Latest
Open
RNA-Seq
ChIP-Seq
SNP
Assembly
Forum
Planet
All »
Home
Log In
Question: Compute Sum Per Row
0
gravatar for Joachim Jacob
6.0 years ago by
Joachim Jacob • 50
Joachim Jacob • 50 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) http://www.bits.vib.be @bitsatvib
• 765 views
ADD COMMENT • link •
modified 6.0 years ago by Jennifer Hillman Jackson ♦ 25k • written 6.0 years ago by Joachim Jacob • 50
0
gravatar for Jennifer Hillman Jackson
6.0 years ago by
Jennifer Hillman Jackson ♦ 25k
United States
Jennifer Hillman Jackson ♦ 25k 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 http://galaxyproject.org
ADD COMMENT • link written 6.0 years ago by Jennifer Hillman Jackson ♦ 25k
Please log in to add an answer.

Similar posts • Search »

Content
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