Average across multiple columns group by Post: 302932964

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

Get the SUM of TWO columns SEPARATELY by doing GROUP BY on other columns

My File looks like: "|" -> Field separator A|B|C|100|1000 D|E|F|1|2 G|H|I|0|7 D|E|F|1|2 A|B|C|10|10000 G|H|I|0|7 A|B|C|1|100 D|E|F|1|2 I need to do a SUM on Col. 5 and Col.6 by grouping on Col 1,2 & 3 My expected output is: A|B|C|111|11100

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

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

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

8. UNIX for Beginners Questions & Answers

Group by columns and add sum in new columns

Dear Experts, I have input file which is comma separated, has 4 columns like below, BRAND,COUNTRY,MODEL,COUNT NIKE,USA,DUMMY,5 NIKE,USA,ORIGINAL,10 PUMA,FRANCE,DUMMY,20 PUMA,FRANCE,ORIGINAL,15 ADIDAS,ITALY,DUMMY,50 ADIDAS,ITALY,ORIGINAL,50 SPIKE,CHINA,DUMMY,1O And expected output add...

9. Shell Programming and Scripting

Average of a columns from three files

hello, I have three files in the following order ==> File1 <== 1 20977000 20977000 A C 1.00 0,15 15 45 1 115829313 115829313 G A 0.500 6,7 13 99 ==> File2 <== 1 20977000 20977000 A C 1.00 0,13 13 39 1 115829313 ...

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

figtoipe

FIGTOIPE(1)						      General Commands Manual						       FIGTOIPE(1)

NAME

       figtoipe - Convert FIG figures into Ipe format

SYNOPSIS

       figtoipe [-g] [-p preamble] FIGfile XMLfile

DESCRIPTION

       figtoipe converts files in FIG format (as created, e.g., by xfig) to Ipe's XML format.

       figtoipe  is  not  complete.   The  main lacking feature is the conversion of splines.  Arc-boxes are replaced by rectangles.  Feel free to
       improve this version!

       The drawing models of FIG and Ipe are somewhat different.  Ipe does not support depth ordering independent of grouping, pattern	fill,  and
       Postscript fonts.

       figtoipe  tries	to  include  images specified in the XFIG file. For JPEG pictures, it tries include the compressed image data into the XML
       file. For files not recognized as JPEG, anytopnm is called; its output is compressed and included in the XML file. Some output of  anytopnm
       might be rejected (e.g. images larger than 5000x5000 pixels or B&W bitmaps), or misunderstood.

OPTIONS

       -g group the figure in the output XML

       -p latex
	      add latex as a preamble to the generated XML file, e.g.
		   'usepackage{amsmath}'

AUTHORS

       Otfried Cheong
       Alexander Burger <acfb@users.sf.net> (image handling)

REPORTING BUGS

       Please report bugs using Ipe bugzilla at http://tclab.kaist.ac.kr/ipe/bugzilla.html

SEE ALSO

       More information about Ipe can be found in The Ipe Manual, which can be found in your Ipe installation.

LICENSE &; WARRANTY
       figtoipe comes with ABSOLUTELY NO WARRANTY. It is free software; you can redistribute it and/or modify it under the terms of the GNU Gen-
       eral Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

       See the file GPL-2 accompanying the source for details.

								  April 26, 2008						       FIGTOIPE(1)