Hello everyone,
I would like to use awk to parse a file with three columns in, like:
monday 0 1
monday 1 1
monday 2 1
monday 3 1
monday 4 1
monday 5 1
tuesday 0 5
tuesday 1 1
tuesday 2 1
tuesday 3 1
tuesday 4 1
wednesday 0 1
monday 5 25

they represent the day the hour and the number of transactions.
There are thousand of lines, I would like to generate a single table
with hours as headers, the row name will be the day name, and the cells will be the average number of transaction for that day name in that particular hour like:
=========== 0 1 2 3 4 5 6 7 ... 23
Monday xxx xxx xxx ... . . . . . . . . . . . . . .
Tuesday xxx xxx xxx ... . . . . . . . . . . . . . .
Wednesday xxx xxx xxx ... . . . . . . . . . . . . . .
.
.
.
Sunday xxx xxx xxx ... . . . . . . . . . . . . . .

I only have access to the standard AWK, no gawk ....
I hope you understand and can help.
Thanks.