Question: simple qu: amalgamate and/or transpose mutational and clinical data
gravatar for beinda.yeo
2.5 years ago by
beinda.yeo0 wrote:


Probably a beginners question for most of you so apologies!

I have excel spreadsheet of 400+ mutations identified (each row is mutation identified hence multiple mutations in each patients sample)

I need to transpose the data so that each row is a unique patient and each column is a gene, however I then need multiple mutations in the one gene to be denominated

I then can add the clinical data

Any suggestions? Many thanks

ADD COMMENTlink modified 2.5 years ago by Jennifer Hillman Jackson25k • written 2.5 years ago by beinda.yeo0
gravatar for Jennifer Hillman Jackson
2.5 years ago by
United States
Jennifer Hillman Jackson25k wrote:


This is not really a Galaxy question, but the manipulation could be done within Galaxy. Tools to use:

  1. Export Excel data as tabular and upload to Galaxy
  2. Datamash > Transpose
  3. Join, Subtract and Group > Group

Many more text manipulation tools are available. For example, Join two Datasets may be useful.

Help to get started using Galaxy is at the top of this wiki page:

Thanks, Jen, Galaxy team

ADD COMMENTlink written 2.5 years ago by Jennifer Hillman Jackson25k
Please log in to add an answer.


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