Hi Shantanu, Thanks! I'll save these snippets in my folder
Might we have similar solutions for efficiently listing and individually/bulk editing a database table's entries on a webpage? (similar to how one manages an email inbox) -- Cheers, Nikhil +91-966-583-1250 Pune, India Self-designed learner at Swaraj University <http://www.swarajuniversity.org> http://nikhilsheth.blogspot.in On Sat, May 14, 2016 at 4:24 PM, shantanu oak <[email protected]> wrote: > > Hi Nikhil, > > Here is 5 lines of python code that will help to visualize the routes on > google maps like this.. > > http://www.darrinward.com/lat-long/?id=1958126 > > As per your disclaimer this is not .NET code nor hi-fi server required. > Anyone can visualize lat-lon data Using the 2 tables mentioned in phase 1 and > 2. > > # Downloaded routes and stops from the sheets > !wget https://s3.amazonaws.com/oksoft/routes.csv > !wget https://s3.amazonaws.com/oksoft/stops.csv > > # imported the csv data into python pandas dataFrame > import pandas as pd > routes = pd.read_csv('routes.csv',usecols=["Route Num", "StopNo", "StopEN", > "StopCode"]) > stops = pd.read_csv('stops.csv',usecols=["stop_id", "stop_name", > "stop_desc","stop_lat", "stop_lon"]) > > # Merge these 2 frames on stop code - id this is one to many relation > # one stop_id from stops table can be in many routes > df=pd.merge(routes, stops, left_on='StopCode', right_on='stop_id') > > # Find co-ordinates of all stops of a given route for e.g. 1000XD and export > the data to csv file > df.loc[df['Route Num'] == '1000XD'][['stop_lat', > 'stop_lon']].to_csv('myroute.csv', index=False) > > # open the csv and pass the values to google map > !cat myroute.csv > > This can also be achieved using php+mysql but using python-pandas makes it > extensible and easy to integrate. > > -- Shantanu Oak > > > > On Friday, 13 May 2016 10:03:16 UTC+5:30, Nikhil VJ wrote: >> >> Hi Friends, >> >> Please connect with anyone who would like to do some fundoo >> coding-for-public: >> >> Design document: (a ppt slideshow) : Bus Route Information Management System >> >> (lots of things ironed out since the last time I spammed you about this, and >> I've now broken it down to phases where initial ones would be fairly simple >> to implement) >> >> Specific detail: As far as possible I want to pull this off on >> PHP/SQL/Javascript platform. >> >> If you could connect me with a pune-based college's computer science >> department it would be heavenly! >> >> Sharing a few of the slides to stoke your imagination.. >> >> [image: Inline image 9] >> >> [image: Inline image 10] >> >> [image: Inline image 11] >> >> [image: Inline image 12] >> >> (please see the link shared at top for seeing all the slides) >> >> >> [image: Inline image 6] [image: Inline image 7] [image: Inline image 8] >> >> >> Disclaimer note: If you believe you're a .NET-only developer then this is >> not for you. And, absolutely no hi-fi advanced server/stack based solutions >> allowed which require complicated command-line installations on server side >> and need to be maintained as if they're some freakin' nuclear power plant. >> This whole thing can run off just 2 tables in its most basic form (phase >> 1&2), so let's keep things simple. Aur copyright / IPR ki baat ki toh >> chappal khayegaa. >> >> >> Read some FAQs here. >> >> Thanks for your time! Do connect if interested! >> >> Link for sharing this article on FB/twitter/etc >> or share my FB post >> >> >> -- >> Cheers, >> Nikhil >> +91-966-583-1250 >> Pune, India >> Self-designed learner at Swaraj University <http://www.swarajuniversity.org> >> http://nikhilsheth.blogspot.in > > -- > 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.
