Data Wizard
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
Installs
- Total 674
- Win 357
- Mac 230
- Linux 87
Jul 24 | Jul 23 | Jul 22 | Jul 21 | Jul 20 | Jul 19 | Jul 18 | Jul 17 | Jul 16 | Jul 15 | Jul 14 | Jul 13 | Jul 12 | Jul 11 | Jul 10 | Jul 9 | Jul 8 | Jul 7 | Jul 6 | Jul 5 | Jul 4 | Jul 3 | Jul 2 | Jul 1 | Jun 30 | Jun 29 | Jun 28 | Jun 27 | Jun 26 | Jun 25 | Jun 24 | Jun 23 | Jun 22 | Jun 21 | Jun 20 | Jun 19 | Jun 18 | Jun 17 | Jun 16 | Jun 15 | Jun 14 | Jun 13 | Jun 12 | Jun 11 | Jun 10 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Windows | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Mac | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Linux | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Readme
- Source
- raw.githubusercontent.com
DataWizard
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. Notes: it's strongly recommended to key bind the justify, collapse, pivot, and pop commands. Recommended Key Bindings
//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)
Pivot and Justify
Pop
Distinct Columns
Distinct Columns into Json
SQL Inserts(batched in groups of 1000) now supporting sql server and postgres syntax
LeadingZerosAddRemove
Shuffle Columns
Shuffle Characters vertically within equal length strings
Distinct Characters
Other misc function
Read Py Variables