Bamboo Weekly #64: Coal power
Get better at: Excel, memory optimization, PyArrow, grouping, regular expressions, strings, plotting, and pivot tables
3 min read
excel
Reading from and writing to Excel spreadsheets with Pandas, including working with multiple sheets, formatting, and large workbooks.
Page 6 of 9
Bamboo Weekly #63: Ukraine aid (solutions)
Get better at: Excel, cleaning, string manipulation, grouping, regular expressions, pivot tables, dates and times, plotting, and window functions.
14 min read
Bamboo Weekly #63: Ukraine aid
Get better at: Excel, cleaning, string manipulation, grouping, regular expressions, pivot tables, dates and times, plotting, and window functions.
3 min read
Bamboo Weekly #62: Economic report card (solutions)
Get better at: Excel, missing values, multi-index, regular expressions, web scraping, string operations, plotting, and grouping
16 min read
Bamboo Weekly #62: Economic report card
Get better at: Excel, missing values, multi-index, regular expressions, web scraping, string operations, plotting, and grouping
2 min read
Bamboo Weekly #54: Household debt (solutions)
Get better at: Excel, formatting, plotting, window-functions, using "apply", string functionality, grouping, and interpolation
16 min read
Bamboo Weekly #54: Household debt
Get better at: Excel, formatting, plotting, window-functions, using "apply", string functionality, grouping, and interpolation
4 min read
Bamboo Weekly #45: Netflix (solutions)
Get better at: Excel, dates and times, missing data, grouping, formatting, using "apply", plotting, and regular expressions
17 min read
Bamboo Weekly #45: Netflix
Get better at: Excel, dates and times, missing data, grouping, formatting, using "apply", plotting, and regular expressions
3 min read
Bamboo Weekly #41: Wine production (solutions)
Get better at: Excel files, regular expressions, filtering, grouping, plotting, pivot tables, cleaning
15 min read
Bamboo Weekly #41: Wine production
Get better at: Excel files, regular expressions, filtering, grouping, plotting, pivot tables, and cleaning
3 min read
Bamboo Weekly #38: Telework (solutions)
Get better at: Excel files, Polars, regular-expressions, and filtering.
14 min read