Add “filename” column to table as multiple files are read and bound

by

I generally use the following approach, based on dplyr/tidyr:

data = tibble(File = files) %>%
    extract(File, "Site", "([A-Z]{2}-[A-Za-z0-9]{3})", remove = FALSE) %>%
    mutate(Data = lapply(File, read_csv)) %>%
    unnest(Data) %>%
    select(-File)

More Related Contents:

  1. Grouping functions (tapply, by, aggregate) and the *apply family
  2. Access lapply index names inside FUN
  3. How do you read multiple .txt files into R? [duplicate]
  4. Read multiple CSV files into separate data frames
  5. lapply vs for loop – Performance R
  6. Read all files in a folder and apply a function to each data frame
  7. Faster way to read fixed-width files
  8. Same function over multiple data frames in R
  9. Returning anonymous functions from lapply – what is going wrong?
  10. Access and preserve list names in lapply function
  11. passing several arguments to FUN of lapply (and others *apply)
  12. How to index an element of a list object in R
  13. lapply-ing with the “$” function
  14. What are the performance differences between for-loops and the apply family of functions?
  15. How to tell lapply to ignore an error and process the next thing in the list?
  16. Writing multiple data frames into .csv files using R
  17. Using lapply to apply a function over list of data frames and saving output to files with different names
  18. Creating a named list from two vectors (names, values)
  19. Union of intersecting vectors in a list in R
  20. How does one access the piped data.frame in dplyr::funs?
  21. Split a vector into chunks
  22. Convert date-time string to class Date
  23. Assign unique ID based on two columns [duplicate]
  24. What is the significance of the new Reference Classes?
  25. Setting Defaults for geoms and scales ggplot2
  26. Normalizing y-axis in histograms in R ggplot to proportion
  27. Can I load a saved R object into a new object name?
  28. Ordering of points in R lines plot
  29. stumped on how to scrape the data from this site (using R)
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment