CODEWITHSUNDEEP
bashawk
Ujjawal Khare
Ujjawal Khare

Reputation: 796

Command to sum 2nd colum of csv file

hi i have a csv file which has 2 coloumns first column has names and secons has values. All i want is a script that can sum values of second column and print output in last row of csv as Total

example of file:-

CNG 2128485188
WND 222047363
HUM 283010928
AINGO   253694944

The command i am using is printing in last line but giving total as 0.

$ awk '{print;s+=$2}END{printf "Total %'\''d\n",s}' /cygdrive/c/KPI/test/SCCP_ADMIN_RAW2.csv | tail -10
LIMIT,27789
VDEOT,21109
CELZA,627
DUUNI,26636
EMBLT,1255927
URA,521
MONTE,1789
EGLMO,391
DGTEL,394
Total 0

Upvotes: 16

Views: 22179

Answers (1)

dngot_
dngot_

Reputation: 433

$ awk -F"," '{print;x+=$2}END{print "Total " x}' ./test.csv 
CNG ,1
WND ,2
HUM ,1
AINGO   ,1
Total 5

Upvotes: 27

Related Questions