Update table with another table values (several columns) in R

Question

I am trying in R to update a table A with another table B only when values in table B are not NA. For example, if table A is:

and table B is:

I would like to have, as a result:

Would anyone the best way to do that?

How do I ask and answer homework questions? How much research effort is expected of Stack Overflow users? How to Ask Help center minimal reproducible example Why should I not upload images of code/data/errors when asking a question? Why are images of text, code and mathematical expressions discouraged? — philipxy
– philipxy, Commented Aug 2, 2022 at 19:51

Julien · Accepted Answer · 2022-08-02 13:10:30Z

1

library(tidyverse)
A <- tribble(
  ~ name, ~X1, ~X2, ~X3,
  "AX", 1, 1, NA,
  "BL", 6, 1, 3,
  "CD",NA, 4, 6,
  "DA", 4, NA, NA)

B <- tribble(
  ~ name, ~X1, ~X2, ~X3,
  "AX", 4, 5, 6,
  "BL", NA, 3, 4,
  "DA", NA, 4, 6)

bind_rows(A, B) %>% 
  group_by(name) %>% 
  summarise(across(everything(), ~ ifelse(!is.na(last(.)), last(.), first(.))))

  name     X1    X2    X3
  <chr> <dbl> <dbl> <dbl>
1 AX        4     5     6
2 BL        6     3     4
3 CD       NA     4     6
4 DA        4     4     6

edited Aug 2, 2022 at 13:10

answered Aug 2, 2022 at 12:28

Julien

1,8881 gold badge15 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update table with another table values (several columns) in R

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related