/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 vote170 views1 answer
Visualizing missing values in r
R
3 votes178 views4 answers
Read csv file in r
R
1 vote188 views1 answer
R merge inner join
R
1 vote165 views1 answer
How to split a column in r
R
0 vote161 views1 answer
Add comma every 3 digits in r
R
1 vote151 views1 answer
Add a vertical line in ggplot
R
0 vote146 views1 answer
Disable the y axis in plot r
R
0 vote151 views1 answer
Number of rows by group in r
R
1 vote140 views1 answer
Name elements in vector r
R
1 vote155 views1 answer
Rmarkdown section title as variable ##
R