R help - Jan 2013 - Merge 2 columns into 1 column

Ein eingebundener Text mit undefiniertem Zeichensatz wurde abgetrennt.
Name: nicht verf?gbar
URL:
<https://stat.ethz.ch/pipermail/r-help/attachments/20130119/b876311e/attachment.pl>

On Jan 19, 2013, at 8:08 AM, qt2hot4u at gmail.com wrote:
> Hey everyone,
> 
> I just can?t wrap my head around this problem: I got 2 Columns with 4
columns.
OK, this is simply incoherent.

> 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.
I doubt that claim. Can you provide a reproducible example to prove me wrong?

> 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]]
-- 

David Winsemius
Alameda, CA, USA

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: "qt2hot4u at gmail.com" <qt2hot4u at gmail.com>
To: r-help at 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 at 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.