VSCode Data Preview 🈸 💎 for devs around the 🌐

My vscode Data 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:

📢 #1 Visual Studio Code Data Preview 🈸

dataPixy 🧚‍♂️ ・ Nov 8 '19 ・ 2 min read

#showdev #vscode #data #preview

& most recent update on that versatile data tool for vscode devs:

📢 VSCode Data Preview 🈸 November 2019 Update

dataPixy 🧚‍♂️ ・ Nov 14 '19 ・ 1 min read

#showdev #vscode #data #preview

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_values https://en.wikipedia.org/wiki/Tab-separated_values
.dif .ods .xls .xlsb .xlsx .xlsm .xml .html	binary/text	js-xlsx/XLSX.read()	See https://github.com/SheetJS/js-xlsx#file-formats for more info on Excel 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. See json.utils.ts for more info.

See Data Manager API & src/data.providers folder for data loading and saving imlementation details.

Provided Chart 📊 Types

• Area Chart
• Bar Chart
• Candlesick Chart (d3fc only))
• Heatmap
• Line Chart
• OHLC Chart (d3fc only)
• Scatter Chart
• Sunburst
• Tree Map

Supported Filter Functions

• <, <=, ==, !=, >, >= for dates and number columns/fields
• ==, !=, contains, in, not in, begins with, ends with for 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 with supported 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 :)

vsCode dataPixy 🧚‍♂️ dataViz 📈 📉 📊 devTools 🔬

dataPixy 🧚‍♂️ ・ Nov 11 '19 ・ 1 min read

#showdev #vscode #dataviz #devtools

Comments

[dataPixy 🧚‍♂️]

dev discuss it here || on twitter :)

dataPixy

@tarasnovak

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 2019

0 1

...