How to transpose data using terminal?
0
0
Entering edit mode
5.0 years ago
Genosa ▴ 150

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!

terminal linux rnaseq • 1.3k views
ADD COMMENT
1
Entering edit mode

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

ADD REPLY
0
Entering edit mode

I am trying to make the data fit the GSEA format

ADD REPLY

Login before adding your answer.

Traffic: 2731 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6