A pivot table redisplays information from a data frame in a new way: It uses the unique values from one column as its index, the unique values from a second column for its columns, and then applies an aggregation function to all of the values in each row-column intersection.
Get better at: Excel files, multiple files, pivot tables, plotting, and missing data.
Get better at: Excel files, multiple files, pivot tables, plotting, and missing data.
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.
Get better with: CSV files, dates and times, plotting, pivot tables, and the "where" method
Get better with: CSV files, dates and times, plotting, pivot tables, and the "where" method
Get better at: Excel, memory optimization, PyArrow, grouping, regular expressions, strings, plotting, and pivot tables
Get better at: Excel, memory optimization, PyArrow, grouping, regular expressions, strings, plotting, and pivot tables
Get better at: Excel, cleaning, string manipulation, grouping, regular expressions, pivot tables, dates and times, plotting, and window functions.
Get better at: Excel, cleaning, string manipulation, grouping, regular expressions, pivot tables, dates and times, plotting, and window functions.
