About this Dataset

Top 500 Indian Cities

Context

I created this data set merging the census 2011 of Indian Cities with Population more than 1 Lac and City wise number of Graduates from the Census 2011, to create a visualization of where the future cities of India stands today, I will try to add more columns [ fertility rate, religion distribution, health standards, number of schools, Mortality rate ] in the future, hope people will contribute.

Content

Data of 500 Cities with population more than 1 Lac by Census 2011

'name_of_city'					: Name of the City 
'state_code' 					: State Code of the City
'state_name' 					: State Name of the City
'dist_code'						: District Code where the city belongs ( 99 means multiple district ) 
'population_total' 				: Total Population
'population_male' 				: Male Population 
'population_female' 			: Female Population
'0-6_population_total' 			: 0-6 Age Total Population
'0-6_population_male' 			: 0-6 Age Male Population
'0-6_population_female' 		: 0-6 Age Female Population
'literates_total' 				: Total Literates
'literates_male' 				: Male Literates
'literates_female' 				: Female Literates 
'sex_ratio' 					: Sex Ratio 
'child_sex_ratio' 				: Sex ratio in 0-6
'effective_literacy_rate_total' : Literacy rate over Age 7 
'effective_literacy_rate_male' 	: Male Literacy rate over Age 7 
'effective_literacy_rate_female': Female Literacy rate over Age 7 
'location' 						: Lat,Lng
'total_graduates' 				: Total Number of Graduates
'male_graduates' 				: Male Graduates 
'female_graduates' 				: Female Graduates

Acknowledgements

Census 2011

http://censusindia.gov.in/2011-prov-results/paper2/data_files/India2/Table_2_PR_Cities_1Lakh_and_Above.xls

Google Geocoder for Location Fetching.
Graduation Data Census 2011

http://www.censusindia.gov.in/2011census/C-series/DDWCT-0000C-08.xlsx

Inspiration

What story do the top 500 cities of India tell to the world?
I wrote a post in my blog about the dataset .

Tables

Cities R2

@kaggle.zed9941_top_500_indian_cities.cities_r2

76.25 KB
493 rows
22 columns


CREATE TABLE cities_r2 (
  "name_of_city" VARCHAR,
  "state_code" BIGINT,
  "state_name" VARCHAR,
  "dist_code" BIGINT,
  "population_total" BIGINT,
  "population_male" BIGINT,
  "population_female" BIGINT,
  "n_0_6_population_total" BIGINT,
  "n_0_6_population_male" BIGINT,
  "n_0_6_population_female" BIGINT,
  "literates_total" BIGINT,
  "literates_male" BIGINT,
  "literates_female" BIGINT,
  "sex_ratio" BIGINT,
  "child_sex_ratio" BIGINT,
  "effective_literacy_rate_total" DOUBLE,
  "effective_literacy_rate_male" DOUBLE,
  "effective_literacy_rate_female" DOUBLE,
  "location" VARCHAR,
  "total_graduates" BIGINT,
  "male_graduates" BIGINT,
  "female_graduates" BIGINT
);