10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Input file:
101M
10M10D20M1I70M
10M10D39M4I48M
10M10D91M
10M10I13M2I7M1I58M
10M10I15M1D66M
Output file:
101M 101 0 0
10M10D20M1I70M 100 1 10
10M10D39M4I48M 97 4 10
10M10D91M 101 0 10
10M10I13M2I7M1I58M 88 13 0
10M10I15M1D66M 91 10 1
I'm interested to count how many total of... (6 Replies)
Discussion started by: perl_beginner
6 Replies
2. Shell Programming and Scripting
I would like to have some help in calculating 5th percentile value of column 2 for each site, the input is like below:site val1 val2
002 10 25.3
002 20 25.3
002 30 25.3
002 40 20
002 50 20
002 60 20
002 70 20
002 80 30
002 90 30
002 100 30
002 120 30
003 20 30.3
003 20 30.3
003 30 20... (2 Replies)
Discussion started by: wuhuai
2 Replies
3. Shell Programming and Scripting
Hello dears,
I have a log file with records like below and want to get a average of one column based on the search of one specific keyword.
2015-02-07 08:15:28 10.102.51.100 10.112.55.101 "kevin.c" POST ... (2 Replies)
Discussion started by: Newman
2 Replies
4. Shell Programming and Scripting
Hi,
I would like to calculate the average of column 'y' based on the value of column 'pos'.
For example, here is file1
id pos y c
11 1 220 aa
11 4333 207 f
11 5333 112 ee
11 11116 305 e
11 11117 310 r
11 22228 781 gg
11 ... (2 Replies)
Discussion started by: jackken007
2 Replies
5. Shell Programming and Scripting
Dear All,
I have input file like this.
input.txt
CE2_12-15 3950.00 589221.0 9849709.0 768.0 CE2_12_2012
CE2_12-15 3949.00 589199.0 9849721.0 768.0 CE2_12_2012
CE2_12-15 3948.00 589178.0 9849734.0 768.0 CE2_12_2012
CE2_12-52 1157.00 ... (3 Replies)
Discussion started by: attila
3 Replies
6. Shell Programming and Scripting
Hi All,
Thanks all for the continued support so far.
Today, I need to find the most occurring string/number(also called mode in statistics terminology) for each column in a data file (.csv type).
For one column of data(1.txt) like below
Sample
1
2
2
3
4
1
1
1
2
I can find the mode... (6 Replies)
Discussion started by: ks_reddy
6 Replies
7. Shell Programming and Scripting
Input file
11916 30640 9320 51876
5690 15874 4723 26287
5121 12269 2569 19959
9 71 6 86
Desired output file
11916 30640 9320 51876
5690 15874 4723 26287
5121 12269 2569 19959
9 71 6 86
22736 58854 16618 98208
Last part is the total up of first three data.
I used the following... (6 Replies)
Discussion started by: perl_beginner
6 Replies
8. Shell Programming and Scripting
Hi, I am having the file which contains the following two columns.
518 _factorial
256 _main
73 _atol
52 ___do_global_ctors
170 ___main
52 ___do_g
How can calculate the percentage of each value in the first column ?
first need to get the sum of the first column and... (3 Replies)
Discussion started by: saleru_raja
3 Replies
9. UNIX for Dummies Questions & Answers
Suppose I have 500 files in a directory and I need to Use awk to calculate average of column 3 for each of the file, how would I do that? (6 Replies)
Discussion started by: grossgermany
6 Replies
10. UNIX for Dummies Questions & Answers
Hi I have fakebook.csv as following:
F1(current date) F2(popularity) F3(name of book) F4(release date of book)
2006-06-21,6860,"Harry Potter",2006-12-31
2006-06-22,,"Harry Potter",2006-12-31
2006-06-23,7120,"Harry Potter",2006-12-31
2006-06-24,,"Harry Potter",2006-12-31... (0 Replies)
Discussion started by: onthetopo
0 Replies