Replacing '?' in a dataframe in R with ZEROs in R

Question

I need help with replacing '?' on my data frame with Zeros in R language.

any help will be highly appreciated. Regards

Please provide a reproducible example. – Felix Grossmann Aug 15 '17 at 09:56 — Felix Grossmann, Aug 15 '17 at 09:56

score 0 · Answer 1 · answered Aug 15 '17 at 10:05

0

df <- data.frame(
  A=c(1,"?",3),
  B=c(1:3),
  C=c("a", "b", "?")
)

df <- apply(df, MARGIN = 2, FUN = function(x) {
  x[x == "?"] <- 0
  x
})
as.data.frame(df)
#   A B C
# 1 1 1 a
# 2 0 2 b
# 3 3 3 0

answered Aug 15 '17 at 10:05

Arkadii Kuznetsov

479
5
13

`df[ df == "?" ] <- 0` should work, too. – zx8754 Aug 15 '17 at 10:21
Thanks all. it worked. – emudria Aug 15 '17 at 12:14
`df[ df == "?" ] <- 0` not work with factors without zero. `invalid factor level, NA generated` – Arkadii Kuznetsov Aug 15 '17 at 13:14
You could convert them into character and apply what @zx8754 has suggested. Seems simpler. – creativename Aug 15 '17 at 14:28

Replacing '?' in a dataframe in R with ZEROs in R

1 Answers1