pivot_table: Default mean, aggfunc and margins
Lessons in this course
- First Look: Sum, Mean & value_counts on a Real Orders TableFree
- Boolean Masks: Filtering Rows with &, | and ~ Locked
- groupby Basics: size, sum and mean per Region Locked
- size vs count: Groups with Missing Values Locked
- Named Aggregation: min, max and nunique in One Report Locked
- Two Keys and unstack: From MultiIndex to Cross-Table Locked
- transform: Group Totals and Shares on Every Row Locked
- Filtering Whole Groups: groupby().filter() as HAVING Locked
- Ranking Inside Groups: rank, cumcount and Top-N Locked
- merge on a Key: What an Inner Join Keeps and Drops Locked
- Left Joins, indicator=True and the Duplicate-Key Trap Locked
- concat and drop_duplicates: Combining Overlapping Exports Locked
- pivot_table: Default mean, aggfunc and margins Locked
- melt: From Wide Spreadsheets to Tidy Long Data Locked
- Missing Values: isna, fillna and dropna Without Fooling Yourself Locked
- Gaps in a Series: ffill, bfill and interpolate Locked
- Dates with the .dt Accessor: Weekdays, Weekends and Names Locked
- resample: Weekly Totals, Counts and Means from Raw Orders Locked
- Rolling Windows: Moving Averages and min_periods Locked
- shift, diff and pct_change: Month-over-Month Growth Locked
- Plotting with pandas: Line for Time, Bars for Categories Locked
- Final Project: Merge, Filter, Group and Rank a Margin Report Locked