Re: [datameet] Re: Mapping MPs with criminal cases
Hi, Thanks a ton for helping me out :) But Fusion table is still doing the same. Only keeping constituencies that have values. I think it is something to do with shpescape. On 17 July 2014 19:46, Sajjad Anwar m...@sajjad.in wrote: On Jul 17, 2014 3:43 PM, Saurabh Datar brocksaur...@gmail.com 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 m...@sajjad.in 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 datameet+unsubscr...@googlegroups.com. 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 datameet+unsubscr...@googlegroups.com. 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 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 datameet+unsubscr...@googlegroups.com. 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 datameet+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [datameet] Re: Mapping MPs with criminal cases
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 the Google Groups datameet group. To unsubscribe from this group and stop receiving emails from it, send an email to datameet+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [datameet] Re: Mapping MPs with criminal cases
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? On 17 July 2014 19:11, Sajjad Anwar m...@sajjad.in 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 datameet+unsubscr...@googlegroups.com. 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 datameet+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [datameet] Re: Mapping MPs with criminal cases
On Jul 17, 2014 3:43 PM, Saurabh Datar brocksaur...@gmail.com 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 m...@sajjad.in 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 datameet+unsubscr...@googlegroups.com. 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 datameet+unsubscr...@googlegroups.com. 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 datameet+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.