Tag Archives: csv

Default preference reversal in R 4.0.x

I just wrote an entry on my Biochem blog which I think would fit on this site: Default preferences I enjoy using R and RStudio, but I am always weary of upgrading R because that usually leads to some issue(s). The most recent was a bit long for me to diagnose, even though in retrospect… Read More »

in2csv: the Excel killer is part of csvkit the command-line spreadsheet

Summary csvkit is a suite of command-line tools for converting to and working with CSV, the king of tabular file formats. (csvkit can convert XLSX files to CSV.) A good docker container for csvkit: thomasleplus/csv Inspiration: stack overflow article: convert-xlsx-file-to-csv-using-batch Note: I wrote a different version of this on this post elsewhere: csvkit command-line spreadsheet can convert and… Read More »

TableConvert.com – free tabular data formats converter

This is a repost of my post on the Biochemistry department: tableconvert-com-free-tabular-data-formats-converter Tabular formats When I first came to Madison in 1986 as a postdoc with Biochemistry professor Paul Kaesberg to learn cloning and sequencing, I was surprised when he said that the most important program to work with sequences was the (now defunct GCG) program… Read More »

Bioawk for handling bioinformatics formats

Today I found a new tool: bioawk that was written by Heng Li who also wrote samtools and bwa. I first discovered it ont this blog: bioawk-basics (Bioinformatics Workbooks) There is also a short tutorial on GitHub: github.com/vsbuffalo/bioawk-tutorial I also found a recent docker image, and in fact there are only 2 images on docker hub: lbmc/bioawk updated 2 months ago,… Read More »