Replace certain values in all tibble columns with NA

Asked Sep 28 '18 at 23:12

Active Sep 28 '18 at 23:12

Viewed 47 times

In the following tibble how to set the entries with only "-" to NA? I do not want to replace dash in entries like "1-2" with NA, only there where only dash is typed. I have a huge dataset so that would neet to apply to all columns and rows. Thanks!

data_fake <- data.frame(c("1","2","-","3","2","1"),c(1,2,3,4,5,6),c("2-3","3 bundles","4","5","-","1"))

data_fake <- as_tibble(data_fake)

data_fake %>%
        recode(.,"-", NA)

asked Sep 28 '18 at 23:12

MIH

1,083
3
14
26

2

`data_fake[data_fake=='-'] <- NA`? – lukeA Sep 28 '18 at 23:17
4

or `data_fake %>% na_if("-")` – Maurits Evers Sep 28 '18 at 23:19
Such a simple nice command, fantastic and thank you so much! @lukeA! – MIH Oct 01 '18 at 21:50
and @MauritsEvers ! – MIH Oct 01 '18 at 21:51

Replace certain values in all tibble columns with NA

0 Answers0