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.