Data Wizard

by nickklaskala ALL

ST3/ST4 package for advanced data manipulation in delimited flat files (.csv, .psv, .tsv, .txt, .dat .etc). Supports auto detection of delimiters, Justification of delimited file, collapsing delimited files, pivoting delimited files, pop columns to end (cycling first column to end in pivoted data sets, see example), data masking(shuffle list, shuffle characters), data sampling, and converting datagrid to sql insert statements. This Package is especially helpful for ETL or any task that interfaces with delimited flat files in which you are constantly opening files and inspecting them. Allows for instant human readability and analysis.

Details

Version 1.1.10
Homepage github.com
Issues github.com
Modified 9 months ago
Last Seen 2 hours ago
First Seen 4 years ago

Installs

Total 614
Win 328
Mac 212
Linux 74

	Dec 26	Dec 25	Dec 24	Dec 23	Dec 22	Dec 21	Dec 20	Dec 19	Dec 18	Dec 17	Dec 16	Dec 15	Dec 14	Dec 13	Dec 12	Dec 11	Dec 10	Dec 9	Dec 8	Dec 7	Dec 6	Dec 5	Dec 4	Dec 3	Dec 2	Dec 1	Nov 30	Nov 29	Nov 28	Nov 27	Nov 26	Nov 25	Nov 24	Nov 23	Nov 22	Nov 21	Nov 20	Nov 19	Nov 18	Nov 17	Nov 16	Nov 15	Nov 14	Nov 13	Nov 12
Windows	0	0	0	0	0	0	2	0	1	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	1	0	0	1	1	0	0	0	0	0
Mac	0	0	1	1	0	0	0	0	0	0	1	0	1	0	1	0	0	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0
Linux	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1

Readme

Source: raw.githubusercontent.com

DataWizard

//recommended bindings
// { "keys": ["alt+\\"],           "command": "datawizardjustifycolumns"},
// { "keys": ["alt+shift+\\"],     "command": "datawizardcollapsecolumns"},
// { "keys": ["alt+p"],            "command": "datawizardpivot"},
// { "keys": ["alt+shift+p"],      "command": "datawizardpivotjustify"},
// { "keys": ["alt+l"],            "command": "datawizardpop"},
// { "keys": ["alt+s"],            "command": "datawizarddistinctcolumns"},
// { "keys": ["alt+shift+s"],      "command": "datawizarddistinctcolumnformats"},
// { "keys": ["alt+j"],            "command": "datawizarddistinctcolumnstojson"},
// { "keys": ["alt+shift+j"],      "command": "datawizarddistinctcolumnformatstojson"},
// { "keys": ["alt+i"],            "command": "datawizardstatisticssampledelimiteddiffs"},
// { "keys": ["alt+q"],            "command": "datawizardconverttosqlinsertpostgres"},


//not neccessary to map these but you can if wanted.
//sense these are less common i really just use the context menu for these actions by right clicking in the canvas

// {"keys":["alt+?"],"command":"datawizarddistinctchars"},
// {"keys":["alt+?"],"command":"datawizardkeepdelimiters"},
// {"keys":["alt+?"],"command":"datawizardleadingzerosadd"},
// {"keys":["alt+?"],"command":"datawizardleadingzerosremove"},
// {"keys":["alt+?"],"command":"datawizardsqltolowercaser"},
// {"keys":["alt+?"],"command":"datawizardpyvartotext"},
// {"keys":["alt+?"],"command":"datawizardrandomshufflecolumnvertically"},
// {"keys":["alt+?"],"command":"datawizardrandomshufflecharvertically"},
// {"keys":["alt+?"],"command":"datawizardconverttosqlinsert"},
// {"keys":["alt+?"],"command":"datawizardopenchrometab"},
// {"keys":["alt+?"],"command":"datawizardformatjson"},

Justify Collapse Columns (auto detects delimiters) Justify_Collapse