On Jul 17, 2014 3:43 PM, "Saurabh Datar" <[email protected]> wrote: > > Hi, > > Is it a mistake on my part? Because I used the shapefiles and converted it using shpescape. Also, is it necessary to have all data points to merge? E.g. does my sheet need all 544 constituencies, even though relevant data is only for a smaller number?
Not necessarily. But you had to tell the join operation to keep the records without matches as well. > > > On 17 July 2014 19:11, Sajjad Anwar <[email protected]> wrote: >> >> Hello Saurabh, >> >> The data you sent does have issues - some of the geometry columns are >> empty. Plus, there are 544 constituencies in the shapefile but the >> criminal dataset has only 184 data points, and the MP assets dataset >> has only 443. >> >> I've did the spatial join as you require and uploaded them here - >> http://sajjad.in/datameet/ >> Let me know if it looks okay. >> >> HTH. >> >> Cheers, >> Sajjad. >> >> -- >> 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 a topic in the Google Groups "datameet" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/topic/datameet/srloeXEP5kc/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. > > > > > -- > Best regards, > Saurabh Datar > > -- > 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
