/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

1 vote273 views1 answer
R mean by group
R
0 vote288 views1 answer
R - extracting specific columns from a data frame
R
0 vote303 views1 answer
R df space in column name
R
0 vote288 views1 answer
Ts object to data frame
R
1 vote282 views2 answers
Load multiple packages in r
R
0 vote214 views1 answer
R replace blank string with na
R
0 vote298 views1 answer
How to get the r2 value in r
R
0 vote283 views1 answer
Rmarkdown how to load workspace
R
0 vote285 views2 answers
Remove column from matrix r
R
1 vote257 views1 answer
KnnImputation in r
R