My vscodeData Preview 🈸 extension just hit 24K installs & closing in on 140K downloads in VS marketplace, beating Azure data crew tools & taking that #1 spot :)
Share it with your devs & take it for a spin!
👀 this intro post:
& most recent update on that versatile data tool for vscode devs:
Supported Text & Binary Data Formats ;)
| Data File Extension(s) | File Type | Data Parsing Library/Method Used | Data Format Specification |
|---|---|---|---|
.json.config.jsonl.ndjson | text | JSON.parse() | https://json.org/ |
.json5 | text | json5/JSON5.parse() | https://json5.org/ |
.hjson | text | hjson-js/Hjson.parse() | https://hjson.org/ |
.arrow.arr | binary | apache-arrow/Table.from() | https://arrow.apache.org/ |
.avro | binary | avsc/avro.createFileDecoder() | https://avro.apache.org/docs/current/ |
.properties.env | text | node-properties/properties.parse() | https://en.wikipedia.org/wiki/.properties |
.ini | text | node-properties/properties.parse() | https://en.wikipedia.org/wiki/INI_file |
.md | text | RegExp/markdownToCsv() | https://en.wikipedia.org/wiki/Markdown |
.yml.yaml | text | js-yaml/yaml.load() | https://yaml.org/ |
.csv.tsv.txt.tab | text | perspective/perspectiveViewer.load(text) | https://en.wikipedia.org/wiki/Comma-separated_valueshttps://en.wikipedia.org/wiki/Tab-separated_values |
.dif.ods.xls.xlsb.xlsx.xlsm.xml.html | binary/text | js-xlsx/XLSX.read() | Seehttps://github.com/SheetJS/js-xlsx#file-formats for more info onExcel file formats |
Note:.json.config &.yml configuration files that don't contain array data are converted to flat properties key/value pairs Object and displayed in a Property Grid Data View mode. Seejson.utils.ts for more info.
SeeData Manager API &src/data.providers folder for data loading and saving imlementation details.
Provided Chart 📊 Types
- Area Chart
- Bar Chart
- Candlesick Chart (
d3fconly)) - Heatmap
- Line Chart
- OHLC Chart (
d3fconly) - Scatter Chart
- Sunburst
- Tree Map
Supported Filter Functions
<, <=, ==, !=, >, >=for dates and number columns/fields==, !=, contains, in, not in, begins with, ends withfor string fields and dictionaries&, |, and, or, ==, !=for bolean fields
Supported Aggregate Functions
- any
- avg
- count
- distinct count
- dominant
- first by index
- last by index
- last
- high
- low
- mean
- mean by count
- median
- pct sum parent
- pct sum grand total
- sum
- sum abs
- sum not null
- unique
Recommended VSCode Extensions
Other extensions Data Preview 🈸 replaces, enhances or supplements for working withsupported data file formats in VSCode:
| Extension | Description |
|---|---|
| Excel Viewer | View Excel spreadsheets and CSV files |
| Avro Viewer | .avro file viewer |
| avro-idl | Avro IDL Syntax Highlighter |
| DotENV | .env Syntax Highlighter |
| Ini for VSCode | Provides outline view and section folding for INI files |
| Hjson | Hjson language syntax support |
| JSON5 syntax | Adds syntax highlighting of JSON5 files |
| NDJSON Colorizer | Colorizes NDJSON (Newline Delimited JSON) files |
| YAML | YAML Language Support by Red Hat, with built-in Kubernetes and Kedge syntax support |
| docs-yaml | YAML schema validation and auto-completion for docs.microsoft.com authoring |
| YAML to JSON | Convert YAML from clipboard or current document/selection to JSON and vice versa |
| Properties To Yaml | Convert properties to yaml |
| Markdown Table Prettifier | Transforms markdown tables to be more readable |
Dev Log
See#DataPreview 🈸 tag on Twitter for the latest and greatest updates on this vscode extension and what's in store next.
P.S.: more such tools here :)
Top comments(1)
- LocationEnd of the Rainbow Rd, McDaniels KY
- Joined
dev discuss it here || on twitter :)
just showing@azuredataux crew how it's done :)#DataPreview 🈸@code extension is 24K installs strong now!dev.to/tarasnovak/vsc…
I dare@code team to RT it! :)
#dataPixy 🧚♂️#dataTools 🛠️ for#devs around the 🌐 🤗14:26 PM - 18 Nov 20190
1
...
For further actions, you may consider blocking this person and/orreporting abuse
