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
Grouping and Aggregation
4 Topics
GroupBy Basics
8 Sub-topics
Understanding groupby() Concept
Grouping by Single Column
Grouping by Multiple Columns
Aggregation with min() and max()
Multiple Aggregations with agg()
Advanced GroupBy
9 Sub-topics
Custom Aggregation Functions
Grouping with Transformations
Size and Count Differences
Nunique for Unique Counts
Groupby with Multiple Statistics
GroupBy Performance
8 Sub-topics
GroupBy with Multiple Keys
GroupBy with Custom Functions
Nested GroupBy Operations
GroupBy Performance Tuning
GroupBy Result Formatting
Aggregation Patterns
8 Sub-topics
Custom Aggregation Functions
Multiple Aggregations Per Column
Different Aggregations Per Column
Aggregation with Filtering
Aggregation with Transform