Learn Practice Projects Free datasets Resources Toolkit Pricing

Log in Start free

Loading…

Hands-on analytics engineering training with browser-based practice, guided projects, and a human-reviewed capstone.

support@analyticsengineering.com

Learn

The course
Roadmap
Practice
Projects
Free datasets
Resources
Templates
Open-source toolkit
Jobs
Job market data
Guides
Glossary
Compare tools
Starting-point quiz

Topics

Analytics Engineering
SQL
dbt
Data Modeling
BigQuery
Snowflake
Looker
Python
Career
Interview Prep

Company

About
1-on-1 coaching
Pricing
Log in
Start free

© 2026 Analytics Engineering · All rights reserved

Terms Privacy Built by Routeless

Loading this exercise…

10. Merge two DataFrames · Python: Pandas DataFrames

Home / Practice / Python: Pandas DataFrames

10. Merge two DataFrames

#10 · 10 of 50

Python: Pandas DataFrames

50 exercises

011. Create DataFrame from dict Free
022. Print first 5 rows Free
033. Summary statistics Free
044. Select a specific column Locked
055. Filter rows by condition Locked
066. Add a new column Locked
077. Group by a column and compute mean Locked
088. Sort by a specific column Locked
099. Drop rows with missing values Locked
1010. Merge two DataFrames Locked
1111. Rename a column Locked
1212. Drop a column Locked
1313. Fill missing values Locked
1414. Replace values Locked
1515. Drop duplicatesLocked
1616. Map values Locked
1717. Apply function to a column Locked
1818. Concatenate two DataFrames Locked
1919. Melt (unpivot) a DataFrame Locked
2020. Create a pivot table Locked
2121. Set a MultiIndex Locked
2222. Unstack a MultiIndex Locked
2323. Insert a row by loc Locked
2424. Mask and replace values in a column Locked
2525. Value counts of a column Locked
2626. Read from CSV (StringIO) Locked
2727. Write to CSV (StringIO) Locked
2828. Reindex a DataFrame Locked
2929. Set and reset index Locked
3030. Sort by multiple columns Locked
3131. Merge with a left join Locked
3232. Outer join merge Locked
3333. Aggregate multiple columns Locked
3434. Map with a dictionary Locked
3535. Count unique values in a column Locked
3636. Assign a new column with .assign() Locked
3737. Detect and count duplicates Locked
3838. Query usage Locked
3939. Pivot from long to wide Locked
4040. Pivot from wide to long Locked
4141. Slice rows with loc Locked
4242. Slice by position with iloc Locked
4343. Group by multiple columns Locked
4444. Merge on multiple keys Locked
4545. Sort groupby results Locked
4646. Rolling mean Locked
4747. Shift column Locked
4848. Insert column at a specific position Locked
4949. Create DataFrame from list of dicts Locked
5050. Combine multiple aggregations with groupby Locked

Paid plan required

Unlock the full library.

This exercise is part of the full library. The Practice Pass unlocks hints, explanations, instant answer reveal, and all 1,604 graded exercises — one payment, lifetime access. (The full course adds the capstone and GPT tutor.)

See all plans →Log in

All exercises in Python: Pandas DataFrames50

Python: Pandas DataFrames

50 exercises

011. Create DataFrame from dict Free
022. Print first 5 rows Free
033. Summary statistics Free
044. Select a specific column Locked
055. Filter rows by condition Locked
066. Add a new column Locked
077. Group by a column and compute mean Locked
088. Sort by a specific column Locked
099. Drop rows with missing values Locked
1010. Merge two DataFrames Locked
1111. Rename a column Locked
1212. Drop a column Locked
1313. Fill missing values Locked
1414. Replace values Locked
1515. Drop duplicatesLocked
1616. Map values Locked
1717. Apply function to a column Locked
1818. Concatenate two DataFrames Locked
1919. Melt (unpivot) a DataFrame Locked
2020. Create a pivot table Locked
2121. Set a MultiIndex Locked
2222. Unstack a MultiIndex Locked
2323. Insert a row by loc Locked
2424. Mask and replace values in a column Locked
2525. Value counts of a column Locked
2626. Read from CSV (StringIO) Locked
2727. Write to CSV (StringIO) Locked
2828. Reindex a DataFrame Locked
2929. Set and reset index Locked
3030. Sort by multiple columns Locked
3131. Merge with a left join Locked
3232. Outer join merge Locked
3333. Aggregate multiple columns Locked
3434. Map with a dictionary Locked
3535. Count unique values in a column Locked
3636. Assign a new column with .assign() Locked
3737. Detect and count duplicates Locked
3838. Query usage Locked
3939. Pivot from long to wide Locked
4040. Pivot from wide to long Locked
4141. Slice rows with loc Locked
4242. Slice by position with iloc Locked
4343. Group by multiple columns Locked
4444. Merge on multiple keys Locked
4545. Sort groupby results Locked
4646. Rolling mean Locked
4747. Shift column Locked
4848. Insert column at a specific position Locked
4949. Create DataFrame from list of dicts Locked
5050. Combine multiple aggregations with groupby Locked