/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 vote155 views1 answer
Read.table tab separator
R
1 vote119 views1 answer
Select all columns except one by name in r
R
0 vote109 views1 answer
R yardstick confusion matrix
R
0 vote115 views1 answer
R check object dimensions
R
0 vote141 views1 answer
Add tab in string r
R
0 vote120 views1 answer
Ggplot_regression_line
R
0 vote122 views1 answer
R total line text file
R
-1 vote124 views2 answers
Export csv file in r
R
2 votes162 views2 answers
How to iterate through a list in r
R
1 vote131 views1 answer
R convert matrix to list of column vectors
R