10 More Discussions You Might Find Interesting
1. Programming
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
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
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
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
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
6. Shell Programming and Scripting
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
7. Shell Programming and Scripting
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! (16 Replies)
Discussion started by: cno
16 Replies
8. Programming
Hello there.
I've got the query like that
SELECT count(tour_id) AS cnt
FROM orders
JOIN tours
ON orders.tour_id=tours.id
GROUP BY tour_id
The result Is
cnt
1
4
2
1
1
Now i have to select all records with minimum values in field "cnt"
MySQL function min() returns only one.... (2 Replies)
Discussion started by: Trump
2 Replies
9. Shell Programming and Scripting
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. Shell Programming and Scripting
Here is an example of a file I am working with:
C 4704 CB 1318 ASP 115 BGRF 1 weak 0.0% 4.33
C 4720 OD 1322 ASP 115 BGRF 1 weak 0.0% 3.71
O 4723 OD 1322 ASP 115 BGRF 1 weak 0.0% 3.48
O 4723 CG 1321 ASP 115 BGRF 1 weak 0.0% 4.34... (3 Replies)
Discussion started by: userix
3 Replies