datamanagement - Manage and transform data in R
Imports, cleans, reshapes, joins, validates, and transforms data in R using tidyverse packages for analysis preparation.
Tags
Updated: 2026-09-28Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Import CSV and Excel files
- Read SPSS, Stata, and SAS files
- Clean column names and types
- Handle missing data
- Recode and derive variables
- Transform rows and columns
- Summarise grouped data
- Reshape data between formats
- Join and merge datasets
- Map over lists and models
- Validate and inspect data
Inputs
- CSV files
- Excel files
- SPSS files
- Stata files
- SAS files
- R data frames
- Lookup datasets
- Transformation requirements
Outputs
- Cleaned R data frames
- Transformed datasets
- Summary tables
- Reshaped datasets
- Joined datasets
- Saved model or data files
Requirements
- R 4.1 or later
- Tidyverse packages
- janitor package
- lubridate package
- readxl package
- haven package
- gtsummary package
- labelled package