Top Indian CitiesSend FeedbackGiven File 'startup_funding.csv'Problem Statement :Find out which cities are generally chosen for starting a startup.Find top 10 Indian cities which have most number of startups ?Plot a pie chart and visualise it.Print the city name and number of startups in that city also.Note :Take city name "Delhi" as "New Delhi".Check the case-sensitiveness of cities also. That means - at some place, instead of "Bangalore", "bangalore" is given. Take city name as "Bangalore".For few startups multiple locations are given, one Indian and one Foreign. Count those startups in Indian startup also. Indian city name is first.Print the city in descending order with respect to the number of startups.Output Format :city1 number1city2 number2. . .
Question
Top Indian CitiesSend FeedbackGiven File 'startup_funding.csv'Problem Statement :Find out which cities are generally chosen for starting a startup.Find top 10 Indian cities which have most number of startups ?Plot a pie chart and visualise it.Print the city name and number of startups in that city also.Note :Take city name "Delhi" as "New Delhi".Check the case-sensitiveness of cities also. That means - at some place, instead of "Bangalore", "bangalore" is given. Take city name as "Bangalore".For few startups multiple locations are given, one Indian and one Foreign. Count those startups in Indian startup also. Indian city name is first.Print the city in descending order with respect to the number of startups.Output Format :city1 number1city2 number2. . .
Solution
To find the top 10 Indian cities with the most number of startups, we will follow these steps:
- Read the data from the 'startup_funding.csv' file.
- Clean the data by converting all city names to lowercase and replacing "new delhi" with "delhi" and "bangalore" with "bengaluru".
- Count the number of startups in each city, considering both Indian and foreign locations.
- Sort the cities in descending order based on the number of startups.
- Select the top 10 cities.
- Plot a pie chart to visualize the distribution of startups among these cities.
- Print the city names and the corresponding number of startups.
Let's proceed with these steps to find the top 10 Indian cities with the most startups.
Similar Questions
Directions: Identify the correct degree :Very few cities in India are ______ (populous) Mumbai.
Very few cities in India are as rich as Mumbai. (Change into comparative and find the new sentence from the choices given)
Richest States in India are A. Maharashtra, Gujrat and Tamilnadu B. Sikkim, Goa and Manipur C. Uttar Pradesh, Madhya Pradesh and Chattisgarh D. Kerala, Andhra Pradesh and Panjab
A data analyst wants to create a visualization that depicts the populations of the top ten most populous cities in North Carolina. What type of chart would be best for this?
Write a statement that will select the City column from the Customers table.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.