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