Icon

DV_​Group49_​DataProcessing

Core Dataset 1 (Enforcement) Q1 - Fines by Offence (Donut Chart) Q3 - Age Group vs Offence (Heatmap) Q4 - Fatalities Trend by Year (Line Plot) Q6 - Crash Types by Road User (Stacked Bar Chart) Q2 - Enforcement by State (Bubble Map) Q5 - Fatalities by State (Choropleth Map) Q7 - Fines vs Fatalities by State (Dual-Axis and Scatter Plot) Core Dataset 2 (Outcomes) Australian_Road_Deaths_ Database_Fatalities.csv replace unknow gender to "?" Repalce "-9" Truck Involvement to "?" Replace "99:99:99" time with "00:00:01" ConvertTime Grouping age ProcessedFatalities.csv Remove Unnecessary Column police_enforcement_2024_fines.csv Remove Unnecessary Column Convert "'Average speed camera, Mobile camera, red light camera, fixed camera, fixed or movile camera" to "Auto Detection Camera" Convert "Not applicable and Police issued" to "Manual Detection" ProcessedFines.csv Filter out year before 2020 Filter out year 2020-2024 Added Month inName Resorting Column Rename all ages to Unknown ProcessedFines.csv Keep METRIC, FINES, YEAR, STATE Sum FINES by METRIC, YEAR, STATE Calculate % of total fines Sort by Total_Fines (Desc) Q1_Fines_By_Offence_Detailed ProcessedFatalities.csv ProcessedFines.csv Q4_Fatalities_Trend_By_Year.csv Q6_Crash_Types_By_Road_User.csv Q2_Enforcement_By_State.csv Keep Year, State, & Crash ID Count fatalities by Year & State Rename Count*(Crash ID) to Total_Fatalities Sum states to get Total per year Reshape data (Rows: Year, Cols: State) Sort by Year (Ascending) Sort by Year (Ascending) Keep Crash Type, Road User, & Crash ID Count fatalities by Crash_Type & Road_User Rename Count*(Crash ID) to Total_Fatalities Sum road users to get Total_Fatalities ProcessedFatalities.csv Reshape data (Rows: Crash_Type, Cols: Road_User) ProcessedFatalities.csv Q5_Fatalities_By_State.csv Remove Unknown Keep JURISDICTION. FINES, YEAR, STATE Sum FINES by JURISDICTION, YEAR, STATE Sort by Total_Fines (Desc) Add Latitude based on state Rename Sum(FINES) to Total_Fines Add Longitude based on state Add Color_Hex based on fine amount Sort by Year (Ascending) Keep State & Crash ID Count fatalities by State Rename Count*(Crash ID) to Total_Fatalities Add State_Name column Add Latitude based on state Add Longitude based on state Add Population_M (in Millions) Calculate Fatality_Rate_Per_100k Add Color_Hex based on fine amount Combine Fines & Fatalities tables by state, year Keep only final chart columns Calculate Fines_Per_Fatality ratio Sort by Total_Fines (Desc) Road Fines Percentage by Offence Type Rename METRIC values Road Fatalities Trend by Year (2020-2025) Fatalities by Crash Type and Road User Fines_vs_Fatalities_By_State Rename State Sum Total_Fines by YEAR, STATE Rename to Total_Fines, YearState_Total Join YEAR and STATE Keep METRIC, FINES, Sum FINES by METRIC, Rename to Total_Fines Calculate % of total fines Sort by Total_Fines (Desc) Remove Year_State_Total Q1_Fines_By_Offence_Overall.csv Keep AGE_GROUP, METRIC, FINES Q3_Age_Offence_Heatmap.csv ProcessedFines.csv Remove Unknown Heatmap of Fine Totals: Age Group vs. Offence Population.csv Combine with population by state, year Fatality Rate per 100k Fines per Capita Q7_Fines_vs_Fatalities_By_State.csv ProcessedFines.csv Count fatalities by State Keep State & Crash ID Rename Count*(Crash ID) to Total_Fatalities Keep JURISDICTION. FINES, YEAR, STATE Sum FINES by JURISDICTION, YEAR, STATE ProcessedFatalities.csv Rename Sum(FINES) to Total_Fines CSV Reader Rule Engine Rule Engine Rule Engine String to Date&Time Rule Engine CSV Writer Column Filter CSV Reader Column Filter Rule Engine Rule Engine CSV Writer Row Filter Row Filter Rule Engine Column Resorter Rule Engine CSV Reader Column Filter GroupBy Math Formula Sorter CSV Writer CSV Reader CSV Reader CSV Writer CSV Writer CSV Writer Column Filter GroupBy Column Renamer Math Formula Pivot Sorter Sorter Column Filter GroupBy Column Renamer Math Formula CSV Reader Pivot CSV Reader CSV Writer Row Filter Column Filter GroupBy Sorter Rule Engine Column Renamer Rule Engine Rule Engine Sorter Column Filter GroupBy Column Renamer Rule Engine Rule Engine Rule Engine Rule Engine Math Formula Rule Engine Joiner Column Filter Math Formula Sorter Pie Chart Rule Engine Line Plot Bar Chart Scatter Plot Column Renamer GroupBy Column Renamer Joiner Column Filter GroupBy Column Renamer Math Formula Sorter Column Filter CSV Writer Column Filter CSV Writer CSV Reader Row Filter Heatmap CSV Reader Joiner Math Formula Math Formula CSV Writer CSV Reader GroupBy Column Filter Column Renamer Column Filter GroupBy CSV Reader Column Renamer Core Dataset 1 (Enforcement) Q1 - Fines by Offence (Donut Chart) Q3 - Age Group vs Offence (Heatmap) Q4 - Fatalities Trend by Year (Line Plot) Q6 - Crash Types by Road User (Stacked Bar Chart) Q2 - Enforcement by State (Bubble Map) Q5 - Fatalities by State (Choropleth Map) Q7 - Fines vs Fatalities by State (Dual-Axis and Scatter Plot) Core Dataset 2 (Outcomes) Australian_Road_Deaths_ Database_Fatalities.csv replace unknow gender to "?" Repalce "-9" Truck Involvement to "?" Replace "99:99:99" time with "00:00:01" ConvertTime Grouping age ProcessedFatalities.csv Remove Unnecessary Column police_enforcement_2024_fines.csv Remove Unnecessary Column Convert "'Average speed camera, Mobile camera, red light camera, fixed camera, fixed or movile camera" to "Auto Detection Camera" Convert "Not applicable and Police issued" to "Manual Detection" ProcessedFines.csv Filter out year before 2020 Filter out year 2020-2024 Added Month inName Resorting Column Rename all ages to Unknown ProcessedFines.csv Keep METRIC, FINES, YEAR, STATE Sum FINES by METRIC, YEAR, STATE Calculate % of total fines Sort by Total_Fines (Desc) Q1_Fines_By_Offence_Detailed ProcessedFatalities.csv ProcessedFines.csv Q4_Fatalities_Trend_By_Year.csv Q6_Crash_Types_By_Road_User.csv Q2_Enforcement_By_State.csv Keep Year, State, & Crash ID Count fatalities by Year & State Rename Count*(Crash ID) to Total_Fatalities Sum states to get Total per year Reshape data (Rows: Year, Cols: State) Sort by Year (Ascending) Sort by Year (Ascending) Keep Crash Type, Road User, & Crash ID Count fatalities by Crash_Type & Road_User Rename Count*(Crash ID) to Total_Fatalities Sum road users to get Total_Fatalities ProcessedFatalities.csv Reshape data (Rows: Crash_Type, Cols: Road_User) ProcessedFatalities.csv Q5_Fatalities_By_State.csv Remove Unknown Keep JURISDICTION. FINES, YEAR, STATE Sum FINES by JURISDICTION, YEAR, STATE Sort by Total_Fines (Desc) Add Latitude based on state Rename Sum(FINES) to Total_Fines Add Longitude based on state Add Color_Hex based on fine amount Sort by Year (Ascending) Keep State & Crash ID Count fatalities by State Rename Count*(Crash ID) to Total_Fatalities Add State_Name column Add Latitude based on state Add Longitude based on state Add Population_M (in Millions) Calculate Fatality_Rate_Per_100k Add Color_Hex based on fine amount Combine Fines & Fatalities tables by state, year Keep only final chart columns Calculate Fines_Per_Fatality ratio Sort by Total_Fines (Desc) Road Fines Percentage by Offence Type Rename METRIC values Road Fatalities Trend by Year (2020-2025) Fatalities by Crash Type and Road User Fines_vs_Fatalities_By_State Rename State Sum Total_Fines by YEAR, STATE Rename to Total_Fines, YearState_Total Join YEAR and STATE Keep METRIC, FINES, Sum FINES by METRIC, Rename to Total_Fines Calculate % of total fines Sort by Total_Fines (Desc) Remove Year_State_Total Q1_Fines_By_Offence_Overall.csv Keep AGE_GROUP, METRIC, FINES Q3_Age_Offence_Heatmap.csv ProcessedFines.csv Remove Unknown Heatmap of Fine Totals: Age Group vs. Offence Population.csv Combine with population by state, year Fatality Rate per 100k Fines per Capita Q7_Fines_vs_Fatalities_By_State.csv ProcessedFines.csv Count fatalities by State Keep State & Crash ID Rename Count*(Crash ID) to Total_Fatalities Keep JURISDICTION. FINES, YEAR, STATE Sum FINES by JURISDICTION, YEAR, STATE ProcessedFatalities.csv Rename Sum(FINES) to Total_Fines CSV Reader Rule Engine Rule Engine Rule Engine String to Date&Time Rule Engine CSV Writer Column Filter CSV Reader Column Filter Rule Engine Rule Engine CSV Writer Row Filter Row Filter Rule Engine Column Resorter Rule Engine CSV Reader Column Filter GroupBy Math Formula Sorter CSV Writer CSV Reader CSV Reader CSV Writer CSV Writer CSV Writer Column Filter GroupBy Column Renamer Math Formula Pivot Sorter Sorter Column Filter GroupBy Column Renamer Math Formula CSV Reader Pivot CSV Reader CSV Writer Row Filter Column Filter GroupBy Sorter Rule Engine Column Renamer Rule Engine Rule Engine Sorter Column Filter GroupBy Column Renamer Rule Engine Rule Engine Rule Engine Rule Engine Math Formula Rule Engine Joiner Column Filter Math Formula Sorter Pie Chart Rule Engine Line Plot Bar Chart Scatter Plot Column Renamer GroupBy Column Renamer Joiner Column Filter GroupBy Column Renamer Math Formula Sorter Column Filter CSV Writer Column Filter CSV Writer CSV Reader Row Filter Heatmap CSV Reader Joiner Math Formula Math Formula CSV Writer CSV Reader GroupBy Column Filter Column Renamer Column Filter GroupBy CSV Reader Column Renamer

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: minthukyawkhaung
Created at: 2025-10-31
On NodePit since: 2025-11-01
Last update: 2025-11-20
Created with KNIME version: v5.5.2

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

Try NodePit Runner!