Hi,
I have a text file with some thousands of rows of the following kind (this will be referred to as the inputFileWithColorsAndNumbers.txt):

Code:

Blue    6
Red     4
Blue    3
Yellow  4
Red     7

Colors in the left column and a number in the right one for each line. I want to run an awk script to produce this kind of output:

Code:

Color     Occurrence    Mean Value
=====    ============  ==========
Blue           2           4.5
Red            2           5.5
Yellow         1            4

So I created the below awk file which is not really optimized but I like to do it this way to understand what happens in every step.

Code:

#!/bin/bash
awk '
{
        if(!($1 in c))
        {
                colors[$1] = $1
        }
        TotalValue[$1] += $2
        occurrences[$1]++
}

END {   printf("%-11s %-12s %12s\n", "   Color   "," Occurrences ", " Mean Value ")
        printf("%-11s %-12s %12s\n", "===========", "============", "============")
        for(i in c)
                printf("%-11s %-12d %12d\n", colors[i], occurrences[i], TotalValue[i]/occurrences[i])
}' $1

I run the file with this command in Linux:

./awkFileFromAbove.sh inputFileWithColorsAndNumbersFromAbove.txt

The problem is that when I run this I don't get any output printed from the 'for loop'. Have tried to troubleshoot by putting printf() here and there, and I know the script enters the if statement for every single line (not once per color). Suggestions on how to proceed?