Re: Transpose Table in Image J help

Posted by Jacob Lewis on Oct 03, 2015; 11:20am
URL: http://imagej.273.s1.nabble.com/Transpose-Table-in-Image-J-help-tp5014534p5014540.html

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