I have a data frame like this:
Vehicle Driver Distance Fuel.Consumption
W01 Alex 22.31 0.58
W01 Alex 93.21 2.48
W02 Brian 122.72 3.22
W02 Brian 22.25 0.5
......
我希望得到以下输出:
我想要这样的输出:
Vehicle Driver Distance Fuel.Consumption Fuel.Efficiency
W01 Alex 115.52 3.06 37.75
W02 Brian 144.97 3.72 38.97
......
只需将每辆车的距离和燃油消耗相加,并计算每辆车的燃油效率。我尝试使用
aggregate()
,但它的效果并不像我想象的那样。aggregate(Distance~Vehicle, df, FUN=sum)
aggregate
的尝试。 - user3710546