In this course, you’ll learn how to prepare and clean data for your data analysis workflow. Datasets are often a disorganized mess, and you’ll hardly ever receive data that’s in exactly the state you want, which is why data cleaning is such a critical skill for data professionals. By the end, you’ll be able to transform messy data into ready-to-analyze data.
Enroll for Free
4.8 (359 reviews)
“I love that Dataquest explains, here’s why we do this, and here’s how we take this next step. That helped a lot and not every platform does that. The guided paths ensured I never started something I wasn’t prepared for and I didn’t waste time trying to figure out what was next.”
This course is for intermediate Python users, and it builds upon the essentials covered in our previous Python lessons. You’ll learn how to leverage Python to supercharge your data analysis workflow. You’ll learn how to manipulate, combine, transform, and merge data; manipulate strings; and work with missing values in Python — as well as new concepts and techniques to improve the speed and efficiency of your Python code.
Best of all, you’ll learn by doing — you’ll practice and get feedback directly in the browser. You’ll apply your skills to several guided projects involving realistic business scenarios to build your portfolio and prepare for your next interview.
Aggregating, combining, transforming, and cleaning data
Manipulating strings and working with regular expressions in Python
Combining, transforming, and reshaping datasets
Resolving missing data and duplicate data
Loading lessons...
Dataquest has helped thousands of people start new careers in data. If you put in the work and follow our course, you'll master data skills and grow your career.
We believe so strongly in our courses that we offer a full satisfaction guarantee. If you complete a career course on Dataquest and aren't satisfied with your outcome, we'll give you a refund.
Learn exactly what you need to achieve your goal. Don’t waste time on unrelated lessons.
Build confidence with our in-depth projects, and show off your data skills.
Work with real data from day one with interactive lessons and hands-on exercises.
Impress employers by completing a capstone project and certifying it with an expert review.
Learners who recommend
Dataquest for career advancement
Dataquest rating on
G2Crowd and SwitchUp
Average salary boost
for learners who complete a path
