from Spreadsheet to R is intended for people who usespreadsheeets (Excel, Google sheets) for data manipulation and analysis but would like to learn how to use R. In particular we are thinking of:
Naomi: she is doing a PhD in genetics. Has been analyzing data with Excel for almost ten years. Is going to run 300 experiments in the next six months. Doesn’t want to have to do all the analyses by hand. And wants nicer charts for her thesis than she can produce in Excel.
Andrea: has been working for many years analyzing crops, yields and prices from data she receives in spreadsheets. They handles Excel very well and although they has to start every analysis from scratch and need to copy tables and plots to word for the reports they need to build, they has a lot of practice. They hear about R and they thinks it can be useful to automate they workflow, but at the same time it is a challenge to change the way they has always been working.
Rodrigo: works with data in Google Sheets, because he edit the files with other people. Is not as experienced and often makes mistakes that force him to start the analysis over again. At the same time he is afraid of losing the original data and ends up download and saving into disck many versions of the same file. He wants to learn to program but does not know whether to start using R or Python and whether he will be able to solve the problems he has with Google Sheets with either of these tools.