I have some .csv data, containing 10 colums and lots of rows whose number can vary from 10k to several hundred k.
What I would like to do is get average, median, and stdev for every, say, 5000 rows, and append it to the end, and save the data as .xls.
I just did it by hand -- doable, but it's rather tedious and time consuming. How can I do this automatically?
Wacky Races 2012!