[R] DATA SUMMARIZING and REPORTING

[Bert Gunter]

Is this homework? There is a no homework policy here.

And stop posting in HTML --- plain text only-- and learn to use ?dput
to post example data.

-- Bert

Bert Gunter
Genentech Nonclinical Biostatistics
(650) 467-7374

"Data is not information. Information is not knowledge. And knowledge
is certainly not wisdom."
Clifford Stoll




On Wed, Jul 30, 2014 at 5:46 AM, Abhinaba Roy <abhinabaroy09 at gmail.com> wrote:
> Hi R-helpers,
>
> I have dataframe like
>
>   ID_CASE         YEAR_MTH       ATT_1             A1              A2
> A3  CB26A 201302 1 146 42 74  CB26A 201302 0 140 50 77  CB26A 201303 0 128
> 36 77  CB26A 201304 1 146 36 72  CB26A 201305 1 134 36 80  CB26A 201305 0
> 148 30 80  CB26A 201306 0 134 20 72  CB26A 201307 1 125 48 79  CB26A 201309
> 0 122 44 74  CB26A 201310 1 126 37 72  CB26A 201310 1 107 43 75
> I want a final dataframe which will look like
>
>   ID_CASE Period  No.ofChange      %Paid  CB26A 201302-2013042  0.414365
> CB26A 201303-201305 2 0.445245  CB26A 201304-201306 1 0.444444  CB26A
> 201305-201307 2 0.460741  CB26A 201306-201308 1 0.461774  CB26A
> 201307-201309 1 0.451327  CB26A 201308-201310 1 0.461378
> where,
> Period = a time period of 3 months which is shifted by 1 month subsequently
>
> No.ofChange = number of time ATT_1 has changed values in this period
>
> %Paid = sum(A3)/(sum(A1)+sum(A2)) for this period
> E.g. for Period=201302-201304,
> %Paid = (74+77+77+72)/((146+140+128+146)+(42+50+36+36))
>
> Period calculation should start from the first YEAR_MTH for the ID_CASE,
> i.e., if for a ID_CASE first YEAR_MTH is 201301 or 201304 then the period
> should be defined accordingly.
>
> I have a dataframe with 400 unique ID_CASE, I need to do it for all ID_CASE.
>
> How can I do it in R?
>
> Regards,
> Abhinaba
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.