Challenge 1 - Best Places to live with an EV

Challenge 1: Best places to live with an EV

Level: Medium
Description: You have an EV but you 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 10 cities that have the most EV chargers. You also want to consider which of those 10 cities offer, on average, the cheapest KwH rates in cost. You should be narrowing down your city of choice to 5 after taking into account the costs.

• Objective 1 (Easy): Clean data by removing addresses without real city names and extract country out of address.

• Objective 2 (Easy): Count the total number of EV charging stations by city and find top 10 cities.

• Objective 3 (Easy): Of the top 10 cities, find out which cities have the cheapest average cost to charge per kwH and show the 5 cheapest cities.

• Objective 4 (Medium): Create a bar chart that allows you to compare the top 10 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.