Average of a columns from three files Post: 303002736

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Taking the average of two columns and printing it on a new column

Hi, I have a space delimited text file that looks like the following: Aa 100 200 Bb 300 100 Cc X 500 Dd 600 X Basically, I want to take the average of columns 2 and 3 and print it in column 4. However if there is an X in either column 2 or 3, I want to print the non-X value. Therefore...

2. Shell Programming and Scripting

Average of columns with values of other column with same name

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

How to calculate average of two columns and copy into another file?

Hi, I need help with the awk command. I have a folder with aprox 500 files each one with two columns and I want to print in a new file, the average of column 1 and average of column 2 and the name of each file. Input files are: File-1: 100 99 20 99 50 99 50 99 File-2: 200 85...

4. UNIX for Dummies Questions & Answers

Writing a script to take the average of two columns every 3 rows

I have a dataset with 120 columns. I would like to write a script, that takes the average of every two columns, starting from columns 2 and 3, and moving consecutively in frames of 3 columns, all the way until the last column. The first column in the output file would be the averages of columns...

5. Shell Programming and Scripting

Average across multiple columns group by

Hi experts, I want to group by average, for multiple columns starting column $7 until NF, group by ($1-$5), please help For just 7th column, I can do awk ' NR>1{ arr += $7 count += 1 } END{ for (a in arr) { print a, arr/count ...

6. Shell Programming and Scripting

Match first two columns and calculate percent of average in third column

I have the need to match the first two columns and when they match, calculate the percent of average for the third columns. The following awk script does not give me the expected results. awk 'NR==FNR {T=$3; next} $1,$2 in T {P=T/$3*100; printf "%s %s %.0f\n", $1, $2, (P>=0)?P:-P}' diff.file...

7. Shell Programming and Scripting

Match first two columns and average third from multiple files

I have the following format of input from multiple files File 1 24.01 -81.01 1.0 24.02 -81.02 5.0 24.03 -81.03 0.0 File 2 24.01 -81.01 2.0 24.02 -81.02 -5.0 24.03 -81.03 10.0 I need to scan through the files and when the first 2 columns match I...

8. Emergency UNIX and Linux Support

Average columns based on header name

Hi Friends, I have files with columns like this. This sample input below is partial. Please check below for main file link. Each file will have only two rows. ...

9. Shell Programming and Scripting

Average across multiple columns - awk

Hi forum members, I'm trying to get an average of multiple columns in a csv file using awk. A small example of my input data is as follows: cu,u3o8,au,ag -9,20,-9,3.6 0.005,30,-9,-9 0.005,50,10,3.44 0.021,-9,8,3.35 The following code seems to do most of what I want gawk -F","...

10. UNIX for Beginners Questions & Answers

Average of columns

I have files that have the following columns chr pos ref alt sample 1 sample 2 sample 3 chr2 179644035 G A 1,107 0,1 58,67 chr7 151945167 G T 142,101 100,200 500,700 chr13 31789169 CTT CT,C 6,37,8 0,0,0 15,46,89 chr22 ...

LEARN ABOUT OPENSOLARIS

val

sccs-val(1)							   User Commands						       sccs-val(1)

NAME

       sccs-val, val - validate an SCCS file

SYNOPSIS

       val [-s] [-m name] [-rsid] [-y type] s.filename...

DESCRIPTION

       The val utility determines if the specified s.files meet the characteristics specified by the indicated arguments. val can process up to 50
       files on a single command line.

       val has a special argument, `-', which reads the standard input until the end-of-file condition is detected. Each  line	read  is  indepen-
       dently processed as if it were a command line argument list.

       val generates diagnostic messages on the standard output for each command line and file processed and also returns a single 8-bit code upon
       exit as described below.

       The 8-bit code returned by val is a disjunction of the possible errors, that is, it can be interpreted as a bit string where  (moving  from
       left to right) the bits set are interpreted as follows:

	 bit 0 = missing file argument
	 bit 1 = unknown or duplicate option
	 bit 2 = corrupted s.file
	 bit 3 = can not open file or file not in s.file format
	 bit 4 = the SCCS delta ID (SID) is invalid or ambiguous
	 bit 5 = the SID does not exist
	 bit 6 = mismatch between Y% and -y argument
	 bit 7 = mismatch between sccs-val.1 and -m argument

       val  can  process  two  or  more  files	on a given command line, and in turn can process multiple command lines (when reading the standard
       input). In these cases, an aggregate code is returned which is the logical OR of the codes generated for each command line  and	file  pro-
       cessed.

OPTIONS

       The following options are supported:

       -s	  Silent.  Suppresses the normal error or warning messages.

       -m name	  Compares name with the %M% ID keyword in the s.file.

       -rsid	  Checks to see if the indicated SID is ambiguous, invalid, or absent from the s.file.

       -y type	  Compares type with the %Y% ID keyword.

ENVIRONMENT VARIABLES

       See  environ(5)	for  descriptions of the following environment variables that affect the execution of val: LANG, LC_ALL, LC_CTYPE, LC_MES-
       SAGES, and NLSPATH.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWsprot 		   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+
       |Standard		     |See standards(5). 	   |
       +-----------------------------+-----------------------------+

SEE ALSO

       sccs(1), sccs-admin(1), sccs-delta(1), sccs-get(1), sccs-help(1), what(1), sccsfile(4), attributes(5), environ(5), standards(5)

DIAGNOSTICS

       Use the SCCS help command for explanations (see sccs-help(1)).

SunOS 5.11							    17 Jan 2008 						       sccs-val(1)