[R] need descriptive help

[mkm1616]

Thank you Rui. Appreciate the help.

Apologies for "badgering" the msg board. lol

On Jun 5, 11:28 am, Rui Barradas <ruipbarra... at 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... at 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... at 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 -