[R] Data Manipulations - Group By equivalent

From: zubin <binabina_at_bellsouth.net>
Date: Sun 02 Jul 2006 - 10:05:06 EST

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@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 Sun Jul 02 10:10:36 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Thu 03 Aug 2006 - 04:15:48 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.