MISSION 137

Data Cleaning Walkthrough: Combining the Data

Learn how to combine multiple data sets to get a single, clean data set.

Objectives

  • Learn to combine multiple datasets.
  • Learn to perform joins in pandas.

Mission Outline

1. Introduction
2. Condensing the Class Size Data Set
3. Condensing the Class Size Data Set
4. Computing Average Class Sizes
5. Computing Average Class Sizes
6. Condensing the Demographics Data Set
7. Condensing the Demographics Data Set
8. Condensing the Graduation Data Set
9. Condensing the Graduation Data Set
10. Converting AP Test Scores
11. Left, Right, Inner, and Outer Joins
12. Performing the Left Joins
13. Performing the Inner Joins
14. Filling in Missing Values
15. Filling in Missing Values
16. Adding a School District Column for Mapping
17. Next Steps
18. Takeaways

data-exploration

Course Info:

Intermediate

The median completion time for this course is 7.5 hours. ​View Details​​​

This course requires a basic subscription. This course includes four missions and two guided projects. It is the seventh course in the Data Analyst in Python path and the Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside