Top 16 Tsv Open-Source Projects
q - Run SQL directly on CSV or TSV files (by harelba)Project mention: What are the most useful VSCode extensions you know which could be reimplemented in Emacs? | reddit.com/r/emacs | 2021-03-31
I would love if someone ported this to emacs, but perhaps in the meantime check out q (https://github.com/harelba/q), a command line tool that offers similar query abilities.
A list of command line tools for manipulating structured text dataProject mention: Consultare un databate XML, JSON, CVS o RDF | reddit.com/r/ItalyInformatica | 2021-03-31
Per una vasta lista commentata vedi https://github.com/dbohdan/structured-text-tools
Scout APM - Leading-edge performance monitoring starting at $39/month. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
A terminal spreadsheet multitool for discovering and arranging dataProject mention: `uq is a simple, user-friendly alternative to `sort | uniq`. | reddit.com/r/commandline | 2021-04-15
Run vd (VisiData on the file, press Shift+F, instant unique lines sorted by number of uses. Like sort | uniq -c | sort -n in one go.
Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSONProject mention: Consultare un databate XML, JSON, CVS o RDF | reddit.com/r/ItalyInformatica | 2021-03-31
eBay's TSV Utilities: Command line tools for large, tabular data files. Filtering, statistics, sampling, joins and more.Project mention: Return 1 to N results from a large (19MM line) CSV | reddit.com/r/commandline | 2021-04-17
May well be overkill for your needs, but I'm a fan of tsv-utils It's fast and enormously flexible, and seems to me a "best of breed" toolset for data mining CSV files (that is what it was written for). https://github.com/eBay/tsv-utils
A cross-platform, efficient and practical CSV/TSV toolkit in GolangProject mention: csvtk - CSV/TSV Toolkit | reddit.com/r/planetemacs | 2021-04-01
CSV parser for SwiftProject mention: Reading from spreadsheet | reddit.com/r/SwiftUI | 2021-03-09
Fast reading of delimited filesProject mention: Is there a way to load a large SAS7BDAT dataset into R efficiently with fair speed? | reddit.com/r/rstats | 2021-03-23
You can use an `rds` file. You have to read it in then write it out though. If you care about speed, then just use `readr::write_rds`, which is similar to the base `saveRDS`, but with compression off, but the file size will be much larger. You can also use random access objects, such as `fst`: https://www.fstpackage.org/, but again, need to write it out. I tried a quick benchmark and `haven` is much faster than `sas7bdat` package. If it's in a plain text delimited file, you can also look into `vroom`: https://github.com/r-lib/vroom
🌈Rainbow CSV - Vim plugin: Highlight columns in CSV and TSV files and run queries in SQL-like languageProject mention: Any recommendations for a cli CSV editor? | reddit.com/r/commandline | 2021-03-24
Rainbow CSV, for visual color highlighting and has an SQL-like language for running data queries.
swiss-army knife for dataProject mention: sq: swiss-army knife for data | news.ycombinator.com | 2021-03-05
Reads and writes CSV, fixed-length and other flat file formats with a focus on schema definition, configuration and speed.Project mention: Limit length of string in fixed width flat file | reddit.com/r/csharp | 2021-01-07
If this is for production code and not just learning, I've had success using FlatFiles before, which can enforce this sort of thing for you.
🧚 pxi (pixie) is a small, fast, and magical command-line data processor similar to jq, mlr, and awk.Project mention: List of JSON tools for command line | reddit.com/r/commandline | 2021-03-27
Schema registry for CSV, TSV, JSON, AVRO and Parquet schema. Supports schema inference and GraphQL API.
JupyterLab spreadsheet editor for tabular data (e.g. csv, tsv)Project mention: Spreadsheet editor extension is now compatible with JupyterLab 3.0 | reddit.com/r/JupyterLab | 2021-03-17
A small RFC-4180 compliant VBA library to manipulate CSV files at the highest speed.Project mention: Using VBA CSV interface to work with USA Cartographic Boundary Files (Shapefiles) | reddit.com/r/vba | 2021-04-20
Working from Notepad++ gave me an idea of how the text strings should be manipulated from VBA. The first thing to do from the VBA CSV interface will be to import only the fields that contain the relevant data to solve the problem (the_geom and NAME). The files created in this step (temporary) will be saved in the same folder.
Go library for parsing and deserialising CSV files into Go objectsProject mention: Yet another CSV parsing library | reddit.com/r/golang | 2021-04-04
My slightly different take on CSV parsing library: https://github.com/stefantds/csvdecoder
What are some of the best open-source Tsv projects? This list will help you: