I am looking for the right way to do a computation using "text
manipulation, compute an expression on every row".
I have a table consisting of 20 columns and about 15.000 rows.
Column 1 is my untreated or control and I would like to normalize every
other column to this control by simple division.
As a result I would like to obtain a table in which column 1 is set to a
value of 1 for every row, and the corresponding values in the other
columns resulting from column x / column 1.
I tried something like c2/c1,c3/c1,c4/c1... on a small testfile but that
results in all normalized values being put into one column in brackets
rather than being put into individual columns. What would be the right
I also thought about creating a workflow consisting of successive
divisions of the columns but that feels rather complicated. Is there an
Any help would be much appreciated!
Tobias Hohenauer, PhD
GCNA, Disease Mechanism Research Core
RIKEN Brain Science Institute
2-1 Hirosawa, Wako-shi
The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at usegalaxy.org. Please keep all replies on the list by
using "reply all" in your mail client. For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:
To manage your subscriptions to this and other Galaxy lists,
please use the interface at:
To search Galaxy mailing lists use the unified search at: