Sponsored Content
Full Discussion: Matrix transpose
Top Forums Shell Programming and Scripting Matrix transpose Post 302662245 by radoulov on Tuesday 26th of June 2012 11:11:19 AM
Old 06-26-2012
Code:
awk 'END {
  for (e in m) print e, m[e]
  }
NR == 1 {
  split($0, c); next
  }
{
  for (i = 1; ++i <= NF;) 
    m[c[i - 1] OFS $1] = $i  
  }' matrice_prova.txt | sort

With GNU awk you won't need to sort externally.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Transpose using awk

I have a requirement to transpose the below xml which is in a text file on unix: <?xml version="1.0" ?> <REQUEST> <ID>XXX</ID> <TIMESTAMP>20090720062610</TIMESTAMP> <FLAG>Y</FLAG> <TO_FLAG>Y</TO_FLAG> </REQUEST> to <?xml version="1.0"... (13 Replies)
Discussion started by: new_ds_man
13 Replies

2. Shell Programming and Scripting

diagonal matrix to square matrix

Hello, all! I am struggling with a short script to read a diagonal matrix for later retrieval. 1.000 0.234 0.435 0.123 0.012 0.102 0.325 0.412 0.087 0.098 1.000 0.111 0.412 0.115 0.058 0.091 0.190 0.045 0.058 1.000 0.205 0.542 0.335 0.054 0.117 0.203 0.125 1.000 0.587 0.159 0.357... (11 Replies)
Discussion started by: yifangt
11 Replies

3. Shell Programming and Scripting

Transpose

TRANSPOSE -------------------------------------------------------------------------------- i have a file with recurring fields Start A 1 B 2 C 3 D 4 E 5 End Start A 11 B 12 C 23 D 25 E 21 (1 Reply)
Discussion started by: aravindj80
1 Replies

4. Ubuntu

How to convert full data matrix to linearised left data matrix?

Hi all, Is there a way to convert full data matrix to linearised left data matrix? e.g full data matrix Bh1 Bh2 Bh3 Bh4 Bh5 Bh6 Bh7 Bh1 0 0.241058 0.236129 0.244397 0.237479 0.240767 0.245245 Bh2 0.241058 0 0.240594 0.241931 0.241975 ... (8 Replies)
Discussion started by: evoll
8 Replies

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

6. Shell Programming and Scripting

Find and transpose

Dear All I was wondering how to resolve an issue that I met during my analysis. In particular I have a file like this(tab separated): factor1 element1 chr1 309343146 330945480 1 protein_coding geneA factor2 element2 chr2 309350853 309603230 1 protein_coding geneA factor3 element3 chr3... (2 Replies)
Discussion started by: giuliangiuseppe
2 Replies

7. Shell Programming and Scripting

Transpose using awk

Hi Friends, Very urgent requirement please do needful ASAP.. Input: |1||1|1||1|3||3|2||2|4||4|2||2|3||3|NA||0|5||5|NA||0|4||4|3||3 output: |1||1 |1||1 |3||3 |2||2 |4||4 |2||2 |3||3 |NA||0 |5||5 (4 Replies)
Discussion started by: bharat1211
4 Replies

8. Shell Programming and Scripting

Transpose matrix based on second column using awk

Hi, Is it possible to transpose the matrix like this using awk ? Many thanks in advance Input abc Name_1 0 abc Name_2 1 abc Name_3 2 abc Name_4 0.4 def Name_1 0 def Name_2 9 def Name_3 78 def Name_4 1 Output abc def Name_1 0 ... (4 Replies)
Discussion started by: quincyjones
4 Replies

9. UNIX for Dummies Questions & Answers

Transpose matrix, and rearrange columns common with another file

This is my first post, I apologize if I have broken rules. Some assistance with the following will be very helpful. I have a couple of files, both should ultimately have common columns only, arranged in the same order. This file needs to be transposed, to bring the rows to columns ... (2 Replies)
Discussion started by: abh.kumar
2 Replies

10. UNIX for Beginners Questions & Answers

Transpose the data

Hi All, I have sort of a case to transpose data from rows to column input data Afghanistan|10000|1 Albania|25000|4 Algeria|25000|7 Andorra|10000|4 Angola|25000|47 Antigua and Barbuda|25000|23 Argentina|5000|3 Armenia|100000|12 Aruba|20000|2 Australia|50000|2 I need to transpose... (3 Replies)
Discussion started by: radius
3 Replies
Matrix(3)						User Contributed Perl Documentation						 Matrix(3)

NAME
PDL::Matrix -- a derived matrix class that implements column-major constructors and methods VERSION
This document refers to version PDL::Matrix 0.01 of PDL::Matrix SYNOPSIS
use PDL::Matrix; $m = mpdl [[1,2,3],[4,5,6]]; $m = PDL::Matrix->pdl([[1,2,3],[4,5,6]]); $m = msequence(4,3); @dimsa = $a->mdims; # 'dims' is not overloaded $v = vpdl [0,1,2,3] $v = vzeroes(4); DESCRIPTION
Overview This package tries to help people who want to use PDL for 2D matrix computation with lots of indexing involved . It provides a PDL subclass so one- and two-dimensional piddles that are used as vectors resp. matrices can be typed in using traditional matrix convention. The original pdl class refers to the first index as the first row, the second index as the first column of a matrix. Consider print $B = sequence(3,2) [ [0 1 2] [3 4 5] ] which gives a 2x3 matrix in terms of the matrix convention, but the constructor used (3,2). This might get more confusing when using slices like sequence(3,2)->slice("1:2,(0)") : with traditional matrix convention one would expect [2 4] instead of [1 2]. This subclass PDL::Matrix overloads the constructors and indexing functions of pdls so that they are compatible with the usual matrix con- vention, where the first dimension refers to the row of a matrix. So now, the above example would be written as print $B = PDL::Matrix->sequence(3,2) # or $B = msequence(3,2) [ [0 1] [2 3] [4 5] ] Routines like eigenvalue or matrix inversion can be used without any changes. Furthermore one can construct and use vectors as n x 1 matrices without mentioning the second index '1'. Implementation "PDL::Matrix" works by overloading a number of PDL constructors and methods such that first and second args (corresponding to first and second dims of corresponding matrices) are effectively swapped. It is not yet clear if PDL::Matrix achieves a consistent column major look-and-feel in this way. FUNCTIONS
mpdl, PDL::Matrix::pdl constructs an object of class PDL::Matrix which is a piddle child class, where the first index refers to the first column of the two-dimen- sional piddle. $m = mpdl [[1,2,3],[4,5,6]]; $m = PDL::Matrix->pdl([[1,2,3],[4,5,6]]); mzeroes, mones, msequence constructs a PDL::Matrix object similar to the piddle constructors zeroes, ones, sequence vpdl constructs an object of class PDL::Matrix which is of matrix dimensions (n x 1) print $v = vpdl [0,1]; [ [0] [1] ] vzeroes, vones, vsequence constructs a PDL::Matrix object with matrix dimensions (n x 1), therefore only the first scalar argument is used. print $v = vsequence(2); [ [0] [1] ] PDL::Matrix::slice, PDL::Matrix::dice same as slice, dice for normal piddles, but reflecting the matrix convention by swapping the first two arguments. print sequence(3,2)->slice("1:2,(0)") # piddle [1 2] print msequence(3,2)->slice("1:2,(0)") # PDL::Matrix [2 4] PDL::Matrix::at same as at for piddles, but reflecting the matrix convention by swapping the first two arguments If only one scalar argument is used, we assume the object to be a vector and look only at the first column. PDL::Matrix::set set a particular value in a PDL::Matrix object. Note that this has to be called as an object method rather than a function print msequence(3,3)->set(2,0,-1) # ok with PDL::Matrix convention [ [ 0 1 2] [ 3 4 5] [-1 7 8] ] print set msequence(3,3), 2,0,-1 # does not conform with PDL::Matrix convention [ [ 0 1 -1] [ 3 4 5] [ 6 7 8] ] PDL::Matrix::reshape same as reshape for piddles, but reflecting the matrix convention by swapping the first two arguments mdims returns the dimensions of the PDL::Matrix object in matrix convention "dims" is NOT overloaded by PDL::Matrix to make sure that methods like PDL::transpose still work. So use "mdims" to get the dims in the PDL::Matrix notation. print msequence(3,2)->mdims 3 2 kroneckerproduct returns kroneckerproduct of two matrices. This is not efficiently implemented. det_general returns a generalized determinant of a matrix. If the matrix is not regular, one can specify the rank of the matrix and the corresponding subdeterminant is returned. This is implemented using the "eigens" function. trace returns the trace of a matrix (sum of diagonals) vcrossp, PDL::Matrix::crossp similar to PDL::crossp, however reflecting PDL::Matrix notations BUGS AND PROBLEMS
Because we change the way piddles are constructed, not all pdl operators may be applied to piddle-matrices. The inner product is not rede- fined. We might have missed some functions/methods. Internal consistency of our approach needs yet to be established. TODO
check all PDL functions, benchmarks, optimization, lots of other things ... AUTHOR(S) Stephan Heuel (stephan@heuel.org), Christian Soeller (c.soeller@auckland.ac.nz). COPYRIGHT
All rights reserved. There is no warranty. You are allowed to redistribute this software / documentation under certain conditions. For details, see the file COPYING in the PDL distribution. If this file is separated from the PDL distribution, the copyright notice should be included in the file. perl v5.8.0 2001-12-03 Matrix(3)
All times are GMT -4. The time now is 01:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy