There is a wonderful blog post by @Craige_Hales :
It nicely illustrates that there are multiple solutions to every problem - with varying degrees of success in achieving the goal and in investing ressources.
And often there is not the ONE solution with maximum points in all categories:
- goal was met
- length of code
- speed (to write the code)
- speed (to execute the code)
- complexity (to understand the code)
- complexity ( to remember the code)
Examples:
| topic | standard approach | faster approaches | links |
| General | |||
| learn scripting | trial and error | watch the recordings of the | |
| Data import | |||
| open multiple data files | use open() (inside a for loop) | use MFI (faster csv reader!) | |
| get a list of files | generate the file list - via Python, command prompt etc. and paste it into a new JMP table | MFI → right click on file list → Make into data table | |
| find a file in a deep/complicated network tree structure | use MFI or Windows File dialog | create a wrapper for Python/GLOB | |
| Data tables | |||
| change column entries | step by step via for loop | data table subscripting | |
| ... | dt << begin/end data update; | ||
| add columns to a data table | merge data tables via Tables/Update | first aggregate via Tables/Summary, then merge via Tables/Update | |
| column aggregation with restrictions (1) | the new approach via Where (JMP18)
is easy to remember, but very slow doesn't work yet. | use the old approach via If:
It looks more complicated but it's orders of magnitude faster *) | Col-Median-and-others:Where option |
| column aggregation with restrictions (2) | *) unfortunately, with a character comparison Col... gets very (!!!) slow: | ->use if(:sex2==1,...) | How-do-I-use-the-Col-Maximum-Formula-with-a-where |
... | replace | How-do-I-use-the-Col-Maximum-Formula-with-a-where | |
| count words | e.g. count xxx in :col: N Rows(loc(Words(:col),"xxx")) |
| |
| rank unique |
| support this wish with a Kudo:
| |
| Recode |  can be very slow in combination with other options | apply the option in a second step | |
| replace values with other values | for loop or Recode | use DataTable subscripting | |
| select rows based on a formula | If dt << select where() is too slow ... split it into 2 steps: | myrows= dt << get rows where(); dt << select rows(myrows) | |
| spec calcualations | some manual JSL code | support this wish with a Kudo: | |
| Graphs | |||
| Reports | |||
| Export | |||
| Database access | |||
| Neural Networks | |||
| ... | |||
[More like this]
Accepted Solutions
