Open-source projects categorized as Tsv
Related topics: #CSV #JSON #Command-line #CLI #SQL

Top 16 Tsv Open-Source Projects

  • GitHub repo q

    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.

  • GitHub repo structured-text-tools

    A list of command line tools for manipulating structured text data

    Project 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

  • GitHub repo visidata

    A terminal spreadsheet multitool for discovering and arranging data

    Project 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.

  • GitHub repo miller

    Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON

    Project mention: Consultare un databate XML, JSON, CVS o RDF | reddit.com/r/ItalyInformatica | 2021-03-31
  • GitHub repo tsv-utils

    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

  • GitHub repo csvtk

    A cross-platform, efficient and practical CSV/TSV toolkit in Golang

    Project mention: csvtk - CSV/TSV Toolkit | reddit.com/r/planetemacs | 2021-04-01
  • GitHub repo SwiftCSV

    CSV parser for Swift

    Project mention: Reading from spreadsheet | reddit.com/r/SwiftUI | 2021-03-09

    Maybe this?

  • GitHub repo vroom

    Fast reading of delimited files

    Project 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

  • GitHub repo rainbow_csv

    🌈Rainbow CSV - Vim plugin: Highlight columns in CSV and TSV files and run queries in SQL-like language

    Project 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.

  • GitHub repo sq

    swiss-army knife for data

    Project mention: sq: swiss-army knife for data | news.ycombinator.com | 2021-03-05
  • GitHub repo FlatFiles

    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.

  • GitHub repo pxi

    🧚 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
  • GitHub repo Schemer

    Schema registry for CSV, TSV, JSON, AVRO and Parquet schema. Supports schema inference and GraphQL API.

  • GitHub repo jupyterlab-spreadsheet-editor

    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
  • GitHub repo VBA-CSV-interface

    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.

  • GitHub repo csvdecoder

    Go library for parsing and deserialising CSV files into Go objects

    Project 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

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). The latest post mention was on 2021-04-20.


What are some of the best open-source Tsv projects? This list will help you:

Project Stars
1 q 8,110
2 structured-text-tools 5,690
3 visidata 3,739
4 miller 2,710
5 tsv-utils 1,224
6 csvtk 575
7 SwiftCSV 527
8 vroom 475
9 rainbow_csv 339
10 sq 310
11 FlatFiles 278
12 pxi 249
13 Schemer 97
14 jupyterlab-spreadsheet-editor 36
15 VBA-CSV-interface 12
16 csvdecoder 9