http://imagej.273.s1.nabble.com/Transpose-Table-in-Image-J-help-tp5014534p5014547.html
See dropbox link an example table output for the ImageJ multi-measure table “multi-measure" and the other is the table format required by the plugin I need to use, called “Newtableformat”.
Basically what I need to achieve is to take all the columns labelled Mean1… Mean2… etc and merge them into a single column one after another, create a new column that contains the corresponds column number to enable a way to separate out each measurement.
I hope this explains better my problem.
> On 5 Oct 2015, at 8:56 am, Brandon Hurr <
[hidden email]> wrote:
>
> Could you describe the problem in a bit more detail with some sort of
> example table?
>
> You said you want to transpose, but then you want all of the gray value
> data in a single column. The Results table displays each data type in
> columns with ROIs as rows. Wayne's transpose function takes that and makes
> ROIs as columns and data types (roundness, area,...) as rows.
>
> If neither one of those works for you, then you need to describe what you
> have and what you need better.
>
> B
>
> On Sat, Oct 3, 2015 at 4:20 AM, Jacob Lewis <
[hidden email]> wrote:
>
>> Hi Wayne,
>>
>> Sorry to bother you again. Would I apply the same logic as in the
>> javascript you provided to take all the columns output by multi-measure
>> (i.e. mean grey value) and merge them into one column? Or is that even more
>> difficult/multi-step process? I know I would have to provide an additional
>> column like molecule or trajectory to separate out each measurement. It
>> appears I wasn’t very clear when I mentioned “transpose” in my last email,
>> although that code was helpful. The plugin reads columns rather and rows,
>> see screen shot for typical format. This is the format I need to get the
>> data in after the multi-measure on all slices.
>>
>> I apologise if my explanation is a bit confusing I’m a biochemist trying
>> to analyse and navigate image analysis for some single molecule data.
>>
>> Cheers,
>>
>> Jacob
>>
>>
>>> On 3 Oct 2015, at 2:02 pm, Rasband, Wayne (NIH/NIMH) [E] <
>>
[hidden email]> wrote:
>>>
>>>> On Oct 2, 2015, at 7:10 PM, Jacob Lewis <
[hidden email]> wrote:
>>>>
>>>> Hi All,
>>>>
>>>> I am using the multi-measure tool in ROI manager, the table format it
>> produces does not work with the plug in written for our group I was
>> wondering if anyone could help with this. I need to transpose the table
>> from default Image J columns to rows.
>>>>
>>>> Any help our advise would be much appreciated.
>>>
>>> Hi Jacob,
>>>
>>> The following JavaScript code transposes the the Results table. You will
>> need to upgrade to the latest daily build (1.50d6) to transpose tables that
>> have a "Label" column.
>>>
>>> -wayne
>>>
>>> rt1 = Analyzer.getResultsTable();
>>> rt2 = new ResultsTable();
>>> hdr = rt1.getHeadings();
>>> for (i=0; i<rt1.getCounter(); i++) {
>>> for (j=0; j<hdr.length; j++) {
>>> if (i==0) rt2.setValue("Column", j, hdr[j])
>>> value = rt1.getStringValue(hdr[j], i);
>>> rt2.setValue(""+(i+1), j, value)
>>> }
>>> }
>>> rt2.showRowNumbers(false);
>>> rt2.show("Results");
>>>
>>>
>>> --
>>> ImageJ mailing list:
http://imagej.nih.gov/ij/list.html>>
>>
>> --
>> ImageJ mailing list:
http://imagej.nih.gov/ij/list.html>>
>
> --
> ImageJ mailing list:
http://imagej.nih.gov/ij/list.html