Welcome!
What is this course about?
This course is intended for people who use spreadsheets for data manipulation and have never programmed, but would like to learn how to work with R. Therefore its starts from the beginning: why use R? and where to start?
We propose to work with R in an orderly and reproducible way. For this reason, we present a workflow that allows those who take this course to apply good programming practices, work collaboratively and present their work in a single document that includes the analysis and the results.
Whenever we can, we will mention how what we propose to solve with R can also be done with spreadsheets and the advantages and disadvantages of each approach.
In each section we include activities along with examples. We want these exercises to be realistic so that anyone can find similarities in their own data and can apply what they have learned to other situations.
Before we start
During this workshop we will use Posit Cloud. If you want to use your computer we will use R and RStudio. Please follow these instructions to prepare for the workshop.
Schedule
This is a tentative time table.
| Duration (minutes) | Topics |
|---|---|
| 55 | Introduction, reports, workflows |
| 5 | Break |
| 55 | Reading and Plotting |
| 5 | Break |
| 30 | Data manipulation |
| 20 | Reporting your work |
| 10 | Q&A and goodbye |
Who are we?
Yanina Bellini Saibene
Yanina Bellini Saibene is the Community Manager at rOpenSci. She was a researcher at Argentina’s National Institute of Agricultural Technology (INTA) from 1998 to 2022, working on AgTech. She also develops software to support research and education. She teaches undergraduate and graduate courses at several universities in Argentina, teaching applied Data Science and developing open courses and tutorials to teach technical data management skills. She is a trainer, instructor and member of the Board of Directors of The Carpentries, and a Posit certified instructor. She is part of the Board of Directors of R-Ladies+ Global.
Pao Corrales
Paola Corrales holds a PhD in Atmospheric Sciences from the University of Buenos Aires. She worked in atmospheric sciences applying data assimilation techniques to improve short-term forecasts of severe weather events in Argentina, and she currently works at Monash University exploring weather and climate extremes in Australia. She is a trainer and instructor for The Carpentries and an RStudio certified instructor. She has also contributed to translation projects of The Carpentries’ materials, the book Teaching Tech Together and R base. She is part of Expedición Ciencia, an Argentina-based non-profit organization, where she leads educational projects such as science camps and workshops for students and primary and secondary school science teachers. She is a professor in the Data Science degree at Universidad Austral. She also develops openly licensed materials to teach and learn R from scratch.
paobcorrales.github.io | @paobcorrales
Elio Campitelli
Elio Campitelli holds a PhD in Atmospheric Sciences from the University of Buenos Aires, where they studied the large-scale circulation of the Southern Hemisphere. They currently study the interaction between the atmosphere and Antarctic sea ice at Monash University. As part of their research, they have developed several R packages to work with climate science data, such as metR, ggnewscale, icecdr and others.
eliocamp.github.io | @eliocamp
License
All materials in this course are under the license Creative Commons Attribution-ShareAlike 4.0 International License.
We are inspired and based on the following resources:
R for Reproducible Scientific Analysis by The Carpentries
R for Excel Users by Dr. Julie Stewart Lowndes and Dr. Allison Horst
R for Data Science by Hadley Wickham
de Excel a R by Paola Corrales and Elio Campitelli
An Antarctic Tour of the Tidyverse by Silvia Canelón
The source code for these materials and web page can be found at https://github.com/yabellini/fromSpreadSheetToR.