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
Is it possible to print the average of 2 nd column based on a key in 1st col
input
a1X 4
a1X 6
a2_1 10
a2_1 20
a2_1 30
a2_1 30
a2_1 10
output
a1X 5
a2_1 20 (11 Replies)
Discussion started by: quincyjones
11 Replies
8. 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
9. Web Development
Not sure if this is the right place to ask this but here goes. I am creating a cheat sheet for co-workers. The concept is that you pick wire size and conduit size and the amount of wires that will fit is displayed. I haven't used alot of drop downs and can't quite figure out the way the get id... (3 Replies)
Discussion started by: zero3ree
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