Fig. Darker the color, more the number of bank branches in that state
Fig. Bigger the dot, more the number of bank branches in that city
Check out: Link for interactive Tableau visualizations for above images
So here is how it was done:
Data on number of bank branches in Indian cities was taken from
http://dbie.rbi.org.in/DBIE/dbie.rbi?site=statistics
(On above page, select Financial Sector->Banking - Branch Statistics, then go to Quarterly tab and then to table (c) District-Wise Number of Functioning Offices of Commercial Banks. The data was saved as excel sheet)
Only latest bank branch data of March 2013 was used. After some cleaning, the data looked something like this.
For the visualization, this branch data was transposed on a map of India using Tableau Public. Tableau has built-in support for Indian cities, however, in the data from RBI, cities names didn't match with what Tableau thought they should be (actually Tableau didn't recognize 400+ cities from RBI data). So a quick and dirty python script here fetched the latitude and longitude for cities in the RBI data using Google Geocoding API into a csv file like this. Tableau can use raw latitude and longitude data for places to map them. The final file used with Tableau Public for generating the visualization by combining RBI data along with lat/long fetched using Geocoding API is here.
No comments:
Post a Comment