Simplify an Excel document with R markdown
Budget: $30 – $250 CAD
The initial situation of the project is the following:
Currently there is 39 sheets in the attached Excel file
Each sheet is using some of the data from the previous sheets to make analysis, but not all of the data is used, some is unnecessary.
I know that after the 16th sheets all the data is correct. So the first 16 sheets are the one to modified; you only need to removed the cases that are in the first 16 sheets and not used in the following 23.
The objective of this project is the following:
Create an R markdown script that will simplify the Excel document so that the unnecessary and unused data are removed from the Excel file.
The unnecessary data is the one that is located it the first 16 sheets and not used in the following 23 others. I think that creating an R script that could scan each case and only keeping the ones that will be used could be the solution, but I am not sure.
The Output is an R database with a markdown script and an Excel file.
Please let me know how long you think it will take you
Currently there is 39 sheets in the attached Excel file
Each sheet is using some of the data from the previous sheets to make analysis, but not all of the data is used, some is unnecessary.
I know that after the 16th sheets all the data is correct. So the first 16 sheets are the one to modified; you only need to removed the cases that are in the first 16 sheets and not used in the following 23.
The objective of this project is the following:
Create an R markdown script that will simplify the Excel document so that the unnecessary and unused data are removed from the Excel file.
The unnecessary data is the one that is located it the first 16 sheets and not used in the following 23 others. I think that creating an R script that could scan each case and only keeping the ones that will be used could be the solution, but I am not sure.
The Output is an R database with a markdown script and an Excel file.
Please let me know how long you think it will take you