DNB_Vorbereitung_Dataframe-Isolieren_von_IDs.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "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>Unnamed: 0</th>\n",
       "      <th>subject</th>\n",
       "      <th>identifier</th>\n",
       "      <th>type</th>\n",
       "      <th>creator</th>\n",
       "      <th>title</th>\n",
       "      <th>volume</th>\n",
       "      <th>edition</th>\n",
       "      <th>publisher</th>\n",
       "      <th>year</th>\n",
       "      <th>...</th>\n",
       "      <th>description</th>\n",
       "      <th>collective.title</th>\n",
       "      <th>links</th>\n",
       "      <th>relation</th>\n",
       "      <th>rights</th>\n",
       "      <th>subject.headings</th>\n",
       "      <th>connected.titles</th>\n",
       "      <th>uniform.title</th>\n",
       "      <th>frequency</th>\n",
       "      <th>wv.number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31</td>\n",
       "      <td>830 Deutsche Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-3-945238-40-0 Broschur, IDN:1206561718</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Trelenberg, Thorsten [Verfasser]</td>\n",
       "      <td>Auf der Suche nach dem Zauberwort = V poiskach...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dortmund : Verlag Dortmunder Buch</td>\n",
       "      <td>2020</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>20,A18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>71</td>\n",
       "      <td>830 Deutsche Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-3-8353-3856-2 Festeinband : circa EUR...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Erb, Elke [Verfasser] ; Anderson, Shane [Übers...</td>\n",
       "      <td>Das Gedicht ist, was es tut : deutsch - englis...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Göttingen : Wallstein Verlag</td>\n",
       "      <td>2020</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Berliner Rede zur Poesie ; 2018</td>\n",
       "      <td>Inhaltstext [http://deposit.dnb.de/cgi-bin/dok...</td>\n",
       "      <td>http://d-nb.info/1114525014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Erscheint auch als: ISBN: 9783835332614</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20,N29 , 21,A08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>72</td>\n",
       "      <td>830 Deutsche Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-1-4907-9859-2 Broschur, IDN:1211201678</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mohnnau, Ralph Günther [Verfasser] ; Martin, C...</td>\n",
       "      <td>[Tag um Tag faltet sich die Zeit] ; Day by day...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bi-lingual edition</td>\n",
       "      <td>[Frankfurt am Main] : Ralph Günther Mohnnau</td>\n",
       "      <td>2020</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>Tag um Tag faltet sich die Zeit</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20,B25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>96</td>\n",
       "      <td>820 Englische Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-3-945961-17-9 Broschur : EUR 15.00 (D...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Daly, Leo [Verfasser] ; Soppa, Chris Inken [Üb...</td>\n",
       "      <td>[The rock garden] ; Der Felsengarten : Stimmen...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[1. Auflage]</td>\n",
       "      <td>Berlin : Literaturverlag Josefine Rosalski</td>\n",
       "      <td>2020</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Edition Karo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The rock garden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19,N51 , 20,A32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>97</td>\n",
       "      <td>810 Englische Literatur Amerikas ; B Belletristik</td>\n",
       "      <td>ISBN:978-3-96588-040-5 Festeinband : EUR 17.80...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Larson, R. J. Verfasser] ; [Wolf, Alexandra [Ü...</td>\n",
       "      <td>[Judge] ; Der Richter : Roman / R. J. Larson ;...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1. Auflage</td>\n",
       "      <td>Rinteln : ReformaZion Media</td>\n",
       "      <td>2020</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bücher des Ewigen : Verfasser : 2019 ; Band 2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://d-nb.info/1201559065</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Judge</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20,N47 , 21,A05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0                                            subject  \\\n",
       "0          31            830 Deutsche Literatur ; B Belletristik   \n",
       "1          71            830 Deutsche Literatur ; B Belletristik   \n",
       "2          72            830 Deutsche Literatur ; B Belletristik   \n",
       "3          96           820 Englische Literatur ; B Belletristik   \n",
       "4          97  810 Englische Literatur Amerikas ; B Belletristik   \n",
       "\n",
       "                                          identifier type  \\\n",
       "0    ISBN:978-3-945238-40-0 Broschur, IDN:1206561718  NaN   \n",
       "1  ISBN:978-3-8353-3856-2 Festeinband : circa EUR...  NaN   \n",
       "2    ISBN:978-1-4907-9859-2 Broschur, IDN:1211201678  NaN   \n",
       "3  ISBN:978-3-945961-17-9 Broschur : EUR 15.00 (D...  NaN   \n",
       "4  ISBN:978-3-96588-040-5 Festeinband : EUR 17.80...  NaN   \n",
       "\n",
       "                                             creator  \\\n",
       "0                   Trelenberg, Thorsten [Verfasser]   \n",
       "1  Erb, Elke [Verfasser] ; Anderson, Shane [Übers...   \n",
       "2  Mohnnau, Ralph Günther [Verfasser] ; Martin, C...   \n",
       "3  Daly, Leo [Verfasser] ; Soppa, Chris Inken [Üb...   \n",
       "4  Larson, R. J. Verfasser] ; [Wolf, Alexandra [Ü...   \n",
       "\n",
       "                                               title volume  \\\n",
       "0  Auf der Suche nach dem Zauberwort = V poiskach...    NaN   \n",
       "1  Das Gedicht ist, was es tut : deutsch - englis...    NaN   \n",
       "2  [Tag um Tag faltet sich die Zeit] ; Day by day...    NaN   \n",
       "3  [The rock garden] ; Der Felsengarten : Stimmen...    NaN   \n",
       "4  [Judge] ; Der Richter : Roman / R. J. Larson ;...    NaN   \n",
       "\n",
       "              edition                                    publisher  year  ...  \\\n",
       "0                 NaN            Dortmund : Verlag Dortmunder Buch  2020  ...   \n",
       "1                 NaN                 Göttingen : Wallstein Verlag  2020  ...   \n",
       "2  Bi-lingual edition  [Frankfurt am Main] : Ralph Günther Mohnnau  2020  ...   \n",
       "3        [1. Auflage]   Berlin : Literaturverlag Josefine Rosalski  2020  ...   \n",
       "4          1. Auflage                  Rinteln : ReformaZion Media  2020  ...   \n",
       "\n",
       "  description                               collective.title  \\\n",
       "0         NaN                                            NaN   \n",
       "1         NaN                Berliner Rede zur Poesie ; 2018   \n",
       "2         NaN                                            NaN   \n",
       "3         NaN                                   Edition Karo   \n",
       "4         NaN  Bücher des Ewigen : Verfasser : 2019 ; Band 2   \n",
       "\n",
       "                                               links  \\\n",
       "0                                                NaN   \n",
       "1  Inhaltstext [http://deposit.dnb.de/cgi-bin/dok...   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4                                                NaN   \n",
       "\n",
       "                      relation  rights subject.headings  \\\n",
       "0                          NaN     NaN              NaN   \n",
       "1  http://d-nb.info/1114525014     NaN              NaN   \n",
       "2                          NaN     NaN              NaN   \n",
       "3                          NaN     NaN              NaN   \n",
       "4  http://d-nb.info/1201559065     NaN              NaN   \n",
       "\n",
       "                          connected.titles                    uniform.title  \\\n",
       "0                                      NaN                              NaN   \n",
       "1  Erscheint auch als: ISBN: 9783835332614                              NaN   \n",
       "2                                      NaN  Tag um Tag faltet sich die Zeit   \n",
       "3                                      NaN                  The rock garden   \n",
       "4                                      NaN                            Judge   \n",
       "\n",
       "  frequency        wv.number  \n",
       "0       NaN           20,A18  \n",
       "1       NaN  20,N29 , 21,A08  \n",
       "2       NaN           20,B25  \n",
       "3       NaN  19,N51 , 20,A32  \n",
       "4       NaN  20,N47 , 21,A05  \n",
       "\n",
       "[5 rows x 29 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv(\"alldnb_bilingual_ger.csv\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>identifier</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ISBN:978-3-945238-40-0 Broschur, IDN:1206561718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ISBN:978-3-8353-3856-2 Festeinband : circa EUR...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ISBN:978-1-4907-9859-2 Broschur, IDN:1211201678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ISBN:978-3-945961-17-9 Broschur : EUR 15.00 (D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ISBN:978-3-96588-040-5 Festeinband : EUR 17.80...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1317</th>\n",
       "      <td>ISBN:978-3-924313-01-2 Gewebe, 3-924313-01-6 G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1318</th>\n",
       "      <td>ISBN:kart., IDN:953951456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1319</th>\n",
       "      <td>ISBN:kart., IDN:953951642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1320</th>\n",
       "      <td>ISBN:Lei 6.50, IDN:36897345X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1321</th>\n",
       "      <td>ISBN:kart., IDN:95513711X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1322 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             identifier\n",
       "0       ISBN:978-3-945238-40-0 Broschur, IDN:1206561718\n",
       "1     ISBN:978-3-8353-3856-2 Festeinband : circa EUR...\n",
       "2       ISBN:978-1-4907-9859-2 Broschur, IDN:1211201678\n",
       "3     ISBN:978-3-945961-17-9 Broschur : EUR 15.00 (D...\n",
       "4     ISBN:978-3-96588-040-5 Festeinband : EUR 17.80...\n",
       "...                                                 ...\n",
       "1317  ISBN:978-3-924313-01-2 Gewebe, 3-924313-01-6 G...\n",
       "1318                          ISBN:kart., IDN:953951456\n",
       "1319                          ISBN:kart., IDN:953951642\n",
       "1320                       ISBN:Lei 6.50, IDN:36897345X\n",
       "1321                          ISBN:kart., IDN:95513711X\n",
       "\n",
       "[1322 rows x 1 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Spalte \"identifier\" als eigenes Dataframe: \n",
    "\n",
    "df_id = pd.DataFrame(df, columns=['identifier'])\n",
    "df_id\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Funktion zur Übergabe des Inhalttextes: \n",
    "\n",
    "def retrieve_text(lst, text):\n",
    "    try:\n",
    "        return [i for i in lst if text in i][0]\n",
    "    except:\n",
    "        return None\n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Ergänzen Spalten mit Teilen des Textes aus df_id anhand der String-Funktion: \n",
    "\n",
    "df_id['ISBN_test'] = df_id['identifier'].str.split().apply(lambda x: retrieve_text(x, 'ISBN')) \n",
    "df_id['IDN_test'] = df_id['identifier'].str.split().apply(lambda x: retrieve_text(x, 'IDN'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>identifier</th>\n",
       "      <th>ISBN_test</th>\n",
       "      <th>IDN_test</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ISBN:978-3-945238-40-0 Broschur, IDN:1206561718</td>\n",
       "      <td>ISBN:978-3-945238-40-0</td>\n",
       "      <td>IDN:1206561718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ISBN:978-3-8353-3856-2 Festeinband : circa EUR...</td>\n",
       "      <td>ISBN:978-3-8353-3856-2</td>\n",
       "      <td>IDN:1213594154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ISBN:978-1-4907-9859-2 Broschur, IDN:1211201678</td>\n",
       "      <td>ISBN:978-1-4907-9859-2</td>\n",
       "      <td>IDN:1211201678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ISBN:978-3-945961-17-9 Broschur : EUR 15.00 (D...</td>\n",
       "      <td>ISBN:978-3-945961-17-9</td>\n",
       "      <td>IDN:1201301157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ISBN:978-3-96588-040-5 Festeinband : EUR 17.80...</td>\n",
       "      <td>ISBN:978-3-96588-040-5</td>\n",
       "      <td>IDN:1221388894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1317</th>\n",
       "      <td>ISBN:978-3-924313-01-2 Gewebe, 3-924313-01-6 G...</td>\n",
       "      <td>ISBN:978-3-924313-01-2</td>\n",
       "      <td>IDN:971051135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1318</th>\n",
       "      <td>ISBN:kart., IDN:953951456</td>\n",
       "      <td>ISBN:kart.,</td>\n",
       "      <td>IDN:953951456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1319</th>\n",
       "      <td>ISBN:kart., IDN:953951642</td>\n",
       "      <td>ISBN:kart.,</td>\n",
       "      <td>IDN:953951642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1320</th>\n",
       "      <td>ISBN:Lei 6.50, IDN:36897345X</td>\n",
       "      <td>ISBN:Lei</td>\n",
       "      <td>IDN:36897345X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1321</th>\n",
       "      <td>ISBN:kart., IDN:95513711X</td>\n",
       "      <td>ISBN:kart.,</td>\n",
       "      <td>IDN:95513711X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1322 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             identifier  \\\n",
       "0       ISBN:978-3-945238-40-0 Broschur, IDN:1206561718   \n",
       "1     ISBN:978-3-8353-3856-2 Festeinband : circa EUR...   \n",
       "2       ISBN:978-1-4907-9859-2 Broschur, IDN:1211201678   \n",
       "3     ISBN:978-3-945961-17-9 Broschur : EUR 15.00 (D...   \n",
       "4     ISBN:978-3-96588-040-5 Festeinband : EUR 17.80...   \n",
       "...                                                 ...   \n",
       "1317  ISBN:978-3-924313-01-2 Gewebe, 3-924313-01-6 G...   \n",
       "1318                          ISBN:kart., IDN:953951456   \n",
       "1319                          ISBN:kart., IDN:953951642   \n",
       "1320                       ISBN:Lei 6.50, IDN:36897345X   \n",
       "1321                          ISBN:kart., IDN:95513711X   \n",
       "\n",
       "                   ISBN_test        IDN_test  \n",
       "0     ISBN:978-3-945238-40-0  IDN:1206561718  \n",
       "1     ISBN:978-3-8353-3856-2  IDN:1213594154  \n",
       "2     ISBN:978-1-4907-9859-2  IDN:1211201678  \n",
       "3     ISBN:978-3-945961-17-9  IDN:1201301157  \n",
       "4     ISBN:978-3-96588-040-5  IDN:1221388894  \n",
       "...                      ...             ...  \n",
       "1317  ISBN:978-3-924313-01-2   IDN:971051135  \n",
       "1318             ISBN:kart.,   IDN:953951456  \n",
       "1319             ISBN:kart.,   IDN:953951642  \n",
       "1320                ISBN:Lei   IDN:36897345X  \n",
       "1321             ISBN:kart.,   IDN:95513711X  \n",
       "\n",
       "[1322 rows x 3 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>identifier</th>\n",
       "      <th>ISBN_test</th>\n",
       "      <th>IDN_test</th>\n",
       "      <th>ISBN</th>\n",
       "      <th>IDN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ISBN:978-3-945238-40-0 Broschur, IDN:1206561718</td>\n",
       "      <td>ISBN:978-3-945238-40-0</td>\n",
       "      <td>IDN:1206561718</td>\n",
       "      <td>978-3-945238-40-0</td>\n",
       "      <td>1206561718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ISBN:978-3-8353-3856-2 Festeinband : circa EUR...</td>\n",
       "      <td>ISBN:978-3-8353-3856-2</td>\n",
       "      <td>IDN:1213594154</td>\n",
       "      <td>978-3-8353-3856-2</td>\n",
       "      <td>1213594154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ISBN:978-1-4907-9859-2 Broschur, IDN:1211201678</td>\n",
       "      <td>ISBN:978-1-4907-9859-2</td>\n",
       "      <td>IDN:1211201678</td>\n",
       "      <td>978-1-4907-9859-2</td>\n",
       "      <td>1211201678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ISBN:978-3-945961-17-9 Broschur : EUR 15.00 (D...</td>\n",
       "      <td>ISBN:978-3-945961-17-9</td>\n",
       "      <td>IDN:1201301157</td>\n",
       "      <td>978-3-945961-17-9</td>\n",
       "      <td>1201301157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ISBN:978-3-96588-040-5 Festeinband : EUR 17.80...</td>\n",
       "      <td>ISBN:978-3-96588-040-5</td>\n",
       "      <td>IDN:1221388894</td>\n",
       "      <td>978-3-96588-040-5</td>\n",
       "      <td>1221388894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1317</th>\n",
       "      <td>ISBN:978-3-924313-01-2 Gewebe, 3-924313-01-6 G...</td>\n",
       "      <td>ISBN:978-3-924313-01-2</td>\n",
       "      <td>IDN:971051135</td>\n",
       "      <td>978-3-924313-01-2</td>\n",
       "      <td>971051135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1318</th>\n",
       "      <td>ISBN:kart., IDN:953951456</td>\n",
       "      <td>ISBN:kart.,</td>\n",
       "      <td>IDN:953951456</td>\n",
       "      <td>kart.,</td>\n",
       "      <td>953951456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1319</th>\n",
       "      <td>ISBN:kart., IDN:953951642</td>\n",
       "      <td>ISBN:kart.,</td>\n",
       "      <td>IDN:953951642</td>\n",
       "      <td>kart.,</td>\n",
       "      <td>953951642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1320</th>\n",
       "      <td>ISBN:Lei 6.50, IDN:36897345X</td>\n",
       "      <td>ISBN:Lei</td>\n",
       "      <td>IDN:36897345X</td>\n",
       "      <td>Lei</td>\n",
       "      <td>36897345X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1321</th>\n",
       "      <td>ISBN:kart., IDN:95513711X</td>\n",
       "      <td>ISBN:kart.,</td>\n",
       "      <td>IDN:95513711X</td>\n",
       "      <td>kart.,</td>\n",
       "      <td>95513711X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1322 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             identifier  \\\n",
       "0       ISBN:978-3-945238-40-0 Broschur, IDN:1206561718   \n",
       "1     ISBN:978-3-8353-3856-2 Festeinband : circa EUR...   \n",
       "2       ISBN:978-1-4907-9859-2 Broschur, IDN:1211201678   \n",
       "3     ISBN:978-3-945961-17-9 Broschur : EUR 15.00 (D...   \n",
       "4     ISBN:978-3-96588-040-5 Festeinband : EUR 17.80...   \n",
       "...                                                 ...   \n",
       "1317  ISBN:978-3-924313-01-2 Gewebe, 3-924313-01-6 G...   \n",
       "1318                          ISBN:kart., IDN:953951456   \n",
       "1319                          ISBN:kart., IDN:953951642   \n",
       "1320                       ISBN:Lei 6.50, IDN:36897345X   \n",
       "1321                          ISBN:kart., IDN:95513711X   \n",
       "\n",
       "                   ISBN_test        IDN_test               ISBN         IDN  \n",
       "0     ISBN:978-3-945238-40-0  IDN:1206561718  978-3-945238-40-0  1206561718  \n",
       "1     ISBN:978-3-8353-3856-2  IDN:1213594154  978-3-8353-3856-2  1213594154  \n",
       "2     ISBN:978-1-4907-9859-2  IDN:1211201678  978-1-4907-9859-2  1211201678  \n",
       "3     ISBN:978-3-945961-17-9  IDN:1201301157  978-3-945961-17-9  1201301157  \n",
       "4     ISBN:978-3-96588-040-5  IDN:1221388894  978-3-96588-040-5  1221388894  \n",
       "...                      ...             ...                ...         ...  \n",
       "1317  ISBN:978-3-924313-01-2   IDN:971051135  978-3-924313-01-2   971051135  \n",
       "1318             ISBN:kart.,   IDN:953951456             kart.,   953951456  \n",
       "1319             ISBN:kart.,   IDN:953951642             kart.,   953951642  \n",
       "1320                ISBN:Lei   IDN:36897345X                Lei   36897345X  \n",
       "1321             ISBN:kart.,   IDN:95513711X             kart.,   95513711X  \n",
       "\n",
       "[1322 rows x 5 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Einfügen neuer Spalten \"ISBN\" und \"IDN\", in dem die Spalten \"ISBN_test\" und \"IDN_test\" übernommen, aber in deren \n",
    "#Inhaltstext die Buchstaben \"ISBN:\" bzw. \"IDN:\" entfernt werden: \n",
    "\n",
    "df_id['ISBN'] = df_id['ISBN_test'].str.replace('ISBN:', '')\n",
    "df_id['IDN'] = df_id['IDN_test'].str.replace('IDN:', '')\n",
    "df_id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>ISBN</th>\n",
       "      <th>IDN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>978-3-945238-40-0</td>\n",
       "      <td>1206561718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>978-3-8353-3856-2</td>\n",
       "      <td>1213594154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>978-1-4907-9859-2</td>\n",
       "      <td>1211201678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>978-3-945961-17-9</td>\n",
       "      <td>1201301157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>978-3-96588-040-5</td>\n",
       "      <td>1221388894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1317</th>\n",
       "      <td>978-3-924313-01-2</td>\n",
       "      <td>971051135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1318</th>\n",
       "      <td>kart.,</td>\n",
       "      <td>953951456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1319</th>\n",
       "      <td>kart.,</td>\n",
       "      <td>953951642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1320</th>\n",
       "      <td>Lei</td>\n",
       "      <td>36897345X</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1321</th>\n",
       "      <td>kart.,</td>\n",
       "      <td>95513711X</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1322 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   ISBN         IDN\n",
       "0     978-3-945238-40-0  1206561718\n",
       "1     978-3-8353-3856-2  1213594154\n",
       "2     978-1-4907-9859-2  1211201678\n",
       "3     978-3-945961-17-9  1201301157\n",
       "4     978-3-96588-040-5  1221388894\n",
       "...                 ...         ...\n",
       "1317  978-3-924313-01-2   971051135\n",
       "1318             kart.,   953951456\n",
       "1319             kart.,   953951642\n",
       "1320                Lei   36897345X\n",
       "1321             kart.,   95513711X\n",
       "\n",
       "[1322 rows x 2 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Entfernen der Spalten \"identifier\", \"ISBN_test\" und \"IDN_test\":\n",
    "\n",
    "df_id = df_id.drop(columns=['identifier', 'ISBN_test', 'IDN_test'])\n",
    "df_id"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Da das ursprüngliche Dataframe bereits eine Spalte \"ISBN\" enthält, vergleichen wir nun die Angaben der bereits vorhandenen Spalte mit den von uns aus der Spalte \"identifier\" gefilterten Informationen zur ISBN: "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True     1129\n",
       "False     193\n",
       "Name: ISBN, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['ISBN'].isin(df_id['ISBN']).value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Wir sehen, dass es in einigen Fällen Unterschiede gibt und die Spalten leider nicht immer identisch sind. Wir entscheiden uns daher hier dafür, die ursprünglich enthaltenen Spalte \"ISBN\" beizubehalten, jedoch eine neue Spalte, die wir \"ISBN_new\" nennen werden, hinzuzufügen, die den ISBN-Text aus dem Feld \"identifier\" enthalten wird: "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>Unnamed: 0</th>\n",
       "      <th>subject</th>\n",
       "      <th>identifier</th>\n",
       "      <th>ISBN_new</th>\n",
       "      <th>IDN</th>\n",
       "      <th>type</th>\n",
       "      <th>creator</th>\n",
       "      <th>title</th>\n",
       "      <th>volume</th>\n",
       "      <th>edition</th>\n",
       "      <th>...</th>\n",
       "      <th>description</th>\n",
       "      <th>collective.title</th>\n",
       "      <th>links</th>\n",
       "      <th>relation</th>\n",
       "      <th>rights</th>\n",
       "      <th>subject.headings</th>\n",
       "      <th>connected.titles</th>\n",
       "      <th>uniform.title</th>\n",
       "      <th>frequency</th>\n",
       "      <th>wv.number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31</td>\n",
       "      <td>830 Deutsche Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-3-945238-40-0 Broschur, IDN:1206561718</td>\n",
       "      <td>978-3-945238-40-0</td>\n",
       "      <td>1206561718</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Trelenberg, Thorsten [Verfasser]</td>\n",
       "      <td>Auf der Suche nach dem Zauberwort = V poiskach...</td>\n",
       "      <td>NaN</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>20,A18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>71</td>\n",
       "      <td>830 Deutsche Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-3-8353-3856-2 Festeinband : circa EUR...</td>\n",
       "      <td>978-3-8353-3856-2</td>\n",
       "      <td>1213594154</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Erb, Elke [Verfasser] ; Anderson, Shane [Übers...</td>\n",
       "      <td>Das Gedicht ist, was es tut : deutsch - englis...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Berliner Rede zur Poesie ; 2018</td>\n",
       "      <td>Inhaltstext [http://deposit.dnb.de/cgi-bin/dok...</td>\n",
       "      <td>http://d-nb.info/1114525014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Erscheint auch als: ISBN: 9783835332614</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20,N29 , 21,A08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>72</td>\n",
       "      <td>830 Deutsche Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-1-4907-9859-2 Broschur, IDN:1211201678</td>\n",
       "      <td>978-1-4907-9859-2</td>\n",
       "      <td>1211201678</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mohnnau, Ralph Günther [Verfasser] ; Martin, C...</td>\n",
       "      <td>[Tag um Tag faltet sich die Zeit] ; Day by day...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bi-lingual edition</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>Tag um Tag faltet sich die Zeit</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20,B25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>96</td>\n",
       "      <td>820 Englische Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-3-945961-17-9 Broschur : EUR 15.00 (D...</td>\n",
       "      <td>978-3-945961-17-9</td>\n",
       "      <td>1201301157</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Daly, Leo [Verfasser] ; Soppa, Chris Inken [Üb...</td>\n",
       "      <td>[The rock garden] ; Der Felsengarten : Stimmen...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[1. Auflage]</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Edition Karo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The rock garden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19,N51 , 20,A32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>97</td>\n",
       "      <td>810 Englische Literatur Amerikas ; B Belletristik</td>\n",
       "      <td>ISBN:978-3-96588-040-5 Festeinband : EUR 17.80...</td>\n",
       "      <td>978-3-96588-040-5</td>\n",
       "      <td>1221388894</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Larson, R. J. Verfasser] ; [Wolf, Alexandra [Ü...</td>\n",
       "      <td>[Judge] ; Der Richter : Roman / R. J. Larson ;...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1. Auflage</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bücher des Ewigen : Verfasser : 2019 ; Band 2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://d-nb.info/1201559065</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Judge</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20,N47 , 21,A05</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>1317</th>\n",
       "      <td>35929</td>\n",
       "      <td>2303 Belletristik; 830 Deutsche Literatur ; B ...</td>\n",
       "      <td>ISBN:978-3-924313-01-2 Gewebe, 3-924313-01-6 G...</td>\n",
       "      <td>978-3-924313-01-2</td>\n",
       "      <td>971051135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Uhlenköpereien : die Geschichte vom Uhlenköper...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Inhaltsverzeichnis [http://d-nb.info/971051135...</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>94,P01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1318</th>\n",
       "      <td>35935</td>\n",
       "      <td>59 Belletristik</td>\n",
       "      <td>ISBN:kart., IDN:953951456</td>\n",
       "      <td>kart.,</td>\n",
       "      <td>953951456</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wendt, Albert [Verfasser]</td>\n",
       "      <td>Mein dicker Mantel : Hörspiel ; [Prix Italia 1...</td>\n",
       "      <td>NaN</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>94,P01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1319</th>\n",
       "      <td>35936</td>\n",
       "      <td>59 Belletristik</td>\n",
       "      <td>ISBN:kart., IDN:953951642</td>\n",
       "      <td>kart.,</td>\n",
       "      <td>953951642</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wendt, Albert [Verfasser]</td>\n",
       "      <td>Mein dicker Mantel : Hörspiel ; [Prix Italia 1...</td>\n",
       "      <td>NaN</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>94,P01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1320</th>\n",
       "      <td>35953</td>\n",
       "      <td>830 Deutsche Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:Lei 6.50, IDN:36897345X</td>\n",
       "      <td>Lei</td>\n",
       "      <td>36897345X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hofmannsthal, Hugo von [Verfasser]</td>\n",
       "      <td>Poezii / Hugo von Hofmannsthal. Trad. şi cuvîn...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Orfeu</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gedichte</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04,L01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1321</th>\n",
       "      <td>35960</td>\n",
       "      <td>59 Belletristik</td>\n",
       "      <td>ISBN:kart., IDN:95513711X</td>\n",
       "      <td>kart.,</td>\n",
       "      <td>95513711X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Scholz-Amoulong, Sieglinde [Verfasser]</td>\n",
       "      <td>Diagnose: Dringender Kinderwunsch : O-Ton ; Er...</td>\n",
       "      <td>NaN</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>94,P01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1322 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                                            subject  \\\n",
       "0             31            830 Deutsche Literatur ; B Belletristik   \n",
       "1             71            830 Deutsche Literatur ; B Belletristik   \n",
       "2             72            830 Deutsche Literatur ; B Belletristik   \n",
       "3             96           820 Englische Literatur ; B Belletristik   \n",
       "4             97  810 Englische Literatur Amerikas ; B Belletristik   \n",
       "...          ...                                                ...   \n",
       "1317       35929  2303 Belletristik; 830 Deutsche Literatur ; B ...   \n",
       "1318       35935                                    59 Belletristik   \n",
       "1319       35936                                    59 Belletristik   \n",
       "1320       35953            830 Deutsche Literatur ; B Belletristik   \n",
       "1321       35960                                    59 Belletristik   \n",
       "\n",
       "                                             identifier           ISBN_new  \\\n",
       "0       ISBN:978-3-945238-40-0 Broschur, IDN:1206561718  978-3-945238-40-0   \n",
       "1     ISBN:978-3-8353-3856-2 Festeinband : circa EUR...  978-3-8353-3856-2   \n",
       "2       ISBN:978-1-4907-9859-2 Broschur, IDN:1211201678  978-1-4907-9859-2   \n",
       "3     ISBN:978-3-945961-17-9 Broschur : EUR 15.00 (D...  978-3-945961-17-9   \n",
       "4     ISBN:978-3-96588-040-5 Festeinband : EUR 17.80...  978-3-96588-040-5   \n",
       "...                                                 ...                ...   \n",
       "1317  ISBN:978-3-924313-01-2 Gewebe, 3-924313-01-6 G...  978-3-924313-01-2   \n",
       "1318                          ISBN:kart., IDN:953951456             kart.,   \n",
       "1319                          ISBN:kart., IDN:953951642             kart.,   \n",
       "1320                       ISBN:Lei 6.50, IDN:36897345X                Lei   \n",
       "1321                          ISBN:kart., IDN:95513711X             kart.,   \n",
       "\n",
       "             IDN type                                            creator  \\\n",
       "0     1206561718  NaN                   Trelenberg, Thorsten [Verfasser]   \n",
       "1     1213594154  NaN  Erb, Elke [Verfasser] ; Anderson, Shane [Übers...   \n",
       "2     1211201678  NaN  Mohnnau, Ralph Günther [Verfasser] ; Martin, C...   \n",
       "3     1201301157  NaN  Daly, Leo [Verfasser] ; Soppa, Chris Inken [Üb...   \n",
       "4     1221388894  NaN  Larson, R. J. Verfasser] ; [Wolf, Alexandra [Ü...   \n",
       "...          ...  ...                                                ...   \n",
       "1317   971051135  NaN                                                NaN   \n",
       "1318   953951456  NaN                          Wendt, Albert [Verfasser]   \n",
       "1319   953951642  NaN                          Wendt, Albert [Verfasser]   \n",
       "1320   36897345X  NaN                 Hofmannsthal, Hugo von [Verfasser]   \n",
       "1321   95513711X  NaN             Scholz-Amoulong, Sieglinde [Verfasser]   \n",
       "\n",
       "                                                  title volume  \\\n",
       "0     Auf der Suche nach dem Zauberwort = V poiskach...    NaN   \n",
       "1     Das Gedicht ist, was es tut : deutsch - englis...    NaN   \n",
       "2     [Tag um Tag faltet sich die Zeit] ; Day by day...    NaN   \n",
       "3     [The rock garden] ; Der Felsengarten : Stimmen...    NaN   \n",
       "4     [Judge] ; Der Richter : Roman / R. J. Larson ;...    NaN   \n",
       "...                                                 ...    ...   \n",
       "1317  Uhlenköpereien : die Geschichte vom Uhlenköper...    NaN   \n",
       "1318  Mein dicker Mantel : Hörspiel ; [Prix Italia 1...    NaN   \n",
       "1319  Mein dicker Mantel : Hörspiel ; [Prix Italia 1...    NaN   \n",
       "1320  Poezii / Hugo von Hofmannsthal. Trad. şi cuvîn...    NaN   \n",
       "1321  Diagnose: Dringender Kinderwunsch : O-Ton ; Er...    NaN   \n",
       "\n",
       "                 edition  ... description  \\\n",
       "0                    NaN  ...         NaN   \n",
       "1                    NaN  ...         NaN   \n",
       "2     Bi-lingual edition  ...         NaN   \n",
       "3           [1. Auflage]  ...         NaN   \n",
       "4             1. Auflage  ...         NaN   \n",
       "...                  ...  ...         ...   \n",
       "1317                 NaN  ...         NaN   \n",
       "1318                 NaN  ...         NaN   \n",
       "1319                 NaN  ...         NaN   \n",
       "1320                 NaN  ...         NaN   \n",
       "1321                 NaN  ...         NaN   \n",
       "\n",
       "                                   collective.title  \\\n",
       "0                                               NaN   \n",
       "1                   Berliner Rede zur Poesie ; 2018   \n",
       "2                                               NaN   \n",
       "3                                      Edition Karo   \n",
       "4     Bücher des Ewigen : Verfasser : 2019 ; Band 2   \n",
       "...                                             ...   \n",
       "1317                                            NaN   \n",
       "1318                                            NaN   \n",
       "1319                                            NaN   \n",
       "1320                                          Orfeu   \n",
       "1321                                            NaN   \n",
       "\n",
       "                                                  links  \\\n",
       "0                                                   NaN   \n",
       "1     Inhaltstext [http://deposit.dnb.de/cgi-bin/dok...   \n",
       "2                                                   NaN   \n",
       "3                                                   NaN   \n",
       "4                                                   NaN   \n",
       "...                                                 ...   \n",
       "1317  Inhaltsverzeichnis [http://d-nb.info/971051135...   \n",
       "1318                                                NaN   \n",
       "1319                                                NaN   \n",
       "1320                                                NaN   \n",
       "1321                                                NaN   \n",
       "\n",
       "                         relation rights  subject.headings  \\\n",
       "0                             NaN    NaN               NaN   \n",
       "1     http://d-nb.info/1114525014    NaN               NaN   \n",
       "2                             NaN    NaN               NaN   \n",
       "3                             NaN    NaN               NaN   \n",
       "4     http://d-nb.info/1201559065    NaN               NaN   \n",
       "...                           ...    ...               ...   \n",
       "1317                          NaN    NaN               NaN   \n",
       "1318                          NaN    NaN               NaN   \n",
       "1319                          NaN    NaN               NaN   \n",
       "1320                          NaN    NaN               NaN   \n",
       "1321                          NaN    NaN               NaN   \n",
       "\n",
       "                             connected.titles  \\\n",
       "0                                         NaN   \n",
       "1     Erscheint auch als: ISBN: 9783835332614   \n",
       "2                                         NaN   \n",
       "3                                         NaN   \n",
       "4                                         NaN   \n",
       "...                                       ...   \n",
       "1317                                      NaN   \n",
       "1318                                      NaN   \n",
       "1319                                      NaN   \n",
       "1320                                      NaN   \n",
       "1321                                      NaN   \n",
       "\n",
       "                        uniform.title frequency        wv.number  \n",
       "0                                 NaN       NaN           20,A18  \n",
       "1                                 NaN       NaN  20,N29 , 21,A08  \n",
       "2     Tag um Tag faltet sich die Zeit       NaN           20,B25  \n",
       "3                     The rock garden       NaN  19,N51 , 20,A32  \n",
       "4                               Judge       NaN  20,N47 , 21,A05  \n",
       "...                               ...       ...              ...  \n",
       "1317                              NaN       NaN           94,P01  \n",
       "1318                              NaN       NaN           94,P01  \n",
       "1319                              NaN       NaN           94,P01  \n",
       "1320                         Gedichte       NaN           04,L01  \n",
       "1321                              NaN       NaN           94,P01  \n",
       "\n",
       "[1322 rows x 31 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Ergänze Spalten \"ISBN\" und \"IDN\" im ursprünglichen Dataframe: \n",
    "\n",
    "df.insert(loc=3, column='ISBN_new', value=df_id['ISBN'])\n",
    "df.insert(loc=4, column='IDN', value=df_id['IDN'])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"alldnb_bilingual_ger_id.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Damit ist unser Dataframe und unsere neue CSV-Datei vorbereitet, da wir nun separate Spalten für die IDN sowie die ISBN haben. \n",
    "\n",
    "    *\n",
    "    *\n",
    "    *\n",
    "\n",
    "\n",
    "Falls uns weiterhin interessiert, an welchen Stellen der beiden Dataframes für die ISBNs die Unterschiede bestehen, können wir die beiden Dataframes anhand der Spalten \"ISBN\" zusammenführen und uns im Anschluss die Einträge anzeigen lassen, an denen die ISBNs nicht übereinstimmten: "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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>Unnamed: 0</th>\n",
       "      <th>subject</th>\n",
       "      <th>identifier</th>\n",
       "      <th>ISBN_new</th>\n",
       "      <th>IDN_x</th>\n",
       "      <th>type</th>\n",
       "      <th>creator</th>\n",
       "      <th>title</th>\n",
       "      <th>volume</th>\n",
       "      <th>edition</th>\n",
       "      <th>...</th>\n",
       "      <th>links</th>\n",
       "      <th>relation</th>\n",
       "      <th>rights</th>\n",
       "      <th>subject.headings</th>\n",
       "      <th>connected.titles</th>\n",
       "      <th>uniform.title</th>\n",
       "      <th>frequency</th>\n",
       "      <th>wv.number</th>\n",
       "      <th>IDN_y</th>\n",
       "      <th>Exist</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3193</th>\n",
       "      <td>2262.0</td>\n",
       "      <td>820 Englische Literatur ; B Belletristik</td>\n",
       "      <td>URN:urn:nbn:de:101:1-2018102919301908361659, U...</td>\n",
       "      <td>978-3-455-00337-6,</td>\n",
       "      <td>1170120938</td>\n",
       "      <td>Online-Ressource</td>\n",
       "      <td>Christie, Agatha [Verfasser] ; Bandini, Giovan...</td>\n",
       "      <td>Morphium / Agatha Christie</td>\n",
       "      <td>NaN</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>Erscheint auch als Agatha Christie: Morphium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18,O11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3290</th>\n",
       "      <td>5871.0</td>\n",
       "      <td>830 Deutsche Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-3-650-40114-4, 3-650-40114-2, 978-3-6...</td>\n",
       "      <td>978-3-650-40114-4,</td>\n",
       "      <td>107649868X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grimm, Jacob [Herausgeber] ; Schlosser, Franz ...</td>\n",
       "      <td>Et nisi mortui sunt ... : die 12 schönsten Mär...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Erw. Aufl.</td>\n",
       "      <td>...</td>\n",
       "      <td>Inhaltsverzeichnis [http://d-nb.info/107649868...</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>15,A40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3441</th>\n",
       "      <td>10609.0</td>\n",
       "      <td>830 Deutsche Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-985-02-1322-8, IDN:1030349673</td>\n",
       "      <td>978-985-02-1322-8,</td>\n",
       "      <td>1030349673</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lasonchyk, R. [Verfasser]</td>\n",
       "      <td>In fremdem Welten : Gegenwartsliteratur aus De...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Inhaltsverzeichnis [http://d-nb.info/103034967...</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>13,A15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3491</th>\n",
       "      <td>11924.0</td>\n",
       "      <td>880 Griechische Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-3-257-06793-4, 978-3-257-06793-4Geweb...</td>\n",
       "      <td>978-3-257-06793-4,</td>\n",
       "      <td>101179523X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Markarēs, Petros [Verfasser] ; Prinzinger, Mic...</td>\n",
       "      <td>Faule Kredite : ein Fall für Kostas Charitos ;...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Inhaltstext [http://deposit.dnb.de/cgi-bin/dok...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lēxiprothesma daneia &lt;dt.&gt;</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11,N21 , 11,A32</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3637</th>\n",
       "      <td>14909.0</td>\n",
       "      <td>830 Deutsche Literatur ; B Belletristik</td>\n",
       "      <td>ISBN:978-3-8291-2283-2, IDN:993586260</td>\n",
       "      <td>978-3-8291-2283-2,</td>\n",
       "      <td>993586260</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andersen, Hans Christian [Mitwirkender] ; Goet...</td>\n",
       "      <td>Marianne Hoppe spricht Andersen, Goethe und Dr...</td>\n",
       "      <td>NaN</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>09,A17,2173</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</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>4460</th>\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",
       "      <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>963752103</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4461</th>\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",
       "      <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>1079247483</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4462</th>\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",
       "      <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>950666475</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4463</th>\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",
       "      <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>1013905601</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4464</th>\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",
       "      <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>36897345X</td>\n",
       "      <td>right_only</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>186 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                                     subject  \\\n",
       "3193      2262.0    820 Englische Literatur ; B Belletristik   \n",
       "3290      5871.0     830 Deutsche Literatur ; B Belletristik   \n",
       "3441     10609.0     830 Deutsche Literatur ; B Belletristik   \n",
       "3491     11924.0  880 Griechische Literatur ; B Belletristik   \n",
       "3637     14909.0     830 Deutsche Literatur ; B Belletristik   \n",
       "...          ...                                         ...   \n",
       "4460         NaN                                         NaN   \n",
       "4461         NaN                                         NaN   \n",
       "4462         NaN                                         NaN   \n",
       "4463         NaN                                         NaN   \n",
       "4464         NaN                                         NaN   \n",
       "\n",
       "                                             identifier            ISBN_new  \\\n",
       "3193  URN:urn:nbn:de:101:1-2018102919301908361659, U...  978-3-455-00337-6,   \n",
       "3290  ISBN:978-3-650-40114-4, 3-650-40114-2, 978-3-6...  978-3-650-40114-4,   \n",
       "3441             ISBN:978-985-02-1322-8, IDN:1030349673  978-985-02-1322-8,   \n",
       "3491  ISBN:978-3-257-06793-4, 978-3-257-06793-4Geweb...  978-3-257-06793-4,   \n",
       "3637              ISBN:978-3-8291-2283-2, IDN:993586260  978-3-8291-2283-2,   \n",
       "...                                                 ...                 ...   \n",
       "4460                                                NaN                 NaN   \n",
       "4461                                                NaN                 NaN   \n",
       "4462                                                NaN                 NaN   \n",
       "4463                                                NaN                 NaN   \n",
       "4464                                                NaN                 NaN   \n",
       "\n",
       "           IDN_x              type  \\\n",
       "3193  1170120938  Online-Ressource   \n",
       "3290  107649868X               NaN   \n",
       "3441  1030349673               NaN   \n",
       "3491  101179523X               NaN   \n",
       "3637   993586260               NaN   \n",
       "...          ...               ...   \n",
       "4460         NaN               NaN   \n",
       "4461         NaN               NaN   \n",
       "4462         NaN               NaN   \n",
       "4463         NaN               NaN   \n",
       "4464         NaN               NaN   \n",
       "\n",
       "                                                creator  \\\n",
       "3193  Christie, Agatha [Verfasser] ; Bandini, Giovan...   \n",
       "3290  Grimm, Jacob [Herausgeber] ; Schlosser, Franz ...   \n",
       "3441                          Lasonchyk, R. [Verfasser]   \n",
       "3491  Markarēs, Petros [Verfasser] ; Prinzinger, Mic...   \n",
       "3637  Andersen, Hans Christian [Mitwirkender] ; Goet...   \n",
       "...                                                 ...   \n",
       "4460                                                NaN   \n",
       "4461                                                NaN   \n",
       "4462                                                NaN   \n",
       "4463                                                NaN   \n",
       "4464                                                NaN   \n",
       "\n",
       "                                                  title volume     edition  \\\n",
       "3193                         Morphium / Agatha Christie    NaN         NaN   \n",
       "3290  Et nisi mortui sunt ... : die 12 schönsten Mär...    NaN  Erw. Aufl.   \n",
       "3441  In fremdem Welten : Gegenwartsliteratur aus De...    NaN         NaN   \n",
       "3491  Faule Kredite : ein Fall für Kostas Charitos ;...    NaN         NaN   \n",
       "3637  Marianne Hoppe spricht Andersen, Goethe und Dr...    NaN         NaN   \n",
       "...                                                 ...    ...         ...   \n",
       "4460                                                NaN    NaN         NaN   \n",
       "4461                                                NaN    NaN         NaN   \n",
       "4462                                                NaN    NaN         NaN   \n",
       "4463                                                NaN    NaN         NaN   \n",
       "4464                                                NaN    NaN         NaN   \n",
       "\n",
       "      ...                                              links  relation rights  \\\n",
       "3193  ...                                                NaN       NaN    NaN   \n",
       "3290  ...  Inhaltsverzeichnis [http://d-nb.info/107649868...       NaN    NaN   \n",
       "3441  ...  Inhaltsverzeichnis [http://d-nb.info/103034967...       NaN    NaN   \n",
       "3491  ...  Inhaltstext [http://deposit.dnb.de/cgi-bin/dok...       NaN    NaN   \n",
       "3637  ...                                                NaN       NaN    NaN   \n",
       "...   ...                                                ...       ...    ...   \n",
       "4460  ...                                                NaN       NaN    NaN   \n",
       "4461  ...                                                NaN       NaN    NaN   \n",
       "4462  ...                                                NaN       NaN    NaN   \n",
       "4463  ...                                                NaN       NaN    NaN   \n",
       "4464  ...                                                NaN       NaN    NaN   \n",
       "\n",
       "     subject.headings                              connected.titles  \\\n",
       "3193              NaN  Erscheint auch als Agatha Christie: Morphium   \n",
       "3290              NaN                                           NaN   \n",
       "3441              NaN                                           NaN   \n",
       "3491              NaN                                           NaN   \n",
       "3637              NaN                                           NaN   \n",
       "...               ...                                           ...   \n",
       "4460              NaN                                           NaN   \n",
       "4461              NaN                                           NaN   \n",
       "4462              NaN                                           NaN   \n",
       "4463              NaN                                           NaN   \n",
       "4464              NaN                                           NaN   \n",
       "\n",
       "                   uniform.title  frequency        wv.number       IDN_y  \\\n",
       "3193                         NaN        NaN           18,O11         NaN   \n",
       "3290                         NaN        NaN           15,A40         NaN   \n",
       "3441                         NaN        NaN           13,A15         NaN   \n",
       "3491  Lēxiprothesma daneia <dt.>        NaN  11,N21 , 11,A32         NaN   \n",
       "3637                         NaN        NaN      09,A17,2173         NaN   \n",
       "...                          ...        ...              ...         ...   \n",
       "4460                         NaN        NaN              NaN   963752103   \n",
       "4461                         NaN        NaN              NaN  1079247483   \n",
       "4462                         NaN        NaN              NaN   950666475   \n",
       "4463                         NaN        NaN              NaN  1013905601   \n",
       "4464                         NaN        NaN              NaN   36897345X   \n",
       "\n",
       "           Exist  \n",
       "3193   left_only  \n",
       "3290   left_only  \n",
       "3441   left_only  \n",
       "3491   left_only  \n",
       "3637   left_only  \n",
       "...          ...  \n",
       "4460  right_only  \n",
       "4461  right_only  \n",
       "4462  right_only  \n",
       "4463  right_only  \n",
       "4464  right_only  \n",
       "\n",
       "[186 rows x 33 columns]"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "df_diff  = pd.merge(df, df_id, on=\"ISBN\", how='outer', indicator='Exist')\n",
    "df_diff  = df_diff.loc[df_diff['Exist'] != 'both']\n",
    "df_diff"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}