/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

3 votes381 views2 answers
R random number
R
0 vote365 views1 answer
Getting rid of row names in R
R
1 vote321 views1 answer
R pipe
R
0 vote332 views1 answer
How to filter a vector by location in r
R
0 vote367 views1 answer
Remove the colour name from ggplot
R
0 vote391 views1 answer
Add another 'color' condition to jitter with ggboxplot
R
0 vote340 views1 answer
Extract r squared from lm in r
R
0 vote357 views1 answer
How to format a number in r
R
3 votes441 views3 answers
Rename variables in r
R
0 vote412 views1 answer
R find n largest
R