[R] Fw: Need Help - R Programming - Using iteration value to change field names for processing for every iteraion

[Vijaya Kumar Regati]

Hi All,


I have tried in different ways.

Finally I got the solution this way :


for(i in 2:4) {
   test[,paste0("Day",i,".Prod.balc")] <- test[,paste0("Day",i,".Prod.balc")] + test[,paste0("Day",i-1,".Prod.balc")]
}


Please save it for references, if needed in future.
Thanks all for your references.


List Moderator,

You can mark the question as closed now.



With Regards,
Vijaya Kumar Regati
Technical Lead, M3bi India Private Ltd
Work: 040-67064732


________________________________
From: Vijaya Kumar Regati
Sent: Tuesday, May 30, 2017 3:35 PM
To: Jim Lemon
Subject: Re: [R] Need Help - R Programming - Using iteration value to change field names for processing for every iteraion


Thank you for the response.

That did not give me desired output when ran.


But I was able to find 1 solution :


for(i in 2:4) {
   test[,paste0("Day",i,".Prod.balc")] <- test[,paste0("Day",i,".Prod.balc")] + test[,paste0("Day",i-1,".Prod.balc")]
}

Its working now.


With Regards,
Vijaya Kumar Regati
Technical Lead, M3bi India Private Ltd
Work: 040-67064732

________________________________
From: Jim Lemon <drjimlemon at gmail.com>
Sent: Tuesday, May 30, 2017 3:00:39 PM
To: Vijaya Kumar Regati
Subject: Re: [R] Need Help - R Programming - Using iteration value to change field names for processing for every iteraion

Hi Vijaya,
How about:

test_dataframe<-read.table(
 text="Day1.balc Day2.balc Day3.balc Day4.balc
 100        20        30        40
 100        10        10        10",
 header=TRUE)
t(apply(test_dataframe,1,cumsum))

Jim

On Tue, May 30, 2017 at 5:02 PM, Vijaya Kumar Regati
<VijayaKumar.Regati at m3bi.com> wrote:
> Hi,
>
> I am new to R programming, I am trying to work on below requirement. But could not achieve desired result.
> Appreciate if someone can help me on this :
>
> test dataframe :
>   Day1.balc Day2.balc Day3.balc Day4.balc
> x       100        20        30        40
> y       100        10        10        10
>> class(test)
> [1] "data.frame"
>
> My Goal is to accomplish :
> Day2.balc <- Day2.balc + Day1.balc
> Day3.balc <- Day3.balc + Day2.balc
> .
> .
> .
> Day30.balc <- Day30.balc + Day29.balc
>
>     # Testing for first 4 days
>     for (i in 1:4 ) {
>     test$Day[i].balc <- test$Day[i].balc + test$Day[i-1].balc
>     }
>
> I identified the line I have written inside the loop is not the correct one, can someone help me how I can use iteration value(i), for every iteration, as a basis for changing field names since field consists of 1,2,3... for each different day( Day1.balc Day2.balc Day3.balc Day4.balc etc.,).
>
>
> Thanks,
>
> Vijay
>
>
>
> Disclaimer: IMPORTANT NOTICE: This e-mail (including any attachments) are confidential, may contain proprietary or privileged information and is intended for the named recipient(s) only. If you are not the intended recipient, any disclosures, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this email in error, please notify the sender by return e-mail or telephone immediately and permanently delete the message and any attachments.
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
R-help Info Page - Homepage - SfS – Seminar for Statistics<https://stat.ethz.ch/mailman/listinfo/r-help>
stat.ethz.ch
The main R mailing list, for announcements about the development of R and the availability of new code, questions and answers about problems and solutions using R ...


> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
Disclaimer: IMPORTANT NOTICE: This e-mail (including any attachments) are confidential, may contain proprietary or privileged information and is intended for the named recipient(s) only. If you are not the intended recipient, any disclosures, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this email in error, please notify the sender by return e-mail or telephone immediately and permanently delete the message and any attachments.

	[[alternative HTML version deleted]]