- 论坛徽章:
- 0
|
多谢
我想统计 很多列的和值
2009-07-16 , 22290001 , 27428.920000000000 , 13 , 653523.000000000000 , 97778.000000000000 , 7822.2400000000000000 , 11775.000000000000 , 602771.160000000000
2009-07-16 , 22290002 , 26548.040000000000 , 4 , 5635.0000000000000000 , 1916.0000000000000000 , 153.2800000000000000 , 6220.0000000000000000 , 36640.320000000000
2009-07-16 , 22290003 , 12232842.280000000000 , 6 , -11495620.000000000000 , 242.0000000000000000 , 19.3600000000000000 , 2215.0000000000000000 , 739214.640000000000
2009-07-16 , 22290004 , 34208.000000000000 , 4 , 12880.000000000000 , 2188.0000000000000000 , 175.0400000000000000 , 7210.0000000000000000 , 52285.040000000000
2009-07-16 , 22290005 , 41837.680000000000 , 2 , 1080.0000000000000000 , 644.0000000000000000 , 51.5200000000000000 , 4455.0000000000000000 , 46780.200000000000
2009-07-16 , 22290006 , 31393.040000000000 , 3 , 1202.0000000000000000 , 798.0000000000000000 , 63.8400000000000000 , 2025.0000000000000000 , 33885.880000000000
2009-07-16 , 22290007 , 54856.360000000000 , 1 , 4450.0000000000000000 , 248.0000000000000000 , 19.8400000000000000 , 200.0000000000000000 , 59278.200000000000
2009-07-16 , 22290008 , 24460.560000000000 , 4 , -268.0000000000000000 , 688.0000000000000000 , 55.0400000000000000 , 4080.0000000000000000 , 27639.600000000000
2009-07-16 , 22290009 , 20854.320000000000 , 2 , 58.0000000000000000 , 164.0000000000000000 , 13.1200000000000000 , 13015.000000000000 , 33776.440000000000
2009-07-16 , 22290010 , 37862.320000000000 , 7 , -49714.000000000000 , 1870.0000000000000000 , 149.6000000000000000 , 12600.000000000000 , -972.0800000000000000
(10 rows)
[postgres@bdttestone ~]$ awk -F , '{a+=$3;b+=$4;c+=$5;d+=$6;e+=$7;f+=$8;g+=$9}END{print a,b,c,d,e,f,g} ' 1.txt
1.25323e+07 46 -10866774 106536 8522.88 63795 1.6313e+06
但是我如果用printf呢
[postgres@bdttestone ~]$ awk -F , '{a+=$3;b+=$4;c+=$5;d+=$6;e+=$7;f+=$8;g+=$9}END{printf "%.2f\n" ,a,b,c,d,e,f,g} ' 1.txt
12532291.52
只能输出 第一个数
还请大家 指点一下 |
|