
BW #103: CDC data (solution)
Get better at: Multi-indexes, working with dates and times, pivot tables, plotting, and window functions
Window functions perform aggregate operations across either a growing number of rows or a "sliding window" of rows.
Get better at: Multi-indexes, working with dates and times, pivot tables, plotting, and window functions
Get better at: Multi-indexes, working with dates and times, pivot tables, plotting, and window functions
Get better at: Cleaning data, plotting, dates and times, and window functions
Get better at: Cleaning data, plotting, dates and times, and window functions
Get better at: Working with Excel files, dates and times, grouping, and window functions
Get better at: Working with Excel files, dates and times, grouping, and window functions
Get better at: CSV, filtering, regular expressions, multiple files, index operations, window functions, stack and unstack, multi-indexes, and plotting
Get better at: CSV, filtering, regular expressions, multiple files, index operations, window functions, stack and unstack, multi-indexes, and plotting
Get better at: Excel, DuckDB, grouping, speed optimization, pivot tables, and window functions.
Get better at: Excel, DuckDB, grouping, speed optimization, pivot tables, and window functions.
Get better with: CSV, pivot tables, window functions, the "pipe" method, stack and unstack, grouping, and formatting.
Get better with: CSV, pivot tables, window functions, the "pipe" method, stack and unstack, grouping, and formatting.