Category Archives: Computation

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 »

A great Unix tutorial suitable for beginners

More than once I have written my own tutorials for learning how to use the command line within the bash shell in the context of a Unix or Unix-like computer. Recently I found a very well done tutorial that, while titled “Unix for Neuroimagers”  provides a wonderfully well done, easy to understand set of small… Read More »

PCA as Metro-Maps & Hierarchical Clustering on Principal Components

The iris dataset is perhaps one of the most famous datasets used to learn and teach statistics and now machine learning. Being curious about this dataset lead me last time to the TableConvert.com  web site that I discussed in my previous post here (and there.) “Metro Maps” Today while revisiting the Wikipedia link for this dataset (Iris_flower_data_set) my… 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 »

Hunting for SRA sequence archives

SRA: Sequence Read Archive The Sequence Read Archive (SRA) makes biological sequence data available to the research community to enhance reproducibility and allow for new discoveries by comparing data sets. The SRA stores raw sequencing data and alignment information from high-throughput sequencing platforms, […] However, it is rather difficult to even find the download links… and even… Read More »