Data Cleaning with pandas

Data Cleaning with pandas

3h 6mIntermediate2026-08-27

Authors

Anaconda, Inc

Anaconda, Inc

Course details

Real-world data arrives messy. Missing values, inconsistent text, and outliers can quietly skew your results. In this hands-on course, discover how to turn that raw data into clean, analysis-ready datasets with pandas. Start with pandas fundamentals, then move into the techniques data professionals rely on to prepare data with confidence. Explore how to work with pandas Series and DataFrames, select rows and columns with iloc and loc, and filter data with Boolean conditions. Learn how to clean and match text using regular expressions, handle missing data by dropping or filling values with statistical techniques, and reason about what outliers mean before you remove them. By the end of this course, you'll be prepared to diagnose data-quality issues and clean a dataset for reliable analysis. This intermediate-level course is an ideal fit for data analysts, data scientists, Python developers, and anyone who works with data.

Learning objectives
Work with pandas series and DataFrames.
Select rows and columns using iloc and loc.
Clean and match text using regular expressions.
Handle missing data by dropping, filling, or imputing values.
Identify and remove outliers appropriately for the application.
Prepare a reliable dataset for downstream analysis.

Concepts

Introduction

  • Getting started with Anaconda Notebooks
  • pandas basics
  • pandas DataFrames
  • Importing data in pandas

Selecting Rows and Columns

  • Selecting rows and columns
  • Dropping rows by condition
  • Updating data - Exercise

Sorting, Mapping, and Categories

  • Sorting, casting, and categories
  • Categories - Exercise

Removing Duplicative and Sparse Data

  • Removing duplicative and sparse data
  • Remove columns with one value
  • Remove columns with low variance - Exercise

Handling Missing Data

  • Handling missing data
  • Removing rows with missing values
  • Fill in missing values with nearest neighbor - Exercise

Outliers

  • Outliers
  • Using local outlier factor (LOF) - Exercise

Dates and Times

  • Dates and times
  • Filtering on datetimes
  • Dates and times - Exercise

Wrangling Text

  • Wrangling text
  • Regular expression (RegEx) basics
  • Partial and full string matches
  • Finding all matches - Exercise

Conclusion

  • Conclusion
80,000 Toman