RandomFractals / vscode-data-preview

Data Preview 🈸 extension for importing 📤 viewing 🔎 slicing 🔪 dicing 🎲 charting 📊 & exporting 📥 large JSON array/config, YAML, Apache Arrow, Avro, Parquet & Excel data files
https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.vscode-data-preview
Apache License 2.0
541 stars 58 forks source link

ints being interpreted as floats #328

Closed akbinod closed 1 year ago

akbinod commented 1 year ago

Thank you for this extension - it is helping a lot :)

My .tab file only contains ints. Some columns are correctly displayed as int, but others are represented as floats with no discernible pattern. I've attached a file with tab separated values - renamed it to .txt since .tab cannot be uploaded.

TIA. sample.txt

RandomFractals commented 1 year ago

@akbinod try our Tabular data viewer and see if you get better results. Just change the default view setrting to Perspective. See: https://github.com/RandomFractals/tabular-data-viewer#settings

Tabular data viewer uses more recent version of Perspective viewer for data display.

https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.tabular-data-viewer

RandomFractals commented 1 year ago

Actually, this is the grid view I get in tabular data viewer.

Columns that have 0 on the first row are interpreted as floats by default.

image

Please include screenshots next time. I will close this ticket as duplicate of #321. There are a few other closed tickets with similar issue due to perspective viewer evaluating data type based on the first row column values.

RandomFractals commented 1 year ago

good news: you can change this in the new Tabular data viewer extension. See how for your sample data below:

tabular-data-viewer-floats-precision

akbinod commented 1 year ago

Hi Taras

Thank you for your email. Unfortunately, the extension you mentioned is no longer available on the VS Marketplace.

Regards

BInod

On Mar 13, 2023, at 8:05 AM, Taras Novak @.***> wrote:

@akbinod https://github.com/akbinod try our Tabular data viewer and see if you get better results. Just change the default view setrting to Perspective. See: https://github.com/RandomFractals/tabular-data-viewer#settings

Tabular data viewer uses more recent version of Perspective viewer for data display.

https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.tabular-data-viewer

— Reply to this email directly, view it on GitHub https://github.com/RandomFractals/vscode-data-preview/issues/328#issuecomment-1466021332, or unsubscribe https://github.com/notifications/unsubscribe-auth/AM6SBQCMWVGXL7XJSJMV7JDW34ERVANCNFSM6AAAAAAVXPQ7AI. You are receiving this because you were mentioned.

RandomFractals commented 1 year ago

@akbinod you can still install tabular data viewer using vsix package attached to our last release of that extension:

https://github.com/RandomFractals/tabular-data-viewer/releases