/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 votes273 views1 answer
Normalization in r
R
5 votes279 views6 answers
Rename column in r
R
0 vote210 views1 answer
How to remove duplicates based on the combinations of two columns r
R
0 vote233 views1 answer
R: rename a column
R
0 vote217 views1 answer
Ggplot: boxplot with trendline
R
0 vote216 views1 answer
R remove insignificant coefficient in output
R
0 vote208 views1 answer
Link excel to r
R
1 vote223 views1 answer
R sapply syntax
R
0 vote218 views1 answer
Assert no missing values in r
R
0 vote209 views2 answers
Write text r
R