用数据框中其他列的值替换空值 [英] Replace empty values with value from other column in a dataframe

问题描述

在我的数据框的一列中，我有一些空单元格。数据如下所示：

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

所需的结果是：

   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?

推荐答案

尝试 ifelse ：

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

这篇关于用数据框中其他列的值替换空值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！