Shell Programming and Scripting

Hi,

I'm new to shell programming, can anyone help me on this? I want to do following operations -

1. Average salary for each country
2. Total salary for each city

and data that looks like -

salary country city
10000 zzz BN
25000 zzz BN
30000 zzz BN
10000 yyy ZN
15000 yyy ZN

My below code only gives average and sum of salaries in total for all records.

average) echo "Average salary for each country"
awk '{ s += $1; } END { print "sum: ", s, " average: ", s/NR, "no of records: ", NR }' $FILENAME
;;
totalsal) echo "Total salary for each city"
awk '{ s += $1; } END { print "sum of salaries : ", s }' $FILENAME
;;

output -

1. sum: 90000 average: 18000 no of records: 5
2. sum of salaries : 90000


i want this to be done based on column value i.e. -

for country as zzz -
sum: 65000 average: 21666.66 no of records: 3

for country as yyy -
sum: 25000 average: 12500 no of records: 2

Similarly for total salaries based on each City.

Is there any method in awk to make the search based on the value of certain column?

Code:

awk 'NR>1{A[$2]+=$1;I[$2]++}END{for(i in A) if (A[i]) print "Country",i,"sum",A[i],"Average",A[i]/I[i],"records",I[i]}' infile

Code:

# cat tst
salary country city
10000 zzz BN
25000 zzz BN
30000 zzz BN
10000 yyy ZN
15000 yyy ZN

# awk 'NR>1{A[$2]+=$1;I[$2]++}END{for(i in A) if (A[i]) print "Country",i,"sum",A[i],"Average",A[i]/I[i],"records",I[i]}' tst
Country yyy sum 25000 Average 12500 records 2
Country zzz sum 65000 Average 21666.7 records 3
#

Code:

awk '{a[$2]+=$1;b[$2]++}END{print "country\tsum\tavg\tnum";for (i in a){print i"\t"a[i]"\t"a[i]/b[i]"\t"b[i]}}' file

Thanks