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

[joe82]

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.