如何读取多个csv，并在每个文件的文件名中保留数字? [英] How can I read multiple csvs and retain the number in the file name for each?

问题描述

我在一个文件夹中有多个csv文件，但都没有标题.我想保留文件末尾的数字所列出的顺序.文件名是"output-1.csv"，"output-2.csv"，依此类推.有没有一种方法可以包含每个csv的文件名，所以我知道哪些数据对应于哪个文件.答案[这里] [1]接近我想要的.

I have multiple csv files in a folder none of which have a header. I want to preserve the order set out by the number at the end of the file. The file names are "output-1.csv", "output-2.csv" and so on. Is there a way to include the file name of each csv so I know which data corresponds to which file. The answer [here][1] gets close to what I want.

library(tidyverse)

#' Load the data ----
mydata <-
  list.files(path = "C:\\Users\\Documents\\Manuscripts\\experiment1\\output",  
   pattern = "*.csv") %>%
  map_df( ~ read_csv(., col_names = F))
mydata

推荐答案

您可以使用:

library(tidyverse)

mydata <- list.files("C:\\Users\\Documents\\Manuscripts\\experiment1\\output", 
pattern = ".csv$", full.names = T) %>% 
  set_names(str_sub(basename(.), 1, -5)) %>% 
  map_dfr(read_csv, .id = "file")

这篇关于如何读取多个csv，并在每个文件的文件名中保留数字?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！