DEV Community

dataPixy πŸ§šβ€β™‚οΈ
dataPixy πŸ§šβ€β™‚οΈ

Posted on • Edited on

πŸ“’ #1 Visual Studio Code Data Preview 🈸

Data Preview 🈸 extension for importing πŸ“€ viewing πŸ”Ž slicing πŸ”ͺ dicing 🎲 charting πŸ“Š & exporting πŸ“₯ large JSON array/config, YAML, Apache Arrow, Avro & Excel data files with Perspective - streaming data analytics WebAssembly library.

Data Preview 🈸 example using dark UI theme with d3fc Charts πŸ“Š Data View config, viewing superstore.arrow data file :)

Data Preview Dark

Data Preview 🈸 is capable of loading a few 10+MB's large data files with 100+K records & an extensive list of supported Data Formats you'll be hard-pressed to find on VSCode marketplace in one extension.

🈸 Features

  • Preview .json .arrow .avro .yml .csv/.tsv & .xlsx/.xlsb data files in a Data Grid w/Sorting & Filtering
  • Grid Data Summary display w/Aggregate Functions, Row & Column Pivots (a.k.a. Group By & Split By)
  • Basic Charts πŸ“Š creation w/Aggregate Functions, Row & Column Pivots
  • Pluggable Charting πŸ“Š libraries for bult-in Charts: d3fc || highcharts
  • Persistent Data Preview Settings (View, Sort, Filter, Pivots, etc.) for restore of open Data View panels on VSCode Reload
  • Mulptiple Spreadsheets Data Preview for Excel data files
  • Markdown tables data preview for .md documentation files
  • Data .schema.json generation for Arrow & Avro Data Schema Text Previews in JSON format
  • Binary Data files .json generation for Arrow, Avro & Excel formats for Text Data Preview
  • Property Grid display for .json .config .env .properties .ini & .yml configuration files
  • Open Data Preview on Side option for slim data || config files
  • Quick Launch new Data Preview input box for data files in open workspace
  • Save Filtered Data Grid || Chart πŸ“Š Data in .arrow .csv .json(s) .yml & .properties formats
  • Save & Load Data View .config options
  • Dark & Light Data Preview 🈸 Panel Themes

πŸ”— Github Repo

https://github.com/RandomFractals/vscode-data-preview

🌟 that github repo if you like this approach for data preview in vscode.

πŸ“₯ Installation

Install Data Preview 🈸 via vscode Extensions tab (Ctrl+Shift+X) by searching for data || via VSCode marketplace search results.

It's the 1st extension on that list when you search for data πŸ˜‰

πŸ‘€ other #dataPixy πŸ§šβ€β™‚οΈ #dataViz πŸ“ˆ πŸ“Š devTools

https://marketplace.visualstudio.com/publishers/RandomFractalsInc

& more info here:

+ just for fun :)

also πŸ‘€ posts #2, #3, & #4 in these #dataPixy πŸ§šβ€β™‚οΈ #data/#charts, #maps & #graphs #devTools in #vscode mini series:

Cheers! :)

Top comments (1)

Collapse
 
rarcsousa profile image
RARCSousa

Is there any way to change the data type from mdy to dmy?