Re^3: how do I manipulate data in csv file

$ echo " week    power   test     Test_end_date_time
201120   5        1       05-10-2011_16:47
201120   699      17      05-10-2011_16:48
201120   454      1       05-10-2011_16:49
201121   5687     26      12-10-2011_15:47
201121   211      1       12-10-2011_15:48
201121   1231     36      12-10-2011_15:49
201121   171      1       12-10-2011_15:50
201121   677      57      12-10-2011_15:51
201121   178      1       12-10-2011_15:52
" | perl -ane'/^\D/&&next;$c{$F[0]}{T}++;$c{$F[0]}{C}+=$F[2]==1}{print
+f"%s %d %.1f%%\n",$_,$c{$_}{T},$c{$_}{C}/$c{$_}{T}*100 for sort keys%
+c'
201120 3 66.7%
201121 6 50.0%
[download]

Comment on Re^3: how do I manipulate data in csv file Download Code

Replies are listed 'Best First'.
Re^4: how do I manipulate data in csv file by Anonymous Monk on Jul 26, 2011 at 08:49 UTC
Thank you very much, it is very helpful	[reply]