我想根据两个条件删除一些行。这是我的代码:
test <-datasetjoin[!(datasetjoin$Occupation == "Clerical" & datasetjoin$AvgMonthSpend > 58.515 ),]
test <- test[!(test$Occupation == "Management" & test$AvgMonthSpend > 59.24 ),]
test <- test[!(test$Occupation == "Manual" & test$AvgMonthSpend > 54.28 ),]
test <- test[!(test$Occupation == "Professional" & test$AvgMonthSpend > 60.08 ),]
test <- test[!(test$Occupation == "Skilled Manual" & test$AvgMonthSpend > 57.06 ),]
test <- test[!(test$NumberCarsOwned == "1" & test$YearlyIncome > (81300-51140) * 1.5 + 81300),]
有没有更加优雅的方式来实现相同的结果呢?
提前致谢。
Occupation MonthlySpend
Clerical 60
Management 59
Clerical 62
Clerical 58
Clerical 63
Management 56
Management 58
如果职业为文员且每月支出大于60,则删除这些行。 如果职业为管理人员且每月支出大于57,则删除这些行。 最终结果应该是这样的:
Occupation MonthlySpend
Clerical 58
Management 56