Question: Compute Sum Per Row
gravatar for Joachim Jacob
6.0 years ago by
Joachim Jacob50 wrote:
Hi all, I wonder if there is a method for calculating a metric (e.g. sum) per row (working on a tabular dataset). But, each row contains a different number of values (i.e. some columns are empty). Can I compute this, using Compute? Cheers, Joachim -- Joachim Jacob, PhD Rijvisschestraat 120, 9052 Zwijnaarde Tel: +32 9 244.66.34 Bioinformatics Training and Services (BITS) @bitsatvib
ADD COMMENTlink modified 6.0 years ago by Jennifer Hillman Jackson25k • written 6.0 years ago by Joachim Jacob50
gravatar for Jennifer Hillman Jackson
6.0 years ago by
United States
Jennifer Hillman Jackson25k wrote:
Hello Joachim, In short, you would want to avoid mixing rows of containing a different number of columns or empty values being used in the calculation. So, this would be possible as long as: 1. There are an equal number of columns per row in the file overall. This may mean that "null" or empty values have to be padded. 2. Any null or padded values are either not included in the calculation or are padded with a "0", if that still makes sense for your calculation. If this doesn't seem to meet you needs, perhaps filtering the data into different populations, performing the calculation, then merging the result is an option (as would grouping the steps into a workflow). Using tools such as "Filter" or "Select" with "Cut" and "Paste" would likely be helpful. Good luck! Jen Galaxy team -- Jennifer Jackson
ADD COMMENTlink written 6.0 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