excel

BW #89: Housing (solution)

Get better at: Excel files, joins, string manipulation, dates and times, multi-indexes, and plotting.

Oct 24, 2024 13 min read paid

BW #89: Housing

Get better at: Excel files, joins, string manipulation, dates and times, multi-indexes, and plotting.

Oct 23, 2024 2 min read paid

BW #88: Hot summers (solution)

Get better at: Excel files, multi-indexes, renaming columns, grouping, and plotting.

Oct 17, 2024 11 min read paid

BW #88: Hot summers

Get better at: Excel files, multi-indexes, renaming columns, grouping, and plotting.

Oct 16, 2024 2 min read paid

BW #83: Gasoline prices (solution)

Get better at: Working with Excel, dates and times, plotting, and using Great Tables

Sep 12, 2024 15 min read paid

BW #83: Gasoline prices

Get better at: Working with Excel, dates and times, plotting, and using Great Tables

Sep 12, 2024 3 min read paid

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