demos/Knowledge Island 2.ipynb

{
 "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>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>src/test/java/petclinic/web/CrashControllerTes...</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>25.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>src/test/java/petclinic/web/OwnerControllerTes...</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>21.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>src/test/java/petclinic/web/PetControllerTests...</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>23.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>src/test/java/petclinic/web/VetControllerTests...</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>10.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>src/test/java/petclinic/web/VisitControllerTes...</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>111.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>src/main/java/petclinic/PetclinicInitializer.java</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>src/main/java/petclinic/repository/jdbc/JdbcPe...</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>src/main/java/petclinic/web/VetController.java</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>src/test/java/petclinic/web/VetControllerTests...</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>22.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>src/main/java/petclinic/repository/jdbc/JdbcVi...</td>\n",
       "      <td>Attilio</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>src/main/java/petclinic/repository/jpa/JpaVisi...</td>\n",
       "      <td>Attilio</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>src/main/java/petclinic/service/ClinicService....</td>\n",
       "      <td>Attilio</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>src/main/java/petclinic/service/ClinicServiceI...</td>\n",
       "      <td>Attilio</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>src/test/java/petclinic/service/AbstractClinic...</td>\n",
       "      <td>Attilio</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>src/main/java/petclinic/model/BaseEntity.java</td>\n",
       "      <td>Faisal Hameed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>src/main/java/petclinic/web/OwnerController.java</td>\n",
       "      <td>Faisal Hameed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>src/main/java/petclinic/web/PetController.java</td>\n",
       "      <td>Faisal Hameed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>src/main/java/petclinic/web/PetValidator.java</td>\n",
       "      <td>Faisal Hameed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>src/test/java/petclinic/service/AbstractClinic...</td>\n",
       "      <td>Faisal Hameed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>53.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>src/test/java/petclinic/web/CrashControllerTes...</td>\n",
       "      <td>Colin But</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>167.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>src/test/java/petclinic/web/OwnerControllerTes...</td>\n",
       "      <td>Colin But</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>113.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>src/test/java/petclinic/web/PetControllerTests...</td>\n",
       "      <td>Colin But</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>76.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>src/test/java/petclinic/web/PetTypeFormatterTe...</td>\n",
       "      <td>Colin But</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>22.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>src/test/java/petclinic/web/VetControllerTests...</td>\n",
       "      <td>Colin But</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>79.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>src/test/java/petclinic/web/VisitControllerTes...</td>\n",
       "      <td>Colin But</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>src/main/java/petclinic/model/Visit.java</td>\n",
       "      <td>Tomas Repel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>src/main/java/petclinic/repository/jdbc/JdbcVi...</td>\n",
       "      <td>Tomas Repel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>src/main/java/petclinic/model/Pet.java</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>src/main/java/petclinic/repository/jdbc/JdbcPe...</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>src/test/java/petclinic/service/AbstractClinic...</td>\n",
       "      <td>Antoine Rey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1052</th>\n",
       "      <td>44.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1053</th>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1054</th>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1055</th>\n",
       "      <td>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1056</th>\n",
       "      <td>41.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1057</th>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1058</th>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059</th>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1060</th>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1061</th>\n",
       "      <td>0.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1062</th>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1069</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1070</th>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1071</th>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1073</th>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1074</th>\n",
       "      <td>26.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1075</th>\n",
       "      <td>36.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1076</th>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1077</th>\n",
       "      <td>39.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1078</th>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1079</th>\n",
       "      <td>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1080</th>\n",
       "      <td>41.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1081</th>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1082</th>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1083</th>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1084</th>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>org.springframework.samples.petclinic/src/main...</td>\n",
       "      <td>Keith Donald</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>929 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      additions  deletions                                           filename  \\\n",
       "1           4.0        5.0  src/test/java/petclinic/web/CrashControllerTes...   \n",
       "2          25.0        7.0  src/test/java/petclinic/web/OwnerControllerTes...   \n",
       "3          21.0        9.0  src/test/java/petclinic/web/PetControllerTests...   \n",
       "4          23.0        3.0  src/test/java/petclinic/web/VetControllerTests...   \n",
       "5          10.0        6.0  src/test/java/petclinic/web/VisitControllerTes...   \n",
       "7         111.0        0.0  src/main/java/petclinic/PetclinicInitializer.java   \n",
       "9           4.0       14.0  src/main/java/petclinic/repository/jdbc/JdbcPe...   \n",
       "11          2.0        2.0     src/main/java/petclinic/web/VetController.java   \n",
       "12         14.0       14.0  src/test/java/petclinic/web/VetControllerTests...   \n",
       "14         22.0        5.0  src/main/java/petclinic/repository/jdbc/JdbcVi...   \n",
       "15          1.0        1.0  src/main/java/petclinic/repository/jpa/JpaVisi...   \n",
       "16          2.0        0.0  src/main/java/petclinic/service/ClinicService....   \n",
       "17          5.0        0.0  src/main/java/petclinic/service/ClinicServiceI...   \n",
       "18         10.0        0.0  src/test/java/petclinic/service/AbstractClinic...   \n",
       "20          1.0        1.0      src/main/java/petclinic/model/BaseEntity.java   \n",
       "21          5.0        4.0   src/main/java/petclinic/web/OwnerController.java   \n",
       "22          7.0        6.0     src/main/java/petclinic/web/PetController.java   \n",
       "23          5.0        3.0      src/main/java/petclinic/web/PetValidator.java   \n",
       "24          1.0        1.0  src/test/java/petclinic/service/AbstractClinic...   \n",
       "26         53.0        0.0  src/test/java/petclinic/web/CrashControllerTes...   \n",
       "27        167.0        0.0  src/test/java/petclinic/web/OwnerControllerTes...   \n",
       "28        113.0        0.0  src/test/java/petclinic/web/PetControllerTests...   \n",
       "29         76.0        0.0  src/test/java/petclinic/web/PetTypeFormatterTe...   \n",
       "30         22.0        6.0  src/test/java/petclinic/web/VetControllerTests...   \n",
       "31         79.0        0.0  src/test/java/petclinic/web/VisitControllerTes...   \n",
       "33          6.0        6.0           src/main/java/petclinic/model/Visit.java   \n",
       "34          2.0        2.0  src/main/java/petclinic/repository/jdbc/JdbcVi...   \n",
       "36          5.0        4.0             src/main/java/petclinic/model/Pet.java   \n",
       "37          2.0        1.0  src/main/java/petclinic/repository/jdbc/JdbcPe...   \n",
       "38          2.0        1.0  src/test/java/petclinic/service/AbstractClinic...   \n",
       "...         ...        ...                                                ...   \n",
       "1052       44.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1053       21.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1054        5.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1055       25.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1056       41.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1057        9.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1058       15.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1059        0.0        5.0  org.springframework.samples.petclinic/src/main...   \n",
       "1060        0.0       25.0  org.springframework.samples.petclinic/src/main...   \n",
       "1061        0.0       41.0  org.springframework.samples.petclinic/src/main...   \n",
       "1062        0.0        9.0  org.springframework.samples.petclinic/src/main...   \n",
       "1063        0.0       15.0  org.springframework.samples.petclinic/src/main...   \n",
       "1065        1.0        1.0  org.springframework.samples.petclinic/src/main...   \n",
       "1066        0.0        1.0  org.springframework.samples.petclinic/src/main...   \n",
       "1067        6.0        1.0  org.springframework.samples.petclinic/src/main...   \n",
       "1069        2.0        1.0  org.springframework.samples.petclinic/src/main...   \n",
       "1070       21.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1071       15.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1073       14.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1074       26.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1075       36.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1076       13.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1077       39.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1078        5.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1079       25.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1080       41.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1081        9.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1082       10.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1083        9.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "1084        5.0        0.0  org.springframework.samples.petclinic/src/main...   \n",
       "\n",
       "             author  \n",
       "1       Antoine Rey  \n",
       "2       Antoine Rey  \n",
       "3       Antoine Rey  \n",
       "4       Antoine Rey  \n",
       "5       Antoine Rey  \n",
       "7       Antoine Rey  \n",
       "9       Antoine Rey  \n",
       "11      Antoine Rey  \n",
       "12      Antoine Rey  \n",
       "14          Attilio  \n",
       "15          Attilio  \n",
       "16          Attilio  \n",
       "17          Attilio  \n",
       "18          Attilio  \n",
       "20    Faisal Hameed  \n",
       "21    Faisal Hameed  \n",
       "22    Faisal Hameed  \n",
       "23    Faisal Hameed  \n",
       "24    Faisal Hameed  \n",
       "26        Colin But  \n",
       "27        Colin But  \n",
       "28        Colin But  \n",
       "29        Colin But  \n",
       "30        Colin But  \n",
       "31        Colin But  \n",
       "33      Tomas Repel  \n",
       "34      Tomas Repel  \n",
       "36      Antoine Rey  \n",
       "37      Antoine Rey  \n",
       "38      Antoine Rey  \n",
       "...             ...  \n",
       "1052   Keith Donald  \n",
       "1053   Keith Donald  \n",
       "1054   Keith Donald  \n",
       "1055   Keith Donald  \n",
       "1056   Keith Donald  \n",
       "1057   Keith Donald  \n",
       "1058   Keith Donald  \n",
       "1059   Keith Donald  \n",
       "1060   Keith Donald  \n",
       "1061   Keith Donald  \n",
       "1062   Keith Donald  \n",
       "1063   Keith Donald  \n",
       "1065   Keith Donald  \n",
       "1066   Keith Donald  \n",
       "1067   Keith Donald  \n",
       "1069   Keith Donald  \n",
       "1070   Keith Donald  \n",
       "1071   Keith Donald  \n",
       "1073   Keith Donald  \n",
       "1074   Keith Donald  \n",
       "1075   Keith Donald  \n",
       "1076   Keith Donald  \n",
       "1077   Keith Donald  \n",
       "1078   Keith Donald  \n",
       "1079   Keith Donald  \n",
       "1080   Keith Donald  \n",
       "1081   Keith Donald  \n",
       "1082   Keith Donald  \n",
       "1083   Keith Donald  \n",
       "1084   Keith Donald  \n",
       "\n",
       "[929 rows x 4 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "# reading\n",
    "git_log = pd.read_csv(\n",
    "    \"../../../buschmais-spring-petclinic/git_log_numstat.log\",\n",
    "    sep=\"\\t\", \n",
    "    header=None,\n",
    "    names=[\n",
    "        'additions', \n",
    "        'deletions', \n",
    "        'filename', \n",
    "        'author'])\n",
    "\n",
    "# converting in \"one line\"\n",
    "log = git_log[['additions', 'deletions', 'filename']]\\\n",
    "    .join(git_log[['author']]\\\n",
    "    .fillna(method='ffill'))\\\n",
    "    .dropna()\n",
    "    \n",
    "log['additions'] = pd.to_numeric(log['additions'], errors='coerce')\n",
    "log['deletions'] = pd.to_numeric(log['deletions'], errors='coerce')\n",
    "\n",
    "log['filename'] = log.filename.str.replace(\"org/springframework/samples/\", \"\")\n",
    "log[log['filename'].str.endswith(\".java\")].to_csv(\"git_log_prepared.log\", columns=['author','filename','additions', 'deletions'], index=None)\n",
    "log"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "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></th>\n",
       "      <th>additions</th>\n",
       "      <th>all_additions</th>\n",
       "      <th>ownership</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>filename</th>\n",
       "      <th>author</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">.bowerrc</th>\n",
       "      <th>Antoine Rey</th>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dapeng</th>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Faycal Ihabritane</th>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">.classpath</th>\n",
       "      <th>Costin Leau</th>\n",
       "      <td>43.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>0.530864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Keith Donald</th>\n",
       "      <td>8.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>0.098765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>28.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>0.345679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rossen Stoyanchev</th>\n",
       "      <td>2.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>0.024691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.editorconfig</th>\n",
       "      <th>Antoine Rey</th>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">.gitignore</th>\n",
       "      <th>Antoine Rey</th>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cyrille Le Clerc</th>\n",
       "      <td>2.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dave Syer</th>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.083333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>6.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Patrick Crocker</th>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.mvn/wrapper/maven-wrapper.jar</th>\n",
       "      <th>Patrick Crocker</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.mvn/wrapper/maven-wrapper.properties</th>\n",
       "      <th>Patrick Crocker</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">.project</th>\n",
       "      <th>Costin Leau</th>\n",
       "      <td>36.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.610169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Keith Donald</th>\n",
       "      <td>16.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.271186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>5.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.084746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rossen Stoyanchev</th>\n",
       "      <td>2.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.033898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">.settings/.jsdtscope</th>\n",
       "      <th>Keith Donald</th>\n",
       "      <td>11.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.846154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>2.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.153846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">.settings/com.springsource.server.ide.jdt.core.xml</th>\n",
       "      <th>Keith Donald</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">.settings/org.eclipse.jdt.core.prefs</th>\n",
       "      <th>Keith Donald</th>\n",
       "      <td>12.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>4.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">.settings/org.eclipse.jst.common.project.facet.core.prefs</th>\n",
       "      <th>Keith Donald</th>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.m2e.core.prefs</th>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.m2e.wtp.prefs</th>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>.settings/org.eclipse.wst.common.component</th>\n",
       "      <th>Costin Leau</th>\n",
       "      <td>10.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.263158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">src/test/resources/logback-test.xml</th>\n",
       "      <th>Gordon Dickens</th>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">src/test/resources/org/springframework/samples/petclinic/AbstractClinicTests-context.xml</th>\n",
       "      <th>Chris Beams</th>\n",
       "      <td>6.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.115385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Costin Leau</th>\n",
       "      <td>22.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.423077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Keith Donald</th>\n",
       "      <td>24.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.461538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">src/test/resources/org/springframework/samples/petclinic/hibernate/HibernateClinicTests-context.xml</th>\n",
       "      <th>Costin Leau</th>\n",
       "      <td>32.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.914286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>3.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.085714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/org/springframework/samples/petclinic/jdbc/JdbcClinicTests-context.xml</th>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">src/test/resources/org/springframework/samples/petclinic/jdbc/SimpleJdbcClinicTests-context.xml</th>\n",
       "      <th>Costin Leau</th>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-entityManager.xml</th>\n",
       "      <th>Costin Leau</th>\n",
       "      <td>16.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.941176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>1.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.058824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-hibernateAdapter.xml</th>\n",
       "      <th>Costin Leau</th>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-jpaCommon.xml</th>\n",
       "      <th>Chris Beams</th>\n",
       "      <td>8.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.129032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Costin Leau</th>\n",
       "      <td>31.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Keith Donald</th>\n",
       "      <td>23.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.370968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>0.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-openJpaAdapter.xml</th>\n",
       "      <th>Costin Leau</th>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">src/test/resources/org/springframework/samples/petclinic/jpa/applicationContext-toplinkAdapter.xml</th>\n",
       "      <th>Costin Leau</th>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/test/resources/spring/mvc-test-config.xml</th>\n",
       "      <th>Antoine Rey</th>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>src/{main =&gt; test}/java/org/springframework/samples/petclinic/util/EntityUtils.java</th>\n",
       "      <th>Dave Syer</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>travis.yml</th>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>travis.yml =&gt; .travis.yml</th>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>{org.springframework.samples.petclinic/src/main/webapp =&gt; src/main/webapp/resources}/images/banner-graphic.png</th>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>{org.springframework.samples.petclinic/src/main/webapp =&gt; src/main/webapp/resources}/images/pets.png</th>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>{org.springframework.samples.petclinic/src/main/webapp =&gt; src/main/webapp/resources}/images/springsource-logo.png</th>\n",
       "      <th>Michael Isvy</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2647 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                      additions  \\\n",
       "filename                                           author                         \n",
       ".bowerrc                                           Antoine Rey              1.0   \n",
       "                                                   Dapeng                   0.0   \n",
       "                                                   Faycal Ihabritane        3.0   \n",
       ".classpath                                         Costin Leau             43.0   \n",
       "                                                   Keith Donald             8.0   \n",
       "                                                   Michael Isvy            28.0   \n",
       "                                                   Rossen Stoyanchev        2.0   \n",
       ".editorconfig                                      Antoine Rey             14.0   \n",
       ".gitignore                                         Antoine Rey              3.0   \n",
       "                                                   Cyrille Le Clerc         2.0   \n",
       "                                                   Dave Syer                1.0   \n",
       "                                                   Michael Isvy             6.0   \n",
       "                                                   Patrick Crocker          0.0   \n",
       ".mvn/wrapper/maven-wrapper.jar                     Patrick Crocker          NaN   \n",
       ".mvn/wrapper/maven-wrapper.properties              Patrick Crocker          1.0   \n",
       ".project                                           Costin Leau             36.0   \n",
       "                                                   Keith Donald            16.0   \n",
       "                                                   Michael Isvy             5.0   \n",
       "                                                   Rossen Stoyanchev        2.0   \n",
       ".settings/.jsdtscope                               Keith Donald            11.0   \n",
       "                                                   Michael Isvy             2.0   \n",
       ".settings/com.springsource.server.ide.jdt.core.xml Keith Donald             2.0   \n",
       "                                                   Michael Isvy             0.0   \n",
       ".settings/org.eclipse.jdt.core.prefs               Keith Donald            12.0   \n",
       "                                                   Michael Isvy             4.0   \n",
       ".settings/org.eclipse.jst.common.project.facet.... Keith Donald             3.0   \n",
       "                                                   Michael Isvy             0.0   \n",
       ".settings/org.eclipse.m2e.core.prefs               Michael Isvy             4.0   \n",
       ".settings/org.eclipse.m2e.wtp.prefs                Michael Isvy             2.0   \n",
       ".settings/org.eclipse.wst.common.component         Costin Leau             10.0   \n",
       "...                                                                         ...   \n",
       "src/test/resources/logback-test.xml                Gordon Dickens          24.0   \n",
       "                                                   Michael Isvy             0.0   \n",
       "src/test/resources/org/springframework/samples/... Chris Beams              6.0   \n",
       "                                                   Costin Leau             22.0   \n",
       "                                                   Keith Donald            24.0   \n",
       "                                                   Michael Isvy             0.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau             32.0   \n",
       "                                                   Michael Isvy             3.0   \n",
       "src/test/resources/org/springframework/samples/... Michael Isvy            30.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau             11.0   \n",
       "                                                   Michael Isvy             0.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau             16.0   \n",
       "                                                   Michael Isvy             1.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau              9.0   \n",
       "                                                   Michael Isvy             0.0   \n",
       "src/test/resources/org/springframework/samples/... Chris Beams              8.0   \n",
       "                                                   Costin Leau             31.0   \n",
       "                                                   Keith Donald            23.0   \n",
       "                                                   Michael Isvy             0.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau              9.0   \n",
       "                                                   Michael Isvy             0.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau              9.0   \n",
       "                                                   Michael Isvy             0.0   \n",
       "src/test/resources/spring/mvc-test-config.xml      Antoine Rey             12.0   \n",
       "src/{main => test}/java/org/springframework/sam... Dave Syer                0.0   \n",
       "travis.yml                                         Michael Isvy             3.0   \n",
       "travis.yml => .travis.yml                          Michael Isvy             0.0   \n",
       "{org.springframework.samples.petclinic/src/main... Michael Isvy             NaN   \n",
       "{org.springframework.samples.petclinic/src/main... Michael Isvy             NaN   \n",
       "{org.springframework.samples.petclinic/src/main... Michael Isvy             NaN   \n",
       "\n",
       "                                                                      all_additions  \\\n",
       "filename                                           author                             \n",
       ".bowerrc                                           Antoine Rey                  4.0   \n",
       "                                                   Dapeng                       4.0   \n",
       "                                                   Faycal Ihabritane            4.0   \n",
       ".classpath                                         Costin Leau                 81.0   \n",
       "                                                   Keith Donald                81.0   \n",
       "                                                   Michael Isvy                81.0   \n",
       "                                                   Rossen Stoyanchev           81.0   \n",
       ".editorconfig                                      Antoine Rey                 14.0   \n",
       ".gitignore                                         Antoine Rey                 12.0   \n",
       "                                                   Cyrille Le Clerc            12.0   \n",
       "                                                   Dave Syer                   12.0   \n",
       "                                                   Michael Isvy                12.0   \n",
       "                                                   Patrick Crocker             12.0   \n",
       ".mvn/wrapper/maven-wrapper.jar                     Patrick Crocker              0.0   \n",
       ".mvn/wrapper/maven-wrapper.properties              Patrick Crocker              1.0   \n",
       ".project                                           Costin Leau                 59.0   \n",
       "                                                   Keith Donald                59.0   \n",
       "                                                   Michael Isvy                59.0   \n",
       "                                                   Rossen Stoyanchev           59.0   \n",
       ".settings/.jsdtscope                               Keith Donald                13.0   \n",
       "                                                   Michael Isvy                13.0   \n",
       ".settings/com.springsource.server.ide.jdt.core.xml Keith Donald                 2.0   \n",
       "                                                   Michael Isvy                 2.0   \n",
       ".settings/org.eclipse.jdt.core.prefs               Keith Donald                16.0   \n",
       "                                                   Michael Isvy                16.0   \n",
       ".settings/org.eclipse.jst.common.project.facet.... Keith Donald                 3.0   \n",
       "                                                   Michael Isvy                 3.0   \n",
       ".settings/org.eclipse.m2e.core.prefs               Michael Isvy                 4.0   \n",
       ".settings/org.eclipse.m2e.wtp.prefs                Michael Isvy                 2.0   \n",
       ".settings/org.eclipse.wst.common.component         Costin Leau                 38.0   \n",
       "...                                                                             ...   \n",
       "src/test/resources/logback-test.xml                Gordon Dickens              24.0   \n",
       "                                                   Michael Isvy                24.0   \n",
       "src/test/resources/org/springframework/samples/... Chris Beams                 52.0   \n",
       "                                                   Costin Leau                 52.0   \n",
       "                                                   Keith Donald                52.0   \n",
       "                                                   Michael Isvy                52.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau                 35.0   \n",
       "                                                   Michael Isvy                35.0   \n",
       "src/test/resources/org/springframework/samples/... Michael Isvy                30.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau                 11.0   \n",
       "                                                   Michael Isvy                11.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau                 17.0   \n",
       "                                                   Michael Isvy                17.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau                  9.0   \n",
       "                                                   Michael Isvy                 9.0   \n",
       "src/test/resources/org/springframework/samples/... Chris Beams                 62.0   \n",
       "                                                   Costin Leau                 62.0   \n",
       "                                                   Keith Donald                62.0   \n",
       "                                                   Michael Isvy                62.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau                  9.0   \n",
       "                                                   Michael Isvy                 9.0   \n",
       "src/test/resources/org/springframework/samples/... Costin Leau                  9.0   \n",
       "                                                   Michael Isvy                 9.0   \n",
       "src/test/resources/spring/mvc-test-config.xml      Antoine Rey                 12.0   \n",
       "src/{main => test}/java/org/springframework/sam... Dave Syer                    0.0   \n",
       "travis.yml                                         Michael Isvy                 3.0   \n",
       "travis.yml => .travis.yml                          Michael Isvy                 0.0   \n",
       "{org.springframework.samples.petclinic/src/main... Michael Isvy                 0.0   \n",
       "{org.springframework.samples.petclinic/src/main... Michael Isvy                 0.0   \n",
       "{org.springframework.samples.petclinic/src/main... Michael Isvy                 0.0   \n",
       "\n",
       "                                                                      ownership  \n",
       "filename                                           author                        \n",
       ".bowerrc                                           Antoine Rey         0.250000  \n",
       "                                                   Dapeng              0.000000  \n",
       "                                                   Faycal Ihabritane   0.750000  \n",
       ".classpath                                         Costin Leau         0.530864  \n",
       "                                                   Keith Donald        0.098765  \n",
       "                                                   Michael Isvy        0.345679  \n",
       "                                                   Rossen Stoyanchev   0.024691  \n",
       ".editorconfig                                      Antoine Rey         1.000000  \n",
       ".gitignore                                         Antoine Rey         0.250000  \n",
       "                                                   Cyrille Le Clerc    0.166667  \n",
       "                                                   Dave Syer           0.083333  \n",
       "                                                   Michael Isvy        0.500000  \n",
       "                                                   Patrick Crocker     0.000000  \n",
       ".mvn/wrapper/maven-wrapper.jar                     Patrick Crocker          NaN  \n",
       ".mvn/wrapper/maven-wrapper.properties              Patrick Crocker     1.000000  \n",
       ".project                                           Costin Leau         0.610169  \n",
       "                                                   Keith Donald        0.271186  \n",
       "                                                   Michael Isvy        0.084746  \n",
       "                                                   Rossen Stoyanchev   0.033898  \n",
       ".settings/.jsdtscope                               Keith Donald        0.846154  \n",
       "                                                   Michael Isvy        0.153846  \n",
       ".settings/com.springsource.server.ide.jdt.core.xml Keith Donald        1.000000  \n",
       "                                                   Michael Isvy        0.000000  \n",
       ".settings/org.eclipse.jdt.core.prefs               Keith Donald        0.750000  \n",
       "                                                   Michael Isvy        0.250000  \n",
       ".settings/org.eclipse.jst.common.project.facet.... Keith Donald        1.000000  \n",
       "                                                   Michael Isvy        0.000000  \n",
       ".settings/org.eclipse.m2e.core.prefs               Michael Isvy        1.000000  \n",
       ".settings/org.eclipse.m2e.wtp.prefs                Michael Isvy        1.000000  \n",
       ".settings/org.eclipse.wst.common.component         Costin Leau         0.263158  \n",
       "...                                                                         ...  \n",
       "src/test/resources/logback-test.xml                Gordon Dickens      1.000000  \n",
       "                                                   Michael Isvy        0.000000  \n",
       "src/test/resources/org/springframework/samples/... Chris Beams         0.115385  \n",
       "                                                   Costin Leau         0.423077  \n",
       "                                                   Keith Donald        0.461538  \n",
       "                                                   Michael Isvy        0.000000  \n",
       "src/test/resources/org/springframework/samples/... Costin Leau         0.914286  \n",
       "                                                   Michael Isvy        0.085714  \n",
       "src/test/resources/org/springframework/samples/... Michael Isvy        1.000000  \n",
       "src/test/resources/org/springframework/samples/... Costin Leau         1.000000  \n",
       "                                                   Michael Isvy        0.000000  \n",
       "src/test/resources/org/springframework/samples/... Costin Leau         0.941176  \n",
       "                                                   Michael Isvy        0.058824  \n",
       "src/test/resources/org/springframework/samples/... Costin Leau         1.000000  \n",
       "                                                   Michael Isvy        0.000000  \n",
       "src/test/resources/org/springframework/samples/... Chris Beams         0.129032  \n",
       "                                                   Costin Leau         0.500000  \n",
       "                                                   Keith Donald        0.370968  \n",
       "                                                   Michael Isvy        0.000000  \n",
       "src/test/resources/org/springframework/samples/... Costin Leau         1.000000  \n",
       "                                                   Michael Isvy        0.000000  \n",
       "src/test/resources/org/springframework/samples/... Costin Leau         1.000000  \n",
       "                                                   Michael Isvy        0.000000  \n",
       "src/test/resources/spring/mvc-test-config.xml      Antoine Rey         1.000000  \n",
       "src/{main => test}/java/org/springframework/sam... Dave Syer                NaN  \n",
       "travis.yml                                         Michael Isvy        1.000000  \n",
       "travis.yml => .travis.yml                          Michael Isvy             NaN  \n",
       "{org.springframework.samples.petclinic/src/main... Michael Isvy             NaN  \n",
       "{org.springframework.samples.petclinic/src/main... Michael Isvy             NaN  \n",
       "{org.springframework.samples.petclinic/src/main... Michael Isvy             NaN  \n",
       "\n",
       "[2647 rows x 3 columns]"
      ]
     },
     "execution_count": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def aggregate_additions(group):\n",
    "    df = group.groupby(['author'])[['additions']].sum()\n",
    "    df['all_additions'] = group['additions'].sum()\n",
    "    df['ownership'] = df['additions'] / df['all_additions']\n",
    "    return df\n",
    "\n",
    "log.groupby('filename').apply(aggregate_additions)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "log.groupby(['filename', 'author'])[['additions']].agg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5048</th>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5049</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5050</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5051</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5052</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5053</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5054</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5055</th>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5056</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5057</th>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5058</th>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5059</th>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5060</th>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5061</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5062</th>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5063</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5064</th>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5065</th>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5066</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5067</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5068</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5069</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5070</th>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5071</th>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5072</th>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5073</th>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5074</th>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5075</th>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5076</th>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5078</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4520 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     additions\n",
       "1            2\n",
       "3            1\n",
       "5            1\n",
       "8            1\n",
       "9           11\n",
       "11          10\n",
       "12          20\n",
       "13           0\n",
       "15           1\n",
       "16           2\n",
       "17          17\n",
       "19           5\n",
       "20           1\n",
       "21           1\n",
       "22          43\n",
       "24           2\n",
       "26           2\n",
       "28           1\n",
       "30           0\n",
       "32           1\n",
       "34           4\n",
       "36           3\n",
       "37           5\n",
       "38           1\n",
       "39          10\n",
       "40          23\n",
       "42           1\n",
       "44           0\n",
       "45           2\n",
       "47           9\n",
       "...        ...\n",
       "5048        12\n",
       "5049         3\n",
       "5050        10\n",
       "5051         7\n",
       "5052         6\n",
       "5053         9\n",
       "5054         3\n",
       "5055        67\n",
       "5056        13\n",
       "5057       106\n",
       "5058        14\n",
       "5059        26\n",
       "5060        36\n",
       "5061        13\n",
       "5062        39\n",
       "5063         5\n",
       "5064        25\n",
       "5065        41\n",
       "5066         9\n",
       "5067        10\n",
       "5068         9\n",
       "5069         5\n",
       "5070        42\n",
       "5071        12\n",
       "5072        14\n",
       "5073        36\n",
       "5074        12\n",
       "5075        36\n",
       "5076        42\n",
       "5078         4\n",
       "\n",
       "[4520 rows x 1 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "log.groupby(['filename', 'author'], level=0)[['additions']].sum()"
   ]
  }
 ],
 "metadata": {
  "hide_input": false,
  "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.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}