Hi all, I didn't manage to do it on Fusioon Tables, but I did it with Tableau (which is a little slow at times). I started a small datablog of my own. I'd love if you could check it out, give feedback.
I'd really like to learn and make this better. Thank you. Here's the link: asliceofdata.blogspot.in/2014/07/mps-in-lok-sabha-with-criminal-cases.html On 21 July 2014 12:31, Saurabh Datar <[email protected]> wrote: > 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 <[email protected]> wrote: > >> >> 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 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 > -- 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.
