Skip to content
Course Notes: Joining Data with pandas
  • AI Chat
  • Code
  • Report

    • Course Notes

    Use this workspace to take notes, store code snippets, or build your own interactive cheatsheet! The datasets used in this course are available in the datasets folder.

    # Import any packages you want to use here

    Take Notes

    Add notes here about the concepts you've learned and code cells with code you want to keep.

    Add your notes here

    # Add your code snippets here
    Unknown integration
    DataFrameavailable as
    df
    variable
    -- Select the product details and location of hardware priced over 2000 dollars
SELECT PRODUCT_NAME,
        DESCRIPTION,
        LIST_PRICE,
        WAREHOUSE_NAME
FROM PRODUCTS
  INNER JOIN INVENTORIES USING(PRODUCT_ID)
  INNER JOIN WAREHOUSES USING(WAREHOUSE_ID)
WHERE LIST_PRICE > 2000