Hi NIkhil, Thank you for the information. This data is bought from IMD. Information on how to purchase by individuals and organisations is available on their website.
Regards, Uday. On Wed, Sep 9, 2020 at 1:20 PM Nikhil VJ <[email protected]> wrote: > Hi Uday, > > Great, giving the actual structure always helps. Now, do share how you get > this data from IMD so that others can get to it (or for their place / time) > too. > > Generally to be able to work with such data we need to un-pivot it and > bring all the values into one column. > > Towards that, I have created a basic unpivoting tool sometime back which > might help: > https://answerquest.github.io/table-unpivot.html > > It requires properly formatted tables though, so you would have to do some > work on your data before you can use this. I won't be able to help > regarding that, maybe someone else can. I think the place name and lat-long > need to be brought in as columns too, so it won't be as simple as deleting > them off. > > -- > Cheers, > Nikhil VJ > https://nikhilvj.co.in > > > On Tue, Sep 8, 2020 at 6:58 PM Uday Bhaskar Reddy <[email protected]> > wrote: > >> Hi Nikhil, >> >> Attaching a sample file as suggested. >> >> Regards, >> Uday. >> >> On Tue, Sep 8, 2020 at 6:57 AM Nikhil VJ <[email protected]> wrote: >> >>> Hi Uday, >>> Do share all relevant links, sample data whenever possible. >>> >>> Regards >>> Nikhil >>> >>> On Tue, Sep 8, 2020, 01:30 Uday Bhaskar Reddy <[email protected]> >>> wrote: >>> >>>> Hi all, >>>> >>>> Could someone kindly share the easiest way to make a CSV file from the >>>> rainfall data shared by IMD in a text file. The problem is the data is >>>> divided into stations with the header containing the station name, location >>>> and coordinates not conforming to the format of the rainfall data. >>>> >>>> Thank you for your time, >>>> Uday. >>>> >>>> -- >>>> 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]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/datameet/CAE9YNv%3DJH79LU%3DFFd%3D%3DYucQV9%3DAzEBwddA-gPQfb2Q8%2BZsk5%3Dg%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/datameet/CAE9YNv%3DJH79LU%3DFFd%3D%3DYucQV9%3DAzEBwddA-gPQfb2Q8%2BZsk5%3Dg%40mail.gmail.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 [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/datameet/CAH7jeuMz3nh272Lcxj1DCvWGUQJCThKbG9qWMhazKf-92985Bw%40mail.gmail.com >>> <https://groups.google.com/d/msgid/datameet/CAH7jeuMz3nh272Lcxj1DCvWGUQJCThKbG9qWMhazKf-92985Bw%40mail.gmail.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 [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/datameet/CAE9YNvndfMjgkH4cw5Ga9cNx3A4vqDQ02mT%2B-xq8Z2U4XHLuXg%40mail.gmail.com >> <https://groups.google.com/d/msgid/datameet/CAE9YNvndfMjgkH4cw5Ga9cNx3A4vqDQ02mT%2B-xq8Z2U4XHLuXg%40mail.gmail.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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/datameet/CAH7jeuOJiGrHEqXjTsmHGC9AcBLSznz-bLMHTsrHKKJMhma0OQ%40mail.gmail.com > <https://groups.google.com/d/msgid/datameet/CAH7jeuOJiGrHEqXjTsmHGC9AcBLSznz-bLMHTsrHKKJMhma0OQ%40mail.gmail.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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAE9YNv%3DWwYetxPUgc-pVpQGe8suhibJ8-rBArEMROEB_jYTQYA%40mail.gmail.com.
