Pandas

0%
Coding
Theory
Quiz

    Series Dataframe Creation Dtypes

    • Build DataFrame From Dict

      Junior

    • Cast Column To Dtype

      Junior

    • Build a Series From a Dict

      Junior

    • Set Column As Index

      Junior

    • Rename Columns With a Mapping

      Junior

    • Convert Column To category Dtype

      Mid

    • Ordered Categorical Conversion

      Mid

    • Convert Float Series to Nullable Int64

      Mid

    • Name Index Then Reset It

      Mid

    • Build MultiIndex Frame With from_arrays

      Mid

    • Upgrade to Nullable Dtypes

      Mid

    • Downcast Unsigned Integer Series

      Senior

    • Memory-Optimized DataFrame Copy

      Senior

    • Cartesian Product MultiIndex Frame

      Senior

    Indexing Selection Boolean Filtering

    • Label-Based Selection With .loc

      Junior

    • Boolean Mask Row Filter

      Junior

    • Top-Left Block With .iloc

      Junior

    • Fast Scalar Access With .at

      Junior

    • Filter Rows With isin Membership

      Junior

    • Case-Insensitive Substring Filter

      Mid

    • Multi-Condition Boolean Mask Filter

      Mid

    • Filter With DataFrame.query and @vars

      Mid

    • Filter Rows Within Closed Range

      Mid

    • NOT IN Filter With isin Negation

      Mid

    • Select Columns by Name Regex

      Mid

    • Floor Negatives With Series.where

      Senior

    • Conditional Bonus Without Mutation

      Senior

    • Cross-Section by Index Level

      Senior

    • Cross-Section by Inner Level with IndexSlice

      Senior

    • Top-K Rows by Column

      Senior

    Missing Data Cleaning

    • Count Missing Values Per Column

      Junior

    • Forward Fill a Series

      Junior

    • Remove Duplicate Rows Keeping First

      Junior

    • Drop Rows With Missing Values

      Junior

    • Fill Missing Values With Zero

      Junior

    • Group-Wise Forward Fill

      Mid

    • Dedupe Keeping Last Occurrence

      Mid

    • Coerce Dirty Strings to Numeric

      Mid

    • Per-Column fillna With a Dict

      Mid

    • Drop Sparse Rows by Non-Null Count

      Mid

    • Linear Interpolation of Interior NaNs

      Senior

    • Clean Currency Series With Median Impute

      Senior

    • Dtype-Preserving Nullable Int Imputation

      Senior

    • Winsorize a Numeric Series With clip

      Senior

    • Mask Outliers and Impute Mean

      Senior

    Groupby Aggregation Transform

    • Total Sales by Region

      Junior

    • Mean Score Per Student

      Junior

    • Orders Per Customer With size()

      Junior

    • Distinct Products Per Region

      Junior

    • Sales by Region and Category

      Junior

    • Sales Summary With Named Aggregation

      Mid

    • Distinct Products and Total Sales

      Mid

    • Multiple Stats Per Group

      Mid

    • Group Mean-Center With transform

      Mid

    • Percentage of Region Total

      Mid

    • Dense Rank Within Each Team

      Mid

    • Top N Rows Per Group

      Senior

    • Quantity-Weighted Average Price

      Senior

    • Group Sales by Observed Category

      Senior

    • Row of Max Per Group

      Senior

    • Keep Groups Above Sum Threshold

      Senior

    Merging Joining Concatenation

    • Inner Merge Orders With Customers

      Junior

    • Left Merge Products With Prices

      Junior

    • Merge Sales And Targets On Two Keys

      Junior

    • Stack Two DataFrames By Rows

      Junior

    • Horizontal Concat With pd.concat

      Junior

    • Index-Based Left Join

      Mid

    • Outer Merge With Zero Fill

      Mid

    • Concat With Quarter Keys MultiIndex

      Mid

    • Merge Headcounts With Suffixes

      Mid

    • Patch Missing Values With combine_first

      Mid

    • Left Anti-Join With Indicator

      Senior

    • Pair Employees With Manager Name

      Senior

    • Attach Latest Quote With merge_asof

      Senior

    • Validated Many-to-One Join

      Senior

    • Cross Join Size-Color Catalog

      Senior

    Reshaping Pivoting Crosstab

    • One-Hot Encode a Color Column

      Junior

    • Melt Wide Survey to Long

      Junior

    • One-Hot Encode With drop_first

      Junior

    • Explode List Column Into Rows

      Junior

    • Transpose City-Indexed Table

      Junior

    • Sales Pivot by Region and Month

      Mid

    • Pivot Tidy Data to Wide Form

      Mid

    • Gender by Product Crosstab

      Mid

    • Row-Normalized Crosstab of Gender vs Education

      Mid

    • Unstack Innermost Quarter Level

      Mid

    • Wide to Long With stack

      Mid

    • Explode Skills Then Count

      Senior

    • Pivot Table With Grand Totals

      Senior

    • Reshape Panel Data With wide_to_long

      Senior

    • Pivot on Two Value Columns

      Senior

    Time Series Datetime

    • Parse ISO Dates With to_datetime

      Junior

    • Coerce Invalid Dates to NaT

      Junior

    • Extract Year and Month Columns

      Junior

    • Add Day-of-Week Column

      Junior

    • Sort DataFrame by Date

      Junior

    • Daily Fractional Price Change

      Mid

    • Daily Date Range Reindex

      Mid

    • Monthly Sales Totals via Resample

      Mid

    • Weekly Resample With on= Column

      Mid

    • Time-Based 7-Day Rolling Mean

      Mid

    • Add Lag and Delta Columns

      Mid

    • Upsample and Interpolate Daily

      Senior

    • Convert UTC Timestamps to US/Eastern

      Senior

    • Monthly Sales by Store

      Senior

    • Reindex Onto Business-Day Range

      Senior

    • Intraday Rows With between_time

      Senior

    • Upsample Series to Daily With Forward Fill

      Senior

    String Text Str Categorical

    • Split Full Name Column

      Junior

    • Vectorized Lowercasing With str.lower

      Junior

    • Vectorized String Lengths With str.len

      Junior

    • Zero-Pad ID Strings

      Junior

    • Extract Area Code With str.extract

      Mid

    • Bin Ages With pd.cut

      Mid

    • Extract Date Parts With Named Groups

      Mid

    • Mask Email Local Parts

      Mid

    • Map Status Labels With Series.map

      Mid

    • Category Codes as int8

      Mid

    • Ordered Categorical Priority Sort

      Senior

    • Factorize Labels With Reconstruction

      Senior

    • Extract All Hashtags With extractall

      Senior

    • Quartile Buckets With qcut

      Senior

    Sorting Ranking Window Method Chaining

    • Multi-Column Sort With Mixed Order

      Junior

    • Stable Descending Sort by Score

      Junior

    • Top N Rows by Revenue

      Junior

    • Category Frequencies With value_counts

      Junior

    • Sort DataFrame by Row Index

      Junior

    • Sort Scores With NaNs Last

      Junior

    • Dense Rank Scores Descending

      Mid

    • Ordinal Rank With method='first'

      Mid

    • Percentile Rank of a Series

      Mid

    • Rolling Mean With Full Window

      Mid

    • Rolling Sum With Partial Windows

      Mid

    • Clip Column And Flag Changes

      Mid

    • Running Maximum With cummax

      Mid

    • Enrich and Filter via Method Chaining

      Senior

    • Exponentially-Weighted Moving Average

      Senior

    • Maximum Drawdown From Returns

      Senior