Thank you Rui. Appreciate the help. Apologies for "badgering" the msg board. lol
On Jun 5, 11:28 am, Rui Barradas <ruipbarra...@sapo.pt> wrote: > Hello, > > Try > > Total <- aggregate(cost~patient, data=x) > Total[Total$cost > 1000, ] > > As for writing to a csv file, see ?write.csv > > Hope this helps, > > Rui Barradas > > Em 05-06-2012 16:34, mkm1616 escreveu: > > > > > > > Hi all, I'm new to using R, and apologize for simplicity of this > > question. > > > I'm using a data set with over 60,000 observations, Two variables are > > patient ID, and cost incurred by the patient. I'd like to generate > > frequency/table by patient and cost IF the total cost is over 2000. > > > Right now I'm using: > > > by(x$cost, x$patient, sum) > > > but this generates a huge list for each patient. > > > What is the best way to either (1) export the output into a csv so I > > can visually inspect each patient or more helpful (2) create the table > > IF sum of cost> 1000 > > > Thanks! > > > ______________________________________________ > > r-h...@r-project.org mailing list > >https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guidehttp://www.R-project.org/posting-guide.html > > and provide commented, minimal, self-contained, reproducible code. > > ______________________________________________ > r-h...@r-project.org mailing listhttps://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guidehttp://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.- Hide > quoted text - > > - Show quoted text - ______________________________________________ R-help@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.
