代码之家  ›  专栏  ›  技术社区  ›  Erin

使用输入变量作为数据帧的名称从函数返回数据帧

  •  1
  • Erin  · 技术社区  · 9 年前

    我试图编写一个函数,根据csv的名称将csv组合成1个数据帧,然后根据输入函数的模式命名数据帧。除了返回数据帧外,其他一切都正常。我不知道如何使用函数输入作为数据帧的名称。

    Return a data frame from function

    #### Create files in your current working directory ####
    dir <- getwd()
    
    subDir <- 'temp'
    
    dir.create(subDir)
    
    setwd(file.path(dir, subDir))
    
    dir.create('Run1')
    dir.create('Run2')
    
    employeeID <- c('123','456','789')
    salary <- c(21000, 23400, 26800)
    startdate <- as.Date(c('2010-11-1','2008-3-25','2007-3-14'))
    
    employeeID <- c('123','456','789')
    first <- c('John','Jane','Tom')
    last <- c('Doe','Smith','Franks')
    
    data <- data.frame(employeeID,salary,startdate)
    name <- data.frame(employeeID,first,last)
    
    write.csv(data, file = "Run1/data.csv",row.names=FALSE, na="")
    write.csv(name, file = "Run1/name.csv",row.names=FALSE, na="")
    
    employeeID <- c('465','798','132')
    salary <- c(100000, 500000, 300000)
    startdate <- as.Date(c('2000-11-1','2001-3-25','2003-3-14'))
    
    employeeID <- c('465','798','132')
    first <- c('Jay','Susan','Tina')
    last <- c('Jones','Smith','Thompson')
    
    data <- data.frame(employeeID,salary,startdate)
    name <- data.frame(employeeID,first,last)
    
    write.csv(data, file = "Run2/data.csv",row.names=FALSE, na="")
    write.csv(name, file = "Run2/name.csv",row.names=FALSE, na="")
    
    #### function #### 
    files_to_df <- function(pattern){ 
    
      # pattern <- "data"
      filenames <- list.files(recursive = TRUE, pattern = pattern) 
    
      df_list <- lapply(filenames, read.csv, header = TRUE)
    
      # Name each dataframe with the run and filename
      names(df_list) <- str_sub(list, 1, 4)
    
      # Create combined dataframe  
      df <- df_list %>%
        bind_rows(.id = 'run')
    
      # Assign dataframe to the name of the pattern  
      assign(pattern, df)
    
      # Return the dataframe  
      return(data.frame(pattern))
      #list2env(pattern,.GlobalEnv)
    }
    
    #### Run function ####
    files_to_df(c("data"))
    
    1 回复  |  直到 9 年前
        1
  •  3
  •   and-bri    9 年前

    我对您的代码进行了两次更改:

    1.) str_sub(list, 1, 4) -&燃气轮机; str_sub(filenames, 1, 4)

    2.) return(data.frame(pattern)) -&燃气轮机; return(df) 返回数据。框架而不是刺痛。

    files_to_df <- function(pattern){ 
    
      # pattern <- "data"
      filenames <- list.files(recursive = TRUE, pattern = pattern) 
    
      df_list <- lapply(filenames, read.csv, header = TRUE)
    
      # Name each dataframe with the run and filename
      names(df_list) <- str_sub(filenames, 1, 4)
    
      # Create combined dataframe  
      df <- df_list %>%
        bind_rows(.id = 'run')
    
      # Assign dataframe to the name of the pattern  
      assign(pattern, df)
    
      # Return the dataframe  
      return(data.frame(df))
      #list2env(pattern,.GlobalEnv)
    }