
BW #113: US airport traffic (solution)
Get better at: Excel files, multiple files, pivot tables, grouping, dates and times, and plotting
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, grouping, dates and times, and plotting
Get better at: Excel files, multiple files, pivot tables, grouping, dates and times, and plotting
Get better at: Excel files, dates and times, plotting, and creating pivot tables
Get better at: Excel files, dates and times, plotting, and creating pivot tables
Get better at: CSV files, dates and times, correlations, plotting, and pivot tables
Get better at: CSV files, dates and times, correlations, plotting, and pivot tables
Get better at: String manipulation, working with dates, plotting, grouping, and pivot tables
Get better at: String manipulation, working with dates, plotting, grouping, and pivot tables
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: Grouping, pivot tables, plotting, and joining
Get better at: Grouping, pivot tables, plotting, and joining