r语言 - 如果在多个条件下运行，则无错误，但数据不会更改

Question

我试图用中值条件来估算缺失的数据，没有错误，但数据没有改变。为什么以及如何让它发挥作用？

housing = read.csv('housingsample22.csv')
if (housing$Car == 0 && housing$Tunit == 1) {
housing$Car = median(housing$Car)
}
if (housing$Landsize == 0 && housing$Tunit != 1) { 
housing$Landsize = median(housing$Landsize)
}
if (housing$BuildingArea == 0 && housing$TTHouse == 1) {
housing$BuildingArea = median(housing$BuildingArea[housing$TTHouse == 1])
}

Answer 1

数据没有更改是有原因的。以第一个条件为例：

if (housing$Car == 0 && housing$Tunit == 1) 
{housing$Car = median(housing$Car)}

您正在检查整列是否等于零。它肯定只需要第一个元素来评估条件。

你可以做什么：

require(dplyr)
median_car = median(housing$Car)
housing = housing %>% 
mutate(Car = if_else(Car == 0 & Tunit == 1,median_car,Car))

您可以将其他3条语句类似地写在一起。让我知道这是否有效。