10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to average the values from 3 files with the same format. They are very large files so I will describe the file and show some it of. Basically the file has 83 columns (with nearly 7000 rows). The first three columns are the same for each file while the remaining 80 are values... (3 Replies)
Discussion started by: kylle345
3 Replies
2. Shell Programming and Scripting
Hi all,
I have a data file like below, where Time is in the second column
DATE TIME FRAC_DAYS_SINCE_JAN1
2011-06-25 08:03:20.000 175.33564815
2011-06-25 08:03:25.000 175.33570602... (10 Replies)
Discussion started by: gd9629
10 Replies
3. Shell Programming and Scripting
Hi,
I have a file with multiple tab delimited columns and I would like to have the average of each column:
Iteration Tree No Lh HMean
1000 1 -78.834717 -78.834717
1100 1 -77.991031 -78.624046
1200 1 -79.416055 -78.761861
1300 1 -79.280494 -78.968099
1400 1 -82.846275 -80.808696 ... (4 Replies)
Discussion started by: mikey11415
4 Replies
4. UNIX for Dummies Questions & Answers
Hi
I have 100 xy graphs and need to average these together in a line by line fashion. The value of the x axis are the same. y differs e.g. taking only 2 graphs:
graph 1
x y
1 3
2 5
3 7
4 9
5 11
graph 2
x y
1 4
2 6
3 10 (2 Replies)
Discussion started by: jenjen_mt
2 Replies
5. UNIX for Dummies Questions & Answers
Dear all,
I have the data in the following format. I want to do average of each NR= 5 (rows) for all the 3 ($1,$2, $3) columns and want to print average result in another file in the same format. I dont know how to write code for this in 'awk', can some one help me to write a code for this in... (1 Reply)
Discussion started by: arvindr
1 Replies
6. Shell Programming and Scripting
Hello,
I have a awk line that averages rows.
So if my file looks like this:
Jack 1 1 1 1 1 1
Joe 1 1 1 1 1 1
Jerry 0 0 0 0 0 0
John 1 1 1 0 0 0
The awk line below skips column 1 and then averaged the rows
awk -F'\t' -v r=3... (3 Replies)
Discussion started by: phil_heath
3 Replies
7. UNIX for Dummies Questions & Answers
Hello all,
I'm trying to perform an averaging procedure which selects a selection of rows, average the corresponding value, selects the next set of rows and average the corresponding values etc.
The data below illustrates what I want to do. Given two columns (day and value),
I want to... (2 Replies)
Discussion started by: Muhammad Rahiz
2 Replies
8. Shell Programming and Scripting
Hello,
I am trying to average multiple columns simultaneously while skipping the first column.
I am using this awk line to average one column
awk '{sum+=$3} END { print "Average = ",sum/NR}'
But I want to be able to do it for multiple columns while skipping the first column. There... (4 Replies)
Discussion started by: gisele_l
4 Replies
9. Shell Programming and Scripting
Hi,
I have a file that I want to average. So specifically I want to average every third column for each row.
Here is an example of my file
2 2 2 3 3 3 1 1 1 5 5 5
Heres what I want it to look like after averaging every third column
2 3 1 5
thanks (11 Replies)
Discussion started by: kylle345
11 Replies
10. Shell Programming and Scripting
Hello,
I have three columns of data of the format below:
<name> <volume> <size>
a 2 1.2
a 2 1.1
b 3 1.7
c 0.7 1.9
c 0.7 1.9
c 0.7 1.8
What I... (3 Replies)
Discussion started by: itisthus
3 Replies