Replace empty values with value from other column in a dataframe

Question

In one column of my dataframe I have some empty cells. The data looks like this:

   yymmdd    lat   lon mag depth knmilocatie baglocatie   tijd
 19861226 52.992 6.548 2.8   1.0       Assen      Assen  74751
 19871214 52.928 6.552 2.5   1.5   Hooghalen            204951
 19891201 52.529 4.971 2.7   1.2   Purmerend    Kwadijk 200914
 19910215 52.771 6.914 2.2   3.0       Emmen      Emmen  21116
 19910425 52.952 6.575 2.6   3.0   Geelbroek    Ekehaar 102631
 19910808 52.965 6.573 2.7   3.0     Eleveld      Assen  40114

The desired result is:

   yymmdd    lat   lon mag depth knmilocatie baglocatie   tijd
 19861226 52.992 6.548 2.8   1.0       Assen      Assen  74751
 19871214 52.928 6.552 2.5   1.5   Hooghalen  Hooghalen 204951
 19891201 52.529 4.971 2.7   1.2   Purmerend    Kwadijk 200914
 19910215 52.771 6.914 2.2   3.0       Emmen      Emmen  21116
 19910425 52.952 6.575 2.6   3.0   Geelbroek    Ekehaar 102631
 19910808 52.965 6.573 2.7   3.0     Eleveld      Assen  40114

Inspired by this solution, I tried to replace the empty cells with:

df$baglocatie[df$baglocatie == ""] <- df$knmilocatie

However, this did not work as the empty cells were filled with the wrong values. Another possible solution also didn't work.

How do I solve this?

zx8754 · Accepted Answer · 2014-01-17 09:17:10Z

15

Try ifelse:

df$baglocatie <- ifelse(df$baglocatie == "", df$knmilocatie, df$baglocatie)

answered Jan 17, 2014 at 9:17

zx8754

56.7k12 gold badges131 silver badges229 bronze badges

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

Comments

Beasterfield · Accepted Answer · 2014-01-17 09:12:45Z

5

You need to index also the replacing column:

df[ df$baglocatie == "", "baglocatie"  ]  <- df[ df$baglocatie == "", "knmilocatie" ]

answered Jan 17, 2014 at 9:12

Beasterfield

7,1332 gold badges43 silver badges49 bronze badges

1 Comment

zx8754 Over a year ago

Coming across this post after 8 years, I think this is the correct answer, not mine.

Jaap · Accepted Answer · 2018-11-20 16:09:56Z

3

Or you can use a support vector:

empty <- df$baglocatie == ""
df$baglocatie[empty] <- df$knmilocatie[empty]

edited Nov 20, 2018 at 16:09

Jaap

83.7k36 gold badges190 silver badges203 bronze badges

answered Nov 20, 2018 at 14:52

LuigiZ

311 bronze badge

Collectives™ on Stack Overflow

Replace empty values with value from other column in a dataframe

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related