HI,
Not clear what you are trying to do:
set.seed(25)
df1<-as.data.frame(matrix(sample(1:40,20,replace=TRUE),ncol=4))
set.seed(15)
df2<-as.data.frame(matrix(sample(1:40,20,replace=TRUE),ncol=4))
do.call(rbind,lapply(list(df1,df2),`[`,c(2,4)))
# V2 V4
#1 40 6
#2 26 22
#3 14 30
#4 3 20
#5 12 30
#6 40 34
#7 33 18
#8 11 39
#9 28 6
#10 34 32
do.call(rbind,lapply(list(df1,df2),`[`,c(1,3)))
#in reading from read.csv()
do.call(rbind,lapply(lapply(files,read.csv),`[`,c(1,3)))
A.K.
----- Original Message -----
From: "qt2ho...@gmail.com" <qt2ho...@gmail.com>
To: r-help@r-project.org
Cc:
Sent: Saturday, January 19, 2013 11:08 AM
Subject: [R] Merge 2 columns into 1 column
Hey everyone,
I just can’t wrap my head around this problem: I got 2 Columns with 4 columns.
They basically look like this:
1 2 3 4
… … … …
I want to merge the two CSVs into a two-column list, which should look like
this:
1 & 3 2 & 4
… …
… …
This is what I came up with so far:
files <- paste(list.files(files.dir, pattern = "*.csv"), sep = "")# Scan
mergedfiles <- do.call("rbind", lapply(files, read.csv)) # Merge
Obviously this will only merge the two CSVs into a four column list. Is there
any way to merge columns 1 & 3 and columns 2 & 4 of both files into a single
list?
Thanks and all the best
Kenji
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
