Use if else statement in R dataframe

Question

d = data.frame(A=c(1,1),B=c(0,20),C=c(0,10))
d$B[d$B>0] = TRUE
d$C[d$C>0] = TRUE
d$B[d$B==0] = FALSE
d$C[d$C==0] = FALSE

Is there a way to do the 4 last operations in one line to simplify things like an if else statement for dataframe.

You want to do it only for B and C columns leaving A ? — Ronak Shah
– Ronak Shah, Commented Mar 28, 2018 at 4:37
Can the values be negative as well? Or will it be either greater than 0 or 0 ? — Ronak Shah
– Ronak Shah, Commented Mar 28, 2018 at 4:38
I think this should be a duplicate of some question, couldn't find something close, hence answering. — Ronak Shah
– Ronak Shah, Commented Mar 28, 2018 at 4:55

Ronak Shah · Accepted Answer · 2018-03-28 04:54:51Z

3

We can compare the entire dataframe (except the first column) and check if the value is greater than 0 or not and convert that value into numeric

d[-1] <- as.numeric(d[-1] > 0)

d
#  A B C
#1 1 0 0
#2 1 1 1

Or if we want to keep the values as logical we can remove the as.numeric call

d[-1] <- d[-1] > 0

#  A     B     C
#1 1 FALSE FALSE
#2 1  TRUE  TRUE

answered Mar 28, 2018 at 4:54

Ronak Shah

391k20 gold badges173 silver badges237 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

akrun · Accepted Answer · 2018-03-28 05:57:48Z

1

We can use tidyverse

library(dplyr)
d %>%
  mutate_at(2:3, funs(. > 0))
#  A     B     C
#1 1 FALSE FALSE
#2 1  TRUE  TRUE

answered Mar 28, 2018 at 5:57

akrun

891k38 gold badges590 silver badges700 bronze badges

Comments

Suanbit · Accepted Answer · 2018-03-28 07:37:58Z

-1

You can use dplyr's if_else as follows:

library(dplyr)

d = data.frame(A=c(1,1),B=c(0,20),C=c(0,10))

 d$B<-if_else(d$B>0,"TRUE","FALSE")
 d$C<-if_else(d$C>0,"TRUE","FALSE")


  A     B     C
1 1 FALSE FALSE
2 1  TRUE  TRUE

answered Mar 28, 2018 at 7:37

Suanbit

4911 gold badge5 silver badges12 bronze badges

3 Comments

Suanbit Over a year ago

If B>0 return "TRUE", if not "FALSE"

Cath Over a year ago

my point is: your ifelse call returns exactly the same as d$B>0 or actually the same as as.character(d$B>0), which is another part I don't find logical

zx8754 Over a year ago

class("TRUE") vs class(TRUE)

Collectives™ on Stack Overflow

Use if else statement in R dataframe

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related