Mobile users!
Landscape mode is your friend
Total Amount spent: $20,709.87
Total Amount per Person: $6,903.29
Date Range: November 2020 - March 2025
Explore the Python code used to generate this analysis.
As part of switching between electric companies, June of 2023 charged an unusally high amount after shortchanging the prior month. At this point in the analysis, in just a few short plots, I move some of that money from June to May of 2023 to more accurately reflect what billing should have been.
At the same point, I consolidate "Pepco" and "CleanChoice" into one creatively-named value, "Electric". And I move one cleaning payment from thrice-in-a-month July 2024 to once-in-a-month June 2024. Accounting wizardry.
In the same spirit of data fidelity to truthiness, I manually updated December 2023 through April 2024, to account for the weird stretch where the utility company only billed $19/month and created a giant backlog of debt that had to be paid off.
Some days, you're just on hold with the Electric company.
This is the only time you'll see the Pepco / CleanChoice data. After this, they'll be consolidated into "Electric"
Note how these per person plots look exactly the same as the prior total plots, just with a different y-axis range.
Here's a look at average electric costs, the most variable of the individual expenses.