FLBB

values in csv

Discussion created by FLBB on Apr 30, 2014
Latest reply on Apr 30, 2014 by hua17
I have a csv that looks like this:

A,B,C,D
(Newline)
2,3,4,feature_1
1,2,4,feature_1
#Average line "","",4
(Newline)
3,6,7,feature_2
1,2,6,feature_2
#Average line "","",""6.5

I want to be able to take the rows for each "feature" and write another line that takes the average of the values in column "C". I have inserted comments for your convenience.

Outcomes