/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 vote184 views2 answers
Count r
R
0 vote178 views1 answer
Ggplot - subset top 10 in a stack bar plot
R
1 vote192 views1 answer
R range with step
R
0 vote179 views4 answers
Convert first row to header in r
R
2 votes210 views2 answers
Read excel in r
R
0 vote190 views1 answer
Convert all numeric columns to percentages R
R
3 votes452 views2 answers
Mode in r
R
0 vote164 views1 answer
Autoplot confusion matrix
R
0 vote176 views1 answer
Ggplot box plot without outliers poins
R
1 vote199 views1 answer
Find data types in list r
R