/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 vote154 views1 answer
Utils vs readr and fread
R
0 vote138 views1 answer
Count equal values in a vector
R
2 votes146 views1 answer
Dplyr replace na
R
0 vote142 views1 answer
Truncate string in r
R
0 vote131 views1 answer
Grid.arrange
R
10 votes267 views3 answers
R replace na with 0
R
0 vote137 views1 answer
Geom_jitter transparency
R
1 vote135 views1 answer
R value statistics
R
0 vote133 views1 answer
Str_extract all using mutate and toString
R
0 vote148 views1 answer
How to create dates in a range in R
R