👩💻 Join our community of thousands of amazing developers!
Importing multiple excel files (not sheets, but files) and flattening into one data frame / tibble / data.table should be straightforward - shouldn’t it? How many ways can there be? What are the pros and cons of each? I’ve made three copies of an excel file from a PreppinData challenge. For this, I just want to import the first sheet from each workbook, into one table. Ideally I’d like to identify the sheets - but it’s not a deal breaker. suppressPackageStartupMessages(library(rio)) suppressPack...