Advanced data management & manipulation using R (2018)

22-23 October 2018

Dr. Marta Bellone, Coordinator of the CUSO Doctoral Program in Ecology and Evolution

Dr. Sara Santi, Coordinator of the Doctoral Program in Organismal Biology

Dr. Jan Wunder, Swiss Federal Institute for Forest, Snow and Landscape Research (WSL) Birmensdorf & Wunder Consulting Wald ZH

The analysis of large data sets ("big data") is becoming increasingly important in science and elsewhere. In this course you will learn how to use R to manage and manipulate large data sets, i.e. to sort, merge, subset, aggregate and reshape data, including outlier detection and gap filling algorithms.

For advanced data manipulation, we are going to use novel developments such as dplyr ("A Grammar of Data Manipulation"), the pipe operator (%>%) for simpler R-coding and data.table for the fast aggregation of large data sets. Furthermore, we will have a closer look at R-data base connections, SQL queries and the creation of new data bases from R.

Depending on the course progress, there will be scope for individuals to work on small projects and/ or their own data sets.

Course outline:

• Data structures
• 
Data management (merge, sort, reshape,...)
• "The data.table way" (data.table)
• "The grammar of data manipulation" (dplyr)
• Tidying up messy data (tidyr, NAs & outliers)
• Databases (ODB)
• Reporting (knitr)

University of Bern

1

Full attendance and personal work: participants are required to complete and send an assignment before November 2.

!PREREQUIREMENT!

Familiarity with R before attending the workshop or previous attendance of an introductory course to R

When? October 22-23, 2018, from 9am to 18pm

Where? University of Bern

Uni Tobler, Raum B -181, Länggassstrasse 49, 3012 Bern

Information: Bring your own laptop to the workshop with recent versions of R and R-Studio installed. Make sure that your laptop is properly connecting to the University of Bern or eduroam WLAN.

Reimbursement:

PhD students of the DPEE are eligible for reimbursement of incurred travel expenses by train (half-fare card, and 2nd class). Please send the original tickets along with the reimbursement form to:

 Marta Bellone  Doctoral Program in Ecology and Evolution
 PER04 building
 University of Fribourg
 Rue Albert-Gockel, 3
 CH-1700 Fribourg

NEW from 2018: NO reimbursement of your meal expenses

Regarding reimbursement of accomodation, please contact the coordinator of the doctoral program (ecologie-evolution(at)cuso.ch) BEFORE the beginning of the course. NO reimbursement of accomodation without the agreement in advance of the course of the coordinator of the doctoral program.

Priority is given to PhD students from the Doctoral Programs in Organismal Biology and CUSO Ecology-Evolution (8 places each) until September 24 2018. After this deadline, first comes, first serves

CUSO PhD students: through your MyCUSO account 

External participants (non-CUSO PhD students, post-docs, etc...): use the icon "registration" at the top of this page and then the last gray box "non-CUSO student" ("personne hors myCUSO").

!The places reserved for DPEE students are now filled! Waiting list is now open.

16