[R] Data Manipulations - Group By equivalent

Frank E Harrell Jr f.harrell at vanderbilt.edu
Sun Jul 2 02:43:45 CEST 2006


zubin wrote:
> Hello, a beginner R user - boy i wish there was a book on just data 
> manipulations for SAS users learning R (equivalent to the SAS DATA 
> STEP)..  Okay, my question: 
> 
> I have a panel data set, hotel data occupancy by month for 12 months, 
> 1000 hotels.  I have a field labeled 'year' and want to consolidate the 
> monthly records using an average into 1000 occupancy numbers - just a 
> simple average of the 12 months by hotel.  In SQL this operation is 
> pretty easy, a group by query (group by hotel where year = 2005, avg 
> occupancy) - how is this done in R? (in R language not SQL).  Thx!
> 
> -zubin
> 
> ______________________________________________
> R-help at 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
> 

This is in the most basic R documentation.  Please read it.

-- 
Frank E Harrell Jr   Professor and Chair           School of Medicine
                      Department of Biostatistics   Vanderbilt University



More information about the R-help mailing list