/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 vote364 views1 answer
Rmarkdown section title as variable ##
R
3 votes375 views4 answers
How to read csv file in r
R
0 vote336 views1 answer
Truncate string in r
R
1 vote350 views1 answer
Fuction in r
R
1 vote349 views1 answer
Read csv online r
R
0 vote352 views3 answers
Turn row names into column in r
R
1 vote357 views1 answer
R dataframe filter endswith
R
0 vote376 views1 answer
How to read a vector input in r
R
1 vote344 views2 answers
Remove line with na r
R
-2 votes369 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