Skip to content
Advertisement

How to create multiple lists with the sum of different columns?

I have a large data set of machine speeds per simulation. I have a column or which simulation it is as well as columns for the different machines. Now I would like to have different lists of the sum of each machine per simulation so that I can do analysis on this as well as create plots for it.

Here is a MRS:

JavaScript

I know that using works, but this just does it for one machine. Meanwhile I have about 20 and would like to know if there is an easier way (if lists are not the best solution I am also open to all suggestions):

JavaScript

Advertisement

Answer

You can filter rows by list, here range and then aggregate sum:

JavaScript
User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement