Analysis notebook.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.7.3"
    },
    "varInspector": {
      "cols": {
        "lenName": 16,
        "lenType": 16,
        "lenVar": 40
      },
      "kernels_config": {
        "python": {
          "delete_cmd_postfix": "",
          "delete_cmd_prefix": "del ",
          "library": "var_list.py",
          "varRefreshCmd": "print(var_dic_list())"
        },
        "r": {
          "delete_cmd_postfix": ") ",
          "delete_cmd_prefix": "rm(",
          "library": "var_list.r",
          "varRefreshCmd": "cat(var_dic_list()) "
        }
      },
      "types_to_exclude": [
        "module",
        "function",
        "builtin_function_or_method",
        "instance",
        "_Feature"
      ],
      "window_display": false
    },
    "colab": {
      "name": "testing notebook.ipynb",
      "provenance": [],
      "toc_visible": true
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "9QxCo2O3QuFf",
        "colab_type": "text"
      },
      "source": [
        "# Analysis of Resume data"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "k4FWiy7OLU2V",
        "colab_type": "text"
      },
      "source": [
        "## Setup Google colab"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1C0DV42TJGX0",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 153
        },
        "outputId": "5ae89c5f-08f1-425d-a7d6-0d4ade5a42cf"
      },
      "source": [
        "!bash setup.sh"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Cloning into 'datartistry'...\n",
            "remote: Enumerating objects: 988, done.\u001b[K\n",
            "remote: Counting objects:   0% (1/988)\u001b[K\rremote: Counting objects:   1% (10/988)\u001b[K\rremote: Counting objects:   2% (20/988)\u001b[K\rremote: Counting objects:   3% (30/988)\u001b[K\rremote: Counting objects:   4% (40/988)\u001b[K\rremote: Counting objects:   5% (50/988)\u001b[K\rremote: Counting objects:   6% (60/988)\u001b[K\rremote: Counting objects:   7% (70/988)\u001b[K\rremote: Counting objects:   8% (80/988)\u001b[K\rremote: Counting objects:   9% (89/988)\u001b[K\rremote: Counting objects:  10% (99/988)\u001b[K\rremote: Counting objects:  11% (109/988)\u001b[K\rremote: Counting objects:  12% (119/988)\u001b[K\rremote: Counting objects:  13% (129/988)\u001b[K\rremote: Counting objects:  14% (139/988)\u001b[K\rremote: Counting objects:  15% (149/988)\u001b[K\rremote: Counting objects:  16% (159/988)\u001b[K\rremote: Counting objects:  17% (168/988)\u001b[K\rremote: Counting objects:  18% (178/988)\u001b[K\rremote: Counting objects:  19% (188/988)\u001b[K\rremote: Counting objects:  20% (198/988)\u001b[K\rremote: Counting objects:  21% (208/988)\u001b[K\rremote: Counting objects:  22% (218/988)\u001b[K\rremote: Counting objects:  23% (228/988)\u001b[K\rremote: Counting objects:  24% (238/988)\u001b[K\rremote: Counting objects:  25% (247/988)\u001b[K\rremote: Counting objects:  26% (257/988)\u001b[K\rremote: Counting objects:  27% (267/988)\u001b[K\rremote: Counting objects:  28% (277/988)\u001b[K\rremote: Counting objects:  29% (287/988)\u001b[K\rremote: Counting objects:  30% (297/988)\u001b[K\rremote: Counting objects:  31% (307/988)\u001b[K\rremote: Counting objects:  32% (317/988)\u001b[K\rremote: Counting objects:  33% (327/988)\u001b[K\rremote: Counting objects:  34% (336/988)\u001b[K\rremote: Counting objects:  35% (346/988)\u001b[K\rremote: Counting objects:  36% (356/988)\u001b[K\rremote: Counting objects:  37% (366/988)\u001b[K\rremote: Counting objects:  38% (376/988)\u001b[K\rremote: Counting objects:  39% (386/988)\u001b[K\rremote: Counting objects:  40% (396/988)\u001b[K\rremote: Counting objects:  41% (406/988)\u001b[K\rremote: Counting objects:  42% (415/988)\u001b[K\rremote: Counting objects:  43% (425/988)\u001b[K\rremote: Counting objects:  44% (435/988)\u001b[K\rremote: Counting objects:  45% (445/988)\u001b[K\rremote: Counting objects:  46% (455/988)\u001b[K\rremote: Counting objects:  47% (465/988)\u001b[K\rremote: Counting objects:  48% (475/988)\u001b[K\rremote: Counting objects:  49% (485/988)\u001b[K\rremote: Counting objects:  50% (494/988)\u001b[K\rremote: Counting objects:  51% (504/988)\u001b[K\rremote: Counting objects:  52% (514/988)\u001b[K\rremote: Counting objects:  53% (524/988)\u001b[K\rremote: Counting objects:  54% (534/988)\u001b[K\rremote: Counting objects:  55% (544/988)\u001b[K\rremote: Counting objects:  56% (554/988)\u001b[K\rremote: Counting objects:  57% (564/988)\u001b[K\rremote: Counting objects:  58% (574/988)\u001b[K\rremote: Counting objects:  59% (583/988)\u001b[K\rremote: Counting objects:  60% (593/988)\u001b[K\rremote: Counting objects:  61% (603/988)\u001b[K\rremote: Counting objects:  62% (613/988)\u001b[K\rremote: Counting objects:  63% (623/988)\u001b[K\rremote: Counting objects:  64% (633/988)\u001b[K\rremote: Counting objects:  65% (643/988)\u001b[K\rremote: Counting objects:  66% (653/988)\u001b[K\rremote: Counting objects:  67% (662/988)\u001b[K\rremote: Counting objects:  68% (672/988)\u001b[K\rremote: Counting objects:  69% (682/988)\u001b[K\rremote: Counting objects:  70% (692/988)\u001b[K\rremote: Counting objects:  71% (702/988)\u001b[K\rremote: Counting objects:  72% (712/988)\u001b[K\rremote: Counting objects:  73% (722/988)\u001b[K\rremote: Counting objects:  74% (732/988)\u001b[K\rremote: Counting objects:  75% (741/988)\u001b[K\rremote: Counting objects:  76% (751/988)\u001b[K\rremote: Counting objects:  77% (761/988)\u001b[K\rremote: Counting objects:  78% (771/988)\u001b[K\rremote: Counting objects:  79% (781/988)\u001b[K\rremote: Counting objects:  80% (791/988)\u001b[K\rremote: Counting objects:  81% (801/988)\u001b[K\rremote: Counting objects:  82% (811/988)\u001b[K\rremote: Counting objects:  83% (821/988)\u001b[K\rremote: Counting objects:  84% (830/988)\u001b[K\rremote: Counting objects:  85% (840/988)\u001b[K\rremote: Counting objects:  86% (850/988)\u001b[K\rremote: Counting objects:  87% (860/988)\u001b[K\rremote: Counting objects:  88% (870/988)\u001b[K\rremote: Counting objects:  89% (880/988)\u001b[K\rremote: Counting objects:  90% (890/988)\u001b[K\rremote: Counting objects:  91% (900/988)\u001b[K\rremote: Counting objects:  92% (909/988)\u001b[K\rremote: Counting objects:  93% (919/988)\u001b[K\rremote: Counting objects:  94% (929/988)\u001b[K\rremote: Counting objects:  95% (939/988)\u001b[K\rremote: Counting objects:  96% (949/988)\u001b[K\rremote: Counting objects:  97% (959/988)\u001b[K\rremote: Counting objects:  98% (969/988)\u001b[K\rremote: Counting objects:  99% (979/988)\u001b[K\rremote: Counting objects: 100% (988/988)\u001b[K\rremote: Counting objects: 100% (988/988), done.\u001b[K\n",
            "remote: Compressing objects: 100% (966/966), done.\u001b[K\n",
            "remote: Total 3613 (delta 23), reused 963 (delta 12), pack-reused 2625\u001b[K\n",
            "Receiving objects: 100% (3613/3613), 350.96 MiB | 28.19 MiB/s, done.\n",
            "Resolving deltas: 100% (484/484), done.\n",
            "Checking out files: 100% (4075/4075), done.\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "hyBqNRZvJJXE",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "1a9d48d1-97e3-4bde-e82c-24b95a2a66df"
      },
      "source": [
        "%cd datartistry"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/content/datartistry\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dbfFcm2XJUSW",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 207
        },
        "outputId": "f16d97d3-7c58-4c9e-99ae-1c15c10a6c54"
      },
      "source": [
        "!git checkout -b modeling\n",
        "!git push -u origin modeling"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Switched to a new branch 'modeling'\n",
            "Warning: Permanently added the RSA host key for IP address '192.30.255.112' to the list of known hosts.\n",
            "Total 0 (delta 0), reused 0 (delta 0)\n",
            "remote: \n",
            "remote: Create a pull request for 'modeling' on GitHub by visiting:\u001b[K\n",
            "remote:      https://github.com/Inventrohyder/datartistry/pull/new/modeling\u001b[K\n",
            "remote: \n",
            "To github.com:Inventrohyder/datartistry.git\n",
            " * [new branch]      modeling -> modeling\n",
            "Branch 'modeling' set up to track remote branch 'modeling' from 'origin'.\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "YKGOwY8ELZZq",
        "colab_type": "text"
      },
      "source": [
        "## Begin Analysis"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "0eX9F7SkRaMF",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import os\n",
        "import pandas as pd"
      ],
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "zVTu4B20Rhz5",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 289
        },
        "outputId": "8c532c91-cfd7-4eb7-8a06-407a840dd95b"
      },
      "source": [
        "# list all txt files\n",
        "path = '/content/datartistry/ResumeParser/data/output/'\n",
        "\n",
        "files = []       # Store the file paths\n",
        "categories = []  # Store the job category of each file\n",
        "text = []        # Store the actual text data\n",
        "num_words = []   # Count the number of words in each file\n",
        "\n",
        "# r=root, d=directories, f = files\n",
        "for r, d, f in os.walk(path):\n",
        "    for file in f:\n",
        "        if '.txt' in file:\n",
        "          file_path = os.path.join(r, file)\n",
        "          files.append(file_path)\n",
        "\n",
        "          category = file.split('-')[0]\n",
        "          categories.append(category)\n",
        "\n",
        "          with open(file_path) as text_file:\n",
        "            data = text_file.read()\n",
        "            text.append(data)\n",
        "            words = data.split()\n",
        "            num_words.append(len(words))\n",
        "\n",
        "df = pd.DataFrame(\n",
        "    {\n",
        "     \"category\": categories, \n",
        "     \"file_path\": files, \n",
        "     \"len_words\": num_words,\n",
        "     \"text\": text\n",
        "     }\n",
        ")\n",
        "df.head()"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>category</th>\n",
              "      <th>file_path</th>\n",
              "      <th>len_words</th>\n",
              "      <th>text</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>fund_accounting</td>\n",
              "      <td>/content/datartistry/ResumeParser/data/output/...</td>\n",
              "      <td>679</td>\n",
              "      <td>QIAN BOWEN\\n\\nMobile: + 65 9060 7342\\n\\nEmail:...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>fund_accounting</td>\n",
              "      <td>/content/datartistry/ResumeParser/data/output/...</td>\n",
              "      <td>871</td>\n",
              "      <td>Dina V. Nagao \\n\\n    E: DinaVNagao@gmail.com ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>corporate_secretary</td>\n",
              "      <td>/content/datartistry/ResumeParser/data/output/...</td>\n",
              "      <td>710</td>\n",
              "      <td>\\n\\n \\n \\nEXPERIENCE \\n\\n \\n\\n \\n\\n \\n\\n \\n\\n...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>sales</td>\n",
              "      <td>/content/datartistry/ResumeParser/data/output/...</td>\n",
              "      <td>559</td>\n",
              "      <td>\\n\\n \\n\\n \\n\\n \\n\\n \\n\\n \\n\\n \\n\\n \\n\\nYee Ch...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>sales</td>\n",
              "      <td>/content/datartistry/ResumeParser/data/output/...</td>\n",
              "      <td>501</td>\n",
              "      <td>Terence Neo\\n\\nSingaporean Chinese, born 1985\\...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "              category  ...                                               text\n",
              "0      fund_accounting  ...  QIAN BOWEN\\n\\nMobile: + 65 9060 7342\\n\\nEmail:...\n",
              "1      fund_accounting  ...  Dina V. Nagao \\n\\n    E: DinaVNagao@gmail.com ...\n",
              "2  corporate_secretary  ...   \\n\\n \\n \\nEXPERIENCE \\n\\n \\n\\n \\n\\n \\n\\n \\n\\n...\n",
              "3                sales  ...   \\n\\n \\n\\n \\n\\n \\n\\n \\n\\n \\n\\n \\n\\n \\n\\nYee Ch...\n",
              "4                sales  ...  Terence Neo\\n\\nSingaporean Chinese, born 1985\\...\n",
              "\n",
              "[5 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xBzsw7YbLJxI",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 372
        },
        "outputId": "6d89872b-a5a7-417e-d588-9fa09cc29066"
      },
      "source": [
        "# Counts of job categories\n",
        "df['category'].value_counts().plot(kind='bar')"
      ],
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f3e86d71cc0>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAFSCAYAAAAJoZ97AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3dabhkVXn28f/N7MQkLSKgjYgQQARsEQJJHKIMimCiiJEhiKIGFWfBxGg0RDEiEY0ogggIMogKKqiICKKINFMDDby2DAHC0CIgSlBp7/fDWkVXH073OX3O3lVdm/t3XXWdql1V+1nVXfXUrrXXepZsExER3bLcsBsQERHNS3KPiOigJPeIiA5Kco+I6KAk94iIDlph2A0AWGuttTxz5sxhNyMiYqRcdtllv7Y9Y7z7lonkPnPmTGbPnj3sZkREjBRJtyzuvnTLRER0UJJ7REQHJblHRHRQkntERAcluUdEdFCSe0REByW5R0R0UJJ7REQHTTq5S1pe0hWSvlNvbyDpEknzJJ0qaaW6feV6e169f2Y7TY+IiMVZmhmqBwHXAavW24cBR9g+RdIXgP2Bo+rfe20/S9Ke9XGvnWoDZx783Sk97+ZPvHyqISMiRt6kjtwlrQe8HDim3hbwYuDr9SHHA7vX67vV29T7X1IfHxERAzLZbpn/At4P/LnefjJwn+2H6+3bgHXr9XWBWwHq/ffXxy9C0gGSZkuaPX/+/Ck2PyIixjNhcpf0CuBu25c1Gdj20bZn2Z41Y8a4Rc0iImKKJtPnvj3wSkm7AKtQ+tw/A6wuaYV6dL4ecHt9/O3A+sBtklYAVgPuabzlERGxWBMeuds+xPZ6tmcCewI/sv164Hzg1fVh+wJn1utn1dvU+39k2422OiIilmg649w/ALxb0jxKn/qxdfuxwJPr9ncDB0+viRERsbSWarEO2z8Gflyv3whsM85jHgJe00DbIiJiijJDNSKig5LcIyI6KMk9IqKDktwjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDktwjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDktwjIjpoMgtkryLpF5KuknStpH+r278i6SZJV9bLlnW7JB0paZ6kOZK2bvtFRETEoiazEtMfgBfb/p2kFYGLJJ1T73uf7a+PefzOwEb18gLgqPo3IiIGZDILZNv27+rNFetlSQte7wacUJ/3c2B1SetMv6kRETFZk+pzl7S8pCuBu4FzbV9S7zq0dr0cIWnlum1d4Na+p99Wt43d5wGSZkuaPX/+/Gm8hIiIGGtSyd32AttbAusB20jaHDgE2AR4PrAm8IGlCWz7aNuzbM+aMWPGUjY7IiKWZKlGy9i+Dzgf2Mn2HbXr5Q/AccA29WG3A+v3PW29ui0iIgZkMqNlZkhavV5/HPBS4PpeP7okAbsD19SnnAXsU0fNbAvcb/uOVlofERHjmsxomXWA4yUtT/kyOM32dyT9SNIMQMCVwFvq488GdgHmAQ8C+zXf7IiIWJIJk7vtOcBW42x/8WIeb+DA6TctIiKmKjNUIyI6KMk9IqKDktwjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDktwjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDktwjIjooyT0iooOS3CMiOmgya6iuIukXkq6SdK2kf6vbN5B0iaR5kk6VtFLdvnK9Pa/eP7PdlxAREWNN5sj9D8CLbT8X2BLYqS58fRhwhO1nAfcC+9fH7w/cW7cfUR8XEREDNGFyd/G7enPFejHwYuDrdfvxwO71+m71NvX+l0hSYy2OiIgJTarPXdLykq4E7gbOBX4F3Gf74fqQ24B16/V1gVsB6v33A08eZ58HSJotafb8+fOn9yoiImIRk0ruthfY3hJYD9gG2GS6gW0fbXuW7VkzZsyY7u4iIqLPUo2WsX0fcD6wHbC6pBXqXesBt9frtwPrA9T7VwPuaaS1ERExKZMZLTND0ur1+uOAlwLXUZL8q+vD9gXOrNfPqrep9//ItptsdERELNkKEz+EdYDjJS1P+TI4zfZ3JM0FTpH078AVwLH18ccCJ0qaB/wG2LOFdkdExBJMmNxtzwG2Gmf7jZT+97HbHwJe00jrIiJiSjJDNSKig5LcIyI6KMk9IqKDktwjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDktwjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDktwjIjpoMsvsrS/pfElzJV0r6aC6/SOSbpd0Zb3s0vecQyTNk3SDpB3bfAEREfFok1lm72HgPbYvl/Qk4DJJ59b7jrD9qf4HS9qUsrTeZsDTgB9KerbtBU02PCIiFm/CI3fbd9i+vF5/gLI49rpLeMpuwCm2/2D7JmAe4yzHFxER7VmqPndJMynrqV5SN71N0hxJX5a0Rt22LnBr39NuY8lfBhER0bBJJ3dJTwTOAN5p+7fAUcCGwJbAHcDhSxNY0gGSZkuaPX/+/KV5akRETGBSyV3SipTEfpLtbwDYvsv2Att/Br7Ewq6X24H1+56+Xt22CNtH255le9aMGTOm8xoiImKMyYyWEXAscJ3tT/dtX6fvYa8CrqnXzwL2lLSypA2AjYBfNNfkiIiYyGRGy2wP7A1cLenKuu2DwOskbQkYuBl4M4DtayWdBsyljLQ5MCNlIiIGa8LkbvsiQOPcdfYSnnMocOg02hUREdOQGaoRER2U5B4R0UFJ7hERHZTkHhHRQUnuEREdlOQeEdFBSe4RER2U5B4R0UFJ7hERHZTkHhHRQUnuEREdlOQeEdFBSe4RER2U5B4R0UFJ7hERHZTkHhHRQUnuEREdNJk1VNeXdL6kuZKulXRQ3b6mpHMl/bL+XaNul6QjJc2TNEfS1m2/iIiIWNRkjtwfBt5je1NgW+BASZsCBwPn2d4IOK/eBtiZsij2RsABwFGNtzoiIpZowuRu+w7bl9frDwDXAesCuwHH14cdD+xer+8GnODi58DqktZpvOUREbFYS9XnLmkmsBVwCbC27TvqXXcCa9fr6wK39j3ttrpt7L4OkDRb0uz58+cvZbMjImJJJp3cJT0ROAN4p+3f9t9n24CXJrDto23Psj1rxowZS/PUiIiYwKSSu6QVKYn9JNvfqJvv6nW31L931+23A+v3PX29ui0iIgZkMqNlBBwLXGf70313nQXsW6/vC5zZt32fOmpmW+D+vu6biIgYgBUm8Zjtgb2BqyVdWbd9EPgEcJqk/YFbgD3qfWcDuwDzgAeB/RptcURETGjC5G77IkCLufsl4zzewIHTbFdERExDZqhGRHRQkntERAcluUdEdFCSe0REByW5R0R0UJJ7REQHJblHRHRQkntERAcluUdEdFCSe0REByW5R0R0UJJ7REQHJblHRHTQZEr+PqbMPPi7U3rezZ94ecMtiYiYuhy5R0R0UJJ7REQHJblHRHTQZNZQ/bKkuyVd07ftI5Jul3RlvezSd98hkuZJukHSjm01PCIiFm8yR+5fAXYaZ/sRtresl7MBJG0K7AlsVp/zeUnLN9XYiIiYnAmTu+0Lgd9Mcn+7AafY/oPtmyiLZG8zjfZFRMQUTKfP/W2S5tRumzXqtnWBW/sec1vd9iiSDpA0W9Ls+fPnT6MZEREx1lST+1HAhsCWwB3A4Uu7A9tH255le9aMGTOm2IyIiBjPlJK77btsL7D9Z+BLLOx6uR1Yv++h69VtERExQFNK7pLW6bv5KqA3kuYsYE9JK0vaANgI+MX0mhgREUtrwvIDkr4GvBBYS9JtwIeBF0raEjBwM/BmANvXSjoNmAs8DBxoe0E7TY+IiMWZMLnbft04m49dwuMPBQ6dTqMiImJ6MkM1IqKDktwjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDktwjIjooC2QPWRbkjog25Mg9IqKDktwjIjooyT0iooOS3CMiOijJPSKig5LcIyI6KMk9IqKDJkzukr4s6W5J1/RtW1PSuZJ+Wf+uUbdL0pGS5kmaI2nrNhsfERHjm8yR+1eAncZsOxg4z/ZGwHn1NsDOlHVTNwIOAI5qppkREbE0Jkzuti8EfjNm827A8fX68cDufdtPcPFzYPUxi2lHRMQATLXPfW3bd9TrdwJr1+vrArf2Pe62ui0iIgZo2idUbRvw0j5P0gGSZkuaPX/+/Ok2IyIi+kw1ud/V626pf++u228H1u973Hp126PYPtr2LNuzZsyYMcVmRETEeKaa3M8C9q3X9wXO7Nu+Tx01sy1wf1/3TUREDMiEJX8lfQ14IbCWpNuADwOfAE6TtD9wC7BHffjZwC7APOBBYL8W2hwREROYMLnbft1i7nrJOI81cOB0GxUREdOTGaoRER2U5B4R0UFJ7hERHZTkHhHRQUnuEREdlOQeEdFBEw6FjG6ZefB3p/S8mz/x8oZbEhFtypF7REQHJblHRHRQkntERAcluUdEdFCSe0REB2W0TLQqo3MihiNH7hERHZTkHhHRQUnuEREdlOQeEdFB0zqhKulm4AFgAfCw7VmS1gROBWYCNwN72L53es2MiIil0cSR+4tsb2l7Vr19MHCe7Y2A8+rtiIgYoDa6ZXYDjq/Xjwd2byFGREQswXSTu4EfSLpM0gF129q276jX7wTWHu+Jkg6QNFvS7Pnz50+zGRER0W+6k5h2sH27pKcA50q6vv9O25bk8Z5o+2jgaIBZs2aN+5iIiJiaaR252769/r0b+CawDXCXpHUA6t+7p9vIiIhYOlNO7pKeIOlJvevAy4BrgLOAfevD9gXOnG4jIyJi6UynW2Zt4JuSevs52fb3JF0KnCZpf+AWYI/pNzMiIpbGlJO77RuB546z/R7gJdNpVERETE9mqEZEdFCSe0REByW5R0R0UJJ7REQHJblHRHRQkntERAdlDdXolKzZGlEkuUdMQ75MYlmVbpmIiA7KkXvEiMivhFgaOXKPiOigJPeIiA5Kt0xEjCvdQKMtR+4RER2U5B4R0UHplomIZUK6gZqVI/eIiA5q7chd0k7AZ4DlgWNsf6KtWBERS6vrvxRaOXKXtDzw38DOwKbA6yRt2kasiIh4tLaO3LcB5tV1VpF0CrAbMLeleBERy7RB/1KQ7Sk9cYk7lV4N7GT7jfX23sALbL+t7zEHAAfUmxsDN0wh1FrAr6fZ3MRLvC7E6/JrS7zFe4btGePdMbTRMraPBo6ezj4kzbY9q6EmJV7ijWy8Lr+2xJuatkbL3A6s33d7vbotIiIGoK3kfimwkaQNJK0E7Amc1VKsiIgYo5VuGdsPS3ob8H3KUMgv2762hVDT6tZJvMTrULwuv7bEm4JWTqhGRMRwZYZqREQHJblHRHRQkntERAcluQcAkpaTtOqw2zHqJD1O0sbDbkcs2yQtL+mkNmOMXMlfSVuPs/l+4BbbD7cQbwdgI9vHSZoBPNH2TU3H6Yt3mO0PTLStoVgnA28BFlCGr64q6TO2/7OFWIfT3qip8eK9e0n32/50CzF3BT4FrARsIGlL4KO2X9l0rBrv8cB7gKfbfpOkjYCNbX+npXgrA38PzKQvd9j+aEvx3g581fa9bex/MTEH8nm3vUDSMyStZPuPTe8fRvPI/fPAzylDh74EXAycDtwg6WVNBpL0YeADwCF104rAV5uMMY6XjrNt55ZibWr7t8DuwDnABsDeLcW6Djha0iWS3iJptZbi9DxpgksbPkKpq3QfgO0rKf+mbTkO+AOwXb19O/DvLcY7k1Ij6mHg932XtqwNXCrpNEk7SVKLsYbxeb8R+KmkD0l6d+/S1M5H7sgd+F9g/94RYK02+VHg/cA3gB80GOtVwFbA5QC2/1dSK4lB0luBfwKeKWlO311PAn7aRkxgRUkrUpL752z/SVIrY2NtHwMcU7ss9gPmSPop8CXb57cQ79+a3uck/Mn2/WNyUJtjjTe0/VpJrwOw/WDLCXA92zu1uP9F2P4XSR8CXkZ5z3xO0mnAsbZ/1ULIgX3eq1/Vy3K0cMAxisn92f0/7W3PlbSJ7RtbeF//0bZ7CU/SE5oO0OdkytHzx4GD+7Y/YPs3LcX8InAzcBVwoaRnAL9tKVavFPQm9fLrGvfdkt5se8+WYq4C7A9sBqzS2277DS2Eu1bSPwDL1y6SdwA/ayFOzx8lPY76BSJpQ8qRfFt+Juk5tq9uMcYi6ufvTuBOyi+GNYCvSzrX9vsbDjfIz/sjByCSHm/7wab3P4rdMtdKOkrS39TL54G5tT/wTw3HOk3SF4HVJb0J+CGlK6hxtu+3fTPwL8Cdtm+h/KTfS9LqLcU80va6tndxcQvwojZiSToCuB7YBfgP28+zfZjtXSlHS205EXgqsCNwAaXO0QMtxXo75UvkD5Qv6/uBd7YUC+DDwPeA9evJufMov2DbsgNwmaQbJM2RdPWYX5mNknSQpMuAT1J+vT7H9luB51H6/ps2sM87gKTtJM2lfC6Q9Nyaz5rZ/6jNUK1HKv9EeaNB+U//PPAQ8Hjbv2s43kspPwsFfN/2uU3uf5x4VwKzKCetzqb0c25me5cWYq0N/AfwNNs71y6u7Wwf23AcUb60Pm37UX20klazfX+TMfv2fYXtrSTNsb1F7Yb6ie1t24hXY7ZyJLaYWE8GtqW8P39uu7UytfWX3aPUg4I24n0EOG68/Uv6C9vXtRBzYJ93SZcArwbOsr1V3XaN7c0bCWA7l8VcKEfOq/Tdfhwws+WYl9e/7wfeXq9f0VKsc4A9gKvq7RWAq1uK1cp+JxH3F/XvhcDmlLrZN7YU6y8pC9L8T739XODzLb62VwGr9d1eHdi9hTir1r9rjndp6bUtD1w/4PfKQD/vwCX17xV9265qav8j1y0jaXtJ50r6f5Ju7F1aCnc68Oe+2wvqtjb9qZ4g2wfoDWlbsaVYa9k+jfoaXYaSLmgp1uWSnt/SvpfkaElrAB+iVCadS/mZ34YjKN0/9wDYvgr465ZiAXzYfb94bN9H6app2sn172XA7Pr3sr7bjbO9gDIC7ult7H8xBv15v1XSXwKWtKKk91JGlTViFE+oHgu8i/LGaisR9azgvjGotv+oUsK4TftRxp4favsmSRtQ+o3b8Pv6s753AmlbSj9xG14AvF7SLZThc6KcL9uipXjAI6N0oPS3P7PNWDXerWNO7Lf5Hh3v4Kzxz7TtV9S/bQ7rHM8alHNsv6BvyKVbmjfA4D/vbwE+A6xLGQX4feDApnY+isn9ftvnDCjWfEmvtH0WgKTdaH/prQ2Bd9ruHU3fBBzWUqx3U45mN6zDEmdQ+gDbsGNL+12ixYwbvh+4zGUcepMWORIDDqLBI7FxzJb0acpi9FASw2UtxkPSFjx6EtM3Wgr3oZb2uzgD/by7nB95fVv7H8UTqp+g9Md9g75hX7YvbyHWhsBJwNMoR5q3AvvYntd0rL6YX6VMSjmDMqPz+rZi1XgrUNawFXCD7aZHHI2N9xQWHZL4Py3HO5lygvrbddMrgDmUBHW67ca6aCStRTkS+1vKv+cPgHe4paGsdajeh2o8gHOBf/c4J60bivdlYAvgWhZ2X9jtDCsduDGfd4DbgL3dzph6JD2T8n7ZlvLr+WLgXbYb6WYexeQ+3oQX235xizGfWIM0OhJnCfFWBV5H6aIxZSbi12w3MoRP0t8t6f42jsQkvRI4nPLBuRt4BnCd7c2ajjUm7oXALr3/u/p/+V1gJ8rR+6YNxtre9k8n2jaqJM1t8t9rEvG2BT4L/AWlpMPywO9tN14Dqc7BOMz2ewf1eZf0c8qvrq/VTXtSBlG8oIn9j1y3jO1WxmGPR2NqafT6Ut1SLY0e27+V9HXK2fp3UkZFvE/SkbY/20CIXZcUnvKrqGkfoxyh/NBlaOKLgL1aiDPWU1h0Ys+fgLVt/5+kpif8fBYYW/tovG2NkPRs4L08upukrQOdiyVtantuS/sf63OUhHc65dfXPsCz2wjkUutlh3p9IAdxlKHb/efTvirpfU3tfGSSu6S9bH91MX2ouIVCUJQx5vdT+jHbnPn3iHqEux/wLOAEYBvbd6sUiZpLSRbTYnu/6e5jCv5k+x6V6pPL2T5f0n8NIO5JwCWSzqy3dwVOrl0ajSQpSdtRhkHOGPP+XJVytNmW04EvAMfQ/uACKO/Hi+uM0T8wgJPitudJWr6OnjlO0hUsrP3StCsknUX5d+0/gdvWOYVzJB0MnEI5qHotcLakNWvcaXXnjUxyB3pTgcerwdBW39JAa2lUfw8cYfvC/o0udUP2bzqYpJfz6Kn5bfwyua/+3L0QOEnS3bRbdAoA2x+TdA6wfd30Ftu94XtNncxaCXgi5fPU//78Le2doAZ42PZRLe5/rGMpheWuZtEhg215sI5WuVLSJ4E7aHdW/SqUYaz9v3za+iULZY4JwJvHbN+zxp3W6K5R7HMfWL+mpKOBz3qAtTQGSdIXgMdTSg4cQ0lEv7DdxpfIE4D/o3w4Xw+sRinn2lbdnP7YAynjKukZrrMpJS1X47RZq+cjlPMX32TRwQVtncC92PZ2Ez+ysXjPAO6ifHm+i/Ke+e+2TnB2zSgm98ttbz3RtoZizaV0j9xEyz9DJT3Aor9AVG/3YrZxEqk3Jb/394nAObb/qoVYA6tTPybGhyn9tRvbfrakp1FGyWw/wVOnEutR9fGBVurj13jjfUHZdivj+VXqnqxOGXnU/2XSypGtpINsf2aibQ3GO45xegHaGg1Uh8u+lYUT3X4MfLGpEWsj0y0zpH7NtuqoP4rtNkuLLs5D9e+DNen9BlinpVgvpdTK7rfzONuaNsgyrpvWk+Gvp5R2OJhyvqaV5D6ESUWPoyT1/nUT2uy22JcyVLDfP46zrSn9i5ysQnnv/G9LsQCOosw+7xUL27tue2MTOx+Z5M4Q+jX7fmIvMjZ7EAY0HvzbKhUn/5OS/EzDVfA0nDr1/QZZxnVg9fF7JG0ObMqi75UT2og1qBPxKuU3/oGymtVZfXetSjkAaYXtM8a042vARW3FA55v+7l9t38k6aqmdj4yyd32BcAFkr7ilqrQjbW4sdmUE5BdiHk9sMD2GSoVIbcGvtVwjGHUqe83tozrG2ivjOug6+N/GHghJbmfTfkldBFlVEuTcT7LEgYt2H5Hk/EoNfDvoBR5O7xv+wOUCWiDshFlKG1bFkjasHcOoU5qamzU0yj2uQ9sbG/9Fn0xY8Zmt3HCcRgx+/rad6CMQ/8U8K9NTaIYJ17/ic21gCe1cWJznLgDLds8JvYKbmFt37rvqymVJ6+w/VyVEs5ftT3eUo3TibNvvbo95Yvk1Hr7NcBc229pMt6Y2M+gvGd+qFLue4WmJvONE6t33qt3vutO4JCxR/QNxnsJZYLijTXmM4D93NDKZCNz5N5nkGN7hzE2e5Axe/9+L6csd/ddSa2swdl/YpPyhl6Jsj5l4yc2x6rJvPWELulfF3NXW5Pe/s/2nyU9rDKr+W5g/aaD2D4eHuli26H3ZVVHW/2k6Xg99ZfWAZTSwhtSFlr5AvCSNuIN+ryX7fNUFzWvm26w3dh8mlFM7oMc2zuMsdmDjHl77bJ4KXCYyozctsYRD3R9ynFGHz1yFy2NPmLR/6dVKHVs2i4ctjqlm+ky4HeU+iRtWYNF+72fWLe15UDKguOXANj+ZT0X1ZraLfrI6BXb31nS46cYY3HlP54lqbHRR6PYLfMRBjS2t558e4iSEHpjs0+yfU/TsYYRU2XW606UhTR+KWkdylJmTS4y3ov1C9vb9Iat1td5cZuzG4etfll+3/YLBxBrJmVRjTaXvdsP+AhwPuX9+dfAR3pH9i3Eu8T2C7RwNa0VKIvZtPKeUSlK+HzKrGYo9Z0utf3BhuMct4S73dTQy1FM7gMd2xvNUFmIYCPKr4SPU05snuxmauUsk1QWCbnU9rMa3u8mtq+XNO7cDrdQIbUv9tMoQ/auo0yA+9+xs6kbjPVJ4D5KTZm3U0ZdzbX9zy3FmwNs6VpuW6WY2BWjegAycsl9kOrPp8MoZ8xFuz/phxazbZJE6S/dhCGd2ByEeoKz94FanlIf/6O2P9dwnC/ZfpMGXCFV0hspNerXA66kFIK7uMV4ooz5fuQ9AxzjlpJWTe4v7PUCqNR4+XGLvxRaXcN45JK7pH3G297G2F5J84Bd3cJCvMtSzEGQdLXt5wy7HW3SogtIPwzc1dZImWGoX17PpyzEvaWkTYD/sL3EEtJTjLU8cK3tTZre9xJivg74BIt2Ox1s+9QlPnHq8c6hDC745zraaQXKL4VGPiejeEK1fx3OVShnzi+n4bG91V1DSLLDiDkIl0t6vu1Lh92QNtRk9P1BJKMlnJADWq1i+JDthyQhaeXaNbTxxE9bei4leG+Q9PSWJvCNF/Nrkn7MwhzzAdt3thhyLdunSTqkxn9YUmMjAEcuudt+e//tOlrglJbCzZZ0KmViT+u1NIYYcxCGsobqoAw4GQ2jHj/AbfXz9i3gXEn3Am1OKBzoGqqStgeutH2WpL2A90v6TIuTJltdw3jkumXGUpnufY3txo8gFnNWu7Gz2ctKzEEY02XxiBY/OAOnsurTVsCgFnQeGkl/QxnJ9T33LSrdQoxHcZmt3ka8OZRJYVtQukuOBfawPW47Goj3POBIYHPgGuoaxk2NeBq5I3dJ32bRk1Z/AZzWRiwPYVGLYcQckHUofagPANRJN39Bu0d+g9Yb294j2lvcnHrU92FgB8pn4iLKCdzWhur2tJVgx/gf4A7bDwHUGaprtxjvYdtWWRj7v20fqxbWUOixfVn9AmtlDeORS+6UKfI9DwO32L6tyQCS3m/7k1pMTQ03X0ujP/YqwP48egGNkT5yp1S76x+697txto26FcYmvZqQ2nIKZbLb39fbr6eUBvjbxT5jtJxOqQTbs6Bue/74D5+2B2r/997AX6nU5F+xpVi9XwqnAKe6hRr1ba5q0or64bmeUlVwDaCNn4S9MrS/osz8G3tp04nAU4EdgQsow85aqaUxYOofwlbHEo/iwcWjSHprHUmysaQ5fZebaLfQ1Tq2P2b7pnr5d9o9sh20Ffq7fOr1lVqM91rKea431BOp69FSueZqV64fRv0AABCDSURBVMoB6mmSLpX0XklPb2zvtkfqQlma6hbgeMoImZso/VRNxphLqcp4FeULZM3+S8uv74r6d079uyJl6NnQ/+2n+bq+Abyjvp4VKeOlvzXsdjX02lajFLL7GqX4U+/S9nvl05Ql2Zarlz2ATw3736PB13cu8Mq+27sB57Uc8xnA39brj6cUtxvEa92o5rMFTe1z5E6oqlRNfKntu+vtGZQKis9d8jOXKkZvNtwzgdv776Ll2bB90/QvrG24k7L03UjPwK01QY6kVLw0cB7wzt7/Yyy9Wj/nCSxcz3Q5Fp7ItUd44huApA0ppQDWpbxnbgP2sT2vpXiPFCqzvaFKUa8v2G6lUFmN+QzKL4bXUrqdTrV9+JKfNcl9j2ByX2QyTO0Xu8otTJCRdJTttza93wlivhE4A3gO8BVKcaYP2f7iINsRsaxQKaSH7d+1HOdKaqEy21vVba1NvpN0CeVX7OmUpH5jk/sfxT7P70n6PuUnMJRvvHPaCDToxF5jHlOvXsg4q59L2tctFWpqk0od/qOAtW1vLmkLyk/uVkoMP1bUf8eZLLq2wajPiQDan54/jj/Y/mOpelBq8bOERUoasI/tG9ra+SieUH0fZcWbLerlaNvvH26rBuqgYTdgir4EHAL8CcBlLO+eQ23RiJP0ZeDLlNEyu9bLK5b4pNHyFUo9mafV2/8PeGeL8S6Q9EHgcSoLvJxOWQy8LfdJOraWIUDSpk0OvRzFbpkNGGfsq+2bh9qwAVEtfzrsdiwtSZfafn5/+yVdaXvLYbdtVEmaa3vTYbejLYN+zwyhUFmrtWVG7sid8m36577bvbGvjxWj9W280K/rCbLeVOtXU9bJjKm7uHZVdFWr0/P71dpA19n+ku3X2H51vd7m520t26dR85lLkbnHbm0Zxhn7KqnNsa/LGg27AVN0IHA0sImk2ylDWPcabpNG3gmUBH8nZXx2p+r1AO8GzgI2lPRT6vT8NgJ5CIXKaPnLaxST+3xJr7R9FkCdKvzrIbepMZI28JhFo8ds++kQmjVtdSTA36qswLScW1rk+DHmWMpsyqtZ9NdsV2wI7ExZF/bvKcXn2sxZAy1URstfXqPY594b+9o7ydLq2NdBU12Gbsy2y2w/b1htaoKkgyj9iw9QTq5uTamV3fiSfo8Vki62vd2w29EWSXNsbyFpB+BjlNIj/2r7BS3FG2ihshpzBVJbpnCpwbDtoMa+DorKwgebAatp0Xrdq9JXY2aEvcH2ZyTtCDyZcsR5IpDkPnVXSDqZMqKjS+Whe3r9zy8HvmT7u5JaGzo7URJv6stUi6/H/2w1uED2yCV3Sf8BfNL2ffX2GsB7bP/LcFs2bRtThrGtzqL1uh8A3jSUFjWrd65gF+AE29eqN6A4pupxlKT+sr5tbdZzH7TbJX2Rsu7uYSoLjg9zEEhTB1m9z/dTKIXRflRvvwj4GQ39/41it8yjhgKO15UxqiRtZ/viYbejabVO/brABpSa2ctT1qcc6e6maI+kxwM7AVfb/qWkdYDnDKsrr+k8I+kHwL6276i31wG+YnvHJvY/ckfuwPIqS3z9AR4Z577ykNvUpHl1IsVMFp11OOolf/cHtgRutP1gHSXwSO16SZvZvnZorRtBktYDPgtsXzf9BDjIDZfAHhbbD9J3FFuTYJeGz67fS+zVXUBjVSFHMbmfBJynhSsW7UepENkVZ1I+pD+kwTGvw+ZS4vfyvtv3AP2LSpxIt2q7D8JxwMnAa+rtveq2lw6tRd3WdDfieeOUUvlhUzsfuW4ZAEk7UxbGBjjX9veH2Z4mPVZnbY7qzNthGu+98lh9/wyCpM1tX9PwPl8F/HW9eaHtbza271FM7l1WRwP8zPbZw27LIHXpvMmgSDqPcqTeO/J7HbBfmyVqu6yOYjmMcqJTLJwUNpTSydMdnTNyyb3O4vosZf3NlSgn5n4/6rWre/pqdP+xXob6BhuUJPelV2uBfxbYjjJK5mfA223fOtSGjShJ84BdbV837LbA9H/NjmKf++co1QRPB2YB+wDPHmqLGmT7ScNuw5C0sVxi132UMtriXgBJa1Im+oz6yfdhuWtZSezVtI68R7FwGHU26vK2F9g+jjJcqhNU7CXpQ/X2+pK2GXa7pqvvdf1rvf30/tdle9vhtW5kbdFL7AC2fwPkvMXUzZZ0qqTXSfq73mXYjZqqUTxyf7AWCrtS0icpQ6NG8ktqMT5PqRPyYsqU698B/017K74PSv/r+ihlctYZjP7rGqblJK0x5sh9FD/Ty4pVgQdZdiaFTWt0zii+EfamJPO3Ae9iYVGhrniB7a0lXQFg+96OVL3s6usapsMpVSF7Ja9fAxw6xPaMNNv7TfyoZtXzJhvZ/mGds7NCX1G9vaez75FL7rZvqVcfAv5t7P2SzrA9ysn+T7W2dK8M6Ay6UfGvq69raGyfIGk25dcQwN/ZnjvMNo0ySatQJtttRl+pgbYmEKpvQW5KBcz1gC9Qh3lPd9hll7ozeh617uiIORL4JvAUSYcCF1HWkRx1472ujw+3SaPP9lzbn6uXJPbpORF4KrAjcAEl2bZZmvpAyuzi3wLY/iVlGGYjRu7IfRJGa2znGLZPknQZ5dtbwO7L2Bn8Kenq64pOeZbt10jazfbxteLmT1qM1+qC3F1M7l1wF+VNtQJlsd6tbV8+wXOWaZJOtL03cP042yKWBb1a6vdJ2hy4kwaPpMdxgRZdkPufaHBB7i4m95EuIyvpY8A/Ar9i4be4WdivOqo2679R+99TETKWJUfXEuIfoqyQ9ETgX1uM9wHKgtxXA28GzgaOaWrnIzdDdSKSXjbKq/tIuoFS1rQTk3okHQJ8kFJ7/EEWfvn+ETja9iHDalvEsNSDm2ttb9JajFFJ7pKuZgn9UV1ZFFjSGcBbbd897LY0SdLHk8hjWSZpdcqM95ksWm77HS3FO5NSLqKVBblHqVvmFfXvgfXvifXv64fQljZ9nLJ82jUsunRaW4v0DoTtQ+pP3o1YdJjZhcNrVcQizgZ+zuAWHG91Qe6ROXLveQysxHQt8EXGvMHaXKR3ECS9ETiIMrzsSmBb4GLbo34uITpi0HlELS/IPUpH7j2StL3tn9Ybf0m3xus/aPvIYTeiBQdRSg383PaLVBYE78L4/eiOE+vEou+w6K/m37QRrO0DtlFM7vsDX5a0GuXk3L10qwreTyR9nHK2vv8NNtJDIYGHbD8kibpM4vWSNh52oyL6/BH4T+CfWXSkWisTI9suXz5yyd32ZcBza3LH9v1DblLTel1O/VUSuzAU8rZ6wupbwLmS7gVumeA5EYP0HspEpl8PKF6r5ctHsc99ZUqhsJksekb7o8NqU5MkPdP2jRNtG2W1r3E14HtdGfIZo0/SDygzpx8cULzZtmdJmtMb7dfkcpMjd+ROWUD6fuAy+rotOuTrPHqh6NMZ4Qk/Y8f0jvrJ4eis31NKiZ/Pol2irQyFpOXy5aOY3Nez3ZnFOXrqCcbNgNXGLBCwKn1DB0eR7QWSbpD09LbG9EY04Fv1Miitli8fxeT+M0nPsX31sBvSsI0pY/lXB3bt2/4A8KahtKhZrY7pjZgu28cPOOSzgLtt/5ZxypdP1yj2uc+l/KPcRPnp1FtAuiszVLezffGw29G0tsf0RkyXpJsYZxa87bZGyxxPWdz8N5RCgRcCF/UvnTgdo3jkvvOwG9CyV9WJTP8HfA/YAniX7a8Ot1nTY/sCSWuzcFm9X3StxEKMvFl911ehrGy1ZlvBbO8LIOlpwKspy2k+jYby8igeuT99vO1d6cuVdKXtLSW9itJN827gQtvPHXLTpkXSHpQxxD+m/Nr6K+B9tr8+zHZFLImky2y3MphB0l6Uz8FzgF9TFrD5SVO/3EfxyP27lJ9Oony7bgDcwJiSsiNsxfr35cDptu/vFfMfcf8MPL93tF6X2fshZXRQxNBJ6h+lthzlSL7NHPlflNLeXwDOt31zkzsfueRu+zn9t+t/yD8NqTlt+Lak6yndMm+tSfChIbepCcuN6Ya5h26VjYjRdzgL+9wfBm6mdM20wvZakjYD/ho4VNJGwA1NLWAzct0y45F09dikP8okrQncX4cQPgF4ku07h92u6ZD0n5TzB1+rm14LzLH9geG1KmKhukD22AmSbmuCpKRVKWuo/g2le2Yt4BLb+zSy/1FL7pLe3XdzOcrknjVt7zikJjVK0uMp/exPt31A/Tbf2PZ3hty0aavj93eoN39i+5vDbE9EP0nfA+4DLgcW9LbbPryleHMo/ewXUc6r3dbo/kcluffW25R0H3BE3dz76XSG7S50XSDpVMrs231sb16T/c9sbznkpk2bpKcCL6CUMr501H+NRLdIusb25gOMt4ft08Zse43t05vY/yj1eT6vDhn6H0oltc8CRwHnAI8fZsMatqHtT1IX6611Lkb+jGqt5/4L4FWUYV8/l9Slap4x+n4maZDduwePs62x1cpG6YTqF4DzKKNjZvdtFy2W5RyCP0p6HPXEjqQN6UYNnfcBW9m+B0DSk4GfAV8eaqviMa9vCc8VgP0k3UiLEyQl7QzsAqwrqX/thlUpvRGNGJnkXhewOFLSUbbfOuz2tOgjlMlL60s6iXLC5R+H2aCG3EMppdDzQN0WMWyvmPghjfoN5QD1lZQu2J4HKDVmGjEyfe6PJfWodlvKkcPPB1hfujWSTqBM1jiTcpS0GzCnXrD96eG1LmJwesv5STrZ9j+0FWdkjtwfKyR9GzgZOMv27yd6/Aj5Vb30nFn/PmkIbYkYppUk/QPwgjEVYAGw/Y0mgiS5L3s+RRkD/glJlwKnAN8Z5dFAtZ77k2y/d9htiVgGvAV4PY+uAAvlV20jyT3dMsuomhBfTCn3u1NT6yoOi6SLbW837HZELCsk7W/72Lb2nyP3ZVAdLbMr5Qh+a2DQdabbcKWksyirSvXXc2/kKCViBJ0o6R2U8gMAFwBfsP2nJnaeI/dljKTTgG0oI2ZOBS6w/efhtmr6JB03zmbbzlj3eEySdAylUGDv4G1vYIHtNzay/yT3ZYukHYEf2l4w4YMjYmRJumpsKe/xtk1VumWWMba/L+kvJc2k7//H9glDa1QDJK1HmVW8fd30E+CgputpRIyQBZI2tP0rAEnPpK+mzXQluS9jJJ0IbAhcycL/aAMjndyB4yhDPHslVPeq2146tBZFDNd7gfPrjFgo1Sj3a2rnSe7LnlnApu5ef9kM2/397l+R9M6htSZi+J4MbE5J6rtT1lO9v6mdj1LhsMeKa4CnDrsRLbhH0l6Slq+XvUj5gXhs+5Dt31JqyrwI+BylGGIjktyXPWsBcyV9X9JZvcuwG9WANwB7AHcCd1AqQ/7jMBsUMWS9bteXA1+y/V1gpaZ2nm6ZZc9Hht2AlnwU2Nf2vfDIalOfoiT9iMei2yV9kXLe6TBJK9PgAXeGQsZASLrC9lYTbYt4rKgL8ewEXG37l5LWAZ5j+wdN7D9H7ssISRfZ3kHSAyxcpBcW1pQe6fIDwHKS1hhz5J73Xzxm1YV4vtF3+w5Kl2Uj8uFaRtjeof7tapXEw4GLJfWWEHsNcOgQ2xPRaemWiYGRtCmlGBrAj2zPHWZ7IrosyT0iooMyFDIiooOS3CMiOijJPSKig5LcIyI66P8DXJIrGwIcszgAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Uf3iPS5hX0qc",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 238
        },
        "outputId": "d316ac8b-a686-46c4-8a37-279d2c0bbdcd"
      },
      "source": [
        "df['category'].value_counts()"
      ],
      "execution_count": 32,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "fund_accounting        404\n",
              "finance                163\n",
              "investment_analyst     123\n",
              "sales                   77\n",
              "corporate_secretary     66\n",
              "legal                   26\n",
              "trustee                 24\n",
              "compliance              21\n",
              "admin                   16\n",
              "secretary                9\n",
              "human_resource           6\n",
              "software_developer       1\n",
              "Name: category, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rcqWWXdaa7cF",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 282
        },
        "outputId": "68ee1834-5056-4be2-f9d1-98c01953aa0b"
      },
      "source": [
        "# Histogram of the length of a resume\n",
        "df['len_words'].hist()"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f3e86ccf278>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAD4CAYAAAAXUaZHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAQqUlEQVR4nO3df6zddX3H8edbyq9wXQtCbkjb7MIgM4RuCDeA0ZhbiFpgWVmCBkO0uC5NNkw01sQ6k02TJatbkGhiNJ2QVWO8MNRAQOJY4Yb4B7hWgRYIcmF144a1QUr1IrrVvffH+RSvd/fHued8T885nz0fycn9fj+f7/d7Pu9+Tl/9nu/53tPITCRJdXlTvwcgSWqe4S5JFTLcJalChrskVchwl6QKrer3AADOPvvsHBsb62jf1157jTPOOKPZAfVBDXXUUANYxyCpoQboXR379u17OTPPWahvIMJ9bGyMvXv3drTv1NQUExMTzQ6oD2qoo4YawDoGSQ01QO/qiIifLNbnZRlJqpDhLkkVMtwlqUKGuyRVyHCXpAoZ7pJUIcNdkipkuEtShQx3SarQQPyG6rAa23F/Y8favuEYN7d5vIM7r2vseSXVyTN3SaqQ4S5JFTLcJalChrskVchwl6QKGe6SVCHDXZIqZLhLUoUMd0mqkOEuSRUy3CWpQoa7JFXIcJekChnuklQhw12SKmS4S1KFDHdJqlDb4R4RJ0XEjyLivrJ+XkQ8FhHTEXFnRJxS2k8t69Olf6w3Q5ckLWYlZ+4fBZ6Zs/454LbMvAA4Amwt7VuBI6X9trKdJOkEaivcI2IdcB3w1bIewFXA3WWT3cD1ZXlzWaf0X122lySdIJGZy28UcTfwt8CbgU8ANwOPlrNzImI98EBmXhwRB4BNmfli6XseuCIzX553zG3ANoDR0dHLJicnOypgdnaWkZGRjvbt1v6Zo40da/R0OPR6e9tuWLu6sedtUj/noknWMThqqAF6V8fGjRv3Zeb4Qn2rlts5Iv4IOJyZ+yJioqlBZeYuYBfA+Ph4Tkx0duipqSk63bdbN++4v7Fjbd9wjFv3LzsdABy8aaKx521SP+eiSdYxOGqoAfpTRztp8g7gjyPiWuA04HeALwBrImJVZh4D1gEzZfsZYD3wYkSsAlYDP2185JKkRS17zT0zP5WZ6zJzDLgReCgzbwIeBm4om20B7inL95Z1Sv9D2c61H0lSY7q5z/2TwMcjYhp4C3B7ab8deEtp/ziwo7shSpJWqr2LvEVmTgFTZfkF4PIFtvkl8L4GxiZJ6pC/oSpJFTLcJalChrskVchwl6QKGe6SVCHDXZIqZLhLUoUMd0mqkOEuSRUy3CWpQoa7JFXIcJekChnuklQhw12SKmS4S1KFDHdJqpDhLkkVMtwlqUKGuyRVyHCXpAoZ7pJUIcNdkipkuEtShQx3SaqQ4S5JFTLcJalChrskVchwl6QKGe6SVCHDXZIqZLhLUoUMd0mqkOEuSRUy3CWpQoa7JFXIcJekChnuklQhw12SKrRsuEfEaRHxg4h4IiKeiojPlvbzIuKxiJiOiDsj4pTSfmpZny79Y70tQZI0Xztn7r8CrsrMPwQuATZFxJXA54DbMvMC4AiwtWy/FThS2m8r20mSTqBlwz1bZsvqyeWRwFXA3aV9N3B9Wd5c1in9V0dENDZiSdKyIjOX3yjiJGAfcAHwJeDvgUfL2TkRsR54IDMvjogDwKbMfLH0PQ9ckZkvzzvmNmAbwOjo6GWTk5MdFTA7O8vIyEhH+3Zr/8zRxo41ejocer29bTesXd3Y8zapn3PRJOsYHDXUAL2rY+PGjfsyc3yhvlXtHCAzfw1cEhFrgO8Ab+12UJm5C9gFMD4+nhMTEx0dZ2pqik737dbNO+5v7FjbNxzj1v1tTQcHb5po7Hmb1M+5aJJ1DI4aaoD+1LGiu2Uy81XgYeDtwJqIOJ5G64CZsjwDrAco/auBnzYyWklSW9q5W+accsZORJwOvBt4hlbI31A22wLcU5bvLeuU/oeynWs/kqTGtHMd4Fxgd7nu/ibgrsy8LyKeBiYj4m+AHwG3l+1vB74eEdPAK8CNPRi3JGkJy4Z7Zj4JvG2B9heAyxdo/yXwvkZGJ0nqiL+hKkkVMtwlqUKGuyRVyHCXpAoZ7pJUIcNdkipkuEtShQx3SaqQ4S5JFTLcJalChrskVchwl6QKtfe/Q2igjDX4n4Ss1MGd1/XtuSW1zzN3SaqQ4S5JFTLcJalChrskVchwl6QKGe6SVCHDXZIqZLhLUoUMd0mqkOEuSRUy3CWpQoa7JFXIcJekChnuklQhw12SKmS4S1KFDHdJqpDhLkkVMtwlqUKGuyRVyHCXpAoZ7pJUIcNdkipkuEtShZYN94hYHxEPR8TTEfFURHy0tJ8VEQ9GxHPl55mlPSLiixExHRFPRsSlvS5CkvTb2jlzPwZsz8yLgCuBWyLiImAHsCczLwT2lHWAa4ALy2Mb8OXGRy1JWtKy4Z6ZL2XmD8vyz4FngLXAZmB32Ww3cH1Z3gx8LVseBdZExLmNj1yStKjIzPY3jhgDHgEuBv49M9eU9gCOZOaaiLgP2JmZ3y99e4BPZubeecfaRuvMntHR0csmJyc7KmB2dpaRkZGO9u3W/pmjjR1r9HQ49Hpjh+uZDWtXL9rXz7loknUMjhpqgN7VsXHjxn2ZOb5Q36p2DxIRI8C3gI9l5s9aed6SmRkR7f8r0dpnF7ALYHx8PCcmJlay+xumpqbodN9u3bzj/saOtX3DMW7d3/Z09M3BmyYW7evnXDTJOgZHDTVAf+po626ZiDiZVrB/IzO/XZoPHb/cUn4eLu0zwPo5u68rbZKkE6Sdu2UCuB14JjM/P6frXmBLWd4C3DOn/UPlrpkrgaOZ+VKDY5YkLaOd6wDvAD4I7I+Ix0vbXwI7gbsiYivwE+D9pe+7wLXANPAL4MONjliStKxlw718MBqLdF+9wPYJ3NLluCRJXfA3VCWpQoa7JFXIcJekChnuklQhw12SKmS4S1KFDHdJqpDhLkkVMtwlqUKGuyRVyHCXpAoZ7pJUIcNdkipkuEtShQx3SaqQ4S5JFTLcJalChrskVchwl6QKGe6SVCHDXZIqZLhLUoUMd0mqkOEuSRUy3CWpQoa7JFXIcJekChnuklQhw12SKmS4S1KFDHdJqpDhLkkVMtwlqUKGuyRVyHCXpAoZ7pJUIcNdkiq0bLhHxB0RcTgiDsxpOysiHoyI58rPM0t7RMQXI2I6Ip6MiEt7OXhJ0sLaOXP/R2DTvLYdwJ7MvBDYU9YBrgEuLI9twJebGaYkaSWWDffMfAR4ZV7zZmB3Wd4NXD+n/WvZ8iiwJiLObWqwkqT2RGYuv1HEGHBfZl5c1l/NzDVlOYAjmbkmIu4Ddmbm90vfHuCTmbl3gWNuo3V2z+jo6GWTk5MdFTA7O8vIyEhH+3Zr/8zRxo41ejocer2xw/XMhrWrF+3r51w0yToGRw01QO/q2Lhx477MHF+ob1W3B8/MjIjl/4X4v/vtAnYBjI+P58TEREfPPzU1Raf7duvmHfc3dqztG45x6/6up6PnDt40sWhfP+eiSdYxOGqoAfpTR6d3yxw6frml/Dxc2meA9XO2W1faJEknUKfhfi+wpSxvAe6Z0/6hctfMlcDRzHypyzFKklZo2esAEfFNYAI4OyJeBP4a2AncFRFbgZ8A7y+bfxe4FpgGfgF8uAdjVh+NLXEpavuGY41eqprr4M7renJcqVbLhntmfmCRrqsX2DaBW7odlCSpO/6GqiRVyHCXpAoZ7pJUIcNdkipkuEtShQx3SaqQ4S5JFTLcJalChrskVchwl6QKGe6SVKHB/wLxZeyfOdqzL6uSpGHlmbskVchwl6QKGe6SVCHDXZIqZLhLUoUMd0mqkOEuSRUy3CWpQoa7JFXIcJekChnuklQhw12SKjT0Xxym/x/GTuCXw23fcOyNL6M7uPO6E/a8UpM8c5ekChnuklQhw12SKmS4S1KFDHdJqpDhLkkVMtwlqULe5y4t4UTeXz+f99irG565S1KFDHdJqpDhLkkVMtwlqUJ+oCoNqG4/zJ37BWgr4Qe5dehJuEfEJuALwEnAVzNzZy+eR1LzvEOoDo1flomIk4AvAdcAFwEfiIiLmn4eSdLienHmfjkwnZkvAETEJLAZeLoHzyWpIvPfNXR6aWnQLFVHr96tRGY2e8CIG4BNmflnZf2DwBWZ+ZF5220DtpXV3wee7fApzwZe7nDfQVJDHTXUANYxSGqoAXpXx+9m5jkLdfTtA9XM3AXs6vY4EbE3M8cbGFJf1VBHDTWAdQySGmqA/tTRi1shZ4D1c9bXlTZJ0gnSi3D/V+DCiDgvIk4BbgTu7cHzSJIW0fhlmcw8FhEfAb5H61bIOzLzqaafZ46uL+0MiBrqqKEGsI5BUkMN0Ic6Gv9AVZLUf379gCRVyHCXpAoNdbhHxKaIeDYipiNiR7/Hs5SIOBgR+yPi8YjYW9rOiogHI+K58vPM0h4R8cVS15MRcWkfx31HRByOiANz2lY87ojYUrZ/LiK2DEANn4mImTIfj0fEtXP6PlVqeDYi3junva+vt4hYHxEPR8TTEfFURHy0tA/NfCxRw1DNR0ScFhE/iIgnSh2fLe3nRcRjZUx3lptKiIhTy/p06R9brr6uZeZQPmh9WPs8cD5wCvAEcFG/x7XEeA8CZ89r+ztgR1neAXyuLF8LPAAEcCXwWB/H/S7gUuBAp+MGzgJeKD/PLMtn9rmGzwCfWGDbi8pr6VTgvPIaO2kQXm/AucClZfnNwI/LeIdmPpaoYajmo/yZjpTlk4HHyp/xXcCNpf0rwJ+X5b8AvlKWbwTuXKq+JsY4zGfub3zNQWb+F3D8aw6GyWZgd1neDVw/p/1r2fIosCYizu3HADPzEeCVec0rHfd7gQcz85XMPAI8CGzq/ehbFqlhMZuBycz8VWb+GzBN67XW99dbZr6UmT8syz8HngHWMkTzsUQNixnI+Sh/prNl9eTySOAq4O7SPn8ujs/R3cDVEREsXl/Xhjnc1wL/MWf9RZZ+kfRbAv8cEfui9dULAKOZ+VJZ/k9gtCwPem0rHfeg1vORcrnijuOXMhiSGsrb+rfROmMcyvmYVwMM2XxExEkR8ThwmNY/kM8Dr2bmsQXG9MZ4S/9R4C30sI5hDvdh887MvJTWt2XeEhHvmtuZrfdoQ3df6rCOG/gy8HvAJcBLwK39HU77ImIE+Bbwscz82dy+YZmPBWoYuvnIzF9n5iW0fgv/cuCtfR7SbxnmcB+qrznIzJny8zDwHVovhkPHL7eUn4fL5oNe20rHPXD1ZOah8pfzf4B/4DdvhQe6hog4mVYofiMzv12ah2o+FqphWOcDIDNfBR4G3k7r0tfxXw6dO6Y3xlv6VwM/pYd1DHO4D83XHETEGRHx5uPLwHuAA7TGe/xOhS3APWX5XuBD5W6HK4Gjc952D4KVjvt7wHsi4szydvs9pa1v5n2G8Se05gNaNdxY7m44D7gQ+AED8Hor12hvB57JzM/P6Rqa+VishmGbj4g4JyLWlOXTgXfT+vzgYeCGstn8uTg+RzcAD5V3WYvV170T9elyLx607gb4Ma1rXZ/u93iWGOf5tD4RfwJ46vhYaV1z2wM8B/wLcFb+5pP4L5W69gPjfRz7N2m9Tf5vWtcDt3YybuBPaX1YNA18eABq+HoZ45PlL9i5c7b/dKnhWeCaQXm9Ae+kdcnlSeDx8rh2mOZjiRqGaj6APwB+VMZ7APir0n4+rXCeBv4JOLW0n1bWp0v/+cvV1+3Drx+QpAoN82UZSdIiDHdJqpDhLkkVMtwlqUKGuyRVyHCXpAoZ7pJUof8FV97CuzetwdEAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SMRXGf4ZbqpM",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 297
        },
        "outputId": "5821f0f7-22d9-492b-9f5a-50ca2207be0f"
      },
      "source": [
        "# Descriptive stats of the length of a resume\n",
        "df.describe()"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>len_words</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>936.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>669.694444</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>371.604376</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>437.750000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>574.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>781.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>3071.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         len_words\n",
              "count   936.000000\n",
              "mean    669.694444\n",
              "std     371.604376\n",
              "min       0.000000\n",
              "25%     437.750000\n",
              "50%     574.000000\n",
              "75%     781.000000\n",
              "max    3071.000000"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "d3a-SHs9b6ch",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 208
        },
        "outputId": "7fc68fda-6c6b-4d41-fd60-136d8f28d9de"
      },
      "source": [
        "df['text'][0]"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic": {
              "type": "string"
            },
            "text/plain": [
              "'QIAN BOWEN\\n\\nMobile: + 65 9060 7342\\n\\nEmail: qianbowen@yahoo.com\\n\\nSUMMARY\\n\\n\\uf0b7\\n\\nSenior Manager with the Financial Services Assurance in PricewaterhouseCoopers\\nLLP , Singapore (PwC)\\n\\n\\uf0b7 Over 11 years of experience with PwC, providing assurance services to clients in a wide\\n\\nrange of industries with focus on asset and wealth management industry\\n\\n\\uf0b7 Proficient in leading engagement teams in the design of effective walk-through and\\nreview of financial and operational internal controls across a spectrum of the fund\\nmanagement company’s business activities, such as Portfolio management and trade\\nexecution, Pricing and valuation, Client administration and reporting, and Fund\\naccounting.\\n\\n\\uf0b7 Excellent in client relationship management and project management with an audit\\n\\nportfolio comprising 8-12 clients and over $1 million annual audit fee revenue\\n\\n\\uf0b7 Good knowledge in asset management rules and regulations in Singapore ，\\nexperience in MAS/CPFIS/CCIS compliance review for licensed and registered fund\\nmanagement companies and unit trusts\\n\\n\\uf0b7\\n\\nSelected as a high performer from PwC Singapore to be seconded to PwC Channel\\nIslands, UK as an audit manager from December 2013 to May 2015, working\\nprimarily on private equity related assurance work\\n\\n\\uf0b7 Double promoted from Associate 1 to Senior Associate 1 in PwC Singapore\\n\\uf0b7 Fellow member of the Association of Chartered Certified Accountants (ACCA),\\nMember of Institute of Singapore Chartered Accountants (CA Singapore) and\\nCertified Financial Risk Manager (FRM, GARP)\\n\\n1\\n\\n\\x0cWORK EXPERIENCE\\n\\nJuly 2010 -\\nPresent\\n\\nFinancial Services Assurance, PricewaterhouseCoopers LLP\\n(seconded to PwC Channel Islands from December 2013 to May 2015)\\n\\uf06c\\n\\nLead audit teams, develop risk-based audit plans, review internal\\ncontrol procedures, assess control environment, audit\\nfinancial\\nstatements for financial service clients including fund management\\ncompanies, private equities, exchange traded funds, hedge funds and\\nunit trusts\\n\\n\\uf06c Manage audit resource and budget, ensure quality deliverables and\\n\\nmeet the reporting deadlines\\n\\n\\uf06c Identify internal control/compliance issues during the audit, prepare\\naudit finding reports and make recommendations to the management\\n\\n\\uf06c Perform regulatory\\n\\nfund management\\ncompanies (CMS license holders, CPF Investment Schemes and Code\\nof Collective Investment Schemes)\\n\\ncompliance\\n\\naudit\\n\\nfor\\n\\n\\uf06c Initiate and maintain regular communication with key management\\n\\nand other stakeholders (e.g. Audit Committee)\\n\\n\\uf06c Draft internal guidance for audit methodology and risk management\\n\\npolicies\\n\\n\\uf06c Coach and conduct performance appraisals for junior staff\\n\\n\\uf06c Develop training materials for internal Learning and Development\\nand conduct training courses for audit staff in the audit methodology\\nfor fund Management companies, unit trusts and private equity audits\\n\\n\\uf06c Interview and recruit junior audit staff\\n\\nDecember 2013 - PricewaterhouseCoopers, Channel Islands, UK\\n\\nMay 2015\\n\\n(18 months secondment)\\n\\n\\uf06c Lead and managed a team of 3 to 8 members for various audit\\nengagements of different types of Private Equity funds, such as direct\\ninvestment, fund of funds, venture capital, mezzanine debts, real\\nestate\\n\\n\\uf06c Reviewed financial statements prepared under IFRS/US GAAP/LPA\\n\\n\\uf06c Assessed management fee/carried interest calculation and waterfall/\\n\\ninvestor allocations\\n\\n2\\n\\n\\x0cJune 2005 -\\n\\nGeneral Assurance, PricewaterhouseCoopers LLP\\n\\nJune 2010\\n\\n\\uf06c\\n\\nPlanned and executed risk-based audit fieldwork for a wide range of\\nclients\\ntrading,\\nshipping, hospitality, real estates, retail\\n\\nindustries, e.g. manufacturing,\\n\\nfrom different\\n\\n\\uf06c Reviewed financial statements, drafted audit finding reports and\\n\\ncommunicated to management\\n\\nMay 2004-\\n\\nInternship, C Y Ng & Co\\n\\nJune 2004\\n\\n\\uf06c Assisted audit seniors to complete the audit assignments\\n\\uf06c Received overall grade of A for the internship\\n\\nQUALIFICATION / CERTIFICATION\\n\\n2010\\n\\nChartered Certified Accountant (ACCA)\\n\\nThe Association of Chartered Certified Accountants, UK\\n\\n(Placed No. 7 0f the Top 30 ACCA Affiliates in Final Module, Singapore)\\n\\n2015\\n\\nChartered Accountant of Singapore (CA Singapore)\\n\\nInstitute of Singapore Chartered Accountants\\n\\n2016\\n\\nCertified Financial Risk Manager (FRM®)\\n\\nGlobal Association of Risk Professionals (GARP)\\n\\nCapital Markets and Financial Advisory Services (CMFAS)\\nExaminations\\n\\nModule 1A - Rules and Regulations for Dealing in Securities (2013)\\n\\nModule 3 - Rules & Regulations for Fund Management (2016)\\n\\n3\\n\\n\\x0cEDUCATION\\n\\n2008\\n\\nOxford Brookes University\\n\\nBachelor of Science (First Class Honours) in Applied Accounting\\n\\n2005\\n\\nSingapore Polytechnic\\n\\nDiploma in Accountancy\\n\\n(Placed on School Honour Roll for 5 out of 6 semesters)\\n\\nLANGUAGE\\n\\nEnglish and Chinese (Spoken and Written)\\n\\nSKILLS\\n\\nMicrosoft office (Word, Excel and PowerPoint)\\n\\nREFERENCES\\n\\nAvailable upon request\\n\\n4\\n\\n\\x0c'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bFoIN7eHLti_",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "57ec66fd-1e2a-4a25-9221-32290a163c10"
      },
      "source": [
        "print(df['text'][0])"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "QIAN BOWEN\n",
            "\n",
            "Mobile: + 65 9060 7342\n",
            "\n",
            "Email: qianbowen@yahoo.com\n",
            "\n",
            "SUMMARY\n",
            "\n",
            "\n",
            "\n",
            "Senior Manager with the Financial Services Assurance in PricewaterhouseCoopers\n",
            "LLP , Singapore (PwC)\n",
            "\n",
            " Over 11 years of experience with PwC, providing assurance services to clients in a wide\n",
            "\n",
            "range of industries with focus on asset and wealth management industry\n",
            "\n",
            " Proficient in leading engagement teams in the design of effective walk-through and\n",
            "review of financial and operational internal controls across a spectrum of the fund\n",
            "management company’s business activities, such as Portfolio management and trade\n",
            "execution, Pricing and valuation, Client administration and reporting, and Fund\n",
            "accounting.\n",
            "\n",
            " Excellent in client relationship management and project management with an audit\n",
            "\n",
            "portfolio comprising 8-12 clients and over $1 million annual audit fee revenue\n",
            "\n",
            " Good knowledge in asset management rules and regulations in Singapore ，\n",
            "experience in MAS/CPFIS/CCIS compliance review for licensed and registered fund\n",
            "management companies and unit trusts\n",
            "\n",
            "\n",
            "\n",
            "Selected as a high performer from PwC Singapore to be seconded to PwC Channel\n",
            "Islands, UK as an audit manager from December 2013 to May 2015, working\n",
            "primarily on private equity related assurance work\n",
            "\n",
            " Double promoted from Associate 1 to Senior Associate 1 in PwC Singapore\n",
            " Fellow member of the Association of Chartered Certified Accountants (ACCA),\n",
            "Member of Institute of Singapore Chartered Accountants (CA Singapore) and\n",
            "Certified Financial Risk Manager (FRM, GARP)\n",
            "\n",
            "1\n",
            "\n",
            "\fWORK EXPERIENCE\n",
            "\n",
            "July 2010 -\n",
            "Present\n",
            "\n",
            "Financial Services Assurance, PricewaterhouseCoopers LLP\n",
            "(seconded to PwC Channel Islands from December 2013 to May 2015)\n",
            "\n",
            "\n",
            "Lead audit teams, develop risk-based audit plans, review internal\n",
            "control procedures, assess control environment, audit\n",
            "financial\n",
            "statements for financial service clients including fund management\n",
            "companies, private equities, exchange traded funds, hedge funds and\n",
            "unit trusts\n",
            "\n",
            " Manage audit resource and budget, ensure quality deliverables and\n",
            "\n",
            "meet the reporting deadlines\n",
            "\n",
            " Identify internal control/compliance issues during the audit, prepare\n",
            "audit finding reports and make recommendations to the management\n",
            "\n",
            " Perform regulatory\n",
            "\n",
            "fund management\n",
            "companies (CMS license holders, CPF Investment Schemes and Code\n",
            "of Collective Investment Schemes)\n",
            "\n",
            "compliance\n",
            "\n",
            "audit\n",
            "\n",
            "for\n",
            "\n",
            " Initiate and maintain regular communication with key management\n",
            "\n",
            "and other stakeholders (e.g. Audit Committee)\n",
            "\n",
            " Draft internal guidance for audit methodology and risk management\n",
            "\n",
            "policies\n",
            "\n",
            " Coach and conduct performance appraisals for junior staff\n",
            "\n",
            " Develop training materials for internal Learning and Development\n",
            "and conduct training courses for audit staff in the audit methodology\n",
            "for fund Management companies, unit trusts and private equity audits\n",
            "\n",
            " Interview and recruit junior audit staff\n",
            "\n",
            "December 2013 - PricewaterhouseCoopers, Channel Islands, UK\n",
            "\n",
            "May 2015\n",
            "\n",
            "(18 months secondment)\n",
            "\n",
            " Lead and managed a team of 3 to 8 members for various audit\n",
            "engagements of different types of Private Equity funds, such as direct\n",
            "investment, fund of funds, venture capital, mezzanine debts, real\n",
            "estate\n",
            "\n",
            " Reviewed financial statements prepared under IFRS/US GAAP/LPA\n",
            "\n",
            " Assessed management fee/carried interest calculation and waterfall/\n",
            "\n",
            "investor allocations\n",
            "\n",
            "2\n",
            "\n",
            "\fJune 2005 -\n",
            "\n",
            "General Assurance, PricewaterhouseCoopers LLP\n",
            "\n",
            "June 2010\n",
            "\n",
            "\n",
            "\n",
            "Planned and executed risk-based audit fieldwork for a wide range of\n",
            "clients\n",
            "trading,\n",
            "shipping, hospitality, real estates, retail\n",
            "\n",
            "industries, e.g. manufacturing,\n",
            "\n",
            "from different\n",
            "\n",
            " Reviewed financial statements, drafted audit finding reports and\n",
            "\n",
            "communicated to management\n",
            "\n",
            "May 2004-\n",
            "\n",
            "Internship, C Y Ng & Co\n",
            "\n",
            "June 2004\n",
            "\n",
            " Assisted audit seniors to complete the audit assignments\n",
            " Received overall grade of A for the internship\n",
            "\n",
            "QUALIFICATION / CERTIFICATION\n",
            "\n",
            "2010\n",
            "\n",
            "Chartered Certified Accountant (ACCA)\n",
            "\n",
            "The Association of Chartered Certified Accountants, UK\n",
            "\n",
            "(Placed No. 7 0f the Top 30 ACCA Affiliates in Final Module, Singapore)\n",
            "\n",
            "2015\n",
            "\n",
            "Chartered Accountant of Singapore (CA Singapore)\n",
            "\n",
            "Institute of Singapore Chartered Accountants\n",
            "\n",
            "2016\n",
            "\n",
            "Certified Financial Risk Manager (FRM®)\n",
            "\n",
            "Global Association of Risk Professionals (GARP)\n",
            "\n",
            "Capital Markets and Financial Advisory Services (CMFAS)\n",
            "Examinations\n",
            "\n",
            "Module 1A - Rules and Regulations for Dealing in Securities (2013)\n",
            "\n",
            "Module 3 - Rules & Regulations for Fund Management (2016)\n",
            "\n",
            "3\n",
            "\n",
            "\fEDUCATION\n",
            "\n",
            "2008\n",
            "\n",
            "Oxford Brookes University\n",
            "\n",
            "Bachelor of Science (First Class Honours) in Applied Accounting\n",
            "\n",
            "2005\n",
            "\n",
            "Singapore Polytechnic\n",
            "\n",
            "Diploma in Accountancy\n",
            "\n",
            "(Placed on School Honour Roll for 5 out of 6 semesters)\n",
            "\n",
            "LANGUAGE\n",
            "\n",
            "English and Chinese (Spoken and Written)\n",
            "\n",
            "SKILLS\n",
            "\n",
            "Microsoft office (Word, Excel and PowerPoint)\n",
            "\n",
            "REFERENCES\n",
            "\n",
            "Available upon request\n",
            "\n",
            "4\n",
            "\n",
            "\f\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "4dbAW6-VR1NO",
        "colab_type": "text"
      },
      "source": [
        "## Clean data"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dwCakJK2RKtx",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import re"
      ],
      "execution_count": 11,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "m2XPzI70SBYb",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def strip(text_to_clean):\n",
        "  # Replace all newlines and blanklines with special strings\n",
        "  regx = re.compile(r\"\\n\\n\")\n",
        "  text_to_clean = regx.sub(repl=\" blankline \", string=text_to_clean)\n",
        " \n",
        "  regx = re.compile(r\"\\n\")\n",
        "  text_to_clean = regx.sub(repl=\" newline \", string=text_to_clean)\n",
        "\n",
        "\n",
        "  # Make all white space a single space\n",
        "  regx = re.compile(r\"\\s+\")\n",
        "  text_to_clean = regx.sub(repl=\" \", string=text_to_clean)\n",
        "\n",
        "  # Remove any trailing or leading white space\n",
        "  text_to_clean = text_to_clean.strip(\" \")\n",
        "  return text_to_clean"
      ],
      "execution_count": 19,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EL8ZWufVShDG",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 208
        },
        "outputId": "427c7542-5544-4362-f0fc-db80634f02b1"
      },
      "source": [
        "df['text'][0]"
      ],
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic": {
              "type": "string"
            },
            "text/plain": [
              "'QIAN BOWEN\\n\\nMobile: + 65 9060 7342\\n\\nEmail: qianbowen@yahoo.com\\n\\nSUMMARY\\n\\n\\uf0b7\\n\\nSenior Manager with the Financial Services Assurance in PricewaterhouseCoopers\\nLLP , Singapore (PwC)\\n\\n\\uf0b7 Over 11 years of experience with PwC, providing assurance services to clients in a wide\\n\\nrange of industries with focus on asset and wealth management industry\\n\\n\\uf0b7 Proficient in leading engagement teams in the design of effective walk-through and\\nreview of financial and operational internal controls across a spectrum of the fund\\nmanagement company’s business activities, such as Portfolio management and trade\\nexecution, Pricing and valuation, Client administration and reporting, and Fund\\naccounting.\\n\\n\\uf0b7 Excellent in client relationship management and project management with an audit\\n\\nportfolio comprising 8-12 clients and over $1 million annual audit fee revenue\\n\\n\\uf0b7 Good knowledge in asset management rules and regulations in Singapore ，\\nexperience in MAS/CPFIS/CCIS compliance review for licensed and registered fund\\nmanagement companies and unit trusts\\n\\n\\uf0b7\\n\\nSelected as a high performer from PwC Singapore to be seconded to PwC Channel\\nIslands, UK as an audit manager from December 2013 to May 2015, working\\nprimarily on private equity related assurance work\\n\\n\\uf0b7 Double promoted from Associate 1 to Senior Associate 1 in PwC Singapore\\n\\uf0b7 Fellow member of the Association of Chartered Certified Accountants (ACCA),\\nMember of Institute of Singapore Chartered Accountants (CA Singapore) and\\nCertified Financial Risk Manager (FRM, GARP)\\n\\n1\\n\\n\\x0cWORK EXPERIENCE\\n\\nJuly 2010 -\\nPresent\\n\\nFinancial Services Assurance, PricewaterhouseCoopers LLP\\n(seconded to PwC Channel Islands from December 2013 to May 2015)\\n\\uf06c\\n\\nLead audit teams, develop risk-based audit plans, review internal\\ncontrol procedures, assess control environment, audit\\nfinancial\\nstatements for financial service clients including fund management\\ncompanies, private equities, exchange traded funds, hedge funds and\\nunit trusts\\n\\n\\uf06c Manage audit resource and budget, ensure quality deliverables and\\n\\nmeet the reporting deadlines\\n\\n\\uf06c Identify internal control/compliance issues during the audit, prepare\\naudit finding reports and make recommendations to the management\\n\\n\\uf06c Perform regulatory\\n\\nfund management\\ncompanies (CMS license holders, CPF Investment Schemes and Code\\nof Collective Investment Schemes)\\n\\ncompliance\\n\\naudit\\n\\nfor\\n\\n\\uf06c Initiate and maintain regular communication with key management\\n\\nand other stakeholders (e.g. Audit Committee)\\n\\n\\uf06c Draft internal guidance for audit methodology and risk management\\n\\npolicies\\n\\n\\uf06c Coach and conduct performance appraisals for junior staff\\n\\n\\uf06c Develop training materials for internal Learning and Development\\nand conduct training courses for audit staff in the audit methodology\\nfor fund Management companies, unit trusts and private equity audits\\n\\n\\uf06c Interview and recruit junior audit staff\\n\\nDecember 2013 - PricewaterhouseCoopers, Channel Islands, UK\\n\\nMay 2015\\n\\n(18 months secondment)\\n\\n\\uf06c Lead and managed a team of 3 to 8 members for various audit\\nengagements of different types of Private Equity funds, such as direct\\ninvestment, fund of funds, venture capital, mezzanine debts, real\\nestate\\n\\n\\uf06c Reviewed financial statements prepared under IFRS/US GAAP/LPA\\n\\n\\uf06c Assessed management fee/carried interest calculation and waterfall/\\n\\ninvestor allocations\\n\\n2\\n\\n\\x0cJune 2005 -\\n\\nGeneral Assurance, PricewaterhouseCoopers LLP\\n\\nJune 2010\\n\\n\\uf06c\\n\\nPlanned and executed risk-based audit fieldwork for a wide range of\\nclients\\ntrading,\\nshipping, hospitality, real estates, retail\\n\\nindustries, e.g. manufacturing,\\n\\nfrom different\\n\\n\\uf06c Reviewed financial statements, drafted audit finding reports and\\n\\ncommunicated to management\\n\\nMay 2004-\\n\\nInternship, C Y Ng & Co\\n\\nJune 2004\\n\\n\\uf06c Assisted audit seniors to complete the audit assignments\\n\\uf06c Received overall grade of A for the internship\\n\\nQUALIFICATION / CERTIFICATION\\n\\n2010\\n\\nChartered Certified Accountant (ACCA)\\n\\nThe Association of Chartered Certified Accountants, UK\\n\\n(Placed No. 7 0f the Top 30 ACCA Affiliates in Final Module, Singapore)\\n\\n2015\\n\\nChartered Accountant of Singapore (CA Singapore)\\n\\nInstitute of Singapore Chartered Accountants\\n\\n2016\\n\\nCertified Financial Risk Manager (FRM®)\\n\\nGlobal Association of Risk Professionals (GARP)\\n\\nCapital Markets and Financial Advisory Services (CMFAS)\\nExaminations\\n\\nModule 1A - Rules and Regulations for Dealing in Securities (2013)\\n\\nModule 3 - Rules & Regulations for Fund Management (2016)\\n\\n3\\n\\n\\x0cEDUCATION\\n\\n2008\\n\\nOxford Brookes University\\n\\nBachelor of Science (First Class Honours) in Applied Accounting\\n\\n2005\\n\\nSingapore Polytechnic\\n\\nDiploma in Accountancy\\n\\n(Placed on School Honour Roll for 5 out of 6 semesters)\\n\\nLANGUAGE\\n\\nEnglish and Chinese (Spoken and Written)\\n\\nSKILLS\\n\\nMicrosoft office (Word, Excel and PowerPoint)\\n\\nREFERENCES\\n\\nAvailable upon request\\n\\n4\\n\\n\\x0c'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "P_lCsC5PTFBw",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "79900a9c-9dc0-4320-fafb-6fd75d2e0dd9"
      },
      "source": [
        "print(df['text'][0])"
      ],
      "execution_count": 22,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "QIAN BOWEN\n",
            "\n",
            "Mobile: + 65 9060 7342\n",
            "\n",
            "Email: qianbowen@yahoo.com\n",
            "\n",
            "SUMMARY\n",
            "\n",
            "\n",
            "\n",
            "Senior Manager with the Financial Services Assurance in PricewaterhouseCoopers\n",
            "LLP , Singapore (PwC)\n",
            "\n",
            " Over 11 years of experience with PwC, providing assurance services to clients in a wide\n",
            "\n",
            "range of industries with focus on asset and wealth management industry\n",
            "\n",
            " Proficient in leading engagement teams in the design of effective walk-through and\n",
            "review of financial and operational internal controls across a spectrum of the fund\n",
            "management company’s business activities, such as Portfolio management and trade\n",
            "execution, Pricing and valuation, Client administration and reporting, and Fund\n",
            "accounting.\n",
            "\n",
            " Excellent in client relationship management and project management with an audit\n",
            "\n",
            "portfolio comprising 8-12 clients and over $1 million annual audit fee revenue\n",
            "\n",
            " Good knowledge in asset management rules and regulations in Singapore ，\n",
            "experience in MAS/CPFIS/CCIS compliance review for licensed and registered fund\n",
            "management companies and unit trusts\n",
            "\n",
            "\n",
            "\n",
            "Selected as a high performer from PwC Singapore to be seconded to PwC Channel\n",
            "Islands, UK as an audit manager from December 2013 to May 2015, working\n",
            "primarily on private equity related assurance work\n",
            "\n",
            " Double promoted from Associate 1 to Senior Associate 1 in PwC Singapore\n",
            " Fellow member of the Association of Chartered Certified Accountants (ACCA),\n",
            "Member of Institute of Singapore Chartered Accountants (CA Singapore) and\n",
            "Certified Financial Risk Manager (FRM, GARP)\n",
            "\n",
            "1\n",
            "\n",
            "\fWORK EXPERIENCE\n",
            "\n",
            "July 2010 -\n",
            "Present\n",
            "\n",
            "Financial Services Assurance, PricewaterhouseCoopers LLP\n",
            "(seconded to PwC Channel Islands from December 2013 to May 2015)\n",
            "\n",
            "\n",
            "Lead audit teams, develop risk-based audit plans, review internal\n",
            "control procedures, assess control environment, audit\n",
            "financial\n",
            "statements for financial service clients including fund management\n",
            "companies, private equities, exchange traded funds, hedge funds and\n",
            "unit trusts\n",
            "\n",
            " Manage audit resource and budget, ensure quality deliverables and\n",
            "\n",
            "meet the reporting deadlines\n",
            "\n",
            " Identify internal control/compliance issues during the audit, prepare\n",
            "audit finding reports and make recommendations to the management\n",
            "\n",
            " Perform regulatory\n",
            "\n",
            "fund management\n",
            "companies (CMS license holders, CPF Investment Schemes and Code\n",
            "of Collective Investment Schemes)\n",
            "\n",
            "compliance\n",
            "\n",
            "audit\n",
            "\n",
            "for\n",
            "\n",
            " Initiate and maintain regular communication with key management\n",
            "\n",
            "and other stakeholders (e.g. Audit Committee)\n",
            "\n",
            " Draft internal guidance for audit methodology and risk management\n",
            "\n",
            "policies\n",
            "\n",
            " Coach and conduct performance appraisals for junior staff\n",
            "\n",
            " Develop training materials for internal Learning and Development\n",
            "and conduct training courses for audit staff in the audit methodology\n",
            "for fund Management companies, unit trusts and private equity audits\n",
            "\n",
            " Interview and recruit junior audit staff\n",
            "\n",
            "December 2013 - PricewaterhouseCoopers, Channel Islands, UK\n",
            "\n",
            "May 2015\n",
            "\n",
            "(18 months secondment)\n",
            "\n",
            " Lead and managed a team of 3 to 8 members for various audit\n",
            "engagements of different types of Private Equity funds, such as direct\n",
            "investment, fund of funds, venture capital, mezzanine debts, real\n",
            "estate\n",
            "\n",
            " Reviewed financial statements prepared under IFRS/US GAAP/LPA\n",
            "\n",
            " Assessed management fee/carried interest calculation and waterfall/\n",
            "\n",
            "investor allocations\n",
            "\n",
            "2\n",
            "\n",
            "\fJune 2005 -\n",
            "\n",
            "General Assurance, PricewaterhouseCoopers LLP\n",
            "\n",
            "June 2010\n",
            "\n",
            "\n",
            "\n",
            "Planned and executed risk-based audit fieldwork for a wide range of\n",
            "clients\n",
            "trading,\n",
            "shipping, hospitality, real estates, retail\n",
            "\n",
            "industries, e.g. manufacturing,\n",
            "\n",
            "from different\n",
            "\n",
            " Reviewed financial statements, drafted audit finding reports and\n",
            "\n",
            "communicated to management\n",
            "\n",
            "May 2004-\n",
            "\n",
            "Internship, C Y Ng & Co\n",
            "\n",
            "June 2004\n",
            "\n",
            " Assisted audit seniors to complete the audit assignments\n",
            " Received overall grade of A for the internship\n",
            "\n",
            "QUALIFICATION / CERTIFICATION\n",
            "\n",
            "2010\n",
            "\n",
            "Chartered Certified Accountant (ACCA)\n",
            "\n",
            "The Association of Chartered Certified Accountants, UK\n",
            "\n",
            "(Placed No. 7 0f the Top 30 ACCA Affiliates in Final Module, Singapore)\n",
            "\n",
            "2015\n",
            "\n",
            "Chartered Accountant of Singapore (CA Singapore)\n",
            "\n",
            "Institute of Singapore Chartered Accountants\n",
            "\n",
            "2016\n",
            "\n",
            "Certified Financial Risk Manager (FRM®)\n",
            "\n",
            "Global Association of Risk Professionals (GARP)\n",
            "\n",
            "Capital Markets and Financial Advisory Services (CMFAS)\n",
            "Examinations\n",
            "\n",
            "Module 1A - Rules and Regulations for Dealing in Securities (2013)\n",
            "\n",
            "Module 3 - Rules & Regulations for Fund Management (2016)\n",
            "\n",
            "3\n",
            "\n",
            "\fEDUCATION\n",
            "\n",
            "2008\n",
            "\n",
            "Oxford Brookes University\n",
            "\n",
            "Bachelor of Science (First Class Honours) in Applied Accounting\n",
            "\n",
            "2005\n",
            "\n",
            "Singapore Polytechnic\n",
            "\n",
            "Diploma in Accountancy\n",
            "\n",
            "(Placed on School Honour Roll for 5 out of 6 semesters)\n",
            "\n",
            "LANGUAGE\n",
            "\n",
            "English and Chinese (Spoken and Written)\n",
            "\n",
            "SKILLS\n",
            "\n",
            "Microsoft office (Word, Excel and PowerPoint)\n",
            "\n",
            "REFERENCES\n",
            "\n",
            "Available upon request\n",
            "\n",
            "4\n",
            "\n",
            "\f\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AlCBZwKESkXj",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 208
        },
        "outputId": "972846fb-70f3-4c79-a54a-6488b9a3bf12"
      },
      "source": [
        "strip(df['text'][0])"
      ],
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic": {
              "type": "string"
            },
            "text/plain": [
              "'QIAN BOWEN blankline Mobile: + 65 9060 7342 blankline Email: qianbowen@yahoo.com blankline SUMMARY blankline \\uf0b7 blankline Senior Manager with the Financial Services Assurance in PricewaterhouseCoopers newline LLP , Singapore (PwC) blankline \\uf0b7 Over 11 years of experience with PwC, providing assurance services to clients in a wide blankline range of industries with focus on asset and wealth management industry blankline \\uf0b7 Proficient in leading engagement teams in the design of effective walk-through and newline review of financial and operational internal controls across a spectrum of the fund newline management company’s business activities, such as Portfolio management and trade newline execution, Pricing and valuation, Client administration and reporting, and Fund newline accounting. blankline \\uf0b7 Excellent in client relationship management and project management with an audit blankline portfolio comprising 8-12 clients and over $1 million annual audit fee revenue blankline \\uf0b7 Good knowledge in asset management rules and regulations in Singapore ， newline experience in MAS/CPFIS/CCIS compliance review for licensed and registered fund newline management companies and unit trusts blankline \\uf0b7 blankline Selected as a high performer from PwC Singapore to be seconded to PwC Channel newline Islands, UK as an audit manager from December 2013 to May 2015, working newline primarily on private equity related assurance work blankline \\uf0b7 Double promoted from Associate 1 to Senior Associate 1 in PwC Singapore newline \\uf0b7 Fellow member of the Association of Chartered Certified Accountants (ACCA), newline Member of Institute of Singapore Chartered Accountants (CA Singapore) and newline Certified Financial Risk Manager (FRM, GARP) blankline 1 blankline WORK EXPERIENCE blankline July 2010 - newline Present blankline Financial Services Assurance, PricewaterhouseCoopers LLP newline (seconded to PwC Channel Islands from December 2013 to May 2015) newline \\uf06c blankline Lead audit teams, develop risk-based audit plans, review internal newline control procedures, assess control environment, audit newline financial newline statements for financial service clients including fund management newline companies, private equities, exchange traded funds, hedge funds and newline unit trusts blankline \\uf06c Manage audit resource and budget, ensure quality deliverables and blankline meet the reporting deadlines blankline \\uf06c Identify internal control/compliance issues during the audit, prepare newline audit finding reports and make recommendations to the management blankline \\uf06c Perform regulatory blankline fund management newline companies (CMS license holders, CPF Investment Schemes and Code newline of Collective Investment Schemes) blankline compliance blankline audit blankline for blankline \\uf06c Initiate and maintain regular communication with key management blankline and other stakeholders (e.g. Audit Committee) blankline \\uf06c Draft internal guidance for audit methodology and risk management blankline policies blankline \\uf06c Coach and conduct performance appraisals for junior staff blankline \\uf06c Develop training materials for internal Learning and Development newline and conduct training courses for audit staff in the audit methodology newline for fund Management companies, unit trusts and private equity audits blankline \\uf06c Interview and recruit junior audit staff blankline December 2013 - PricewaterhouseCoopers, Channel Islands, UK blankline May 2015 blankline (18 months secondment) blankline \\uf06c Lead and managed a team of 3 to 8 members for various audit newline engagements of different types of Private Equity funds, such as direct newline investment, fund of funds, venture capital, mezzanine debts, real newline estate blankline \\uf06c Reviewed financial statements prepared under IFRS/US GAAP/LPA blankline \\uf06c Assessed management fee/carried interest calculation and waterfall/ blankline investor allocations blankline 2 blankline June 2005 - blankline General Assurance, PricewaterhouseCoopers LLP blankline June 2010 blankline \\uf06c blankline Planned and executed risk-based audit fieldwork for a wide range of newline clients newline trading, newline shipping, hospitality, real estates, retail blankline industries, e.g. manufacturing, blankline from different blankline \\uf06c Reviewed financial statements, drafted audit finding reports and blankline communicated to management blankline May 2004- blankline Internship, C Y Ng & Co blankline June 2004 blankline \\uf06c Assisted audit seniors to complete the audit assignments newline \\uf06c Received overall grade of A for the internship blankline QUALIFICATION / CERTIFICATION blankline 2010 blankline Chartered Certified Accountant (ACCA) blankline The Association of Chartered Certified Accountants, UK blankline (Placed No. 7 0f the Top 30 ACCA Affiliates in Final Module, Singapore) blankline 2015 blankline Chartered Accountant of Singapore (CA Singapore) blankline Institute of Singapore Chartered Accountants blankline 2016 blankline Certified Financial Risk Manager (FRM®) blankline Global Association of Risk Professionals (GARP) blankline Capital Markets and Financial Advisory Services (CMFAS) newline Examinations blankline Module 1A - Rules and Regulations for Dealing in Securities (2013) blankline Module 3 - Rules & Regulations for Fund Management (2016) blankline 3 blankline EDUCATION blankline 2008 blankline Oxford Brookes University blankline Bachelor of Science (First Class Honours) in Applied Accounting blankline 2005 blankline Singapore Polytechnic blankline Diploma in Accountancy blankline (Placed on School Honour Roll for 5 out of 6 semesters) blankline LANGUAGE blankline English and Chinese (Spoken and Written) blankline SKILLS blankline Microsoft office (Word, Excel and PowerPoint) blankline REFERENCES blankline Available upon request blankline 4 blankline'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "J3rYMrJtSrNa",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df['cleaned_text'] = df['text'].apply(strip)"
      ],
      "execution_count": 24,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "whLGFI6iT6xV",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 394
        },
        "outputId": "fc66859c-fb30-4b78-d1c5-765772b06a22"
      },
      "source": [
        "df.head()"
      ],
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>category</th>\n",
              "      <th>file_path</th>\n",
              "      <th>len_words</th>\n",
              "      <th>text</th>\n",
              "      <th>cleaned_text</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>fund_accounting</td>\n",
              "      <td>/content/datartistry/ResumeParser/data/output/...</td>\n",
              "      <td>679</td>\n",
              "      <td>QIAN BOWEN\\n\\nMobile: + 65 9060 7342\\n\\nEmail:...</td>\n",
              "      <td>QIAN BOWEN blankline Mobile: + 65 9060 7342 bl...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>fund_accounting</td>\n",
              "      <td>/content/datartistry/ResumeParser/data/output/...</td>\n",
              "      <td>871</td>\n",
              "      <td>Dina V. Nagao \\n\\n    E: DinaVNagao@gmail.com ...</td>\n",
              "      <td>Dina V. Nagao blankline E: DinaVNagao@gmail.co...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>corporate_secretary</td>\n",
              "      <td>/content/datartistry/ResumeParser/data/output/...</td>\n",
              "      <td>710</td>\n",
              "      <td>\\n\\n \\n \\nEXPERIENCE \\n\\n \\n\\n \\n\\n \\n\\n \\n\\n...</td>\n",
              "      <td>blankline newline newline EXPERIENCE blankline...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>sales</td>\n",
              "      <td>/content/datartistry/ResumeParser/data/output/...</td>\n",
              "      <td>559</td>\n",
              "      <td>\\n\\n \\n\\n \\n\\n \\n\\n \\n\\n \\n\\n \\n\\n \\n\\nYee Ch...</td>\n",
              "      <td>blankline blankline blankline blankline blankl...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>sales</td>\n",
              "      <td>/content/datartistry/ResumeParser/data/output/...</td>\n",
              "      <td>501</td>\n",
              "      <td>Terence Neo\\n\\nSingaporean Chinese, born 1985\\...</td>\n",
              "      <td>Terence Neo blankline Singaporean Chinese, bor...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "              category  ...                                       cleaned_text\n",
              "0      fund_accounting  ...  QIAN BOWEN blankline Mobile: + 65 9060 7342 bl...\n",
              "1      fund_accounting  ...  Dina V. Nagao blankline E: DinaVNagao@gmail.co...\n",
              "2  corporate_secretary  ...  blankline newline newline EXPERIENCE blankline...\n",
              "3                sales  ...  blankline blankline blankline blankline blankl...\n",
              "4                sales  ...  Terence Neo blankline Singaporean Chinese, bor...\n",
              "\n",
              "[5 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NcXbGDx9T-bP",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 208
        },
        "outputId": "417e3a11-d319-4186-bd51-99e29324e21f"
      },
      "source": [
        "df['cleaned_text'][0]"
      ],
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic": {
              "type": "string"
            },
            "text/plain": [
              "'QIAN BOWEN blankline Mobile: + 65 9060 7342 blankline Email: qianbowen@yahoo.com blankline SUMMARY blankline \\uf0b7 blankline Senior Manager with the Financial Services Assurance in PricewaterhouseCoopers newline LLP , Singapore (PwC) blankline \\uf0b7 Over 11 years of experience with PwC, providing assurance services to clients in a wide blankline range of industries with focus on asset and wealth management industry blankline \\uf0b7 Proficient in leading engagement teams in the design of effective walk-through and newline review of financial and operational internal controls across a spectrum of the fund newline management company’s business activities, such as Portfolio management and trade newline execution, Pricing and valuation, Client administration and reporting, and Fund newline accounting. blankline \\uf0b7 Excellent in client relationship management and project management with an audit blankline portfolio comprising 8-12 clients and over $1 million annual audit fee revenue blankline \\uf0b7 Good knowledge in asset management rules and regulations in Singapore ， newline experience in MAS/CPFIS/CCIS compliance review for licensed and registered fund newline management companies and unit trusts blankline \\uf0b7 blankline Selected as a high performer from PwC Singapore to be seconded to PwC Channel newline Islands, UK as an audit manager from December 2013 to May 2015, working newline primarily on private equity related assurance work blankline \\uf0b7 Double promoted from Associate 1 to Senior Associate 1 in PwC Singapore newline \\uf0b7 Fellow member of the Association of Chartered Certified Accountants (ACCA), newline Member of Institute of Singapore Chartered Accountants (CA Singapore) and newline Certified Financial Risk Manager (FRM, GARP) blankline 1 blankline WORK EXPERIENCE blankline July 2010 - newline Present blankline Financial Services Assurance, PricewaterhouseCoopers LLP newline (seconded to PwC Channel Islands from December 2013 to May 2015) newline \\uf06c blankline Lead audit teams, develop risk-based audit plans, review internal newline control procedures, assess control environment, audit newline financial newline statements for financial service clients including fund management newline companies, private equities, exchange traded funds, hedge funds and newline unit trusts blankline \\uf06c Manage audit resource and budget, ensure quality deliverables and blankline meet the reporting deadlines blankline \\uf06c Identify internal control/compliance issues during the audit, prepare newline audit finding reports and make recommendations to the management blankline \\uf06c Perform regulatory blankline fund management newline companies (CMS license holders, CPF Investment Schemes and Code newline of Collective Investment Schemes) blankline compliance blankline audit blankline for blankline \\uf06c Initiate and maintain regular communication with key management blankline and other stakeholders (e.g. Audit Committee) blankline \\uf06c Draft internal guidance for audit methodology and risk management blankline policies blankline \\uf06c Coach and conduct performance appraisals for junior staff blankline \\uf06c Develop training materials for internal Learning and Development newline and conduct training courses for audit staff in the audit methodology newline for fund Management companies, unit trusts and private equity audits blankline \\uf06c Interview and recruit junior audit staff blankline December 2013 - PricewaterhouseCoopers, Channel Islands, UK blankline May 2015 blankline (18 months secondment) blankline \\uf06c Lead and managed a team of 3 to 8 members for various audit newline engagements of different types of Private Equity funds, such as direct newline investment, fund of funds, venture capital, mezzanine debts, real newline estate blankline \\uf06c Reviewed financial statements prepared under IFRS/US GAAP/LPA blankline \\uf06c Assessed management fee/carried interest calculation and waterfall/ blankline investor allocations blankline 2 blankline June 2005 - blankline General Assurance, PricewaterhouseCoopers LLP blankline June 2010 blankline \\uf06c blankline Planned and executed risk-based audit fieldwork for a wide range of newline clients newline trading, newline shipping, hospitality, real estates, retail blankline industries, e.g. manufacturing, blankline from different blankline \\uf06c Reviewed financial statements, drafted audit finding reports and blankline communicated to management blankline May 2004- blankline Internship, C Y Ng & Co blankline June 2004 blankline \\uf06c Assisted audit seniors to complete the audit assignments newline \\uf06c Received overall grade of A for the internship blankline QUALIFICATION / CERTIFICATION blankline 2010 blankline Chartered Certified Accountant (ACCA) blankline The Association of Chartered Certified Accountants, UK blankline (Placed No. 7 0f the Top 30 ACCA Affiliates in Final Module, Singapore) blankline 2015 blankline Chartered Accountant of Singapore (CA Singapore) blankline Institute of Singapore Chartered Accountants blankline 2016 blankline Certified Financial Risk Manager (FRM®) blankline Global Association of Risk Professionals (GARP) blankline Capital Markets and Financial Advisory Services (CMFAS) newline Examinations blankline Module 1A - Rules and Regulations for Dealing in Securities (2013) blankline Module 3 - Rules & Regulations for Fund Management (2016) blankline 3 blankline EDUCATION blankline 2008 blankline Oxford Brookes University blankline Bachelor of Science (First Class Honours) in Applied Accounting blankline 2005 blankline Singapore Polytechnic blankline Diploma in Accountancy blankline (Placed on School Honour Roll for 5 out of 6 semesters) blankline LANGUAGE blankline English and Chinese (Spoken and Written) blankline SKILLS blankline Microsoft office (Word, Excel and PowerPoint) blankline REFERENCES blankline Available upon request blankline 4 blankline'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8hQky_BYUBWC",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df[['category', 'cleaned_text']].to_csv('/content/datartistry/to_modeling.csv')"
      ],
      "execution_count": 28,
      "outputs": []
    }
  ]
}