visidata
tidy-viewer
Our great sponsors
visidata | tidy-viewer | |
---|---|---|
36 | 28 | |
7,348 | 2,012 | |
- | - | |
9.8 | 4.3 | |
5 days ago | 6 days ago | |
Python | Rust | |
GNU General Public License v3.0 only | The Unlicense |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
visidata
-
Fx – Terminal JSON Viewer
[4] "Is it possible to "flatten" structured data (like JSON?)": https://github.com/saulpw/visidata/discussions/1605
-
jq 1.7 Released
I also find VisiData is useful for adhoc exploring of JSON data. You can also use it to explore multiple other formats. I find it really helpful, plus it gives that little burst of adrenaline from its responsive TUI, similar to fx and jless mentioned.
For my toolbox I include jq, gron, miller, VisiData, in addition to classics like sed, awk, and perl.
-
Mapping LA's Soft-Story Building Earthquake Retrofit Program [OC]
Visidata - https://visidata.org
-
SQLite interface(s) for creating complex queries with a table that has 68 million rows?
You can try Visidata
-
Terminal Based Programs?
VisiData is an awesome terminal spreadsheet tool. edbrowse for internet browsing.
-
Ask HN: I'm looking for some new spreadsheet software what are people using?
If you are a command-line user, try visidata[0]
-
Hanukkah of Data: Advent of Code for Data Enthusiasts
Help Sarah find the family holiday tapestry before her father notices it's missing! Sharpen your SQL/Python/VisiData skills with Hanukkah of Data.
-
Are there any TUI apps you recommend outside of ncdu / nnn / htop / vim / bat / fd / tig / duf?
Have you heard of Visidata
-
Comepress - I built a tool to automatically convert all the PNG/JPG files in your web project into Next-Gen WebP format. Reduce image bundle size by 80% with Comepress, faster site loading for users and smaller project size for devs!
One of my common use cases is for parallelizing ad-hoc REST API on large batch data by using it in conjunction with cURL (or one-off Python or PHP scripts), jq and VisiData.
tidy-viewer
- Csvlens: Command line CSV file viewer. Like less but made for CSV
-
Are there any TUI apps you recommend outside of ncdu / nnn / htop / vim / bat / fd / tig / duf?
I work with data a lot so I use the sqlite cli. I also made tv (self-promotion) to view csvs.
-
One-liner for running queries against CSV files with SQLite
I am a data scientists. I have used a lot of tools/libraries to interact with data. SQLite is my favorite. It is hard to beat the syntax/grammar.
Also, when I use SQLite I do not output using column mode. I pipe to `tv` (tidy-viewer) to get a pretty output.
-
What are some of your favorite CLI/TUI apps?
tv (cat for csvs) - https://github.com/alexhallam/tv
- Tidy Viewer is a cross-platform CLI csv pretty printer that uses column styling to maximize viewer enjoyment.
-
TV is a cross-platform CSV pretty printer made to maximize viewer enjoyment
1. Looks like 0.0.13 the current version is 0.0.13
2. I need to update the README the binaries are here https://github.com/alexhallam/tv/releases/tag/0.0.13
Ah, I didn't mean a newline at the end of the output. Just a space after your shell prompt ($), see e.g. https://github.com/alexhallam/tv/blob/main/img/column_v_tv2.....
https://github.com/alexhallam/tv/pull/58
I added VisiData in my README and represented it in a positive light in the description. Again, just wanted to apologize for my mistake.
#better-together
And a list of options. Reading the first 80 lines of https://github.com/alexhallam/tv/blob/main/src/main.rs was in some sense more educational than the readme.
It, for example, allowed me to make an educated guess as to the answer to the question “how does this handle huge files?”. It by default only reads 25 lines.
(That makes the example from the header:
cat diamonds.csv | head -n 35 | tv
What are some alternatives?
sc-im - sc-im - Spreadsheet Calculator Improvised -- An ncurses spreadsheet program for terminal
miller - Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON
sqlite-tui - A TUI for viewing and editing database files. [Moved to: https://github.com/mathaou/termdbms]
OpenRefine - OpenRefine is a free, open source power tool for working with messy data and improving it
exa - A modern replacement for ‘ls’.
hledger - Robust, fast, intuitive plain text accounting tool with CLI, TUI and web interfaces.
calcurse - A text-based calendar and scheduling application
fff - 📁 A simple file manager written in bash.
gitui - Blazing 💥 fast terminal-ui for git written in rust 🦀
lazygit - simple terminal UI for git commands
vaex - Out-of-Core hybrid Apache Arrow/NumPy DataFrame for Python, ML, visualization and exploration of big tabular data at a billion rows per second 🚀
murex - A smarter shell and scripting environment with advanced features designed for usability, safety and productivity (eg smarter DevOps tooling)