All Images

Introduction

Handling diverse filetypes in Pandas

Figure 1

Snapshot of the Excel file showing the first 6 rows contain metadata, blank spaces and column names.
The first few rows of the eia923_2022.xlsx file

Accessing remote data

Figure 1

Screenshot of documentation, with relevant text reproduced below
Screenshot of documentation, with relevant text reproduced below

Scraping Data

Figure 1

Screenshot of the EIA 923 data page. A listing of each year's files is in the right sidebar.
Screenshot of the EIA 923 data page. A listing of each year’s files is in the right sidebar.

Visual Data Exploration

Figure 1

Screenshot from the page for Form EIA-923. The text 'at the power plant and prime mover level' is highlighted. The full text reads, 'The survey Form EIA-923 collects detailed electric power data — monthly and annually — on electricity generation, fuel consumption, fossil fuel stocks, and receipts at the power plant and prime mover level. Specific survey information provided...'
Screenshot from the page for Form EIA-923

Making assumptions about your data

Modularization

Escape from Jupyter!

Making sure your system is behaving