Analytics Engineering
Start free
← All topics

Python: Merging And Joining Datasets

40 exercises3 free
  1. 01Inner Join On Common Key
    Free→
  2. 02Left Join And Print Shape
    Free→
  3. 03Right Join Example
    Free→
  4. 04Outer Join On Customer_id
    Locked→
  5. 05Concatenate Two DataFrames Vertically
    Locked→
  6. 06Concatenate Two DataFrames Horizontally
    Locked→
  7. 07Combine Different Columns With Outer Concat
    Locked→
  8. 08Join By Index Example
    Locked→
  9. 09Merge Multiple DataFrames
    Locked→
  10. 10Identify & Remove Duplicate Keys
    Locked→
  11. 11Merge Df_orders And Df_order_items On Order_id
    Locked→
  12. 12Merge Df_order_items & Df_products, Rename Column
    Locked→
  13. 13Left Join & Print Shape
    Locked→
  14. 14Outer Join & Column Selection
    Locked→
  15. 15Index-Based Join Then Merge
    Locked→
  16. 16Concatenate Df_products With Itself
    Locked→
  17. 17Semi-Join Equivalent
    Locked→
  18. 18Anti-Join Equivalent
    Locked→
  19. 19Merge & Count Distinct Product_ids
    Locked→
  20. 20Checking Distinct Customers After Merge
    Locked→
  21. 21Cross Merge (Cartesian Product) Example
    Locked→
  22. 22Merge Then Sort By Two Columns
    Locked→
  23. 23Concat With Different Indexes
    Locked→
  24. 24Merge And Filter Rows (Quantity>5)
    Locked→
  25. 25Multi-Step Merge Then Unique Rows
    Locked→
  26. 26Merge Then Group By Customer_id Summing Quantity
    Locked→
  27. 27Pivot After Merge (Product Counts Per Order)
    Locked→
  28. 28Merge And Filter By A Date Condition
    Locked→
  29. 29Merge Then Group By Product_id Summing Quantity
    Locked→
  30. 30Merge Then Pivot (Wide Format By Product_id)
    Locked→
  31. 31Many-To-Many Merge With Indicator
    Locked→
  32. 32Compare Left Vs Right Join Row Counts
    Locked→
  33. 33Chain Merge Df_orders->Df_order_items->Df_products->Df_customers
    Locked→
  34. 34Merge Then Evaluate Summaries
    Locked→
  35. 35Index-Based Concat Aligned By Index
    Locked→
  36. 36Merge Then Group & Pivot
    Locked→
  37. 37Outer Merge With Specific Columns Only
    Locked→
  38. 38Concat All DataFrames With Axis=0 (Hypothetical)
    Locked→
  39. 39Merge Then Pivot Table On City
    Locked→
  40. 40Right Merge To Show Only Existing Orders
    Locked→