Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Tidy Viewer – a cross-platform CSV pretty printer for viewer enjoyment

github.com

Post reply on HN
Print view View original

121–130 of 141 posts

Re: Show HN: Tidy Viewer – a cross-platform CSV pretty printer for viewer enjoyment

#121

Post by IncRnd »

claimred wrote: post #71

Wanted to mention that Windows PowerShell supports pretty CSV printing out of the box, like so Import-Csv .\Levels.csv | Format-Table Count Level elevation Level name Name Object type Unique ID ----- --------------- ---------- ---- ----------- --------- 1 -600.0000000 Store -0,600 - Store Level dc611fed-1783-d759-053a-b19848c51491 1 2850.0000000 Store +2,850 - Store Level c59f2ae4-0e94-6ea0-bd82-8306971e628c 1 3350.0…

So does linux and such:

  cat data.csv | sed 's/,/ ,/g' | column -t -s, | less -S

Re: Show HN: Tidy Viewer – a cross-platform CSV pretty printer for viewer enjoyment

#122

Post by IncRnd »

qorrect wrote: post #103
sixothree wrote: post #75

Earlier quoted context omitted.

There's also ConsoleGridView. https://devblogs.microsoft.com/powershell/introducing-consol...

Dang looks sick, wonder if I get it on *nix.

Yea. That looks nice. Apparently, you can get it on linux, sort of. YMMV.

  https://stackoverflow.com/questions/39180173/powershell-for-linux-workaround-for-missing-out-gridview

Re: Show HN: Tidy Viewer – a cross-platform CSV pretty printer for viewer enjoyment

#123

Post by b0afc375b5 »

oaiey wrote: post #26

There should be a new package next to the traditional gnu tools containing the modern needed tools e.g. jq, curl or tv. Sometimes i really miss the extended sw package on some machines?

I like httpie as an alternative to curl.

Re: Show HN: Tidy Viewer – a cross-platform CSV pretty printer for viewer enjoyment

#124

Post by ac29 »

flusteredBias wrote: post #77
nicoburns wrote: post #69

Earlier quoted context omitted.

> A blank cell is literally missing. That should be filled with NA. Why? "NA" stands for "Not Applicable", but a blank cell in a CSV could represent any number of things of which "Not Applicable" is only one.

haha. You are right "NA" stands for "Not Applicable". That is not always how people/programs using it though. What are some alternatives that you would suggest? I am happy to learn.

I prefer "ND" (No Data), personally.

Re: Show HN: Tidy Viewer – a cross-platform CSV pretty printer for viewer enjoyment

#126

Post by davidatbu »

flusteredBias wrote: post #86
davidatbu wrote: post #35

What is the value-add when compared to using `xsv` to pretty print? Is it only the fact that it highlights NA values?

xsv is one of my favorite data manipulation tools. Also, the author of that package is one of the best developers I know. I use xsv with tv. I normally pipe the output of xsv to tv. 1. As you noted NA comprehension 2. Column overflow logic for different sized terminals 3. Summary meta data in the header 4. Significant digits logic. This allows users to view more columns than they would otherwise view due to decimal d…

Thanks!

Re: Show HN: Tidy Viewer – a cross-platform CSV pretty printer for viewer enjoyment

#128

Post by d4rkp4ttern »

rlue wrote: post #14

Why not visidata? https://www.visidata.org/ https://www.youtube.com/watch?v=N1CBDTgGtOU (It does much, much more than pretty printing, but no reason you can't use it for that.)

Visidata is fantastic, it is a lifesaver for viewing and getting stats on tabular data. It also handles json and others

Re: Show HN: Tidy Viewer – a cross-platform CSV pretty printer for viewer enjoyment

#129

Post by MobiusHorizons »

GuB-42 wrote: post #87
MobiusHorizons wrote: post #25

Earlier quoted context omitted.

Do you think ‘tv I think it’s great for a visualizer like this to encourage people to get used to the power of shell pipelines if possible.

It works, but almost all UNIX commands that work on pipelines can take a list of files as arguments. Out of the commands I use regularly, "patch" is the only one that works exclusively from stdin, probably because file arguments have a different, somewhat obscure, and probably historical meaning. If appropriate, using files as arguments instead of using shell pipelines is a best practice. Commands can optimize for th…

Fair enough.
Post reply on HN