awk '
NR > 1 {aa[$1]; a[$1]++; b[$1,1]+=$2; b[$1,2]+=$3;}
END {
printf("%-10s\t%-10s\t%-10s\n", "POPULATION", "AVG SCORE1", "AVG SCORE2");
for (i in aa) printf("%-10s\t%10.2f\t%10.2f\n", i, b[i,1]/a[i], b[i,2]/a[i]);
}' datafile
Awesome rdrtx!! good work. Any idea why there is an extra line inserted in the output with 0 results. Here is the output based on your script:
Code:
POPULATION AVG SCORE1 AVG SCORE2
0.00 0.00
Italian 9.40 12.22
German 6.50 8.45
British 10.25 13.32
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... (2 Replies)
I would like to use awk to parse a file with three columns in, like:
Chennai,01,1
Chennai,07,1
Chennai,08,3
Chennai,09,6
Chennai,10,12
Chennai,11,19
Chennai,12,10
Chennai,13,12
Kerala,09,2
AP,10,1
AP,11,1
Delhi,13,1
Kerala,13,3
Chennai,00,3
Chennai,01,1
Chennai,02,1
Chennai,07,5 (3 Replies)
Hi,
I have a file with more than 2,000 rows like this:
05/26/2011,1200,1500
I would like to create a awk shell script that calculate the price average of the second and third field each 5,10 and 20 rows or ask me for the values, starting at first row.
Finally compare the average value... (1 Reply)
Hello,
I need some help to reformat this table-by-row to matrix?
infile:
site1 A:o,p,q,r,s,t
site1 C:y,u
site1 T:v,w
site1 -:x,z
site2 A:p,r,t,v,w,z
site2 C:u,y
site2 G:q,s
site2 -:o,x
site3 A:o,q,s,t,u,z
site3 C:y
site3 T:v,w,x
site3 -:p,routfile:
SITE o p q r s t v u w x y... (7 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Write an awk script(company.awk) for the workers file to find the number of workers of each departman, total... (8 Replies)
Hello everyone
I have a 20M file which is having the below sample layout
1111,ABC,100
1111,DEF,200
1111,XYZ,300
4444,LMN,100
4444,AKH,500
4444,WCD,400
2222,ABC,100
7777,DEF,300
7777,WCD,300
I need to covert this to below format
Output
Party_ID|ABC|AKH|DEF|LMN|WCD|XYZ... (5 Replies)
Gents,
Can you please help me to create a pivot table from a csv file. ( I have zip the csv file)
Using the file attached, columns 1,28 and 21 i would like to get something like this output
JD Val 1 2 3 4 5 6 7 8 9 10 11 12 Total... (4 Replies)
Hi
My Input is like below
DELETE|MPI|AUD_UPD_AGENT|MPISYS
INSERT|MPI|AUD_UPD_AGENT|MPISYS
SELECT|MPI|AUD_UPD_AGENT|MPISYS
UPDATE|MPI|AUD_UPD_AGENT|MPISYS
DELETE|MPI|BDYMOD|MPISYS
INSERT|MPI|BDYMOD|MPISYS
SELECT|MPI|BDYMOD|MPISYS
UPDATE|MPI|BDYMOD|MPISYS
DELETE|MPI|BDYMOD_DESC|MPISYS... (4 Replies)
Discussion started by: dineshaila
4 Replies
LEARN ABOUT DEBIAN
gpiv_t-avg
GPIV_T-AVG(1) General Commands Manual GPIV_T-AVG(1)NAME
gpiv_t-avg - Calculates time-averaged mean and variances of PIV data.
SYNOPSIS
gpiv_t-avg [-dn | --dir_name dir basename] [-df | --first_dir N] [-dl | --last_dir N] [-fb | --file_basename file basename] [-ff |
--first_file N] [-fl | --last_file N] [-fx | --file_prefix] [-h | --help] [-n | --none] [-p | --print] [-relrms] [-uv | --print] [-v |
--version]
DESCRIPTION
gpiv_t-avg calculates mean and variances from a series of piv data resulting into time-averaged values. If no parameters are defined at the
command line, standard parameters will be used that are defined in the script. This program does not use the parameter resources from libg-
piv.
Options-dn | --dir_name dir base-name
The dir base-name represents the directory name without its last number. It is supposed that the last number in the directory name
is a counter.
-df | --first_dir
Defines the counter N of the first directory number at which the analyses starts.
-dl | --last_dir
Last directory number N at which the analyses ends.
-fb | --file_base_name file base-name
The filename has to be given without its .piv extension. The file base-name represents the file name without its last number, before
the extension. If not -fx key is used, it is supposed that the last number in the file name is a counter. The output will be written
to dir base-name/file base-name.ta_mean.piv and dirname/filename.ta_sdev.piv at which mean values and variances are written respec-
tively or to dirname/filename.ta_U.piv and to dirname/filename.ta_V.piv if -uv is used.
-ff | --first_file
Defines the counter Nof first file number at which the analyses starts.
-fl | --last_file
Last file number N at which the analyses ends.
-fx | --file_prefix
Prefix numbering to file base name.
-h | --help
On-line help.
-n | --none
Suppresses real execution.
-p | --print
Prints parameters, command line options and input and output filenames to stdout.
-relrms
Prints relative rms, related to the absolute mean value.
-uv Writes U and v displacements/velocities to separate outputs.
-v | --version
Prints version information to standard output, then exits successfully.
SEE ALSO
gpivtools
AUTHOR
Gerber Van der Graaf
19 Januari 2005 GPIV_T-AVG(1)