(Last edit: April 11, 2023) Summary How to deal with many Excel files If I had had the information I was looking for within a single Excel spreadsheet I would not have found csvkit because I would simply have copied the column containing the data I wanted, in that case a list of email. But …
SUMMARY: Check calendar for Free "R" and "Python" workshops (Steenbock Library.) "Introduction to R with RStudio," "Data Wrangling in R" (SSCC - Social Science Computing Cooperative.) "Automating Tasks with the Unix Shell," "Data Management with SQL," "Introduction to Docker" (Software Carpentry through UW-Madison Data Science (fees apply).)
Does data analysis feel like the impossible job of "catching the moon?" Fortunately R and RStudio are great tools to analyze data and illustrate conclusions, while at the same time keeping records and create "live" documents that can be updated with "just one click." The material is written in a way that is conducive to "learn by doing" following demonstrations and examples. All code and all necessary materials and files are available and therefore it is possible to learn and acquire proficiency on one's own with this course content.
...provides a wonderfully well done, easy to understand set of small tutorials, with exercises, each with an accompanying video that should make it easier for beginners that want to learn Unix command line / bash.... To make is faster to navigate the lessons and videos I have combined both into a simple table...
I regularly roam the Internet in search of solutions to simple questions and often find the answers in sites such as stackoverflow.com, biostars.org or similar forums. Once in a while I find interesting, free materials, such as the FREE “Think” book series by Allen B. Downey on Green Tea Press. The premise of this series …
This is a list of R material that I found online that I think can be useful as reference or as working material to learn R / RStudio / Mardkown. I’ll try to separate the links between “Classic” and “Tidyverse” versions, but that is not always possible… “Tidyverse” would include plotting with ggplot2 R package which …
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 REFORMAT. And “boy” was he right, as in my 30+ years …
Winter 2020 Programming Workshops on Campus In the past years I have offered python 3, R, and RStudio workshops within the Biochem Department (see links below.) R is both a language and a software environment for statistical computing and graphics. R (and other languages) can be used through the amazing RStudio interface for even more performance, ease …
Reproducible research Docker is a great tool to provide methods for reproducible research that should allow other researchers to reproduce any advanced calculations that you, as a researcher have done, most likely in association with publishing a paper. However, there are many caveats along the way, the first one being explanations on how to launch …
A couple years ago I wrote a short note on another blog (DNA.today – link below) about a web site that can be quite useful: it provides the name of alternate software. The site is: alternativeto.net For example, if you cannot afford Adobe PhotoShop you would be glad to find an alternative in “Gimp” (GNU Image Manipulation Program.) The …