/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 vote221 views1 answer
Automatically wrap r text label ggplot
R
0 vote212 views1 answer
How to substring in R from position
R
0 vote244 views1 answer
How to source all fies from a directory in r
R
1 vote238 views1 answer
Read csv online r
R
0 vote218 views1 answer
Remove all trailing whitspaces R
R
0 vote204 views1 answer
Dotted y intercept line in ggplot
R
0 vote214 views1 answer
Generate pair with one same variable in r
R
0 vote226 views1 answer
Sequence r
R
0 vote223 views2 answers
Linear regression r text label coefficient ggplot
R
0 vote223 views1 answer
Reorder factors in r
R