BW #81: School (solution)
Get better at: Grouping, pivot tables, sorting, plotting, and filtering
14 min read
paid
pivot-table
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.
Page 3 of 6
BW #81: School
Get better at: Grouping, pivot tables, sorting, plotting, and fitlering
2 min read
paid
BW #79: Cyber attacks (solution)
Get better at: Dates and times, grouping, pivot tables, plotting, and string methods.
12 min read
paid
BW #79: Cyber attacks
Get better at: Dates and times, grouping, pivot tables, plotting, and string methods.
2 min read
paid
BW #76: Aging legislators (solution)
Get better at: YAML, multiple-files, JSON, dates and times, and pivot tables
12 min read
paid
BW #76: Aging legislators
Get better at: YAML, multiple-files, JSON, dates and times, and pivot tables
2 min read
paid
BW #74: UK elections (solution)
Get better at: Excel files, multiple files, pivot tables, plotting, and missing data.
9 min read
paid
BW #74: UK elections
Get better at: Excel files, multiple files, pivot tables, plotting, and missing data.
3 min read
paid
BW #69: Election participation (solution)
Get better at: Excel, DuckDB, grouping, speed optimization, pivot tables, and window functions.
18 min read
paid
BW #69: Election participation
Get better at: Excel, DuckDB, grouping, speed optimization, pivot tables, and window functions.
3 min read
paid
BW #67: Electric cars (solution)
Get better with: CSV, pivot tables, window functions, the "pipe" method, stack and unstack, grouping, and formatting.
10 min read
paid
BW #67: Electric cars
Get better with: CSV, pivot tables, window functions, the "pipe" method, stack and unstack, grouping, and formatting.
3 min read
paid