I'm trying to create a panel of Indian villages from the census data from the years 2011 to 2001 containing data on population and village amenities. Creating a panel across these years is not as straight-forward as merging the datasets by name for various reasons: the village names may be spelled differently across the years; the village may be split into two distinct villages where one of the new villages retains its parent village's name; two or more villages may be merged into one village.

Linking the data for the two census years by village code addresses some of these problems. However, the codes are not the same across the two census years. There are concordance tables provided in the Village and Town directory of the District Census Handbook published for each district. For example, Pg 99 of the pdf document,


Does anyone know of a concordance table that is published in xls, csv, or some other data format for India as a whole?

Or is there any way to convert the required information in all the pdf documents into another data format quickly?

closed as off-topic by ahmadhanb, Jochen Schwarze, ThingumaBob, Andre Silva, whyzar Oct 25 '18 at 13:50

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions relating to general IT or with no clear GIS component, are off-topic here but can be researched/asked at Stack Overflow (software development), Super User (computing hardware and software), Database Administrators (relational databases) and other SE sites" – ahmadhanb, Jochen Schwarze, ThingumaBob, Andre Silva, whyzar
If this question can be reworded to fit the rules in the help center, please edit the question.

  • Is there any specific region that you are interested in? Or do you need this for the entire country? – Devdatta Tengshe Oct 25 '18 at 6:16
  • If this is open data then I think the Open Data Stack Exchange is a better place to research/ask questions like this. – PolyGeo Oct 25 '18 at 6:33
  • It is not difficult to move data from the pdf to spreadsheet. Use an text editor such as Notepad++ in between. Copy and paste there, and use regular expressions to format data until you get a readable format. – Andre Silva Oct 25 '18 at 13:30

This data was available on the eGovernence site; but it seems to be down right now. Someone had scraped this data, and made it available at: https://drive.google.com/file/d/0B4-jbJK7OOmrckpCSkZWbnZOUFZydEFfdlM5eWd1dkR2Q29v/view

This has been shared on the Datameet mailing list

  • Nice one, I am doing a lot with Indian Census data at the moment, although I'm not comparing 2011 with 2001 this is a really useful link to a set of look up tables that really should be easily accessible. – Hornbydd Oct 25 '18 at 9:13

Not the answer you're looking for? Browse other questions tagged or ask your own question.