Icon

burning down the house2

DATASET 1 OPEN DATA

strutture divise centro storico/zone esterne

DATASET 2 ISTAT STRUTTURE

CONFRONTO OPEN DATA - ISTAT STRUTT.

DATASET 3 ISTAT ARRIVI

CONFRONTO STRUTTURE/ARRIVI (ISTAT) DENSITA DI CARICO

DATASET 4 NORMATIVE (loro effetto)

DATASET 5 PREZZI AFFITTI (idealista)

divisione centro/zone esterne prezzi

correlazione crescite prezzi/num. strutture per centro e est.

DATASET 6 STUDENTI

SISTEMARE visualizzazione leggi

MODELLO DI SENSIBILITA REGIONALE: DELTA iscritti per regione + correlazione con aumento affitti

MD 1

MD 2

MD 3

MD 4

MD5

MD6

mese_iso into date
String to Date&Time
filter out years we dont neeed
Row Filter
read D5 (prezzi affitti)
CSV Reader
rename file path column as zone
Column Name Replacer
sort ascending order
Sorter
file path made string
Path to String
extract zona from path
String Splitter (Regex)
centro storico prezzi
Row Filter
prezzi zone no centro storico
Row Filter
make centro storico into true and all other zones into false
String Manipulation
visualization prezzi crescita
Line Plot (Plotly)
read D6 (studenti unibo negli anni)
CSV Reader
media prezzi zone no centro
GroupBy
join prezzi centro storico e non per mesi
Joiner
media annuale tra i mesi per le due zone
GroupBy
filter ateneo bologna
Row Filter
extract year from months
Date&Time Part Extractor
read D1
CSV Reader
anonymization
Column Filter
dataset clean up
Column Filter
convert years to date
String to Date&Time
filter out facilities closed before 2014
Row Filter
extract ending year from dates
Date&Time Part Extractor
extract starting year from dates
Date&Time Part Extractor
file path made string
Path to String
extract year from path
String Splitter (Regex)
keep only necessary columns (total and year)
Column Filter
filter out all data not about bologna
Row Filter
join istat number of facilities and tourism rate data
Joiner
remove empty first row
Missing Value
calcolo densità di carico (arrivi/strutture)
Math Formula
rename file path column as year
Column Name Replacer
keep useful cols
Column Filter
line plot for number of tourists per year
Line Plot (Plotly)
keep only useful columns
Column Filter
correlation falsa zone esterne prezzi/strutture
Linear Correlation
remove empty row
Missing Value
visualize densità di carico
Line Plot (Plotly)
growth rate prezzi
Math Formula
normalizzazione a base 100 per tot strutture
Math Formula
lag column media prezzi zone est
Lag Column
growth rate strutture
Math Formula
lag column strutture zone est
Lag Column
correaltion, POSITIVE
Linear Correlation
normalizzazione a base 100 per tot arrivi
Math Formula
read D4 (laws)
CSV Reader
filter necessary columns
Column Filter
visualization: grafico a forbice, distanza tra due linee mostra crollo densità di carico
Line Plot (Plotly)
visualization: comparing results from the two datasets
Line Plot (Plotly)
table with years in our range
Table Creator
phases of regulation per year
Rule Engine
tables join
Cross Joiner
assign color to phases
Color Manager
MASHUP DATASET (crescita prezzi/strutture di centro e zone esterne + percentuali crescita)
Joiner
join three datasets
Joiner
sum students from different courses/province
GroupBy
visualization 4 growth rates
Line Plot (Plotly)
make year a number to perform row filter
String to Number
reduce anno accademico to a single ywar
String Manipulation
Scatter Plot (Plotly)
total students per year
GroupBy
filter out years not in our range
Row Filter
group bolzano e trento together
GroupBy
create regione trentino for bolzano e trento
Rule Engine
file path made string
Path to String
extract year from path
String Splitter (Regex)
rename file path column as year
Column Name Replacer
create column for each region
Pivot
keep only necessary columns (total and year)
Column Filter
replace column name for open data total
Column Name Replacer
visualization of all regions
Stacked Area Chart (Plotly)
visualize
Bar Chart
convert regions numbers to %
Math Formula (Multi Column)
join facilities per year tables from the two datasets
Joiner
add total student to table + delete regione estera column
Joiner
lag column for open data total
Lag Column
take only 2014 and 2024 to see difference in iscritti in our range
Row Filter
lag column for istat total
Lag Column
visualization without emilia
Stacked Area Chart (Plotly)
replace column name for istat total
Column Name Replacer
create two cols for the two years
Pivot
correlation between two datasets
Linear Correlation
make columns into rows
Unpivot
difference of percentages among two years
Math Formula
growth rate for open data among years
Math Formula
visualize percentages of change of all regions
Bar Chart
sort from lower
Sorter
new correlation value based on comparison of growth rates
Linear Correlation
visualize again
Bar Chart
visualization of different totals among the two datasets
Line Plot (Plotly)
filter out emilia (no fuorisede)
Row Filter
growth rate for istat among years
Math Formula
media tra prezzi centro e est. per anno
Math Formula
remove first row
Missing Value
make cols into rows
Unpivot
rename regions column
Column Name Replacer
table with students per region per year + price affitti per year
Joiner
read D3 (tourist rate)
CSV Reader
loop over each region
Group Loop Start
rename students column
Column Name Replacer
table with prices and structures per year (centro/est)
Joiner
replace column names
Column Name Replacer
replace
Column Name Replacer
convert to true and false
Rule Engine
correlation for each region with prices
Linear Correlation
centro storico num. strutture
Row Filter
convert missing value to zone esterne
Missing Value
create row for each region correlation
Variable to Table Column
loop for every region
Loop End
keep only correlation column
Column Filter
zone esterne num. strutture
Row Filter
table with region, correlation and delta
Joiner
join to visualize number of facilities per year in/out centro storico
Joiner
filter out iteration col
Column Filter
choose colors for visualization
Color Manager
visualization: regions left bottom have been affected by price growth
Scatter Plot (Plotly)
Line Plot (Plotly)
rename column in centro storico
Column Renamer
rename column in zone esterne
Column Renamer
correlation falsa centro storico prezzi/numero strutture
Linear Correlation
lag column strutture centro
Lag Column
filter facilities per year
Rule-based Row Filter
growth rate strutture
Math Formula
rename correlation column
Column Renamer
lag column media prezzi centro
Lag Column
percentuale growth rate prezzi
Math Formula
put facility id column as first
Column Resorter
visualization
Bar Chart
count facilities per year
GroupBy
correlation, LOW
Linear Correlation
create id for each row
RowID
read D2 on number of facilities per year (read dataseries in folder + add file path column to extract year)
CSV Reader
filter out all data not about bologna
Row Filter
facilities per year inside/outside centro storico
GroupBy

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: nicoldamelio
Created at: 2026-01-31
On NodePit since: 2026-02-02
Last update: 2026-02-02
Created with KNIME version: v5.9.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!