RStudio short project
Budget: $30 – $250 USD
Dear Data analyzers
I need a piece of code in R program that can manage some of my tasks in excel spreadsheets. There are some spreadsheets with a large number of data. The data have a date and a value on a daily basis. The code should read the excel file and get the means of each months' values. The output file must contain date and the mean value. A sample file was uploaded here with the sample result format that I want. Also If this task can be done in Microsoft Excel that is good I am open to hear your advice.
I need a piece of code in R program that can manage some of my tasks in excel spreadsheets. There are some spreadsheets with a large number of data. The data have a date and a value on a daily basis. The code should read the excel file and get the means of each months' values. The output file must contain date and the mean value. A sample file was uploaded here with the sample result format that I want. Also If this task can be done in Microsoft Excel that is good I am open to hear your advice.