Data Transformation Basics
5 Topics
Sorting and Ranking
8 Sub-topics
Sorting by Multiple Columns
Sorting in Ascending and Descending Order
Sorting with Missing Values
Ranking Methods - average, min, max, first, dense
Ranking with Ascending and Descending Order
String Operations
11 Sub-topics
Accessing String Methods with str
Converting Case - lower(), upper(), title()
Finding and Replacing with Regex
Extracting with Regex Patterns
Advanced String Operations
8 Sub-topics
Extracting with Named Groups
Multiple Pattern Matching
Handling Special Characters
String Vectorization Performance
Type Conversion
8 Sub-topics
Converting to Numeric with to_numeric()
Handling Errors in Conversion
Downcasting for Memory Optimization
Converting Multiple Columns at Once
Data Type Optimization
8 Sub-topics
Understanding Memory Layout
Integer Type Optimization
String vs Category Decision
Creating Memory-Efficient Pipelines
Applying Functions
3 Topics
Apply Basics
8 Sub-topics
Using apply() on DataFrame Columns
Using apply() on DataFrame Rows
Lambda Functions with apply()
Applying Functions with Arguments
Using applymap() for Element-wise Application
Vectorized Operations vs apply()
Map and Transform
4 Sub-topics
Using map() for Series Transformation
Using replace() with Dictionaries
Using transform() in Groupby
Using pipe() for Method Chaining
Conditional Operations
4 Sub-topics
Conditional Application with where()
Conditional Application with mask()
Using np.where() with Pandas
Creating Calculated Columns