MISSION 293

Data Cleaning Basics

Learn how to clean messy data using pandas.

Objectives

  • Learn about different encodings.
  • Learn how to extract and convert numeric values from string values.
  • Learn how to work with missing values.

Mission Outline

1. Reading CSV Files with Encodings
2. Cleaning Column Names
3. Cleaning Column Names Continued
4. Converting String Columns to Numeric
5. Removing Non-Digit Characters
6. Converting Columns to Numeric Dtypes
7. Renaming Columns
8. Extracting Values from Strings
9. Correcting Bad Values
10. Dropping Missing Values
11. Filling Missing Values
12. Challenge: Clean a String Column
13. Next Steps
14. Takeaways

pandas-fundamentals

Course Info:

Intermediate

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

This course requires a basic subscription and includes five missions and one guided project.  It is the third course in the Data Analyst in Python path and Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside