Roles, Profession, or Commodity_ .ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "ASSs7OObJlwm"
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "2iE7Gj55KRK0"
   },
   "outputs": [],
   "source": [
    "filtered = pd.read_csv(\"filtered (1).csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 1000
    },
    "colab_type": "code",
    "id": "-Os_MNkrFPHK",
    "outputId": "623aece3-18e3-4aa7-ff9e-33bd09130a16"
   },
   "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>lemma</th>\n",
       "      <th>id_text</th>\n",
       "      <th>id_line</th>\n",
       "      <th>id_word</th>\n",
       "      <th>label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>3(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>3</td>\n",
       "      <td>P124149.3.1</td>\n",
       "      <td>o 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>udu[sheep]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>3</td>\n",
       "      <td>P124149.3.2</td>\n",
       "      <td>o 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>6(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>4</td>\n",
       "      <td>P124149.4.1</td>\n",
       "      <td>o 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>u[ewe]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>4</td>\n",
       "      <td>P124149.4.2</td>\n",
       "      <td>o 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>5</td>\n",
       "      <td>P124149.5.1</td>\n",
       "      <td>o 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>mašgal[goat]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>5</td>\n",
       "      <td>P124149.5.2</td>\n",
       "      <td>o 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>šugid[~animal]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>6</td>\n",
       "      <td>P124149.6.1</td>\n",
       "      <td>o 4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>emuhaldim[kitchen]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>6</td>\n",
       "      <td>P124149.6.2</td>\n",
       "      <td>o 4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>mu[name]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>7</td>\n",
       "      <td>P124149.7.1</td>\n",
       "      <td>o 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>gardu[soldier]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>7</td>\n",
       "      <td>P124149.7.2</td>\n",
       "      <td>o 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>šag[heart]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>9</td>\n",
       "      <td>P124149.9.1</td>\n",
       "      <td>r 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>tum-ma-al{ki}[]GN</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>9</td>\n",
       "      <td>P124149.9.2</td>\n",
       "      <td>r 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>ud[sun]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>10</td>\n",
       "      <td>P124149.10.1</td>\n",
       "      <td>r 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>1(u)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>10</td>\n",
       "      <td>P124149.10.2</td>\n",
       "      <td>r 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>5(diš@t)-kam[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>10</td>\n",
       "      <td>P124149.10.3</td>\n",
       "      <td>r 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>ki[place]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>11</td>\n",
       "      <td>P124149.11.1</td>\n",
       "      <td>r 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>du₁₁-ga-ta[NA]NA</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>11</td>\n",
       "      <td>P124149.11.2</td>\n",
       "      <td>r 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>zig[rise]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>12</td>\n",
       "      <td>P124149.12.1</td>\n",
       "      <td>r 4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>itud[moon]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>13</td>\n",
       "      <td>P124149.13.1</td>\n",
       "      <td>r 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>šu-eš₅-ša[]MN</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>13</td>\n",
       "      <td>P124149.13.2</td>\n",
       "      <td>r 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>mu[name]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>14</td>\n",
       "      <td>P124149.14.1</td>\n",
       "      <td>r 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>en[priest]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>14</td>\n",
       "      <td>P124149.14.2</td>\n",
       "      <td>r 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>eridu{ki}[]GN</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>14</td>\n",
       "      <td>P124149.14.3</td>\n",
       "      <td>r 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>huŋ[hire]V/t</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>14</td>\n",
       "      <td>P124149.14.4</td>\n",
       "      <td>r 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>1(u)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>16</td>\n",
       "      <td>P124149.16.1</td>\n",
       "      <td>l.e. 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>1(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>16</td>\n",
       "      <td>P124149.16.2</td>\n",
       "      <td>l.e. 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>173</td>\n",
       "      <td>1(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P405489</td>\n",
       "      <td>3</td>\n",
       "      <td>P405489.3.1</td>\n",
       "      <td>o 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>174</td>\n",
       "      <td>gud[ox]N</td>\n",
       "      <td>epsd2/admin/u3adm/P405489</td>\n",
       "      <td>3</td>\n",
       "      <td>P405489.3.2</td>\n",
       "      <td>o 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>175</td>\n",
       "      <td>niga[fattened]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P405489</td>\n",
       "      <td>3</td>\n",
       "      <td>P405489.3.3</td>\n",
       "      <td>o 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>176</td>\n",
       "      <td>1(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P405489</td>\n",
       "      <td>4</td>\n",
       "      <td>P405489.4.1</td>\n",
       "      <td>o 2</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>449</td>\n",
       "      <td>us[side]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>4</td>\n",
       "      <td>P332036.4.5</td>\n",
       "      <td>o i 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>450</td>\n",
       "      <td>1(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>5</td>\n",
       "      <td>P332036.5.1</td>\n",
       "      <td>o i 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>451</td>\n",
       "      <td>gud[ox]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>5</td>\n",
       "      <td>P332036.5.2</td>\n",
       "      <td>o i 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>452</td>\n",
       "      <td>niga[fattened]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>5</td>\n",
       "      <td>P332036.5.3</td>\n",
       "      <td>o i 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>453</td>\n",
       "      <td>3(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>6</td>\n",
       "      <td>P332036.6.1</td>\n",
       "      <td>o i 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>454</td>\n",
       "      <td>udu[sheep]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>6</td>\n",
       "      <td>P332036.6.2</td>\n",
       "      <td>o i 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>455</td>\n",
       "      <td>niga[fattened]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>6</td>\n",
       "      <td>P332036.6.3</td>\n",
       "      <td>o i 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>456</td>\n",
       "      <td>3(diš)-kam[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>6</td>\n",
       "      <td>P332036.6.4</td>\n",
       "      <td>o i 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>457</td>\n",
       "      <td>us[side]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>6</td>\n",
       "      <td>P332036.6.5</td>\n",
       "      <td>o i 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>458</td>\n",
       "      <td>2(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>7</td>\n",
       "      <td>P332036.7.1</td>\n",
       "      <td>o i 4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>459</td>\n",
       "      <td>udu[sheep]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>7</td>\n",
       "      <td>P332036.7.2</td>\n",
       "      <td>o i 4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>460</td>\n",
       "      <td>niga[fattened]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>7</td>\n",
       "      <td>P332036.7.3</td>\n",
       "      <td>o i 4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>461</td>\n",
       "      <td>4(diš)-kam[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>7</td>\n",
       "      <td>P332036.7.4</td>\n",
       "      <td>o i 4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>462</td>\n",
       "      <td>us[side]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>7</td>\n",
       "      <td>P332036.7.5</td>\n",
       "      <td>o i 4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>463</td>\n",
       "      <td>8(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>8</td>\n",
       "      <td>P332036.8.1</td>\n",
       "      <td>o i 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>464</td>\n",
       "      <td>udu[sheep]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>8</td>\n",
       "      <td>P332036.8.2</td>\n",
       "      <td>o i 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>465</td>\n",
       "      <td>u[grass]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>8</td>\n",
       "      <td>P332036.8.3</td>\n",
       "      <td>o i 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>466</td>\n",
       "      <td>1(u)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>9</td>\n",
       "      <td>P332036.9.1</td>\n",
       "      <td>o i 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>467</td>\n",
       "      <td>mašgal[goat]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>9</td>\n",
       "      <td>P332036.9.2</td>\n",
       "      <td>o i 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>468</td>\n",
       "      <td>u[grass]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>9</td>\n",
       "      <td>P332036.9.3</td>\n",
       "      <td>o i 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>469</td>\n",
       "      <td>1(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>10</td>\n",
       "      <td>P332036.10.1</td>\n",
       "      <td>o i 7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>470</td>\n",
       "      <td>sila[lamb]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>10</td>\n",
       "      <td>P332036.10.2</td>\n",
       "      <td>o i 7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>471</td>\n",
       "      <td>{d}utu-ba-ni[]PN</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>11</td>\n",
       "      <td>P332036.11.1</td>\n",
       "      <td>o i 8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>472</td>\n",
       "      <td>2(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>12</td>\n",
       "      <td>P332036.12.1</td>\n",
       "      <td>o i 9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>473</td>\n",
       "      <td>gud[ox]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>12</td>\n",
       "      <td>P332036.12.2</td>\n",
       "      <td>o i 9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>474</td>\n",
       "      <td>niga[fattened]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>12</td>\n",
       "      <td>P332036.12.3</td>\n",
       "      <td>o i 9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>475</td>\n",
       "      <td>1(u)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>13</td>\n",
       "      <td>P332036.13.1</td>\n",
       "      <td>o i 10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>476</td>\n",
       "      <td>4(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>13</td>\n",
       "      <td>P332036.13.2</td>\n",
       "      <td>o i 10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>477</td>\n",
       "      <td>udu[sheep]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>13</td>\n",
       "      <td>P332036.13.3</td>\n",
       "      <td>o i 10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>478</td>\n",
       "      <td>u[grass]N</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>13</td>\n",
       "      <td>P332036.13.4</td>\n",
       "      <td>o i 10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0                lemma                    id_text  id_line  \\\n",
       "0            0           3(diš)[]NU  epsd2/admin/u3adm/P124149        3   \n",
       "1            1          udu[sheep]N  epsd2/admin/u3adm/P124149        3   \n",
       "2            2           6(diš)[]NU  epsd2/admin/u3adm/P124149        4   \n",
       "3            3              u[ewe]N  epsd2/admin/u3adm/P124149        4   \n",
       "4            4           2(diš)[]NU  epsd2/admin/u3adm/P124149        5   \n",
       "5            5        mašgal[goat]N  epsd2/admin/u3adm/P124149        5   \n",
       "6            6      šugid[~animal]N  epsd2/admin/u3adm/P124149        6   \n",
       "7            7  emuhaldim[kitchen]N  epsd2/admin/u3adm/P124149        6   \n",
       "8            8            mu[name]N  epsd2/admin/u3adm/P124149        7   \n",
       "9            9      gardu[soldier]N  epsd2/admin/u3adm/P124149        7   \n",
       "10          10          šag[heart]N  epsd2/admin/u3adm/P124149        9   \n",
       "11          11    tum-ma-al{ki}[]GN  epsd2/admin/u3adm/P124149        9   \n",
       "12          12             ud[sun]N  epsd2/admin/u3adm/P124149       10   \n",
       "13          13             1(u)[]NU  epsd2/admin/u3adm/P124149       10   \n",
       "14          14     5(diš@t)-kam[]NU  epsd2/admin/u3adm/P124149       10   \n",
       "15          15           ki[place]N  epsd2/admin/u3adm/P124149       11   \n",
       "16          16     du₁₁-ga-ta[NA]NA  epsd2/admin/u3adm/P124149       11   \n",
       "17          17         zig[rise]V/i  epsd2/admin/u3adm/P124149       12   \n",
       "18          18          itud[moon]N  epsd2/admin/u3adm/P124149       13   \n",
       "19          19        šu-eš₅-ša[]MN  epsd2/admin/u3adm/P124149       13   \n",
       "20          20            mu[name]N  epsd2/admin/u3adm/P124149       14   \n",
       "21          21          en[priest]N  epsd2/admin/u3adm/P124149       14   \n",
       "22          22        eridu{ki}[]GN  epsd2/admin/u3adm/P124149       14   \n",
       "23          23         huŋ[hire]V/t  epsd2/admin/u3adm/P124149       14   \n",
       "24          24             1(u)[]NU  epsd2/admin/u3adm/P124149       16   \n",
       "25          25           1(diš)[]NU  epsd2/admin/u3adm/P124149       16   \n",
       "26         173           1(diš)[]NU  epsd2/admin/u3adm/P405489        3   \n",
       "27         174             gud[ox]N  epsd2/admin/u3adm/P405489        3   \n",
       "28         175    niga[fattened]V/i  epsd2/admin/u3adm/P405489        3   \n",
       "29         176           1(diš)[]NU  epsd2/admin/u3adm/P405489        4   \n",
       "..         ...                  ...                        ...      ...   \n",
       "70         449            us[side]N  epsd2/admin/u3adm/P332036        4   \n",
       "71         450           1(diš)[]NU  epsd2/admin/u3adm/P332036        5   \n",
       "72         451             gud[ox]N  epsd2/admin/u3adm/P332036        5   \n",
       "73         452    niga[fattened]V/i  epsd2/admin/u3adm/P332036        5   \n",
       "74         453           3(diš)[]NU  epsd2/admin/u3adm/P332036        6   \n",
       "75         454          udu[sheep]N  epsd2/admin/u3adm/P332036        6   \n",
       "76         455    niga[fattened]V/i  epsd2/admin/u3adm/P332036        6   \n",
       "77         456       3(diš)-kam[]NU  epsd2/admin/u3adm/P332036        6   \n",
       "78         457            us[side]N  epsd2/admin/u3adm/P332036        6   \n",
       "79         458           2(diš)[]NU  epsd2/admin/u3adm/P332036        7   \n",
       "80         459          udu[sheep]N  epsd2/admin/u3adm/P332036        7   \n",
       "81         460    niga[fattened]V/i  epsd2/admin/u3adm/P332036        7   \n",
       "82         461       4(diš)-kam[]NU  epsd2/admin/u3adm/P332036        7   \n",
       "83         462            us[side]N  epsd2/admin/u3adm/P332036        7   \n",
       "84         463           8(diš)[]NU  epsd2/admin/u3adm/P332036        8   \n",
       "85         464          udu[sheep]N  epsd2/admin/u3adm/P332036        8   \n",
       "86         465            u[grass]N  epsd2/admin/u3adm/P332036        8   \n",
       "87         466             1(u)[]NU  epsd2/admin/u3adm/P332036        9   \n",
       "88         467        mašgal[goat]N  epsd2/admin/u3adm/P332036        9   \n",
       "89         468            u[grass]N  epsd2/admin/u3adm/P332036        9   \n",
       "90         469           1(diš)[]NU  epsd2/admin/u3adm/P332036       10   \n",
       "91         470          sila[lamb]N  epsd2/admin/u3adm/P332036       10   \n",
       "92         471     {d}utu-ba-ni[]PN  epsd2/admin/u3adm/P332036       11   \n",
       "93         472           2(diš)[]NU  epsd2/admin/u3adm/P332036       12   \n",
       "94         473             gud[ox]N  epsd2/admin/u3adm/P332036       12   \n",
       "95         474    niga[fattened]V/i  epsd2/admin/u3adm/P332036       12   \n",
       "96         475             1(u)[]NU  epsd2/admin/u3adm/P332036       13   \n",
       "97         476           4(diš)[]NU  epsd2/admin/u3adm/P332036       13   \n",
       "98         477          udu[sheep]N  epsd2/admin/u3adm/P332036       13   \n",
       "99         478            u[grass]N  epsd2/admin/u3adm/P332036       13   \n",
       "\n",
       "         id_word   label  \n",
       "0    P124149.3.1     o 1  \n",
       "1    P124149.3.2     o 1  \n",
       "2    P124149.4.1     o 2  \n",
       "3    P124149.4.2     o 2  \n",
       "4    P124149.5.1     o 3  \n",
       "5    P124149.5.2     o 3  \n",
       "6    P124149.6.1     o 4  \n",
       "7    P124149.6.2     o 4  \n",
       "8    P124149.7.1     o 5  \n",
       "9    P124149.7.2     o 5  \n",
       "10   P124149.9.1     r 1  \n",
       "11   P124149.9.2     r 1  \n",
       "12  P124149.10.1     r 2  \n",
       "13  P124149.10.2     r 2  \n",
       "14  P124149.10.3     r 2  \n",
       "15  P124149.11.1     r 3  \n",
       "16  P124149.11.2     r 3  \n",
       "17  P124149.12.1     r 4  \n",
       "18  P124149.13.1     r 5  \n",
       "19  P124149.13.2     r 5  \n",
       "20  P124149.14.1     r 6  \n",
       "21  P124149.14.2     r 6  \n",
       "22  P124149.14.3     r 6  \n",
       "23  P124149.14.4     r 6  \n",
       "24  P124149.16.1  l.e. 1  \n",
       "25  P124149.16.2  l.e. 1  \n",
       "26   P405489.3.1     o 1  \n",
       "27   P405489.3.2     o 1  \n",
       "28   P405489.3.3     o 1  \n",
       "29   P405489.4.1     o 2  \n",
       "..           ...     ...  \n",
       "70   P332036.4.5   o i 1  \n",
       "71   P332036.5.1   o i 2  \n",
       "72   P332036.5.2   o i 2  \n",
       "73   P332036.5.3   o i 2  \n",
       "74   P332036.6.1   o i 3  \n",
       "75   P332036.6.2   o i 3  \n",
       "76   P332036.6.3   o i 3  \n",
       "77   P332036.6.4   o i 3  \n",
       "78   P332036.6.5   o i 3  \n",
       "79   P332036.7.1   o i 4  \n",
       "80   P332036.7.2   o i 4  \n",
       "81   P332036.7.3   o i 4  \n",
       "82   P332036.7.4   o i 4  \n",
       "83   P332036.7.5   o i 4  \n",
       "84   P332036.8.1   o i 5  \n",
       "85   P332036.8.2   o i 5  \n",
       "86   P332036.8.3   o i 5  \n",
       "87   P332036.9.1   o i 6  \n",
       "88   P332036.9.2   o i 6  \n",
       "89   P332036.9.3   o i 6  \n",
       "90  P332036.10.1   o i 7  \n",
       "91  P332036.10.2   o i 7  \n",
       "92  P332036.11.1   o i 8  \n",
       "93  P332036.12.1   o i 9  \n",
       "94  P332036.12.2   o i 9  \n",
       "95  P332036.12.3   o i 9  \n",
       "96  P332036.13.1  o i 10  \n",
       "97  P332036.13.2  o i 10  \n",
       "98  P332036.13.3  o i 10  \n",
       "99  P332036.13.4  o i 10  \n",
       "\n",
       "[100 rows x 6 columns]"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Get first couple rows\n",
    "filtered.head(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "19jlC5XsC1vj"
   },
   "outputs": [],
   "source": [
    "# List of professions, roles, family\n",
    "professions = [ \"aʾigidu[worker]\", \n",
    "                \"abala[water-drawer]\", \n",
    "                \"abrig[functionary]\", \n",
    "                \"ad.KID[weaver]\", \n",
    "                \"agaʾus[soldier]\",\n",
    "                \"arad[slave]\",\n",
    "                \"ašgab[leatherworker]\",\n",
    "                \"aʾua [musician]\", \n",
    "                \"azlag[fuller]\",\n",
    "                \"bahar[potter]\",\n",
    "                \"bisaŋdubak[archivist]\",\n",
    "                \"damgar[merchant]\",\n",
    "                \"dikud[judge]\",\n",
    "                \"dubsar[scribe]\",\n",
    "                \"en[priest]\",\n",
    "                \"erešdiŋir[priestess]\",\n",
    "                \"ensik[ruler]\",\n",
    "                \"engar[farmer]\",\n",
    "                \"enkud[tax-collector]\",\n",
    "                \"gabaʾaš[courier]\",\n",
    "                \"galamah[singer]\",\n",
    "                \"gala[singer]\",\n",
    "                \"geme[worker]\",\n",
    "                \"gudug[priest]\",\n",
    "                \"guzala[official]\",\n",
    "                \"idu[doorkeeper]\",\n",
    "                \"išib[priest]\",\n",
    "                \"kaguruk[supervisor]\",\n",
    "                \"kaš[runner]\",\n",
    "                \"kiŋgia[messenger]\",\n",
    "                \"kinda[barber]\", \n",
    "                \"kinkin[miller]\",\n",
    "                \"kiridab[driver]\", \n",
    "                \"kurušda[fattener]\", \n",
    "                \"kuš[official]\",\n",
    "                \"lu[person]\",\n",
    "                \"lugal[king]\",\n",
    "                \"lukur[priestess]\",\n",
    "                \"lungak[brewer]\",\n",
    "                \"malah[sailor]\",\n",
    "                \"muhaldim[cook]\",\n",
    "                \"mušendu[bird-catcher]\",\n",
    "                \"nagada[herdsman]\",\n",
    "                \"nagar[carpenter]\",\n",
    "                \"nar[musician]\",\n",
    "                \"nargal[musician]\", \n",
    "                \"narsa[musician]\", \n",
    "                \"nin[lady]\",\n",
    "                \"nubanda[overseer]\",\n",
    "                \"nukirik[horticulturalist]\",\n",
    "                \"saŋ.DUN₃[recorder]\",\n",
    "                \"saŋŋa[official]\",\n",
    "                \"simug[smith]\",\n",
    "                \"sipad[shepherd]\",\n",
    "                \"sukkal[secretary]\",\n",
    "                \"šabra[administrator]\",\n",
    "                \"šagia[cup-bearer]\",\n",
    "                \"šakkanak[general]\",\n",
    "                # \"szej[cook]\", this is a verb\n",
    "                \"šidim[builder]\",\n",
    "                \"šuʾi[barber]\",\n",
    "                \"šukud[fisherman]\",\n",
    "                \"tibira[sculptor]\",\n",
    "                \"ugula[overseer]\",\n",
    "                \"unud[cowherd]\",\n",
    "                # \"urin[guard]\",\n",
    "                \"UN.IL₂[menial]\",\n",
    "                \"ušbar[weaver]\",\n",
    "                \"zabardab[official]\",\n",
    "                \"zadim[stone-cutter]\"]\n",
    "\n",
    "roles = ['ki[source]', 'maškim[administrator]', \n",
    "         'maškim[authorized]', 'i3-dab5[recipient]', 'giri3[intermediary]']\n",
    "\n",
    "family = ['šeš[brother]', 'szesz[brother]', 'dumu[son]', 'dumu-munus[daughter]', \n",
    "        'dumumunus[daughter]' , 'dam[spouse]']\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "PAeGCdTMD0oO"
   },
   "outputs": [],
   "source": [
    "#Create new professions column\n",
    "filtered['prof?'] = filtered['lemma'].apply(lambda word: 'Yes' if (re.match('^[^\\]]*', word)[0] + \"]\") in professions else 'No')\n",
    "filtered['role?'] = filtered['lemma'].apply(lambda word: 'Yes' if (re.match('^[^\\]]*', word)[0] + \"]\") in roles else 'No')\n",
    "filtered['family?'] = filtered['lemma'].apply(lambda word: 'Yes' if (re.match('^[^\\]]*', word)[0] + \"]\") in family else 'No')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Create \"number?\"\" to see if row is number. this could imply that that next row is a commodity\n",
    "filtered['number?'] = filtered['lemma'].str.contains('NU')\n",
    "filtered['number?'] = ['Yes' if filtered['number?'][i] == True else \"No\" for i in range(len(filtered))]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [],
   "source": [
    "filtered['commodity?'] = [\"No\"] + ['Yes' if filtered['number?'][i-1] == \"Yes\" else 'No' for i in range(1, len(filtered))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "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>lemma</th>\n",
       "      <th>id_text</th>\n",
       "      <th>id_line</th>\n",
       "      <th>id_word</th>\n",
       "      <th>label</th>\n",
       "      <th>prof?</th>\n",
       "      <th>role?</th>\n",
       "      <th>family?</th>\n",
       "      <th>number?</th>\n",
       "      <th>commodity?</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>3(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>3</td>\n",
       "      <td>P124149.3.1</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>udu[sheep]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>3</td>\n",
       "      <td>P124149.3.2</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>6(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>4</td>\n",
       "      <td>P124149.4.1</td>\n",
       "      <td>o 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>u[ewe]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>4</td>\n",
       "      <td>P124149.4.2</td>\n",
       "      <td>o 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>5</td>\n",
       "      <td>P124149.5.1</td>\n",
       "      <td>o 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0        lemma                    id_text  id_line      id_word  \\\n",
       "0           0   3(diš)[]NU  epsd2/admin/u3adm/P124149        3  P124149.3.1   \n",
       "1           1  udu[sheep]N  epsd2/admin/u3adm/P124149        3  P124149.3.2   \n",
       "2           2   6(diš)[]NU  epsd2/admin/u3adm/P124149        4  P124149.4.1   \n",
       "3           3      u[ewe]N  epsd2/admin/u3adm/P124149        4  P124149.4.2   \n",
       "4           4   2(diš)[]NU  epsd2/admin/u3adm/P124149        5  P124149.5.1   \n",
       "\n",
       "  label prof? role? family? number? commodity?  \n",
       "0   o 1    No    No      No     Yes         No  \n",
       "1   o 1    No    No      No      No        Yes  \n",
       "2   o 2    No    No      No     Yes         No  \n",
       "3   o 2    No    No      No      No        Yes  \n",
       "4   o 3    No    No      No     Yes         No  "
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 1000
    },
    "colab_type": "code",
    "id": "_4n3pg2dKUWE",
    "outputId": "f5676090-999b-47aa-e2a0-ad7ef9a30830"
   },
   "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>lemma</th>\n",
       "      <th>id_text</th>\n",
       "      <th>id_line</th>\n",
       "      <th>id_word</th>\n",
       "      <th>label</th>\n",
       "      <th>prof?</th>\n",
       "      <th>role?</th>\n",
       "      <th>family?</th>\n",
       "      <th>number?</th>\n",
       "      <th>commodity?</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>197</td>\n",
       "      <td>{d}šul-gi-a-a-mu-ta[]PN</td>\n",
       "      <td>epsd2/admin/u3adm/P405489</td>\n",
       "      <td>12</td>\n",
       "      <td>P405489.12.2</td>\n",
       "      <td>r 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>198</td>\n",
       "      <td>{d}šul-gi-iri-mu[]PN</td>\n",
       "      <td>epsd2/admin/u3adm/P405489</td>\n",
       "      <td>13</td>\n",
       "      <td>P405489.13.1</td>\n",
       "      <td>r 4</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>471</td>\n",
       "      <td>{d}utu-ba-ni[]PN</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>11</td>\n",
       "      <td>P332036.11.1</td>\n",
       "      <td>o i 8</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>499</td>\n",
       "      <td>dingir-ki-ma-at[]PN</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>19</td>\n",
       "      <td>P332036.19.3</td>\n",
       "      <td>o i 15</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>502</td>\n",
       "      <td>di-ku₅-i₃-li₂[]PN</td>\n",
       "      <td>epsd2/admin/u3adm/P332036</td>\n",
       "      <td>19</td>\n",
       "      <td>P332036.19.6</td>\n",
       "      <td>o i 15</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0                    lemma                    id_text  id_line  \\\n",
       "50          197  {d}šul-gi-a-a-mu-ta[]PN  epsd2/admin/u3adm/P405489       12   \n",
       "51          198     {d}šul-gi-iri-mu[]PN  epsd2/admin/u3adm/P405489       13   \n",
       "92          471         {d}utu-ba-ni[]PN  epsd2/admin/u3adm/P332036       11   \n",
       "120         499      dingir-ki-ma-at[]PN  epsd2/admin/u3adm/P332036       19   \n",
       "123         502        di-ku₅-i₃-li₂[]PN  epsd2/admin/u3adm/P332036       19   \n",
       "\n",
       "          id_word   label prof? role? family? number? commodity?  \n",
       "50   P405489.12.2     r 3    No    No      No      No         No  \n",
       "51   P405489.13.1     r 4    No    No      No      No         No  \n",
       "92   P332036.11.1   o i 8    No    No      No      No         No  \n",
       "120  P332036.19.3  o i 15    No    No      No      No         No  \n",
       "123  P332036.19.6  o i 15    No    No      No      No         No  "
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "PN = filtered[filtered['lemma'].str.contains(\"PN\")]\n",
    "PN.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 34
    },
    "colab_type": "code",
    "id": "BEX_8SgNjzvl",
    "outputId": "3e12ffc5-a3b9-490b-884e-1bd62ce86f71"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "46126"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(PN)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 80
    },
    "colab_type": "code",
    "id": "w08xEr_HLoKr",
    "outputId": "c222272e-b1ee-47e9-e2f2-b0993e1aff21"
   },
   "outputs": [],
   "source": [
    "# #get the three rows, with middle being PN\n",
    "# x = filtered.loc[:'552789'].tail(5)\n",
    "# x.iloc[[3]]['lemma'].values[0]\n",
    "# z =filtered.loc[:53].tail(5)\n",
    "# y = z.loc[[52]]\n",
    "# y\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 34
    },
    "colab_type": "code",
    "id": "jfykUP13PLav",
    "outputId": "78c60b81-cb95-49aa-f0aa-028e3cefa386"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "552802"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Check if the preceding and after row belong to the same line\n",
    "\n",
    "pn_indices = PN.index.values.tolist()\n",
    "# PN_dict = dict()\n",
    "lists = [[] for i in range(len(filtered))]\n",
    "for i in pn_indices:\n",
    "  five_rows = filtered.loc[:i+2].tail(5)\n",
    "  correct_id_line = five_rows.iloc[[2]]['id_word'].values[0][:-2]\n",
    "  lemma = five_rows.iloc[[2]]['lemma'].values[0]\n",
    "  #check preceding\n",
    "  five_rows_some_indices = [0, 1, 3, 4]\n",
    "  neighbors = []\n",
    "  key = filtered.loc[[i]]['lemma'].values[0]\n",
    "  for r in five_rows_some_indices:\n",
    "    curr_pn = five_rows.iloc[[r]]['id_word'].values[0][:-2]\n",
    "    if curr_pn == correct_id_line:\n",
    "      neighbors.append(five_rows.iloc[[r]]['lemma'].values[0])\n",
    "  lists[i] = neighbors\n",
    "filtered['neighbors'] = lists\n",
    "len(lists)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 34
    },
    "colab_type": "code",
    "id": "4-JTnZ9vfUz_",
    "outputId": "06db1bd6-6466-4b10-fde4-d68b8e3f6fbd"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "552802"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(filtered)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "W84HphiOV_Sy"
   },
   "outputs": [],
   "source": [
    "# group_of_same_text = filtered[filtered['id_word'] == filtered.iloc[[51]]['id_word'].values[0][:-5]]\n",
    "filtered_wo_nan = filtered.drop([157490])\n",
    "filtered_wo_nan['P_Number'] = [filtered_wo_nan.iloc[[i]]['id_word'].values[0][:-4] for i in range(len(filtered_wo_nan))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 204
    },
    "colab_type": "code",
    "id": "AM2DdgnOct5k",
    "outputId": "78be3d26-624b-471c-a7a8-018195e1a01d"
   },
   "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>lemma</th>\n",
       "      <th>id_text</th>\n",
       "      <th>id_line</th>\n",
       "      <th>id_word</th>\n",
       "      <th>label</th>\n",
       "      <th>prof?</th>\n",
       "      <th>role?</th>\n",
       "      <th>family?</th>\n",
       "      <th>number?</th>\n",
       "      <th>commodity?</th>\n",
       "      <th>neighbors</th>\n",
       "      <th>P_Number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>3(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>3</td>\n",
       "      <td>P124149.3.1</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>udu[sheep]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>3</td>\n",
       "      <td>P124149.3.2</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>6(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>4</td>\n",
       "      <td>P124149.4.1</td>\n",
       "      <td>o 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>u[ewe]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>4</td>\n",
       "      <td>P124149.4.2</td>\n",
       "      <td>o 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>5</td>\n",
       "      <td>P124149.5.1</td>\n",
       "      <td>o 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>mašgal[goat]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>5</td>\n",
       "      <td>P124149.5.2</td>\n",
       "      <td>o 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>šugid[~animal]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>6</td>\n",
       "      <td>P124149.6.1</td>\n",
       "      <td>o 4</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>emuhaldim[kitchen]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>6</td>\n",
       "      <td>P124149.6.2</td>\n",
       "      <td>o 4</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>mu[name]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>7</td>\n",
       "      <td>P124149.7.1</td>\n",
       "      <td>o 5</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>gardu[soldier]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>7</td>\n",
       "      <td>P124149.7.2</td>\n",
       "      <td>o 5</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>šag[heart]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>9</td>\n",
       "      <td>P124149.9.1</td>\n",
       "      <td>r 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>tum-ma-al{ki}[]GN</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>9</td>\n",
       "      <td>P124149.9.2</td>\n",
       "      <td>r 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>ud[sun]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>10</td>\n",
       "      <td>P124149.10.1</td>\n",
       "      <td>r 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>1(u)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>10</td>\n",
       "      <td>P124149.10.2</td>\n",
       "      <td>r 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>5(diš@t)-kam[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>10</td>\n",
       "      <td>P124149.10.3</td>\n",
       "      <td>r 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>ki[place]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>11</td>\n",
       "      <td>P124149.11.1</td>\n",
       "      <td>r 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>du₁₁-ga-ta[NA]NA</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>11</td>\n",
       "      <td>P124149.11.2</td>\n",
       "      <td>r 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>zig[rise]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>12</td>\n",
       "      <td>P124149.12.1</td>\n",
       "      <td>r 4</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>itud[moon]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>13</td>\n",
       "      <td>P124149.13.1</td>\n",
       "      <td>r 5</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>šu-eš₅-ša[]MN</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>13</td>\n",
       "      <td>P124149.13.2</td>\n",
       "      <td>r 5</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>mu[name]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>14</td>\n",
       "      <td>P124149.14.1</td>\n",
       "      <td>r 6</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>en[priest]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>14</td>\n",
       "      <td>P124149.14.2</td>\n",
       "      <td>r 6</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>eridu{ki}[]GN</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>14</td>\n",
       "      <td>P124149.14.3</td>\n",
       "      <td>r 6</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>huŋ[hire]V/t</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>14</td>\n",
       "      <td>P124149.14.4</td>\n",
       "      <td>r 6</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>1(u)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>16</td>\n",
       "      <td>P124149.16.1</td>\n",
       "      <td>l.e. 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>1(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>16</td>\n",
       "      <td>P124149.16.2</td>\n",
       "      <td>l.e. 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>173</td>\n",
       "      <td>1(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P405489</td>\n",
       "      <td>3</td>\n",
       "      <td>P405489.3.1</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P405489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>174</td>\n",
       "      <td>gud[ox]N</td>\n",
       "      <td>epsd2/admin/u3adm/P405489</td>\n",
       "      <td>3</td>\n",
       "      <td>P405489.3.2</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P405489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>175</td>\n",
       "      <td>niga[fattened]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P405489</td>\n",
       "      <td>3</td>\n",
       "      <td>P405489.3.3</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P405489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>176</td>\n",
       "      <td>1(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P405489</td>\n",
       "      <td>4</td>\n",
       "      <td>P405489.4.1</td>\n",
       "      <td>o 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P405489</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552772</th>\n",
       "      <td>3369134</td>\n",
       "      <td>mu[name]N</td>\n",
       "      <td>epsd2/admin/u3adm/P142905</td>\n",
       "      <td>13</td>\n",
       "      <td>P142905.13.1</td>\n",
       "      <td>r 6</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P142905.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552773</th>\n",
       "      <td>3369135</td>\n",
       "      <td>ša-aš-ru{ki}[]GN</td>\n",
       "      <td>epsd2/admin/u3adm/P142905</td>\n",
       "      <td>13</td>\n",
       "      <td>P142905.13.2</td>\n",
       "      <td>r 6</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P142905.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552774</th>\n",
       "      <td>3369136</td>\n",
       "      <td>hulu[bad]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P142905</td>\n",
       "      <td>13</td>\n",
       "      <td>P142905.13.3</td>\n",
       "      <td>r 6</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P142905.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552775</th>\n",
       "      <td>3369137</td>\n",
       "      <td>7(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P142905</td>\n",
       "      <td>15</td>\n",
       "      <td>P142905.15.1</td>\n",
       "      <td>l.e. 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P142905.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552776</th>\n",
       "      <td>3369192</td>\n",
       "      <td>3(u)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>3</td>\n",
       "      <td>P218182.3.1</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552777</th>\n",
       "      <td>3369193</td>\n",
       "      <td>3(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>3</td>\n",
       "      <td>P218182.3.2</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552778</th>\n",
       "      <td>3369194</td>\n",
       "      <td>udu[sheep]N</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>3</td>\n",
       "      <td>P218182.3.3</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552779</th>\n",
       "      <td>3369195</td>\n",
       "      <td>2(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>4</td>\n",
       "      <td>P218182.4.1</td>\n",
       "      <td>o 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552780</th>\n",
       "      <td>3369196</td>\n",
       "      <td>maš[goat]N</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>4</td>\n",
       "      <td>P218182.4.2</td>\n",
       "      <td>o 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552781</th>\n",
       "      <td>3369197</td>\n",
       "      <td>ud[sun]N</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>5</td>\n",
       "      <td>P218182.5.1</td>\n",
       "      <td>o 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552782</th>\n",
       "      <td>3369198</td>\n",
       "      <td>3(u)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>5</td>\n",
       "      <td>P218182.5.2</td>\n",
       "      <td>o 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552783</th>\n",
       "      <td>3369199</td>\n",
       "      <td>lal[small]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>5</td>\n",
       "      <td>P218182.5.3</td>\n",
       "      <td>o 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552784</th>\n",
       "      <td>3369200</td>\n",
       "      <td>1(diš@t)-kam[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>5</td>\n",
       "      <td>P218182.5.4</td>\n",
       "      <td>o 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552785</th>\n",
       "      <td>3369201</td>\n",
       "      <td>ki[place]N</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>6</td>\n",
       "      <td>P218182.6.1</td>\n",
       "      <td>o 4</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552786</th>\n",
       "      <td>3369202</td>\n",
       "      <td>ab-ba-sa₆-ga-ta[]PN</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>6</td>\n",
       "      <td>P218182.6.2</td>\n",
       "      <td>o 4</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[ki[place]N]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552787</th>\n",
       "      <td>3369203</td>\n",
       "      <td>in-ta-e₃-a[]PN</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>7</td>\n",
       "      <td>P218182.7.1</td>\n",
       "      <td>o 5</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552788</th>\n",
       "      <td>3369204</td>\n",
       "      <td>dab[seize]V/t</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>9</td>\n",
       "      <td>P218182.9.1</td>\n",
       "      <td>r 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552789</th>\n",
       "      <td>3369205</td>\n",
       "      <td>break</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>10</td>\n",
       "      <td>P218182.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P21818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552790</th>\n",
       "      <td>3369206</td>\n",
       "      <td>itud[moon]N</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>11</td>\n",
       "      <td>P218182.11.1</td>\n",
       "      <td>r 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552791</th>\n",
       "      <td>3369207</td>\n",
       "      <td>ki-siki-{d}nin-a-zu[]MN</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>11</td>\n",
       "      <td>P218182.11.2</td>\n",
       "      <td>r 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552792</th>\n",
       "      <td>3369208</td>\n",
       "      <td>mu[name]N</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>12</td>\n",
       "      <td>P218182.12.1</td>\n",
       "      <td>r 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552793</th>\n",
       "      <td>3369209</td>\n",
       "      <td>en[priest]N</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>12</td>\n",
       "      <td>P218182.12.2</td>\n",
       "      <td>r 3</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552794</th>\n",
       "      <td>3369210</td>\n",
       "      <td>mah[great]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>12</td>\n",
       "      <td>P218182.12.3</td>\n",
       "      <td>r 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552795</th>\n",
       "      <td>3369211</td>\n",
       "      <td>gal[big]V/i</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>12</td>\n",
       "      <td>P218182.12.4</td>\n",
       "      <td>r 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552796</th>\n",
       "      <td>3369212</td>\n",
       "      <td>an[sky]N</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>12</td>\n",
       "      <td>P218182.12.5</td>\n",
       "      <td>r 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552797</th>\n",
       "      <td>3369213</td>\n",
       "      <td>en[priest]N</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>12</td>\n",
       "      <td>P218182.12.6</td>\n",
       "      <td>r 3</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552798</th>\n",
       "      <td>3369214</td>\n",
       "      <td>{d}nanna[]DN</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>12</td>\n",
       "      <td>P218182.12.7</td>\n",
       "      <td>r 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552799</th>\n",
       "      <td>3369215</td>\n",
       "      <td>huŋ[hire]V/t</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>12</td>\n",
       "      <td>P218182.12.8</td>\n",
       "      <td>r 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552800</th>\n",
       "      <td>3369216</td>\n",
       "      <td>3(u)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>14</td>\n",
       "      <td>P218182.14.1</td>\n",
       "      <td>l.e. 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552801</th>\n",
       "      <td>3369217</td>\n",
       "      <td>5(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P218182</td>\n",
       "      <td>14</td>\n",
       "      <td>P218182.14.2</td>\n",
       "      <td>l.e. 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>[]</td>\n",
       "      <td>P218182.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>552801 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0                    lemma                    id_text  \\\n",
       "0                0               3(diš)[]NU  epsd2/admin/u3adm/P124149   \n",
       "1                1              udu[sheep]N  epsd2/admin/u3adm/P124149   \n",
       "2                2               6(diš)[]NU  epsd2/admin/u3adm/P124149   \n",
       "3                3                  u[ewe]N  epsd2/admin/u3adm/P124149   \n",
       "4                4               2(diš)[]NU  epsd2/admin/u3adm/P124149   \n",
       "5                5            mašgal[goat]N  epsd2/admin/u3adm/P124149   \n",
       "6                6          šugid[~animal]N  epsd2/admin/u3adm/P124149   \n",
       "7                7      emuhaldim[kitchen]N  epsd2/admin/u3adm/P124149   \n",
       "8                8                mu[name]N  epsd2/admin/u3adm/P124149   \n",
       "9                9          gardu[soldier]N  epsd2/admin/u3adm/P124149   \n",
       "10              10              šag[heart]N  epsd2/admin/u3adm/P124149   \n",
       "11              11        tum-ma-al{ki}[]GN  epsd2/admin/u3adm/P124149   \n",
       "12              12                 ud[sun]N  epsd2/admin/u3adm/P124149   \n",
       "13              13                 1(u)[]NU  epsd2/admin/u3adm/P124149   \n",
       "14              14         5(diš@t)-kam[]NU  epsd2/admin/u3adm/P124149   \n",
       "15              15               ki[place]N  epsd2/admin/u3adm/P124149   \n",
       "16              16         du₁₁-ga-ta[NA]NA  epsd2/admin/u3adm/P124149   \n",
       "17              17             zig[rise]V/i  epsd2/admin/u3adm/P124149   \n",
       "18              18              itud[moon]N  epsd2/admin/u3adm/P124149   \n",
       "19              19            šu-eš₅-ša[]MN  epsd2/admin/u3adm/P124149   \n",
       "20              20                mu[name]N  epsd2/admin/u3adm/P124149   \n",
       "21              21              en[priest]N  epsd2/admin/u3adm/P124149   \n",
       "22              22            eridu{ki}[]GN  epsd2/admin/u3adm/P124149   \n",
       "23              23             huŋ[hire]V/t  epsd2/admin/u3adm/P124149   \n",
       "24              24                 1(u)[]NU  epsd2/admin/u3adm/P124149   \n",
       "25              25               1(diš)[]NU  epsd2/admin/u3adm/P124149   \n",
       "26             173               1(diš)[]NU  epsd2/admin/u3adm/P405489   \n",
       "27             174                 gud[ox]N  epsd2/admin/u3adm/P405489   \n",
       "28             175        niga[fattened]V/i  epsd2/admin/u3adm/P405489   \n",
       "29             176               1(diš)[]NU  epsd2/admin/u3adm/P405489   \n",
       "...            ...                      ...                        ...   \n",
       "552772     3369134                mu[name]N  epsd2/admin/u3adm/P142905   \n",
       "552773     3369135         ša-aš-ru{ki}[]GN  epsd2/admin/u3adm/P142905   \n",
       "552774     3369136             hulu[bad]V/i  epsd2/admin/u3adm/P142905   \n",
       "552775     3369137               7(diš)[]NU  epsd2/admin/u3adm/P142905   \n",
       "552776     3369192                 3(u)[]NU  epsd2/admin/u3adm/P218182   \n",
       "552777     3369193               3(diš)[]NU  epsd2/admin/u3adm/P218182   \n",
       "552778     3369194              udu[sheep]N  epsd2/admin/u3adm/P218182   \n",
       "552779     3369195               2(diš)[]NU  epsd2/admin/u3adm/P218182   \n",
       "552780     3369196               maš[goat]N  epsd2/admin/u3adm/P218182   \n",
       "552781     3369197                 ud[sun]N  epsd2/admin/u3adm/P218182   \n",
       "552782     3369198                 3(u)[]NU  epsd2/admin/u3adm/P218182   \n",
       "552783     3369199            lal[small]V/i  epsd2/admin/u3adm/P218182   \n",
       "552784     3369200         1(diš@t)-kam[]NU  epsd2/admin/u3adm/P218182   \n",
       "552785     3369201               ki[place]N  epsd2/admin/u3adm/P218182   \n",
       "552786     3369202      ab-ba-sa₆-ga-ta[]PN  epsd2/admin/u3adm/P218182   \n",
       "552787     3369203           in-ta-e₃-a[]PN  epsd2/admin/u3adm/P218182   \n",
       "552788     3369204            dab[seize]V/t  epsd2/admin/u3adm/P218182   \n",
       "552789     3369205                    break  epsd2/admin/u3adm/P218182   \n",
       "552790     3369206              itud[moon]N  epsd2/admin/u3adm/P218182   \n",
       "552791     3369207  ki-siki-{d}nin-a-zu[]MN  epsd2/admin/u3adm/P218182   \n",
       "552792     3369208                mu[name]N  epsd2/admin/u3adm/P218182   \n",
       "552793     3369209              en[priest]N  epsd2/admin/u3adm/P218182   \n",
       "552794     3369210            mah[great]V/i  epsd2/admin/u3adm/P218182   \n",
       "552795     3369211              gal[big]V/i  epsd2/admin/u3adm/P218182   \n",
       "552796     3369212                 an[sky]N  epsd2/admin/u3adm/P218182   \n",
       "552797     3369213              en[priest]N  epsd2/admin/u3adm/P218182   \n",
       "552798     3369214             {d}nanna[]DN  epsd2/admin/u3adm/P218182   \n",
       "552799     3369215             huŋ[hire]V/t  epsd2/admin/u3adm/P218182   \n",
       "552800     3369216                 3(u)[]NU  epsd2/admin/u3adm/P218182   \n",
       "552801     3369217               5(diš)[]NU  epsd2/admin/u3adm/P218182   \n",
       "\n",
       "        id_line       id_word   label prof? role? family? number? commodity?  \\\n",
       "0             3   P124149.3.1     o 1    No    No      No     Yes         No   \n",
       "1             3   P124149.3.2     o 1    No    No      No      No        Yes   \n",
       "2             4   P124149.4.1     o 2    No    No      No     Yes         No   \n",
       "3             4   P124149.4.2     o 2    No    No      No      No        Yes   \n",
       "4             5   P124149.5.1     o 3    No    No      No     Yes         No   \n",
       "5             5   P124149.5.2     o 3    No    No      No      No        Yes   \n",
       "6             6   P124149.6.1     o 4    No    No      No      No         No   \n",
       "7             6   P124149.6.2     o 4    No    No      No      No         No   \n",
       "8             7   P124149.7.1     o 5    No    No      No      No         No   \n",
       "9             7   P124149.7.2     o 5    No    No      No      No         No   \n",
       "10            9   P124149.9.1     r 1    No    No      No      No         No   \n",
       "11            9   P124149.9.2     r 1    No    No      No      No         No   \n",
       "12           10  P124149.10.1     r 2    No    No      No      No         No   \n",
       "13           10  P124149.10.2     r 2    No    No      No     Yes         No   \n",
       "14           10  P124149.10.3     r 2    No    No      No     Yes        Yes   \n",
       "15           11  P124149.11.1     r 3    No    No      No      No        Yes   \n",
       "16           11  P124149.11.2     r 3    No    No      No      No         No   \n",
       "17           12  P124149.12.1     r 4    No    No      No      No         No   \n",
       "18           13  P124149.13.1     r 5    No    No      No      No         No   \n",
       "19           13  P124149.13.2     r 5    No    No      No      No         No   \n",
       "20           14  P124149.14.1     r 6    No    No      No      No         No   \n",
       "21           14  P124149.14.2     r 6   Yes    No      No      No         No   \n",
       "22           14  P124149.14.3     r 6    No    No      No      No         No   \n",
       "23           14  P124149.14.4     r 6    No    No      No      No         No   \n",
       "24           16  P124149.16.1  l.e. 1    No    No      No     Yes         No   \n",
       "25           16  P124149.16.2  l.e. 1    No    No      No     Yes        Yes   \n",
       "26            3   P405489.3.1     o 1    No    No      No     Yes        Yes   \n",
       "27            3   P405489.3.2     o 1    No    No      No      No        Yes   \n",
       "28            3   P405489.3.3     o 1    No    No      No      No         No   \n",
       "29            4   P405489.4.1     o 2    No    No      No     Yes         No   \n",
       "...         ...           ...     ...   ...   ...     ...     ...        ...   \n",
       "552772       13  P142905.13.1     r 6    No    No      No      No         No   \n",
       "552773       13  P142905.13.2     r 6    No    No      No      No         No   \n",
       "552774       13  P142905.13.3     r 6    No    No      No      No         No   \n",
       "552775       15  P142905.15.1  l.e. 1    No    No      No     Yes         No   \n",
       "552776        3   P218182.3.1     o 1    No    No      No     Yes        Yes   \n",
       "552777        3   P218182.3.2     o 1    No    No      No     Yes        Yes   \n",
       "552778        3   P218182.3.3     o 1    No    No      No      No        Yes   \n",
       "552779        4   P218182.4.1     o 2    No    No      No     Yes         No   \n",
       "552780        4   P218182.4.2     o 2    No    No      No      No        Yes   \n",
       "552781        5   P218182.5.1     o 3    No    No      No      No         No   \n",
       "552782        5   P218182.5.2     o 3    No    No      No     Yes         No   \n",
       "552783        5   P218182.5.3     o 3    No    No      No      No        Yes   \n",
       "552784        5   P218182.5.4     o 3    No    No      No     Yes         No   \n",
       "552785        6   P218182.6.1     o 4    No    No      No      No        Yes   \n",
       "552786        6   P218182.6.2     o 4    No    No      No      No         No   \n",
       "552787        7   P218182.7.1     o 5    No    No      No      No         No   \n",
       "552788        9   P218182.9.1     r 1    No    No      No      No         No   \n",
       "552789       10    P218182.10     NaN    No    No      No      No         No   \n",
       "552790       11  P218182.11.1     r 2    No    No      No      No         No   \n",
       "552791       11  P218182.11.2     r 2    No    No      No      No         No   \n",
       "552792       12  P218182.12.1     r 3    No    No      No      No         No   \n",
       "552793       12  P218182.12.2     r 3   Yes    No      No      No         No   \n",
       "552794       12  P218182.12.3     r 3    No    No      No      No         No   \n",
       "552795       12  P218182.12.4     r 3    No    No      No      No         No   \n",
       "552796       12  P218182.12.5     r 3    No    No      No      No         No   \n",
       "552797       12  P218182.12.6     r 3   Yes    No      No      No         No   \n",
       "552798       12  P218182.12.7     r 3    No    No      No      No         No   \n",
       "552799       12  P218182.12.8     r 3    No    No      No      No         No   \n",
       "552800       14  P218182.14.1  l.e. 1    No    No      No     Yes         No   \n",
       "552801       14  P218182.14.2  l.e. 1    No    No      No     Yes        Yes   \n",
       "\n",
       "           neighbors  P_Number  \n",
       "0                 []   P124149  \n",
       "1                 []   P124149  \n",
       "2                 []   P124149  \n",
       "3                 []   P124149  \n",
       "4                 []   P124149  \n",
       "5                 []   P124149  \n",
       "6                 []   P124149  \n",
       "7                 []   P124149  \n",
       "8                 []   P124149  \n",
       "9                 []   P124149  \n",
       "10                []   P124149  \n",
       "11                []   P124149  \n",
       "12                []  P124149.  \n",
       "13                []  P124149.  \n",
       "14                []  P124149.  \n",
       "15                []  P124149.  \n",
       "16                []  P124149.  \n",
       "17                []  P124149.  \n",
       "18                []  P124149.  \n",
       "19                []  P124149.  \n",
       "20                []  P124149.  \n",
       "21                []  P124149.  \n",
       "22                []  P124149.  \n",
       "23                []  P124149.  \n",
       "24                []  P124149.  \n",
       "25                []  P124149.  \n",
       "26                []   P405489  \n",
       "27                []   P405489  \n",
       "28                []   P405489  \n",
       "29                []   P405489  \n",
       "...              ...       ...  \n",
       "552772            []  P142905.  \n",
       "552773            []  P142905.  \n",
       "552774            []  P142905.  \n",
       "552775            []  P142905.  \n",
       "552776            []   P218182  \n",
       "552777            []   P218182  \n",
       "552778            []   P218182  \n",
       "552779            []   P218182  \n",
       "552780            []   P218182  \n",
       "552781            []   P218182  \n",
       "552782            []   P218182  \n",
       "552783            []   P218182  \n",
       "552784            []   P218182  \n",
       "552785            []   P218182  \n",
       "552786  [ki[place]N]   P218182  \n",
       "552787            []   P218182  \n",
       "552788            []   P218182  \n",
       "552789            []    P21818  \n",
       "552790            []  P218182.  \n",
       "552791            []  P218182.  \n",
       "552792            []  P218182.  \n",
       "552793            []  P218182.  \n",
       "552794            []  P218182.  \n",
       "552795            []  P218182.  \n",
       "552796            []  P218182.  \n",
       "552797            []  P218182.  \n",
       "552798            []  P218182.  \n",
       "552799            []  P218182.  \n",
       "552800            []  P218182.  \n",
       "552801            []  P218182.  \n",
       "\n",
       "[552801 rows x 13 columns]"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered_wo_nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 232
    },
    "colab_type": "code",
    "id": "3qShKCZEWlsf",
    "outputId": "1cf4ce07-5e23-4a4b-d367-367da9abe8ba"
   },
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "157614",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-104-95660ca09afa>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      6\u001b[0m   \u001b[0;31m#group all the respective lines with from the same text first, then extract rows of particular lines\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      7\u001b[0m   \u001b[0mgroup_of_same_text\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mfiltered_wo_nan\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mfiltered_wo_nan\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'P_Number'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0mfiltered_wo_nan\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0miloc\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'id_word'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mvalues\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m4\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 8\u001b[0;31m   neighbors_lines = group_of_same_text[(group_of_same_text['id_line'][i] == group_of_same_text['id_line'] + 1) \n\u001b[0m\u001b[1;32m      9\u001b[0m                                       | (group_of_same_text['id_line'][i] == group_of_same_text['id_line'] - 1)]\n\u001b[1;32m     10\u001b[0m   \u001b[0mline_neigh\u001b[0m\u001b[0;34m=\u001b[0m \u001b[0mneighbors_lines\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'lemma'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mvalues\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtolist\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/core/series.py\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m    764\u001b[0m         \u001b[0mkey\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcom\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_apply_if_callable\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    765\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 766\u001b[0;31m             \u001b[0mresult\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_value\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    767\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    768\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mis_scalar\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mresult\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mget_value\u001b[0;34m(self, series, key)\u001b[0m\n\u001b[1;32m   3101\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3102\u001b[0m             return self._engine.get_value(s, k,\n\u001b[0;32m-> 3103\u001b[0;31m                                           tz=getattr(series.dtype, 'tz', None))\n\u001b[0m\u001b[1;32m   3104\u001b[0m         \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0me1\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3105\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0;36m0\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0minferred_type\u001b[0m \u001b[0;32min\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0;34m'integer'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'boolean'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_value\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_value\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.Int64HashTable.get_item\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.Int64HashTable.get_item\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 157614"
     ]
    }
   ],
   "source": [
    "#grab neighbors for same line, line above, line below (maybe two lines)\n",
    "#check if elements within list fall under certain commodity name? \n",
    "#more_neighbors column \n",
    "bigger_lists = []\n",
    "for i in pn_indices:\n",
    "  #group all the respective lines with from the same text first, then extract rows of particular lines \n",
    "  group_of_same_text = filtered_wo_nan[filtered_wo_nan['P_Number'] == filtered_wo_nan.iloc[[i]]['id_word'].values[0][:-4]]\n",
    "  neighbors_lines = group_of_same_text[(group_of_same_text['id_line'][i] == group_of_same_text['id_line'] + 1) \n",
    "                                      | (group_of_same_text['id_line'][i] == group_of_same_text['id_line'] - 1)]\n",
    "  line_neigh= neighbors_lines['lemma'].values.tolist()\n",
    "#   key = filtered.loc[[i]]['lemma'].values[0]\n",
    "#   for r in five_rows_some_indices:\n",
    "#     curr_pn = five_rows.iloc[[r]]['id_word'].values[0][:-2]\n",
    "#     if curr_pn == correct_id_line:\n",
    "#       neighbors.append(five_rows.iloc[[r]]['lemma'].values[0])\n",
    "  bigger_lists.append(line_neigh)\n",
    "filtered['line neighbors'] = bigger_lists"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['6(diš)[]NU', 'u[ewe]N']"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "group_of_same_text = filtered_wo_nan[filtered_wo_nan['P_Number'] == filtered_wo_nan.iloc[[1]]['id_word'].values[0][:-4]]\n",
    "n = group_of_same_text[(group_of_same_text['id_line'][0] == group_of_same_text['id_line'] + 1) | (group_of_same_text['id_line'][0] == group_of_same_text['id_line'] - 1)]\n",
    "n['lemma'].values.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 34
    },
    "colab_type": "code",
    "id": "C4bhXTPEMTUp",
    "outputId": "c4170e52-cecd-47bd-e42c-e0068fbc3f11"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "552802"
      ]
     },
     "execution_count": 10,
     "metadata": {
      "tags": []
     },
     "output_type": "execute_result"
    }
   ],
   "source": [
    "neigh = filtered.to_csv('filtered_with_neighbors.csv')\n",
    "len(filtered)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 34
    },
    "colab_type": "code",
    "id": "DV1eMuTUYGaf",
    "outputId": "46a1c891-dd15-44bf-b15f-7f4cb7728021"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "157490"
      ]
     },
     "execution_count": 64,
     "metadata": {
      "tags": []
     },
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered.index[filtered['id_line'].isnull()].tolist()[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 34
    },
    "colab_type": "code",
    "id": "n7oVE_n6YZbP",
    "outputId": "6c1c3646-d6b8-4754-a93f-a859e39bf68a"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "157490"
      ]
     },
     "execution_count": 65,
     "metadata": {
      "tags": []
     },
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered.index[157490]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 421
    },
    "colab_type": "code",
    "id": "tTmGWV9ob5Lb",
    "outputId": "d1d07224-72ba-44c9-cd2b-207371466a93"
   },
   "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>lemma</th>\n",
       "      <th>id_text</th>\n",
       "      <th>id_line</th>\n",
       "      <th>id_word</th>\n",
       "      <th>label</th>\n",
       "      <th>prof?</th>\n",
       "      <th>role?</th>\n",
       "      <th>family?</th>\n",
       "      <th>neighbors</th>\n",
       "      <th>P_Number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>3(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>3.0</td>\n",
       "      <td>P124149.3.1</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>udu[sheep]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>3.0</td>\n",
       "      <td>P124149.3.2</td>\n",
       "      <td>o 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>6(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>4.0</td>\n",
       "      <td>P124149.4.1</td>\n",
       "      <td>o 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>u[ewe]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>4.0</td>\n",
       "      <td>P124149.4.2</td>\n",
       "      <td>o 2</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2(diš)[]NU</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>5.0</td>\n",
       "      <td>P124149.5.1</td>\n",
       "      <td>o 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>mašgal[goat]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>5.0</td>\n",
       "      <td>P124149.5.2</td>\n",
       "      <td>o 3</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>šugid[~animal]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>6.0</td>\n",
       "      <td>P124149.6.1</td>\n",
       "      <td>o 4</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>emuhaldim[kitchen]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>6.0</td>\n",
       "      <td>P124149.6.2</td>\n",
       "      <td>o 4</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>mu[name]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>7.0</td>\n",
       "      <td>P124149.7.1</td>\n",
       "      <td>o 5</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>gardu[soldier]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>7.0</td>\n",
       "      <td>P124149.7.2</td>\n",
       "      <td>o 5</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>šag[heart]N</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>9.0</td>\n",
       "      <td>P124149.9.1</td>\n",
       "      <td>r 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>tum-ma-al{ki}[]GN</td>\n",
       "      <td>epsd2/admin/u3adm/P124149</td>\n",
       "      <td>9.0</td>\n",
       "      <td>P124149.9.2</td>\n",
       "      <td>r 1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>[]</td>\n",
       "      <td>P124149</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0                lemma  ... neighbors  P_Number\n",
       "0            0           3(diš)[]NU  ...        []   P124149\n",
       "1            1          udu[sheep]N  ...        []   P124149\n",
       "2            2           6(diš)[]NU  ...        []   P124149\n",
       "3            3              u[ewe]N  ...        []   P124149\n",
       "4            4           2(diš)[]NU  ...        []   P124149\n",
       "5            5        mašgal[goat]N  ...        []   P124149\n",
       "6            6      šugid[~animal]N  ...        []   P124149\n",
       "7            7  emuhaldim[kitchen]N  ...        []   P124149\n",
       "8            8            mu[name]N  ...        []   P124149\n",
       "9            9      gardu[soldier]N  ...        []   P124149\n",
       "10          10          šag[heart]N  ...        []   P124149\n",
       "11          11    tum-ma-al{ki}[]GN  ...        []   P124149\n",
       "\n",
       "[12 rows x 11 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {
      "tags": []
     },
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered_wo_nan[filtered_wo_nan['P_Number'] == filtered_wo_nan.iloc[[3]]['id_word'].values[0][:-4]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 130
    },
    "colab_type": "code",
    "id": "3qO-g2f1dSbj",
    "outputId": "f2b71055-9411-4b68-fe31-b8230e081351"
   },
   "outputs": [
    {
     "ename": "SyntaxError",
     "evalue": "ignored",
     "output_type": "error",
     "traceback": [
      "\u001b[0;36m  File \u001b[0;32m\"<ipython-input-84-b98488dcea28>\"\u001b[0;36m, line \u001b[0;32m1\u001b[0m\n\u001b[0;31m    group_of_same_text.loc([3, :])\u001b[0m\n\u001b[0m                               ^\u001b[0m\n\u001b[0;31mSyntaxError\u001b[0m\u001b[0;31m:\u001b[0m invalid syntax\n"
     ]
    }
   ],
   "source": [
    "group_of_same_text[.loc([3, :])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "OhtGqU0nfJuJ"
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "colab": {
   "collapsed_sections": [],
   "name": "Sumerian",
   "provenance": []
  },
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}