Average of a columns from three files Post: 303002733

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 DEBIAN

text2ps

TEXT2PS(L)																TEXT2PS(L)

NAME

       text2ps - convert text files to PostScript

SYNOPSIS

       text2ps [ options ] [ files ]

DESCRIPTION

       Text2ps	reads the input files (standard input if none are specified) and produces PostScript code which, when fed to a PostScript printer,
       will print the files.  With text2ps it is possible to select any font, point size and number of columns.  Options and files can	be  inter-
       mixed on the command line.  Options are effective for all following files until they are overridden.

       Options

       Here  follows  a list of options that text2ps recognizes.  Most numeric arguments are significant to one decimal place.	Options are evalu-
       ated from left to right.  Later options override earlier ones.

       -# n   Print n copies of each page.  (Default 1.)

       -c n   Print in n columns.  (Default 1.)

       -f font
	      Print using font font.  (Default Courier.)

       -p n   Print with point size n.	(Default 9.)

       -v n   Use a vertical spacing of n points.  If the vertical spacing is set to 0, the spacing will be 1.2 times the  point  size.   (Default
	      0.)

       -l n   Print n lines per column.  When the line count is 0, print as many lines as will fit.  (Default 0.)

       -r [p|l]
	      Set the orientation to either portrait mode (p) or landscape mode (l).  (Default p.)

       -b [+|-]
	      Set  page  break	mode.	An  argument + will force new files to be always printed on a new page (this is the default).  After - new
	      files will be put on the same page if there are still empty columns and the number of columns, the  orientation  or  the	number	of
	      copies didn't change.  New files always start new columns.  (Default -.)

       -mt n  The top margin is n points.  (Default 63.)

       -mb n  The bottom margin is n points.  (Default 63.)

       -ml n  The left margin is n points.  (Default 59.)

       -mr n  The right margin is n points.  (Default 59.)

       -mg n  The inter-column gap is n points.  (Default 25.)

       -t [+|-]
	      If  the  argument is + the name of the file being printed will be printed on each page.  If the argument is - the file name will not
	      be printed.  -t + implies -b +.

       -T text
	      Print text as title on each page.  This implies -t - and -b +.  This option can be  switched  off  by  specifying  -t  -	or  -t	+.
	      (Default no title.)

       -F font
	      Set the title font to font.  (Default Helvetica.)

       -P n   Set the title point size to n.  (Default 12.)

       -B n   Draw borders around each page.  The number n specifies how to draw borders.  N can have any of the following values or-ed in:

	      1      Draw a line along the left of the page.

	      2      Draw a line along the bottom of the page.

	      4      Draw a line along the right of the page.

	      8      Draw a line along the top of the page.

	      16     Draw a line between columns.  This line does not connect to the lines along the top or bottom.

	      32     Draw a connecting line between the line between columns and the line along the top.

	      64     Draw a connecting line between the line between columns and the line along the bottom.

	      When n is 0, no border lines are drawn.  (Default no bordering lines.)

       -w n   Tab stops are set every n spaces.  Set the width of the TAB character.  (Default 8.)

       -1     Sets  up	options  to print in one column in portrait mode with the Courier font, so that you get 66 lines on a page.  Equivalent to
	      specifying the options -c 1 -f Courier -p 9 -v 0 -r p -l 0 -mt 63 -mb 63 -ml 59 -mr 59.
	      This is the default.

       -2     Sets up options to print in two columns in landscape mode with the Courier font, so that you get two  66-line  columns  on  a  page.
	      Equivalent  to  specifying the options -c 2 -f Courier -p 6 -v 0 -r l -l 0 -mt 63 -mb 63 -ml 59 -mr 59 -mg 25.  Together with the -1
	      option, this is probably the most useful option.

       The name - means standard input.

BUGS

       Too many options.

       There is no way to specify where the title will be placed.

       If the font being used is not a constant width font and there are other characters than just tabs and spaces in front of a  tab,  the  next
       character may not align properly.

																	TEXT2PS(L)