teip VS qsv

try https://github.com/greymd/teip -- readme claims it speeds up things (I have never used it; it's on my "TODO" list to try out)

you need teip; https://github.com/greymd/teip

sad CLI search and replace | Space Age seD tcount Count your code by tokens, types of syntax tree nodes, and patterns in the syntax tree. A tokei/scc/cloc alternative. nushell A new type of shell fclones Efficient Duplicate File Finder hunter The fastest file manager in the galaxy! teip Select partial standard input and replace with the result of another command efficiently cb Command line interface to manage clipboard semiuniq A uniq-like tool for removing nearby repeated lines in a file" dua-cli View disk space usage and delete unwanted data, fast. htmlq Like jq, but for HTML. pipecolor A terminal filter to colorize output crowbook Converts books written in Markdown to HTML, LaTeX/PDF and EPUB delta A viewer for git and diff output mdcat cat for markdown pueue Manage your shell commands. gitui Blazing 💥 fast terminal-ui for git written in rust 🦀 pipr A tool to interactively write shell pipelines. rename Rename your files using your favorite text editor bropages Highly readable supplement to man pages from http://bropages.org. Shows simple, concise examples for commands with syntax highlighting. html2md convert simple html documents into markdown bk Terminal Epub reader rs A safe Rust crate for working with the Wayland clipboard. viu Simple terminal image viewer written in Rust. alacritty A cross-platform, OpenGL terminal emulator. wezterm A GPU-accelerated cross-platform terminal emulator and multiplexer written by @wez and implemented in Rust

Thanks for the detailed feedback @snidane!

As maintainer of qsv, here's my reply:

- Given qsv's rapid release cycle (173 releases over three years), the auto-update check is essential at the moment. Once we reach 1.0, I'll turn it off. For now, given your feedback, I've only made it check 10% of the time.

- Pivot is in the backlog and I'll be sure to add unpivot when I implement it. (https://github.com/jqnatividad/qsv/issues/799)

- I'll add a dedicated summing command with the group by (-by) and window by (-over) capability (https://github.com/jqnatividad/qsv/issues/1514). Do note that `stats` has basic sum as @ezequiel-garzon pointed out.

- With the `enum` command, qsv can achieve what you proposed with `laminate`. E.g. qsv enum --new-column newcol --constant newconstant mydata.csv --output laminated-data.csv

- With the cat rowskey command, qsv can already concatenate files with mismatched headers.

- other file formats. qsv supports parquet, csv, tsv, excel, ods, datapackage, sqlite and more (see https://github.com/jqnatividad/qsv/tree/master#file-formats). Fixed-format though is not supported yet and quite interesting, and have added it to the backlog (https://github.com/jqnatividad/qsv/issues/1515)

- as to "enable embedding outputs of commands", qsv is composable by design, so you can use standard stdin/stdout redirection/piping techniques to have it work with other CLI tools like jq, awk, etc.

Finally, just released v0.120.0 that already incorporates the less aggressive self-update check. https://github.com/jqnatividad/qsv/releases/tag/0.120.0

qsv [1] also has a sqlp command which lets you run Polars SQL queries (even on multiple files). Here I'll send the csv data from stdin (represented by -) and then (optionally) pipe the output to the table command for formatting. The shape of the result is also printed to stderr (the (4, 2) below).

[1] https://github.com/jqnatividad/qsv

$ echo 'Name,Department,Salary

It works quite well IMHO. Using the mlua crate, I’ve managed to integrate Luau as a very powerful data-wrangling DSL for qsv (https://github.com/jqnatividad/qsv)

Maybe this might be better done using this? https://github.com/jqnatividad/qsv

https://github.com/jqnatividad/qsv is another option.