Bacterial metagenomics on the JHU campus: analyzing the data, part III

This is third video in our series on analyzing the DNA sequences that came from bacteria on the JHU campus.

In this video, we use a pivot table to count all the different types of bacteria that students found in 2004 and we make a pie graph to visualize the different numbers of each genus.

The parts of this series are:

I. Downloading the data from iFinch and preparing it for analysis. (this is the video below) (We split the data from one column into three).

II. Cleaning up the data

III. Counting all the bacteria

IV. Counting the bacteria by biome

Part III. Pivot tables from Sandra Porter on Vimeo.

For more information about this project, check here, here, here, and here.