/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 vote110 views1 answer
Read delim in r with lapply read.delim sep
R
1 vote111 views1 answer
Why is correlation na in r
R
0 vote107 views1 answer
How the print backslash in r
R
0 vote114 views1 answer
Geom_point transparency
R
1 vote131 views1 answer
Scale between 0 and 1 r
R
0 vote102 views1 answer
Histogram r add line
R
0 vote123 views1 answer
R: foreach multiple argument
R
0 vote119 views1 answer
Reorder factors in r
R
0 vote107 views1 answer
Change labels in legend R
R
0 vote134 views2 answers
How to round all numeric column types in r
R