Useful tools for exploratory data analysisUseful tools for exploratory data analysis
Dr. Holger Specht, Principal Engineer R&D - ams OSRAM Group
Wish List: https://community.jmp.com/t5/JMP-Wish-List/idb-p/jmp-wish-list
#DACH2024

Re: Nützliche Hilfsmittel zur explorativen DatenanalyseAddIns which were presented in the talk:
*) flood script:
View more...flood = Function({},
Try(:"neighbors_dir+diag"n<< get name(), Caption("can you tell me the direct and diagonal neighbors ?!?"); stop());
dt = current data table();
nr = n rows(dt = dt);
Try(:wall; dt << delete column(:wall));
new column("wall", Nominal, set each value(1));
:wall[1]=2;
dt << Graph Builder(
Show Control Panel( 0 ),
Variables( X( :X ), Y( :Y ), Color( :wall ) ),
Elements( Points( X, Y, Legend( 4 ) ) )
);
wait(1);
dt << begin data update();
<BR /><BR />// mark additional pixels as wall "2" if the neighboring pixel belongs to wall 2 - swipe from top to bottom, then inverse - and so on ...
for( i = 1, i<16, i++ ,
dt << begin data update();
for each ({rw}, 1::nr,
if(rw>1,
:wall[rw] = max(:wall[:"neighbors_dir+diag"n[rw]])));
for each ({rw}, reverse(1::nr),
if(rw>1,
:wall[rw] = max(:wall[:"neighbors_dir+diag"n[rw]])));
dt << end data update();
wait(0.1);
);
)
Re: Nützliche Hilfsmittel zur explorativen DatenanalyseGraph builder remote control
once it's running smoothly, I will update Graph Builder Toolbar .
For beta testing, please use the attached version.
v5.1:
- bugfix for numeric columns- help: explain the gui
Re: Nützliche Hilfsmittel zur explorativen DatenanalyseWishes which we discussed during the workshop:
They need your support:
Graph Builder - Overlay by multiple columns / Graph Builder: Line - possibility to add breaks
Process Capability - Non-normal Indices
:folded_hands: X group: restrict the values on the axis to the respective group
Group by - sooo useful!!! how about Interpolate?
Advanced syntax highlighting in JSL Editor - does the function evaluate its argument?
Life Distribution - one Page Overview (Trellis plot like MiniTab)
Manual axis labels are 'mixed up' when plotting multiple columns / :folded_hands: Graph Builder: revert changed axis labels
These features will come with JMP19:
:folded_hands: Column Property: Inclusive/forced Values
:folded_hands: Graph Builder: support more than 2 'Color' columns
Column Filters / Row Filtering and hiding
...
new features in JMP18:
Prediction and Tolerance Interval for the Profiler Tool
Graph Builder - align 'pages' next to each other or as grid
Add native connectors to access different database types
Column headers with sparklines
make columns more distinct
New Formula column - new entry: draft function
Recode - Numeric Transformation
Summary Statistics above columns
... a big Thank You to the Developers !
Re: Nützliche Hilfsmittel zur explorativen DatenanalyseRe: Nützliche Hilfsmittel zur explorativen DatenanalyseHi @Byron_JMP .
a current beta version of GraphBuilder Remote control can be found here.
Re: Nützliche Hilfsmittel zur explorativen DatenanalyseGraphBuilder_Toolbar: new beta v7