Hi...
I have a piece of software that generates up to 4096 values
from a microarray plate. Therefore, it can generate something like:
<id> <bucket> <value>
where <id> is a plate number, <bucket> is a value from 0-4095
and <value> is a number > 0.
Problem is that it only generates values > 0 and I have no control
of the software to generate even those values that are zero. Hence,
I can have 2-<id>s such as:
1 1 4
1 4 5
1 6 8
2 3 3
2 4 3
2 8 13
I want to run a correlation against them, which is OK since I only
care about the buckets that match, since bucket 4 = bucket 4,
regardless of the <id>.
What I want to do is to 'fill in' the buckets for a particular id with
zero values for the buckets that don't exist. For example, using
the above data for id=1, i'd convert it to:
1 1 4
1 2 0
1 3 0
1 4 5
1 5 0
1 6 8
etc...
Is there a way to do this, outside of exporting the data and writing
a perl program?
Thanks in advance
Joe
