/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 vote343 views1 answer
Add a vertical line in ggplot
R
0 vote330 views1 answer
Import excel into R
R
0 vote315 views1 answer
Why is only mean and max infinity in r
R
1 vote340 views1 answer
R convert date as timestamp
R
2 votes415 views1 answer
R count number of na
R
0 vote313 views1 answer
Plot3d in r
R
1 vote344 views1 answer
Convert datetime from string r
R
3 votes362 views1 answer
R remove row dataframe
R
0 vote358 views1 answer
Ggplot - blank title of axis
R
0 vote314 views1 answer
Geom_abline vertical line
R