excel

BW #82: Broadband (solution)

Get better at: Working with Excel files, dates and times, grouping, and window functions

Sep 6, 2024 9 min read paid

BW #82: Broadband

Get better at: Working with Excel files, dates and times, grouping, and window functions

Sep 5, 2024 3 min read paid

BW #74: UK elections (solution)

Get better at: Excel files, multiple files, pivot tables, plotting, and missing data.

Jul 11, 2024 9 min read paid

BW #74: UK elections

Get better at: Excel files, multiple files, pivot tables, plotting, and missing data.

Jul 10, 2024 3 min read paid

BW #69: Election participation (solution)

Get better at: Excel, DuckDB, grouping, speed optimization, pivot tables, and window functions.

Jun 18, 2024 18 min read paid

BW #69: Election participation

Get better at: Excel, DuckDB, grouping, speed optimization, pivot tables, and window functions.

Jun 18, 2024 3 min read paid

BW #64: Coal power (solution)

Get better at: Excel, memory optimization, PyArrow, grouping, regular expressions, strings, plotting, and pivot tables

May 2, 2024 15 min read paid

BW #64: Coal power

Get better at: Excel, memory optimization, PyArrow, grouping, regular expressions, strings, plotting, and pivot tables

May 2, 2024 3 min read paid

BW #63: Ukraine aid (solution)

Get better at: Excel, cleaning, string manipulation, grouping, regular expressions, pivot tables, dates and times, plotting, and window functions.

Apr 25, 2024 14 min read paid

BW #63: Ukraine aid

Get better at: Excel, cleaning, string manipulation, grouping, regular expressions, pivot tables, dates and times, plotting, and window functions.

Apr 24, 2024 3 min read paid

BW #62: Economic report card (solution)

Get better at: Excel, missing values, multi-index, regular expressions, web scraping, string operations, plotting, and grouping

Apr 18, 2024 16 min read paid

BW #62: Economic report card