IMD rainfall data to csv file

[Uday Bhaskar Reddy]

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.

[Nikhil VJ]

Hi Uday,

Do share all relevant links, sample data whenever possible.

Regards

Nikhil

--
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+u...@googlegroups.com.
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.

[Uday Bhaskar Reddy]

Hi Nikhil,

Attaching a sample file as suggested.

Regards,

Uday.

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAH7jeuMz3nh272Lcxj1DCvWGUQJCThKbG9qWMhazKf-92985Bw%40mail.gmail.com.

[Nikhil VJ]

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

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAE9YNvndfMjgkH4cw5Ga9cNx3A4vqDQ02mT%2B-xq8Z2U4XHLuXg%40mail.gmail.com.

[Uday Bhaskar Reddy]

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAH7jeuOJiGrHEqXjTsmHGC9AcBLSznz-bLMHTsrHKKJMhma0OQ%40mail.gmail.com.

[Manish Gupte]

Dear Uday,

Does IMD have 2020 rainfall daily values for stations? I also want to buy it.

Manish

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAE9YNv%3DWwYetxPUgc-pVpQGe8suhibJ8-rBArEMROEB_jYTQYA%40mail.gmail.com.

[Uday Bhaskar Reddy]

Hi Manish,

Sorry, I have no information on that. We have to make a request for data for a period based on which they will act. Please explore here - https://www.imdtvm.gov.in/index.php?option=com_content&task=view&id=29&Itemid=43

Regards,

Uday.

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/690259279.660514.1599747363570%40mail.yahoo.com.

[SANDIP SARKAR]

This might be helpful to you

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAE9YNvndfMjgkH4cw5Ga9cNx3A4vqDQ02mT%2B-xq8Z2U4XHLuXg%40mail.gmail.com.