R 3.0.3 rbind multiple csv files

r csv rbind
user3551565 picture user3551565 · Apr 19, 2014 · Viewed 16.2k times · Source

R 3.0.3: I have 40 csv files all structured the same that I want to rbind into one file so I can calculate the mean of one column.

I searched:

  • this website
  • R in a Nutshell
  • R_Intro sources
  • ?rbind Help in RStudio

I cannot find the answer.

Any suggestions/pointers?

Answer

user20650 picture user20650 · Apr 19, 2014

Using the answer from here [Importing several files and indexing them ]

list files with .csv extension - this assumes that the only .csv files in your working directory are the ones you want to read

files  <- list.files(pattern = '\\.csv')

read files into a list - are there headers?

tables <- lapply(files, read.csv, header = TRUE)

rbind files

combined.df <- do.call(rbind , tables)

You can then find the mean - find which columns are numeric

s <- sapply(combined.df, is.numeric)

find the mean of numeric variables

colMeans(combined.df[s])

Related questions

What's wrong with my function to load multiple .csv files into single dataframe in R using rbind?

I have written the following function to combine 300 .csv files. My directory name is "specdata". I have done the following steps for execution, x <- function(directory) { dir <- directory data_dir <- paste(getwd(),dir,sep = "/") …

Read More
Merge multiple .csv files into one

I am aware this question has been asked multiple times, but despite of trying to apply the aforementioned solutions i was not able to solve my little problem: I have saved all my .csv that i am aiming to merge …

Read More
How to import multiple .csv files at once?

Suppose we have a folder containing multiple data.csv files, each containing the same number of variables but each from different times. Is there a way in R to import them all simultaneously rather than having to import them all …

Read More