A Tale of Two Cities: Urban Transport in India
There was a very interesting event organised by Urban Transport Ministry. Aim was to create a visualization which gives an insight into transport situation in 15 Indian cities – Ahmedabad, Bangalore, Bhopal, Chennai, Delhi, Hubli-Dharwad, Hyderabad, Jaipur, Kolkata, Mumbai, Pune, Surat, Lucknow,Nagpur, Kanpur.
General rules seem to govern the way Indian cities grow. But few cities beat the odds and do things better. And few do worse than what the system predicts. We have focused on these outliers, while calling out the trends that are obviously observed
All data from the excel sheet provided only. With a simple data set provided in 30 odd variables of excel sheet for 15 cities in India Data_Visualization_Challenge_UMI_2014_10_28
Calculation and Formulae:
We have used linear fitting methods to come to all conclusions. We have used scatter plots to assess relationships between the various contextual parameters for each of the 15 cities. We use Population as a key metric to position each city.
We have only drawn inferences from the presented correlations and hence causation should not be assumed.