{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>additions</th>\n",
       "      <th>deletions</th>\n",
       "      <th>filename</th>\n",
       "      <th>author</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>pom.xml</td>\n",
       "      <td>Dave Syer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>readme.md</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>pom.xml</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>pom.xml</td>\n",
       "      <td>Stephane Nicoll</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>src/main/java/org/springframework/samples/petc...</td>\n",
       "      <td>Stephane Nicoll</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  additions deletions                                           filename  \\\n",
       "1         2         3                                            pom.xml   \n",
       "3         1         1                                          readme.md   \n",
       "5         1         0                                            pom.xml   \n",
       "7         1         1                                            pom.xml   \n",
       "8        11         9  src/main/java/org/springframework/samples/petc...   \n",
       "\n",
       "            author  \n",
       "1        Dave Syer  \n",
       "3      Antoine Rey  \n",
       "5      Antoine Rey  \n",
       "7  Stephane Nicoll  \n",
       "8  Stephane Nicoll  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "git_log = pd.read_csv(\n",
    "    \"../../../spring-petclinic/git_knowledge.log\",\n",
    "    names=['additions', 'deletions', 'filename', 'author'],\n",
    "    sep='\\t')\n",
    "git_log['author'] = git_log['author'].ffill()\n",
    "git_log = git_log.dropna()\n",
    "git_log.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>additions</th>\n",
       "      <th>deletions</th>\n",
       "      <th>filename</th>\n",
       "      <th>author</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4185</th>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>.classpath</td>\n",
       "      <td>Michael Isvy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4501</th>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>.classpath</td>\n",
       "      <td>Michael Isvy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4669</th>\n",
       "      <td>28</td>\n",
       "      <td>6</td>\n",
       "      <td>.classpath</td>\n",
       "      <td>Michael Isvy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4776</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>.classpath</td>\n",
       "      <td>Rossen Stoyanchev</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4859</th>\n",
       "      <td>8</td>\n",
       "      <td>36</td>\n",
       "      <td>.classpath</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5094</th>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>.classpath</td>\n",
       "      <td>Costin Leau</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     additions deletions    filename             author\n",
       "4185         0        32  .classpath       Michael Isvy\n",
       "4501         0         5  .classpath       Michael Isvy\n",
       "4669        28         6  .classpath       Michael Isvy\n",
       "4776         2         2  .classpath  Rossen Stoyanchev\n",
       "4859         8        36  .classpath       Keith Donald\n",
       "5094        43         0  .classpath        Costin Leau"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "git_log[git_log['filename'] == \".classpath\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>additions</th>\n",
       "      <th>deletions</th>\n",
       "      <th>filename</th>\n",
       "      <th>author</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>.bowerrc</td>\n",
       "      <td>Dapeng</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1888</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>.bowerrc</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2971</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>.bowerrc</td>\n",
       "      <td>Faycal Ihabritane</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     additions deletions  filename             author\n",
       "362          0         3  .bowerrc             Dapeng\n",
       "1888         1         1  .bowerrc        Antoine Rey\n",
       "2971         3         0  .bowerrc  Faycal Ihabritane"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "git_log[git_log['filename'] == \".bowerrc\"]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pd.DataFrame.var?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "filename\n",
       ".bowerrc                                                                                                 3\n",
       ".classpath                                                                                               6\n",
       ".editorconfig                                                                                            2\n",
       ".gitignore                                                                                               8\n",
       ".mvn/wrapper/maven-wrapper.jar                                                                           1\n",
       ".mvn/wrapper/maven-wrapper.properties                                                                    1\n",
       ".project                                                                                                 5\n",
       ".settings/.jsdtscope                                                                                     3\n",
       ".settings/com.springsource.server.ide.jdt.core.xml                                                       2\n",
       ".settings/org.eclipse.jdt.core.prefs                                                                     3\n",
       ".settings/org.eclipse.jst.common.project.facet.core.prefs                                                2\n",
       ".settings/org.eclipse.m2e.core.prefs                                                                     2\n",
       ".settings/org.eclipse.m2e.wtp.prefs                                                                      2\n",
       ".settings/org.eclipse.wst.common.component                                                               5\n",
       ".settings/org.eclipse.wst.common.project.facet.core.xml                                                  3\n",
       ".settings/org.eclipse.wst.jsdt.ui.superType.container                                                    2\n",
       ".settings/org.eclipse.wst.jsdt.ui.superType.name                                                         2\n",
       ".settings/org.eclipse.wst.validation.prefs                                                               2\n",
       ".settings/org.maven.ide.eclipse.prefs                                                                    2\n",
       ".settings/org.springframework.ide.eclipse.beans.core.prefs                                               2\n",
       ".settings/org.springframework.ide.eclipse.core.prefs                                                     3\n",
       ".springBeans                                                                                            14\n",
       ".travis.yml                                                                                              2\n",
       "README.md                                                                                                2\n",
       "authors.txt                                                                                              2\n",
       "bower.json                                                                                               3\n",
       "db/build.xml                                                                                             2\n",
       "db/dropTables.txt                                                                                        2\n",
       "db/emptyDB.txt                                                                                           2\n",
       "db/mysql/createDB.txt                                                                                    2\n",
       "                                                                                                        ..\n",
       "src/test/java/org/springframework/samples/petclinic/vet/VetControllerTests.java                          1\n",
       "src/test/java/org/springframework/samples/petclinic/vet/VetTests.java                                    1\n",
       "src/test/java/org/springframework/samples/petclinic/web/CrashControllerTests.java                        6\n",
       "src/test/java/org/springframework/samples/petclinic/web/OwnerControllerTests.java                        9\n",
       "src/test/java/org/springframework/samples/petclinic/web/PetControllerTests.java                          9\n",
       "src/test/java/org/springframework/samples/petclinic/web/PetTypeFormatterTests.java                       2\n",
       "src/test/java/org/springframework/samples/petclinic/web/VetControllerTest.java                           2\n",
       "src/test/java/org/springframework/samples/petclinic/web/VetControllerTests.java                         15\n",
       "src/test/java/org/springframework/samples/petclinic/web/VisitControllerTests.java                       10\n",
       "src/test/java/org/springframework/samples/petclinic/web/VisitsAtomViewTest.java                         10\n",
       "src/test/java/org/springframework/samples/petclinic/web/VisitsAtomViewTestWithContainer-config.xml       3\n",
       "src/test/java/org/springframework/samples/petclinic/web/VisitsAtomViewWithContainerTest.java             3\n",
       "src/test/java/org/springframework/samples/petclinic/web/VisitsViewTest-config.xml                        3\n",
       "src/test/java/org/springframework/samples/petclinic/web/VisitsViewTest.java                              4\n",
       "src/test/java/org/springframework/samples/petclinic/web/VisitsViewTests-config.xml                       2\n",
       "src/test/java/org/springframework/samples/petclinic/web/VisitsViewTests.java                             5\n",
       "src/test/jmeter/petclinic_test_plan.jmx                                                                  4\n",
       "src/test/resources/log4j.xml                                                                             2\n",
       "src/test/resources/logback-test.xml                                                                      3\n",
       "src/test/resources/org/springframework/samples/petclinic/AbstractClinicTests-context.xml                 5\n",
       "src/test/resources/org/springframework/samples/petclinic/hibernate/HibernateClinicTests-context.xml      3\n",
       "src/test/resources/org/springframework/samples/petclinic/jdbc/JdbcClinicTests-context.xml                2\n",
       "src/test/resources/org/springframework/samples/petclinic/jdbc/SimpleJdbcClinicTests-context.xml          2\n",
       "src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-entityManager.xml        3\n",
       "src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-hibernateAdapter.xml     2\n",
       "src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-jpaCommon.xml            5\n",
       "src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-openJpaAdapter.xml       2\n",
       "src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-toplinkAdapter.xml       2\n",
       "src/test/resources/spring/mvc-test-config.xml                                                            1\n",
       "travis.yml                                                                                               2\n",
       "Name: author, Length: 1674, dtype: int64"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "git_log['aid'] = pd.factorize(git_log.author)[0]\n",
    "gs = git_log.groupby('filename')['author']\n",
    "# pd.DataFrame(gs.ndim() / gs.count())\n",
    "gs."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>additions</th>\n",
       "      <th>deletions</th>\n",
       "      <th>filename</th>\n",
       "      <th>author</th>\n",
       "      <th>aid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>.bowerrc</td>\n",
       "      <td>Dapeng</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1888</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>.bowerrc</td>\n",
       "      <td>Antoine Rey</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2971</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>.bowerrc</td>\n",
       "      <td>Faycal Ihabritane</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     additions deletions  filename             author  aid\n",
       "362          0         3  .bowerrc             Dapeng    7\n",
       "1888         1         1  .bowerrc        Antoine Rey    1\n",
       "2971         3         0  .bowerrc  Faycal Ihabritane   21"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "git_log[git_log['filename'] == \".bowerrc\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>additions</th>\n",
       "      <th>deletions</th>\n",
       "      <th>filename</th>\n",
       "      <th>author</th>\n",
       "      <th>aid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3023</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>.editorconfig</td>\n",
       "      <td>Antoine Rey</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3028</th>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>.editorconfig</td>\n",
       "      <td>Antoine Rey</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     additions deletions       filename       author  aid\n",
       "3023         5         2  .editorconfig  Antoine Rey    1\n",
       "3028         9         0  .editorconfig  Antoine Rey    1"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "git_log[git_log['filename'] == \".editorconfig\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>additions</th>\n",
       "      <th>deletions</th>\n",
       "      <th>filename</th>\n",
       "      <th>author</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>.gitignore</td>\n",
       "      <td>Dave Syer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>.gitignore</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1862</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>.gitignore</td>\n",
       "      <td>Patrick Crocker</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1879</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>.gitignore</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3440</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>.gitignore</td>\n",
       "      <td>Cyrille Le Clerc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3519</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>.gitignore</td>\n",
       "      <td>Michael Isvy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4186</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>.gitignore</td>\n",
       "      <td>Michael Isvy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4667</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>.gitignore</td>\n",
       "      <td>Michael Isvy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     additions deletions    filename            author\n",
       "66           1         0  .gitignore         Dave Syer\n",
       "358          2         0  .gitignore       Antoine Rey\n",
       "1862         0         1  .gitignore   Patrick Crocker\n",
       "1879         1         0  .gitignore       Antoine Rey\n",
       "3440         2         1  .gitignore  Cyrille Le Clerc\n",
       "3519         1         0  .gitignore      Michael Isvy\n",
       "4186         1         0  .gitignore      Michael Isvy\n",
       "4667         4         0  .gitignore      Michael Isvy"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "git_log[git_log['filename'] == \".gitignore\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>additions</th>\n",
       "      <th>deletions</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>filename</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>.bowerrc</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.classpath</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.editorconfig</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.gitignore</th>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.mvn/wrapper/maven-wrapper.jar</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.mvn/wrapper/maven-wrapper.properties</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.project</th>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/.jsdtscope</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/com.springsource.server.ide.jdt.core.xml</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.jdt.core.prefs</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.jst.common.project.facet.core.prefs</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.m2e.core.prefs</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.m2e.wtp.prefs</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.wst.common.component</th>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.wst.common.project.facet.core.xml</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.wst.jsdt.ui.superType.container</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.wst.jsdt.ui.superType.name</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.wst.validation.prefs</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.maven.ide.eclipse.prefs</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.springframework.ide.eclipse.beans.core.prefs</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.springframework.ide.eclipse.core.prefs</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.springBeans</th>\n",
       "      <td>50.000000</td>\n",
       "      <td>50.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.travis.yml</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>README.md</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>authors.txt</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bower.json</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>db/build.xml</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>db/dropTables.txt</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>db/emptyDB.txt</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>db/mysql/createDB.txt</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/vet/VetControllerTests.java</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/vet/VetTests.java</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/CrashControllerTests.java</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/OwnerControllerTests.java</th>\n",
       "      <td>12.000000</td>\n",
       "      <td>12.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/PetControllerTests.java</th>\n",
       "      <td>12.000000</td>\n",
       "      <td>12.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/PetTypeFormatterTests.java</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VetControllerTest.java</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VetControllerTests.java</th>\n",
       "      <td>20.000000</td>\n",
       "      <td>20.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitControllerTests.java</th>\n",
       "      <td>10.333333</td>\n",
       "      <td>10.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsAtomViewTest.java</th>\n",
       "      <td>16.333333</td>\n",
       "      <td>16.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsAtomViewTestWithContainer-config.xml</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsAtomViewWithContainerTest.java</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsViewTest-config.xml</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsViewTest.java</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsViewTests-config.xml</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsViewTests.java</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/jmeter/petclinic_test_plan.jmx</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/log4j.xml</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/logback-test.xml</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/AbstractClinicTests-context.xml</th>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/hibernate/HibernateClinicTests-context.xml</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jdbc/JdbcClinicTests-context.xml</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jdbc/SimpleJdbcClinicTests-context.xml</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-entityManager.xml</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-hibernateAdapter.xml</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-jpaCommon.xml</th>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-openJpaAdapter.xml</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-toplinkAdapter.xml</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/spring/mvc-test-config.xml</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>travis.yml</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1674 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    additions  deletions\n",
       "filename                                                                \n",
       ".bowerrc                                             0.000000   0.000000\n",
       ".classpath                                           1.000000   1.000000\n",
       ".editorconfig                                             NaN        NaN\n",
       ".gitignore                                           0.800000   0.800000\n",
       ".mvn/wrapper/maven-wrapper.jar                            NaN        NaN\n",
       ".mvn/wrapper/maven-wrapper.properties                     NaN        NaN\n",
       ".project                                             0.250000   0.250000\n",
       ".settings/.jsdtscope                                 0.500000   0.500000\n",
       ".settings/com.springsource.server.ide.jdt.core.xml   0.000000   0.000000\n",
       ".settings/org.eclipse.jdt.core.prefs                 0.500000   0.500000\n",
       ".settings/org.eclipse.jst.common.project.facet....   0.000000   0.000000\n",
       ".settings/org.eclipse.m2e.core.prefs                      NaN        NaN\n",
       ".settings/org.eclipse.m2e.wtp.prefs                       NaN        NaN\n",
       ".settings/org.eclipse.wst.common.component           0.333333   0.333333\n",
       ".settings/org.eclipse.wst.common.project.facet....   0.500000   0.500000\n",
       ".settings/org.eclipse.wst.jsdt.ui.superType.con...   0.000000   0.000000\n",
       ".settings/org.eclipse.wst.jsdt.ui.superType.name     0.000000   0.000000\n",
       ".settings/org.eclipse.wst.validation.prefs           0.000000   0.000000\n",
       ".settings/org.maven.ide.eclipse.prefs                0.000000   0.000000\n",
       ".settings/org.springframework.ide.eclipse.beans...   0.000000   0.000000\n",
       ".settings/org.springframework.ide.eclipse.core....   0.500000   0.500000\n",
       ".springBeans                                        50.000000  50.000000\n",
       ".travis.yml                                          0.000000   0.000000\n",
       "README.md                                                 NaN        NaN\n",
       "authors.txt                                               NaN        NaN\n",
       "bower.json                                           0.000000   0.000000\n",
       "db/build.xml                                              NaN        NaN\n",
       "db/dropTables.txt                                         NaN        NaN\n",
       "db/emptyDB.txt                                            NaN        NaN\n",
       "db/mysql/createDB.txt                                     NaN        NaN\n",
       "...                                                       ...        ...\n",
       "src/test/java/org/springframework/samples/petcl...        NaN        NaN\n",
       "src/test/java/org/springframework/samples/petcl...        NaN        NaN\n",
       "src/test/java/org/springframework/samples/petcl...   3.000000   3.000000\n",
       "src/test/java/org/springframework/samples/petcl...  12.000000  12.000000\n",
       "src/test/java/org/springframework/samples/petcl...  12.000000  12.000000\n",
       "src/test/java/org/springframework/samples/petcl...   0.000000   0.000000\n",
       "src/test/java/org/springframework/samples/petcl...        NaN        NaN\n",
       "src/test/java/org/springframework/samples/petcl...  20.000000  20.000000\n",
       "src/test/java/org/springframework/samples/petcl...  10.333333  10.333333\n",
       "src/test/java/org/springframework/samples/petcl...  16.333333  16.333333\n",
       "src/test/java/org/springframework/samples/petcl...   0.500000   0.500000\n",
       "src/test/java/org/springframework/samples/petcl...   0.500000   0.500000\n",
       "src/test/java/org/springframework/samples/petcl...        NaN        NaN\n",
       "src/test/java/org/springframework/samples/petcl...        NaN        NaN\n",
       "src/test/java/org/springframework/samples/petcl...        NaN        NaN\n",
       "src/test/java/org/springframework/samples/petcl...        NaN        NaN\n",
       "src/test/jmeter/petclinic_test_plan.jmx              2.000000   2.000000\n",
       "src/test/resources/log4j.xml                         0.000000   0.000000\n",
       "src/test/resources/logback-test.xml                  0.500000   0.500000\n",
       "src/test/resources/org/springframework/samples/...   0.250000   0.250000\n",
       "src/test/resources/org/springframework/samples/...   0.500000   0.500000\n",
       "src/test/resources/org/springframework/samples/...        NaN        NaN\n",
       "src/test/resources/org/springframework/samples/...   0.000000   0.000000\n",
       "src/test/resources/org/springframework/samples/...   0.500000   0.500000\n",
       "src/test/resources/org/springframework/samples/...   0.000000   0.000000\n",
       "src/test/resources/org/springframework/samples/...   0.250000   0.250000\n",
       "src/test/resources/org/springframework/samples/...   0.000000   0.000000\n",
       "src/test/resources/org/springframework/samples/...   0.000000   0.000000\n",
       "src/test/resources/spring/mvc-test-config.xml             NaN        NaN\n",
       "travis.yml                                                NaN        NaN\n",
       "\n",
       "[1674 rows x 2 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gb = git_log.groupby(['filename', 'author']).count()\n",
    "gb.groupby(gb.index.get_level_values(0)).var()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>additions</th>\n",
       "      <th>deletions</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>filename</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>.bowerrc</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.classpath</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.editorconfig</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.gitignore</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.mvn/wrapper/maven-wrapper.jar</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.mvn/wrapper/maven-wrapper.properties</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.project</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/.jsdtscope</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/com.springsource.server.ide.jdt.core.xml</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.jdt.core.prefs</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.jst.common.project.facet.core.prefs</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.m2e.core.prefs</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.m2e.wtp.prefs</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.wst.common.component</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.wst.common.project.facet.core.xml</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.wst.jsdt.ui.superType.container</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.wst.jsdt.ui.superType.name</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.wst.validation.prefs</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.maven.ide.eclipse.prefs</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.springframework.ide.eclipse.beans.core.prefs</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.springframework.ide.eclipse.core.prefs</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.springBeans</th>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.travis.yml</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>README.md</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>authors.txt</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bower.json</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>db/build.xml</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>db/dropTables.txt</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>db/emptyDB.txt</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>db/mysql/createDB.txt</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/vet/VetControllerTests.java</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/vet/VetTests.java</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/CrashControllerTests.java</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/OwnerControllerTests.java</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/PetControllerTests.java</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/PetTypeFormatterTests.java</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VetControllerTest.java</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VetControllerTests.java</th>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitControllerTests.java</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsAtomViewTest.java</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsAtomViewTestWithContainer-config.xml</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsAtomViewWithContainerTest.java</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsViewTest-config.xml</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsViewTest.java</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsViewTests-config.xml</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/java/org/springframework/samples/petclinic/web/VisitsViewTests.java</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/jmeter/petclinic_test_plan.jmx</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/log4j.xml</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/logback-test.xml</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/AbstractClinicTests-context.xml</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/hibernate/HibernateClinicTests-context.xml</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jdbc/JdbcClinicTests-context.xml</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jdbc/SimpleJdbcClinicTests-context.xml</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-entityManager.xml</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-hibernateAdapter.xml</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-jpaCommon.xml</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-openJpaAdapter.xml</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-toplinkAdapter.xml</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/spring/mvc-test-config.xml</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>travis.yml</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1674 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    additions  deletions\n",
       "filename                                                                \n",
       ".bowerrc                                                    3          3\n",
       ".classpath                                                  6          6\n",
       ".editorconfig                                               2          2\n",
       ".gitignore                                                  8          8\n",
       ".mvn/wrapper/maven-wrapper.jar                              1          1\n",
       ".mvn/wrapper/maven-wrapper.properties                       1          1\n",
       ".project                                                    5          5\n",
       ".settings/.jsdtscope                                        3          3\n",
       ".settings/com.springsource.server.ide.jdt.core.xml          2          2\n",
       ".settings/org.eclipse.jdt.core.prefs                        3          3\n",
       ".settings/org.eclipse.jst.common.project.facet....          2          2\n",
       ".settings/org.eclipse.m2e.core.prefs                        2          2\n",
       ".settings/org.eclipse.m2e.wtp.prefs                         2          2\n",
       ".settings/org.eclipse.wst.common.component                  5          5\n",
       ".settings/org.eclipse.wst.common.project.facet....          3          3\n",
       ".settings/org.eclipse.wst.jsdt.ui.superType.con...          2          2\n",
       ".settings/org.eclipse.wst.jsdt.ui.superType.name            2          2\n",
       ".settings/org.eclipse.wst.validation.prefs                  2          2\n",
       ".settings/org.maven.ide.eclipse.prefs                       2          2\n",
       ".settings/org.springframework.ide.eclipse.beans...          2          2\n",
       ".settings/org.springframework.ide.eclipse.core....          3          3\n",
       ".springBeans                                               14         14\n",
       ".travis.yml                                                 2          2\n",
       "README.md                                                   2          2\n",
       "authors.txt                                                 2          2\n",
       "bower.json                                                  3          3\n",
       "db/build.xml                                                2          2\n",
       "db/dropTables.txt                                           2          2\n",
       "db/emptyDB.txt                                              2          2\n",
       "db/mysql/createDB.txt                                       2          2\n",
       "...                                                       ...        ...\n",
       "src/test/java/org/springframework/samples/petcl...          1          1\n",
       "src/test/java/org/springframework/samples/petcl...          1          1\n",
       "src/test/java/org/springframework/samples/petcl...          6          6\n",
       "src/test/java/org/springframework/samples/petcl...          9          9\n",
       "src/test/java/org/springframework/samples/petcl...          9          9\n",
       "src/test/java/org/springframework/samples/petcl...          2          2\n",
       "src/test/java/org/springframework/samples/petcl...          2          2\n",
       "src/test/java/org/springframework/samples/petcl...         15         15\n",
       "src/test/java/org/springframework/samples/petcl...         10         10\n",
       "src/test/java/org/springframework/samples/petcl...         10         10\n",
       "src/test/java/org/springframework/samples/petcl...          3          3\n",
       "src/test/java/org/springframework/samples/petcl...          3          3\n",
       "src/test/java/org/springframework/samples/petcl...          3          3\n",
       "src/test/java/org/springframework/samples/petcl...          4          4\n",
       "src/test/java/org/springframework/samples/petcl...          2          2\n",
       "src/test/java/org/springframework/samples/petcl...          5          5\n",
       "src/test/jmeter/petclinic_test_plan.jmx                     4          4\n",
       "src/test/resources/log4j.xml                                2          2\n",
       "src/test/resources/logback-test.xml                         3          3\n",
       "src/test/resources/org/springframework/samples/...          5          5\n",
       "src/test/resources/org/springframework/samples/...          3          3\n",
       "src/test/resources/org/springframework/samples/...          2          2\n",
       "src/test/resources/org/springframework/samples/...          2          2\n",
       "src/test/resources/org/springframework/samples/...          3          3\n",
       "src/test/resources/org/springframework/samples/...          2          2\n",
       "src/test/resources/org/springframework/samples/...          5          5\n",
       "src/test/resources/org/springframework/samples/...          2          2\n",
       "src/test/resources/org/springframework/samples/...          2          2\n",
       "src/test/resources/spring/mvc-test-config.xml               1          1\n",
       "travis.yml                                                  2          2\n",
       "\n",
       "[1674 rows x 2 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ownership = git_log.groupby(['filename', 'author']).count()\n",
    "ownership.groupby(\n",
    "    [ownership.index.get_level_values(0)]).sum()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}