[R] Aggregating data (with more than one function)

From: Sivakumaran Raman <sivak1976_at_yahoo.co.in>
Date: Tue 29 Mar 2005 - 11:15:57 EST


I have the data similar to the following in a data frame:

    LastName Department Salary

1   Johnson    IT          56000
2   James      HR          54223
3   Howe       Finance     80000
4   Jones      Finance     82000
5   Norwood    IT          67000
6   Benson     Sales       76000
7   Smith      Sales       65778
8   Baker      HR          56778
9   Dempsey    HR          78999
10  Nolan      Sales       45667
11  Garth      Finance     89777
12  Jameson    IT          56786

I want to calculate both the mean salary broken down by Department and also the
total amount paid out per department i.e. I want both sum(Salary) and mean(Salary) for each Department. Right now, I am using aggregate.data.frame twice, creating two data frames, and then combining them using data.frame. However, this seems to be very memory and processor intensive and is taking a
very long time on my data set. Is there a quicker way to do this?

Thanks in advance,
Siv Raman



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Tue Mar 29 11:20:27 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:30:56 EST