What is data cleaning?

Raw data is messy and hard to analyze, so we have to “clean” it by filling in missing values, correcting mistakes and improper formatting, fitting it into the right rows and columns, and other methods you’ll learn in this course.

Why do we need to clean data?

Data needs to be prepped and formatted before you can use it. You’ll come across a lot of missing and inaccurate values as you go through raw data, and they can throw off your analyses if left unresolved.

How do you clean data?

Most of the work around cleaning data involves finding and fixing incomplete or missing values. Once that’s handled and the data’s (mostly) accurate, it needs to be shaped and organized into rows and columns.

Who’s responsible for cleaning data?

There’s a saying that Data Scientists spend 80% of their time cleaning and manipulating data and only 20% of their time analyzing it or building models from it, and Machine Learning Engineers spend much of their time building and maintaining pipelines that automatically collect, clean, and organize data into a usable format. Outside of tech, there are a ton of jobs that involve (or can benefit from) working with data, and cleaning data is one of the first steps toward putting it to good use.

What else should I study if I am learning about cleaning data?

Learning a little about statistics can help you sharpen your data skills. There are a couple of popular methods for cleaning data that you’ll explore in your studies, and they’ll take you pretty far — but there are various statistical methods you can use when working with numerical data that all have different effects on your analyses.

Course

How to Clean Data with Python

Learn the basics of regular expressions and how to pull and clean data from the web with Python.

This course includes

20,477 learners enrolled

This course includes

Skill level
Intermediate
Time to complete
Average based on combined completion rates — individual pacing in lessons, projects, and quizzes may vary

3 hours
Projects
1
Prerequisites
1 course

We suggest you complete the following courses before you get started with How to Clean Data with Python:
Learn Python 3

About this course

People say that data scientists spend 80% of their time cleaning data and only 20% of their time doing analysis. Learn some of the most common techniques for getting your data ready to analyze. Along the way, you’ll learn the basics of Regex, a fun and powerful tool to find patterns in strings.

Syllabus

How to Clean Data with Python
Some say data scientists spend 80% of their time cleaning data and 20% of their time doing analysis. Learn how to do this 80% in Python!

lesson Introduction to Regular Expressions
quiz Introduction to Regular Expressions
lesson How to Clean Data with Python
quiz Data Cleaning in Python
project Cleaning US Census Data
Certificate of completion available with Plus or Pro
Earn a certificate of completion and showcase your accomplishment on your resume or LinkedIn.

The platform

Hands-on learning

Animated GIF of an AI provided error explanation within Codecademy's learning environment

An AI-generated hint within the instructions of a Codecademy project

Animated GIF of Codecademy's Job Readiness Checker tool generating a compatibility report for a senior software engineer role

Animated GIF of building a phone screen interview using Codecademy's Interview Simulator

A fill-in-the-blank JavaScript question in a Codecademy assessment

Explore features

Projects in this course

practice Project
Cleaning US Census Data
Use your pandas and regex skills to clean up this dataset containing a bunch of census data collected by the US government.

Earn a certificate of completion

Show your network you've done the work by earning a certificate of completion for each course or path you finish.

Show proofReceive a certificate that demonstrates you've completed a course or path.
Build a collectionThe more courses and paths you complete, the more certificates you collect.
Share with your networkEasily add certificates of completion to your LinkedIn profile to share your accomplishments.