Skip to content
Prev 318582 / 398503 Next

replace zeros for NA in a column based on values of another column

Camilo Mora 
Hi everyone,

Imagine that I have a data frame with four columns:
data<-
a       b       c       d
0       1       1       0
1       1       1       1
1       0       0       1

I want to replace the zeros in columns a:b for NA only for the rows in  
which column d are zero. So

a       b       c       d
NA      1       1       0
1       1       1       1
1       0       0       1

I am trying this:
data[,1:3][data[4] == 0] <- NA
But get this error:

Error in `[<-.data.frame`(`*tmp*`, Data[4] == 0, value = NA) :
   only logical matrix subscripts are allowed in replacement

Does anyone knows the reason of this error or is there an alternative  
to replace the values in one column based on the values of another?

Thanks,

Camilo

Camilo Mora, Ph.D.
Department of Geography, University of Hawaii
http://www.soc.hawaii.edu/mora/

Thread (6 messages)

Camilo Mora replace zeros for NA in a column based on values of another column Mar 2 Anthony Damico replace zeros for NA in a column based on values of another column Mar 2 Rui Barradas replace zeros for NA in a column based on values of another column Mar 2 Petr Suvorov (Quetzalcoatlus) how to log out from the conference Mar 2 arun replace zeros for NA in a column based on values of another column Mar 2 Rui Barradas replace zeros for NA in a column based on values of another column Mar 2