
BW #67: Electric cars (solution)
Get better with: CSV, pivot tables, window functions, the "pipe" method, stack and unstack, grouping, and formatting.
Window functions perform aggregate operations across either a growing number of rows or a "sliding window" of rows.
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 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: CSV, filtering, window functions, plotting, web scraping, regular expressions, index operations, correlations, joins
Get better at: CSV, filtering, window functions, plotting, web scraping, regular expressions, index operations, correlations, joins
Get better at: CSV files, grouping, stack and unstack, window functions, and plotting
Get better at: CSV files, grouping, stack and unstack, window functions, and plotting
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: Excel, formatting, plotting, window-functions, using "apply", string functionality, grouping, and interpolation
Get better at: Excel, formatting, plotting, window-functions, using "apply", string functionality, grouping, and interpolation