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)
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)
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)
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)
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)
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)
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)
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)
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)
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)