Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Find the minimum value

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Find the minimum value
# 8  
Old 07-22-2010
Hi

Code:
cat -n infile | sort -k2,2n | head -1

Guru
# 9  
Old 07-22-2010
Since this question was posted from an university computer, all replies are set to moderated until it's proven to not be homework.
# 10  
Old 07-22-2010
There is a problem with the script :
Code:
awk 'END { print min, "at line" ,s}
{
  min || min = $1
  s || s = NR
  if ($1 < min) {min=$1; s=NR}
  }' inputfile

when the input file contains the value 0 :
Code:
94.971
101.468
73.120
0.0
100.601
102.329

The result is
Code:
100.601 at line 4

instead of
Code:
0.0 at line 4

A new version of the script :
Code:
awk 'END { print min, "at line" ,s}
NR==1 {
  min = $1;
  s   = NR;
  next;
}
{
  if ($1 < min) {min=$1; s=NR}
  }' inputfile

Jean-Pierre.
# 11  
Old 07-22-2010
Quote:
Originally Posted by aigles
There is a problem with the script :
Code:
awk 'END { print min, "at line" ,s}
{
  min || min = $1
  s || s = NR
  if ($1 < min) {min=$1; s=NR}
  }' inputfile

when the input file contains the value 0 [...]
Yes,
mine handles that too ...
# 12  
Old 07-23-2010
I'm working on a project at the Technical University of Denmark! I have just started learning unix and needed to pick the minimum value from a dataset of 100.000 scores of protein structures that I generated using Rosetta!
There is no teaching or homework in Denmark during the summer holidays :)

Thank you for all your answers :) They were very helpful
Last edited by cno; 07-23-2010 at 05:10 AM..
# 13  
Old 07-23-2010
try this
Code:
# sort -k1n infile | head -1

# 14  
Old 07-23-2010
Code:
grep -n $( sort -g data | head -n 1 ) data

Last edited by dr.house; 07-23-2010 at 06:32 AM.. Reason: Line number added
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Find the minimum value of the column with respect to other column

Hi All, I would like get the minimum value in the certain column with respect to other column. For example, I have a text file like this. ATOM 1 QSS SPH S 0 -2.790 -1.180 -2.282 2.28 2.28 ATOM 1 QSS SPH S 1 -2.915 -1.024 -2.032 2.31 2.31 ATOM 1 ... (4 Replies)
Discussion started by: bala06
4 Replies

2. Shell Programming and Scripting

awk to find maximum and minimum from column and store in other column

Need your support for below. Please help to get required output If column 5 is INV then only consider column1 and take out duplicates/identical rows/values from column1 and then put minimum value of column6 in column7 and put maximum value in column 8 and then need to do subtract values of... (7 Replies)
Discussion started by: as7951
7 Replies

3. Shell Programming and Scripting

Find minimum and maximum values based on column with associative array

Hello, I need to find out the minimum and maximum values based on specific column, and then print out the entire row with the max value. Infile.txt: scf6 290173 290416 . + X_047241 T_00113118-1 scf6 290491 290957 . + X_047241 T_00113118-2 scf6 290898 290957 . + X_047241 T_00113119-3 scf6... (2 Replies)
Discussion started by: yifangt
2 Replies

4. Shell Programming and Scripting

Python: find the minimum in all rows

I am using Biopython to process an alignment in fasta format. I need to slice the sequences where there is the first stop codon. So I divided my alignment in codons and found the stop. I then found the first codon position using enumerate(). But I found the minimum for each row. However I need to... (0 Replies)
Discussion started by: Homa
0 Replies

5. Shell Programming and Scripting

How to find a minimum value of a row?

input 1 2 3 4 5 2 8 2 1 1 1 4 2 1 5 4 4 4 2 1 3 2 2 6 7 4 5 4 5 5 5 4 3 3 5 I woud like to print a min of each row such that my output would look like 1 1 1 2 3 (5 Replies)
Discussion started by: johnkim0806
5 Replies

6. Shell Programming and Scripting

In a row, replace negative sign and find minimum value among four columns

Hi Friends, I have an input file like this chr1 100 200 1 2 3 4 chr1 150 200 4 5 6 7 chr2 300 400 9 6 7 1 chr2 300 410 -10 21 -11 13 chr3 700 900 -21 -22 130 165 Now, my output file is chr1 100 200 1 chr1 150 200 4 chr2 300 400 1 chr2 300 410 10 chr3 700 900 21 Remove... (5 Replies)
Discussion started by: jacobs.smith
5 Replies

7. Shell Programming and Scripting

Find minimum value different from zero

Hello, I have this file file1.csv Element1;23-10-2012;1,450;1,564;1,428 Element2;23-10-2012;1,448;1,565;1,427 Element3;23-10-2012;1,453;1,570;1,424 Element4;23-10-2012;1,428;1,542;1,405 Element5;23-10-2012;1,461;;1,453 Element6;23-10-2012;1,438;1,555;1,417... (6 Replies)
Discussion started by: saba01
6 Replies

8. Shell Programming and Scripting

Finding minimum value

Hi All, I have multiple files which contains 5 columns and multiple rows..... I want to calculate the minimum value of column 5th, if column 2 is MET, till column 1 comes to the next number. Also it must skip the condition similar to 1st line where column number 1 and 3 are same and... (9 Replies)
Discussion started by: CAch
9 Replies

9. Shell Programming and Scripting

Find the minimum number

Input 10 8 20 8 10 9 20 9 10 12 20 19 10 10 20 40 Output1 10 8 2 20 8 12 10 9 1 20 9 11 10 12 -2 20 19 1 10 10 0 20 40 -20 Output2 10 9 ... (0 Replies)
Discussion started by: repinementer
0 Replies

10. UNIX for Dummies Questions & Answers

Minimum RAM

Can anyone tell me the minimum ram requirements for suse 6.1 & mdk9 please? Will they accept edo ram? (3 Replies)
Discussion started by: onestepto
3 Replies
Login or Register to Ask a Question