[R] need descriptive help

[Rui Barradas]

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-help at 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.