Question: How to transpose data using terminal?
gravatar for Genosa
3.8 years ago by
Genosa100 wrote:

Hi, sorry if this is a rather basic terminal question. I have a set of RNAseq output file which is in the current format:

gene    condition    replicate    fpkm 
B2M     untreated    0              800
B2M     Untreated   1               900
B2M     untreated    2              850
B2M     treated        0              909
B2M     treated        1              980
B2M     treated        2              809

And I wish to change the data to the format:

Gene  untreated  untreated  untreated  treated  treated  treated
B2M   800           900            850           909       980       809

What kind of command should I use please? Thank you!

linux terminal rnaseq • 1.1k views
ADD COMMENTlink modified 3.8 years ago by genomax89k • written 3.8 years ago by Genosa100

it sounds like a XY problem . Why do you need to transpose this ?

ADD REPLYlink written 3.8 years ago by Pierre Lindenbaum130k

I am trying to make the data fit the GSEA format

ADD REPLYlink written 3.8 years ago by Genosa100
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1215 users visited in the last hour