Back to Practice
Pandas

NumPy & Pandas Data Wrangling Sheet

Array and dataframe practice for vectorization, reshaping, missing values, joins, grouped summaries, and rolling features.

NumPy Arrays, Masks & Broadcasting

20 problems
#0008
Standardize a Numeric Columnnumpypreprocessingmeanstandard-deviation
Easy10 XP#0036
Select Positive Valuesnumpyboolean-indexingarrays
Easy10 XP#0037
Normalize Each Rownumpybroadcastingmatrix
Medium15 XP#0038
Pairwise Distances To a Query Pointnumpybroadcastingknndistance
Medium15 XP#0058
Min-Max Scale an Arraynumpyscalingpreprocessing
Easy15 XP#0075
Add Column Offsets With Broadcastingnumpybroadcasting
Easy15 XP#0076
Mask Values Above a Thresholdnumpymaskingfiltering
Easy10 XP#0098
Column Means Ignoring NaNnumpynanaggregation
Easy10 XP#0099
Scale Rows With Multipliersnumpybroadcasting
Medium20 XP#0116
Take Selected Columnsnumpyindexing
Easy10 XP#0117
Binary Confusion Matrix With NumPynumpymetricsboolean-masks
Medium20 XP#0134
Replace NaN With Column Meannumpynanimputation
Medium20 XP#0135
Argmax Per Rownumpyaxisargmax
Easy10 XP#0152
Clamp Values to a Rangenumpyvectorizationmasking
Easy10 XP#0153
Batch Dot Productsnumpylinear algebra
Medium20 XP#0170
Filter Rows With a Boolean Masknumpymasking
Easy10 XP#0183
One-Hot Encode Integer Labelsnumpyencoding
Medium20 XP#0184
Cosine Similarity Between Vectorsnumpyvectorssimilarity
Medium20 XP#0199
Standardize Columnsnumpyfeature scaling
Medium20 XP#0200
Pairwise L1 Distancenumpybroadcastingdistance
Medium20 XP

NumPy Scaling, Distances & Linear Algebra

10 problems
#0008
Standardize a Numeric Columnnumpypreprocessingmeanstandard-deviation
Easy10 XP#0038
Pairwise Distances To a Query Pointnumpybroadcastingknndistance
Medium15 XP#0058
Min-Max Scale an Arraynumpyscalingpreprocessing
Easy15 XP#0098
Column Means Ignoring NaNnumpynanaggregation
Easy10 XP#0117
Binary Confusion Matrix With NumPynumpymetricsboolean-masks
Medium20 XP#0134
Replace NaN With Column Meannumpynanimputation
Medium20 XP#0153
Batch Dot Productsnumpylinear algebra
Medium20 XP#0183
One-Hot Encode Integer Labelsnumpyencoding
Medium20 XP#0184
Cosine Similarity Between Vectorsnumpyvectorssimilarity
Medium20 XP#0200
Pairwise L1 Distancenumpybroadcastingdistance
Medium20 XP

Pandas GroupBy, Joins & Cleaning

20 problems
#0009
Find Revenue By Categorypandasgroupbyaggregation
Easy10 XP#0039
Filter Active High-Value Userspandasfilteringboolean-mask
Easy10 XP#0040
Fill Missing Values By Group Medianpandasmissing-valuesgroupbytransform
Medium15 XP#0041
Left Join Orders With Customerspandasmergejoins
Easy10 XP#0060
Keep Latest Event Per Userpandasdeduplicationsorting
Medium20 XP#0081
Pivot Sales by Region and Productpandaspivotaggregation
Medium20 XP#0082
Melt Wide Score Columnspandasmeltreshape
Medium20 XP#0100
Revenue Share Within Grouppandasgroupbytransform
Medium20 XP#0101
Inner Join Users and Eventspandasjoins
Easy10 XP#0118
Rolling Average by Userpandasrollingtime-series
Medium20 XP#0119
Flag Duplicate Rows by Keypandasduplicatesdata-quality
Easy10 XP#0136
Top N Rows Per Grouppandasgroupbyranking
Medium20 XP#0137
Wide Monthly Sales to Longpandasmeltreshape
Medium20 XP#0154
Cumulative Sales by Customerpandasgroupbycumsum
Medium20 XP#0155
Keep Latest Record per Entitypandasdeduplicationsorting
Medium20 XP#0171
Percent of Group Totalpandasgroupbytransform
Medium20 XP#0185
Left Anti Join in Pandaspandasjoins
Medium20 XP#0186
Rolling Average Salespandastime seriesrolling
Medium20 XP#0201
Top Product per Categorypandasgroupbyranking
Medium20 XP#0202
Fill Missing Values by Group Medianpandasmissing valuestransform
Medium20 XP

Pandas Reshape, Ranking & Time Windows

10 problems
#0060
Keep Latest Event Per Userpandasdeduplicationsorting
Medium20 XP#0081
Pivot Sales by Region and Productpandaspivotaggregation
Medium20 XP#0082
Melt Wide Score Columnspandasmeltreshape
Medium20 XP#0118
Rolling Average by Userpandasrollingtime-series
Medium20 XP#0136
Top N Rows Per Grouppandasgroupbyranking
Medium20 XP#0137
Wide Monthly Sales to Longpandasmeltreshape
Medium20 XP#0154
Cumulative Sales by Customerpandasgroupbycumsum
Medium20 XP#0155
Keep Latest Record per Entitypandasdeduplicationsorting
Medium20 XP#0186
Rolling Average Salespandastime seriesrolling
Medium20 XP#0201
Top Product per Categorypandasgroupbyranking
Medium20 XP