Re: A new 'transpose' coreutil

[Assaf Gordon]

Hello,

On 12/17/2015 06:00 AM, Pádraig Brady wrote:
> On 17/12/15 05:06, Ryan wrote:
> > Hi everybody,
> >
> > I looked through the rejected feature requests and did not find this.
> > I and others I know have often wished for an efficient 'transpose'
>
> Interesting.

GNU Datamash ( http://www.gnu.org/software/datamash/ ) can transpose files from 
the command line:

    $ cat 1.txt
    Genes   NOX1    DcP     HH
    Sample  A1      A2      B3
    Counts  514     542     490

    $ datamash transpose < 1.txt
    Genes   Sample  Counts
    NOX1    A1      514
    DcP     A2      542
    HH      B3      490

In addition to performing other various statistical and text-related operations 
(in the coming version: also cross-tabulation, a.k.a pivot-tables).

regards,
 - assaf