JMP User Community

Latest Discussions

Scraping and accessing data on Redfin directly from JMP

Hello All - In one of the JMP seminars I came across the instructor demonstrating how to download housing price and related data from Red-fin website for analysis. The instructor used "internet open --> webpage" to access the data for analysis. Can someone share how we can do that? This is for academic purpose. Thanks!JMP Pro 17.0.0 (622753)
AbhijithS

Discussions |
Dec 12, 2023 12:15 AM

831 views | 1 replies
Sixth data extraction

Let say I have data "12345278" and "12345078" and would like to extract out the sixth, any formula I can use?
Coz if use Right(data,3), then the data will be "278" or "078"For every sequence have to be extracted out in diff column, so it might be quite inconvenient to use like this: Left(Right(data,3),1) Any suggested method to do this?
Sysy13

Discussions |
Dec 11, 2023 3:58 PM

1299 views | 2 replies
Is it by design that header summary graphs aren't affected by column properties such as Missing Value Codes and Value Labels?

Is this by design that Column properties don't seem to affect header summary graphs? Here I have set Missing Value Code to "M" and Value Label to F = "Female" and you can see difference between the header summary graphs and distribution plot:
jthi

Discussions |
Dec 11, 2023 12:17 PM

1638 views | 4 replies
Replacing NAs with Randomly generated numbers

Hi, I'm very new to JMP and I am working with a dataset of measured element concentrations that have a few non-detects labelled as "ND" scattered throughout the dataset. I have been instructed to replace all of the ND's with a value randomly drawn from a uniform distribution
between 0 and the daily limit of detection (LOD) by a two-point calibration. I have the values for the various LODs for each...
LossEffectPuma9

Discussions |
Dec 11, 2023 10:36 AM

968 views | 2 replies
How to set default date interval in a date picker script ?

I want to set default dates in the the following date picker script, FROM 6 months back TO today.What do I need to add or modify in the script below?Names Default To Here( 1 ); clear log (); New Window( "Query Date (last 6 months selected by default)", <<Modal, sd = Today(); ed = Today(); H List Box( Text Box( "From:" ), scal = Number Edit Box( sd, <<Set Format( Format( "yyyy-mm-dd" ) ),...
Neo

Discussions |
Dec 11, 2023 10:03 AM

885 views | 1 replies

Previous
Next

Latest Discussions

Scraping and accessing data on Redfin directly from JMP

Hello All - In one of the JMP seminars I came across the instructor demonstrating how to download housing price and related data from Red-fin website for analysis. The instructor used "internet open --> webpage" to access the data for analysis. Can someone share how we can do that? This is for academic purpose. Thanks!JMP Pro 17.0.0 (622753)
AbhijithS

Discussions |
Dec 12, 2023 12:15 AM

831 views | 1 replies
Is it by design that header summary graphs aren't affected by column properties such as Missing Value Codes and Value Labels?

Is this by design that Column properties don't seem to affect header summary graphs? Here I have set Missing Value Code to "M" and Value Label to F = "Female" and you can see difference between the header summary graphs and distribution plot:
jthi

Discussions |
Dec 11, 2023 12:17 PM

1638 views | 4 replies
Replacing NAs with Randomly generated numbers

Hi, I'm very new to JMP and I am working with a dataset of measured element concentrations that have a few non-detects labelled as "ND" scattered throughout the dataset. I have been instructed to replace all of the ND's with a value randomly drawn from a uniform distribution
between 0 and the daily limit of detection (LOD) by a two-point calibration. I have the values for the various LODs for each...
LossEffectPuma9

Discussions |
Dec 11, 2023 10:36 AM

968 views | 2 replies
How to get y-axis labels from multiple Y charts and change only specific labels?

In a multiple y plot, how can I get the plotted y-axis labels/tiles (e.g. say get AAA, BBB, CCC, DDD and FFF as a list) and change some specific ones (post plotting), say BBB and DDD to BBB1 and DDD1 respectively and replot (closing the old)?
Neo

Discussions |
Dec 11, 2023 9:28 AM

1245 views | 3 replies
Copy Last Two Column data from Data table A to Data table B

Hi Everyone I have a two data table , table A and table B,I want write a script that copy last two column data from table A then paste to table B,Could you give me some kindly sugestion ? Thanks.
wade-liu

Discussions |
Dec 11, 2023 1:21 AM

1025 views | 3 replies

Previous
Next

Latest Discussions

Select ALL matching cells

very useful!
it selects the matching cells in all open datasets (e.g. select a specific wafer and get it highlighted in the other datasets)
Working with Rows ... but a little hard to find

note to mysef: not here - or here: but here: Thankyou, @Jasean for showing me the way ...
hogi

Discussions |
Dec 9, 2023 3:12 AM

664 views | 0 replies
Vector Modeling and Related Analysis Capabilities

hello JMP team , I am curious to learn more on the vector data type modeling and any associated analysis on that . Are there examples of sample vector datasets ? Once such dataset exists, could clustering techniques work on them and how would they work specifically ?I assume they would at the very least extract statistical aggregation from each vector and use these for clustering. Is there any mo...
altug_bayram

Discussions |
Dec 1, 2023 2:30 PM

612 views | 0 replies
Dendrograms in JMP: show scale, show categories without the categories dendrogram and setup UPGMA+dice as statistics.

HiDoes anybody know how to get the scale of the dendrograms? Scale can be setup in different ways, but it is not shown by default in the output.Does anybody know how to get the categories labels shown without performing the categories dendrogram?Does anybody know how to perform Dice+UPGMA dendrograms? Those are basics statistics, and I can’t find them.Thank you very much if someone helps JMP 17.2....
JRTormo

Discussions |
Nov 29, 2023 2:41 AM

836 views | 0 replies
Keyboard shortcuts

[More Topic Containers like this] Jmp Help/Keyboard Shortcuts assign new Keyboard ShortcutsAssigning-keyboard-shortcuts-for-frequently-used-options comment/uncomment blocks of code (international keyboard)A shortcut can be set in the menu customization Editoradd keyboard shortcuts for your own functionsadd them to the main menu/ to a toolbar and assign a shortcutadd keyboard shortcuts for "open...
hogi

Discussions |
Nov 26, 2023 1:38 AM

751 views | 0 replies
When the neural network of JMP is operated in Python, the value is different.

When the neural network created by JMP was saved and run in python code, it output values different from the score output by JMP.

OS：windows 10Python Version : 3.9

File list jmp_score.py
CNN_NTanH_boost.py <- JMP Python
mypython_code.py

import CNN_NTanH_boost
import numpy as np
import pandas as pdfilepath = r"filepath" ext = 'csv' if filepath.endswith(ext): df=pd.read_csv(filepath) else : df=pd....
TShiino

Discussions |
Nov 21, 2023 8:48 PM

650 views | 0 replies