{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "fa2c0c2d-356b-4ea7-ac83-d1a0246b1139",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: openpyxl in /opt/conda/lib/python3.10/site-packages (3.1.2)\n",
      "Requirement already satisfied: et-xmlfile in /opt/conda/lib/python3.10/site-packages (from openpyxl) (1.1.0)\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    }
   ],
   "source": [
    "%pip install openpyxl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6ec73b33-1f5d-4445-9d84-a85545cd5733",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import re\n",
    "import requests\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 882,
   "id": "4773a522-d048-4bc1-80b1-55e1d8c595a5",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "True\n",
      "False\n"
     ]
    }
   ],
   "source": [
    "p = re.compile('Z[0-9X]+')\n",
    "print(bool(p.search('+Z203753604')))\n",
    "print(bool(p.search('B1575290')))\n",
    "\n",
    "def extract_valid_bc(bc):\n",
    "    pattern = 'Z[0-9X]+'\n",
    "    match = re.search(pattern, str(bc))\n",
    "    if match:\n",
    "        return match.group(0)\n",
    "    return None\n",
    "\n",
    "def get_iiif_manifest(bcs):\n",
    "    mans = []\n",
    "    for bc in bcs:\n",
    "        r = requests.get(f'https://iiif.onb.ac.at/presentation/ABO/{bc}/manifest/')\n",
    "        if r.status_code == 200:\n",
    "            man = r.content\n",
    "            mans.append(man)\n",
    "    return mans"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 169,
   "id": "424debb0-4153-4b21-8ac5-b754d4df2008",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "df_1 = pd.read_excel('data/catalogue/BE ANAv4.xlsx')\n",
    "df_2 = pd.read_excel('data/catalogue/notBE-Eugeniana ANA.xlsx')\n",
    "df_3 = pd.read_excel('data/catalogue/NichtBE-Eugeniana SW6xx-ME.xlsx')\n",
    "df_4 = pd.read_excel('data/catalogue/BE ANA ohne Item.xlsx')\n",
    "df_5 = pd.read_excel('data/catalogue/Signatur BE2 ME SW etc + ALMA.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "id": "c1a776c7-6b78-4a2e-aa28-eda36f9d35d1",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n",
      "22412\n",
      "Index([ 'Permanent Call Number',                      992,\n",
      "                            993,                      695,\n",
      "                            866,  'Library Code (Active)',\n",
      "                'Location Code',                'Barcode',\n",
      "             'Item Call Number',                  'Title',\n",
      "                       'Author',   'Author (contributor)',\n",
      "       'Begin Publication Date',   'End Publication Date',\n",
      "             'Publication Date',      'Publication Place',\n",
      "                    'Publisher',            'Unnamed: 17',\n",
      "                       'MMS Id',                      856,\n",
      "                     'Subjects',       'Subjects (Names)'],\n",
      "      dtype='object')\n",
      "2\n",
      "31\n",
      "Index([ 'Permanent Call Number',                      992,\n",
      "                            993,                      695,\n",
      "                            866,  'Library Code (Active)',\n",
      "                'Location Code',                'Barcode',\n",
      "             'Item Call Number',                 'Author',\n",
      "         'Author (contributor)', 'Begin Publication Date',\n",
      "                       'MMS Id',       'Publication Date',\n",
      "            'Publication Place',              'Publisher',\n",
      "                        'Title',   'End Publication Date',\n",
      "                            856,               'Subjects',\n",
      "             'Subjects (Names)'],\n",
      "      dtype='object')\n",
      "3\n",
      "31\n",
      "Index(['001', 600, 610, 611, 630, 648, 650, 651, 653, 655, 689], dtype='object')\n",
      "4\n",
      "22496\n",
      "Index([ 'Permanent Call Number',                '992 HOL',\n",
      "                      '993 HOL',                '695 HOL',\n",
      "                      '866 HOL',  'Library Code (Active)',\n",
      "                'Location Code',                 'Author',\n",
      "         'Author (contributor)',                  'Title',\n",
      "       'Begin Publication Date',   'End Publication Date',\n",
      "             'Publication Date',      'Publication Place',\n",
      "                    'Publisher',                      856,\n",
      "                     'Subjects',       'Subjects (Names)',\n",
      "                  'Unnamed: 18',                 'MMS Id'],\n",
      "      dtype='object')\n",
      "5\n",
      "20706\n",
      "Index([                     '001',                        600,\n",
      "                              610,                        611,\n",
      "                              630,                        648,\n",
      "                              650,                        651,\n",
      "                              653,                      '655',\n",
      "                            '689',                    '130$a',\n",
      "                          '245$a',                    '245$c',\n",
      "                          '500$a',                    '751$a',\n",
      "                          '982$z', 'Type / Creator / Imprint',\n",
      "                    'Unnamed: 18',                  'Subject',\n",
      "                          'Title',                   'Series',\n",
      "                   'Availability',        'Modification Date',\n",
      "                        'Edition',            'Record number',\n",
      "                       'Language',                   'MMS ID'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "for i in range(1, 6):\n",
    "    print(i)\n",
    "    print(len(eval(f'df_{i}')))\n",
    "    print(eval(f'df_{i}').columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 379,
   "id": "2376519e-bac0-44c0-9365-542845f3a6bc",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 740,
   "id": "0a39cd9f-8687-4f82-84b0-836fe40ac366",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "merge_23 = df_2.merge(df_3, how='outer', left_on='MMS Id', right_on='001')\n",
    "merge_23['Begin Publication Date'] = merge_23['Begin Publication Date'].astype(object)\n",
    "merge_23['End Publication Date'] = merge_23['End Publication Date'].astype(object)\n",
    "merge_23['Publication Date'] = merge_23['Publication Date'].astype(object)\n",
    "\n",
    "merge_123 = df_1.merge(merge_23, how='outer', on=['Begin Publication Date', 'End Publication Date', 'Publication Date', 'Barcode', 'Permanent Call Number', 992, 695, 'Library Code (Active)', 'Location Code', 'Title', 'Author', 'Author (contributor)', 'Publication Place', 'Publisher', 'MMS Id', 856, 'Subjects'])\n",
    "merge_45 = df_4.merge(df_5, how='outer', left_on='MMS Id', right_on='MMS ID')\n",
    "merge_45['Title'] = merge_45.apply(lambda x: combine_entries(x['Title_x'], x['Title_y']), axis=1)\n",
    "merge_12345 = merge_45.merge(merge_123, how='outer', on=['Begin Publication Date', 'End Publication Date', 'Publication Date', 'Permanent Call Number', 'Library Code (Active)', 'Location Code', 'Title', 'Author', 'Author (contributor)', 'Publication Place', 'Publisher', 'MMS Id', 856, 'Subjects'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 745,
   "id": "018d5635-7b0a-496f-97a7-44e04afe4c39",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([   'Permanent Call Number',                  '992 HOL',\n",
       "                        '993 HOL',                  '695 HOL',\n",
       "                        '866 HOL',    'Library Code (Active)',\n",
       "                  'Location Code',                   'Author',\n",
       "           'Author (contributor)',                  'Title_x',\n",
       "         'Begin Publication Date',     'End Publication Date',\n",
       "               'Publication Date',        'Publication Place',\n",
       "                      'Publisher',                        856,\n",
       "                       'Subjects',         'Subjects (Names)',\n",
       "                         'MMS Id',                    '001_x',\n",
       "                          '600_x',                    '610_x',\n",
       "                          '650_x',                    '653_x',\n",
       "                            '655',                      '689',\n",
       "                          '130$a',                    '245$a',\n",
       "                          '245$c',                    '500$a',\n",
       "                          '751$a',                    '982$z',\n",
       "       'Type / Creator / Imprint',            'Unnamed: 18_y',\n",
       "                        'Subject',                  'Title_y',\n",
       "                         'Series',             'Availability',\n",
       "              'Modification Date',                  'Edition',\n",
       "                  'Record number',                 'Language',\n",
       "                         'MMS ID',                    'Title',\n",
       "                              992,                    '993_x',\n",
       "                              695,                    '866_x',\n",
       "                        'Barcode',       'Item Call Number_x',\n",
       "             'Subjects (Names)_x',                    '001_y',\n",
       "                              655,                        689],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 745,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merge_12345_dropna = merge_12345.dropna(axis=1, how='all', ignore_index=True)\n",
    "merge_12345_dropna.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 746,
   "id": "d8b8ed91-fb6b-4eb8-87f3-2bb45f32c144",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['001_x',\n",
       " '001_y',\n",
       " '130$a',\n",
       " '245$a',\n",
       " '245$c',\n",
       " '500$a',\n",
       " '600_x',\n",
       " '610_x',\n",
       " '650_x',\n",
       " '653_x',\n",
       " '655',\n",
       " '655',\n",
       " '689',\n",
       " '689',\n",
       " '695',\n",
       " '695 HOL',\n",
       " '751$a',\n",
       " '856',\n",
       " '866 HOL',\n",
       " '866_x',\n",
       " '982$z',\n",
       " '992',\n",
       " '992 HOL',\n",
       " '993 HOL',\n",
       " '993_x',\n",
       " 'Author',\n",
       " 'Author (contributor)',\n",
       " 'Availability',\n",
       " 'Barcode',\n",
       " 'Begin Publication Date',\n",
       " 'Edition',\n",
       " 'End Publication Date',\n",
       " 'Item Call Number_x',\n",
       " 'Language',\n",
       " 'Library Code (Active)',\n",
       " 'Location Code',\n",
       " 'MMS ID',\n",
       " 'MMS Id',\n",
       " 'Modification Date',\n",
       " 'Permanent Call Number',\n",
       " 'Publication Date',\n",
       " 'Publication Place',\n",
       " 'Publisher',\n",
       " 'Record number',\n",
       " 'Series',\n",
       " 'Subject',\n",
       " 'Subjects',\n",
       " 'Subjects (Names)',\n",
       " 'Subjects (Names)_x',\n",
       " 'Title',\n",
       " 'Title_x',\n",
       " 'Title_y',\n",
       " 'Type / Creator / Imprint',\n",
       " 'Unnamed: 18_y']"
      ]
     },
     "execution_count": 746,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sorted([   'Permanent Call Number',                  '992 HOL',\n",
    "                        '993 HOL',                  '695 HOL',\n",
    "                        '866 HOL',    'Library Code (Active)',\n",
    "                  'Location Code',                   'Author',\n",
    "           'Author (contributor)',                  'Title_x',\n",
    "         'Begin Publication Date',     'End Publication Date',\n",
    "               'Publication Date',        'Publication Place',\n",
    "                      'Publisher',                        '856',\n",
    "                       'Subjects',         'Subjects (Names)',\n",
    "                         'MMS Id',                    '001_x',\n",
    "                          '600_x',                    '610_x',\n",
    "                          '650_x',                    '653_x',\n",
    "                            '655',                      '689',\n",
    "                          '130$a',                    '245$a',\n",
    "                          '245$c',                    '500$a',\n",
    "                          '751$a',                    '982$z',\n",
    "       'Type / Creator / Imprint',            'Unnamed: 18_y',\n",
    "                        'Subject',                  'Title_y',\n",
    "                         'Series',             'Availability',\n",
    "              'Modification Date',                  'Edition',\n",
    "                  'Record number',                 'Language',\n",
    "                         'MMS ID',                    'Title',\n",
    "                              '992',                    '993_x',\n",
    "                              '695',                    '866_x',\n",
    "                        'Barcode',       'Item Call Number_x',\n",
    "             'Subjects (Names)_x',                    '001_y',\n",
    "                              '655',                        '689'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 963,
   "id": "4868e5a1-cdb3-4b3c-9d1d-248cadbcb4a0",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "def combine_ids(lis):\n",
    "    int_lis = []\n",
    "    for e in lis:\n",
    "        if not np.isnan(e):\n",
    "            int_lis.append(int(e))\n",
    "    return list(set(int_lis))[0]\n",
    "\n",
    "def combine_entries(a, b):\n",
    "    if a == b:\n",
    "        return a\n",
    "    else:\n",
    "        if isinstance(a, str) and isinstance(b, str):\n",
    "            return a + b\n",
    "        elif isinstance(a, str):\n",
    "            return a\n",
    "        else:\n",
    "            return b\n",
    "\n",
    "def get_signature(a, b):\n",
    "    if isinstance(a, str):\n",
    "        return a\n",
    "    else:\n",
    "        match = re.search('BE.*;|\\d{6}.*;', b)\n",
    "        if match:\n",
    "            return match.group(0)\n",
    "        else:\n",
    "            return a\n",
    "\n",
    "merge_IDs = merge_12345_dropna.apply(lambda x: combine_ids([x['001_x'], x['001_y'], x['MMS Id'], x['MMS ID']]), axis=1)\n",
    "merge_655 = merge_12345_dropna.apply(lambda x: combine_entries(x[655], x['655']), axis=1)\n",
    "merge_689 = merge_12345_dropna.apply(lambda x: combine_entries(x[689], x['689']), axis=1)\n",
    "merge_695 = merge_12345_dropna.apply(lambda x: combine_entries(x[695], x['695 HOL']), axis=1)\n",
    "merge_866 = merge_12345_dropna.apply(lambda x: combine_entries(x['866 HOL'], x['866_x']), axis=1)\n",
    "merge_992 = merge_12345_dropna.apply(lambda x: combine_entries(x[992], x['992 HOL']), axis=1)\n",
    "merge_993 = merge_12345_dropna.apply(lambda x: combine_entries(x['993_x'], x['993 HOL']), axis=1)\n",
    "merge_992_993 = pd.concat([merge_992, merge_993], axis=1)\n",
    "merge_992_993['Bemerkungen'] = merge_992_993.apply(lambda x: combine_entries(x[0], x[1]), axis=1)\n",
    "merge_subject_names = merge_12345_dropna.apply(lambda x: combine_entries(x['Subjects (Names)'], x['Subjects (Names)_x']), axis=1)\n",
    "merge_begin_date = merge_12345_dropna['Begin Publication Date'][(merge_12345_dropna['Begin Publication Date'] != '####') & (merge_12345_dropna['Begin Publication Date'] != '9999')]\n",
    "merge_end_date = merge_12345_dropna['End Publication Date'][(merge_12345_dropna['End Publication Date'] != '####') & (merge_12345_dropna['End Publication Date'] != '9999')]\n",
    "merge_date = merge_12345_dropna['Publication Date'][(merge_12345_dropna['Publication Date'] != '####') & (merge_12345_dropna['Publication Date'] != '9999')]\n",
    "merge_signatur = merge_12345_dropna.apply(lambda x: get_signature(x['Permanent Call Number'], x['Availability']), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 999,
   "id": "c5813ff3-1734-4273-b49b-3f5d4bc6964f",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "c_df = pd.concat([merge_signatur,\n",
    "                  merge_12345_dropna['Barcode'],\n",
    "                  merge_12345_dropna['Title'], \n",
    "                  merge_12345_dropna['Author'], \n",
    "                  merge_12345_dropna['Author (contributor)'], \n",
    "                  merge_begin_date, \n",
    "                  merge_end_date, \n",
    "                  merge_date, \n",
    "                  merge_12345_dropna['Publication Place'], \n",
    "                  merge_12345_dropna['751$a'],\n",
    "                  merge_12345_dropna['Subjects'],\n",
    "                  merge_689,\n",
    "                  merge_695,\n",
    "                  merge_655,\n",
    "                  merge_992_993['Bemerkungen'],\n",
    "                 ], axis=1)\n",
    "c_df.rename(columns={0: 'Signatur', 'Title': 'Titel', 'Author': 'Autor', 'Author (contributor)': 'Mitwirkender', 'Begin Publication Date': 'Anfang Veröffentlichungsdatum', 'End Publication Date': 'Ende Veröffentlichungsdatum', 'Publication Date': 'Veröffentlichungsdatum', 'Publication Place': 'Veröffentlichungsort', '751$a': 'Veröffentlichungsort (normiert)', 'Subjects': 'Schlagwörter', 1: 'Schlagwörter (mit GND)', 2: 'Vorbesitzer', 3: 'Typ'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1000,
   "id": "43bf5dc7-b9e0-40e9-9e27-244ed09e508f",
   "metadata": {
    "tags": []
   },
   "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>Signatur</th>\n",
       "      <th>Barcode</th>\n",
       "      <th>Titel</th>\n",
       "      <th>Autor</th>\n",
       "      <th>Mitwirkender</th>\n",
       "      <th>Anfang Veröffentlichungsdatum</th>\n",
       "      <th>Ende Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsort</th>\n",
       "      <th>Veröffentlichungsort (normiert)</th>\n",
       "      <th>Schlagwörter</th>\n",
       "      <th>Schlagwörter (mit GND)</th>\n",
       "      <th>Vorbesitzer</th>\n",
       "      <th>Typ</th>\n",
       "      <th>Bemerkungen</th>\n",
       "      <th>valid_bc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BE.1.A.1</td>\n",
       "      <td>3537581-20</td>\n",
       "      <td>Flora Napolitana, ossia descrizione delle pian...</td>\n",
       "      <td>Tenore, Michele</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1811</td>\n",
       "      <td>1836</td>\n",
       "      <td>1811-36</td>\n",
       "      <td>Napoli</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Neapel; Pflanzen</td>\n",
       "      <td>Neapel$Dg--(DE-588)4041476-0;Pflanzen$Ds--(DE-...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BE.1.C.10</td>\n",
       "      <td>B1711164</td>\n",
       "      <td>Flora Napolitana, ossia descrizione delle pian...</td>\n",
       "      <td>Tenore, Michele</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1811</td>\n",
       "      <td>1836</td>\n",
       "      <td>1811-36</td>\n",
       "      <td>Napoli</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Neapel; Pflanzen</td>\n",
       "      <td>Neapel$Dg--(DE-588)4041476-0;Pflanzen$Ds--(DE-...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BE.1.A.10</td>\n",
       "      <td>B1214205</td>\n",
       "      <td>Antiquites du Bosphore Cimmerien conservees au...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gosudarstvennyj Ėrmitaž</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>St. Petersburg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sankt Petersburg; Museum; Eremitage; Straße vo...</td>\n",
       "      <td>Antiquität$Ds--(DE-588)4002325-4;Straße von Ke...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BE.1.A.11</td>\n",
       "      <td>B1475984</td>\n",
       "      <td>Musee des antiques dessine et grave par P. Bou...</td>\n",
       "      <td>Bouillon, Pierre</td>\n",
       "      <td>Saint-Victor, Jacques Maximilien Renjamin Bins de</td>\n",
       "      <td>1811</td>\n",
       "      <td>1827</td>\n",
       "      <td>1811-1827</td>\n",
       "      <td>Paris</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Altertümer</td>\n",
       "      <td>Altertümer$Ds--(DE-588)4201096-2;AT-OBV--ONB-AK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BE.1.A.12</td>\n",
       "      <td>B1771764</td>\n",
       "      <td>Divers works of early masters in christian dec...</td>\n",
       "      <td>Weale, John</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1846</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1846</td>\n",
       "      <td>London</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dekoration; Christentum</td>\n",
       "      <td>Dekoration$Ds--(DE-588)4149033-2;Christentum$D...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22638</th>\n",
       "      <td>Ink 7.E.1</td>\n",
       "      <td>1566517-10</td>\n",
       "      <td>Biblia Mit Postilla litteralis von Nicolaus de...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Koberger, Anton</td>\n",
       "      <td>1485</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7. Mai 1485; [1485.05.07]</td>\n",
       "      <td>Nürnberg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Inkunabel</td>\n",
       "      <td>Inkunabel$Af</td>\n",
       "      <td>$$a Savoyen-Carignan, Eugen &lt;von&gt;; $$b [Vorbes...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$$c Rote Rubriken und Lombarden (Punktverdicku...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22639</th>\n",
       "      <td>Ink 8.E.26</td>\n",
       "      <td>+Z158726101</td>\n",
       "      <td>La nef des fols du monde Aus dem Lat. des Jako...</td>\n",
       "      <td>Brant, Sebastian 1458-1521</td>\n",
       "      <td>Jean Lambert; Rivière, Pierre -1499</td>\n",
       "      <td>1497</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[nicht vor Dez.] 1497</td>\n",
       "      <td>Paris</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Inkunabel</td>\n",
       "      <td>Inkunabel$Af</td>\n",
       "      <td>$$a Savoyen-Carignan, Eugen &lt;von&gt;; $$b [Vorbes...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$$d Barock-Einband für Eugen von Savoyen: rote...</td>\n",
       "      <td>Z158726101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22640</th>\n",
       "      <td>Ink 9.D.5</td>\n",
       "      <td>+Z35095803</td>\n",
       "      <td>Thesaurus Cornu copiae et Horti Adonidis &lt;grie...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manuzio, Aldo Pio; Bolzanio, Urbano 1443-1524;...</td>\n",
       "      <td>1496</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aug. 1496; [1496.08]</td>\n",
       "      <td>Venedig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Inkunabel</td>\n",
       "      <td>Inkunabel$Af</td>\n",
       "      <td>$$a Savoyen-Carignan, Eugen &lt;von&gt;; $$b [Vorbes...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$$f Ink 9.D.5; $$m Vereinzelt griechische Marg...</td>\n",
       "      <td>Z35095803</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22641</th>\n",
       "      <td>Ink 9.F.22</td>\n",
       "      <td>+Z96101306</td>\n",
       "      <td>Comoediae ; Francesco Petrarca: Vita Terentii</td>\n",
       "      <td>Terentius Afer, Publius v195-v159</td>\n",
       "      <td>Zarotto, Antonio</td>\n",
       "      <td>1476</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23. Feb. 1476; [1476.02.23]</td>\n",
       "      <td>Mailand</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Inkunabel</td>\n",
       "      <td>Inkunabel$Af</td>\n",
       "      <td>$$a Wappen; $$b [Vorbesitzer, 15./16. Jh?]; $$...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$$c Wappenschild (Bl.3a, a1a) mit Wasserfarben...</td>\n",
       "      <td>Z96101306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22642</th>\n",
       "      <td>Ink 9.F.5</td>\n",
       "      <td>1460328-10</td>\n",
       "      <td>Biblia ; Interpretationes Hebraicorum nominum</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wild, Leonhard</td>\n",
       "      <td>1481</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1481</td>\n",
       "      <td>Venedig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Inkunabel</td>\n",
       "      <td>Inkunabel$Af</td>\n",
       "      <td>$$a Savoyen-Carignan, Eugen &lt;von&gt;; $$b [Vorbes...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$$c Rote und blaue Lombarden (verwischt), rote...</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22643 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Signatur      Barcode   \n",
       "0        BE.1.A.1   3537581-20  \\\n",
       "1       BE.1.C.10     B1711164   \n",
       "2       BE.1.A.10     B1214205   \n",
       "3       BE.1.A.11     B1475984   \n",
       "4       BE.1.A.12     B1771764   \n",
       "...           ...          ...   \n",
       "22638   Ink 7.E.1   1566517-10   \n",
       "22639  Ink 8.E.26  +Z158726101   \n",
       "22640   Ink 9.D.5   +Z35095803   \n",
       "22641  Ink 9.F.22   +Z96101306   \n",
       "22642   Ink 9.F.5   1460328-10   \n",
       "\n",
       "                                                   Titel   \n",
       "0      Flora Napolitana, ossia descrizione delle pian...  \\\n",
       "1      Flora Napolitana, ossia descrizione delle pian...   \n",
       "2      Antiquites du Bosphore Cimmerien conservees au...   \n",
       "3      Musee des antiques dessine et grave par P. Bou...   \n",
       "4      Divers works of early masters in christian dec...   \n",
       "...                                                  ...   \n",
       "22638  Biblia Mit Postilla litteralis von Nicolaus de...   \n",
       "22639  La nef des fols du monde Aus dem Lat. des Jako...   \n",
       "22640  Thesaurus Cornu copiae et Horti Adonidis <grie...   \n",
       "22641      Comoediae ; Francesco Petrarca: Vita Terentii   \n",
       "22642      Biblia ; Interpretationes Hebraicorum nominum   \n",
       "\n",
       "                                   Autor   \n",
       "0                        Tenore, Michele  \\\n",
       "1                        Tenore, Michele   \n",
       "2                                    NaN   \n",
       "3                       Bouillon, Pierre   \n",
       "4                            Weale, John   \n",
       "...                                  ...   \n",
       "22638                                NaN   \n",
       "22639         Brant, Sebastian 1458-1521   \n",
       "22640                                NaN   \n",
       "22641  Terentius Afer, Publius v195-v159   \n",
       "22642                                NaN   \n",
       "\n",
       "                                            Mitwirkender   \n",
       "0                                                    NaN  \\\n",
       "1                                                    NaN   \n",
       "2                                Gosudarstvennyj Ėrmitaž   \n",
       "3      Saint-Victor, Jacques Maximilien Renjamin Bins de   \n",
       "4                                                    NaN   \n",
       "...                                                  ...   \n",
       "22638                                    Koberger, Anton   \n",
       "22639                Jean Lambert; Rivière, Pierre -1499   \n",
       "22640  Manuzio, Aldo Pio; Bolzanio, Urbano 1443-1524;...   \n",
       "22641                                   Zarotto, Antonio   \n",
       "22642                                     Wild, Leonhard   \n",
       "\n",
       "      Anfang Veröffentlichungsdatum Ende Veröffentlichungsdatum   \n",
       "0                              1811                        1836  \\\n",
       "1                              1811                        1836   \n",
       "2                               NaN                         NaN   \n",
       "3                              1811                        1827   \n",
       "4                              1846                         NaN   \n",
       "...                             ...                         ...   \n",
       "22638                          1485                         NaN   \n",
       "22639                          1497                         NaN   \n",
       "22640                          1496                         NaN   \n",
       "22641                          1476                         NaN   \n",
       "22642                          1481                         NaN   \n",
       "\n",
       "            Veröffentlichungsdatum Veröffentlichungsort   \n",
       "0                          1811-36               Napoli  \\\n",
       "1                          1811-36               Napoli   \n",
       "2                              NaN       St. Petersburg   \n",
       "3                        1811-1827                Paris   \n",
       "4                             1846               London   \n",
       "...                            ...                  ...   \n",
       "22638    7. Mai 1485; [1485.05.07]             Nürnberg   \n",
       "22639        [nicht vor Dez.] 1497                Paris   \n",
       "22640         Aug. 1496; [1496.08]              Venedig   \n",
       "22641  23. Feb. 1476; [1476.02.23]              Mailand   \n",
       "22642                         1481              Venedig   \n",
       "\n",
       "      Veröffentlichungsort (normiert)   \n",
       "0                                 NaN  \\\n",
       "1                                 NaN   \n",
       "2                                 NaN   \n",
       "3                                 NaN   \n",
       "4                                 NaN   \n",
       "...                               ...   \n",
       "22638                             NaN   \n",
       "22639                             NaN   \n",
       "22640                             NaN   \n",
       "22641                             NaN   \n",
       "22642                             NaN   \n",
       "\n",
       "                                            Schlagwörter   \n",
       "0                                       Neapel; Pflanzen  \\\n",
       "1                                       Neapel; Pflanzen   \n",
       "2      Sankt Petersburg; Museum; Eremitage; Straße vo...   \n",
       "3                                             Altertümer   \n",
       "4                                Dekoration; Christentum   \n",
       "...                                                  ...   \n",
       "22638                                          Inkunabel   \n",
       "22639                                          Inkunabel   \n",
       "22640                                          Inkunabel   \n",
       "22641                                          Inkunabel   \n",
       "22642                                          Inkunabel   \n",
       "\n",
       "                                  Schlagwörter (mit GND)   \n",
       "0      Neapel$Dg--(DE-588)4041476-0;Pflanzen$Ds--(DE-...  \\\n",
       "1      Neapel$Dg--(DE-588)4041476-0;Pflanzen$Ds--(DE-...   \n",
       "2      Antiquität$Ds--(DE-588)4002325-4;Straße von Ke...   \n",
       "3        Altertümer$Ds--(DE-588)4201096-2;AT-OBV--ONB-AK   \n",
       "4      Dekoration$Ds--(DE-588)4149033-2;Christentum$D...   \n",
       "...                                                  ...   \n",
       "22638                                       Inkunabel$Af   \n",
       "22639                                       Inkunabel$Af   \n",
       "22640                                       Inkunabel$Af   \n",
       "22641                                       Inkunabel$Af   \n",
       "22642                                       Inkunabel$Af   \n",
       "\n",
       "                                             Vorbesitzer  Typ   \n",
       "0                                                    NaN  NaN  \\\n",
       "1                                                    NaN  NaN   \n",
       "2                                                    NaN  NaN   \n",
       "3                                                    NaN  NaN   \n",
       "4                                                    NaN  NaN   \n",
       "...                                                  ...  ...   \n",
       "22638  $$a Savoyen-Carignan, Eugen <von>; $$b [Vorbes...  NaN   \n",
       "22639  $$a Savoyen-Carignan, Eugen <von>; $$b [Vorbes...  NaN   \n",
       "22640  $$a Savoyen-Carignan, Eugen <von>; $$b [Vorbes...  NaN   \n",
       "22641  $$a Wappen; $$b [Vorbesitzer, 15./16. Jh?]; $$...  NaN   \n",
       "22642  $$a Savoyen-Carignan, Eugen <von>; $$b [Vorbes...  NaN   \n",
       "\n",
       "                                             Bemerkungen    valid_bc  \n",
       "0                                                    NaN        None  \n",
       "1                                                    NaN        None  \n",
       "2                                                    NaN        None  \n",
       "3                                                    NaN        None  \n",
       "4                                                    NaN        None  \n",
       "...                                                  ...         ...  \n",
       "22638  $$c Rote Rubriken und Lombarden (Punktverdicku...        None  \n",
       "22639  $$d Barock-Einband für Eugen von Savoyen: rote...  Z158726101  \n",
       "22640  $$f Ink 9.D.5; $$m Vereinzelt griechische Marg...   Z35095803  \n",
       "22641  $$c Wappenschild (Bl.3a, a1a) mit Wasserfarben...   Z96101306  \n",
       "22642  $$c Rote und blaue Lombarden (verwischt), rote...        None  \n",
       "\n",
       "[22643 rows x 16 columns]"
      ]
     },
     "execution_count": 1000,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c_df['valid_bc'] = c_df['Barcode'].apply(lambda x: extract_valid_bc(x))\n",
    "c_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 988,
   "id": "ea675efe-3005-4052-9290-ec4b3262b7bb",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "final = pd.read_csv('data/predictions/final_predictions.csv')\n",
    "final['valid_bc'] = final['filename'].apply(lambda x: extract_valid_bc(x))\n",
    "final_color_preds = final.drop_duplicates(subset='valid_bc')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1004,
   "id": "8d681b59-7f88-4747-9923-11223e79305d",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "merged_col_pred = c_df.merge(final_color_preds, how='left', on='valid_bc')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 209,
   "id": "3ad5557e-e3c9-4505-8589-79f2b1118aa6",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "pred = pd.read_csv('data/predictions/combined_predictions.csv')\n",
    "pred = pred.drop('Unnamed: 0', axis=1)\n",
    "pred['valid_bc'] = pred['filename'].apply(lambda x: extract_valid_bc(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1057,
   "id": "f9536ee4-4f27-4047-b4dc-cdac170b8400",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "pred_drop = pred.drop_duplicates(subset=['prediction', 'valid_bc'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1065,
   "id": "6906dc88-62e9-4adb-9ca1-e22c4de78c13",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "20574"
      ]
     },
     "execution_count": 1065,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pred_drop.drop_duplicates('valid_bc')['valid_bc'].isin(c_df['valid_bc']).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1080,
   "id": "ce8c0d9b-3b6e-4766-9e25-403ee3bb3aed",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "supralibros_bc = pred[pred['prediction'] != 'N']['valid_bc']\n",
    "neg_preds = pred[~pred['valid_bc'].isin(supralibros_bc)].drop_duplicates('valid_bc')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1095,
   "id": "109706d0-4a93-4df4-8682-be91044c2446",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "all_predictions = pd.concat([final_color_preds, neg_preds]).drop(['years', 'man_prediction', 'man_color'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1101,
   "id": "5a608b2a-de63-4eb5-b2d3-48eaeccfb9a6",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "cat_pred_comb = c_df.merge(all_predictions, how='left', on='valid_bc')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1108,
   "id": "b9ff69db-bea1-47c8-92ac-8f11176d4fca",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Signatur', 'Barcode', 'Titel', 'Autor', 'Mitwirkender',\n",
       "       'Anfang Veröffentlichungsdatum', 'Ende Veröffentlichungsdatum',\n",
       "       'Veröffentlichungsdatum', 'Veröffentlichungsort',\n",
       "       'Veröffentlichungsort (normiert)', 'Schlagwörter',\n",
       "       'Schlagwörter (mit GND)', 'Vorbesitzer', 'Typ', 'Bemerkungen',\n",
       "       'valid_bc', 'filename', 'prediction', 'p_A', 'p_B', 'p_C', 'p_N',\n",
       "       'color', 'p_blue', 'p_red', 'p_yellow'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 1108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_pred_comb.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1111,
   "id": "fdde2770-b2cb-402f-aa55-572239be15f0",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "cat_pred_comb.rename(columns={'valid_bc': 'Gültiger Barcode', 'filename': 'Dateiname', 'prediction': 'Wappenklassifizierung', 'color': 'Farbklassifizierung'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1183,
   "id": "3e2838ff-c5d9-49dc-817c-cc1ec9393f61",
   "metadata": {
    "tags": []
   },
   "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>Signatur</th>\n",
       "      <th>Barcode</th>\n",
       "      <th>Titel</th>\n",
       "      <th>Autor</th>\n",
       "      <th>Mitwirkender</th>\n",
       "      <th>Anfang Veröffentlichungsdatum</th>\n",
       "      <th>Ende Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsort</th>\n",
       "      <th>Veröffentlichungsort (normiert)</th>\n",
       "      <th>...</th>\n",
       "      <th>Dateiname</th>\n",
       "      <th>Wappenklassifizierung</th>\n",
       "      <th>p_A</th>\n",
       "      <th>p_B</th>\n",
       "      <th>p_C</th>\n",
       "      <th>p_N</th>\n",
       "      <th>Farbklassifizierung</th>\n",
       "      <th>p_blue</th>\n",
       "      <th>p_red</th>\n",
       "      <th>p_yellow</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BE.1.A.1</td>\n",
       "      <td>3537581-20</td>\n",
       "      <td>Flora Napolitana, ossia descrizione delle pian...</td>\n",
       "      <td>Tenore, Michele</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1811</td>\n",
       "      <td>1836</td>\n",
       "      <td>1811-36</td>\n",
       "      <td>Napoli</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BE.1.C.10</td>\n",
       "      <td>B1711164</td>\n",
       "      <td>Flora Napolitana, ossia descrizione delle pian...</td>\n",
       "      <td>Tenore, Michele</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1811</td>\n",
       "      <td>1836</td>\n",
       "      <td>1811-36</td>\n",
       "      <td>Napoli</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BE.1.A.10</td>\n",
       "      <td>B1214205</td>\n",
       "      <td>Antiquites du Bosphore Cimmerien conservees au...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gosudarstvennyj Ėrmitaž</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>St. Petersburg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BE.1.A.11</td>\n",
       "      <td>B1475984</td>\n",
       "      <td>Musee des antiques dessine et grave par P. Bou...</td>\n",
       "      <td>Bouillon, Pierre</td>\n",
       "      <td>Saint-Victor, Jacques Maximilien Renjamin Bins de</td>\n",
       "      <td>1811</td>\n",
       "      <td>1827</td>\n",
       "      <td>1811-1827</td>\n",
       "      <td>Paris</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BE.1.A.12</td>\n",
       "      <td>B1771764</td>\n",
       "      <td>Divers works of early masters in christian dec...</td>\n",
       "      <td>Weale, John</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1846</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1846</td>\n",
       "      <td>London</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22638</th>\n",
       "      <td>Ink 7.E.1</td>\n",
       "      <td>1566517-10</td>\n",
       "      <td>Biblia Mit Postilla litteralis von Nicolaus de...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Koberger, Anton</td>\n",
       "      <td>1485</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7. Mai 1485; [1485.05.07]</td>\n",
       "      <td>Nürnberg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22639</th>\n",
       "      <td>Ink 8.E.26</td>\n",
       "      <td>+Z158726101</td>\n",
       "      <td>La nef des fols du monde Aus dem Lat. des Jako...</td>\n",
       "      <td>Brant, Sebastian 1458-1521</td>\n",
       "      <td>Jean Lambert; Rivière, Pierre -1499</td>\n",
       "      <td>1497</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[nicht vor Dez.] 1497</td>\n",
       "      <td>Paris</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22640</th>\n",
       "      <td>Ink 9.D.5</td>\n",
       "      <td>+Z35095803</td>\n",
       "      <td>Thesaurus Cornu copiae et Horti Adonidis &lt;grie...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manuzio, Aldo Pio; Bolzanio, Urbano 1443-1524;...</td>\n",
       "      <td>1496</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aug. 1496; [1496.08]</td>\n",
       "      <td>Venedig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22641</th>\n",
       "      <td>Ink 9.F.22</td>\n",
       "      <td>+Z96101306</td>\n",
       "      <td>Comoediae ; Francesco Petrarca: Vita Terentii</td>\n",
       "      <td>Terentius Afer, Publius v195-v159</td>\n",
       "      <td>Zarotto, Antonio</td>\n",
       "      <td>1476</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23. Feb. 1476; [1476.02.23]</td>\n",
       "      <td>Mailand</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22642</th>\n",
       "      <td>Ink 9.F.5</td>\n",
       "      <td>1460328-10</td>\n",
       "      <td>Biblia ; Interpretationes Hebraicorum nominum</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wild, Leonhard</td>\n",
       "      <td>1481</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1481</td>\n",
       "      <td>Venedig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22643 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Signatur      Barcode   \n",
       "0        BE.1.A.1   3537581-20  \\\n",
       "1       BE.1.C.10     B1711164   \n",
       "2       BE.1.A.10     B1214205   \n",
       "3       BE.1.A.11     B1475984   \n",
       "4       BE.1.A.12     B1771764   \n",
       "...           ...          ...   \n",
       "22638   Ink 7.E.1   1566517-10   \n",
       "22639  Ink 8.E.26  +Z158726101   \n",
       "22640   Ink 9.D.5   +Z35095803   \n",
       "22641  Ink 9.F.22   +Z96101306   \n",
       "22642   Ink 9.F.5   1460328-10   \n",
       "\n",
       "                                                   Titel   \n",
       "0      Flora Napolitana, ossia descrizione delle pian...  \\\n",
       "1      Flora Napolitana, ossia descrizione delle pian...   \n",
       "2      Antiquites du Bosphore Cimmerien conservees au...   \n",
       "3      Musee des antiques dessine et grave par P. Bou...   \n",
       "4      Divers works of early masters in christian dec...   \n",
       "...                                                  ...   \n",
       "22638  Biblia Mit Postilla litteralis von Nicolaus de...   \n",
       "22639  La nef des fols du monde Aus dem Lat. des Jako...   \n",
       "22640  Thesaurus Cornu copiae et Horti Adonidis <grie...   \n",
       "22641      Comoediae ; Francesco Petrarca: Vita Terentii   \n",
       "22642      Biblia ; Interpretationes Hebraicorum nominum   \n",
       "\n",
       "                                   Autor   \n",
       "0                        Tenore, Michele  \\\n",
       "1                        Tenore, Michele   \n",
       "2                                    NaN   \n",
       "3                       Bouillon, Pierre   \n",
       "4                            Weale, John   \n",
       "...                                  ...   \n",
       "22638                                NaN   \n",
       "22639         Brant, Sebastian 1458-1521   \n",
       "22640                                NaN   \n",
       "22641  Terentius Afer, Publius v195-v159   \n",
       "22642                                NaN   \n",
       "\n",
       "                                            Mitwirkender   \n",
       "0                                                    NaN  \\\n",
       "1                                                    NaN   \n",
       "2                                Gosudarstvennyj Ėrmitaž   \n",
       "3      Saint-Victor, Jacques Maximilien Renjamin Bins de   \n",
       "4                                                    NaN   \n",
       "...                                                  ...   \n",
       "22638                                    Koberger, Anton   \n",
       "22639                Jean Lambert; Rivière, Pierre -1499   \n",
       "22640  Manuzio, Aldo Pio; Bolzanio, Urbano 1443-1524;...   \n",
       "22641                                   Zarotto, Antonio   \n",
       "22642                                     Wild, Leonhard   \n",
       "\n",
       "      Anfang Veröffentlichungsdatum Ende Veröffentlichungsdatum   \n",
       "0                              1811                        1836  \\\n",
       "1                              1811                        1836   \n",
       "2                               NaN                         NaN   \n",
       "3                              1811                        1827   \n",
       "4                              1846                         NaN   \n",
       "...                             ...                         ...   \n",
       "22638                          1485                         NaN   \n",
       "22639                          1497                         NaN   \n",
       "22640                          1496                         NaN   \n",
       "22641                          1476                         NaN   \n",
       "22642                          1481                         NaN   \n",
       "\n",
       "            Veröffentlichungsdatum Veröffentlichungsort   \n",
       "0                          1811-36               Napoli  \\\n",
       "1                          1811-36               Napoli   \n",
       "2                              NaN       St. Petersburg   \n",
       "3                        1811-1827                Paris   \n",
       "4                             1846               London   \n",
       "...                            ...                  ...   \n",
       "22638    7. Mai 1485; [1485.05.07]             Nürnberg   \n",
       "22639        [nicht vor Dez.] 1497                Paris   \n",
       "22640         Aug. 1496; [1496.08]              Venedig   \n",
       "22641  23. Feb. 1476; [1476.02.23]              Mailand   \n",
       "22642                         1481              Venedig   \n",
       "\n",
       "      Veröffentlichungsort (normiert)  ... Dateiname Wappenklassifizierung   \n",
       "0                                 NaN  ...       NaN                   NaN  \\\n",
       "1                                 NaN  ...       NaN                   NaN   \n",
       "2                                 NaN  ...       NaN                   NaN   \n",
       "3                                 NaN  ...       NaN                   NaN   \n",
       "4                                 NaN  ...       NaN                   NaN   \n",
       "...                               ...  ...       ...                   ...   \n",
       "22638                             NaN  ...       NaN                   NaN   \n",
       "22639                             NaN  ...       NaN                   NaN   \n",
       "22640                             NaN  ...       NaN                   NaN   \n",
       "22641                             NaN  ...       NaN                   NaN   \n",
       "22642                             NaN  ...       NaN                   NaN   \n",
       "\n",
       "      p_A p_B p_C p_N Farbklassifizierung p_blue  p_red  p_yellow  \n",
       "0     NaN NaN NaN NaN                 NaN    NaN    NaN       NaN  \n",
       "1     NaN NaN NaN NaN                 NaN    NaN    NaN       NaN  \n",
       "2     NaN NaN NaN NaN                 NaN    NaN    NaN       NaN  \n",
       "3     NaN NaN NaN NaN                 NaN    NaN    NaN       NaN  \n",
       "4     NaN NaN NaN NaN                 NaN    NaN    NaN       NaN  \n",
       "...    ..  ..  ..  ..                 ...    ...    ...       ...  \n",
       "22638 NaN NaN NaN NaN                 NaN    NaN    NaN       NaN  \n",
       "22639 NaN NaN NaN NaN                 NaN    NaN    NaN       NaN  \n",
       "22640 NaN NaN NaN NaN                 NaN    NaN    NaN       NaN  \n",
       "22641 NaN NaN NaN NaN                 NaN    NaN    NaN       NaN  \n",
       "22642 NaN NaN NaN NaN                 NaN    NaN    NaN       NaN  \n",
       "\n",
       "[22643 rows x 26 columns]"
      ]
     },
     "execution_count": 1183,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_pred_comb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1198,
   "id": "281e8244-edae-4104-bd7a-857d866857a4",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "cat_pred_comb.drop([658, 22284], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1224,
   "id": "d57c4ddd-9e8c-4c59-913e-df7d5c7c21ee",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        Italian\n",
       "1        Italian\n",
       "2        unknown\n",
       "3         French\n",
       "4        English\n",
       "          ...   \n",
       "22638        NaN\n",
       "22639        NaN\n",
       "22640        NaN\n",
       "22641        NaN\n",
       "22642        NaN\n",
       "Name: Sprache, Length: 22641, dtype: object"
      ]
     },
     "execution_count": 1224,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lang = pd.concat([merge_12345_dropna['Language'], merge_signatur], axis=1)\n",
    "lang.rename(columns={'Language': 'Sprache', 0: 'Signatur'}, inplace=True)\n",
    "lang.drop([658, 22284], inplace=True)\n",
    "cat_pred_comb.insert(10, 'Sprache', lang['Sprache'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1229,
   "id": "f91dfb09-7314-44ea-901a-30b8194e0723",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "cat_pred_comb.to_excel('data/combined/Katalogauszug und Vorhersagen.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "a8a67ec3-3b12-4361-93ce-c74beb555386",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "cat_pred_comb = pd.read_excel('../Daten/Vorhersagen/Katalogauszug und Vorhersagen.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "3e3ce606-5fa9-4aa3-ab88-3bd2c018660a",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Unnamed: 0\n",
      "Signatur\n",
      "Barcode\n",
      "Titel\n",
      "Autor\n",
      "Mitwirkender\n",
      "Anfang Veröffentlichungsdatum\n",
      "Ende Veröffentlichungsdatum\n",
      "Veröffentlichungsdatum\n",
      "Veröffentlichungsort\n",
      "Veröffentlichungsort (normiert)\n",
      "Sprache\n",
      "Schlagwörter\n",
      "Schlagwörter (mit GND)\n",
      "Vorbesitzer\n",
      "Typ\n",
      "Bemerkungen\n",
      "Gültiger Barcode\n",
      "Dateiname\n",
      "Wappenklassifizierung\n",
      "p_A\n",
      "p_B\n",
      "p_C\n",
      "p_N\n",
      "Farbklassifizierung\n",
      "p_blue\n",
      "p_red\n",
      "p_yellow\n"
     ]
    }
   ],
   "source": [
    "for e in list(cat_pred_comb.columns):\n",
    "    print(e)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1242,
   "id": "f6a6bc7b-5659-4ffd-9220-cd7331090060",
   "metadata": {
    "tags": []
   },
   "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>Signatur</th>\n",
       "      <th>Barcode</th>\n",
       "      <th>Titel</th>\n",
       "      <th>Autor</th>\n",
       "      <th>Mitwirkender</th>\n",
       "      <th>Anfang Veröffentlichungsdatum</th>\n",
       "      <th>Ende Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsort</th>\n",
       "      <th>Veröffentlichungsort (normiert)</th>\n",
       "      <th>...</th>\n",
       "      <th>Dateiname</th>\n",
       "      <th>Wappenklassifizierung</th>\n",
       "      <th>p_A</th>\n",
       "      <th>p_B</th>\n",
       "      <th>p_C</th>\n",
       "      <th>p_N</th>\n",
       "      <th>Farbklassifizierung</th>\n",
       "      <th>p_blue</th>\n",
       "      <th>p_red</th>\n",
       "      <th>p_yellow</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>659</th>\n",
       "      <td>BE.1.N.75*</td>\n",
       "      <td>+Z167910202</td>\n",
       "      <td>Postila to est, kratko istlmačenje vsih' nedel...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Christoph Württemberg, Herzog 1515-1568; Consu...</td>\n",
       "      <td>1562</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1562</td>\n",
       "      <td>V Tubingi [Urach]</td>\n",
       "      <td>Tübingen;Urach</td>\n",
       "      <td>...</td>\n",
       "      <td>Z167910202_00000001.jpg</td>\n",
       "      <td>N</td>\n",
       "      <td>0.000509</td>\n",
       "      <td>0.000098</td>\n",
       "      <td>0.000944</td>\n",
       "      <td>0.998449</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Signatur      Barcode   \n",
       "659  BE.1.N.75*  +Z167910202  \\\n",
       "\n",
       "                                                 Titel Autor   \n",
       "659  Postila to est, kratko istlmačenje vsih' nedel...   NaN  \\\n",
       "\n",
       "                                          Mitwirkender   \n",
       "659  Christoph Württemberg, Herzog 1515-1568; Consu...  \\\n",
       "\n",
       "    Anfang Veröffentlichungsdatum Ende Veröffentlichungsdatum   \n",
       "659                          1562                         NaN  \\\n",
       "\n",
       "    Veröffentlichungsdatum Veröffentlichungsort   \n",
       "659                   1562    V Tubingi [Urach]  \\\n",
       "\n",
       "    Veröffentlichungsort (normiert)  ...                Dateiname   \n",
       "659                  Tübingen;Urach  ...  Z167910202_00000001.jpg  \\\n",
       "\n",
       "    Wappenklassifizierung       p_A       p_B       p_C       p_N   \n",
       "659                     N  0.000509  0.000098  0.000944  0.998449  \\\n",
       "\n",
       "    Farbklassifizierung p_blue p_red  p_yellow  \n",
       "659                 NaN    NaN   NaN       NaN  \n",
       "\n",
       "[1 rows x 27 columns]"
      ]
     },
     "execution_count": 1242,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_pred_comb[cat_pred_comb['Gültiger Barcode'] == 'Z167910202']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1200,
   "id": "6423f5bb-d52a-4b49-b91e-1d085daf70fd",
   "metadata": {
    "tags": []
   },
   "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>Signatur</th>\n",
       "      <th>Barcode</th>\n",
       "      <th>Titel</th>\n",
       "      <th>Autor</th>\n",
       "      <th>Mitwirkender</th>\n",
       "      <th>Anfang Veröffentlichungsdatum</th>\n",
       "      <th>Ende Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsort</th>\n",
       "      <th>Veröffentlichungsort (normiert)</th>\n",
       "      <th>...</th>\n",
       "      <th>Dateiname</th>\n",
       "      <th>Wappenklassifizierung</th>\n",
       "      <th>p_A</th>\n",
       "      <th>p_B</th>\n",
       "      <th>p_C</th>\n",
       "      <th>p_N</th>\n",
       "      <th>Farbklassifizierung</th>\n",
       "      <th>p_blue</th>\n",
       "      <th>p_red</th>\n",
       "      <th>p_yellow</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>0 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Signatur, Barcode, Titel, Autor, Mitwirkender, Anfang Veröffentlichungsdatum, Ende Veröffentlichungsdatum, Veröffentlichungsdatum, Veröffentlichungsort, Veröffentlichungsort (normiert), Schlagwörter, Schlagwörter (mit GND), Vorbesitzer, Typ, Bemerkungen, Gültiger Barcode, Dateiname, Wappenklassifizierung, p_A, p_B, p_C, p_N, Farbklassifizierung, p_blue, p_red, p_yellow]\n",
       "Index: []\n",
       "\n",
       "[0 rows x 26 columns]"
      ]
     },
     "execution_count": 1200,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_pred_comb.dropna(subset='Dateiname')[cat_pred_comb.dropna(subset='Dateiname').duplicated('Dateiname', keep=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1244,
   "id": "c6428a9b-2b1f-4bc8-967f-4314fbd06bee",
   "metadata": {
    "tags": []
   },
   "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>Signatur</th>\n",
       "      <th>Barcode</th>\n",
       "      <th>Titel</th>\n",
       "      <th>Autor</th>\n",
       "      <th>Mitwirkender</th>\n",
       "      <th>Anfang Veröffentlichungsdatum</th>\n",
       "      <th>Ende Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsort</th>\n",
       "      <th>Veröffentlichungsort (normiert)</th>\n",
       "      <th>Sprache</th>\n",
       "      <th>Schlagwörter</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BE.1.A.1</td>\n",
       "      <td>3537581-20</td>\n",
       "      <td>Flora Napolitana, ossia descrizione delle pian...</td>\n",
       "      <td>Tenore, Michele</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1811</td>\n",
       "      <td>1836</td>\n",
       "      <td>1811-36</td>\n",
       "      <td>Napoli</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Italian</td>\n",
       "      <td>Neapel; Pflanzen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BE.1.C.10</td>\n",
       "      <td>B1711164</td>\n",
       "      <td>Flora Napolitana, ossia descrizione delle pian...</td>\n",
       "      <td>Tenore, Michele</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1811</td>\n",
       "      <td>1836</td>\n",
       "      <td>1811-36</td>\n",
       "      <td>Napoli</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Italian</td>\n",
       "      <td>Neapel; Pflanzen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BE.1.A.10</td>\n",
       "      <td>B1214205</td>\n",
       "      <td>Antiquites du Bosphore Cimmerien conservees au...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gosudarstvennyj Ėrmitaž</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>St. Petersburg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>unknown</td>\n",
       "      <td>Sankt Petersburg; Museum; Eremitage; Straße vo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BE.1.A.11</td>\n",
       "      <td>B1475984</td>\n",
       "      <td>Musee des antiques dessine et grave par P. Bou...</td>\n",
       "      <td>Bouillon, Pierre</td>\n",
       "      <td>Saint-Victor, Jacques Maximilien Renjamin Bins de</td>\n",
       "      <td>1811</td>\n",
       "      <td>1827</td>\n",
       "      <td>1811-1827</td>\n",
       "      <td>Paris</td>\n",
       "      <td>NaN</td>\n",
       "      <td>French</td>\n",
       "      <td>Altertümer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BE.1.A.12</td>\n",
       "      <td>B1771764</td>\n",
       "      <td>Divers works of early masters in christian dec...</td>\n",
       "      <td>Weale, John</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1846</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1846</td>\n",
       "      <td>London</td>\n",
       "      <td>NaN</td>\n",
       "      <td>English</td>\n",
       "      <td>Dekoration; Christentum</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BE.1.A.13</td>\n",
       "      <td>B986740</td>\n",
       "      <td>Colonna Traiana eretta dal senato, e popolo Ro...</td>\n",
       "      <td>Bartoli, Pietro Santo 1635-1700</td>\n",
       "      <td>Chacón, Alfonso 1540-1599</td>\n",
       "      <td>1751</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1751</td>\n",
       "      <td>Roma</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Italian</td>\n",
       "      <td>Trajanssäule--Rom; Trajan--Römisches Reich, Ka...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BE.1.A.14</td>\n",
       "      <td>B998501</td>\n",
       "      <td>Columna Cochlis M. Aurelio Antonio Augusto dicata</td>\n",
       "      <td>Bellori, Giovanni Pietro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1704</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1704</td>\n",
       "      <td>Roma</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Italian</td>\n",
       "      <td>Mark Aurel--Römisches Reich, Kaiser--121-180; ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BE.1.A.15</td>\n",
       "      <td>B1581441</td>\n",
       "      <td>A new collection of chimney pieces. Ornamented...</td>\n",
       "      <td>Richardson, George</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1781</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1781</td>\n",
       "      <td>London</td>\n",
       "      <td>NaN</td>\n",
       "      <td>English</td>\n",
       "      <td>Aquatinta; Schornstein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>BE.1.A.16</td>\n",
       "      <td>B1417347</td>\n",
       "      <td>Raccolta Di Statve Antiche E Moderne Data In L...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Maffei, Paolo Alessandro 1653-1716; Rossi, Dom...</td>\n",
       "      <td>1704</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1704</td>\n",
       "      <td>Roma</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Italian</td>\n",
       "      <td>Plastik</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BE.1.A.17</td>\n",
       "      <td>B992390</td>\n",
       "      <td>Le Grand Porte-Feuille Politique A l'usage des...</td>\n",
       "      <td>Beaufort, Louis &lt;&lt;de&gt;&gt; 1703-1795</td>\n",
       "      <td>Maradan, Claude François; Selbstverl.; Beaufor...</td>\n",
       "      <td>1789</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1789</td>\n",
       "      <td>A Paris</td>\n",
       "      <td>Paris</td>\n",
       "      <td>French</td>\n",
       "      <td>Französische Revolution; Bild</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Signatur     Barcode                                              Titel   \n",
       "0   BE.1.A.1  3537581-20  Flora Napolitana, ossia descrizione delle pian...  \\\n",
       "1  BE.1.C.10    B1711164  Flora Napolitana, ossia descrizione delle pian...   \n",
       "2  BE.1.A.10    B1214205  Antiquites du Bosphore Cimmerien conservees au...   \n",
       "3  BE.1.A.11    B1475984  Musee des antiques dessine et grave par P. Bou...   \n",
       "4  BE.1.A.12    B1771764  Divers works of early masters in christian dec...   \n",
       "5  BE.1.A.13     B986740  Colonna Traiana eretta dal senato, e popolo Ro...   \n",
       "6  BE.1.A.14     B998501  Columna Cochlis M. Aurelio Antonio Augusto dicata   \n",
       "7  BE.1.A.15    B1581441  A new collection of chimney pieces. Ornamented...   \n",
       "8  BE.1.A.16    B1417347  Raccolta Di Statve Antiche E Moderne Data In L...   \n",
       "9  BE.1.A.17     B992390  Le Grand Porte-Feuille Politique A l'usage des...   \n",
       "\n",
       "                              Autor   \n",
       "0                   Tenore, Michele  \\\n",
       "1                   Tenore, Michele   \n",
       "2                               NaN   \n",
       "3                  Bouillon, Pierre   \n",
       "4                       Weale, John   \n",
       "5   Bartoli, Pietro Santo 1635-1700   \n",
       "6          Bellori, Giovanni Pietro   \n",
       "7                Richardson, George   \n",
       "8                               NaN   \n",
       "9  Beaufort, Louis <<de>> 1703-1795   \n",
       "\n",
       "                                        Mitwirkender   \n",
       "0                                                NaN  \\\n",
       "1                                                NaN   \n",
       "2                            Gosudarstvennyj Ėrmitaž   \n",
       "3  Saint-Victor, Jacques Maximilien Renjamin Bins de   \n",
       "4                                                NaN   \n",
       "5                          Chacón, Alfonso 1540-1599   \n",
       "6                                                NaN   \n",
       "7                                                NaN   \n",
       "8  Maffei, Paolo Alessandro 1653-1716; Rossi, Dom...   \n",
       "9  Maradan, Claude François; Selbstverl.; Beaufor...   \n",
       "\n",
       "  Anfang Veröffentlichungsdatum Ende Veröffentlichungsdatum   \n",
       "0                          1811                        1836  \\\n",
       "1                          1811                        1836   \n",
       "2                           NaN                         NaN   \n",
       "3                          1811                        1827   \n",
       "4                          1846                         NaN   \n",
       "5                          1751                         NaN   \n",
       "6                          1704                         NaN   \n",
       "7                          1781                         NaN   \n",
       "8                          1704                         NaN   \n",
       "9                          1789                         NaN   \n",
       "\n",
       "  Veröffentlichungsdatum Veröffentlichungsort Veröffentlichungsort (normiert)   \n",
       "0                1811-36               Napoli                             NaN  \\\n",
       "1                1811-36               Napoli                             NaN   \n",
       "2                    NaN       St. Petersburg                             NaN   \n",
       "3              1811-1827                Paris                             NaN   \n",
       "4                   1846               London                             NaN   \n",
       "5                   1751                 Roma                             NaN   \n",
       "6                   1704                 Roma                             NaN   \n",
       "7                   1781               London                             NaN   \n",
       "8                   1704                 Roma                             NaN   \n",
       "9                   1789              A Paris                           Paris   \n",
       "\n",
       "   Sprache                                       Schlagwörter  \n",
       "0  Italian                                   Neapel; Pflanzen  \n",
       "1  Italian                                   Neapel; Pflanzen  \n",
       "2  unknown  Sankt Petersburg; Museum; Eremitage; Straße vo...  \n",
       "3   French                                         Altertümer  \n",
       "4  English                            Dekoration; Christentum  \n",
       "5  Italian  Trajanssäule--Rom; Trajan--Römisches Reich, Ka...  \n",
       "6  Italian  Mark Aurel--Römisches Reich, Kaiser--121-180; ...  \n",
       "7  English                             Aquatinta; Schornstein  \n",
       "8  Italian                                            Plastik  \n",
       "9   French                      Französische Revolution; Bild  "
      ]
     },
     "execution_count": 1244,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_pred_comb.iloc[0:10,0:12]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1250,
   "id": "e450dd3d-1d5f-4b52-a52c-b3d0ad48515a",
   "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>Signatur</th>\n",
       "      <th>Barcode</th>\n",
       "      <th>Titel</th>\n",
       "      <th>Autor</th>\n",
       "      <th>Mitwirkender</th>\n",
       "      <th>Anfang Veröffentlichungsdatum</th>\n",
       "      <th>Ende Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsdatum</th>\n",
       "      <th>Veröffentlichungsort</th>\n",
       "      <th>Veröffentlichungsort (normiert)</th>\n",
       "      <th>...</th>\n",
       "      <th>Dateiname</th>\n",
       "      <th>Wappenklassifizierung</th>\n",
       "      <th>p_A</th>\n",
       "      <th>p_B</th>\n",
       "      <th>p_C</th>\n",
       "      <th>p_N</th>\n",
       "      <th>Farbklassifizierung</th>\n",
       "      <th>p_blue</th>\n",
       "      <th>p_red</th>\n",
       "      <th>p_yellow</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22620</th>\n",
       "      <td>Ink 2.D.15</td>\n",
       "      <td>+Z158717306</td>\n",
       "      <td>Ars memorandi per figuras evangelistarum</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1470</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[um 1470]</td>\n",
       "      <td>[Süddeutschland]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22621</th>\n",
       "      <td>Ink 3.H.31</td>\n",
       "      <td>+Z173262908</td>\n",
       "      <td>De consuetudinibus et conditionibus orientaliu...</td>\n",
       "      <td>Polo, Marco 1254-1324</td>\n",
       "      <td>Leeu, Gerard</td>\n",
       "      <td>1483</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[zwischen 1483 und 11. Juni 1484]</td>\n",
       "      <td>[Gouda]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22622</th>\n",
       "      <td>Ink 3.H.8</td>\n",
       "      <td>+Z158731704</td>\n",
       "      <td>Herbarium Apulei Mit Widmungsbrief des Drucker...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lignamine, Johannes Philippus de</td>\n",
       "      <td>1482</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[um 1481-82]</td>\n",
       "      <td>[Rom]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22623</th>\n",
       "      <td>Ink 4.A.2</td>\n",
       "      <td>1638836-20</td>\n",
       "      <td>Biblia Mit Glossa ordinaria und Interlinearglosse</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rusch, Adolf</td>\n",
       "      <td>1480</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[nicht nach 1480]</td>\n",
       "      <td>[Straßburg]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22624</th>\n",
       "      <td>Ink 4.C.3</td>\n",
       "      <td>1605764-10</td>\n",
       "      <td>Biblia ; Menardus Monachus: Generalis et compe...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Winters, Konrad</td>\n",
       "      <td>1479</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20. Sept. 1479; [1479.09.20]</td>\n",
       "      <td>Köln</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22625</th>\n",
       "      <td>Ink 4.E.4</td>\n",
       "      <td>+Z158736209</td>\n",
       "      <td>Elegantiae linguae latinae Mit Brief des Autor...</td>\n",
       "      <td>Valla, Lorenzo 1407-1457</td>\n",
       "      <td>Jenson, Nicolas</td>\n",
       "      <td>1471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[vor Juli] 1471</td>\n",
       "      <td>Venedig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22626</th>\n",
       "      <td>Ink 4.E.9</td>\n",
       "      <td>+Z158719005</td>\n",
       "      <td>Hypnerotomachia Poliphili Mit lat. Widmungsbri...</td>\n",
       "      <td>Colonna, Francesco 1433-1527</td>\n",
       "      <td>Manuzio, Aldo Pio 1450-1515</td>\n",
       "      <td>1499</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dezember 1499; [1499.12]</td>\n",
       "      <td>Venedig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22627</th>\n",
       "      <td>Ink 4.G.19</td>\n",
       "      <td>+Z158745004</td>\n",
       "      <td>Biblia ; Interpretationes Hebraicorum nominum</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Renner, Franz</td>\n",
       "      <td>1480</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1480</td>\n",
       "      <td>Venedig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22628</th>\n",
       "      <td>Ink 4.H.44</td>\n",
       "      <td>+Z15872590X</td>\n",
       "      <td>Concordantia astronomie cum theologia. Concord...</td>\n",
       "      <td>Peter von Ailly, Kardinal 1351-1420</td>\n",
       "      <td>Ratdolt, Erhard</td>\n",
       "      <td>1490</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2. Jan. 1490; [1490.01.02]</td>\n",
       "      <td>Augsburg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22629</th>\n",
       "      <td>Ink 4.H.45</td>\n",
       "      <td>1444073-10</td>\n",
       "      <td>Biblia ; Interpretationes Hebraicorum nominum</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1480</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31. Mai 1480; [1480.05.31]</td>\n",
       "      <td>Venedig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22630</th>\n",
       "      <td>Ink 4.H.58</td>\n",
       "      <td>+Z158747906</td>\n",
       "      <td>Coronica del cid ruy diaz</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1498</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mai 1498</td>\n",
       "      <td>Sevilla</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22631</th>\n",
       "      <td>Ink 5.B.10</td>\n",
       "      <td>+Z158733907</td>\n",
       "      <td>Biblia &lt;dt.&gt; Übers. aus dem Lateinischen. Mit ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Koberger, Anton</td>\n",
       "      <td>1483</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17. Feb. 1483; [1483.02.17]</td>\n",
       "      <td>Nürnberg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22632</th>\n",
       "      <td>Ink 5.C.12</td>\n",
       "      <td>1571736-10</td>\n",
       "      <td>Biblia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Schöffer, Peter (der Ältere)</td>\n",
       "      <td>1472</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23. Feb. 1472</td>\n",
       "      <td>Mainz</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22633</th>\n",
       "      <td>Ink 5.C.9</td>\n",
       "      <td>+Z173284400</td>\n",
       "      <td>Historiae Romanae decades Mit den Periochae. M...</td>\n",
       "      <td>Livius, Titus v59-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1470</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1470</td>\n",
       "      <td>[Venedig]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22634</th>\n",
       "      <td>Ink 5.E.4</td>\n",
       "      <td>+Z158727300</td>\n",
       "      <td>Decamerone</td>\n",
       "      <td>Boccaccio, Giovanni 1313-1375</td>\n",
       "      <td>Zarotto, Antonio</td>\n",
       "      <td>1476</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1476</td>\n",
       "      <td>Mailand</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22635</th>\n",
       "      <td>Ink 6.B.2</td>\n",
       "      <td>1639891-10</td>\n",
       "      <td>Biblia &lt;ital.&gt; Übers. aus dem Lateinischen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ammergau, Adam von</td>\n",
       "      <td>1471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1. Okt. 1471</td>\n",
       "      <td>[Venedig]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22636</th>\n",
       "      <td>Ink 6.E.11</td>\n",
       "      <td>+Z158731601</td>\n",
       "      <td>De materia medica &lt;lat.&gt; Mit Glossen und Zusät...</td>\n",
       "      <td>Dioscorides, Pedanius 40-90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1478</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Juli 1478; [1478.07]</td>\n",
       "      <td>Colle</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22637</th>\n",
       "      <td>Ink 7.D.16</td>\n",
       "      <td>+Z95540203</td>\n",
       "      <td>Mathesis Mit Widmungsbrief an Kardinal Ippolit...</td>\n",
       "      <td>Firmicus Maternus, Iulius ca. 335/350</td>\n",
       "      <td>Manuzio, Aldo Pio 1450-1515; Guidobaldo I. Urb...</td>\n",
       "      <td>1499</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1499; Juni (P. 1), Okt. 1499 (P. 2)</td>\n",
       "      <td>Venedig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22638</th>\n",
       "      <td>Ink 7.E.1</td>\n",
       "      <td>1566517-10</td>\n",
       "      <td>Biblia Mit Postilla litteralis von Nicolaus de...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Koberger, Anton</td>\n",
       "      <td>1485</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7. Mai 1485; [1485.05.07]</td>\n",
       "      <td>Nürnberg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22639</th>\n",
       "      <td>Ink 8.E.26</td>\n",
       "      <td>+Z158726101</td>\n",
       "      <td>La nef des fols du monde Aus dem Lat. des Jako...</td>\n",
       "      <td>Brant, Sebastian 1458-1521</td>\n",
       "      <td>Jean Lambert; Rivière, Pierre -1499</td>\n",
       "      <td>1497</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[nicht vor Dez.] 1497</td>\n",
       "      <td>Paris</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22640</th>\n",
       "      <td>Ink 9.D.5</td>\n",
       "      <td>+Z35095803</td>\n",
       "      <td>Thesaurus Cornu copiae et Horti Adonidis &lt;grie...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manuzio, Aldo Pio; Bolzanio, Urbano 1443-1524;...</td>\n",
       "      <td>1496</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aug. 1496; [1496.08]</td>\n",
       "      <td>Venedig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22641</th>\n",
       "      <td>Ink 9.F.22</td>\n",
       "      <td>+Z96101306</td>\n",
       "      <td>Comoediae ; Francesco Petrarca: Vita Terentii</td>\n",
       "      <td>Terentius Afer, Publius v195-v159</td>\n",
       "      <td>Zarotto, Antonio</td>\n",
       "      <td>1476</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23. Feb. 1476; [1476.02.23]</td>\n",
       "      <td>Mailand</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22642</th>\n",
       "      <td>Ink 9.F.5</td>\n",
       "      <td>1460328-10</td>\n",
       "      <td>Biblia ; Interpretationes Hebraicorum nominum</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wild, Leonhard</td>\n",
       "      <td>1481</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1481</td>\n",
       "      <td>Venedig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Signatur      Barcode   \n",
       "22620  Ink 2.D.15  +Z158717306  \\\n",
       "22621  Ink 3.H.31  +Z173262908   \n",
       "22622   Ink 3.H.8  +Z158731704   \n",
       "22623   Ink 4.A.2   1638836-20   \n",
       "22624   Ink 4.C.3   1605764-10   \n",
       "22625   Ink 4.E.4  +Z158736209   \n",
       "22626   Ink 4.E.9  +Z158719005   \n",
       "22627  Ink 4.G.19  +Z158745004   \n",
       "22628  Ink 4.H.44  +Z15872590X   \n",
       "22629  Ink 4.H.45   1444073-10   \n",
       "22630  Ink 4.H.58  +Z158747906   \n",
       "22631  Ink 5.B.10  +Z158733907   \n",
       "22632  Ink 5.C.12   1571736-10   \n",
       "22633   Ink 5.C.9  +Z173284400   \n",
       "22634   Ink 5.E.4  +Z158727300   \n",
       "22635   Ink 6.B.2   1639891-10   \n",
       "22636  Ink 6.E.11  +Z158731601   \n",
       "22637  Ink 7.D.16   +Z95540203   \n",
       "22638   Ink 7.E.1   1566517-10   \n",
       "22639  Ink 8.E.26  +Z158726101   \n",
       "22640   Ink 9.D.5   +Z35095803   \n",
       "22641  Ink 9.F.22   +Z96101306   \n",
       "22642   Ink 9.F.5   1460328-10   \n",
       "\n",
       "                                                   Titel   \n",
       "22620           Ars memorandi per figuras evangelistarum  \\\n",
       "22621  De consuetudinibus et conditionibus orientaliu...   \n",
       "22622  Herbarium Apulei Mit Widmungsbrief des Drucker...   \n",
       "22623  Biblia Mit Glossa ordinaria und Interlinearglosse   \n",
       "22624  Biblia ; Menardus Monachus: Generalis et compe...   \n",
       "22625  Elegantiae linguae latinae Mit Brief des Autor...   \n",
       "22626  Hypnerotomachia Poliphili Mit lat. Widmungsbri...   \n",
       "22627      Biblia ; Interpretationes Hebraicorum nominum   \n",
       "22628  Concordantia astronomie cum theologia. Concord...   \n",
       "22629      Biblia ; Interpretationes Hebraicorum nominum   \n",
       "22630                          Coronica del cid ruy diaz   \n",
       "22631  Biblia <dt.> Übers. aus dem Lateinischen. Mit ...   \n",
       "22632                                             Biblia   \n",
       "22633  Historiae Romanae decades Mit den Periochae. M...   \n",
       "22634                                         Decamerone   \n",
       "22635         Biblia <ital.> Übers. aus dem Lateinischen   \n",
       "22636  De materia medica <lat.> Mit Glossen und Zusät...   \n",
       "22637  Mathesis Mit Widmungsbrief an Kardinal Ippolit...   \n",
       "22638  Biblia Mit Postilla litteralis von Nicolaus de...   \n",
       "22639  La nef des fols du monde Aus dem Lat. des Jako...   \n",
       "22640  Thesaurus Cornu copiae et Horti Adonidis <grie...   \n",
       "22641      Comoediae ; Francesco Petrarca: Vita Terentii   \n",
       "22642      Biblia ; Interpretationes Hebraicorum nominum   \n",
       "\n",
       "                                       Autor   \n",
       "22620                                    NaN  \\\n",
       "22621                  Polo, Marco 1254-1324   \n",
       "22622                                    NaN   \n",
       "22623                                    NaN   \n",
       "22624                                    NaN   \n",
       "22625               Valla, Lorenzo 1407-1457   \n",
       "22626           Colonna, Francesco 1433-1527   \n",
       "22627                                    NaN   \n",
       "22628    Peter von Ailly, Kardinal 1351-1420   \n",
       "22629                                    NaN   \n",
       "22630                                    NaN   \n",
       "22631                                    NaN   \n",
       "22632                                    NaN   \n",
       "22633                   Livius, Titus v59-17   \n",
       "22634          Boccaccio, Giovanni 1313-1375   \n",
       "22635                                    NaN   \n",
       "22636            Dioscorides, Pedanius 40-90   \n",
       "22637  Firmicus Maternus, Iulius ca. 335/350   \n",
       "22638                                    NaN   \n",
       "22639             Brant, Sebastian 1458-1521   \n",
       "22640                                    NaN   \n",
       "22641      Terentius Afer, Publius v195-v159   \n",
       "22642                                    NaN   \n",
       "\n",
       "                                            Mitwirkender   \n",
       "22620                                                NaN  \\\n",
       "22621                                       Leeu, Gerard   \n",
       "22622                   Lignamine, Johannes Philippus de   \n",
       "22623                                       Rusch, Adolf   \n",
       "22624                                    Winters, Konrad   \n",
       "22625                                    Jenson, Nicolas   \n",
       "22626                        Manuzio, Aldo Pio 1450-1515   \n",
       "22627                                      Renner, Franz   \n",
       "22628                                    Ratdolt, Erhard   \n",
       "22629                                                NaN   \n",
       "22630                                                NaN   \n",
       "22631                                    Koberger, Anton   \n",
       "22632                       Schöffer, Peter (der Ältere)   \n",
       "22633                                                NaN   \n",
       "22634                                   Zarotto, Antonio   \n",
       "22635                                 Ammergau, Adam von   \n",
       "22636                                                NaN   \n",
       "22637  Manuzio, Aldo Pio 1450-1515; Guidobaldo I. Urb...   \n",
       "22638                                    Koberger, Anton   \n",
       "22639                Jean Lambert; Rivière, Pierre -1499   \n",
       "22640  Manuzio, Aldo Pio; Bolzanio, Urbano 1443-1524;...   \n",
       "22641                                   Zarotto, Antonio   \n",
       "22642                                     Wild, Leonhard   \n",
       "\n",
       "      Anfang Veröffentlichungsdatum Ende Veröffentlichungsdatum   \n",
       "22620                          1470                         NaN  \\\n",
       "22621                          1483                         NaN   \n",
       "22622                          1482                         NaN   \n",
       "22623                          1480                         NaN   \n",
       "22624                          1479                         NaN   \n",
       "22625                          1471                         NaN   \n",
       "22626                          1499                         NaN   \n",
       "22627                          1480                         NaN   \n",
       "22628                          1490                         NaN   \n",
       "22629                          1480                         NaN   \n",
       "22630                          1498                         NaN   \n",
       "22631                          1483                         NaN   \n",
       "22632                          1472                         NaN   \n",
       "22633                          1470                         NaN   \n",
       "22634                          1476                         NaN   \n",
       "22635                          1471                         NaN   \n",
       "22636                          1478                         NaN   \n",
       "22637                          1499                         NaN   \n",
       "22638                          1485                         NaN   \n",
       "22639                          1497                         NaN   \n",
       "22640                          1496                         NaN   \n",
       "22641                          1476                         NaN   \n",
       "22642                          1481                         NaN   \n",
       "\n",
       "                    Veröffentlichungsdatum Veröffentlichungsort   \n",
       "22620                            [um 1470]     [Süddeutschland]  \\\n",
       "22621    [zwischen 1483 und 11. Juni 1484]              [Gouda]   \n",
       "22622                         [um 1481-82]                [Rom]   \n",
       "22623                    [nicht nach 1480]          [Straßburg]   \n",
       "22624         20. Sept. 1479; [1479.09.20]                 Köln   \n",
       "22625                      [vor Juli] 1471              Venedig   \n",
       "22626             Dezember 1499; [1499.12]              Venedig   \n",
       "22627                                 1480              Venedig   \n",
       "22628           2. Jan. 1490; [1490.01.02]             Augsburg   \n",
       "22629           31. Mai 1480; [1480.05.31]              Venedig   \n",
       "22630                             Mai 1498              Sevilla   \n",
       "22631          17. Feb. 1483; [1483.02.17]             Nürnberg   \n",
       "22632                        23. Feb. 1472                Mainz   \n",
       "22633                                 1470            [Venedig]   \n",
       "22634                                 1476              Mailand   \n",
       "22635                         1. Okt. 1471            [Venedig]   \n",
       "22636                 Juli 1478; [1478.07]                Colle   \n",
       "22637  1499; Juni (P. 1), Okt. 1499 (P. 2)              Venedig   \n",
       "22638            7. Mai 1485; [1485.05.07]             Nürnberg   \n",
       "22639                [nicht vor Dez.] 1497                Paris   \n",
       "22640                 Aug. 1496; [1496.08]              Venedig   \n",
       "22641          23. Feb. 1476; [1476.02.23]              Mailand   \n",
       "22642                                 1481              Venedig   \n",
       "\n",
       "      Veröffentlichungsort (normiert)  ... Dateiname Wappenklassifizierung   \n",
       "22620                             NaN  ...       NaN                   NaN  \\\n",
       "22621                             NaN  ...       NaN                   NaN   \n",
       "22622                             NaN  ...       NaN                   NaN   \n",
       "22623                             NaN  ...       NaN                   NaN   \n",
       "22624                             NaN  ...       NaN                   NaN   \n",
       "22625                             NaN  ...       NaN                   NaN   \n",
       "22626                             NaN  ...       NaN                   NaN   \n",
       "22627                             NaN  ...       NaN                   NaN   \n",
       "22628                             NaN  ...       NaN                   NaN   \n",
       "22629                             NaN  ...       NaN                   NaN   \n",
       "22630                             NaN  ...       NaN                   NaN   \n",
       "22631                             NaN  ...       NaN                   NaN   \n",
       "22632                             NaN  ...       NaN                   NaN   \n",
       "22633                             NaN  ...       NaN                   NaN   \n",
       "22634                             NaN  ...       NaN                   NaN   \n",
       "22635                             NaN  ...       NaN                   NaN   \n",
       "22636                             NaN  ...       NaN                   NaN   \n",
       "22637                             NaN  ...       NaN                   NaN   \n",
       "22638                             NaN  ...       NaN                   NaN   \n",
       "22639                             NaN  ...       NaN                   NaN   \n",
       "22640                             NaN  ...       NaN                   NaN   \n",
       "22641                             NaN  ...       NaN                   NaN   \n",
       "22642                             NaN  ...       NaN                   NaN   \n",
       "\n",
       "      p_A p_B p_C p_N Farbklassifizierung p_blue p_red  p_yellow  \n",
       "22620 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22621 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22622 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22623 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22624 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22625 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22626 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22627 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22628 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22629 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22630 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22631 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22632 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22633 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22634 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22635 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22636 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22637 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22638 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22639 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22640 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22641 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "22642 NaN NaN NaN NaN                 NaN    NaN   NaN       NaN  \n",
       "\n",
       "[23 rows x 27 columns]"
      ]
     },
     "execution_count": 1250,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_pred_comb[cat_pred_comb['Signatur'].str.contains('Ink')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "61dfbe10-2de4-4adf-a6c1-7b4aca7de930",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([   62,    80,    82,    83,   242,   416,   418,   490,   491,\n",
       "         492,   493,   560,   610,   613,   657,   658,   694,   695,\n",
       "         736,   868,   948,   960,   961,  1009,  1028,  1113,  1139,\n",
       "        1140,  1141,  1142,  1143,  1181,  1204,  1206,  1217,  1218,\n",
       "        1219,  1220,  1221,  1222,  1223,  1224,  1225,  1226,  1227,\n",
       "        1228,  1229,  1230,  1231,  1232,  1233,  1234,  1235,  1236,\n",
       "        1244,  1245,  1246,  1247,  1248,  1249,  1250,  1251,  1287,\n",
       "        1288,  1289,  1290,  1291,  1292,  1293,  1294,  1300,  1301,\n",
       "        1304,  1305,  1312,  1425,  1441,  1473,  1546,  1547,  1629,\n",
       "        1691,  1711,  2335,  2462,  2668,  2727,  2733,  2814,  2818,\n",
       "        2963,  3065,  3117,  3284,  3285,  3337,  3338,  3389,  3583,\n",
       "        3774,  3860,  3912,  3917,  3994,  4029,  4256,  4275,  4292,\n",
       "        4383,  4507,  4526,  4527,  4528,  4531,  4532,  4534,  4537,\n",
       "        4538,  4539,  4543,  4755,  4759,  4760,  4918,  4919,  4983,\n",
       "        4987,  4988,  4989,  4990,  4991,  4992,  4993,  4994,  4995,\n",
       "        4999,  5011,  5012,  5018,  5019,  5021,  5022,  5023,  5024,\n",
       "        5025,  5027,  5046,  5063,  5110,  5119,  5120,  5121,  5123,\n",
       "        5131,  5132,  5134,  5144,  5238,  5239,  5240,  5241,  5242,\n",
       "        5243,  5279,  5280,  5315,  5316,  5325,  5341,  5342,  5343,\n",
       "        5345,  5346,  5394,  5395,  5398,  5431,  5432,  5433,  5434,\n",
       "        5440,  5441,  5442,  5443,  5476,  5490,  5558,  5711,  5713,\n",
       "        5761,  5778,  6100,  6107,  6121,  6127,  6128,  6429,  6611,\n",
       "        6612,  6613,  6620,  6621,  6622,  6623,  6624,  6725,  6817,\n",
       "        6818,  6873,  6874,  6875,  6876,  6877,  6878,  6881,  6916,\n",
       "        6924,  6931,  6932,  6933,  7014,  7017,  7018,  7019,  7021,\n",
       "        7022,  7023,  7030,  7059,  7060,  7064,  7068,  7069,  7326,\n",
       "        7477,  7478,  7489,  7542,  7543,  7655,  7726,  7773,  7791,\n",
       "        8037,  8093,  8184,  8185,  8186,  8188,  8194,  8289,  8382,\n",
       "        8385,  8386,  8394,  8419,  8433,  8656,  8686,  8689,  9419,\n",
       "        9443,  9494,  9511,  9588,  9590,  9592,  9597,  9720,  9730,\n",
       "        9801,  9802,  9838,  9839,  9840,  9841,  9987, 10328, 10329,\n",
       "       10334, 10345, 10346, 10347, 10348, 10349, 10350, 10356, 10357,\n",
       "       10588, 10590, 10591, 10592, 10603, 10604, 10605, 10618, 10619,\n",
       "       10620, 10621, 10625, 10626, 10705, 10706, 10707, 10740, 10741,\n",
       "       10742, 10743, 10907, 11117, 11118, 11119, 11171, 11481, 11488,\n",
       "       11489, 11543, 11593, 11594, 11777, 11867, 11877, 11978, 11994,\n",
       "       12013, 12015, 12016, 12017, 12028, 12072, 12081, 12165, 12184,\n",
       "       12217, 12306, 12307, 12311, 12325, 12399, 12421, 12422, 12482,\n",
       "       12630, 12689, 12712, 12714, 12715, 12732, 12734, 12736, 12835,\n",
       "       12851, 12853, 12955, 13389, 13416, 13477, 13530, 13675, 13676,\n",
       "       13714, 13832, 13835, 13845, 13853, 14055, 14056, 14057, 14058,\n",
       "       14059, 14060, 14117, 14190, 14317, 14432, 14449, 14526, 14689,\n",
       "       14791, 14873, 14874, 14943, 14944, 14945, 15071, 15142, 15144,\n",
       "       15169, 15339, 15407, 15408, 15441, 15447, 15585, 15824, 15851,\n",
       "       15935, 15942, 16007, 16095, 16172, 16173, 16190, 16218, 16224,\n",
       "       16226, 16321, 16322, 16408, 16417, 16495, 16555, 16648, 16660,\n",
       "       16661, 16764, 16771, 16772, 17095, 17158, 17159, 17167, 17171,\n",
       "       17183, 17316, 17349, 17350, 17406, 17515, 17644, 17645, 17708,\n",
       "       17709, 17721, 17743, 17940, 18058, 18059, 18178, 18453, 18484,\n",
       "       18485, 18578, 18594, 18640, 18642, 18643, 18644, 18645, 18646,\n",
       "       18647, 18648, 18654, 18832, 18928, 19163, 19182, 19183, 19253,\n",
       "       19254, 19358, 19399, 19402, 19404, 19470, 19496, 19497, 19498,\n",
       "       19499, 19500, 19501, 19502, 19503, 19653, 19753, 19755, 19769,\n",
       "       19772, 19795, 19804, 19810, 19815, 19873, 19955, 19956, 19982,\n",
       "       20234, 20440, 20503, 20509, 20513, 20514, 20515, 20516, 20517,\n",
       "       20518, 20519, 20521, 20546, 20607, 20608, 20609, 20610, 20611,\n",
       "       20612, 20620, 20623, 20624, 20625, 20921, 21020, 21159, 21160,\n",
       "       21161, 21239, 21240, 21241, 21242, 21243, 21244, 21249, 21250,\n",
       "       21251, 21259, 21269, 21270, 21271, 21272, 21273, 21274, 21276,\n",
       "       21277, 21290, 21308, 21347, 21365, 21380, 21382, 21385, 21390,\n",
       "       21391, 21392, 21397, 21398, 21399, 21411, 21413, 21464, 21470,\n",
       "       21472, 21473, 21474, 21475, 21476, 21483, 21489, 21490, 21491,\n",
       "       21497, 21569, 21570, 21571, 21576, 21577, 21580, 21581, 21585,\n",
       "       21586, 21587, 21590, 21597, 21598, 21599, 21614, 21781, 21792,\n",
       "       21793, 21794, 21795, 21796, 21797, 21798, 21799, 21800, 21801,\n",
       "       21803, 21804, 21811, 21812, 21824, 21825, 21991, 22010, 22011,\n",
       "       22012, 22013, 22014, 22015, 22020, 22022, 22023, 22025, 22030,\n",
       "       22033, 22036, 22037, 22038, 22039, 22040, 22049, 22050, 22073,\n",
       "       22152, 22153, 22207, 22208, 22247, 22250, 22254, 22272, 22273,\n",
       "       22283, 22344, 22589, 22610, 22611, 22612, 22613, 22614, 22615,\n",
       "       22616, 22617, 22618, 22619, 22620, 22621, 22622, 22623, 22624,\n",
       "       22625, 22626, 22627, 22628, 22629, 22630, 22631, 22632, 22633,\n",
       "       22634, 22635, 22636, 22637, 22638, 22639, 22640])"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_pred_comb['Bemerkungen'].dropna().index.values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "75c785d5-6b04-4fdf-a1e3-85ccf62ef746",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'$$c Wappenschild (Bl.3a, a1a) mit Wasserfarben, gelb-rot geteilt, nicht gefüllt.; $$d Barock-Einband für Eugen von Savoyen: rotes Maroquin, Golddruck (Wappen-Supralibros VD, HD). - Wien, Etienne Boyet d. J., nach 1713. - 280x200mm.; $$f Ink 9.F.22; $$k 1738 mit der Bibliotheca Eugeniana von der Hofbibliothek erworben. Alte Bleistift-Signatur der Hofbibliothek (Bl.V2a *XXXVII.D.26, getilgt).; $$l Menčik, Ferdinand: Die Wegführung der Handschriften aus der Hofbibliothek durch die Franzosen im Jahre 1809. Wien, Leipzig 1910 (Bestandsliste Inkunabeln, S.27, Sp. 2).; $$m Ursprünglich durchgehend ausführliche Marginalien und Interlinearglossen sowie Bl.2b Ausführungen zur Comedia (Bl.2b) in Humanistenkursive (um 1500, vielleicht von der Hand Johannes Cuspinians?), wahrscheinlich im 18. Jh vor der Neubindung für Prinz Eugen ausgewaschen oder gebleicht.; $$p Im 18. Jh im Besitz Prinz Eugens von Savoyen (1663-1736). - Aufgrund des Eintrags \"Vienne\" (braune Tinte, schräg Bl.V1b, unterer Rand) bei jenen Inkunabeln, die 1809 von den französischen Truppen nach Paris entführt und 1814/15 zurückerstattet wurden (vgl. Menčik).; $$a ALT'"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_pred_comb.loc[22639]['Bemerkungen']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "87556949-727b-48de-a3b5-e6c2234aef77",
   "metadata": {},
   "source": [
    "# Felder in \"Vorbesitzer\" und \"Bemerkungen\"\n",
    "\n",
    "## Vorbesitzer\n",
    "\n",
    "$$a: Name (manchmal mit Lebensdaten)\n",
    "$$b: Bezeichnung (Vorbesitzer oder Buchbinder etc.)\n",
    "$$c: Berufs-/Standesbezeichnung\n",
    "$$d: Lebensdaten oder Besitzdauer\n",
    "$$0: GND-Link\n",
    "$$4: ???\n",
    "\n",
    "## Bemerkungen\n",
    "\n",
    "$$a: Exemplar/Standort\n",
    "$$b: Hinweise\n",
    "$$c: Ausstattung\n",
    "$$d: Einband\n",
    "$$e: Einband/Druckinformation/Korrekturen/Besonderheiten\n",
    "$$f: Signatur\n",
    "$$g: Standort\n",
    "$$k: Erwerb\n",
    "$$l: Literaturhinweis\n",
    "$$m: Handschriftliche Vermerke\n",
    "$$p: Provenienz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4d13bf4e-b5a3-47d1-8a9a-b7c6df5e5337",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
