Breaking News: Grepper is joining You.com. Read the official announcement!

remove na after pivot_wider

Trustworthy Whale answered on October 17, 2022 Popularity 1/10 Helpfulness 1/10

answer remove na after pivot_wider

remove na after pivot_wider

Comment

df <- data.frame(col_1 = c("A", "A", "A", "A", "A", "A", "B", "B", "B"), 
                 col_2 = c(1, 3, NA, NA, NA, NA, 4, NA, NA),
                 col_3 = c(NA, NA, 2, 5, NA, NA, NA, 5, NA),
                 col_4 = c(NA, NA, NA, NA, 5, 6, NA, NA, 7))

df %>% dplyr::group_by(col_1) %>% 
  dplyr::summarise_all(purrr::discard, is.na)

Popularity 1/10 Helpfulness 1/10 Language r

Source: stackoverflow.com

Tags: na r

Link to this answer
Share Copy Link