R按列值子集行
示例
内置的功能子集可以rows与columns该满足的条件。
df <- data.frame(item = c(1:10),
price_Elasticity = c(-0.57667, 0.03205, -0.04904, 0.10342, 0.04029,
0.0742, 0.1669, 0.0313, 0.22204, 0.06158),
total_Margin = c(-145062, 98671, 20576, -56382, 207623, 43463, 1235,
34521, 146553, -74516))为了找到rows有price_Elasticity>0：
df[df$price_Elasticity>0,]
item price_Elasticity total_Margin 2 2 0.03205 98671 4 4 0.10342 -56382 5 5 0.04029 207623 6 6 0.07420 43463 7 7 0.16690 1235 8 8 0.03130 34521 9 9 0.22204 146553 10 10 0.06158 -74516
基于price_Elasticity>0和的子集total_Margin>0：
df[df$price_Elasticity>0&df$total_Margin>0,]
item price_Elasticity total_Margin 2 2 0.03205 98671 5 5 0.04029 207623 6 6 0.07420 43463 7 7 0.16690 1235 8 8 0.03130 34521 9 9 0.22204 146553