Import multiple Excel files

Casestudy of purrr::map() to make one big data frame

The code and companion youtube playlist show practical R/data-wrangling tips and tricks. This case study demonstrates custom functions, regex (regular expressions), and iteration. The workflow shows techniques for common needs such: data-scraping, ingesting multiple files, transforming messy data into tidy data, quickly cleaning column names, separating multivalue fields, uniting variable values, and nesting data.

Playlist

Code and data

Github ▶️ libjohn/workshop_rfun/iterate