get dates from texts.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "135e8ccd",
   "metadata": {},
   "outputs": [],
   "source": [
    "# finished US 226: 020 - Implementatie tijdlijninformatie-extractie\n",
    "# pandas library is hoogstwaarschijnlijk al in de code aanwezig, alleen datefinder moet toegevoegd worden.\n",
    "import datefinder\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "ef5f3396",
   "metadata": {},
   "outputs": [],
   "source": [
    "def find_dates_in_text(text: str, sentence_store = True) -> str:\n",
    "    \"\"\"Args:\n",
    "    - text: one text file (CV) that we want to get the dates out of\n",
    "    - sentence_store: true or false statement, decides if we store the sentence with the date or only the date.\n",
    "    Output:\n",
    "    - pandas dataframe with the CV dates and if chosen the relevant sentences\n",
    "    required libraries:\n",
    "    - datefinder, pandas as pd\"\"\"\n",
    "    \n",
    "    characters_to_replace = [\"?\", \"\\n\", \",\"]\n",
    "    for item in characters_to_replace:\n",
    "        text = text.replace(item,\".\")\n",
    "    sentences = text.split(\".\")\n",
    "\n",
    "    date_store = []\n",
    "    for sentence in sentences:\n",
    "        for match in datefinder.find_dates(sentence):\n",
    "            print_date = pd.to_datetime(pd.Series(match)).dt.strftime('%d/%m/%Y')\n",
    "            if sentence_store == True:\n",
    "                date_store.append([print_date, sentence])\n",
    "            else:\n",
    "                date_store.append(print_date)\n",
    "    return pd.DataFrame(date_store)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "3665355d",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Hieronder een test voorbeeld\n",
    "# al de volgende code moet NIET toegevoegd worden, is alleen voor test\n",
    "# in de email staat een CV_sample_test data bestand, code hieronder is het inladen van het bestand\n",
    "import openpyxl\n",
    "path = \"CV_sample_test.xlsx\"\n",
    "wb_obj = openpyxl.load_workbook(path) \n",
    "\n",
    "sheet_obj = wb_obj.active \n",
    "cell_obj = sheet_obj.cell(row = 2, column = 2) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "6e4feb63",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0    21/12/2013\n",
       "dtype: object</td>\n",
       "      <td>2013 – 2013 Minor Embedded Vision Design aan d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0    21/12/2014\n",
       "dtype: object</td>\n",
       "      <td>2011 – 2014 HBO Embedded Systems Engineering a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0    21/12/2011\n",
       "dtype: object</td>\n",
       "      <td>2008 – 2011 MBO ICT-Beheerder Niv</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0    04/12/2022\n",
       "dtype: object</td>\n",
       "      <td>4 aan de ROC Aventus te Apeldoorn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0    06/12/2022\n",
       "dtype: object</td>\n",
       "      <td>2022 Qt 6 Core Advanced with C++</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0    06/12/2022\n",
       "dtype: object</td>\n",
       "      <td>2022 Qt 6 Core Intermediate with C++</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0    06/12/2022\n",
       "dtype: object</td>\n",
       "      <td>2022 Qt 6 Core Beginners with C++</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0    21/12/2021\n",
       "dtype: object</td>\n",
       "      <td>2021 Complete Python Developer 2021: Zero to M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0    07/12/2022\n",
       "dtype: object</td>\n",
       "      <td>2015 Oracle Certified Associate (OCA): Java SE...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0    21/01/2015\n",
       "dtype: object</td>\n",
       "      <td>jan 2015 – heden CIMSOLUTIONS B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0    21/01/2014\n",
       "dtype: object</td>\n",
       "      <td>jan 2014 – jul 2014 EAL Apeldoorn B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0    21/07/2014\n",
       "dtype: object</td>\n",
       "      <td>jan 2014 – jul 2014 EAL Apeldoorn B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0    21/08/2013\n",
       "dtype: object</td>\n",
       "      <td>aug 2013 – dec 2014 DNVN    Software Engineer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0    21/12/2014\n",
       "dtype: object</td>\n",
       "      <td>aug 2013 – dec 2014 DNVN    Software Engineer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0    21/08/2010\n",
       "dtype: object</td>\n",
       "      <td>aug 2010 – feb 2011 AVOO    Software Engineer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0    21/02/2011\n",
       "dtype: object</td>\n",
       "      <td>aug 2010 – feb 2011 AVOO    Software Engineer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0    21/08/2009\n",
       "dtype: object</td>\n",
       "      <td>aug 2009 – feb 2010 Paradigit Computers B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0    21/02/2010\n",
       "dtype: object</td>\n",
       "      <td>aug 2009 – feb 2010 Paradigit Computers B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0    21/04/2022\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Medisch PERIODE: april 2022 – nu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0    21/01/2022\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Industrie  PERIODE: jan 2022 – apri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0    21/04/2022\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Industrie  PERIODE: jan 2022 – apri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0    21/11/2021\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Cosmetica/Consument PERIODE: nov 20...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0    21/02/2022\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Cosmetica/Consument PERIODE: nov 20...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0    21/08/2021\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Cosmetica/Consument PERIODE: aug 20...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0    21/02/2022\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Cosmetica/Consument PERIODE: aug 20...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0    21/02/2021\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Medisch  PERIODE: feb 2021 – aug 2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0    21/08/2021\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Medisch  PERIODE: feb 2021 – aug 2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0    19/12/2022\n",
       "dtype: object</td>\n",
       "      <td>en wegens het COVID-19 virus is er besloten o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0    19/12/2022\n",
       "dtype: object</td>\n",
       "      <td>en wegens het COVID-19 virus is er besloten o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0    19/12/2022\n",
       "dtype: object</td>\n",
       "      <td>Implementeren algoritme COVID-19 in samenswer...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>0    21/07/2020\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Medisch PERIODE: jul 2020 – mrt 2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>0    21/01/2018\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Medisch PERIODE: jan 2018 – jun 2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>0    21/06/2020\n",
       "dtype: object</td>\n",
       "      <td>BRANCHE: Medisch PERIODE: jan 2018 – jun 2020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                0  \\\n",
       "0   0    21/12/2013\n",
       "dtype: object   \n",
       "1   0    21/12/2014\n",
       "dtype: object   \n",
       "2   0    21/12/2011\n",
       "dtype: object   \n",
       "3   0    04/12/2022\n",
       "dtype: object   \n",
       "4   0    06/12/2022\n",
       "dtype: object   \n",
       "5   0    06/12/2022\n",
       "dtype: object   \n",
       "6   0    06/12/2022\n",
       "dtype: object   \n",
       "7   0    21/12/2021\n",
       "dtype: object   \n",
       "8   0    07/12/2022\n",
       "dtype: object   \n",
       "9   0    21/01/2015\n",
       "dtype: object   \n",
       "10  0    21/01/2014\n",
       "dtype: object   \n",
       "11  0    21/07/2014\n",
       "dtype: object   \n",
       "12  0    21/08/2013\n",
       "dtype: object   \n",
       "13  0    21/12/2014\n",
       "dtype: object   \n",
       "14  0    21/08/2010\n",
       "dtype: object   \n",
       "15  0    21/02/2011\n",
       "dtype: object   \n",
       "16  0    21/08/2009\n",
       "dtype: object   \n",
       "17  0    21/02/2010\n",
       "dtype: object   \n",
       "18  0    21/04/2022\n",
       "dtype: object   \n",
       "19  0    21/01/2022\n",
       "dtype: object   \n",
       "20  0    21/04/2022\n",
       "dtype: object   \n",
       "21  0    21/11/2021\n",
       "dtype: object   \n",
       "22  0    21/02/2022\n",
       "dtype: object   \n",
       "23  0    21/08/2021\n",
       "dtype: object   \n",
       "24  0    21/02/2022\n",
       "dtype: object   \n",
       "25  0    21/02/2021\n",
       "dtype: object   \n",
       "26  0    21/08/2021\n",
       "dtype: object   \n",
       "27  0    19/12/2022\n",
       "dtype: object   \n",
       "28  0    19/12/2022\n",
       "dtype: object   \n",
       "29  0    19/12/2022\n",
       "dtype: object   \n",
       "30  0    21/07/2020\n",
       "dtype: object   \n",
       "31  0    21/01/2018\n",
       "dtype: object   \n",
       "32  0    21/06/2020\n",
       "dtype: object   \n",
       "\n",
       "                                                    1  \n",
       "0   2013 – 2013 Minor Embedded Vision Design aan d...  \n",
       "1   2011 – 2014 HBO Embedded Systems Engineering a...  \n",
       "2                   2008 – 2011 MBO ICT-Beheerder Niv  \n",
       "3                  4 aan de ROC Aventus te Apeldoorn   \n",
       "4                    2022 Qt 6 Core Advanced with C++  \n",
       "5                2022 Qt 6 Core Intermediate with C++  \n",
       "6                   2022 Qt 6 Core Beginners with C++  \n",
       "7   2021 Complete Python Developer 2021: Zero to M...  \n",
       "8   2015 Oracle Certified Associate (OCA): Java SE...  \n",
       "9                     jan 2015 – heden CIMSOLUTIONS B  \n",
       "10                jan 2014 – jul 2014 EAL Apeldoorn B  \n",
       "11                jan 2014 – jul 2014 EAL Apeldoorn B  \n",
       "12      aug 2013 – dec 2014 DNVN    Software Engineer  \n",
       "13      aug 2013 – dec 2014 DNVN    Software Engineer  \n",
       "14      aug 2010 – feb 2011 AVOO    Software Engineer  \n",
       "15      aug 2010 – feb 2011 AVOO    Software Engineer  \n",
       "16          aug 2009 – feb 2010 Paradigit Computers B  \n",
       "17          aug 2009 – feb 2010 Paradigit Computers B  \n",
       "18          BRANCHE: Medisch PERIODE: april 2022 – nu  \n",
       "19    BRANCHE: Industrie  PERIODE: jan 2022 – apri...  \n",
       "20    BRANCHE: Industrie  PERIODE: jan 2022 – apri...  \n",
       "21    BRANCHE: Cosmetica/Consument PERIODE: nov 20...  \n",
       "22    BRANCHE: Cosmetica/Consument PERIODE: nov 20...  \n",
       "23    BRANCHE: Cosmetica/Consument PERIODE: aug 20...  \n",
       "24    BRANCHE: Cosmetica/Consument PERIODE: aug 20...  \n",
       "25     BRANCHE: Medisch  PERIODE: feb 2021 – aug 2021  \n",
       "26     BRANCHE: Medisch  PERIODE: feb 2021 – aug 2021  \n",
       "27   en wegens het COVID-19 virus is er besloten o...  \n",
       "28   en wegens het COVID-19 virus is er besloten o...  \n",
       "29   Implementeren algoritme COVID-19 in samenswer...  \n",
       "30      BRANCHE: Medisch PERIODE: jul 2020 – mrt 2021  \n",
       "31      BRANCHE: Medisch PERIODE: jan 2018 – jun 2020  \n",
       "32      BRANCHE: Medisch PERIODE: jan 2018 – jun 2020  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# uitvoeren van de functie\n",
    "find_dates_in_text(cell_obj.value, True)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}