cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
vince_faller
Super User (Alumni)

transpose list of lists (summarize()) without a for loop

Can anyone think of a way to transpose a list of lists like what comes from the following script so that each row is grouped together instead of by column. 

I know I can do it with a for loop but I'm wondering if there's anything better or less brute.  

 

Names default to here(1);
dt = open("$SAMPLE_DATA\Big Class.jmp");
summarize(dt, d = By(:age, :sex));

rows = nitems(d);
cols = nitems(d[1]);

show(rows, cols);

// rows = 2;
// cols = 12;

For this I want to change it from 2 lists of 12 to 12 lists of 2.  

 

Adding a few people that I think might either like this challenge or already have something. 

@pmroz,  @Justin_Chilton@gzmorgan0@msharp@ms

 

Vince Faller - Predictum
11 REPLIES 11
pmroz
Super User

Re: transpose list of lists (summarize()) without a for loop

Repeat: MS your repeat solution is very nice. :)

nikles
Level VI

Re: transpose list of lists (summarize()) without a for loop

I had the exact same question @vince_faller .  Thanks for asking.  I've posted a request for a feature like this to be added to the next version of JMP.  Let's see...

 

https://community.jmp.com/t5/JMP-Wish-List/Transpose-List-of-Lists-without-a-for-loop/idi-p/348968

 

Recommended Articles