pychallenger

Marathon Data

data wrangling
pandas
rename columns
drop duplicates
string operations
type conversion
merge DataFrames
pd.concat
str accessor
pd.to_datetime

Getting the Data Ready

LESSON

Rename a Column

CHALLENGE

Rename Multiple Columns

CHALLENGE

Drop an Unnecessary Column

CHALLENGE

Rename a Registration Column

CHALLENGE

Drop Multiple Columns

CHALLENGE

Rename and Drop Together

CHALLENGE

One Runner, One Row

LESSON

Check for Duplicates

CHALLENGE

Count Duplicate Rows

CHALLENGE

Remove Duplicate Rows

CHALLENGE

Deduplicate by Runner ID

CHALLENGE

The Inconsistency Problem

LESSON

Standardize Category Case

CHALLENGE

Remove Spaces from Categories

CHALLENGE

Standardize the DNF Column

CHALLENGE

Filter by Category Pattern

CHALLENGE

Numbers That Look Like Text

LESSON

Convert Dates

CHALLENGE

Extract the Registration Month

CHALLENGE

Convert a Column Type with astype()

CHALLENGE

Handle Non-Numeric Values

CHALLENGE

Two Files, One Picture

LESSON

Stack Two DataFrames

CHALLENGE

Merge Results with Registrations

CHALLENGE

Keep All Runners

CHALLENGE

Fastest Runner by Experience Level

CHALLENGE