mdavy86

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

mdavy86

Problem

Incorrectly formatting of Vine identifiers from Excel sources for eBrida. For example, the identifier

Incorrect Excel format	conversion	Correct eBrida format
TO8.33.06.15F	=>	T08.33-06-15f

---

mdavy86

HOWTO Parse vcf to DT

John McCallum 15 July 2016

Goal

• work out tidiest way to split up haplotypes from phased vcf in data.table for plotting haplotypes

mdavy86

- Click anywhere within the data table
- Hit the key combination Alt - d - p to bring up the Pivot Table Wizard (which is not on the ribbon)
- Select "Multiple consolidation ranges" and click Next
- Select "I will create the page fields" and click Next
- Select your data table (in the example it's A1:E11)  and click Next
- Select the location and click Next
Now you will see a pivot table that looks just like your data table
- Click the Pivot table and in the field list uncheck Row and Column (and uncheck any Page Field, if present)
- Now select the cell with the single remaining total number and double click it.
The result is a new sheet with your data laid out one item per row.

mdavy86

Learning Python

Getting Started with Python

There are a huge range of tutorials and books available for learning Python. There are a couple things to watch out for when selecting learning material:

1. Python 2 & 3 are very similar but subtly different languages. This can be a bit of a pain point when first learning Python so be aware of what version a tutorial or book is demonstrating. I highly recommend sticking to Python 3 as Python 2 is slowly being phased out of existence.
2. Python is a very general purpose language (e.g. compared to R) so a lot of material is focused on web development, games and etc. The style of code used can be different between these topics so try to find learning material from an appropriate domain.

Bellow is a list of resources that are generally more focussed towards science and numerical programming rather than other topics (e.g. web development). I have used parts of most of these or otherwise trust the source of the material.