From Python Pandas dataframe to jmp with group columns and add column property

qLienceStats — Sat, 10 Jun 2023 23:21:02 GMT

Hello there,

I have a table that is a generate from a collection of databases.

Columns = [Time, raw1_prop1, raw1_prop2, raw1_prop1,..., Q1]

The table is the same format every time and would therefore like to:

I would prefer to do it from python but i can also be tricked to do it in JMP :)

Re: From Python Pandas dataframe to jmp with group columns and add column property

Byron_JMP — Thu, 22 Oct 2020 18:19:01 GMT

Super easy to do with JMP. When you're ready for a treat let someone know.

Use your python query, save the resulting table as a CSV

Open the data frame in JMP

Tables>Split by test method to a wide format.

one run per row, one column per variable.

Use the Analysis>Quality>Process Capability launch platform.

add all your variable columns

Use the dialog to load specs from a separate table.

This analysis platform generates all the figures