
BW #66: Pittsburgh (solution)
Get better with: CSV files, dates and times, plotting, pivot tables, and the "where" method
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 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.
Get better at: Web scraping, regular expressions, joins, CSV, plotting, and pivot tables
Get better at: Web scraping, regular expressions, joins, CSV, plotting, and pivot tables
Get better at: CSV, PyArrow, regular expressions, filtering, plotting, window functions, cutting, and pivot tables
Get better at: CSV, PyArrow, regular expressions, filtering, plotting, window functions, cutting, and pivot tables
Get better at: CSV, PyArrow, grouping, stack-unstack, and pivot tables.
Get better at: CSV, PyArrow, grouping, stack-unstack, and pivot tables.