Problem sheet

Series: Labelled Columns

series · index · alignment

Build and Describe a DataFrame

dataframe · dtypes · inspection

Reading and Writing CSV

read-csv · io · dtypes

Select and Filter Rows

filtering · loc · isin

Derived Columns

feature-engineering · assign · missing-values

Finding and Handling Missing Values

missing-values · isna · dropna

Sort and Rank

sorting · ranking · ties

Group-by Aggregation

groupby · aggregation · split-apply-combine

Fill Missing Values by Group

missing-values · imputation · transform

Merging Tables

merge · join · relational-data

Cleaning Text Columns

strings · regex · data-cleaning

Working with Dates

datetime · to-datetime · dt-accessor

Weekly Resampling

time-series · resample · datetime

Pivot Tables

pivot · melt · reshaping

Binning with pd.cut

binning · categorical · pd.cut

Rolling-Window Features

rolling · lag-features · leakage

Exploratory Analysis of a Public Dataset

Project idea · exploratory-data-analysis · cleaning · reporting

Personal Finance Dashboard Data

Project idea · time-series · pivot-tables · cleaning