10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Hello,
I am writing a script which expects as its input a hash with student names as the keys and marks as the values. The script then returns array of average marks for student scored 60-70, 70-80, and over 90.
Output expected
50-70 1
70-90 3
over 90 0
The test script so far... (4 Replies)
Discussion started by: nans
4 Replies
2. Shell Programming and Scripting
Im looking for a way to average the values in field 14 (when field 2 is equal to 2016) and fields 3 and 4 (when field 2 is equal to 2017).
Any help is appreciated.
001001 2016 33.22 38.19 48.07 51.75 59.77 67.68 70.86 72.21 66.92 53.67 42.31 40.15
001001 2017 ... (10 Replies)
Discussion started by: ncwxpanther
10 Replies
3. Shell Programming and Scripting
I have this file input.txt. I want to take average column-wise for the rows having duplicate gene names.
Gene Sample_1 Sample_2 Sample_3
gene_A 2 4 5
gene_B 1 2 3
gene_A 0 5 7
gene_B 4 5 6
gene_A 11 12 13
gene_C 2 3 4
Desired output:
gene_A 4.3 7 8.3
gene_B 2.5 3.5 4.5
gene_C 2 3 4... (6 Replies)
Discussion started by: Sanchari
6 Replies
4. Shell Programming and Scripting
Hey guys,
I have several huge tab delimited files which look like this:
a 1 20
a 3 15
a 5 10
b 2 15
b 6 10
c 3 23
what I am interested is to calculate the average of top n% of data in third column. So for example for this file the top 50% values are:
23
20
(Please note that it... (11 Replies)
Discussion started by: @man
11 Replies
5. Shell Programming and Scripting
Dear Experts,
Kindly help me please,
I have a big file where there is duplicate values in col 11 till col 23, every 2 rows appers a new numbers, but in each row there is different coordinates x and y in col 57 till col 74.
Please i will like to get a single value and average of the x and y... (8 Replies)
Discussion started by: jiam912
8 Replies
6. Shell Programming and Scripting
I have a lot of input files that have the following form:
Sample Cq Sample Cq Sample Cq Sample Cq Sample Cq
1WBIN 23.45 1WBIN 23.45 1CVSIN 23.96 1CVSIN 23.14 S1 31.37
1WBIN 23.53 1WBIN 23.53 1CVSIN 23.81 1CVSIN 23.24 S1 31.49
1WBIN 24.55 1WBIN 24.55 1CVSIN 23.86 1CVSIN 23.24 S1 31.74 ... (3 Replies)
Discussion started by: isildur1234
3 Replies
7. Shell Programming and Scripting
Hi i have data with two columns like below.
I want to find average of column values like if the value in column 2 is between 0-250000 the average of column 1 is some xx and average of column2 is ww then if value is 250001-5000000 average of column 1 is yy and average of column 2 is zz.
And my... (5 Replies)
Discussion started by: bhargavpbk88
5 Replies
8. Programming
Hi all,
can you please help me with these part of my code, I want to calculate average grade from each module and
not sure if need to label each element there, or is there any easier option to do that?
appreciate your help... (0 Replies)
Discussion started by: me.
0 Replies
9. Shell Programming and Scripting
Hi guys, I am not an expert in shell and I need help with awk command. I have a file with values like
200 1 1
200 7 2
200 6 3
200 5 4
300 3 1
300 7 2
300 6 3
300 4 4
I need resulting file with averages of... (3 Replies)
Discussion started by: saif
3 Replies
10. Shell Programming and Scripting
11.60 12.35 12.49
12.99 13.09 12.91
13.48 14.16 14.18
13.23 13.17 13.15
13.71 13.35 13.12
13.00 12.79 12.83
12.54 12.89 12.89
12.47 12.94 13.00
13.41 13.09 13.09
12.09 12.76 12.93
13.67 13.14 13.01
12.39 12.78 12.86
12.61 12.50 12.11
12.98 12.90 12.77
12.56... (5 Replies)
Discussion started by: gagan.delouri
5 Replies