Introduction to Data Management 2600-MSdz2IDMen
• Introduction to R and R data structures, Execute R commands, understand R objects and data structures, use R functions, Data investigation and manipulation using Base R
• Investigate R object type and structure, isolate elements using Base R subset operators and the subset () function, Data investigation and manipulation using tidyverse
• Select, filter, and sort data using tidyverse functions, chain functions together using pipes (%>%), create new variables conditionally using if_else(), recode(), and case_when()
• Calculate aggregate statistics from multiple rows of data, Group rows of data using group_by(), create aggregate statistics using summarize()
• Work with strings and date/datetime objects, Understand string basics, manipulate strings using stringr functions, work with dates and times using the lubridate package
• Understand the class and attributes of R objects, Investigate R object class and attributes, work with factor variables, label variables and values of a data frame using the labelled package
• Tools and guidelines for exploratory data analysis (EDA) Learn common approaches for exploring and analyzing data, understand skip patterns in survey data
• Understand tidy data structure and reshaping data, Define tidy data and how to reshape untidy data into tidy form, reshape data from wide to long using pivot_longer(), reshape data from long to wide using pivot_wider(), handle missing values during reshaping
• Combine data from multiple datasets using joins, Merge datasets using mutating joins, Check quality of merge using filtering joins, append datasets by stacking rows
Course coordinators
Type of course
Mode
Learning outcomes
Knowledge
K_W05 – Students will have knowledge of basic object-oriented programming concepts.
K_W06 – Students will have extensive knowledge of data manipulation and pattern analysis in datasets.
K_W07 – Students will learn guidelines and practical strategies for ensuring data quality during data cleaning and creation of analytical variables.
Skills
K_U01 – Students will be able to sort datasets to gain insight into their structure.
K_U02 – Students will be able to create summary statistics for individual variables to diagnose errors in data.
K_U03 – Students will be able to merge multiple datasets and manipulate the organizational structure of data collections.
K_U07 – Students will be able to use a foreign language at the B2+ level of the Common European Framework of Reference for Languages (CEFR) and employ specialized terminology in the field of management and quality science.
Social Competences
K_K01 – Students will be able to make evidence-based decisions.
K_K02 – Students will be able to solve problems through teamwork.
Assessment criteria
Group Project and Presentation (50%)
Homework (30%)
Class Activities (20%)
Bibliography
R for Data Science by Garrett Grolemund and Hadley Wickham
https://r4ds.hadley.nz/
• R Graphics Cookbook, 2nd edition, Winston Chang
https://r-graphics.org/
Required Software
R, statistical programming language
https://cloud.r-project.org/
RStudio, integrated development environment for R
https://posit.co/download/rstudio-desktop/