/R/Replace na in a column with values from another df

Replace na in a column with values from another df

library(dplyr)

df1 %>% inner_join(df2, by= "ID") %>%
  mutate(Count = coalesce(Count.x, Count.y)) %>%
  select(ID, Count)

#   ID Count
# 1 11   345
# 2 22   456
# 3 33   786
# 4 44   765
# 5 55   890
# 6 66   888
# 7 77   654

Source: stackoverflow.com

Similar codes

1 vote235 views1 answer
R value statistics
R
0 vote224 views2 answers
R predict type = prob
R
1 vote233 views1 answer
Suppress error r
R
0 vote240 views1 answer
Extract first element before a character stringr
R
0 vote251 views2 answers
Remove column from matrix r
R
0 vote204 views1 answer
Combine row for every element of vector r
R
0 vote245 views1 answer
Remove all trailing whitspaces R
R
0 vote237 views1 answer
Summary metrics of confusion matrix
R
1 vote274 views1 answer
Remove rows in r based on row number using dplyr
R
1 vote256 views1 answer
How to combine all columns into one column in r
R