Here's a nifty twist on it.

#!/bin/perl use strict; use warnings; my ( $name, $avg ); while (<DATA>) { my @list; ( $name, @list ) = split /,/; my $sum = 0; $sum += $_ for @list; $avg = $sum / scalar @list; write; } format STDOUT= @<<<< @#.## $name,$avg . __DATA__ AAA01,1.45,0.42,1.54,1.49,1.47,1.36,1.81,0.47,1.8,0.55 ABA05,1.29,1.09,1.13,1.88,1.11,1.44,1.25,1.23,1.05,1.39 BCD06,4.58,4.24,3.87,3.9,4.13,2.04,3.34,7.6,3.58,1.26,7.45 DFG12,26,26.34,24.59,26.46,26.24,26.14,32.35,31.77,31.77 MJK82,8.27,13.23,7.73,8.85,9.15,13.95,0,0,0,0,0 POU45,3.07,3.14,2.97,3.28,21.65,54.23,3.16,3.02,3.26 RTY76,1.22,1.3,1.11,0.92,1.57,1.06,1.01,0.87,0.93 SDH45,15.38,12,22.32,23.3,19.74,46.42,2.06,1.7,2.17 WPL02,13.24,13.23,7.73,8.85,9.15,13.95,0,0,0,0,0

The output you get is:

AAA01 1.24 ABA05 1.29 BCD06 4.18 DFG12 27.96 MJK82 5.56 POU45 10.86 RTY76 1.11 SDH45 16.12 WPL02 6.01

Hope this helped,
-v.

"Perl. There is no substitute."

In reply to Re: Calculating Row Averages From a CSV File by Velaki
in thread Calculating Row Averages From a CSV File by rayv

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.