Icon

JKI Challenge 01 - Best Places to live with EV


URL: JKI 1-4 on the KNIME forum https://forum.knime.com/t/solutions-to-just-knime-it-challenge-1-season-4/87971
URL: Subscribe to my KNIME focused YouTube channel (free) https://www.youtube.com/@bytesandbudgets?sub_confirmation=1

Desscription


You have an EV and want to live in a place that has many available charging stations, and where it is also cheap to charge your vehicle. Given a dataset on chargers around the world, you need to find out the top ten cities that have the most EV chargers. You also want to consider which of those ten cities offer, on average, the cheapest KwH rates in cost. You should be narrowing down your city of choice to five after taking into account the costs.

  • 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.

Objective 1 - clean data


Objective 2 - Top 10 cities by numer of stations


Objective 3 - Top 5 cheapest cities


Objective 4 - Interactive bar chart


import EV city data
CSV Reader
remove rows with"Country" placeholder
Row Filter
split address into street and city
Cell Splitter
rename columnsto "Street" and"City"
Column Renamer
keep only top 5cheapest Cities by avgcost / KWh
Top k Row Filter
keep only top 10 Cities by numberof stations
Top k Row Filter
group count of stationsand avg coust byCity
GroupBy
Select cities and display avg cost

Nodes

Extensions

Links