Welcome!
What is this course about?
This course is intended for people who use spreadsheets for data manipulation and 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 using Quarto.
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.
We’ll start with an example of a short report to show all the things you can do with R. Then you learn how to read data into R, create tables and visualizations to reproduce the same example. At the end, you’ll be able to create a report in different formats and share it with others.
Before we start
During this workshop we will use and RStudio project. You can work locanly from your computer or use Posit Cloud (an RStudio version in the cloud). Please follow these instructions to prepare for the workshop.
Schedule
This is a tentative time table.
| Duration (minutes) | Topics |
|---|---|
| 45 | Introduction, reports, workflows |
| 15 | Reading data |
| 30 | Plotting data |
| 30 | Break |
| 45 | Data manipulation |
| 30 | Reporting your work |
| 15 | Q&A and goodbye |
Hi!
I’m Pao Corrales
I have a PhD in atmospheric sciences from the University of Buenos Aires. I worked in atmospheric sciences applying data assimilation techniques to improve short-term forecasts of severe events in Argentina and I’m currently working at Monash University exploring extremes in climate and weather in Australia. I’m trainer and instructor for The Carpentries and an RStudio certified instructor. I’m also part of Expedition Science, an Argentina-based NPO, where she leads educational projects such as science camps and workshops for students and K-12 science teachers. I’m a professor at the Data Sciences degree at Austral University and I develop openly licensed materials to teach and learn R from scratch.
paobcorrales.github.io | fosstodon.org/@paocorrales
License
All materials in this course are under the license Creative Commons Attribution-ShareAlike 4.0 International License.
This material is an updated version of From spreadsheets to R.
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.