qsv
usv
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.
qsv
- FLaNK Weekly 31 December 2023
-
Qsv: Efficient CSV CLI Toolkit
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
- Joining CSV Data Without SQL: An IP Geolocation Use Case
-
Why my favourite API is a zipfile on the European Central Bank's website
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
- Qsv: Ultra-fast CSV data-wrangling toolkit
- Qsv: CSVs sliced, diced and analyzed (fork of xsv)
- Nushell.sh ls – where size > 10mb – –sort-by modified
-
Do Rust and Lua work well together?
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)
-
How manipulate this CSV in Python?
Maybe this might be better done using this? https://github.com/jqnatividad/qsv
-
How to convert xslx to csv using Rust?
https://github.com/jqnatividad/qsv is another option.
usv
- How to fix CSV: make it even more U+1F4A9 PILE OF POO
-
Friends don't let friends export to CSV
The reason why USV did not use the proper ASCII codes for field separator and record separator is a bit too pragmatic for me…
https://github.com/SixArm/usv/tree/main/doc/faq#why-use-cont...
-
Show HN: Comma Separated Values (CSV) to Unicode Separated Values (USV)
https://github.com/SixArm/usv/blob/main/doc/criticisms/index...
-
Ask HN: Can you help with IANA, + RFC and ABNF?
I'm working on standardizing a data exchange format and media time, and seeking advice here from anyone experienced with how to do this.
For example, how to properly submit a request to Internet Assigned Numbers Authority (IANA.org), or Internet Engineering Task Force (IETF.org), and proofread the Augmented Backus-Naur Form (ABNF).
The project is Unicode Separated Values (USV) and media type is "text/usv".
Work in progress here: https://github.com/sixarm/usv
My email is [email protected]
Thanks!
- Show HN: Unicode Separated Values (USV) for data formatting
-
Modernizing AWK, a 45-year old language, by adding CSV support
Ben this is great, thank you. Would you be open to adding Unicode Separated Values (USV) as well? It's much like CSV and also simpler because of no escaping and no quoting. I can donate $50 to you or your charity of choice as a token of thanks and encouragement.
https://github.com/sixarm/usv
- GitHub - SixArm/usv: USV: Unicode Separated Values
- Show HN: USV = Unicode Separated Values
What are some alternatives?
miller - Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON
tsv-utils - eBay's TSV Utilities: Command line tools for large, tabular data files. Filtering, statistics, sampling, joins and more.
calamine - A pure Rust Excel/OpenDocument SpreadSheets file reader: rust on metal sheets
goawk - A POSIX-compliant AWK interpreter written in Go, with CSV support
fortune-sheet - A drop-in javascript spreadsheet library that provides rich features like Excel and Google Sheets
nio - Low Overhead Numerical/Native IO library & tools
csvquote
ess-view-data - View data support for ESS
zsv - zsv+lib: tabular data swiss-army knife CLI + world's fastest (simd) CSV parser