/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 vote306 views2 answers
Animated bar chart race in r
R
1 vote299 views1 answer
R convert string to list of characters
R
1 vote269 views1 answer
"R" concatinate rows
R
0 vote261 views1 answer
Attr(* label )= chr in r
R
0 vote304 views1 answer
Timestamp conversion from excel R
R
0 vote264 views2 answers
R predict type = prob
R
0 vote299 views1 answer
R predict type
R
1 vote266 views1 answer
Create folder in r
R
0 vote274 views1 answer
Delete variable from environment r
R
1 vote272 views1 answer
Name elements in vector r
R