Displaying 1 to 3 from 3 results

q - q - Run SQL directly on CSV or TSV files

  •    Python

q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and column type detection, and provides full support for multiple encodings.

vcf2tsv - Genomic VCF to tab-separated values

  •    Python

Running vcf2tsv requires Python 3. It also requires that you have cyvcf2 and numpy installed. This can be achieved through the use of pip.

pyexcel-io - One interface to read and write the data in various excel formats, import the data into and export the data from databases

  •    Python

If your company has embedded pyexcel and its components into a revenue generating product, please support me on patreon or bounty source to maintain the project and develop it further. If you are an individual, you are welcome to support me too and for however long you feel like. As my backer, you will receive early access to pyexcel related contents.