How do I calculate a new column with row-dependent operations determined by a grouping label?
I created a stacked table that has a column X corresponding to x-coordinates, a column Label with a grouping label, and finally the Data column. Suppose the set of x-coordinates shared for all collected data are [1,2,3,4,5,6,7,8,9,10], there are three groups A,B,C, and the data are arbitrary numbers. I want to make a new column where the value from Data is normalized within each group (A, B, C) by...