DEV Community

dataPixy 🧚‍♂️
dataPixy 🧚‍♂️

Posted on • Edited on

14 7

📢 #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! :)

Do your career a big favor. Join DEV. (The website you're on right now)

It takes one minute, it's free, and is worth it for your career.

Get started

Community matters

Top comments (1)

Collapse
 
rarcsousa profile image
RARCSousa

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