How to substitute values in one row column based on values in another column?

Question

I have the following data:

#ID    DV    MDV#
  1     2     1
  2     3     0
  3     0     0
  4     .     0

I want the following: Whenever DV column has a non-zero number, the MDV column should be 0 and vice-versa. If DV has a zero value (or missing value), MDV should be 1 for that ID.

#ID    DV    MDV#
  1     2     0
  2     3     0
  3     0     1
  4     .     1

How do I code this?

I refuse to beleive that you did a minimal effort of finding an answer yourself and wasn't successful — David Arenburg
– David Arenburg, Commented Jun 16, 2014 at 20:56

sds · Accepted Answer · 2017-09-26 14:29:51Z

2

If you have a data.frame f, then you can do

f$MDV[f$DV > 0] <- 0

to set MDV to zero whenever DV is positive.

edited Sep 26, 2017 at 14:29

answered Jun 16, 2014 at 18:56

sds

60.5k31 gold badges178 silver badges304 bronze badges

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

Comments

Rich Scriven · Accepted Answer · 2014-06-16 19:44:37Z

0

ifelse might do the trick for you here.

Read your data:

> d <- read.table(h=T, text = "ID    DV    MDV
   1     2     1
   2     3     0
   3     0     0
   4     .     0", stringsAsFactors = FALSE)

Since "." > 0 is FALSE, we can reset the MDV column according to your specifications of the DV column as follows:

> d$MDV <- ifelse(d$DV > 0, 0, 1)
> d
#   ID DV MDV
# 1  1  2   0
# 2  2  3   0
# 3  3  0   1
# 4  4  .   1

edited Jun 16, 2014 at 19:44

answered Jun 16, 2014 at 19:10

Rich Scriven

99.8k11 gold badges191 silver badges252 bronze badges

Collectives™ on Stack Overflow

How to substitute values in one row column based on values in another column?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related