Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Find min.max value if matching columns found using AWK
Top Forums Shell Programming and Scripting Find min.max value if matching columns found using AWK Post 302574989 by vasanth.vadalur on Saturday 19th of November 2011 02:53:35 PM
Old 11-19-2011
HI,

Thanks .

Its is simple that i need to check input file and i need to reduce the lines by two ways.


way1: checking column2 and column4 if it is equal, i will replace those line by single line with total 4 columns.

i.e ) column 1 contains min value
col3 contains max. value.
col 2 and col 4 is same

way2 : here as explained in the prev example.


It is actually reducing the records...


Hi, ur code is printing all the values... expected output is less lines as per the explained ways.

---------- Post updated at 11:53 AM ---------- Previous update was at 09:19 AM ----------

To be clear consider the below input_file

Code:
2 3 4 5
1 1 0 1
2 1 -1 1
2 1 3 1
3 1 4 1

here other than first record, all other records are $2 == $4, then i can reduce those $2==$4 records to a single record.

Desired output
Code:
2 3 4 5
-1 1 4 1                 (  =====> HERE -1 is min among $1&$3 and 4 is max among $1&$3)

The desired output contains second line with Col1 is min value(-1) of $2==$4 rows and Col2(4) is max value of $2==$4 rows.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to find whenther given value is in betwwen min and Max in unix shell scripting

Hi I wanted to write a shell script with an if condition Example MinValue=10 MaxValue=30 logvalue = some integer value that script reads from the command line arguement I wanted to check whether log value greater than or equal to10 and less than equal to 30 and proceed with the rest of... (5 Replies)
Discussion started by: pinky
5 Replies

2. Shell Programming and Scripting

how to find min, max dates in a file

hello friends...:-) i need some help i have a file cantain like this Star1 ,NetWork,09/02/2008 Star1 ,NetWork,10/02/2008 Star1 ,NetWork,11/02/2008 Star2 ,NetWork,08/03/2008 Star2 ,NetWork,09/04/2008 Star2 ,NetWork,10/05/2008 i need to find out min, max dates the output look like... (6 Replies)
Discussion started by: gemini106
6 Replies

3. UNIX for Dummies Questions & Answers

Awk search for max and min field values

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)
Discussion started by: Kirichiko
3 Replies

4. Shell Programming and Scripting

How to find the average,min,max ,total count?

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)
Discussion started by: vinothsekark
7 Replies

5. Shell Programming and Scripting

to find min and max value for each column!

Hello Experts, I have got a txt files which has multiple columns, I want to get the max, min and diff (max-min) for each column in the same txt file. Example: cat file.txt a 1 4 b 2 5 c 3 6 I want ouput like: cat file.txt a 1 4 b 2 5 c 3 6 Max 3 6 Min 1 4 Diff 2 2 awk 'min=="" ||... (4 Replies)
Discussion started by: dixits
4 Replies

6. 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... (4 Replies)
Discussion started by: MetaBolic0
4 Replies

7. Shell Programming and Scripting

Get the min avg and max with awk

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)
Discussion started by: yanglei_fage
2 Replies

8. Shell Programming and Scripting

awk script to find min and max value

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)
Discussion started by: ncwxpanther
3 Replies

9. Shell Programming and Scripting

How to get min and max values using awk?

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)
Discussion started by: redse171
12 Replies

10. Shell Programming and Scripting

Find min and max time taken from a log file

You have a log file as attached in sample input with various operations and time taken by each of them. Write a script to find the min and max time taken for each operation. Sample output is attached. Sample Input is given as below: operation1,83621 operation2,72321 operation3,13288... (1 Reply)
Discussion started by: Chandan_Bose
1 Replies

LEARN ABOUT DEBIAN

re-pcr

RE-PCR(1)						      General Commands Manual							 RE-PCR(1)

NAME

       re-PCR -- Find sequence tagged sites (STS) in DNA sequences

SYNOPSIS

       re-PCR [-hV] -p hash-file [-g gaps] [-n mism] [-lq] [primer ...]

       re-PCR [-hV] -P hash-file [-g gaps] [-n mism] [-l] [-m margin] [-O+|-] [-C batchcnt] [-o outfile] [-r+|-] [primers-file ...]

       re-PCR [-hV] -s hash-file [-g gaps] [-n mism] [-lq] [-m margin] [-o outfile] [-r+|-] [left right lo[-hi] [...]]

       re-PCR [-hV] -S hash-file [-g gaps] [-n mism] [-lq] [-m margin] [-O+|-] [-C batchcnt] [-o outfile] [-r+|-] [stsfile ...]

DESCRIPTION

       Implements reverse searching (called Reverse e-PCR) to make it feasible to search the human genome sequence and other large genomes by per-
       forming STS and primer searches.

OPTIONS

       -p=hash-file
		 Perform primer lookup using hash-file

       -P=hash-file
		 Perform primer lookup using hash-file

       -s=hash-file
		 Perform STS lookup using hash-file

       -S=hash-file
		 Perform STS lookup using hash-file

       -n=mism	 Set max allowed mismatches per primer for lookup

       -g=gaps	 Set max allowed indels per primer for lookup

       -m=margin Set variability for STS size for lookup

       -l	 Use presize alignments (only if gaps>0)

       -G	 Print alignments in comments

       -d=min-max
		 Set default STS size

       -r=+|-	 Enable/disable reverse STS lookup

       -O=+|-	 Enable/disable syscall optimisation

       -C=batchcnt
		 Set number of STSes per batch

       -o=outfile
		 Set output file name

       -q	 Quiet (no progress indicator)

EXAMPLE

	famap -tN -b genome.famap org/chr_*.fa

	fahash -b genome.hash -w 12 -f3 ${PWD}/genome.famap

	re-PCR -s genome.hash -n1 -g1 ACTATTGATGATGA AGGTAGATGTTTTT 120-200

       See famap(1) and fahash(1)

SEE ALSO

       /usr/share/doc/ncbi-epcr/README.txt

       bioperl(1), e-pcr(1), famap(1) and fahash(1)

AUTHORS

       This manual page was written by Andreas Tille <tille@debian.org> for the Debian system (but may be used by others).  Permission is  granted
       to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published by
       the Free Software Foundation.

       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

								    April 2008								 RE-PCR(1)
All times are GMT -4. The time now is 08:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy