/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 vote247 views3 answers
How to remove null values in r
R
0 vote257 views1 answer
R remove insignificant coefficient in output
R
5 votes340 views2 answers
Use packages in r
R
0 vote290 views1 answer
R - remove scientific notations
R
0 vote258 views3 answers
Turn row names into column in r
R
3 votes246 views1 answer
R remove row dataframe
R
0 vote224 views1 answer
Seperate words in column r
R
-1 vote256 views1 answer
Legend in R
R
0 vote251 views2 answers
Linear regression r text label coefficient ggplot
R
0 vote279 views1 answer
R find n largest
R