Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

csvlook 1.0.3: Shorting decimals and displaying ellipsis in values #991

Closed
xmarti6 opened this issue Oct 13, 2018 · 1 comment
Closed

csvlook 1.0.3: Shorting decimals and displaying ellipsis in values #991

xmarti6 opened this issue Oct 13, 2018 · 1 comment

Comments

@xmarti6
Copy link

xmarti6 commented Oct 13, 2018

Hi, this issue is related to these:
#824
https://csvkit.readthedocs.io/en/1.0.3/tricks.html#python-standard-output-encoding-errors

When piping like:
<../file.tsv |tail -n+2|head|PYTHONIOENCODING=utf8 csvlook -d$'\t' |less -S

I get values in fields truncated with "ellipsis", e.g: "0.015...". Instead of having three dots i get printed the unicode character corresponding to "ellipsis" u'\u2026', this is why I need to add "PYTHONIOENCODING=utf8" in order to avoid the error "ascii' codec can't encode ...".

My question here is not in regards to "ellipsis" char, but to know why are "ellipsis" added to the values, instead of being able to see the complete float number without rounding up and without adding ellipsis: "0.0148232611174"

I want to point out that this is not an issue in version "0.9.2", values are displayed correctly, unfortunately, using that version I come up with the issue: #383 :(

Many thanks in advance

@jpmckinney
Copy link
Member

csvlook makes a best attempt to make data viewable within a regularly-sized shell window, so it truncates some values. (You can always open the CSV in OpenOffice, LibreOffice, Excel, etc. to see full values.)

Closing as duplicate of #941 which is about configuring the number of decimals to display.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants