Clean & Preprocess Data
Handle missing values, fix data types, remove outliers, and prepare the dataset for feature engineering.
2
Clean & Preprocess Data
python • Step 2
Handle missing values, fix data types, remove outliers, and prepare the dataset for feature engineering.
pandasdata_cleaningpreprocessingimputation
Learning Objectives
- →Handle missing values with appropriate strategies
- →Convert data types (dates, categoricals)
- →Detect and handle outliers
- →Encode categorical variables
Dataset
View on Kaggle Matches Kaggle
Transit departure / arrival delays with weather & event context (synthetic).
*bleep* Load the dataset in the browser terminal:
from pyodide.http import open_url
import pandas as pd
df = pd.read_csv(open_url("/datasets/public_transport_delays.csv"))
print(df.shape)
print(df.columns.tolist()) Running locally? The file inside the Kaggle download is already named public_transport_delays.csv — drop it into the notebook's working directory and the code above runs unchanged (swap open_url(...) for "public_transport_delays.csv").
Dataset Columns
trip_iddatetransport_typeroute_idactual_departure_delay_minweather_conditiontemperature_Cevent_typepeak_hourdelayed- Write your solution in the Try It Yourself editor below — matplotlib/seaborn figures and pandas tables render inline.
- Stuck? Expand a section and click ↑ Send to editor to stack its snippet into the editor, notebook-style.
- Hit ▶ Run (or ⌘↵) — once your output matches the expected result, the step is marked solved.
- Use ↺ Reset to restore the starter code at any time.
Try It Yourself
Python
Loading editor...
*bleep* Output will appear here after running your code. Figures from matplotlib/seaborn render inline.
Expected output:
Remaining nulls: 0 Clean shape:
0/3
Export to GitHub
Cross-verse learning
Bleepx skills build on each other. Continue your learning path across Query, Lab, and Cloud.