{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "# Wrangling and hacker stats with Darwin's finches {#exr-finches}\n",
        "\n",
        "- [Dataset 1 download](https://s3.amazonaws.com/bebi103.caltech.edu/data/grant_1973.csv)\n",
        "- [Dataset 2 download](https://s3.amazonaws.com/bebi103.caltech.edu/data/grant_1975.csv)\n",
        "- [Dataset 3 download](https://s3.amazonaws.com/bebi103.caltech.edu/data/grant_1987.csv)\n",
        "- [Dataset 4 download](https://s3.amazonaws.com/bebi103.caltech.edu/data/grant_1991.csv)\n",
        "- [Dataset 5 download](https://s3.amazonaws.com/bebi103.caltech.edu/data/grant_2012.csv)\n",
        "- [Pre-wrangled data set download](https://s3.amazonaws.com/bebi103.caltech.edu/data/grant_complete.csv)\n",
        "<hr />"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "Peter and Rosemary Grant of Princeton University have visited the island of Daphne Major on the Gal\u00e1pagos every year for over forty years and have been taking a careful inventory of the finches there. The Grants published a wonderful book,  [40 years of evolution: Darwin's finches on Daphne Major Island](http://www.worldcat.org/oclc/854285415). They were generous and made their data publicly available on the [Dryad data repository](http://dx.doi.org/10.5061/dryad.g6g3h). \n",
        "\n",
        "We will investigate their measurements of beak depth (the distance, top to bottom, of a closed beak) and beak length (base to tip on the top) of Darwin's finches. The image below defines the beak length and beak depth.\n",
        "\n",
        "![Diagram of finch beaks illustrated length and width.](finch_beak_diagram.png){width=60%}    \n",
        "\n",
        "We will look at data from two species, *Geospiza fortis* and *Geospiza scandens*.  The Grants provided data on the finches of Daphne for the years 1973, 1975, 1987, 1991, and 2012.  I have included the data in the files `grant_1973.csv`, `grant_1975.csv`, `grant_1987.csv`, `grant_1991.csv`, and  `grant_2012.csv`. They are in almost exactly the same format is in the Dryad repository; I have only deleted blank entries at the end of the files. You can complete part (a) if you want to practice data wrangling. Otherwise, you can use [the tidied data set](https://s3.amazonaws.com/bebi103.caltech.edu/data/grant_complete.csv) and proceed to part (b).\n",
        "\n",
        "**a)** The data sets come in separate files, but we would like to merge these all into one data frame.  The problem is that they have different header names, and only the 1973 file has a year entry (called `yearband`).  This is common with real data.  It is often a bit messy and requires some wrangling.  \n",
        "\n",
        "1. First, change the name of the `yearband` column of the 1973 data to `year`.  Also, make sure the year format is four digits, not two!  \n",
        "2. Next, add a `year` column to the other four data frames.  You want tidy data, so each row in the data frame should have an entry for the year.\n",
        "3. Change the column names so that all the data frames have the same column names.  I would choose column names\n",
        "\n",
        "    `['band', 'species', 'beak length (mm)', 'beak depth (mm)', 'year']`\n",
        "\n",
        "4. Concatenate the data frames into a single data frame.\n",
        "\n",
        "\n",
        "**b)** After the wrangling you have done in part (a), your task now is to devise a measure for the *shape* of a beak. That is, invent some scalar measure that combines both the length and depth of the beak and justify your choice. Compare this measure between species and through time. (This is very open-ended. It is up to you to define the measure, make relevant plots, and compute confidence intervals.)"
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3 (ipykernel)",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.13.5"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 4
}