print max number of 2 columns - awk Post: 302611507

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to print mon and max values of ranges

HI all I'm trying to write an awk script to print the min and max value in a range(s) contained in another file - the range values are in $2 EG 114,7964,1,y,y,n 114,7965,1,y,y,n 114,7966,1,y,y,n 114,7967,1,y,y,n 114,7969,1,y,y,n 114,7970,1,y,y,n 114,7971,1,y,y,n 114,7972,1,y,y,n...

2. Shell Programming and Scripting

shell script(Preferably awk or sed) to print selected number of columns from each row

Hi Experts, The question may look very silly by seeing the title, but please have a look at it clearly. I have a text file where the first 5 columns in each row were supposed to be attributes of a sample(like sample name, number, status etc) and the next 25 columns are parameters on which...

3. Shell Programming and Scripting

awk: print columns depending on their number

hi guys, i have the following problem: i have a matrix with 3 columns and over 450 rows like this: 0.0165 0.0151 0.0230 0.0143 0.0153 0.0134 0.0135 0.0123 0.0195 0.0173 0.0153 0.0182 i now want to calculate the average of every line and divide every element of this...

4. Shell Programming and Scripting

Find min.max value if matching columns found using AWK

Input_ File : 2 3 4 5 1 1 0 1 2 1 -1 1 2 1 3 1 3 1 4 1 6 5 6 6 6 6 6 7 6 7 6 8 5 8 6 7 Desired output : 2 3 4 5 -1 1 4 1 6 5 6 8 5 8 6 7

5. UNIX for Dummies Questions & Answers

[Solved] Print a line using a max and a min values of different columns

Hi guys, I already search on the forum but i can't solve this on my own. I have a lot of files like this: And i need to print the line with the maximum value in last column but if the value is the same (2 in this exemple for the 3 last lines) i need get the line with the minimum value in...

6. Shell Programming and Scripting

AWK print number of records, divide this number

I would like to print the number of records of 2 files, and divide the two numbers awk '{print NR}' file1 > output1 awk '{print NR}' file2 > output2 paste output1 output2 > output awl '{print $1/$2}' output > output_2 is there a faster way?

7. Shell Programming and Scripting

Number of elements, average value, min & max from a list of numbers using awk

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!

8. Shell Programming and Scripting

awk to find number in a field then print the line and the number

Hi I want to use awk to match where field 3 contains a number within string - then print the line and just the number as a new field. The source file is pipe delimited and looks something like 1|net|ABC Letr1|1530||| 1|net|EXP_1040 ABC|1121||| 1|net|EXP_TG1224|1122||| 1|net|R_North|1123|||...

9. Shell Programming and Scripting

Print root number between min and max ranges

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...

10. UNIX for Beginners Questions & Answers

Print a row with the max number in a column

Hello, I have this table: chr1_16857_17742 - chr1 17369 17436 "ENST00000619216.1"; "MIR6859-1"; - 67 chr1_16857_17742 - chr1 14404 29570 "ENST00000488147.1"; "WASH7P"; - 885 chr1_16857_18061 - chr1 ...

LEARN ABOUT OSX

minmax

MINMAX(l)																 MINMAX(l)

NAME

       minmax - Find extreme values in data tables

SYNOPSIS

       minmax [ files] [ -C ] [ -D ] [ -H[nrec] ] [ -Idx[/dy] ] [ -L ] [ -M[flag] ] [ -: ] [ -bi[s][n] ]

DESCRIPTION

       minmax  reads  its  standard  input  [or from files] and finds the extreme values in each of the columns. It recognizes NaNs and will print
       warnings if the number of columns vary from record to record.  As an option, minmax will find the extent of the first two  columns  rounded
       up  and down to the nearest multiple of dx/dy. This output will be in the form -Rw/e/s/n which can be used directly in the command line for
       other programs, or simply in column form.

       xyzfile
	      ASCII [or binary, see -b] file(s) holding a fixed number of data columns.

OPTIONS

       -C     Report the min/max values per column in separate columns [Default uses <min/max> format]

       -D     Sets longitude discontinuity to the Dateline (-180/+180) [Default is Greenwich (0-360)].	Requires -L.

       -H     Input file(s) has Header record(s). Number of header records can be changed by editing your .gmtdefaults file. If used, GMT  default
	      is 1 header record.

       -I     Report  the  min/max of the first two columns to the nearest multiple of dx and dy, and output this in the form -Rw/e/s/n (unless -C
	      is set).

       -L     Indicates that the x column contains longitudes, which may be periodic in 360 degrees [Default assumes no periodicity].

       -M     Multiple segment file(s). Segments are separated by a special record.  For ASCII files the first character must be flag [Default	is
	      '>'].  For binary files all fields must be NaN.

       -:     Toggles  between	(longitude,latitude)  and  (latitude,longitude)  input/output. [Default is (longitude,latitude)].  Applies to geo-
	      graphic coordinates only.  Only works when -I is selected.

       -bi    Selects binary input. Append s for single precision [Default is double].	Append n for the number of columns in the binary  file(s).
	      [Default is 2 input columns].

EXAMPLES

       To find the extreme values in the file ship_gravity.xygd, try

       minmax ship_gravity.xygd

       Output should look like

       ship_gravity.xygd: N = 6992 <326.125/334.684> <-28.0711/-8.6837> <-47.7/177.6> <0.6/3544.9>

       To find the extreme values in the file track.xy to the nearest 5 units and use this region to draw a line using psxy, try

       psxy `minmax -I5 track.xy` track.xy -Jx1 -B5 -P > track.ps

       To find the min and max values for each column, but rounded to integers, try

       minmax junkfile -C -I1

SEE ALSO

       gmt(1gmt)

								    1 Jan 2004								 MINMAX(l)