Data aggregation and transformation with the R package tidyverse
This 8-hour course is designed for data and business analysts, researchers, auditors, and other professionals with little background in the R programming language who want to develop a deeper understanding of the principles of clean data, practical skills in aggregating and transforming data using the R package tidyverse.
Course target
The aim of the course is to develop an in-depth understanding of the principles of clean data and practical skills in data aggregation and transformation using the R package tidyverse.
Audience
- Data analysts;
- Risk and business analysts;
- Economists;
- Researchers;
- Auditors;
- Business controllers.
At Course Completion you will be able to:
- Cleaning data to prepare it for further processing;
- Aggregate data, calculate different indicators by dividing data into groups;
- Select observations and variables;
- Modify data table formats, create new variables and modify existing ones;
- Merge multiple data tables.
Prerequisites
Basic R skills – creating commands and importing data.
Training materials
BDA-developed training materials and practical examples.
Certification Exam
Not intended.
Course outline
- The concept of clean data;
- Pipe operator use;
- Packages included in the R package tidyverse, their applications;
- Data format change – long and wide format tables;
- Working with text;
- Aggregating data and calculating different indicators by dividing data into groups;
- Creating new variables and modifying existing variables;
- Selection of observations and variables;
- Combining multiple data tables into one table.
If you want to get more information about this course, contact us by phone +371 67505091 or send an e-mail at mrn@bda.lv.
