Icon

SCB_​Power_​Production

We need to have three different variables across four different weather stations (at least).

Below are the variables: air temperature (sampled once per day), air pressure (sampled once per hour), and precipitation amount (once per day).

I have made sure that each has four weather stations (1 in north, 1 in south, 1 in west, 1 in east).

If we are happy with this selection, we need to aggregate air pressure to once per day as well. Also, we need to make sure that there is a time period that overlaps on all of these samples which is at least 12 months long.

Data from 1966 - 1995

Data from 1983 - 1995

Data from 1881 - 1995

Data from 1935 - 1972

Data from 1939 - 1972

Data from 1904 - 1973

Data from 1950 - 2025

Data from 1939 - 2025

Data from 1949 - 1997

Data from 1966 - 2025

Data from 1967 - 2025

Data from 2013 - 2025

Data from 2017-01-01

Data from from 2017-01-01


Ignore the part above, this was us mainly testing around and not fully understanding the goal of the assignment. Below will be the actual workflow for the assignment.

Using 4 different weather stations: Stockholm, Göteborg, Jönköping, Malmö

Using 3 different variables: Wind speed (maps nicely to wind power), Sunlight time (maps nicely to solar power), air temperature (maybe correlation to renewable thermal power) and precipitation (maybe correlation to water power)

All raw data collected is hourly.

Data from 2013 - 2025

Data from 2012 - 2025

Data from 1972 - 2025-04

Data from 1995 - 2025

Data from from 2017-01-01

Wind Speed / Wind Power

positive correlation

Air Temperature / Thermal Power

Clearly negatively related

Sunlight Time / Solar Power

(some missing data in the beginning)

maybe not the best quality data but looks related

Precipitation / Water Power

unrelated

Clustering of Wind Speed / Wind Power with 3 clusters, complete linkage

Clustering of Sunlight Time / Solar Power with 5 clusters, average linkage

Clustering of Air Temperature/ Thermal Power (renewable) with 4 clusters, complete linkage

Clustering of Precipitation / Water Power with 3 clusters, complete linkage

CSV Reader
get air temperature from Göteborg (west of sweden)
Column Renamer
String to Date&Time
String to Date&Time
Column Filter
String to Date&Time
Row Filter
mean temperature/month
Date&Time Aggregator (Labs)
Row Filter
Row Filter
Joiner
max air pressure/month
Date&Time Aggregator (Labs)
Joiner
Joiner
String to Date&Time
variance precipitation/month
Date&Time Aggregator (Labs)
original request
POST Request
get wind speed from Malmö-Sturup Flygplats
CSV Reader
String Manipulation
get sunlight time from Stockholm
CSV Reader
StructureJSONoutput
JSON Path
Exclude unstructuredoutput
Column Filter
Split Datain Rows
Ungroup
Make Typereadable
String Manipulation
API call to scb-energy-production
POST Request
CSV Reader
get Precipitation amount from Riksgränsen (north of sweden)
Column Renamer
get air pressure from Riksgränsen (north of sweden)
Column Renamer
Column Filter
get air temperature from Stockholm-Bromma Flygplats (east of sweden)
Column Renamer
Column Filter
Column Filter
mean wind speed/month
Date&Time Aggregator (Labs)
CSV Reader
sum sunlight time/month
Date&Time Aggregator (Labs)
sum precipitation/month
Date&Time Aggregator (Labs)
mean air temperature/month
Date&Time Aggregator (Labs)
CSV Reader
Joiner
get air pressure from Stockholm-Bromma Flygplats (east of sweden)
Column Renamer
Joiner
Make Typereadable
String Manipulation
Joiner
API call to scb-energy-production
POST Request
Column Filter
Column Filter
CSV Reader
CSV Reader
get Precipitation amount from Stockholm-Bromma Flygplats (east of sweden)
Column Renamer
CSV Reader
String to Date&Time
get Precipitation amount from Nordkoster A (west of sweden)
Column Renamer
StructureJSONoutput
JSON Path
get air pressure from Väderöarna A (west of sweden)
Column Renamer
Fix Date format
String Manipulation
Column Filter
Exclude unstructuredoutput
Column Filter
2017-01-01 - 2025-01-01
Row Filter
Split Datain Rows
Ungroup
Column Filter
Date&Time Part Extractor
Pivot
Scatter Plot
Joiner
Line Plot
Number to String
CSV Reader
Normalizer
Fix Date Format
String to Date&Time
String Manipulation
get air temperature from sandhammaren (south of sweden)
Column Renamer
Line Plot
Column Filter
Column Filter
Scatter Plot
Line Plot
Scatter Plot
get air pressure from sandhammaren (south of sweden)
Column Renamer
Column Filter
Scatter Plot
CSV Reader
Line Plot
Column Filter
Color Manager
CSV Reader
CSV Reader
Hierarchical Cluster Assigner (local)
get Precipitation amount from sandhammaren (south of sweden)
Column Renamer
Scatter Plot
CSV Reader
Hierarchical Clustering (DistMatrix)
Distance Matrix Calculate
get air temperature from Riksgränsen (north of sweden)
Column Renamer
Distance Matrix Calculate
Column Filter
Number to String
Column Renamer
Column Filter
get precipitation from Växjö
CSV Reader
get air temperature from Göteborg
CSV Reader
Row Filter
Hierarchical Clustering (DistMatrix)
Column Filter
String to Date&Time
Hierarchical Cluster Assigner (local)
2017-01-01 - 2025-01-01
Row Filter
cut rows with missing datafor solar power
Row Filter
Scatter Plot
Number to String
Column Renamer
Number to String
String to Date&Time
Color Manager
Distance Matrix Calculate
Hierarchical Clustering (DistMatrix)
Hierarchical Cluster Assigner (local)
String to Date&Time
Column Filter
String to Date&Time
2017-01-01 - 2025-01-01
Row Filter
Column Renamer
Column Filter
Color Manager
String to Date&Time
Scatter Plot
2017-01-01 - 2025-01-01
Row Filter
Hierarchical Clustering (DistMatrix)
Column Renamer
Number to String
Hierarchical Cluster Assigner (local)
Distance Matrix Calculate
2017-01-01 - 2025-01-01
Row Filter
Color Manager
Scatter Plot

Nodes

Extensions

Links