Amit Shirsath - Learning Path # 1: Download, compile and visualize India Census 2011 data

Learning Path # 1: Download, compile and visualize India Census 2011 data

Write python code to download census 2011 data at village level for all districts in India
1. Open this website. http://censusindia.gov.in
2. Go to Directory ---> Population Enumeration Data ---> Primary Census Abstract Data C.D. Block Wise (Excel Format)
3. Download all the files for each state
Understand census data structure and create a database structure in MySQL
1. Create master tables for State, District, Taluka, Village/Ward/Town
2. Create a separate table for data
3. Connect all these tables using primary and foreign keys
4. Create routines for showing a particular data for a state / district / taluka / village / ward / town
5. Create indexes to speed up query execution. Ideally, any query should execute in less than 100 ms
Create a public web page for displaying census data
1. Design a web page using Pencil or other wireframing tools. This should be done simultaneously with Point 2.4 above
2. Create a web server and an HTML page using Django library in Python
3. Use D3.js charts or Google charts to show census data in chart and table format
Create an android mobile app for displaying census data
1. Design screens for the app using Pencil or other wireframing tools. This should be done simultaneously with Point 2.4 above
2. Use the same web server, charts and routines created above to fetch and visualize data

Google Sites

Report abuse