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

Hi

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 COMMENT • link • modified 2.5 years ago by Jennifer Hillman Jackson ♦ 25k • written 2.5 years ago by beinda.yeo • 0
0
gravatar for Jennifer Hillman Jackson
2.5 years ago by
United States
Jennifer Hillman Jackson ♦ 25k wrote:

Hello,

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: https://wiki.galaxyproject.org/Support

Thanks, Jen, Galaxy team

ADD COMMENT • link written 2.5 years ago by Jennifer Hillman Jackson ♦ 25k
Please log in to add an answer.

Help
Access

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