awk to convert table-by-row to matrix table Post: 302881907

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Is it possible to draw table/matrix using shell script?

Hi all, I need to create a matrix of variable rows and columns. Right now i have 3 rows and two columns and following values. Output something like TypeA TypeB TestCase1 Pass Fail TestCase2 Pass ...

2. UNIX for Dummies Questions & Answers

convert matrix to row and columns

Dear Unix Gurus, I have a sample data set that looks like this y1 y2 y3 y4 y5 x1 0.3 0.5 2.3 3.1 5.1 x2 1.2 4.1 3.5 1.7 1.2 x3 3.1 2.1 1.0 4.1 2.1 x4 5.0 4.0 6.0 7.0 1.1 I want to open it up so that I get x1 y1 0.3 x2 y1 1.2 x3 y1 3.1 x4 y1 5.0 x1 y2 0.5 x2 y2...

3. UNIX for Dummies Questions & Answers

Shell Script: Traverse Database Table Row by Row

Hello Everyone, My issue is that I want to traverse a database table row by row and do some action on the value retrieved in each row. I have gone through a lot of shell script questions/posts. I could find row by row traversal of a file but not a database table. Please help. Thanks &...

4. Shell Programming and Scripting

Table to Matrix

Hi, I have a table in the format: 1 0 -1 1 0 2 0 1 -1 0 0 0 3 0 1 1 0 0 0 0 0 0 etc. I am trying to input this to a program, however it is complaining about the fact that it is not in matrix format. How do I add 0's to end of the rows to make them even? Thanks in advance!

5. Shell Programming and Scripting

Read in Table as a matrix

Dear forum users, i'm trying to read a table with 40x122 data in a array. Following this, i'd plot each rows again the header of the file in gnuplot. i was thinking for something like that #!/bin/bash # reads from the $ips file and assigns to $MYARRAY #IFS =";" split the line after the...

6. Shell Programming and Scripting

How to sort matrix table in UNIX?

Hello All, i have a file sort.txt with below entries. 1 12 10 16 6 4 20 8 15 i need to sort these entries and the out put should come in a single line. 1 4 6 8 10 12 15 16 20 Can you please help me sort this out?

7. Shell Programming and Scripting

In php, Moving a new row to another table and deleting old row

Hi, I already succeed moving a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla). But it can't delete the old row. Please help me with the script. my php script: INSERT INTO...

8. Shell Programming and Scripting

Convert rows into columns and create table with awk

Hello I've four fields . They are First Name, Last Name, Age, Country. So when I run a Unix command, I get below output with these fields comes every time in different order as you can see. Some times first name is the first row and other time last name is first row in the output and etc etc.....

LEARN ABOUT REDHAT

sgeequ

SGEEQU(l)								 )								 SGEEQU(l)

NAME

       SGEEQU - compute row and column scalings intended to equilibrate an M-by-N matrix A and reduce its condition number

SYNOPSIS

       SUBROUTINE SGEEQU( M, N, A, LDA, R, C, ROWCND, COLCND, AMAX, INFO )

	   INTEGER	  INFO, LDA, M, N

	   REAL 	  AMAX, COLCND, ROWCND

	   REAL 	  A( LDA, * ), C( * ), R( * )

PURPOSE

       SGEEQU computes row and column scalings intended to equilibrate an M-by-N matrix A and reduce its condition number. R returns the row scale
       factors and C the column scale factors, chosen to try to make the largest element in each row and column of  the  matrix  B  with  elements
       B(i,j)=R(i)*A(i,j)*C(j) have absolute value 1.

       R(i) and C(j) are restricted to be between SMLNUM = smallest safe number and BIGNUM = largest safe number.  Use of these scaling factors is
       not guaranteed to reduce the condition number of A but works well in practice.

ARGUMENTS

       M       (input) INTEGER
	       The number of rows of the matrix A.  M >= 0.

       N       (input) INTEGER
	       The number of columns of the matrix A.  N >= 0.

       A       (input) REAL array, dimension (LDA,N)
	       The M-by-N matrix whose equilibration factors are to be computed.

       LDA     (input) INTEGER
	       The leading dimension of the array A.  LDA >= max(1,M).

       R       (output) REAL array, dimension (M)
	       If INFO = 0 or INFO > M, R contains the row scale factors for A.

       C       (output) REAL array, dimension (N)
	       If INFO = 0,  C contains the column scale factors for A.

       ROWCND  (output) REAL
	       If INFO = 0 or INFO > M, ROWCND contains the ratio of the smallest R(i) to the largest R(i).  If ROWCND >= 0.1 and AMAX is  neither
	       too large nor too small, it is not worth scaling by R.

       COLCND  (output) REAL
	       If INFO = 0, COLCND contains the ratio of the smallest C(i) to the largest C(i).  If COLCND >= 0.1, it is not worth scaling by C.

       AMAX    (output) REAL
	       Absolute  value	of  largest  matrix  element.	If AMAX is very close to overflow or very close to underflow, the matrix should be
	       scaled.

       INFO    (output) INTEGER
	       = 0:  successful exit
	       < 0:  if INFO = -i, the i-th argument had an illegal value
	       > 0:  if INFO = i,  and i is
	       <= M:  the i-th row of A is exactly zero
	       >  M:  the (i-M)-th column of A is exactly zero

LAPACK version 3.0						   15 June 2000 							 SGEEQU(l)