Data Cleaning Script AssistantThis add-in makes it easy to create repeatable scripts that perform common data cleaning tasks. It will be particularly helpful for newer scripters who are unfamiliar with JSL conventions and syntax. It contains four point-and click tools:
- Victor the Cleaner: A GUI for renaming, reordering, and deleting columns, as well changing their data types and modeling types
- Format Copier: Generates JSL for assigning formats to selected columns
- Property Copier: Generates JSL for assigning column properties to selected columns
- Subset Selected Rows: Generates JSL for subsetting the selected rows of the current data table
For more details, see the Help document in the add-in menu.
7/15/2020: Update to v1.1 with 4th tool, "Subset Selected Rows"
A suite of 3 point-and-click utilities that generate reusable jsl code for common data cleaning tasks: renaming, reordering, and deleting columns; assigning data types, modeling types, formats and column properties.
Analytical Application DevelopmentUtilitiesRe: Data Cleaning Script AssistantHere it is!
Automating Analyses Using JMP Scripts
Re: Data Cleaning Script AssistantCan you point me towards the video you mention? Thank you.
Re: Data Cleaning Script AssistantHi Jordan,
Great tool, great videos using it! Still on jmp 14, so very happy if you find time to include that!
Thanks
Re: Data Cleaning Script AssistantThis Script is very beneficial !
Thanks
Re: Data Cleaning Script AssistantHi Jordan.
I not succeeded to open addinn code in JMP 14.
If possible please provide JSL source code and I will try to compile it for JMP version 14.
Thanks.
Re: Data Cleaning Script AssistantThanks @PatrickGiuliano for the comments.
Hi @ptolomey! Today I tried to make this tool backward-compatible with JMP 14, but I was unsuccessful. Anybody who has better jsl skills than me is welcome to try and improve it, the code is not encrypted.
Re: Data Cleaning Script AssistantHi @ptolomey Tagging @Jordan_Hiller so he sees your request! @PatrickGiuliano
Re: Data Cleaning Script AssistantHi Jordan.
Thank you for great tool.
Can you also add support for JMP version 14.
Re: Data Cleaning Script AssistantStupendous, thanks @Jordan_Hiller . Also a great tool for showing full reproducibility in an analysis work-flow (e.g. for "data integrity" purposes in a regulated medical-device or biotechnology environment). This is a much more elaborate instantiation of another add-in that I used to use pretty often when trying to create my analysis reproducibly without scripting: Copy Script For Selected Column(s) to Clipboard
copying @JerryFish and @patricia_roth so they can bookmark this per discussion earlier today. Cheers,
Re: Data Cleaning Script AssistantExcellent tool!
Re: Data Cleaning Script AssistantVery helpful! Thanks, Jordan!
Re: Data Cleaning Script AssistantGreat tool, Jordan!
