To summary data

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

To summary data

mrzung
hi all,

my data is here,
--------------------------------------------------------------------------------------------------
data

  clss number
1    A      1
2    B      2
3    C      3
4    A      4
5    B      5
6    C      6
7    A      7
8    B      8
9    C      9
-----------------------------------------------------------------------------------------------------
I want to this format

clss number
A      12
B      15
C      18

is there a way to solve this problem?
Reply | Threaded
Open this post in threaded view
|

Re: To summary data

Berend Hasselman

On 14-05-2012, at 07:14, mrzung wrote:

> hi all,
>
> my data is here,
> --------------------------------------------------------------------------------------------------
> data
>
>  clss number
> 1    A      1
> 2    B      2
> 3    C      3
> 4    A      4
> 5    B      5
> 6    C      6
> 7    A      7
> 8    B      8
> 9    C      9
> -----------------------------------------------------------------------------------------------------
> I want to this format
>
> clss number
> A      12
> B      15
> C      18
>
> is there a way to solve this problem?

?aggregate

mydata <- data.frame(clss=rep(c("A","B","C"),rep=3),number=1:9, stringsAsFactors=FALSE)
aggregate(number ~ .,data=mydata,sum)

Berend

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: To summary data

John Kane
In reply to this post by mrzung
One way is to use the reshape2 package
===============================
library(reshape2)
dcast(xx,  A ~ . , sum)
================================

John Kane
Kingston ON Canada


> -----Original Message-----
> From: [hidden email]
> Sent: Sun, 13 May 2012 22:14:02 -0700 (PDT)
> To: [hidden email]
> Subject: [R] To summary data
>
> hi all,
>
> my data is here,
> --------------------------------------------------------------------------------------------------
> data
>
>   clss number
> 1    A      1
> 2    B      2
> 3    C      3
> 4    A      4
> 5    B      5
> 6    C      6
> 7    A      7
> 8    B      8
> 9    C      9
> -----------------------------------------------------------------------------------------------------
> I want to this format
>
> clss number
> A      12
> B      15
> C      18
>
> is there a way to solve this problem?
>
> --
> View this message in context:
> http://r.789695.n4.nabble.com/To-summary-data-tp4629887.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> [hidden email] 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.

____________________________________________________________
FREE ONLINE PHOTOSHARING - Share your photos online with your friends and family!
Visit http://www.inbox.com/photosharing to find out more!

______________________________________________
[hidden email] 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.