Electricity Household

Contents

Electricity Household#

Goal

Visualize household electricity consumption patterns over time using a line chart. This provides an overview of how electricity usage varies across the measurement period.

Data Basis

The dataset eboBookEleMeter.csv contains cumulative electricity meter readings at 15-minute intervals (columns: timestamp, eleMeterVal; separator ;). The meter counts Wh (it rises by about 1,000,000 in 2015, i.e. about 1,000 kWh per year). We compute consumption by differencing the cumulative values and convert it to kWh.

Data Preparation#

import pandas as pd

url = "https://raw.githubusercontent.com/retomarek/edap/main/edap/sampleData/eboBookEleMeter.csv"
raw = pd.read_csv(url, sep=";")

# Parse timestamp and set as index
raw["timestamp"] = pd.to_datetime(raw["timestamp"])
raw = raw.set_index("timestamp")

# Consumption per 15 minutes from the cumulative meter readings, Wh -> kWh
consumption = raw.diff() / 1000

# Hourly sums for a cleaner chart (complete hours only: all 4 quarter-hours present)
hourly = consumption.resample("h").sum(min_count=4).dropna()

hourly.head()

	eleMeterVal
timestamp
2015-01-01 00:00:00	0.0345
2015-01-01 01:00:00	0.0375
2015-01-01 02:00:00	0.0330
2015-01-01 03:00:00	0.0375
2015-01-01 04:00:00	0.0340

Visualization#

from pyedautils.plots import plot_timeseries

fig = plot_timeseries(
    hourly,
    columns=["eleMeterVal"],
    title="Household Electricity Consumption",
    ylab="Electricity [kWh/h]",
)
fig.show()