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.
LIST OF ABBREVIATIONS USED :
--------------------------
MRF = TOTAL MONTHLY R/F IN MM
NOB = No. OF OBSERVATIONS IN THE MONTH (NUMBER OF OBSERVATIONS ZERO
MEANS OBSERVATIONS ARE NOT RECORDED DURING THE MONTH
R/D = No. OF RAINY DAYS (DAYS HAVING R/F MORE THAN 2.4 MM)
R/F = 24 HOURS HEAVIEST RAINFALL IN MM
DT = DATE OF HEAVIEST R/F
MN = MONTH OF HEAVIEST R/F
MONTHLY RAINFALL DATA FOR STATION : A.KONDAPURAM PWD DISTT. : ANANTAPUR
LAT. : DEG. N LONG. : DEG. E
----------------------------------------------------------------------------------------------------------------------------
YEAR JAN FEB MAR APR MAY JUN JUL AUG SEP
OCT NOV DEC ANNUAL 24 HRS HEAVIEST
----------------------------------------------------------------------------------------------------------------------------
1989 MRF : 42.0 274.0 227.0
543.0 R/F : 91.0
NOB : 0 0 0 0 0 30 31 0 30
0 0 0 91 DT : 26
R/D : 2 9 10
MN : 09
1993 MRF : 50.0 54.0 64.8 135.7
201.8 71.2 61.2 638.7 R/F : 120.0
NOB : 0 0 0 0 0 30 31 31 30
31 30 31 214 DT : 03
R/D : 3 3 6 6
8 5 2 MN : 10
1994 MRF : 26.0
26.0 R/F : 20.0
NOB : 0 0 0 30 0 0 0 0 0
0 0 0 30 DT : 28
R/D : 2
MN : 04
STATION : AGALI REV DISTT. : ANANTAPUR LAT. : 13 DEG. N
LONG. : 77 DEG. E
1989 MRF : .0 .0 .0 12.8 24.8 55.5 191.2 45.8 223.4
40.6 .0 .0 594.1 R/F : 61.0
NOB : 31 28 31 30 31 30 31 31 30
31 30 31 365 DT : 21
R/D : 0 0 0 1 2 1 9 7 11
2 0 0 MN : 09
1991 MRF : 77.0 81.6 161.4 19.0 24.2 155.8
382.4 44.2 945.6 R/F : 131.6
NOB : 0 0 0 30 31 30 31 31 30
31 30 0 244 DT : 31
R/D : 2 4 6 2 3 5
11 2 MN : 10
1992 MRF : 92.6 107.4 124.0 45.8 78.4 68.4
159.4 24.0 700.0 R/F : 92.6
NOB : 0 0 0 30 31 30 31 31 30
31 30 0 244 DT : 18
R/D : 1 5 9 2 7 6
8 2 MN : 04
1993 MRF : .6 6.4 52.0 48.4 24.6 18.0 86.6
236.0 35.0 48.0 555.6 R/F : 70.8
NOB : 0 0 31 30 31 30 31 31 30
31 30 31 306 DT : 03
R/D : 0 1 1 3 3 2 6
8 1 1 MN : 10
1994 MRF : 28.8 3.6 58.0 62.2 30.4 27.0 47.4
187.6 9.8 454.8 R/F : 64.4
NOB : 31 0 0 30 31 30 31 31 30
31 30 0 275 DT : 04
R/D : 1 1 3 5 3 5 4
11 2 MN : 10
1995 MRF : 5.6 88.2 33.6 81.8 132.8 122.6
57.2 40.4 562.2 R/F : 64.0
NOB : 0 0 0 30 31 30 31 31 30
31 30 0 244 DT : 29
R/D : 1 3 3 6 8 7
2 1 MN : 05
1996 MRF : 67.6 .0 160.6 51.0 62.4 305.2
79.6 726.4 R/F : 94.0
NOB : 0 0 0 30 31 30 31 31 30
31 0 0 214 DT : 14
R/D : 2 0 4 5 4 8
6 MN : 06
1997 MRF : 82.6 6.8 249.8
46.0 79.4 14.0 478.6 R/F : 62.2
NOB : 0 0 0 0 0 30 0 31 30
31 30 31 183 DT : 10
R/D : 5 1 9
3 6 1 MN : 09
1998 MRF : 5.0 31.0 52.4 165.2 100.6 147.4
190.2 25.2 8.0 725.0 R/F : 72.0
NOB : 0 0 31 30 0 30 31 31 30
31 30 31 275 DT : 10
R/D : 1 3 4 6 10 8
8 3 1 MN : 07
1999 MRF : 21.4 15.2 108.0 40.0 46.0 32.8 99.0
89.4 31.6 483.4 R/F : 74.2
NOB : 0 28 0 30 31 30 31 31 30
31 30 0 272 DT : 30
R/D : 1 1 7 5 4 3 4
7 4 MN : 09
2000 MRF : 21.4 33.2 20.8 146.2 115.6
108.4 445.6 R/F : 37.0
NOB : 0 0 0 0 31 30 31 31 30
31 0 0 184 DT : 05
R/D : 2 4 3 12 8
10 MN : 08
2001 MRF : 58.6 17.8 10.0 17.0 40.4 196.4
104.4 3.5 448.1 R/F : 62.4
NOB : 0 0 0 30 31 30 31 31 30
31 30 0 244 DT : 19
R/D : 5 3 2 4 6 13
8 1 MN : 09
2002 MRF : 29.0 13.4 57.6 86.6 16.4 27.4
87.4 8.4 326.2 R/F : 48.4
NOB : 31 28 0 0 31 30 0 31 30
31 0 31 243 DT : 26
R/D : 1 2 2 7 1 2
11 1 MN : 05
2003 MRF : 4.2 27.8 17.0 65.6 41.6 11.6
161.2 329.0 R/F : 46.0
NOB : 0 0 31 30 0 30 31 31 30
31 0 0 214 DT : 06
R/D : 1 2 2 9 4 2
8 MN : 10
2004 MRF : 8.0 96.8 44.4 120.2 33.8 39.4
342.6 R/F : 28.6
NOB : 0 0 0 30 31 30 31 31 30
0 0 0 183 DT : 12
R/D : 2 10 3 11 5 4
MN : 07
2005 MRF : 8.2 18.6 114.8 21.2 220.8 111.6 131.8
313.8 34.0 .4 975.2 R/F : 105.0
NOB : 0 28 31 0 31 30 31 31 30
31 30 31 304 DT : 15
R/D : 1 2 8 3 8 8 8
18 3 0 MN : 07
2006 MRF : .0 .0 40.4 20.0 35.8 107.0 14.8 .0 25.8
6.2 21.8 .0 271.8 R/F : 64.2
NOB : 31 28 31 30 31 30 31 31 30
31 30 31 365 DT : 20
R/D : 0 0 2 1 4 5 2 0 4
1 3 0 MN : 06
