Welcome to the JMP User Community!

Latest Discussions

• Dealing with wildcards for joining tables

  I need to join multiple tables, but the column I need to join on has wildcards for one of the tables columns. The tables are not overly large so it doens't need to be very efficient. In the Table1 KEY column below there could be any single alphanmueric character where the question marks are. In the Brackets are OR statements, so it could be 1 or 2 or 3 or 4. So for example it should join onto rows...

  ts2

  Discussions |

  Aug 31, 2019 2:30 AM

  3205 views | 2 replies

• Search a list of strings for a partial string

  Hello I am trying to find a way to search through a list of strings for all items that contain a partial string. I know this can be done using a For loop, but the list that I will be running this script on is very large and For loops take a very long time. I am wondering if there is some function out there similar to Loc(list, string) that will find the items that have the partial string. Just as ...

  aallman

  Discussions |

  Aug 22, 2019 8:39 PM

  4066 views | 1 replies

• Default Parameters for Elastic Net Logistic Regression

  Hi all, I used to use JMP for data mining when I was in school, but have switched to using Python since then.  I recently used JMP to build an Elastic Net Logistic regression with my data since its output is more intuitive.  I attempted to replicate my results in python using the "SGDClassifier function" but my results were way off.  I believe it may be because this function requires specifying se...

  wa635419

  Discussions |

  Aug 22, 2019 7:05 AM

  4343 views | 5 replies

• Non-parametric coefficient of determination

  Dear, I have a question about the use of the coefficient of determination (which is part of the output from a regression model). For the study I'm ready to analyze the data, I want to use the coefficient of determination (COD) to examine the relationship between my dependent variables which represent each column (see annex). But, as I found out each dependent variables (column) has a non consisten...

  tomasVH

  Discussions |

  Aug 21, 2019 10:52 AM

  2232 views | 2 replies

• replacing numbers with strings

  hey,i have a column COL_A, which has 31 rows for wach number between 1 - 31 ( 31 rows of 1, 31 rows of 2 .... etc), and i want to replace those numbers with 31 strings in a specifiec order, for example:if my string are in this order: horse, cat, dog ....etc, i want to replace the 1's with horse, the 2's with cat, the 3's with dog...., what is the best and fastest way to do it?

  adham_saif

  Discussions |

  Aug 21, 2019 3:55 AM

  3424 views | 3 replies