how to replace particular value in column using R

Question

Below is the data set for reference X1

X1 <- data.frame(A = c(2,3,4,5,6,7),
                 B = c(0,0,0.23,1.7,2.45,84.5))  
#  A     B
#1 2  0.00
#2 3  0.00
#3 4  0.23
#4 5  1.70
#5 6  2.45
#6 7 84.50

Now i need to replace values greater than 0 as 1

Lots of different ways to do this, but I personally like replace: `df$B <- replace(df$B, df$B>0, 1)` — Mike H., Dec 22 '17 at 13:38

score 1 · Answer 1 · answered Dec 22 '17 at 13:38

1

With:

X1$B <- as.integer(X1$B > 0)

The result:

answered Dec 22 '17 at 13:38

h3rm4n

4,126
15
21

1

@MichaelChirico No, he said "greater than 0 as 1". – Rui Barradas Dec 22 '17 at 14:22

score 0 · Answer 2 · answered Dec 22 '17 at 13:48

So your data.frame is:

X1<-data.frame(A=2:7,B=c(0,0,0.23,1.7,2.45,84.5))

and you want to replace all the values greater than 0 in the column B with 1. Use can use the standard built-in sub-replace function of '[<-', i.e.:

X1[X1[,"B"]>0,"B"]<-1

i.e. check if the values in the column B are greater than zero and if true replace them with 1.

how to replace particular value in column using R

2 Answers2