Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Selecting lowest and highest values in columns 1 and 2, based on subsets in column 3
Top Forums Shell Programming and Scripting Selecting lowest and highest values in columns 1 and 2, based on subsets in column 3 Post 302629887 by jim mcnamara on Wednesday 25th of April 2012 07:31:07 AM
Old 04-25-2012
Code:
awk  '{ max[$3]=($2>max[$3])? $2: max[$3];
           if(! $3 in min) {min[$3]=999999999};  
           min[$3]=($1<min[$3])? $1: min[$3];
           next;
        }
        END {
               for(i in min){ print  min[i], max[i], i}
        } '   inputfilename  > outputfilename

Assuming I understood... try this.
This User Gave Thanks to jim mcnamara For This Post:
hubleo
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl ? - How to find and print the lowest and highest numbers punched in by the user?

. . . . . . (3 Replies)
Discussion started by: some124one
3 Replies

2. Shell Programming and Scripting

Selecting rows based on values in columns

Hi My pipe delimited .txt file contains rows with 10 columns. Can anyone advise how I output to file only those rows with the letters ‘ci' as the first 2 characters in the 3rd column ? Many thanks (4 Replies)
Discussion started by: malts18
4 Replies

3. Shell Programming and Scripting

selecting record by matching in two columns values

Hi Guys ! i want to search a record in file by matching two values in a record in two different columns suppose i have 3 columns and i want to select all those values from col1 for which in col3 has a specific value e.g select all "john" from column1 where column 3 has a value of "20" ... (9 Replies)
Discussion started by: ourned
9 Replies

4. UNIX for Dummies Questions & Answers

HELP Script don't work selecting lowest value!!!

Hy again guys, Last week i resolve a question here but now i need your help again :rolleyes: I have about 3000 files that i need to choose based on the lowest value, so i make temp files like this: The files can have lines from 1-10 but only 2 columns, the point is to grep the name os the... (2 Replies)
Discussion started by: MetaBolic0
2 Replies

5. Shell Programming and Scripting

top 10 highest and lowest percentile from a column

Hi, I want to extract the the top 10 and lowest 10 percentile for a column of values. For example in column 2 for this file: JOE 1 JAY 5 JAM 6 JIL 8 JIB 4 JIH 3 JIG 2 JIT 7 JAM 9 MAR 10 The top 10 lowest will be: JOE 1 and the top 10 highest will be: (2 Replies)
Discussion started by: kylle345
2 Replies

6. Shell Programming and Scripting

Selecting lines having same values for first two columns

Hello to all. This is first post. Kindly excuse me if I do not adhere to any rules and regulations of this forum. I have a file containing some rows with three columns each per row(separeted by a space). There are certain rows for which first two columns have same value but the value in... (6 Replies)
Discussion started by: manojmalhotra13
6 Replies

7. UNIX for Dummies Questions & Answers

Awk, highest and lowest value of a column

Hi again! I am still impressed how fast I get a solution for my topic "average specific column value awk" yesterday. The associative arrays in awk work fine for me! But now I have another question for the same project. Now I have a list like this 1 -0.1 1 0 1 0.1 2 0 2 0.2 2 -0.2 How... (10 Replies)
Discussion started by: bjoern456
10 Replies

8. Linux

To get all the columns in a CSV file based on unique values of particular column

cat sample.csv ID,Name,no 1,AAA,1 2,BBB,1 3,AAA,1 4,BBB,1 cut -d',' -f2 sample.csv | sort | uniq this gives only the 2nd column values Name AAA BBB How to I get all the columns of CSV along with this? (1 Reply)
Discussion started by: sanvel
1 Replies

9. Shell Programming and Scripting

Sort from highest to lowest number

Hi Guys, I am looking for a way to sort the output below from the "Inuse" count from Highest to Lowest. Is it possible? Thanks in advance. user1 0.12 0.06 0 0.12 User Inuse Pin Pgsp Virtual Unit:... (4 Replies)
Discussion started by: jaapar
4 Replies

10. Shell Programming and Scripting

Help with shell script: selecting rows that have the same values in two columns

Hello, everyone I am beginner for shell programming. I want to print all lines that have the same values in first two columns data: a b 1 2 a a 3 4 b b 5 6 a b 4 6 what I expected is : a a 3 4 b b 5 6 but I searched for one hour in... (2 Replies)
Discussion started by: nengcheng
2 Replies

LEARN ABOUT DEBIAN

lockward

lockward(6x)							XScreenSaver manual						      lockward(6x)

NAME

       lockward - Rotating spinning color-cycling things

SYNOPSIS

       lockward  [-display  displayspec]  [-root]  [-window]  [-visual	arg]  [-window-id  arg]  [-delay usec] [-pair] [-fps] [-blink | -no-blink]
       [-rotateidle-min msec] [-rotateidle-max msec] [-blinkidle-min msec] [-blinkidle-max msec] [-blinkdwell-min msec] [-blinkdwell-max msec]

DESCRIPTION

       lockward draws a spinning, rotating set of notched wheels overlaid with some flashing effects, using OpenGL.  It's a sort of cross  between
       the wards in a combination lock and those old information displays that animated via polarized light.

OPTIONS

       -visual visual
	       Specify which visual to use.  Legal values are the name of a visual class, or the ID number (decimal or hex) of a specific visual.

       -window Draw on a newly-created window (default).

       -root   Draw on the root window.

       -delay microseconds
	       Per-frame delay, in microseconds.  Default: 20000 (50 frames/sec).

       -blink | -no-blink
	       Enables/disables the blinking effects.  Default: Enabled.

       -fps    Display the current frame rate, CPU load, and polygon count.

       -rotateidle-min milliseconds

       -rotateidle-max milliseconds
	       The minimum and maximum time each spinner will sit idle, in milliseconds.  Defaults: Min 1000, max 6000.

       -blinkidle-min milliseconds

       -blinkidle-max milliseconds
	       The minimum and maximum time between blinking effects, in milliseconds.	Defaults: Min 1000, max 9000.

       -blinkdwell-min milliseconds

       -blinkdwell-max milliseconds
	       The minimum and maximum dwell time for the blinking effects, in milliseconds.  This affects how quickly the blinks actually happen.
	       Defaults: Min 100, max 600.

ENVIRONMENT

       DISPLAY Default host and display number.

       XENVIRONMENT
	       Name of a resource file that overrides the global resources stored in the RESOURCE_MANAGER property.

SEE ALSO

       X(1), xscreensaver(1)

AUTHORS

       Leo L. Schwab <ewhac@best.com>

X Version 11							5.15 (28-Sep-2011)						      lockward(6x)
All times are GMT -4. The time now is 11:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy