Icon

01 - Best EV Place

<p><strong>JKISeason4-1</strong></p>

my Solution of Challenge 1:


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.

Extra - get detailed information from OSM Website

CSV Reader
Cell Splitter
Adress
String Cleaner
Value Counter
Clusteringbased onHaversine Distance
Python Script
Keep Lat/Lon
Column Filter
top 10 cities
Top k Row Filter
Sorter
Plotting
Plotting
Column Renamer
Top k Row Filter
Joiner
Joiner
remove duplicates
Duplicate Row Filter
Median Locationand Countper Cluster
GroupBy
dropgeneric fake entries
Row Filter
GET request on OSM
Get correct City Information
Select top 25
Top k Row Filter
nice naming
Column Renamer
Joiner
RowID
Sorter

Nodes

Extensions

Links