Adding values from one column to another with missing values in the second column using R

Question

I want to add just some specific values from column z in dataframe df2 into dataframe df1, but just for the id = 1 and id = 3.

I have already tried solutions with ifelse, but for the missing values that kind of solutions work for the first value, until find the first missing gap.

 df1$z <- ifelse((df1$id == df2$id), df2$z, 0)

Examples of the data:

 df1 <- read.table(text = "
 id  v    w   
 1   20   B
 3   30   T

     ", h = T)

 df2 <- read.table(text = "
 id  z   b  c  d  e  f  g  h  i  j
 1   100   z  w  e  r  y  w  u  y  q
 2   800   t  q  j  n  m  q  i  x  z
 3   700   f  e  q  b  a  i  e  p  w
 4   300   a  b  c  d  a  g  s  y  q"                 
                   , h = T)

Expected result:

  df1_add <- read.table(text = "
  id  v    w   z 
  1   20   B  100
  3   30   T  700
                ", h = T)

What about merge merge(df1, df2[c("id", "z")])

akrun
– akrun

2019-04-17 12:41:20 +00:00
Commented Apr 17, 2019 at 12:41 — akrun
– akrun, Commented Apr 17, 2019 at 12:41
@akrun It works pretty good thank you!

A89
– A89

2019-04-17 13:02:13 +00:00
Commented Apr 17, 2019 at 13:02 — A89
– A89, Commented Apr 17, 2019 at 13:02

tomasu · Accepted Answer · 2019-04-17 12:54:05Z

2

Let's use left_join() and select() from the dplyr package:

library(dplyr)

df1_add <- df1 %>%
  left_join(df2 %>% select(id, z))

df1_add

  id  v w   z
1  1 20 B 100
2  3 30 T 700

answered Apr 17, 2019 at 12:54

tomasu

1,43811 silver badges11 bronze badges

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

1 Comment

A89 Over a year ago

Thank you @tomasu, I really want to use dplyr package but I didn't know how to use it.

Cettt · Accepted Answer · 2019-04-17 12:46:33Z

1

you can try this

df_add <- df1
df_add$z = df2[df2$id %in% c(1, 3), ]$z

answered Apr 17, 2019 at 12:46

Cettt

12k8 gold badges40 silver badges61 bronze badges

Comments

akrun · Accepted Answer · 2019-04-17 14:40:50Z

1

We can use merge from base R

merge(df1, df2[c("id", "z")])

answered Apr 17, 2019 at 14:40

akrun

891k38 gold badges590 silver badges700 bronze badges

Collectives™ on Stack Overflow

Adding values from one column to another with missing values in the second column using R

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related