/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 vote169 views1 answer
List all installed packages in r
R
0 vote135 views1 answer
Strtrim in r
R
0 vote133 views4 answers
Convert first row to header in r
R
1 vote153 views1 answer
Scale between 0 and 1 r
R
0 vote148 views1 answer
Required in r
R
0 vote137 views3 answers
How to remove null values in r
R
0 vote137 views1 answer
Reverse row order dataframe R
R
0 vote172 views1 answer
How to change the font of the xlab in plot in r
R
0 vote141 views1 answer
How to enter character string with quotes in r
R
0 vote170 views1 answer
R - transform as factor
R