Triga perfecte composita (Beispiel 1).ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Triga perfecte composita (2-2-2)\n",
    "\n",
    "Spurensuche bei Schütz und Schein"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "dfSchuetz6 = pd.read_json(\"schuetz6-datenset.json\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>StimmenZahl</th>\n",
       "      <th>TrigaKlasse</th>\n",
       "      <th>TrigaAttribut</th>\n",
       "      <th>IntervallStruktur</th>\n",
       "      <th>Anzahl</th>\n",
       "      <th>Dauer</th>\n",
       "      <th>Bassnoten</th>\n",
       "      <th>Stellen</th>\n",
       "      <th>Bassschritte</th>\n",
       "      <th>b</th>\n",
       "      <th>m</th>\n",
       "      <th>s</th>\n",
       "      <th>AvLaenge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>M3--P5--P8--P12--M17</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M3, P5, P8, P12, M17]</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>{'C3': 1}</td>\n",
       "      <td>{'Das_ist_je_gewisslich_wahr.musicxml': [42.0]}</td>\n",
       "      <td>{'P1': [['M3', 'M6', 'P8', 'M10', 'M17']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3--P5--P12--P15--M17</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M3, P5, P12, P15, M17]</td>\n",
       "      <td>1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>{'B-2': 1}</td>\n",
       "      <td>{'Ein-Kind-ist-uns-geboren.musicxml': [66.0]}</td>\n",
       "      <td>{'M2': [['P5', 'm10', 'P12', 'P15']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>m3--P5--P8--m10--P12</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[m3, P5, P8, m10, P12]</td>\n",
       "      <td>14</td>\n",
       "      <td>38.5</td>\n",
       "      <td>{'A3': 6, 'G3': 5, 'D3': 3}</td>\n",
       "      <td>{'Das_ist_je_gewisslich_wahr.musicxml': [86.0,...</td>\n",
       "      <td>{'P1': [['P4', 'P4', 'P8', 'm10', 'P12'], ['m3...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P8--m10--P12--m17--P19</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P8, m10, P12, m17, P19]</td>\n",
       "      <td>4</td>\n",
       "      <td>11.0</td>\n",
       "      <td>{'G2': 4}</td>\n",
       "      <td>{'Ein-Kind-ist-uns-geboren.musicxml': [60.0, 8...</td>\n",
       "      <td>{'M2': [['m3', 'P8', 'm13', 'm17', 'm17'], ['m...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M10--P12--P15--M17--P19</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M10, P12, P15, M17, P19]</td>\n",
       "      <td>8</td>\n",
       "      <td>21.0</td>\n",
       "      <td>{'F2': 8}</td>\n",
       "      <td>{'Das-Wort-ward-Fleisch.musicxml': [212.0, 220...</td>\n",
       "      <td>{'P4': [['P5', 'P8', 'P12', 'P15', 'M17'], ['P...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.625000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>m3--P5--m10--P12--P15</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[m3, P5, m10, P12, P15]</td>\n",
       "      <td>5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>{'D3': 4, 'C3': 1}</td>\n",
       "      <td>{'Das-Wort-ward-Fleisch.musicxml': [4.0], 'Die...</td>\n",
       "      <td>{'P1': [['P1', 'm3', 'm10', 'm13', 'P15'], ['M...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3--P5--P8--M10--P12</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M3, P5, P8, M10, P12]</td>\n",
       "      <td>47</td>\n",
       "      <td>112.5</td>\n",
       "      <td>{'F3': 23, 'E3': 2, 'G3': 9, 'D3': 2, 'F2': 2,...</td>\n",
       "      <td>{'Das-Wort-ward-Fleisch.musicxml': [222.0, 232...</td>\n",
       "      <td>{'P-5': [['P5', 'P8', 'P12', 'P15', 'M17'], ['...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.393617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3--P5--M10--P12--P15</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M3, P5, M10, P12, P15]</td>\n",
       "      <td>7</td>\n",
       "      <td>15.5</td>\n",
       "      <td>{'D3': 1, 'E-3': 3, 'C3': 2, 'B-2': 1}</td>\n",
       "      <td>{'Das-Wort-ward-Fleisch.musicxml': [20.0], 'Di...</td>\n",
       "      <td>{'P1': [['M3', 'P5', 'P12', 'P15'], ['P1', 'M6...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.214286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P5--M10--P12--P15--M17</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P5, M10, P12, P15, M17]</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>{'F2': 1, 'B-2': 4}</td>\n",
       "      <td>{'Der_Engel_sprach_zu_den_Hirten._SWV_395_-_Sc...</td>\n",
       "      <td>{'M3': [['m6', 'P8', 'm10', 'm10', 'm17']], 'P...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P4--m6--P11--m13--P15</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P4, m6, P11, m13, P15]</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>{'A2': 1}</td>\n",
       "      <td>{'O-lieber-Herre-Gott.musicxml': [102.0]}</td>\n",
       "      <td>{'P1': [['P5', 'P8', 'P11', 'P15', 'P15']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M6--P8--M10--M13--M17</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M6, P8, M10, M13, M17]</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>{'B-2': 1}</td>\n",
       "      <td>{'Ich-bin-ein-rechter-Weinstock.musicxml': [43...</td>\n",
       "      <td>{'M2': [['M6', 'P8', 'M10', 'P12', 'P15']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>m3--m6--m10--m13--P15</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[m3, m6, m10, m13, P15]</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>{'D3': 1}</td>\n",
       "      <td>{'Troestet-mein-Volk.musicxml': [488.0]}</td>\n",
       "      <td>{'m3': [['P1', 'P5', 'P8', 'M10', 'P12']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3--M6--M10--M13--P15</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M3, M6, M10, M13, P15]</td>\n",
       "      <td>3</td>\n",
       "      <td>6.0</td>\n",
       "      <td>{'F2': 1, 'C3': 1, 'F3': 1}</td>\n",
       "      <td>{'Du-Schalksknecht.musicxml': [410.0], 'Seelig...</td>\n",
       "      <td>{'M2': [['M3', 'm6', 'P8', 'P12', 'm13'], ['M3...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P5--m10--P12--P15--m17</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P5, m10, P12, P15, m17]</td>\n",
       "      <td>2</td>\n",
       "      <td>3.5</td>\n",
       "      <td>{'G2': 2}</td>\n",
       "      <td>{'Das-Wort-ward-Fleisch.musicxml': [476.0], 'S...</td>\n",
       "      <td>{'P1': [['P5', 'M9', 'P12', 'P15', 'm17'], ['P...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P4--M6--P8--P11--M13</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P4, M6, P8, P11, M13]</td>\n",
       "      <td>1</td>\n",
       "      <td>1.5</td>\n",
       "      <td>{'G2': 1}</td>\n",
       "      <td>{'Auf_dem_Gebirge_hat_man_ein_Geschrei,_SWV_39...</td>\n",
       "      <td>{'P1': [['P4', 'm7', 'P8', 'P11', 'M13']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P5--M10--P15--M17--P19</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P5, M10, P15, M17, P19]</td>\n",
       "      <td>1</td>\n",
       "      <td>1.5</td>\n",
       "      <td>{'F2': 1}</td>\n",
       "      <td>{'Ich-bin-ein-rechter-Weinstock.musicxml': [42...</td>\n",
       "      <td>{'P1': [['P5', 'M10', 'P15', 'M16', 'P18']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P1--m3--P5--m10--P12</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P1, m3, P5, m10, P12]</td>\n",
       "      <td>6</td>\n",
       "      <td>7.5</td>\n",
       "      <td>{'A3': 2, 'D3': 1, 'G3': 3}</td>\n",
       "      <td>{'Das_ist_je_gewisslich_wahr.musicxml': [537.0...</td>\n",
       "      <td>{'P-5': [['m3', 'P8', 'm10', 'M13', 'P15'], ['...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P8--M10--P12--M17--P19</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P8, M10, P12, M17, P19]</td>\n",
       "      <td>3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>{'F2': 2, 'G2': 1}</td>\n",
       "      <td>{'Ein-Kind-ist-uns-geboren.musicxml': [468.0],...</td>\n",
       "      <td>{'P5': [['M3', 'P5', 'M10', 'P12', 'P15']], 'P...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P4--m6--P8--P11--m13</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P4, m6, P8, P11, m13]</td>\n",
       "      <td>6</td>\n",
       "      <td>6.5</td>\n",
       "      <td>{'E3': 1, 'G2': 1, 'D3': 3, 'A2': 1}</td>\n",
       "      <td>{'Das_ist_je_gewisslich_wahr.musicxml': [70.0]...</td>\n",
       "      <td>{'P1': [['P4', 'P8', 'P8', 'P11', 'm13'], ['P4...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.083333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P5--P8--m10--P12--m17</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P5, P8, m10, P12, m17]</td>\n",
       "      <td>3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>{'C3': 2, 'A2': 1}</td>\n",
       "      <td>{'Herzlich-lieb-hab-ich-dich.musicxml': [270.0...</td>\n",
       "      <td>{'P1': [['P8', 'P8', 'm10', 'M13', 'm17'], ['P...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P5--P8--M10--M17--P19</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P5, P8, M10, M17, P19]</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>{'B-2': 2}</td>\n",
       "      <td>{'Herzlich-lieb-hab-ich-dich.musicxml': [66.0,...</td>\n",
       "      <td>{'M2': [['P5', 'P8', 'P12', 'P15', 'm17'], ['P...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>m3--P5--P8--P12--m17</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[m3, P5, P8, P12, m17]</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>{'C3': 1}</td>\n",
       "      <td>{'Die_Himmel_erzaehlen_die_Ehre_Gottes_-_Schue...</td>\n",
       "      <td>{'P1': [['m3', 'P5', 'M9', 'P12', 'M16']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P1--M3--P5--M10--P12</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P1, M3, P5, M10, P12]</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>{'F3': 1}</td>\n",
       "      <td>{'Troestet-mein-Volk.musicxml': [148.0]}</td>\n",
       "      <td>{'m-3': [['m3', 'P5', 'm10', 'P12', 'P15']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>m3--m6--P8--m10--m13</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[m3, m6, P8, m10, m13]</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>{'D3': 1}</td>\n",
       "      <td>{'Troestet-mein-Volk.musicxml': [538.0]}</td>\n",
       "      <td>{'M-2': [['P4', 'M6', 'M10', 'M13', 'P15']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P5--P8--M10--P12--M17</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P5, P8, M10, P12, M17]</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>{'B-2': 1}</td>\n",
       "      <td>{'Troestet-mein-Volk.musicxml': [543.0]}</td>\n",
       "      <td>{'M6': [[]]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3--P8--M10--P12--P19</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M3, P8, M10, P12, P19]</td>\n",
       "      <td>1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>{'B-2': 1}</td>\n",
       "      <td>{'Die_Himmel_erzaehlen_die_Ehre_Gottes_-_Schue...</td>\n",
       "      <td>{'P1': [['M3', 'M7', 'M9', 'P12', 'P19']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>P5--m10--P15--m17--P19</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P5, m10, P15, m17, P19]</td>\n",
       "      <td>1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>{'G2': 1}</td>\n",
       "      <td>{'Die_Himmel_erzaehlen_die_Ehre_Gottes_-_Schue...</td>\n",
       "      <td>{'M2': [['P4', 'm9', 'm14', 'm16', 'P18']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3--M6--M13--P15--M17</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M3, M6, M13, P15, M17]</td>\n",
       "      <td>1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>{'B-2': 1}</td>\n",
       "      <td>{'Ich-bin-eine-rufende-Stimme.musicxml': [199.0]}</td>\n",
       "      <td>{'m-3': [['P5', 'P8', 'P15', 'P18', 'P19']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3--M6--P8--M10--M13</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M3, M6, P8, M10, M13]</td>\n",
       "      <td>1</td>\n",
       "      <td>0.5</td>\n",
       "      <td>{'F3': 1}</td>\n",
       "      <td>{'O-lieber-Herre-Gott.musicxml': [316.0]}</td>\n",
       "      <td>{'P1': [['M6', 'M6', 'P8', 'M10', 'P15']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         StimmenZahl TrigaKlasse TrigaAttribut  \\\n",
       "M3--P5--P8--P12--M17               6          TP         pcomp   \n",
       "M3--P5--P12--P15--M17              6          TP         pcomp   \n",
       "m3--P5--P8--m10--P12               6          TI         pcomp   \n",
       "P8--m10--P12--m17--P19             6          TI         pcomp   \n",
       "M10--P12--P15--M17--P19            6          TP         pcomp   \n",
       "m3--P5--m10--P12--P15              6          TI         pcomp   \n",
       "M3--P5--P8--M10--P12               6          TP         pcomp   \n",
       "M3--P5--M10--P12--P15              6          TP         pcomp   \n",
       "P5--M10--P12--P15--M17             6          TP         pcomp   \n",
       "P4--m6--P11--m13--P15              6          TI         pcomp   \n",
       "M6--P8--M10--M13--M17              6          TI         pcomp   \n",
       "m3--m6--m10--m13--P15              6          TP         pcomp   \n",
       "M3--M6--M10--M13--P15              6          TI         pcomp   \n",
       "P5--m10--P12--P15--m17             6          TI         pcomp   \n",
       "P4--M6--P8--P11--M13               6          TP         pcomp   \n",
       "P5--M10--P15--M17--P19             6          TP         pcomp   \n",
       "P1--m3--P5--m10--P12               6          TI         pcomp   \n",
       "P8--M10--P12--M17--P19             6          TP         pcomp   \n",
       "P4--m6--P8--P11--m13               6          TI         pcomp   \n",
       "P5--P8--m10--P12--m17              6          TI         pcomp   \n",
       "P5--P8--M10--M17--P19              6          TP         pcomp   \n",
       "m3--P5--P8--P12--m17               6          TI         pcomp   \n",
       "P1--M3--P5--M10--P12               6          TP         pcomp   \n",
       "m3--m6--P8--m10--m13               6          TP         pcomp   \n",
       "P5--P8--M10--P12--M17              6          TP         pcomp   \n",
       "M3--P8--M10--P12--P19              6          TP         pcomp   \n",
       "P5--m10--P15--m17--P19             6          TI         pcomp   \n",
       "M3--M6--M13--P15--M17              6          TI         pcomp   \n",
       "M3--M6--P8--M10--M13               6          TI         pcomp   \n",
       "\n",
       "                                 IntervallStruktur  Anzahl  Dauer  \\\n",
       "M3--P5--P8--P12--M17        [M3, P5, P8, P12, M17]       1    6.0   \n",
       "M3--P5--P12--P15--M17      [M3, P5, P12, P15, M17]       1    4.0   \n",
       "m3--P5--P8--m10--P12        [m3, P5, P8, m10, P12]      14   38.5   \n",
       "P8--m10--P12--m17--P19    [P8, m10, P12, m17, P19]       4   11.0   \n",
       "M10--P12--P15--M17--P19  [M10, P12, P15, M17, P19]       8   21.0   \n",
       "m3--P5--m10--P12--P15      [m3, P5, m10, P12, P15]       5   12.0   \n",
       "M3--P5--P8--M10--P12        [M3, P5, P8, M10, P12]      47  112.5   \n",
       "M3--P5--M10--P12--P15      [M3, P5, M10, P12, P15]       7   15.5   \n",
       "P5--M10--P12--P15--M17    [P5, M10, P12, P15, M17]       5   10.0   \n",
       "P4--m6--P11--m13--P15      [P4, m6, P11, m13, P15]       1    2.0   \n",
       "M6--P8--M10--M13--M17      [M6, P8, M10, M13, M17]       1    2.0   \n",
       "m3--m6--m10--m13--P15      [m3, m6, m10, m13, P15]       1    2.0   \n",
       "M3--M6--M10--M13--P15      [M3, M6, M10, M13, P15]       3    6.0   \n",
       "P5--m10--P12--P15--m17    [P5, m10, P12, P15, m17]       2    3.5   \n",
       "P4--M6--P8--P11--M13        [P4, M6, P8, P11, M13]       1    1.5   \n",
       "P5--M10--P15--M17--P19    [P5, M10, P15, M17, P19]       1    1.5   \n",
       "P1--m3--P5--m10--P12        [P1, m3, P5, m10, P12]       6    7.5   \n",
       "P8--M10--P12--M17--P19    [P8, M10, P12, M17, P19]       3    3.5   \n",
       "P4--m6--P8--P11--m13        [P4, m6, P8, P11, m13]       6    6.5   \n",
       "P5--P8--m10--P12--m17      [P5, P8, m10, P12, m17]       3    3.0   \n",
       "P5--P8--M10--M17--P19      [P5, P8, M10, M17, P19]       2    2.0   \n",
       "m3--P5--P8--P12--m17        [m3, P5, P8, P12, m17]       1    1.0   \n",
       "P1--M3--P5--M10--P12        [P1, M3, P5, M10, P12]       1    1.0   \n",
       "m3--m6--P8--m10--m13        [m3, m6, P8, m10, m13]       1    1.0   \n",
       "P5--P8--M10--P12--M17      [P5, P8, M10, P12, M17]       1    1.0   \n",
       "M3--P8--M10--P12--P19      [M3, P8, M10, P12, P19]       1    0.5   \n",
       "P5--m10--P15--m17--P19    [P5, m10, P15, m17, P19]       1    0.5   \n",
       "M3--M6--M13--P15--M17      [M3, M6, M13, P15, M17]       1    0.5   \n",
       "M3--M6--P8--M10--M13        [M3, M6, P8, M10, M13]       1    0.5   \n",
       "\n",
       "                                                                 Bassnoten  \\\n",
       "M3--P5--P8--P12--M17                                             {'C3': 1}   \n",
       "M3--P5--P12--P15--M17                                           {'B-2': 1}   \n",
       "m3--P5--P8--m10--P12                           {'A3': 6, 'G3': 5, 'D3': 3}   \n",
       "P8--m10--P12--m17--P19                                           {'G2': 4}   \n",
       "M10--P12--P15--M17--P19                                          {'F2': 8}   \n",
       "m3--P5--m10--P12--P15                                   {'D3': 4, 'C3': 1}   \n",
       "M3--P5--P8--M10--P12     {'F3': 23, 'E3': 2, 'G3': 9, 'D3': 2, 'F2': 2,...   \n",
       "M3--P5--M10--P12--P15               {'D3': 1, 'E-3': 3, 'C3': 2, 'B-2': 1}   \n",
       "P5--M10--P12--P15--M17                                 {'F2': 1, 'B-2': 4}   \n",
       "P4--m6--P11--m13--P15                                            {'A2': 1}   \n",
       "M6--P8--M10--M13--M17                                           {'B-2': 1}   \n",
       "m3--m6--m10--m13--P15                                            {'D3': 1}   \n",
       "M3--M6--M10--M13--P15                          {'F2': 1, 'C3': 1, 'F3': 1}   \n",
       "P5--m10--P12--P15--m17                                           {'G2': 2}   \n",
       "P4--M6--P8--P11--M13                                             {'G2': 1}   \n",
       "P5--M10--P15--M17--P19                                           {'F2': 1}   \n",
       "P1--m3--P5--m10--P12                           {'A3': 2, 'D3': 1, 'G3': 3}   \n",
       "P8--M10--P12--M17--P19                                  {'F2': 2, 'G2': 1}   \n",
       "P4--m6--P8--P11--m13                  {'E3': 1, 'G2': 1, 'D3': 3, 'A2': 1}   \n",
       "P5--P8--m10--P12--m17                                   {'C3': 2, 'A2': 1}   \n",
       "P5--P8--M10--M17--P19                                           {'B-2': 2}   \n",
       "m3--P5--P8--P12--m17                                             {'C3': 1}   \n",
       "P1--M3--P5--M10--P12                                             {'F3': 1}   \n",
       "m3--m6--P8--m10--m13                                             {'D3': 1}   \n",
       "P5--P8--M10--P12--M17                                           {'B-2': 1}   \n",
       "M3--P8--M10--P12--P19                                           {'B-2': 1}   \n",
       "P5--m10--P15--m17--P19                                           {'G2': 1}   \n",
       "M3--M6--M13--P15--M17                                           {'B-2': 1}   \n",
       "M3--M6--P8--M10--M13                                             {'F3': 1}   \n",
       "\n",
       "                                                                   Stellen  \\\n",
       "M3--P5--P8--P12--M17       {'Das_ist_je_gewisslich_wahr.musicxml': [42.0]}   \n",
       "M3--P5--P12--P15--M17        {'Ein-Kind-ist-uns-geboren.musicxml': [66.0]}   \n",
       "m3--P5--P8--m10--P12     {'Das_ist_je_gewisslich_wahr.musicxml': [86.0,...   \n",
       "P8--m10--P12--m17--P19   {'Ein-Kind-ist-uns-geboren.musicxml': [60.0, 8...   \n",
       "M10--P12--P15--M17--P19  {'Das-Wort-ward-Fleisch.musicxml': [212.0, 220...   \n",
       "m3--P5--m10--P12--P15    {'Das-Wort-ward-Fleisch.musicxml': [4.0], 'Die...   \n",
       "M3--P5--P8--M10--P12     {'Das-Wort-ward-Fleisch.musicxml': [222.0, 232...   \n",
       "M3--P5--M10--P12--P15    {'Das-Wort-ward-Fleisch.musicxml': [20.0], 'Di...   \n",
       "P5--M10--P12--P15--M17   {'Der_Engel_sprach_zu_den_Hirten._SWV_395_-_Sc...   \n",
       "P4--m6--P11--m13--P15            {'O-lieber-Herre-Gott.musicxml': [102.0]}   \n",
       "M6--P8--M10--M13--M17    {'Ich-bin-ein-rechter-Weinstock.musicxml': [43...   \n",
       "m3--m6--m10--m13--P15             {'Troestet-mein-Volk.musicxml': [488.0]}   \n",
       "M3--M6--M10--M13--P15    {'Du-Schalksknecht.musicxml': [410.0], 'Seelig...   \n",
       "P5--m10--P12--P15--m17   {'Das-Wort-ward-Fleisch.musicxml': [476.0], 'S...   \n",
       "P4--M6--P8--P11--M13     {'Auf_dem_Gebirge_hat_man_ein_Geschrei,_SWV_39...   \n",
       "P5--M10--P15--M17--P19   {'Ich-bin-ein-rechter-Weinstock.musicxml': [42...   \n",
       "P1--m3--P5--m10--P12     {'Das_ist_je_gewisslich_wahr.musicxml': [537.0...   \n",
       "P8--M10--P12--M17--P19   {'Ein-Kind-ist-uns-geboren.musicxml': [468.0],...   \n",
       "P4--m6--P8--P11--m13     {'Das_ist_je_gewisslich_wahr.musicxml': [70.0]...   \n",
       "P5--P8--m10--P12--m17    {'Herzlich-lieb-hab-ich-dich.musicxml': [270.0...   \n",
       "P5--P8--M10--M17--P19    {'Herzlich-lieb-hab-ich-dich.musicxml': [66.0,...   \n",
       "m3--P5--P8--P12--m17     {'Die_Himmel_erzaehlen_die_Ehre_Gottes_-_Schue...   \n",
       "P1--M3--P5--M10--P12              {'Troestet-mein-Volk.musicxml': [148.0]}   \n",
       "m3--m6--P8--m10--m13              {'Troestet-mein-Volk.musicxml': [538.0]}   \n",
       "P5--P8--M10--P12--M17             {'Troestet-mein-Volk.musicxml': [543.0]}   \n",
       "M3--P8--M10--P12--P19    {'Die_Himmel_erzaehlen_die_Ehre_Gottes_-_Schue...   \n",
       "P5--m10--P15--m17--P19   {'Die_Himmel_erzaehlen_die_Ehre_Gottes_-_Schue...   \n",
       "M3--M6--M13--P15--M17    {'Ich-bin-eine-rufende-Stimme.musicxml': [199.0]}   \n",
       "M3--M6--P8--M10--M13             {'O-lieber-Herre-Gott.musicxml': [316.0]}   \n",
       "\n",
       "                                                              Bassschritte  \\\n",
       "M3--P5--P8--P12--M17            {'P1': [['M3', 'M6', 'P8', 'M10', 'M17']]}   \n",
       "M3--P5--P12--P15--M17                {'M2': [['P5', 'm10', 'P12', 'P15']]}   \n",
       "m3--P5--P8--m10--P12     {'P1': [['P4', 'P4', 'P8', 'm10', 'P12'], ['m3...   \n",
       "P8--m10--P12--m17--P19   {'M2': [['m3', 'P8', 'm13', 'm17', 'm17'], ['m...   \n",
       "M10--P12--P15--M17--P19  {'P4': [['P5', 'P8', 'P12', 'P15', 'M17'], ['P...   \n",
       "m3--P5--m10--P12--P15    {'P1': [['P1', 'm3', 'm10', 'm13', 'P15'], ['M...   \n",
       "M3--P5--P8--M10--P12     {'P-5': [['P5', 'P8', 'P12', 'P15', 'M17'], ['...   \n",
       "M3--P5--M10--P12--P15    {'P1': [['M3', 'P5', 'P12', 'P15'], ['P1', 'M6...   \n",
       "P5--M10--P12--P15--M17   {'M3': [['m6', 'P8', 'm10', 'm10', 'm17']], 'P...   \n",
       "P4--m6--P11--m13--P15          {'P1': [['P5', 'P8', 'P11', 'P15', 'P15']]}   \n",
       "M6--P8--M10--M13--M17          {'M2': [['M6', 'P8', 'M10', 'P12', 'P15']]}   \n",
       "m3--m6--m10--m13--P15           {'m3': [['P1', 'P5', 'P8', 'M10', 'P12']]}   \n",
       "M3--M6--M10--M13--P15    {'M2': [['M3', 'm6', 'P8', 'P12', 'm13'], ['M3...   \n",
       "P5--m10--P12--P15--m17   {'P1': [['P5', 'M9', 'P12', 'P15', 'm17'], ['P...   \n",
       "P4--M6--P8--P11--M13            {'P1': [['P4', 'm7', 'P8', 'P11', 'M13']]}   \n",
       "P5--M10--P15--M17--P19        {'P1': [['P5', 'M10', 'P15', 'M16', 'P18']]}   \n",
       "P1--m3--P5--m10--P12     {'P-5': [['m3', 'P8', 'm10', 'M13', 'P15'], ['...   \n",
       "P8--M10--P12--M17--P19   {'P5': [['M3', 'P5', 'M10', 'P12', 'P15']], 'P...   \n",
       "P4--m6--P8--P11--m13     {'P1': [['P4', 'P8', 'P8', 'P11', 'm13'], ['P4...   \n",
       "P5--P8--m10--P12--m17    {'P1': [['P8', 'P8', 'm10', 'M13', 'm17'], ['P...   \n",
       "P5--P8--M10--M17--P19    {'M2': [['P5', 'P8', 'P12', 'P15', 'm17'], ['P...   \n",
       "m3--P5--P8--P12--m17            {'P1': [['m3', 'P5', 'M9', 'P12', 'M16']]}   \n",
       "P1--M3--P5--M10--P12          {'m-3': [['m3', 'P5', 'm10', 'P12', 'P15']]}   \n",
       "m3--m6--P8--m10--m13          {'M-2': [['P4', 'M6', 'M10', 'M13', 'P15']]}   \n",
       "P5--P8--M10--P12--M17                                         {'M6': [[]]}   \n",
       "M3--P8--M10--P12--P19           {'P1': [['M3', 'M7', 'M9', 'P12', 'P19']]}   \n",
       "P5--m10--P15--m17--P19         {'M2': [['P4', 'm9', 'm14', 'm16', 'P18']]}   \n",
       "M3--M6--M13--P15--M17         {'m-3': [['P5', 'P8', 'P15', 'P18', 'P19']]}   \n",
       "M3--M6--P8--M10--M13            {'P1': [['M6', 'M6', 'P8', 'M10', 'P15']]}   \n",
       "\n",
       "                           b    m    s  AvLaenge  \n",
       "M3--P5--P8--P12--M17     2.0  2.0  2.0  6.000000  \n",
       "M3--P5--P12--P15--M17    2.0  2.0  2.0  4.000000  \n",
       "m3--P5--P8--m10--P12     2.0  2.0  2.0  2.750000  \n",
       "P8--m10--P12--m17--P19   2.0  2.0  2.0  2.750000  \n",
       "M10--P12--P15--M17--P19  2.0  2.0  2.0  2.625000  \n",
       "m3--P5--m10--P12--P15    2.0  2.0  2.0  2.400000  \n",
       "M3--P5--P8--M10--P12     2.0  2.0  2.0  2.393617  \n",
       "M3--P5--M10--P12--P15    2.0  2.0  2.0  2.214286  \n",
       "P5--M10--P12--P15--M17   2.0  2.0  2.0  2.000000  \n",
       "P4--m6--P11--m13--P15    2.0  2.0  2.0  2.000000  \n",
       "M6--P8--M10--M13--M17    2.0  2.0  2.0  2.000000  \n",
       "m3--m6--m10--m13--P15    2.0  2.0  2.0  2.000000  \n",
       "M3--M6--M10--M13--P15    2.0  2.0  2.0  2.000000  \n",
       "P5--m10--P12--P15--m17   2.0  2.0  2.0  1.750000  \n",
       "P4--M6--P8--P11--M13     2.0  2.0  2.0  1.500000  \n",
       "P5--M10--P15--M17--P19   2.0  2.0  2.0  1.500000  \n",
       "P1--m3--P5--m10--P12     2.0  2.0  2.0  1.250000  \n",
       "P8--M10--P12--M17--P19   2.0  2.0  2.0  1.166667  \n",
       "P4--m6--P8--P11--m13     2.0  2.0  2.0  1.083333  \n",
       "P5--P8--m10--P12--m17    2.0  2.0  2.0  1.000000  \n",
       "P5--P8--M10--M17--P19    2.0  2.0  2.0  1.000000  \n",
       "m3--P5--P8--P12--m17     2.0  2.0  2.0  1.000000  \n",
       "P1--M3--P5--M10--P12     2.0  2.0  2.0  1.000000  \n",
       "m3--m6--P8--m10--m13     2.0  2.0  2.0  1.000000  \n",
       "P5--P8--M10--P12--M17    2.0  2.0  2.0  1.000000  \n",
       "M3--P8--M10--P12--P19    2.0  2.0  2.0  0.500000  \n",
       "P5--m10--P15--m17--P19   2.0  2.0  2.0  0.500000  \n",
       "M3--M6--M13--P15--M17    2.0  2.0  2.0  0.500000  \n",
       "M3--M6--P8--M10--M13     2.0  2.0  2.0  0.500000  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sub222Schuetz = dfSchuetz6[(dfSchuetz6[\"TrigaAttribut\"] == \"pcomp\")]\n",
    "\n",
    "stellenSchuetzSorted = sub222Schuetz.sort_values(by=[\"Anzahl\", \"Dauer\"], ascending=False)\n",
    "\n",
    "stellenSchuetzSorted.loc[\"M3--P5--P8--M10--P12\"][\"Stellen\"]\n",
    "\n",
    "columnAvDauer = stellenSchuetzSorted[\"Dauer\"] / stellenSchuetzSorted[\"Anzahl\"]\n",
    "stellenSchuetzSorted[\"AvLaenge\"] = columnAvDauer\n",
    "stellenSchuetzSorted.sort_values(by=\"AvLaenge\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Das_ist_je_gewisslich_wahr.musicxml': [537.0, 553.0],\n",
       " 'Der_Engel_sprach_zu_den_Hirten._SWV_395_-_Schuetz.musicxml': [325.0],\n",
       " 'Troestet-mein-Volk.musicxml': [502.0, 508.0],\n",
       " 'Unser-Wandel-ist-im-Himmel.musicxml': [169.0]}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stellenSchuetzSorted.loc[\"P1--m3--P5--m10--P12\"][\"Stellen\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>StimmenZahl</th>\n",
       "      <th>TrigaKlasse</th>\n",
       "      <th>TrigaAttribut</th>\n",
       "      <th>IntervallStruktur</th>\n",
       "      <th>Anzahl</th>\n",
       "      <th>Dauer</th>\n",
       "      <th>Bassnoten</th>\n",
       "      <th>Stellen</th>\n",
       "      <th>Bassschritte</th>\n",
       "      <th>b</th>\n",
       "      <th>m</th>\n",
       "      <th>s</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>P5--P8--M10--P12--M17</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[P5, P8, M10, P12, M17]</td>\n",
       "      <td>3</td>\n",
       "      <td>2.75</td>\n",
       "      <td>{'C3': 3}</td>\n",
       "      <td>{'IB-26-Nu_danket.musicxml': [56.0, 376.0, 464...</td>\n",
       "      <td>{'P1': [['P5', 'P8', 'P11', 'P12', 'M17'], ['M...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M10--P12--P15--M17--P19</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M10, P12, P15, M17, P19]</td>\n",
       "      <td>2</td>\n",
       "      <td>1.50</td>\n",
       "      <td>{'G2': 2}</td>\n",
       "      <td>{'IB-26-Nu_danket.musicxml': [59.0, 159.5]}</td>\n",
       "      <td>{'M2': [['P5', 'P8', 'P12', 'M16', 'm17']], 'P...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3--P5--M10--P12--P15</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M3, P5, M10, P12, P15]</td>\n",
       "      <td>3</td>\n",
       "      <td>2.75</td>\n",
       "      <td>{'F3': 2, 'C3': 1}</td>\n",
       "      <td>{'IB-26-Nu_danket.musicxml': [69.0, 70.0, 246.0]}</td>\n",
       "      <td>{'P1': [['A4', 'P5', 'M10', 'P12', 'P15']], 'P...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3--P5--P8--M10--P12</th>\n",
       "      <td>6</td>\n",
       "      <td>TP</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[M3, P5, P8, M10, P12]</td>\n",
       "      <td>8</td>\n",
       "      <td>11.00</td>\n",
       "      <td>{'F3': 3, 'E3': 3, 'C3': 2}</td>\n",
       "      <td>{'IB-26-Nu_danket.musicxml': [100.0, 132.0, 23...</td>\n",
       "      <td>{'P1': [['P5', 'M10'], ['P4', 'P5', 'P8', 'M10...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>m3--P5--m10--P12--P15</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[m3, P5, m10, P12, P15]</td>\n",
       "      <td>1</td>\n",
       "      <td>0.50</td>\n",
       "      <td>{'D3': 1}</td>\n",
       "      <td>{'IB-26-Nu_danket.musicxml': [149.0]}</td>\n",
       "      <td>{'P1': [['P4', 'P5', 'm10', 'P12', 'P15']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>m3--P5--P8--m10--P12</th>\n",
       "      <td>6</td>\n",
       "      <td>TI</td>\n",
       "      <td>pcomp</td>\n",
       "      <td>[m3, P5, P8, m10, P12]</td>\n",
       "      <td>1</td>\n",
       "      <td>0.50</td>\n",
       "      <td>{'D3': 1}</td>\n",
       "      <td>{'IB-26-Nu_danket.musicxml': [478.0]}</td>\n",
       "      <td>{'P1': [['P4', 'P5', 'P8', 'm10', 'P12']]}</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         StimmenZahl TrigaKlasse TrigaAttribut  \\\n",
       "P5--P8--M10--P12--M17              6          TP         pcomp   \n",
       "M10--P12--P15--M17--P19            6          TP         pcomp   \n",
       "M3--P5--M10--P12--P15              6          TP         pcomp   \n",
       "M3--P5--P8--M10--P12               6          TP         pcomp   \n",
       "m3--P5--m10--P12--P15              6          TI         pcomp   \n",
       "m3--P5--P8--m10--P12               6          TI         pcomp   \n",
       "\n",
       "                                 IntervallStruktur  Anzahl  Dauer  \\\n",
       "P5--P8--M10--P12--M17      [P5, P8, M10, P12, M17]       3   2.75   \n",
       "M10--P12--P15--M17--P19  [M10, P12, P15, M17, P19]       2   1.50   \n",
       "M3--P5--M10--P12--P15      [M3, P5, M10, P12, P15]       3   2.75   \n",
       "M3--P5--P8--M10--P12        [M3, P5, P8, M10, P12]       8  11.00   \n",
       "m3--P5--m10--P12--P15      [m3, P5, m10, P12, P15]       1   0.50   \n",
       "m3--P5--P8--m10--P12        [m3, P5, P8, m10, P12]       1   0.50   \n",
       "\n",
       "                                           Bassnoten  \\\n",
       "P5--P8--M10--P12--M17                      {'C3': 3}   \n",
       "M10--P12--P15--M17--P19                    {'G2': 2}   \n",
       "M3--P5--M10--P12--P15             {'F3': 2, 'C3': 1}   \n",
       "M3--P5--P8--M10--P12     {'F3': 3, 'E3': 3, 'C3': 2}   \n",
       "m3--P5--m10--P12--P15                      {'D3': 1}   \n",
       "m3--P5--P8--m10--P12                       {'D3': 1}   \n",
       "\n",
       "                                                                   Stellen  \\\n",
       "P5--P8--M10--P12--M17    {'IB-26-Nu_danket.musicxml': [56.0, 376.0, 464...   \n",
       "M10--P12--P15--M17--P19        {'IB-26-Nu_danket.musicxml': [59.0, 159.5]}   \n",
       "M3--P5--M10--P12--P15    {'IB-26-Nu_danket.musicxml': [69.0, 70.0, 246.0]}   \n",
       "M3--P5--P8--M10--P12     {'IB-26-Nu_danket.musicxml': [100.0, 132.0, 23...   \n",
       "m3--P5--m10--P12--P15                {'IB-26-Nu_danket.musicxml': [149.0]}   \n",
       "m3--P5--P8--m10--P12                 {'IB-26-Nu_danket.musicxml': [478.0]}   \n",
       "\n",
       "                                                              Bassschritte  \\\n",
       "P5--P8--M10--P12--M17    {'P1': [['P5', 'P8', 'P11', 'P12', 'M17'], ['M...   \n",
       "M10--P12--P15--M17--P19  {'M2': [['P5', 'P8', 'P12', 'M16', 'm17']], 'P...   \n",
       "M3--P5--M10--P12--P15    {'P1': [['A4', 'P5', 'M10', 'P12', 'P15']], 'P...   \n",
       "M3--P5--P8--M10--P12     {'P1': [['P5', 'M10'], ['P4', 'P5', 'P8', 'M10...   \n",
       "m3--P5--m10--P12--P15          {'P1': [['P4', 'P5', 'm10', 'P12', 'P15']]}   \n",
       "m3--P5--P8--m10--P12            {'P1': [['P4', 'P5', 'P8', 'm10', 'P12']]}   \n",
       "\n",
       "                           b    m    s  \n",
       "P5--P8--M10--P12--M17    2.0  2.0  2.0  \n",
       "M10--P12--P15--M17--P19  2.0  2.0  2.0  \n",
       "M3--P5--M10--P12--P15    2.0  2.0  2.0  \n",
       "M3--P5--P8--M10--P12     2.0  2.0  2.0  \n",
       "m3--P5--m10--P12--P15    2.0  2.0  2.0  \n",
       "m3--P5--P8--m10--P12     2.0  2.0  2.0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "dfSchein = pd.read_json(\"schein-datenset.json\")\n",
    "\n",
    "sub222Schein = dfSchein[(dfSchein[\"StimmenZahl\"] == 6) & (dfSchein[\"TrigaAttribut\"] == \"pcomp\")]\n",
    "sub222Schein"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2844"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfSchuetz6[\"Dauer\"].sum()\n",
    "len(dfSchuetz6)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfSchuetz5 = pd.read_json(\"schuetz5-datenset.json\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3678.0"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfSchuetz5[\"Dauer\"].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}