Re: [R] How to substract a valur from dataframe with condition

From: <Bill.Venables_at_csiro.au>
Date: Tue, 22 Mar 2011 12:45:34 +1100

dat <- within(dat, {
	X2 <- ifelse(X2 > 50, 100-X2, X2)
	X3 <- ifelse(X3 > 50, 100-X3, X3)

})  

-----Original Message-----
From: r-help-bounces_at_r-project.org [mailto:r-help-bounces_at_r-project.org] On Behalf Of joe82 Sent: Tuesday, 22 March 2011 7:40 AM
To: r-help_at_r-project.org
Subject: [R] How to substract a valur from dataframe with condition

Hello All,

I need help with my dataframe, it is big but here I am using a small table as an example.

My dataframe df looks like:

        X1 X2 X3

1   2011-02  0.00 96.00
2   2011-02  0.00  2.11
3   2011-02  2.00  3.08
4   2011-02  0.06  2.79
5   2011-02  0.00 96.00
6   2011-02  0.00 97.00
7   2011-02  0.08  2.23

I want values in columns X2 and X3 to be checked if they are greater than 50, if yes, then subtract from '100'

df should look like:

       X1 X2 X3

1   2011-02  0.00 4.00
2   2011-02  0.00  2.11
3   2011-02  2.00  3.08
4   2011-02  0.06  2.79
5   2011-02  0.00 4.00
6   2011-02  0.00 3.00
7   2011-02  0.08  2.23


Please help, I will really appreciate that.

Thanks,

Joe

--
View this message in context: http://r.789695.n4.nabble.com/How-to-substract-a-valur-from-dataframe-with-condition-tp3394907p3394907.html
Sent from the R help mailing list archive at Nabble.com.


______________________________________________
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.
______________________________________________
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.
Received on Tue 22 Mar 2011 - 01:50:41 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 22 Mar 2011 - 04:00:23 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive