JKISeason4-1_​tark

0 ×

Objective 1 (Easy): Clean data by removing addresses without real city names and extract country out of their addresses.
Objective 2 (Easy): Count the total number of EV charging stations by city and find the top ten cities.
Objective 3 (Easy): Of the top ten cities, find out which cities have the cheapest average cost to charge per kwH and show the five cheapest cities.
Objective 4 (Medium): Create a bar chart that allows you to compare the top ten cities in terms of average cost to charge per kwH. Create a widget that lets you select the cities you want to see in this plot and control the plotting with flow variables.

Author: Thor Landstrom

Dataset: EV data in the KNIME Community Hub

URL: www.knime.com/just-knime-it https://www.knime.com/just-knime-it
URL: forum.knime.com/t/solutions-to-just-knime-it-challenge-1-season-4/87971 https://forum.knime.com/t/solutions-to-just-knime-it-challenge-1-season-4/87971

Nodes

• Reference Row Filter4 ×
• Column Filter2 ×
• Generic ECharts View2 ×
• GroupBy2 ×
• CSV Reader1 ×
• Column Rename (Regex)1 ×
• Component Input1 ×
• Component Output1 ×
• Math Formula (Multi Column)1 ×
• Multiple Selection Widget1 ×
• Normalizer1 ×
• Row Splitter1 ×
• Sorter1 ×
• Regex Split1 ×
• Table Row to Variable1 ×
• Table View1 ×
• Text View1 ×
• Top k Row Filter1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Quick Forms
• FeatureKNIME Views

Links

• No links available