/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 vote117 views1 answer
How to change the numbering of rows in r
R
0 vote116 views1 answer
Digits in format and formatc in r
R
0 vote118 views1 answer
Filter only NA column in R
R
0 vote140 views1 answer
Utils vs readr and fread
R
0 vote124 views1 answer
Ggplot increase label font size
R
0 vote121 views1 answer
Ggplot abline thickness
R
12 votes245 views5 answers
Regex examples
R
0 vote141 views1 answer
Getting rid of row names in R
R
2 votes150 views1 answer
Convert latin accents to ascii R
R
0 vote158 views1 answer
Rename variable in r dplyr
R