## Find minimum value different from zero

Find minimum value different from zero
# 1
10-23-2012
Find minimum value different from zero

Hello,

I have this file file1.csv
and need calculate minimum value of colums 3,4 and 5

I use awk, in colum 3 work well
but in colum 4 not print any results because are rows with empty fields
how I can calculate the minimum value of column 4 without empty values​​?

 saba01 View Public Profile for saba01 Find all posts by saba01
# 2
10-23-2012
This User Gave Thanks to itkamaraj For This Post:
 itkamaraj View Public Profile for itkamaraj Find all posts by itkamaraj
# 3
10-23-2012
Quote:
Originally Posted by itkamaraj
thanks itkamaraj !!!
work ok

and minimum only the first 10 rows and (without the last row)?
 saba01 View Public Profile for saba01 Find all posts by saba01
# 4
10-23-2012
what you mean by first 10 rows and without last row ?

you want to check the minimum value in the first 10 rows ?
 itkamaraj View Public Profile for itkamaraj Find all posts by itkamaraj
# 5
10-23-2012
Quote:
Originally Posted by itkamaraj
what you mean by first 10 rows and without last row ?

you want to check the minimum value in the first 10 rows ?
Yes, check the minimum value in the first 10 rows without empty values​​
the last row always has the minimum value
 saba01 View Public Profile for saba01 Find all posts by saba01
# 6
10-23-2012
This User Gave Thanks to itkamaraj For This Post:
 itkamaraj View Public Profile for itkamaraj Find all posts by itkamaraj
# 7
10-23-2012
Quote:
Originally Posted by itkamaraj
is just what I wanted, works well

thanks again !!!
 saba01 View Public Profile for saba01 Find all posts by saba01

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

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

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

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

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

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

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

## Find the minimum value

Hi there I have generated a column containing 100.000 values. Sample: 94.971 101.468 73.120 100.601 102.329 I need to find the minimum value in this file and I must know which row it is in (no sorting). I hope you can help! Thanks!

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

## Minimum RAM

Can anyone tell me the minimum ram requirements for suse 6.1 & mdk9 please? Will they accept edo ram?