Hi Mantha There isn't a readily-available crosswalk, but there might just be a workaround. I can give you some resources but you would have to be *extremely* careful while matching stuff across these data sets because district, AC, and PIN code *boundaries are very fluid* and keep changing. You will have to keep a track of whether your matching makes any sense.
You can use the file named "AC_predelim_District_intersect.csv" (which is an AC-District crosswalk) from this folder: https://www.dropbox.com/sh/rt0tldkybbdccmb/AAChviOyKfqZo3zPpe84xGyHa?dl=0 Please read the paper that is included in the folder to get context on why the data is constructed the way it is. And then you can use the following District-PIN code crosswalks as well: https://www.dropbox.com/sh/fmodu1b1iwjdw5n/AADSbbXnRP0lxkqi-CpJEZ59a?dl=0 You can perhaps merge both types of crosswalks by *district name* (you will have to either do approximate string matching, or do it manually for precision; again, district names usually have different spellings in different data sets, so you have to be quite careful; also, district A in year one might split into district A and district B in year 2) and you should have what you need. However, once again, be EXTREMELY careful of whether what you are doing makes sense. This is because district X in year 1 may contain AC Y inside it, but in year 2 district X may or may not contain AC Y within its boundary. So please be really aware of boundary dynamics while merging these crosswalks. It is not going to be an easy task, may require you to look at some other resources as well (like district census numbers and boundaries by year, AC numbers and boundaries by year, etc), and may require several iterations as well before you have the correct crosswalk. Thanks and regards. Yours sincerely *Shiv Hastawala* (He/His/Him) Doctoral Student Department of Economics Binghamton University (State University of New York) Zoom ID: 201 717 2613 www.shivhastawala.com On Sat, Dec 2, 2023 at 11:09 AM Mantha Chandrasekhar <chaman...@gmail.com> wrote: > Hi Jatin Rajani, > Did you find any data sets that matches assembly constituencies with pin > codes? > > > On Monday, May 18, 2020 at 6:31:12 PM UTC+5:30 jatin rajani wrote: > >> Hi Jeff, >> Were you able to find the pin code matching with assembly constituencies? >> >> >> On Friday, 14 February 2014 22:39:02 UTC+5:30, Jeff Weaver wrote: >>> >>> Hi all, >>> >>> Just came across this group, and excited to read about all the cool data >>> tasks that people are working on. I’m currently trying to link a dataset of >>> school data (DISE) to the MP/MLA constituencies (and eventually maybe >>> panchayats) in which they are located. Each school has its district, block, >>> village and PIN code listed. I was really hoping to connect it to assembly >>> constituencies using the PIN code data, and avoid doing any name-matching. >>> My plan was to use the GPS coordinates of PIN codes and then link them >>> using the GIS maps of constituencies. >>> >>> However, I haven’t been able to find a large enough dataset on the GPS >>> coordinates of the pincodes. Does anyone know of a good public (or private) >>> source of this or have another suggestion for how to do this? I have the >>> dataset that someone in the group made using Open Street Maps, and it’s >>> great, but it doesn’t cover a lot of the pin codes (especially the rural >>> ones). Or are there companies that are willing to sell it for a reasonable >>> price? >>> >>> Thanks! >>> >> -- > Datameet is a community of Data Science enthusiasts in India. Know more > about us by visiting http://datameet.org > --- > You received this message because you are subscribed to the Google Groups > "datameet" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to datameet+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/datameet/5b0fa49a-0c00-4694-87fd-c11f99f57f41n%40googlegroups.com > <https://groups.google.com/d/msgid/datameet/5b0fa49a-0c00-4694-87fd-c11f99f57f41n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org --- You received this message because you are subscribed to the Google Groups "datameet" group. To unsubscribe from this group and stop receiving emails from it, send an email to datameet+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAGiG-AzSnwPkvB5esYNLJojLKYGzo432Bss6suvRMLEeCEvRSw%40mail.gmail.com.
