Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →
Top 23 Tsv Open-Source Projects
-
miller
Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
winmerge
WinMerge is an Open Source differencing and merging tool for Windows. WinMerge can compare both folders and files, presenting differences in a visual text format that is easy to understand and handle.
-
-
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
tsv-utils
eBay's TSV Utilities: Command line tools for large, tabular data files. Filtering, statistics, sampling, joins and more.
-
-
-
rainbow_csv
🌈Rainbow CSV - Vim plugin: Highlight columns in CSV and TSV files and run queries in SQL-like language
-
FlatFiles
Reads and writes CSV, fixed-length and other flat file formats with a focus on schema definition, configuration and speed.
-
pxi
🧚 pxi (pixie) is a small, fast, and magical command-line data processor similar to jq, mlr, and awk.
-
Ididit
C# .NET 7 Blazor habit tracker application. Works on Web, Windows, Linux, Android, iOS and macOS.
-
zsv
zsv+lib: world's fastest (simd) CSV parser, bare metal or wasm, with an extensible CLI for SQL querying, format conversion and more
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
[4] "Is it possible to "flatten" structured data (like JSON?)": https://github.com/saulpw/visidata/discussions/1605
Neat! Once you're installing something to do terminal plots though, https://github.com/red-data-tools/YouPlot looks the nicest I've seen
You might want to look at tsv-utils, or a similar project: https://github.com/eBay/tsv-utils
For the SQL part, but maybe a lot heavier, you can use one of the projects listed on this page: https://github.com/multiprocessio/dsq (No longer maintained, but has links to lots of other projects)
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
Project mention: Frawk: An efficient Awk-like programming language. (2021) | news.ycombinator.com | 2024-04-21If you need just csv/tsv parsing, you can also take a look at https://github.com/eBay/tsv-utils
No problem. You might also be interested in csvtk https://github.com/shenwei356/csvtk from the same group. Very handy set of tools.
Probably not an exact fit, but this plugin came to mind: rainbow_csv
Project mention: Show HN: I built jq-like scriptable tool to query CSV and JSON with SQLite | news.ycombinator.com | 2024-02-24Is this related to the other SQ? https://github.com/neilotoole/sq
Ididit
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
Tsv related posts
- Qsv: Efficient CSV CLI Toolkit
- Tracking SQLite Database Changes in Git
- Joining CSV Data Without SQL: An IP Geolocation Use Case
- Align primers to a reference sequence.
- stable: a package for streaming pretty text table
- Qsv: Ultra-fast CSV data-wrangling toolkit
- Qsv: CSVs sliced, diced and analyzed (fork of xsv)
-
A note from our sponsor - InfluxDB
www.influxdata.com | 24 Apr 2024
Index
What are some of the best open-source Tsv projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | q | 10,109 |
| 2 | miller | 8,553 |
| 3 | visidata | 7,409 |
| 4 | structured-text-tools | 6,865 |
| 5 | winmerge | 5,698 |
| 6 | YouPlot | 3,919 |
| 7 | dsq | 3,619 |
| 8 | qsv | 2,214 |
| 9 | tsv-utils | 1,396 |
| 10 | csvtk | 953 |
| 11 | SwiftCSV | 901 |
| 12 | vroom | 608 |
| 13 | rainbow_csv | 569 |
| 14 | sq | 510 |
| 15 | FlatFiles | 350 |
| 16 | sqawk | 308 |
| 17 | RecordParser | 271 |
| 18 | pxi | 267 |
| 19 | datadash | 234 |
| 20 | Ididit | 209 |
| 21 | zsv | 170 |
| 22 | cascadia | 134 |
| 23 | jupyterlab-spreadsheet-editor | 114 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com