Filtering and Selection
4 Topics
Boolean Filtering
5 Sub-topics
Boolean Filtering with Single Condition
Boolean Filtering with Multiple Conditions
Using AND, OR, NOT Operators
Using isin() for Multiple Values
Using between() for Range Filtering
String-Based Filtering
3 Sub-topics
String Filtering with contains()
Filtering with str.startswith() and str.endswith()
Filtering with Regular Expressions
Query Method
3 Sub-topics
Query with Multiple Conditions
Dynamic Filter Construction
Advanced Filtering
6 Sub-topics
Filtering Null and Non-Null Values
Combining Complex Conditions
Multi-condition Boolean Filtering
Filtering with Lambda Functions
Filter Performance Optimization
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