How to transpose data using terminal?
0
0
Entering edit mode
6.1 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.6k views
1
Entering edit mode

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

0
Entering edit mode

I am trying to make the data fit the GSEA format