prototypes/Read a XML file into Pandas DataFrame.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Introduction\n",
    "\n",
    "Recently, I came across the nice little library `xmldataset` that allows you to flatten multi-level XML data so that you can process it easily with Pandas."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "```\n",
    "pip install xmldataset\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>class_name</th>\n",
       "      <th>covered</th>\n",
       "      <th>method_name</th>\n",
       "      <th>missed</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>org/springframework/samples/petclinic/Petclini...</td>\n",
       "      <td>3</td>\n",
       "      <td>&lt;init&gt;</td>\n",
       "      <td>0</td>\n",
       "      <td>INSTRUCTION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>org/springframework/samples/petclinic/Petclini...</td>\n",
       "      <td>1</td>\n",
       "      <td>&lt;init&gt;</td>\n",
       "      <td>0</td>\n",
       "      <td>LINE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>org/springframework/samples/petclinic/Petclini...</td>\n",
       "      <td>1</td>\n",
       "      <td>&lt;init&gt;</td>\n",
       "      <td>0</td>\n",
       "      <td>COMPLEXITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>org/springframework/samples/petclinic/Petclini...</td>\n",
       "      <td>1</td>\n",
       "      <td>&lt;init&gt;</td>\n",
       "      <td>0</td>\n",
       "      <td>METHOD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>org/springframework/samples/petclinic/Petclini...</td>\n",
       "      <td>7</td>\n",
       "      <td>onStartup</td>\n",
       "      <td>0</td>\n",
       "      <td>INSTRUCTION</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          class_name covered method_name  \\\n",
       "0  org/springframework/samples/petclinic/Petclini...       3      <init>   \n",
       "1  org/springframework/samples/petclinic/Petclini...       1      <init>   \n",
       "2  org/springframework/samples/petclinic/Petclini...       1      <init>   \n",
       "3  org/springframework/samples/petclinic/Petclini...       1      <init>   \n",
       "4  org/springframework/samples/petclinic/Petclini...       7   onStartup   \n",
       "\n",
       "  missed         type  \n",
       "0      0  INSTRUCTION  \n",
       "1      0         LINE  \n",
       "2      0   COMPLEXITY  \n",
       "3      0       METHOD  \n",
       "4      0  INSTRUCTION  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import xmldataset\n",
    "import pandas as pd\n",
    "xml = \"\"\n",
    "\n",
    "with open (\"datasets/jacocoTestReport.xml\") as f:\n",
    "    xml = f.read()\n",
    "\n",
    "\n",
    "profile=\"\"\"\n",
    "report\n",
    "    package\n",
    "        class\n",
    "            name = external_dataset:info,prefix:class_\n",
    "            method\n",
    "                name = external_dataset:info,prefix:method_\n",
    "                counter\n",
    "                    type = dataset:measures\n",
    "                    missed = dataset:measures\n",
    "                    covered = dataset:measures\n",
    "                    __EXTERNAL_VALUE__ = info:class_name:measures info:method_name:measures\n",
    "                    \n",
    "\"\"\"\n",
    "\n",
    "\n",
    "output = xmldataset.parse_using_profile(xml,profile)\n",
    "coverage_data = pd.DataFrame.from_records(output['measures'])\n",
    "coverage_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "coverage_data['covered'] = pd.to_numeric(coverage_data['covered'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "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>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th colspan=\"5\" halign=\"left\">covered</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>type</th>\n",
       "      <th>BRANCH</th>\n",
       "      <th>COMPLEXITY</th>\n",
       "      <th>INSTRUCTION</th>\n",
       "      <th>LINE</th>\n",
       "      <th>METHOD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>class_name</th>\n",
       "      <th>method_name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">org/springframework/samples/petclinic/PetclinicInitializer</th>\n",
       "      <th>&lt;init&gt;</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>createRootApplicationContext</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>createServletApplicationContext</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>getServletFilters</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>getServletMappings</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>onStartup</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>registerDandelionServlet</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>registerServletFilter</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">org/springframework/samples/petclinic/model/BaseEntity</th>\n",
       "      <th>&lt;init&gt;</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>getId</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isNew</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>setId</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">org/springframework/samples/petclinic/model/NamedEntity</th>\n",
       "      <th>&lt;init&gt;</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>getName</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>setName</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>toString</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"13\" valign=\"top\">org/springframework/samples/petclinic/model/Owner</th>\n",
       "      <th>&lt;init&gt;</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>addPet</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>getAddress</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>getCity</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>getPet</th>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>getPets</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>getPetsInternal</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>getTelephone</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>setAddress</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>setCity</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>setPetsInternal</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>setTelephone</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>toString</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>org/springframework/samples/petclinic/model/Person</th>\n",
       "      <th>&lt;init&gt;</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">org/springframework/samples/petclinic/web/OwnerController</th>\n",
       "      <th>initUpdateOwnerForm</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>processCreationForm</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>processFindForm</th>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>processUpdateOwnerForm</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>setAllowedFields</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>showOwner</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"9\" valign=\"top\">org/springframework/samples/petclinic/web/PetController</th>\n",
       "      <th>&lt;init&gt;</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>findOwner</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>initCreationForm</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>initOwnerBinder</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>initPetBinder</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>initUpdateForm</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>populatePetTypes</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>processCreationForm</th>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>processUpdateForm</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">org/springframework/samples/petclinic/web/PetTypeFormatter</th>\n",
       "      <th>&lt;init&gt;</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>parse</th>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>print</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">org/springframework/samples/petclinic/web/PetValidator</th>\n",
       "      <th>&lt;init&gt;</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>supports</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>validate</th>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">org/springframework/samples/petclinic/web/VetController</th>\n",
       "      <th>&lt;init&gt;</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>showResourcesVetList</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>showVetList</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">org/springframework/samples/petclinic/web/VisitController</th>\n",
       "      <th>&lt;init&gt;</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>initNewVisitForm</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>loadPetWithVisit</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>processNewVisitForm</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>setAllowedFields</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>showVisits</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>162 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                   covered  \\\n",
       "type                                                                                BRANCH   \n",
       "class_name                                         method_name                               \n",
       "org/springframework/samples/petclinic/Petclinic... <init>                              NaN   \n",
       "                                                   createRootApplicationContext        NaN   \n",
       "                                                   createServletApplicationContext     NaN   \n",
       "                                                   getServletFilters                   NaN   \n",
       "                                                   getServletMappings                  NaN   \n",
       "                                                   onStartup                           NaN   \n",
       "                                                   registerDandelionServlet            NaN   \n",
       "                                                   registerServletFilter               NaN   \n",
       "org/springframework/samples/petclinic/model/Bas... <init>                              NaN   \n",
       "                                                   getId                               NaN   \n",
       "                                                   isNew                               2.0   \n",
       "                                                   setId                               NaN   \n",
       "org/springframework/samples/petclinic/model/Nam... <init>                              NaN   \n",
       "                                                   getName                             NaN   \n",
       "                                                   setName                             NaN   \n",
       "                                                   toString                            NaN   \n",
       "org/springframework/samples/petclinic/model/Owner  <init>                              NaN   \n",
       "                                                   addPet                              NaN   \n",
       "                                                   getAddress                          NaN   \n",
       "                                                   getCity                             NaN   \n",
       "                                                   getPet                              5.0   \n",
       "                                                   getPets                             NaN   \n",
       "                                                   getPetsInternal                     1.0   \n",
       "                                                   getTelephone                        NaN   \n",
       "                                                   setAddress                          NaN   \n",
       "                                                   setCity                             NaN   \n",
       "                                                   setPetsInternal                     NaN   \n",
       "                                                   setTelephone                        NaN   \n",
       "                                                   toString                            NaN   \n",
       "org/springframework/samples/petclinic/model/Person <init>                              NaN   \n",
       "...                                                                                    ...   \n",
       "org/springframework/samples/petclinic/web/Owner... initUpdateOwnerForm                 NaN   \n",
       "                                                   processCreationForm                 0.0   \n",
       "                                                   processFindForm                     3.0   \n",
       "                                                   processUpdateOwnerForm              1.0   \n",
       "                                                   setAllowedFields                    NaN   \n",
       "                                                   showOwner                           NaN   \n",
       "org/springframework/samples/petclinic/web/PetCo... <init>                              NaN   \n",
       "                                                   findOwner                           NaN   \n",
       "                                                   initCreationForm                    NaN   \n",
       "                                                   initOwnerBinder                     NaN   \n",
       "                                                   initPetBinder                       NaN   \n",
       "                                                   initUpdateForm                      NaN   \n",
       "                                                   populatePetTypes                    NaN   \n",
       "                                                   processCreationForm                 4.0   \n",
       "                                                   processUpdateForm                   0.0   \n",
       "org/springframework/samples/petclinic/web/PetTy... <init>                              NaN   \n",
       "                                                   parse                               3.0   \n",
       "                                                   print                               NaN   \n",
       "org/springframework/samples/petclinic/web/PetVa... <init>                              NaN   \n",
       "                                                   supports                            NaN   \n",
       "                                                   validate                            4.0   \n",
       "org/springframework/samples/petclinic/web/VetCo... <init>                              NaN   \n",
       "                                                   showResourcesVetList                NaN   \n",
       "                                                   showVetList                         NaN   \n",
       "org/springframework/samples/petclinic/web/Visit... <init>                              NaN   \n",
       "                                                   initNewVisitForm                    NaN   \n",
       "                                                   loadPetWithVisit                    NaN   \n",
       "                                                   processNewVisitForm                 1.0   \n",
       "                                                   setAllowedFields                    NaN   \n",
       "                                                   showVisits                          NaN   \n",
       "\n",
       "                                                                                               \\\n",
       "type                                                                               COMPLEXITY   \n",
       "class_name                                         method_name                                  \n",
       "org/springframework/samples/petclinic/Petclinic... <init>                                 1.0   \n",
       "                                                   createRootApplicationContext           1.0   \n",
       "                                                   createServletApplicationContext        1.0   \n",
       "                                                   getServletFilters                      1.0   \n",
       "                                                   getServletMappings                     1.0   \n",
       "                                                   onStartup                              1.0   \n",
       "                                                   registerDandelionServlet               1.0   \n",
       "                                                   registerServletFilter                  1.0   \n",
       "org/springframework/samples/petclinic/model/Bas... <init>                                 1.0   \n",
       "                                                   getId                                  1.0   \n",
       "                                                   isNew                                  2.0   \n",
       "                                                   setId                                  1.0   \n",
       "org/springframework/samples/petclinic/model/Nam... <init>                                 1.0   \n",
       "                                                   getName                                1.0   \n",
       "                                                   setName                                1.0   \n",
       "                                                   toString                               0.0   \n",
       "org/springframework/samples/petclinic/model/Owner  <init>                                 1.0   \n",
       "                                                   addPet                                 1.0   \n",
       "                                                   getAddress                             1.0   \n",
       "                                                   getCity                                1.0   \n",
       "                                                   getPet                                 1.0   \n",
       "                                                   getPets                                1.0   \n",
       "                                                   getPetsInternal                        1.0   \n",
       "                                                   getTelephone                           1.0   \n",
       "                                                   setAddress                             1.0   \n",
       "                                                   setCity                                1.0   \n",
       "                                                   setPetsInternal                        0.0   \n",
       "                                                   setTelephone                           1.0   \n",
       "                                                   toString                               0.0   \n",
       "org/springframework/samples/petclinic/model/Person <init>                                 1.0   \n",
       "...                                                                                       ...   \n",
       "org/springframework/samples/petclinic/web/Owner... initUpdateOwnerForm                    1.0   \n",
       "                                                   processCreationForm                    0.0   \n",
       "                                                   processFindForm                        1.0   \n",
       "                                                   processUpdateOwnerForm                 1.0   \n",
       "                                                   setAllowedFields                       1.0   \n",
       "                                                   showOwner                              1.0   \n",
       "org/springframework/samples/petclinic/web/PetCo... <init>                                 1.0   \n",
       "                                                   findOwner                              1.0   \n",
       "                                                   initCreationForm                       1.0   \n",
       "                                                   initOwnerBinder                        1.0   \n",
       "                                                   initPetBinder                          1.0   \n",
       "                                                   initUpdateForm                         0.0   \n",
       "                                                   populatePetTypes                       1.0   \n",
       "                                                   processCreationForm                    1.0   \n",
       "                                                   processUpdateForm                      0.0   \n",
       "org/springframework/samples/petclinic/web/PetTy... <init>                                 1.0   \n",
       "                                                   parse                                  2.0   \n",
       "                                                   print                                  1.0   \n",
       "org/springframework/samples/petclinic/web/PetVa... <init>                                 1.0   \n",
       "                                                   supports                               1.0   \n",
       "                                                   validate                               1.0   \n",
       "org/springframework/samples/petclinic/web/VetCo... <init>                                 1.0   \n",
       "                                                   showResourcesVetList                   0.0   \n",
       "                                                   showVetList                            0.0   \n",
       "org/springframework/samples/petclinic/web/Visit... <init>                                 1.0   \n",
       "                                                   initNewVisitForm                       1.0   \n",
       "                                                   loadPetWithVisit                       1.0   \n",
       "                                                   processNewVisitForm                    1.0   \n",
       "                                                   setAllowedFields                       1.0   \n",
       "                                                   showVisits                             0.0   \n",
       "\n",
       "                                                                                                \\\n",
       "type                                                                               INSTRUCTION   \n",
       "class_name                                         method_name                                   \n",
       "org/springframework/samples/petclinic/Petclinic... <init>                                  3.0   \n",
       "                                                   createRootApplicationContext           27.0   \n",
       "                                                   createServletApplicationContext         9.0   \n",
       "                                                   getServletFilters                      29.0   \n",
       "                                                   getServletMappings                      7.0   \n",
       "                                                   onStartup                               7.0   \n",
       "                                                   registerDandelionServlet               22.0   \n",
       "                                                   registerServletFilter                  20.0   \n",
       "org/springframework/samples/petclinic/model/Bas... <init>                                  3.0   \n",
       "                                                   getId                                   3.0   \n",
       "                                                   isNew                                   7.0   \n",
       "                                                   setId                                   4.0   \n",
       "org/springframework/samples/petclinic/model/Nam... <init>                                  3.0   \n",
       "                                                   getName                                 3.0   \n",
       "                                                   setName                                 4.0   \n",
       "                                                   toString                                0.0   \n",
       "org/springframework/samples/petclinic/model/Owner  <init>                                  3.0   \n",
       "                                                   addPet                                  9.0   \n",
       "                                                   getAddress                              3.0   \n",
       "                                                   getCity                                 3.0   \n",
       "                                                   getPet                                 16.0   \n",
       "                                                   getPets                                17.0   \n",
       "                                                   getPetsInternal                         6.0   \n",
       "                                                   getTelephone                            3.0   \n",
       "                                                   setAddress                              4.0   \n",
       "                                                   setCity                                 4.0   \n",
       "                                                   setPetsInternal                         0.0   \n",
       "                                                   setTelephone                            4.0   \n",
       "                                                   toString                                0.0   \n",
       "org/springframework/samples/petclinic/model/Person <init>                                  3.0   \n",
       "...                                                                                        ...   \n",
       "org/springframework/samples/petclinic/web/Owner... initUpdateOwnerForm                    11.0   \n",
       "                                                   processCreationForm                     0.0   \n",
       "                                                   processFindForm                        23.0   \n",
       "                                                   processUpdateOwnerForm                 13.0   \n",
       "                                                   setAllowedFields                        9.0   \n",
       "                                                   showOwner                              14.0   \n",
       "org/springframework/samples/petclinic/web/PetCo... <init>                                  6.0   \n",
       "                                                   findOwner                               5.0   \n",
       "                                                   initCreationForm                       14.0   \n",
       "                                                   initOwnerBinder                         9.0   \n",
       "                                                   initPetBinder                           6.0   \n",
       "                                                   initUpdateForm                          0.0   \n",
       "                                                   populatePetTypes                        4.0   \n",
       "                                                   processCreationForm                    25.0   \n",
       "                                                   processUpdateForm                       0.0   \n",
       "org/springframework/samples/petclinic/web/PetTy... <init>                                  6.0   \n",
       "                                                   parse                                  22.0   \n",
       "                                                   print                                   3.0   \n",
       "org/springframework/samples/petclinic/web/PetVa... <init>                                  3.0   \n",
       "                                                   supports                                4.0   \n",
       "                                                   validate                               19.0   \n",
       "org/springframework/samples/petclinic/web/VetCo... <init>                                  6.0   \n",
       "                                                   showResourcesVetList                    0.0   \n",
       "                                                   showVetList                             0.0   \n",
       "org/springframework/samples/petclinic/web/Visit... <init>                                  6.0   \n",
       "                                                   initNewVisitForm                        2.0   \n",
       "                                                   loadPetWithVisit                       14.0   \n",
       "                                                   processNewVisitForm                     9.0   \n",
       "                                                   setAllowedFields                        9.0   \n",
       "                                                   showVisits                              0.0   \n",
       "\n",
       "                                                                                         \\\n",
       "type                                                                               LINE   \n",
       "class_name                                         method_name                            \n",
       "org/springframework/samples/petclinic/Petclinic... <init>                           1.0   \n",
       "                                                   createRootApplicationContext     4.0   \n",
       "                                                   createServletApplicationContext  3.0   \n",
       "                                                   getServletFilters                4.0   \n",
       "                                                   getServletMappings               1.0   \n",
       "                                                   onStartup                        3.0   \n",
       "                                                   registerDandelionServlet         5.0   \n",
       "                                                   registerServletFilter            3.0   \n",
       "org/springframework/samples/petclinic/model/Bas... <init>                           1.0   \n",
       "                                                   getId                            1.0   \n",
       "                                                   isNew                            1.0   \n",
       "                                                   setId                            2.0   \n",
       "org/springframework/samples/petclinic/model/Nam... <init>                           1.0   \n",
       "                                                   getName                          1.0   \n",
       "                                                   setName                          2.0   \n",
       "                                                   toString                         0.0   \n",
       "org/springframework/samples/petclinic/model/Owner  <init>                           1.0   \n",
       "                                                   addPet                           3.0   \n",
       "                                                   getAddress                       1.0   \n",
       "                                                   getCity                          1.0   \n",
       "                                                   getPet                           4.0   \n",
       "                                                   getPets                          3.0   \n",
       "                                                   getPetsInternal                  2.0   \n",
       "                                                   getTelephone                     1.0   \n",
       "                                                   setAddress                       2.0   \n",
       "                                                   setCity                          2.0   \n",
       "                                                   setPetsInternal                  0.0   \n",
       "                                                   setTelephone                     2.0   \n",
       "                                                   toString                         0.0   \n",
       "org/springframework/samples/petclinic/model/Person <init>                           1.0   \n",
       "...                                                                                 ...   \n",
       "org/springframework/samples/petclinic/web/Owner... initUpdateOwnerForm              3.0   \n",
       "                                                   processCreationForm              0.0   \n",
       "                                                   processFindForm                  6.0   \n",
       "                                                   processUpdateOwnerForm           4.0   \n",
       "                                                   setAllowedFields                 2.0   \n",
       "                                                   showOwner                        3.0   \n",
       "org/springframework/samples/petclinic/web/PetCo... <init>                           3.0   \n",
       "                                                   findOwner                        1.0   \n",
       "                                                   initCreationForm                 4.0   \n",
       "                                                   initOwnerBinder                  2.0   \n",
       "                                                   initPetBinder                    2.0   \n",
       "                                                   initUpdateForm                   0.0   \n",
       "                                                   populatePetTypes                 1.0   \n",
       "                                                   processCreationForm              5.0   \n",
       "                                                   processUpdateForm                0.0   \n",
       "org/springframework/samples/petclinic/web/PetTy... <init>                           3.0   \n",
       "                                                   parse                            5.0   \n",
       "                                                   print                            1.0   \n",
       "org/springframework/samples/petclinic/web/PetVa... <init>                           1.0   \n",
       "                                                   supports                         1.0   \n",
       "                                                   validate                         6.0   \n",
       "org/springframework/samples/petclinic/web/VetCo... <init>                           3.0   \n",
       "                                                   showResourcesVetList             0.0   \n",
       "                                                   showVetList                      0.0   \n",
       "org/springframework/samples/petclinic/web/Visit... <init>                           3.0   \n",
       "                                                   initNewVisitForm                 1.0   \n",
       "                                                   loadPetWithVisit                 4.0   \n",
       "                                                   processNewVisitForm              3.0   \n",
       "                                                   setAllowedFields                 2.0   \n",
       "                                                   showVisits                       0.0   \n",
       "\n",
       "                                                                                           \n",
       "type                                                                               METHOD  \n",
       "class_name                                         method_name                             \n",
       "org/springframework/samples/petclinic/Petclinic... <init>                             1.0  \n",
       "                                                   createRootApplicationContext       1.0  \n",
       "                                                   createServletApplicationContext    1.0  \n",
       "                                                   getServletFilters                  1.0  \n",
       "                                                   getServletMappings                 1.0  \n",
       "                                                   onStartup                          1.0  \n",
       "                                                   registerDandelionServlet           1.0  \n",
       "                                                   registerServletFilter              1.0  \n",
       "org/springframework/samples/petclinic/model/Bas... <init>                             1.0  \n",
       "                                                   getId                              1.0  \n",
       "                                                   isNew                              1.0  \n",
       "                                                   setId                              1.0  \n",
       "org/springframework/samples/petclinic/model/Nam... <init>                             1.0  \n",
       "                                                   getName                            1.0  \n",
       "                                                   setName                            1.0  \n",
       "                                                   toString                           0.0  \n",
       "org/springframework/samples/petclinic/model/Owner  <init>                             1.0  \n",
       "                                                   addPet                             1.0  \n",
       "                                                   getAddress                         1.0  \n",
       "                                                   getCity                            1.0  \n",
       "                                                   getPet                             0.5  \n",
       "                                                   getPets                            1.0  \n",
       "                                                   getPetsInternal                    1.0  \n",
       "                                                   getTelephone                       1.0  \n",
       "                                                   setAddress                         1.0  \n",
       "                                                   setCity                            1.0  \n",
       "                                                   setPetsInternal                    0.0  \n",
       "                                                   setTelephone                       1.0  \n",
       "                                                   toString                           0.0  \n",
       "org/springframework/samples/petclinic/model/Person <init>                             1.0  \n",
       "...                                                                                   ...  \n",
       "org/springframework/samples/petclinic/web/Owner... initUpdateOwnerForm                1.0  \n",
       "                                                   processCreationForm                0.0  \n",
       "                                                   processFindForm                    1.0  \n",
       "                                                   processUpdateOwnerForm             1.0  \n",
       "                                                   setAllowedFields                   1.0  \n",
       "                                                   showOwner                          1.0  \n",
       "org/springframework/samples/petclinic/web/PetCo... <init>                             1.0  \n",
       "                                                   findOwner                          1.0  \n",
       "                                                   initCreationForm                   1.0  \n",
       "                                                   initOwnerBinder                    1.0  \n",
       "                                                   initPetBinder                      1.0  \n",
       "                                                   initUpdateForm                     0.0  \n",
       "                                                   populatePetTypes                   1.0  \n",
       "                                                   processCreationForm                1.0  \n",
       "                                                   processUpdateForm                  0.0  \n",
       "org/springframework/samples/petclinic/web/PetTy... <init>                             1.0  \n",
       "                                                   parse                              1.0  \n",
       "                                                   print                              1.0  \n",
       "org/springframework/samples/petclinic/web/PetVa... <init>                             1.0  \n",
       "                                                   supports                           1.0  \n",
       "                                                   validate                           1.0  \n",
       "org/springframework/samples/petclinic/web/VetCo... <init>                             1.0  \n",
       "                                                   showResourcesVetList               0.0  \n",
       "                                                   showVetList                        0.0  \n",
       "org/springframework/samples/petclinic/web/Visit... <init>                             1.0  \n",
       "                                                   initNewVisitForm                   1.0  \n",
       "                                                   loadPetWithVisit                   1.0  \n",
       "                                                   processNewVisitForm                1.0  \n",
       "                                                   setAllowedFields                   1.0  \n",
       "                                                   showVisits                         0.0  \n",
       "\n",
       "[162 rows x 5 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "coverage_data.pivot_table(\n",
    "    index=[\"class_name\", \"method_name\"],\n",
    "    columns=['type'],\n",
    "    values=[\"covered\", \"missed\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Limitations\n",
    "Unfortunately, there is currently an important feature missing. Apparently, you "
   ]
  }
 ],
 "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
}