Hi,
Try:
dat1 <- read.table(text="id cat val
1 A 2
1 C 4
3 B 1
5 A 2
6 A 3
6 B 5
6 C 2
8 B 5
8 D 2
9 D 3",sep="",header=TRUE,stringsAsFactors=FALSE)
library(reshape2)
res1 <- dcast(dat1,id~cat,value.var="val",fill=0)
colnames(res1)[-1] <- paste0("cat",colnames(res1)[-1])
#or
xtabs(val~id+cat,data=dat1)
A.K.
On Sunday, December 15, 2013 8:38 PM, marcos.takahashi
<marcos.takaha...@mobly.com.br> wrote:
Hi all,
I'm kinda new in R programming and I need some help preparing a database to
run logistic regression.
I have data in a tuple form:
*id cat val*
1 A 2
1 C 4
3 B 1
5 A 2
6 A 3
6 B 5
6 C 2
8 B 5
8 D 2
9 D 3
and would like to have it like:
*id catA catB catC catD*
1 2 0 4 0
3 0 1 0 0
5 2 0 0 0
6 3 5 2 0
8 0 5 0 2
9 0 0 0 3
Could someone help me?
I have already tried table function, but it doesn't return row and column
names.
--
View this message in context:
http://r.789695.n4.nabble.com/Rows-to-Column-tp4682245.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.
