Sponsored Content
Top Forums Shell Programming and Scripting Summing up a matrix using awk Post 302602546 by birei on Monday 27th of February 2012 04:49:51 PM
Old 02-27-2012
Hi JRodrigoF,

One way:
Code:
$ cat infile
100 3 3 3 3 3 
200 5 5 5 5 5 
400 1 1 1 1 1 
500 8 8 8 8 8 
900 0 0 0 0 0 
100 7 7 7 7 7 
$ awk '{ getline line; split( line, fields ); for( i = 1; i <= NF; i++ ) { $i += fields[i] } print }' infile
300 8 8 8 8 8
900 9 9 9 9 9
1000 7 7 7 7 7

Regards,
Birei
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk scripting - matching records and summing up time

Hello. I just found out about awk, and it appears that this could handle the problem I'm having right now. I first stumbled on the thread How to extract first and last line of different record from a file, and that problem is almost similar to mine. In my case, an ASCII file will contain the... (0 Replies)
Discussion started by: Gonik
0 Replies

2. Shell Programming and Scripting

awk matrix problem

hi there I'm very new in programing and i've started with awk. I'm processing 200 data files and I need to do some precessing on them. The files have 3 columns with N-lines for each line a have on the first and second value is the same for all the files and only the third is variable. like... (2 Replies)
Discussion started by: philstar
2 Replies

3. Shell Programming and Scripting

Awk: Summing values with group criteria

Hi Guys, I have a text file with ";" like separator F1;F2;F3;F4;F5 444;100041;IT;GLOB;1800000000 444;100041;TM;GLOB;1000000000 444;10300264;IT;GLOB;2000000000 444;10300264;IT;GLOB;2500000000 I have to sum the cullums F5 for same F2 and F3 collums The result must be: ... (7 Replies)
Discussion started by: gianluca2
7 Replies

4. Shell Programming and Scripting

awk? adjacency matrix to adjacency list / correlation matrix to list

Hi everyone I am very new at awk but think that that might be the best strategy for this. I have a matrix very similar to a correlation matrix and in practical terms I need to convert it into a list containing the values from the matrix (one value per line) with the first field of the line (row... (5 Replies)
Discussion started by: stonemonkey
5 Replies

5. Shell Programming and Scripting

Using awk to summing from a given line

My file is something like this : 03.097 03.094 03.093 03.095 03.091 04.089 06.093 07.225 08.196 06.097 06.094 05.096 04.086 I'd like to sum it from a given line to another one , e.g.: from line 10 until line 20 What s the awk way solving this ? (1 Reply)
Discussion started by: firelink
1 Replies

6. Shell Programming and Scripting

Please Help!!!! Awk for summing columns based on selected column value

a,b,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,aa,bb,cc,dd,ee,ff,gg,hh,ii a thru ii are digits and strings.... The awk needed....if coloumn 9 == i (coloumn 9 is string ), output the sum of x's(coloumn 22 ) in all records and sum of y's (coloumn 23 ) in all records in a file (records.txt).... (6 Replies)
Discussion started by: BrownBob
6 Replies

7. Shell Programming and Scripting

how to rearrange a matrix with awk

Hi, every one. I have two files ,one is in matrix like this, one is a list with the same data as the matrix. AB AE AC AD AA AF SA 3 4 5 6 4 6 SC 5 7 2 8 4 3 SD 4 6 5 3 8 3 SE 45 ... (5 Replies)
Discussion started by: xshang
5 Replies

8. Shell Programming and Scripting

awk summing specific lines and fields

Hi I would like to know if it is possible to sum some specific fields. I have this x;x;x;x;x;x;x;x;467,390,611 Bytes;0.435291 GB;0.062247 GB;0.373045 GB;11,225;157 a;a;a;a;a;a;a;a;13,805,156,846 Bytes;12.857054 GB;1.838559 GB;11.018495 GB;151,063;18,933 b;b;b;b;b;b;b;b;232,797,478,723... (5 Replies)
Discussion started by: nakaedu
5 Replies

9. Shell Programming and Scripting

Help summing a file using awk

I'm trying to sum a text file using AWK. Here is an example of the file: 600|3H68| 46 600|3H69| 46 600|3H6F| 290 600|3H6G| 24 600|3HDY| 1 600|3HDY| 3 600|3HE0| 1 600|3HE0| 3 I would like to sum the third field if the first... (7 Replies)
Discussion started by: Drenhead
7 Replies

10. Shell Programming and Scripting

awk split columns after matching on rows and summing the last column

input: chr1 1 2 3 chr1 1 2 4 chr1 2 4 5 chr2 3 6 9 chr2 3 6 10 Code: awk '{a+=$4}END{for (i in a) print i,a}' input Output: chr112 7 chr236 19 chr124 5 Desired output: chr1 1 2 7 chr2 3 6 19 chr1 2 4 5 (1 Reply)
Discussion started by: jacobs.smith
1 Replies
Pango::Matrix(3)					User Contributed Perl Documentation					  Pango::Matrix(3)

NAME
Pango::Matrix HIERARCHY
Glib::Boxed +----Pango::Matrix METHODS
matrix = Pango::Matrix->new ($xx=1., $xy=0., $yx=0., $yy=1., $x0=0., $y0=0.) o $xx (double) o $xy (double) o $yx (double) o $yy (double) o $x0 (double) o $y0 (double) $matrix->concat ($new_matrix) o $new_matrix (Pango::Matrix) $matrix->rotate ($degrees) o $degrees (double) $matrix->scale ($scale_x, $scale_y) o $scale_x (double) o $scale_y (double) (dx, dy) = $matrix->transform_distance ($dx, $dy) o $dx (double) o $dy (double) Since: pango 1.16 array reference = $matrix->transform_pixel_rectangle ($rect) o $rect (array reference) Since: pango 1.16 (x, y) = $matrix->transform_point ($x, $y) o $x (double) o $y (double) Since: pango 1.16 array reference = $matrix->transform_rectangle ($rect) o $rect (array reference) Since: pango 1.16 $matrix->translate ($tx, $ty) o $tx (double) o $ty (double) double = $matrix->x0 ($new) o $new (double) double = $matrix->xx ($new=0) o $new (double) double = $matrix->xy ($new) o $new (double) double = $matrix->y0 ($new) o $new (double) double = $matrix->yx ($new) o $new (double) double = $matrix->yy ($new) o $new (double) SEE ALSO
Pango, Glib::Boxed COPYRIGHT
Copyright (C) 2003-2009 by the gtk2-perl team. This software is licensed under the LGPL. See Pango for a full notice. perl v5.12.1 2010-07-05 Pango::Matrix(3)
All times are GMT -4. The time now is 05:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy