Icon

Access, preprocess and monitor electricity consumption data

There has been no title set for this workflow's metadata.

This workflow demonstrates how to perform common spreadsheet user's tasks in KNIME, such as
- Data blending,
- Data cleaning,
- Data aggregation, and
- Data visualization.

Read
  • One Excel sheet

  • Data from an API

Clean
  • Remove redundant timestamps

  • Translate the column names

Create new features
  • Extract date and time fields into separate columns

  • Aggregate hourly timestamps to dates

  • Create a column with the last week's values

Calculate new metrics
  • Daily total values

  • Average hourly values on different weekdays

Visualize
  • Line plot

  • Lag plot

  • Seasonal plot

This workflow accesses, preprocesses and visualizes hourly Electricity Consumption in Finland

Data source: Fingrid / data.fingrid.fi, license CC 4.0 BY

See Fingrid's webpage for the API access

Electricity Consumption Dashboard
Read data for October2023
Excel Reader
Read data for November2023
Data Access via API
Concatenate
Data Preprocessing
Data Cleaning

Nodes

Extensions

Links