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 1 year ago
Last Seen 16 minutes ago
First Seen 4 years ago

Installs

Total 662
Win 352
Mac 225
Linux 85

	Jun 1	May 31	May 30	May 29	May 28	May 27	May 26	May 25	May 24	May 23	May 22	May 21	May 20	May 19	May 18	May 17	May 16	May 15	May 14	May 13	May 12	May 11	May 10	May 9	May 8	May 7	May 6	May 5	May 4	May 3	May 2	May 1	Apr 30	Apr 29	Apr 28	Apr 27	Apr 26	Apr 25	Apr 24	Apr 23	Apr 22	Apr 21	Apr 20	Apr 19	Apr 18	Apr 17
Windows	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0
Mac	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	1	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0
Linux	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	1	1	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