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.

More like this

There has been a lot of media attention on drug-resistant bacteria lately.
Spiteful bacteria. Two words you probably haven't heard together. Then again, you probably haven't heard of altruistic bacteria either, but both sorts of microbes are out there--and in many cases in you.
You would think after the sound thrashing Michael Egnor received due to his mangling of the basics of evolutionary biology, the Discovery Institute might want to find someone else to quote in a gu