I'm working with video data for drug phenotypes on some mutant cell lines. Output is thousands of columns of pixel intensity data vs time (each row being a new frame of the video). I want to normalise the data in each column against an average of the first 10 data points from that column. I'm no geek btw, so go easy!!
I need to take an average of the first 10 rows of the column (and store that average in a new column or document) But I can't work out how to ONLY do that calculation on the first 10 rows rather than on the whole column (147 rows in total)
I need to divide every data point in the column by that average (I can probably work this one out myself, once I've got the answer to question 1!)
Here's an example of the data
Thanks very much!! Ewan