Tool
Pandas
The standard tool for tabular data in Python
Learn pandas for real-world data — Series and DataFrames, reading CSV and JSON, selecting and filtering, cleaning messy data, groupby, merging, pivot tables, correlations, and plotting.
11
Chapters
23
Hours (estimated)
1
Self-paced
Part-time
About 8 weeks
1 hour a day, 3 days a week
Full-time
About 3 weeks
3 hours a day, 3 days a week
Estimated from 11 chapters (notes, practice, labs, quiz, exercise, and challenge) plus the final exam. Go at your own pace.
Curriculum
11 chapters, each with a tutorial, a live example, a quiz, an exercise, a challenge, and class practice.
- 1
Introduction to Pandas
What pandas is, Series and DataFrames at a glance, and getting started.
- 2
Series & DataFrames
Creating Series with labels, building DataFrames, the index, and selecting rows with loc and iloc.
- 3
Reading & Analyzing Data
Reading CSV and JSON, viewing large tables, and the first checks: head, tail, info, and describe.
- 4
Selecting, Filtering & Sorting
Choosing columns, filtering rows with conditions, isin and query, sorting, and adding columns.
- 5
Cleaning Empty Cells
Finding missing values, removing rows with dropna, and filling gaps with fillna, mean, median, and mode.
- 6
Cleaning Wrong Formats, Wrong Data & Duplicates
Converting formats with to_datetime and to_numeric, fixing impossible values, and removing duplicates.
- 7
GroupBy
Split-apply-combine: grouping rows, aggregating with sum, mean, count, and agg, and grouping by several columns.
- 8
Merging & Joining
Combining DataFrames with concat, merge on keys, join types, and checking results.
- 9
Pivot Tables & Reshaping
pivot_table, crosstab, and reshaping between wide and long formats with melt and pivot.
- 10
Correlations
Measuring relationships between columns with corr(), reading correlation values, and their limits.
- 11
Plotting
Line, bar, scatter, histogram, and box plots straight from pandas, and choosing the right chart.
Pandas is free to study, self-paced. Pass the final exam to earn an optional Certificate of Completion for $40.