Average, min and max in file with header, using awk
Hi,
I have a file which looks like this:
I would like an awk script that extracts the average, min and max values from the last column. The following code prints the minimum value:
Putting > instead of < naturally gives me the header instead. Putting NR>1 gives me the last number of the column, here 0.003118. If I remove the header, it works fine, but I would like to skip that step. The following code, however, works fine for finding the average:
More info on file: It could be as much as 1 million lines in total. The numbers are usually between 0 and 1, ie lots of decimal numbers. After the header, the column in question is only numeric. There will always be a number, but it might be either 0 or 1.
hi, i have an awk script and I managed to figure out how to search the max value but Im having difficulty in searching for the min field value.
BEGIN {FS=","; max=0}
NF == 7 {if (max < $6) max = $6;}
END { print man, min}
where $6 is the column of a field separated by a comma (3 Replies)
hi!
i have a file like the attachement.
I'd like to get for each line the min, max and average values. (there is 255 values for each line)
how can i get that ?
i try this, is it right?
BEGIN {FS = ","; OFS = ";";max=0;min=0;moy=0;total=0;freq=890}
$0 !~ /Trace1:/ {
... (1 Reply)
I am redirecting my ping output to a file. The sample output is like this:
64 bytes from xx.xx.xx.167: icmp_seq=4490 ttl=116 3.75 ms 2011Jul12- 15 40 16
64 bytes from xx.xx.xx.167: icmp_seq=4491 ttl=116 5.29 ms 2011Jul12- 15 40 17
64 bytes from xx.xx.xx.167: icmp_seq=4492 ttl=116 4.88 ms... (6 Replies)
Hi ,
Below is my sample data,I have this 8 column(A,B,C,D,E,F,G,H) in csv file.
A , B ,C ,D ,E ,F,G ,H
4141,127337,24,15,20,69,72.0,-3
4141,128864,24,15,20,65,66.0,-1
4141,910053,24,15,4,4,5.0,-1
4141,910383,24,15,22,3,4.0,-1
4141,496969,24,15,14,6,-24.0,-18... (7 Replies)
Hi all,
I have a list of numbers. I need an awk command to find out the numbers of elements (number of numbers, sort to speak), the average value the min and max value. Reading the list only once, with awk.
Any ideas?
Thanks! (5 Replies)
aaa: 3 ms
aaa: 2 ms
aaa: 5 ms
aaa: 10 ms
..........
to get the 3 2 5 10 ...'s min avg and max
something like
min: 2 ms avg: 5 ms max: 10 ms (2 Replies)
I need to find the max/min of columns 1 and 2 of a 2 column file what contains the special character ">".
I know that this will find the max value of column 1.
awk 'BEGIN {max = 0} {if ($1>max) max=$1} END {print max}' input.file
But what if I needed to ignore special characters in the... (3 Replies)
Hi,
I need your kind help to get min and max values from file based on value in $5 .
File1
SP12.3 stc 2240806 2240808 + ID1_N003 ID2_N003T0
SP12.3 sto 2241682 2241684 + ID1_N003 ID2_N003T0
SP12.3 XE 2239943 2240011 + ID1_N003 ID2_N003T0
SP12.3 XE 2240077 2241254 + ID1_N003 ... (12 Replies)
Chart::Clicker::Decoration::Legend::Tabular(3pm) User Contributed Perl Documentation Chart::Clicker::Decoration::Legend::Tabular(3pm)NAME
Chart::Clicker::Decoration::Legend::Tabular - Tabular version of Legend
VERSION
version 2.83
SYNOPSIS
my $cc = Chart::Clicker->new;
my $series1 = Chart::Clicker::Data::Series->new;
my $series2 = Chart::Clicker::Data::Series->new;
$cc->legend(Chart::Clicker::Decoration::Legend::Tabular->new(
header => [ qw(Name Min Max) ],
data => [
[ min(@{ $series1->values }), max(@{ $series1->values }) ],
[ min(@{ $series2->values }), max(@{ $series2->values }) ]
]
));
DESCRIPTION
Chart::Clicker::Decoration::Legend::Tabular draws a legend on a Chart with tabular data display.
The Tabular legend is a legend with a few extra attributes that allow you to pass it data to display. The attributes are c<header> and
c<data>. The "header" (optional) allows you to specify the strings to display at the top of the table and the "data" attribute allows you
to pass in arrayrefs of strings for display aside each of the series.
Note: The first string in the "header" arrayref should be the header for the column above the name of the series. This code does not do
anything to verify that you've given the appropriate counts of data. It is expected that you will provide "data" with one arrayref for
every series, each containing n elements. Having that, "header" will expect n + 1 elements with one for the series name and the remaining
(n) matching the number of elements in each of "data"'s arrayrefs.
ATTRIBUTES
border
Set/Get this Legend's border.
color
Set/Get the color to use as the foreground for the legend.
data
Set/Get the data for this legend. Expects an arrayref of arrayrefs, with one inner arrayref for every series charted.
font
Set/Get the font used for this legend's items.
header
Set/Get the header data used for this legend. Expects an arrayref of Strings.
insets
Set/Get this Legend's insets.
item_padding
Set/Get the padding for this legend's items.
METHODS
has_header
Predicate returning true of this legend has a header, else 1.
AUTHOR
Cory G Watson <gphat@cpan.org>
COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Cold Hard Code, LLC.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.14.2 2012-06-22 Chart::Clicker::Decoration::Legend::Tabular(3pm)