Since you haven't provided any samples, I'll just throw in a solution with assumptions:
Code:
awk '{total+=$1}
$1<=min{min=$1}
$1>=max{max=$1}
END{
OFMT="%.6f"
print "Total numbers : " total
print "Smallest number : " min
print "Largest number : " max
print "Average : " total/NR' file
Thank you. It only lacks 2 things :
- I guess there's a missing "}" in your statement, I've added at the end of the command, it works.
- I also need the number of numbers (number of elements in the list), not the "total". The total I know it is necessary for the average value, but I don't needed it printed, I need the number of elements in the list instead.
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,
I have a file which looks like this:
FID IID MISS_PHENO N_MISS N_GENO F_MISS
12AB43131 12AB43131 N 17774 906341 0.01961
65HJ87451 65HJ87451 N 10149 906341 0.0112
43JJ21345 43JJ21345 N 2826 906341 0.003118I would... (11 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)
I want to create a form with data values in a dropdown list. The values in the dropdown list need to be generated on the fly from max, min and increment values contained in a mysql database.
Hopefully this makes sense, I really have no idea where to start :confused:
Thanks (6 Replies)
Hi to all,
Please help on the following problem, I'm not where to begin, if awk or shell script.
I have pairs of ranges of numbers and I need to find the root or roots of ranges based on min Range and Max ranges
Example #1:
If min range is 120000 and max ranges 124999, it means that are... (5 Replies)
Discussion started by: Ophiuchus
5 Replies
LEARN ABOUT OSX
zprint
ZPRINT(1) General Commands Manual ZPRINT(1)NAME
zprint - show information about kernel zones
SYNOPSIS
zprint [-w] [-s] [-c] [-h] [-t] [-d] [-p <pid>][name]
DESCRIPTION zprint(1) displays data about Mach zones. By default, zprint will print out information about all Mach zones. If the optional name is
specified, zprint will print information about each zone for which name is a substring of the zone's name.
zprint interprets the following options:
-c (Default) zprint prints zone info in columns. Long zone names are truncated with '$', and spaces are replaced with '.', to allow
for sorting by column. Pageable and collectible zones are shown with 'P' and 'C' on the far right. Zones with preposterously large
maximum sizes are shown with '----' in the max size and max num elts fields.
-h (Default) Shows headings for the columns printed with the -c option. It may be useful to override this option when sorting by col-
umn.
-s zprint sorts the zones, showing the zone wasting the most memory first.
-w For each zone, zprint calculates how much space is allocated but not currently in use, the space wasted by the zone.
-t For each zone, zprint calculates the total size of allocations from the zone over the life of the zone.
-d Display deltas over time, showing any zones that have achieved a new maximum current allocation size during the interval. If the
total allocation sizes are being displayed for the zones in question, it will also display the deltas if the total allocations have
doubled. -p <pid> Display zone usage related to the specified process id. Each zone will display standard columns and the amount
of memory from that zone associated with a given process. The letter "A" in the flags column indicates that this total is being
accounted to the process. Otherwise, the total is an indication of the influence the process has on the kernel, but the memory is
being accounted to the kernel proper.
Any option (including default options) can be overridden by specifying the option in upper-case; for example, -C overrides the (default)
option -c.
02/12/09 ZPRINT(1)
11-09-2012
