/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 vote156 views1 answer
Add column in r
R
1 vote172 views1 answer
Create folder in r
R
1 vote153 views1 answer
How to Convert a Factor in R
R
0 vote156 views3 answers
Make the first row as header in r
R
1 vote175 views1 answer
R dataframe filter endswith
R
-1 vote171 views1 answer
Legend in R
R
6 votes310 views4 answers
Print in r
R
1 vote173 views2 answers
Create a dataframe with column names in r
R
0 vote158 views1 answer
Dotted y intercept line in ggplot
R
6 votes319 views2 answers
Remove na from vector r
R