how to divide a number of columns by one column in

问题:

I have the below dataset: I am doing the below in r:

Monday Tuesday Wednesday Friday Saturday Total
2       3      4          5      6        20
3       6      7          5      1        22

I need to divide 2/20, 3/20, 4/20,5/20,6/20 and on the second row, 3/22,6/22,7/22,5/22,1/22. I can do this by extracting the columns but it is long and tedious,please there must be an easier way please

回答1:

You can simply do

df[,1:5] / df[,6]