[R] Data manipulation

[David L Carlson]

Wouldn't this do the same thing?

xtabs(Count~Class+X, D)

----------------------------------------------
David L Carlson
Associate Professor of Anthropology
Texas A&M University
College Station, TX 77843-4352


> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
> project.org] On Behalf Of IOANNA
> Sent: Friday, March 15, 2013 8:51 AM
> To: 'John Kane'; 'Blaser Nello'; r-help at r-project.org
> Subject: Re: [R] Data manipulation
> 
> Thanks a lot!
> 
> -----Original Message-----
> From: John Kane [mailto:jrkrideau at inbox.com]
> Sent: 15 March 2013 13:41
> To: Blaser Nello; IOANNA; r-help at r-project.org
> Subject: Re: [R] Data manipulation
> 
> Nice. That does look like it. IOANNA?
> 
> John Kane
> Kingston ON Canada
> 
> 
> > -----Original Message-----
> > From: nblaser at ispm.unibe.ch
> > Sent: Fri, 15 Mar 2013 14:27:03 +0100
> > To: ii54250 at msn.com, r-help at r-project.org
> > Subject: Re: [R] Data manipulation
> >
> > Is this what you want to do?
> >
> > D2 <- expand.grid(Class=unique(D$Class), X=unique(D$X))
> > D2 <- merge(D2, D, all=TRUE)
> > D2$Count[is.na(D2$Count)] <- 0
> >
> > W <- aggregate(D2$Count, list(D2$Class, D2$X), "sum") W
> >
> > Best,
> > Nello
> >
> >
> > -----Original Message-----
> > From: r-help-bounces at r-project.org
> > [mailto:r-help-bounces at r-project.org]
> > On Behalf Of IOANNA
> > Sent: Freitag, 15. März 2013 13:41
> > To: r-help at r-project.org
> > Subject: [R] Data manipulation
> >
> > Hello all,
> >
> >
> >
> > I would appreciate your thoughts on a seemingly simple problem. I
> have
> > a database, where each row represent a single record. I want to
> > aggregate this database so I use the aggregate command :
> >
> >
> >
> > D<-read.csv("C:\\Users\\test.csv")
> >
> >
> >
> > attach(D)
> >
> >
> >
> > by1<-factor(Class)
> >
> > by2<-factor(X)
> >
> > W<-aggregate(x=Count,by=list(by1,by2),FUN="sum")
> >
> >
> >
> > The results I get following the form:
> >
> >
> >
> > >W
> >
> >   Group.1 Group.2 x
> >
> > 1       1     0.1 4
> >
> > 2       2     0.1 7
> >
> > 3       3     0.1 1
> >
> > 4       1     0.2 3
> >
> > 5       3     0.2 4
> >
> > 6       3     0.3 4
> >
> >
> >
> >
> >
> > However, what I really want is an aggregation which includes the zero
> > values, i.e.:
> >
> >
> >
> > >W
> >
> >   Group.1 Group.2 x
> >
> > 1       1     0.1 4
> >
> > 2       2     0.1 7
> >
> > 3       3     0.1 1
> >
> > 4       1     0.2 3
> >
> >         2     0.2 0
> >
> > 5       3     0.2 4
> >
> > 1        0.3 0
> >
> > 2        0.3 0
> >
> > 6       3     0.3 4
> >
> >
> >
> >
> >
> > How can I achieve what I want?
> >
> >
> >
> > Best regards,
> >
> > Ioanna
> >
> > ______________________________________________
> > 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.
> 
> ____________________________________________________________
> GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at
> 
> webmails
> 
> ______________________________________________
> 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.