/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

0 vote196 views1 answer
Count word in a string r
R
0 vote194 views1 answer
Infinite in r
R
0 vote195 views1 answer
How to filter a vector by location in r
R
1 vote219 views1 answer
R combine strings
R
0 vote230 views1 answer
St_combine by variables R
R
0 vote232 views1 answer
Diff division R
R
0 vote212 views2 answers
Insert character into string
R
0 vote194 views1 answer
R read.csv tab delimited
R
0 vote255 views1 answer
Get list of words that are in two lists using set
R
0 vote206 views1 answer
R seq
R