Skip to content
LearnPY
pandas

pandas

Load real data into DataFrames, select and reshape it, clean missing values, group rows, and join datasets without losing track of what changed.

What you'll practice

  • DataFrames
  • Selection
  • Grouping
  • Joins
  • Cleaning

Lessons

7 lessons, in order

  1. 01pandas DataFrames: labeled tables that computeBuild a DataFrame, add calculated columns, inspect its shape and dtypes, and load the same structure from CSV text.
  2. 02Selecting rows and columns with confidenceUse brackets, loc, iloc, boolean masks, and query to pull out exactly the rows and columns you mean.
  3. 03Group rows and summarizeSplit a table into groups, aggregate each one, and use transform when the group total needs to travel back to every row.
  4. 04Join related tables without losing rowsMerge DataFrames on a shared key, choose how unmatched rows survive, validate the relationship, and stack tables with concat.
  5. 05Clean messy data deliberatelyInspect missing values, remove duplicates, normalize text, and convert columns to the types your analysis actually needs.
  6. 06Work with dates and time seriesParse date strings, use a DatetimeIndex, resample calendar periods, and compute rolling windows without losing the time order.
  7. 07Reshape wide and long tablesMove values between rows and columns with pivot and melt, and use pivot_table when the same cell appears more than once.