我的数据大概是Name,t1,t2,t3,t4,t5,t6
a,791.51,791.51,786.82,786.82,786.82,786.82
b,3470.4,5076.69,5156.02,5156.02,5156.02,5156.02
c,662.51,562.89,622.66,622.66,627.64,602.74
d,690.89,842.88,735.79,632.16,711.61,822.15
e,560.2,563.44,586.11,578.33,591.4,588.14
f,359.16,369.13,359.16,369.13,369.13,369.13
g,766.56,766.56,739.66,732.94,706.04,672.42
我希望能够生成几个新的变量,new1=t2/t1 -1, new2=t3/t2 -1, new3=t4/t3 -1, new4= t5/t4 -1, new6=t6/t5-1, new7= t6/t1 -1,
请问这样的除了一个一个写公式,还有什么简便的方法吗?因为数据比较大,写起来太费时间了。
谢谢各位了!