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?