Issue in Script

Shell Programming and Scripting
1

I developed a script to group by 1st column and sum few of the column which are required, but while executing sum of 2nd column which has decimals in place is not getting correct sum. below is the script

 awk -F, '{a[$1]+=$2;b[$1]+=$33;c[$1]+=$58;d[$1]+=$11;e[$1]+=$50;}END{for(i in a)printf i","("%f\n"),a","b","c","d","e;}'  input.csv > "output.txt"

Attached the input and output file for furhter reference.

2

Looks like your printf lost control as its format specifier is gone haywire... try a

...
print i "," a "," b "," c "," d "," e
        }
' /tmp/Input.csv 
19-APR-16,4.0989e+07,37193.6,0,4593893,430183
09-APR-16,4.1128e+07,36546.1,0,3693883,351456
18-APR-16,4.23129e+07,38921.6,0,3717989,355104
.
.
.

instead, and you're almost there.

You field count is 56 consistently, so your c[$1]+=$58 array assignment is doomed.

3

Or

printf "%s,%f,%s,%s,%s,%s\n", i, a, b, c, d, e}