I think that is pretty easy in pandas also i have analysed daily rainfall for jaipur for nearly five years here https://github.com/sandeepgadhwal/Rainfall-and-Stormwater-Analysis/blob/master/Rainfall_Analysis.ipynb
On Friday, 9 March 2018 16:09:13 UTC+5:30, Kshithij Iyer wrote: > > DataMeet Pune Rainfall Data (Unpivoted) > <https://github.com/kshithijiyer/DataMeet-Pune-Rainfall> > > This is a script which I developed for DataMeet Pune which takes an .xls > file which has rainfall data of India and generates state-wise .csv files > in an unpivoted format which can be useful for further analysis > > > . > > <https://github.com/kshithijiyer/DataMeet-Pune-Rainfall#what-does-the-script-do>What > > does the script do? > > Look at the unpivoting example.xlsx > <https://github.com/kshithijiyer/DataMeet-Pune-Rainfall/raw/master/data/unpivoting%20example.xlsx> > > file and this link > <https://github.com/datameet-pune/datameet-pune.github.io/wiki/Table-Un-Pivot> > > you'll get a hang of what the script does. :) > > <https://github.com/kshithijiyer/DataMeet-Pune-Rainfall#about-the-data> > <https://github.com/kshithijiyer/DataMeet-Pune-Rainfall#about-the-data>About > the data? > > *Source of Data:* > http://www.indiawaterportal.org/articles/district-wise-monthly-rainfall-data-list-raingauge-stations-india-meteorological-department > > *Issues with the Raw data:* Chandigarh data is given under Chhattisgarh > sheet. A sepreated sheet had to be manually created so that the script can > run smoothy on the .xls file. > > > > <https://github.com/kshithijiyer/DataMeet-Pune-Rainfall#list-of-r-packages-needed-by-the-code>List > > of R packages needed by the code: > > 1. xlsx <https://cran.r-project.org/web/packages/xlsx/index.html> > 2. tidyr <https://cran.r-project.org/web/packages/tidyr/index.html> > > > <https://github.com/kshithijiyer/DataMeet-Pune-Rainfall#manual-inputs-needed-to-the-script>Manual > > inputs needed to the script. > > 1. You'll have to choose the .xlsx file which has to be processed. > However the code does have manual logic as well which can be uncommented > and you can create .CSV files of specific sheets instead of the all the > sheets in the .xls file. > 2. The .csv file would be store in the ./Processed-Data folder and > You'll have to manually add "Sr.No", to the start of the .csv file. > > > <https://github.com/kshithijiyer/DataMeet-Pune-Rainfall#what-can-be-done-with-this-data>What > > can be done with this data? > > 1. A choropleth map of the country with a timeline, the colours > changing to show amount of rainfall. > 2. A predective model for drought detection can be created. > > > -- 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.