search

saulpw / visidata

A terminal spreadsheet multitool for discovering and arranging data
http://visidata.org
GNU General Public License v3.0
7.47k stars 271 forks source link

Scientific notation shown for column with large number even when type is string #2404

Closed jay-babu closed 2 weeks ago

jay-babu commented 2 weeks ago

Small description

image

Expected result

Seeing the original string that is in the csv

Actual result with screenshot If you get an unexpected error, please include the full stack trace that you get with Ctrl-E.

Steps to reproduce with sample data and a .vd First try reproducing without any user configuration by using the flag -N. e.g. echo "abc" | vd -f txt -N

Please attach the commandlog (saved with Ctrl-D) to show the steps that led to the issue. See here for more details.

Additional context Please include the version of VisiData and Python.

jay-babu commented 2 weeks ago

MarketData_may_v4_fix_v2.csv

saulpw commented 2 weeks ago

I mean that is the string that is in the .csv file, what else would you expect? VisiData does no automatic typing or conversion.