Pandas Pro
Write expert pandas for cleaning, reshaping, and analysis. Handles merges, group-bys, pivots, time series, and vectorization, fixes slow or memory-heavy code, and produces tidy, reproducible DataFrames.
This skill brings senior-level pandas expertise. It cleans messy data, reshapes with melt and pivot, performs complex merges and group-by aggregations, works with time series and rolling windows, vectorizes slow loops, reduces memory with dtypes, and produces tidy, reproducible analysis-ready DataFrames.
pandas python data-analysis dataframes etl
When to use
Use for cleaning and reshaping data in pandas, complex merges and group-bys, time-series analysis, or optimizing slow and memory-heavy pandas code.
Examples
Clean messy data
Tidy a raw DataFrame
Clean this pandas DataFrame: parse dates, fix dtypes, drop duplicates, and fill missing values sensibly
Group-by analysis
Aggregate and pivot
Using pandas, compute monthly cohort retention from an events DataFrame and pivot it into a retention matrix
Speed up slow code
Vectorize a loop
This pandas script uses iterrows and is slow. Vectorize it and reduce memory with appropriate dtypes