# HG changeset patch # User Assaf Gordon # Date 1416706803 18000 # Node ID b8e69214bfc638c908546248402da062ee76d196 # Parent 48bbe512639eab753750f69acb6fb1bf3a5d7a58 add 'datamash-transpose' tool diff -r 48bbe512639e -r b8e69214bfc6 datamash-transpose.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/datamash-transpose.xml Sat Nov 22 20:40:03 2014 -0500 @@ -0,0 +1,64 @@ + + rows/columns in a tabular file + + + datamash + + + + datamash -W transpose < $in_file > $out_file + + + + + + + + + + + + + + + +.. class:: infomark + +**TIP:** Input data must be TAB delimited. If the desired dataset does not appear in the input list, use *Text Manipulation->Convert* to convert it to **Tabular** type. + +----- + +**Syntax** + +This tools transposes (swaps) rows/columns in a tabular input file. + +----- + +**Example** + +Input file:: + + Genes NOX1 DcP HH + Sample A1 A2 B3 + Counts 514 542 490 + +Output file:: + + Genes Sample Counts + NOX1 A1 514 + DcP A2 542 + HH B3 490 + + +----- + +**GNU Datamash** is a Free and Open Source Software, see more details on the Datamash_ Website. + +**GNU Datamash** is also available as a command-line program, see http://www.gnu.org/software/datamash/download/ . + +For more details about supported statistical operations, see Datamash_ website. + +.. _Datamash: http://www.gnu.org/software/datamash/ + + + diff -r 48bbe512639e -r b8e69214bfc6 test-data/datamash_transpose_input.txt --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/test-data/datamash_transpose_input.txt Sat Nov 22 20:40:03 2014 -0500 @@ -0,0 +1,3 @@ +Genes NOX1 DcP HH +Sample A1 A2 B3 +Counts 514 542 490 diff -r 48bbe512639e -r b8e69214bfc6 test-data/datamash_transpose_output.txt --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/test-data/datamash_transpose_output.txt Sat Nov 22 20:40:03 2014 -0500 @@ -0,0 +1,4 @@ +Genes Sample Counts +NOX1 A1 514 +DcP A2 542 +HH B3 490