JMP Scripts

Latest Posts

• Tab structured layout in a Journal

  JMP Journal files are very handy for presentations  and that is what I’m using for each of my seminars. Sometimes they can be very long and overwhelming.  An idea would be to have a tab structured layout. I mean by that to have several Tabs in a Journal file so that the presentation can be separated in different sections. Here an example. This is simple to do: 1. Write a script as you would do a ...

  Valerie_Nedbal

  JMP Scripts |

  Jul 19, 2021 1:46 AM

  3020 views | 5 replies

• "Fuzzymerge" - join tables with slightly different timestamps

  I often have data files from different sources that I want to join by time, but as they come from different systems their time stamps are just slightly different.  We solved this by using JMPs KDTable object which allows for crazy fast nearest neighbor searching.  This "fuzzymerge" will find the closest row in time in a second table for each row in the main table and join those rows into the resul...

  klk

  JMP Scripts |

  Mar 30, 2021 10:43 AM

  7995 views | 9 replies

• Sqlite3 to JMP Data table through Python Integration

  The attached JSL uses JMP's Python integration to create a sqlite3 database file by recursively descending a directory of files.  The directory is chosen using JSL's Pick Directory().  The path is passed through to the Python environment.   A MD5 checksum is computed for each file and that along with the path is inserted into the sqlite3 database, then the sqlite3 table is imported into JMP as a ...

  Paul_Nelson

  JMP Scripts |

  Mar 9, 2021 1:29 PM

  1457 views | 1 replies

• Box Plot Line Color Black

  This is the script referenced in step 9 of ISQC Example 6.1 Flow Width New Data Added, in Chapter 3 of the book Douglas Montgomery's Introduction to Statistical Quality Control: A JMP.

  ZenEos

  JMP Scripts |

  Dec 1, 2020 5:12 AM

  918 views | 0 replies

• Instructions and Script for Automating Analysis with JSL

  Power Point, JMP journal and associated files on to use scripting to automate analysis and share reports, which is useful for projects with lots of detail and fairly simple data sets. The main steps:   1.     Open a table 2.     Calculate some statistics 3.     Get statistics from a report 4.     Get easy statistics 5.     Combine the data 6.     Generate figures 7.     Generate report document 8....

  gail_massari

  JMP Scripts |

  Nov 9, 2020 6:56 AM

  13036 views | 2 replies

• Seaborn-Inspired Modern Styling

  Beige is totally out! A color theme for JMP that mimics the Seaborn library from Python.

  Michael_MXAK

  JMP Scripts |

  Oct 13, 2020 12:29 PM

  2114 views | 1 replies

• Combine multiple excel files

  Hi,  Sometimes I have to combine a lot of excel files. But "Import multiple files" menu would not work for excel files properly. So I wrote a JSL for it and I would like to share it here. It starts with select an excel file and open it using excel import wizard. Then the script gets import settings and files list in the directory. Finally, open all excel files (.xls, xlsx, xlsm) in the directory a...

  MKawaguchi

  JMP Scripts |

  Sep 24, 2020 4:31 AM

  10922 views | 8 replies

• Kappa Study for VI operators.

  Hai everyone, here I attached the JMP script and one PDF document to learn how create an attribute chart. it will be useful for the beginners.

  Raj

  JMP Scripts |

  Aug 28, 2020 6:46 AM

  1146 views | 0 replies

• Census Data Import Example via HTTP Request

  JMP intern Katherine Li developed this script to read in public census data tables.  You can extend this script to read in whatever updated census information that you'd like.  This particular example loads data from the American Community Survey of demographics that is done every 10 years.   You will need an API key from the Census Bureau to run this sample.    Also, there is a JSON file included...

  briancorcoran

  JMP Scripts |

  Aug 24, 2020 6:28 AM

  1029 views | 0 replies

• Open JMP Data Table from Microsoft OneDrive

  JMP intern Katherine Li developed this script to connect to a personal Microsoft OneDrive folder, download a .JMP file using the built in browser download facility, and then open it in JMP taking advantage of the file associations with .jmp files.   To use this, though, you will need to obtain a client ID and secret for your organization.  For a personal account, this might not be a problem.  For ...

  briancorcoran

  JMP Scripts |

  Aug 21, 2020 6:26 AM

  1733 views | 0 replies

• Querying World Bank Data through HTTP Request

  JMP intern Katherine Li developed this script to query CO2 levels from the World Bank. The World Bank does not require an API Key. This shows the usage of JMP's HTTP Request service. The World Bank includes some regional data that JMP does not understand, so you'll need to delete the top rows until and including "World". Then you can run the attached Graph Builder script to create a map with Colum...

  briancorcoran

  JMP Scripts |

  Aug 19, 2020 5:23 AM

  1669 views | 1 replies

• Google BigQuery to JMP Table

  This script was created by intern Katherine Li.  It shows an example of reading data from Google BigQuery, using a publicly available dataset for NCAA basketball statistics.     To use this script, which demonstrates HTTP Request, you will need to obtain a Google client id and secret for your own Google account.  Some basics on the setup of client secrets can be found at https://cloud.google.com/d...

  briancorcoran

  JMP Scripts |

  Aug 17, 2020 1:10 PM

  1347 views | 0 replies

• Call Keyboard Maestro (Mac)

  Control OS X macros from JSL

  john_madden

  JMP Scripts |

  Aug 11, 2020 5:40 AM

  986 views | 0 replies

• Get Covid 19 Case Data from NY Times and USFacts at the County Level by Day

  To allow you to easily have the most up-to-date data from the NY Times and USA Facts at the county level, this script goes to the appropriate web sites and downloads the data. Merges it. 

  tony_cooper1

  JMP Scripts |

  May 13, 2020 9:25 AM

  1249 views | 0 replies

• Draw a filled normal distribution

  I have had the need on several occasions to create a filled normal distribution curve for use in presentations, training, and publication.  As common and as important as the normal distribution is, you would think you could find this easily as a standard shape or using an internet search, but I've not had much luck in finding what I needed.   JMP has some nice ways to draw lines and geometric shap...

  MathStatChem

  JMP Scripts |

  Mar 28, 2020 10:26 AM

  2971 views | 0 replies

• Return a JMP Color Value from a Hex Color Code

  Many times color values are specified in many industries through hexadecimal numbers. See:      https://htmlcolorcodes.com/ 
  This function facilitates the conversion of hexadecimal color values into JMP Color values /**************************************************************/ /* Return the JMP Color number from an input of a 6 character */ /* hexadecimal string. ...

  txnelson

  JMP Scripts |

  Mar 19, 2020 3:01 PM

  1911 views | 0 replies

• Export Data Table to HTML

  Exports a JMP Table to HTML Now supports image columns.

  John_Powell_JMP

  JMP Scripts |

  Dec 20, 2019 11:36 AM

  12209 views | 4 replies

• WikiReader: Augmenting Hover Labels with web data and images

  In JMP 15.0 hover labels got extensions that provide the ability to the display images and rich text inside hover labels. The image displayed and what happens when you click on it are completely under the control of the user. One can retrieve an image from a column, a file or a URL built dynamically based on the graph context (e.g. X and Y values of your graph).   To showcase this feature, this ex...

  nascif_jmp

  JMP Scripts |

  Dec 6, 2019 7:50 AM

  3468 views | 2 replies

• Create multiple lag columns

  Here is a script that can be used to create multiple lag columns of varibles in a data table.  This may be useful if your data is skewed in time.  For example, if sensor data is being captured in time, and the data in your table is ordered chronologically, then data corresponding to one batch or product may be spread out over multiple rows.  The script will allow you to easily align the data for a...

  HadleyMyers

  JMP Scripts |

  Nov 18, 2019 1:24 AM

  2526 views | 0 replies

• In List Select Where Script

  In List to select a variable length list of items from a column.  Similar to the In function in SQL.

  Jim_Gillard

  JMP Scripts |

  Oct 22, 2019 11:29 AM

  2993 views | 2 replies

• Modelling Self-heating Solids

  Slides to accompany my UK User Group 2019 Presentation. The slides with a blue border are ones in place of where a demo was given of that functionality in JMP. These slides show the basic scripts required to reproduce the demonstrated functionality. Abstract:Many solid materials slowly oxidise with time which generates heat. If the material is in a bulk form (such as during storage or transport) t...

  stephen_pearson

  JMP Scripts |

  Oct 11, 2019 1:40 AM

  3861 views | 2 replies

• Gauge Study Design

  Editors note: This script is now available as a JMP Add-in: Gauge Study Designer    This Gauge Study Design script creates an experimental design worksheet with randomization of columns within other columns.   Gauge studies are special designed experiments that support mixed models and require incomplete randomization. Random factors can not be randomized (days, repeats), but fixed factors should ...

  Di_Michelson

  JMP Scripts |

  Sep 23, 2019 11:38 AM

  8045 views | 0 replies

• MFR: a JSL Functional Programming Library for List/Associative Arrays Manipulation

  MFR (from Map-Filter-Reduce) is a library of functional programming primitives for JSL. Includes basic tests. Inspired by http://book.pythontips.com/en/latest/map_filter.html

  nascif_jmp

  JMP Scripts |

  Aug 28, 2019 1:17 PM

  7040 views | 4 replies

• Simple way to convert multiple .jmp files into .csv files (no modification) in 2 steps

  Hi all,  My daily work requires me to save many .jmp tables as .csv tables, which takes a lot of time if I use Save as function (can save each file only, need to answer repeated questions from JMP, need to choose directories for each file). I learned from JMP community and composed a simple script. Now it takes only 2 steps: Step 1: Open all .jmp tables you want to convert to .csvStep 2: Run the s...

  tmyanh1993

  JMP Scripts |

  Aug 15, 2019 3:57 AM

  7266 views | 2 replies

• Anaconda Environments Integration

  Using Anaconda virtual environments to access your Python dependencies.

  nascif_jmp

  JMP Scripts |

  Aug 13, 2019 5:21 PM

  6019 views | 5 replies