/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 vote233 views1 answer
Correlation matrix using factors r
R
0 vote192 views1 answer
Interquartile in r
R
0 vote201 views1 answer
Save data frames in a loop r
R
0 vote130 views1 answer
Split strings by space in r
R
0 vote207 views1 answer
Base R change axis line width
R
0 vote198 views1 answer
How to remove rows with inf from a dataframe in R
R
1 vote197 views1 answer
For in r
R
0 vote209 views1 answer
Geom_abline vertical line
R
0 vote199 views2 answers
Remove column from matrix r
R
2 votes242 views3 answers
How to use recursion in r
R