/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 vote388 views1 answer
How to tell if a variable is discrete or continuous in r
R
2 votes364 views1 answer
Loop through list in r
R
0 vote403 views1 answer
Add padding to number r
R
4 votes548 views1 answer
How to do linear regression in r
R
0 vote382 views1 answer
R number of blanks in the data
R
0 vote331 views1 answer
Change to posixct in r
R
0 vote309 views1 answer
Change the y ticks in r plot
R
1 vote386 views1 answer
Descending order a list in r
R
1 vote366 views1 answer
Create file in r
R
2 votes342 views1 answer
Linetype ggplot in r
R