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

Course Info:

Data Cleaning Project Walkthrough

Intermediate

The average completion time for this course is 10-hours.

This course requires a basic subscription. This course includes one free mission and five paid missions, which includes 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

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit