averaging columns Post: 302552167

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK - averaging $3 by info in $1

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

2. Shell Programming and Scripting

Averaging segments

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

3. Shell Programming and Scripting

Averaging multiple columns

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. UNIX for Dummies Questions & Answers

Averaging

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

5. Shell Programming and Scripting

Averaging segments and including the name

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

6. UNIX for Dummies Questions & Answers

Averaging the rows using 'awk'

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

7. UNIX for Dummies Questions & Answers

Averaging 100 columns together line by line

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

8. Shell Programming and Scripting

Averaging Data From Multiple Columns, Using Header if Possible

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

9. Shell Programming and Scripting

Averaging help in awk

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. Shell Programming and Scripting

Averaging 3 files

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

LEARN ABOUT HPUX

fmt

fmt(1)							      General Commands Manual							    fmt(1)

NAME

       fmt - format text

SYNOPSIS

       width] [file...]

DESCRIPTION

       The  command is a simple text formatter that fills and joins lines to produce output lines of (up to) the number of characters specified in
       the width option.  The default width is 72.  concatenates the arguments.  If none are given, formats text from the standard input.

       Blank lines are preserved in the output, as is the spacing between words.  does not fill lines beginning with a	period	for  compatibility
       with Nor does it fill lines starting with

       Indentation is preserved in the output and input lines with differing indentation are not joined (unless is used).

       can also be used as an in-line text filter for the command:

       reformats the text between the cursor location and the end of the paragraph.

   Options
       recognizes the following options:

	      Crown margin mode.
		    Preserve the indentation of the first two lines within a paragraph and align the left margin of each subsequent line with that
		    of the second line.  This is useful for tagged paragraphs.

	      Split lines only.
		    Do not join short lines to form longer ones.  This prevents sample lines of code, and other such "formatted" text, from  being
		    unduly combined.

	      Fill output lines to up to
		    width columns.

WARNINGS

       The width option is acceptable for BSD compatibility, but it may go away in future releases.

SEE ALSO

       nroff(1), vi(1).

																	    fmt(1)