Re: Transpose Table in Image J help

Posted by Brandon Hurr on Oct 04, 2015; 9:50pm
URL: http://imagej.273.s1.nabble.com/Transpose-Table-in-Image-J-help-tp5014534p5014545.html

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