Pandas Advanced Merging and Joining: Exercises with Solutions and Explanation

[An editor is available at the bottom of the page to write and execute the scripts. Go to the editor]

Pandas Advanced Merging and Joining [20 exercises with solution]

1. Write a Pandas program to merge two DataFrames on a single column.
Click me to see the sample solution

2. Write a Pandas program to perform an outer join on two DataFrames.
Click me to see the sample solution

3. Write a Pandas program that performs a left join of two DataFrames.
Click me to see the sample solution

4. Write a Pandas program that performs a right join of two DataFrames.
Click me to see the sample solution

5. Write a Pandas program to merge two DataFrames on multiple columns.
Click me to see the sample solution

6. Write a Pandas program that merges DataFrames with overlapping column names.
Click me to see the sample solution

7. Write a Pandas program to merge two DataFrames on their indexes.
Click me to see the sample solution

8. Write a Pandas program to merge different column names in DataFrames.
Click me to see the sample solution

9. Write a Pandas program to merge DataFrames with duplicate Keys.
Click me to see the sample solution

10. Write a Pandas program to merge multiple DataFrames on a common column.
Click me to see the sample solution

11. Write a Pandas program to merge DataFrames using join() on Index.
Click me to see the sample solution

12. Write a Pandas program to merge with custom indicator to track source.
Click me to see the sample solution

13. Write a Pandas program to merge two DataFrames using multiple keys and specific join conditions.
Click me to see the sample solution

14. Write a Pandas program to merge DataFrames using suffixes for overlapping columns.
Click me to see the sample solution

15. Write a Pandas program to merge DataFrames with custom sorting.
Click me to see the sample solution

16. Write a Pandas program to merge DataFrames and drop duplicates.
Click me to see the sample solution

17. Write a Pandas program to merge DataFrames with missing data.
Click me to see the sample solution

18. Write a Pandas program to merge DataFrames and rename columns after merge.
Click me to see the sample solution

19. Write a Pandas program to merge DataFrames on multiple columns with different names.
Click me to see the sample solution

20. Write a Pandas program that merges DataFrames and select specific columns after merge.
Click me to see the sample solution

Python-Pandas Code Editor:

More to Come !

Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page.

Test your Python skills with w3resource's quiz