/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 vote250 views1 answer
R box plots
R
-2 votes204 views2 answers
What percentage of the row will the following column occupy on desktop devices: <div class="col-xs-3 col-sm-4 col-md-6 col-lg-12"></div>
R
1 vote206 views2 answers
Remove row from matrix r
R
0 vote209 views1 answer
Two string in one string r
R
0 vote190 views1 answer
How the print backslash in r
R
0 vote220 views1 answer
Change the font of the title in a plot in r
R
0 vote232 views2 answers
Count r
R
0 vote198 views1 answer
Get plot title over two lines R
R
1 vote207 views1 answer
R range with step
R
0 vote208 views1 answer
R change column based on condition
R