Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: help printing two consecutive columns, every twenty in a large matrix
Top Forums Shell Programming and Scripting help printing two consecutive columns, every twenty in a large matrix Post 302504763 by flotsam on Tuesday 15th of March 2011 11:28:20 AM
Old 03-15-2011
Here is a slice of one of the data files.
Code:
I Name 146125883 146125883 146125889 146125889 146125926 146125926
M 10080_COIII B B B B B B
M GGaluGA000006 A A A B A A
M GGaluGA000013 A A A B A B

So the cols are not really fixed width, there is no other delimiter other than a space. Not sure how cut would work if I want every 20th and 21st entry? Is there a way

@danmero, considering I have to read in a file to set i <=NF. I'm not sure how different your logic is to the original post other than the modification to print the first two columns? I guess I could also do it like:
Code:










Code:



awk '{printf "%s %s ", $1 $2}; {for (i=19; i<=NF; i+=20) printf "%s %s ", $i,$(i+1);printf "\n"}' tst > tmp









The problem seems to be in the for loop, as different file lengths seem to return weird results, when for example the length of NF is different to 200?













        
          
            

                

                
                    
                        Last edited by Scott; 03-15-2011 at 01:11 PM..
                    
                    
                        Reason: Code tags, please...
                    
                
            

   
        

        

       



            
            
            
            


            

            
            




            
                
            

            

        



        


        


 


        

        
        

        


 

            
        




















	


		


		 
		
			












	
	









    







10 More Discussions You Might Find Interesting











1. Linux






 Regarding Dot Matrix Printing




Hi all, 
 
What I want is that can we manage printing a text file on a Dot Matrix printer installed on a Linux machine and the printer should not take the normal A4 format, but should print only to the extent the text file has text in it. What happen usually is that when we give print comand to any... (0 Replies)





Discussion started by: aman_mlt



0 Replies








2. Shell Programming and Scripting






 extracting multiple consecutive columns using awk




Hello, 
I have a matrix 200*10,000 and I need to extract the columns between 40 and 77. I dont want to write in awk all the columns. eg: awk '{print $40, $41, $42,$43 ... $77}'. I think should exist a better way to do this. (10 Replies)





Discussion started by: auratus42



10 Replies








3. Shell Programming and Scripting






 grep/fgrep/egrep for a very large matrix




All, 
  
I have a problem with grep/fgrep/egrep. Basically I am building a 200 times 200 correlation matrix. The entries of this matrix need to be retrieved from another very large matrix (~100G). I tried to use the grep/fgrep/egrep to locate each entry and put them into one file. It looks very... (1 Reply)





Discussion started by: realwindfly



1 Replies








4. Shell Programming and Scripting






 Columns comparision of two large size files and printing the difference




Hi Experts, 
 
 
My requirement is to compare the second field/column in two files, if the second column is same in both the files then compare the first field. If the first is not matching then print the first and second fields of both the files. 
 
 
first file (a .txt) 
< 1210018971FF0000,... (6 Replies)





Discussion started by: krao



6 Replies








5. Shell Programming and Scripting






 conversion: 3 columns into matrix




Hi guys,  
here https://www.unix.com/shell-programming-scripting/193043-3-column-csv-correlation-matrix-awk-perl.html I found awk script converting  
 
awk '{ 
    OFS = ";" 
    if (t) { 
       if (l != $1) 
          t = t OFS $1 
    } else t = OFS $1 
    x = x ? x OFS $NF : $NF 
    l = $1 
}... (2 Replies)





Discussion started by: grincz



2 Replies








6. Programming






 Converting columns to matrix




Dear All 
 
I would like to convert columns to matrix 
 
For example my data looks like this 
 
 
D2 0 D2 0 1.0 
D2 0 D2 1 0.308 
D2 0 D2 2 0.554 
D2 0 D2 3 0.287 
D2 0 D2 4 0.633 
D2 0 D2 5 0.341 
D2 0 D2 6 0.665 
D2 0 D2 7 0.698 
D2 0 D2 8 0.625 
D2 0 D2 9 0.429 
D2 0 D2 10 0.698 
D2 0 D2 11... (7 Replies)





Discussion started by: bala06



7 Replies








7. Shell Programming and Scripting






 Square matrix to columns




Hello all, 
 
I am quite new in this but I need some help to keep going with my analysis.  
  
I am struggling with a short script to read a square matrix and convert it in two collumns. 
      A    B      C     D      
A  0.00  0.06  0.51   0.03  
B  0.06  0.00  0.72   0.48 
C  0.51  0.72  0.00  ... (7 Replies)





Discussion started by: EvaAM



7 Replies








8. Shell Programming and Scripting






 Maybe by AWK: printing help diagonal matrix characters into line




Hi Experts, 
 
I want to print this charts diagonal data into straight lines. 
This is a matrix 24X24 Horizontal and vertical. 
 
- I want to print all the diagonal cutting characters into straight line: 
 
Data: 
E F S S A H A L L A T M C N O T S O B O D U Q H 
I W I B N L O C N I L N L A N S I N... (9 Replies)





Discussion started by: rveri



9 Replies








9. Shell Programming and Scripting






 Transform columns to matrix




The following code transform the matrix to columns. Is it possible to do it other way around ( get the input from the output) ?  
 
input 
 
    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 
 
output 
 
x1 y1 0.3  
x2 y1 1.2  
x3... (1 Reply)





Discussion started by: quincyjones



1 Replies








10. Shell Programming and Scripting






 Parsing a subset of data from a large matrix




I do have a large matrix of the following format and it is tab delimited 
 
 
                 ch-ab1-20 ch-bb2-23 ch-ab1-34 ch-ab1-24 er-cc1-45 bv-cc1-78 
ch-ab1-20       0             2               3                  4         5             6 
ch-bb2-23       3             0               5    ... (6 Replies)





Discussion started by: Kanja



6 Replies












    

       

          
        

    

    

      

          
        

    













LEARN ABOUT REDHAT



sorg2l








SORG2L(l)								 )								 SORG2L(l)

NAME

       SORG2L - generate an m by n real matrix Q with orthonormal columns,

SYNOPSIS

       SUBROUTINE SORG2L( M, N, K, A, LDA, TAU, WORK, INFO )

	   INTEGER	  INFO, K, LDA, M, N

	   REAL 	  A( LDA, * ), TAU( * ), WORK( * )

PURPOSE

       SORG2L  generates  an  m  by  n real matrix Q with orthonormal columns, which is defined as the last n columns of a product of k elementary
       reflectors of order m

	     Q	=  H(k) . . . H(2) H(1)

       as returned by SGEQLF.

ARGUMENTS

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

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

       K       (input) INTEGER
	       The number of elementary reflectors whose product defines the matrix Q. N >= K >= 0.

       A       (input/output) REAL array, dimension (LDA,N)
	       On entry, the (n-k+i)-th column must contain the vector which defines the elementary reflector H(i), for i = 1,2,...,k, as returned
	       by SGEQLF in the last k columns of its array argument A.  On exit, the m by n matrix Q.

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

       TAU     (input) REAL array, dimension (K)
	       TAU(i) must contain the scalar factor of the elementary reflector H(i), as returned by SGEQLF.

       WORK    (workspace) REAL array, dimension (N)

       INFO    (output) INTEGER
	       = 0: successful exit
	       < 0: if INFO = -i, the i-th argument has an illegal value

LAPACK version 3.0						   15 June 2000 							 SORG2L(l)





















All times are GMT -4. The time now is 10:17 AM.









	






















	
	

Unix & Linux Forums Content Copyright  1993-2022. All Rights Reserved. 

        



Privacy Policy