Hi all,
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!!
Put simply:
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
https://drive.google.com/open?id=16ZhC-OjNTIpXkWek02BJx2qOgh1Xv889TDTbOdprDYk
Thanks very much!! Ewan
If you are using Linux you should read
head -h
.head -n 10 your_input