Hi,
Try this:
dat1<- read.table(text="
V1 V2
8098 110000
9099 001100
0023 110011
6545 111111
",sep="",colClasses=c(V1="character",V2="character"),header=TRUE)
dat2<-as.data.frame(apply(dat1,2,FUN=function(x){do.call(rbind,strsplit(x,""))})$V2)
dat2<-data.frame(V1=dat1$V1,dat2)
names(dat2)<-c("V1",LETTERS[1:6])
> dat2
V1 A B C D E F
1 8098 1 1 0 0 0 0
2 9099 0 0 1 1 0 0
3 0023 1 1 0 0 1 1
4 6545 1 1 1 1 1 1
A.K.
----- Original Message -----
From: efulas <ef_u...@hotmail.com>
To: r-help@r-project.org
Cc:
Sent: Saturday, June 9, 2012 6:21 AM
Subject: [R] Reshaping columns
Dear all,
I have a data frame with 2 columns and 102500 rows. The data looks like
below
V1 V2
8098 110000.......
9099 001100.......
0023 110011.......
6545 111111.......
. .
. .
. .
. .
. .
I want to split the colums like this ;
V1 V2 V3 V4 V5 V6 v7
8098 1 1 0 0 0 0 ......
9099 0 0 1 1 0 0 .......
0023 1 1 0 0 1 1 .......
6545 1 1 1 1 1 1 .......
. . . . . . .
. .
. .
. .
. .
Is there anyway to do this in R.
Many Thanks
--
View this message in context:
http://r.789695.n4.nabble.com/Reshaping-columns-tp4632875.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
