I've been using VisiData for about nine months now, and have found it to be tremendously useful. These days, it's typically the first first tool I reach for when examining/exploring a new dataset.
This is really great in helping me understand what I can do with it and how to do it.
The lightning talk is a really great sales pitch, but it's unclear how to actually replicate it. Another video of his, a recommended one after the lightning talk, again loses me a little and goes very fast. I could pause and try to understand... but it's not just about how to do it, but also about knowing that I should be looking to do certain things in the first place.
Your tutorial both gives a nice overview of what features exist, and explains very clearly how to do things. Thanks for taking the time!
I almost didn't bother because it was a video of someone messing with a csv file, but I'm glad I took a few minutes out to watch that.
For everyone who hasn't watched it yet, from what I can tell, this is a clip of someone using a terminal tool they've made for hacking around with tablular data. It looks awesome for exploring data in a partially visual way, driven by commands. I'll often end up doing a bunch of stuff like he demonstrates directly in python — pull out the data, filter, find patterns, calculate new columns. You could probably do much of that with Pandas, but this definitely looks like it would be worth a play.
VisiData is indispensable for data engineering tasks. I've been `head -n 1000 mybigfile.csv | grep somerandomthing | etc | etc`ing for so long, it's ability to give you fast summaries and exploration is such a breath of fresh air!
A thread about the product release is at https://news.ycombinator.com/item?id=16515310. We merged some comments from that thread into this one because this one is currently ranked higher. Also the demo seems to be communicating more about what the project does than the project page.
If you watch the rest of the video I think you’ll find they fit well with their personality and the tone of the demo. I recommend the butts visualization as evidence. Sounds like he’s also looking for anyone willing to glend a hand in testing it out.
since v0.96 it can take input directly from stdin. I very much appreciated that feature as now you can pipe output from mysql (--batch -e)/sqlite and the likes. Would be interesting to use it as a pager inside the mysql prompt.
I don't really see why those two should be compared? Pandas is a Python library for programmatic work with tabular data. Visidata gives you a live view of a file storing tabular data.
Pretty cool but ... why not use a GUI? It would make it 100 times easier to use. He even says at one point "this is all just in the terminal by the way" like that's a good thing!
I am in favor of it being terminal-based, but imho you're giving all the wrong reasons.
If working on a remote machine were really an issue, you'd just mount the remote filesystem or something. That's a small convenience but not a real reason.
That you're already coding in a terminal, didn't disable alt-tab.
Spreadsheets (or to use the brand name, Excel) have a very different focus. You speak as if spreadsheets are just as good as, in this case, Visidata, but the whole point is that this is better. Else, why bother developing and using it? You can indeed just open up your favorite spreadsheet processor.
I think the real reason is that it's universal and convenient. You can use the multitasking features of your favorite shell, and it attracts a certain audience which indeed wants vim-style hotkeys and shortcuts. It also doesn't need a platform to create GUIs on top of, like Electron.
There's room for both reasons. Sometimes when you're working with massive sets of tabular data you don't want to be doing it over a network mounted drive.
What they showed in the lightning demo is so much better done with fast keystrokes than moving a mouse around. I can't wait to try this tool, it will save me days of time per year.
In fact, I've been liking it so much that I wrote a tutorial for first-time users: https://jsvine.github.io/intro-to-visidata/
(Feedback very much welcome / appreciated.)