In R TidyVerse what is command for dropping a record with an NA

Asked Dec 22 '21 at 01:00

Active Dec 22 '21 at 02:06

Viewed 78 times

I would like to filter out rows that have a particular field NA. The reference https://tidyr.tidyverse.org/reference/drop_na.html seems to suggest that drop_na() will do the trick. However, when I use it I have no luck:

library(dplyr)
df <- tibble(x = c(1, 2, NA), y = c("a", NA, "b"))
df %>% drop_na()

I get Error in drop_na(.) : could not find function "drop_na" Help(drop_na()) does not yield useful information.

My R.version is R version 4.1.2 (2021-11-01) and package version of dplyr is ‘1.0.7’

asked Dec 22 '21 at 01:00

Harold Henson

3

`drop_na` requires loading the package `tidyr`. – PaulS Dec 22 '21 at 01:04
3

`drop_na` is in the `tidyr` package, so you'll need to either run `library(tidyr)` or `library(tidyverse)` (which includes both), or use `df %>% tidyr::drop_na()` – Jon Spring Dec 22 '21 at 01:04
A `dplyr` way without `tidyr` could be `df %>% filter(across(everything(), ~ !is.na(.)))` – Martin Gal Dec 22 '21 at 01:09
2

You could also just not load any package and use `na.omit` instead – IceCreamToucan Dec 22 '21 at 01:09
`... %>% filter(complete.cases(x,y))` – r2evans Dec 22 '21 at 01:11

In R TidyVerse what is command for dropping a record with an NA

0 Answers0