/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 vote412 views1 answer
Sort in descending order in r
R
0 vote400 views2 answers
%in% in R
R
0 vote385 views1 answer
Mutual information in r
R
1 vote387 views1 answer
R type of all columns
R
0 vote350 views2 answers
Write text r
R
0 vote373 views1 answer
Generate pair with one same variable in r
R
2 votes429 views1 answer
Random integer in r
R
1 vote438 views3 answers
R merge by two columns
R
10 votes536 views3 answers
R replace na with 0
R
3 votes450 views1 answer
R language comment
R