/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 vote232 views1 answer
Add column in r
R
0 vote234 views1 answer
WARNING: Rtools is required to build R packages but is not currently installed. Please download and install the appropriate version of Rtools before proceeding:
R
0 vote222 views1 answer
How to remove all attributes from a variables in r
R
0 vote251 views1 answer
Logistic inverse CDF in r
R
0 vote219 views2 answers
R predict type = prob
R
0 vote243 views1 answer
Detect rank deficient in r
R
0 vote254 views1 answer
Getting rid of row names in R
R
2 votes236 views1 answer
Setwd in r
R
1 vote217 views1 answer
Principal component analysis in r
R
0 vote233 views1 answer
Norm,s,inv in r
R