/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

3 votes410 views3 answers
R set dataframe column names
R
2 votes387 views1 answer
Setwd in r
R
1 vote389 views1 answer
Scale between 0 and 1 r
R
0 vote408 views1 answer
How to tell if a variable is discrete or continuous in r
R
0 vote401 views1 answer
How to use par() in R
R
0 vote403 views1 answer
Base R change axis line width
R
1 vote396 views1 answer
Add a vertical line in ggplot
R
0 vote392 views1 answer
Dotted y intercept line in ggplot
R
0 vote423 views5 answers
Identify multiple spellings in R
R
5 votes592 views6 answers
Rename column in r
R