(2)_HERA_Data_Labeling.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "nIVVNUfZI7t2"
      },
      "source": [
        "#Imports"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "P1gOBLyAGVpH"
      },
      "source": [
        "#Import Required Libraries\n",
        "import pandas as pd\n",
        "import re\n",
        "import matplotlib.pyplot as plt"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "-ScnVAxfIpPY"
      },
      "source": [
        "#Initial Dataset Labelling"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "id": "s4rJ1L2tRNDV",
        "outputId": "edd418d9-33fd-4490-d74b-ef157548dc51"
      },
      "source": [
        "'''\n",
        "Project: Bangkit Capstone Project\n",
        "Group: B21-CAP0194\n",
        "Part: Data Labelling\n",
        "'''"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "'\\nProject: Bangkit Capstone Project\\nGroup: B21-CAP0194\\nPart: Data Labelling\\n'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 53
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xfE3aLE_Gpwh",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "7fc974ee-5803-47b3-d748-264158da17b6"
      },
      "source": [
        "#Import the Dataset\n",
        "url = 'https://drive.google.com/file/d/1Mk28tI_DZtBmbjWC3eZFjKPrfBa5-Pyk/view?usp=sharing'\n",
        "file_id = url.split('/')[-2]\n",
        "csv_url = 'https://drive.google.com/uc?id=' + file_id\n",
        "df = pd.read_csv(csv_url)\n",
        "df.head()"
      ],
      "execution_count": null,
      "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>index</th>\n",
              "      <th>text</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>the ironies of the movement are too painfully ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>women in kuwait have launched a social media c...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>triger warning raising awareness of sexual ass...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>charges brought against the guy that smacked m...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>and the fourth presenter on th may is hannah b...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   index                                               text\n",
              "0      0  the ironies of the movement are too painfully ...\n",
              "1      1  women in kuwait have launched a social media c...\n",
              "2      2  triger warning raising awareness of sexual ass...\n",
              "3      3  charges brought against the guy that smacked m...\n",
              "4      4  and the fourth presenter on th may is hannah b..."
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 54
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "octhSmg5KREQ",
        "outputId": "f93d7ed8-5f0b-4075-cce5-6e556c02b853"
      },
      "source": [
        "#Printing the shape/size of the dataframe\n",
        "df.shape"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(16276, 2)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 55
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qddLsFk9hTjP"
      },
      "source": [
        "#Initialize label column\n",
        "df['label_laporan'] = \"\"\n",
        "df['label_post'] = \"\""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 52
        },
        "id": "h8EI5SvBqNS_",
        "outputId": "33d0d4dc-b529-4f08-c65d-646b0cf7ae5e"
      },
      "source": [
        "'''\n",
        "KemenPPPA Categories:\n",
        "1. Kekerasan Fisik / Psikis\n",
        "2. Kejahatan Seksual\n",
        "3. Exploitasi Ekonomi / Seksual\n",
        "4. Penculikan, Penjualan, atau Perdagangan\n",
        "5. Pornografi (Pornography)\n",
        "6. Perlakuan Salah & Penelantaran\n",
        "7. Anak yang Berkonflik dengan Hukum (ABH)\n",
        "8. Penyalahgunaan NAPZA\n",
        "'''"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "'\\nKemenPPPA Categories:\\n1. Kekerasan Fisik / Psikis\\n2. Kejahatan Seksual\\n3. Exploitasi Ekonomi / Seksual\\n4. Penculikan, Penjualan, atau Perdagangan\\n5. Pornografi (Pornography)\\n6. Perlakuan Salah & Penelantaran\\n7. Anak yang Berkonflik dengan Hukum (ABH)\\n8. Penyalahgunaan NAPZA\\n'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 57
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 573
        },
        "id": "hqzawCZhHDvn",
        "outputId": "e9fb6618-a0fb-43a1-bb7b-866d570dc3d6"
      },
      "source": [
        "#Labelling Process\n",
        "#Note: Any unusual words that you find in this part of the code are used to label the dataset\n",
        "for idx, line in enumerate(df['text']):\n",
        "\n",
        "  #Label no. 2\n",
        "  find_psychic = re.findall(r\"fear|afraid|scare|self-confidence|loss|act|ability|helplessness|sense|suffering|psychic\", line)\n",
        "  if len(find_psychic) != 0 and df['label_laporan'][idx] == \"\":\n",
        "    df['label_laporan'][idx] = \"Kekerasan Psikis\"\n",
        "  #Label no. 4\n",
        "  find_neglect = re.findall(r\"neglect|reject|life|care|treatment|keep|raise|raising|control|under\", line)\n",
        "  if len(find_neglect) != 0 and df['label_laporan'][idx] == \"\":\n",
        "    df['label_laporan'][idx] = \"Penelantaran\"\n",
        "\n",
        "  #Label no. 5\n",
        "  find_exploit = re.findall(r\"force|pressure|work|service|job|slave|serf|oppression|suppression|extortion|exploitation|utilization|organ|transplant|kidnapping|trade|trafficking\", line)\n",
        "  if len(find_exploit) != 0 and df['label_laporan'][idx] == \"\":\n",
        "    df['label_laporan'][idx] = \"Eksploitasi\"\n",
        "\n",
        "  #Label no. 6\n",
        "  find_expsex = re.findall(r\"prostitution|porn|pornography|pornographic|pornographies|reproduction|commercial|show|off|nude|body|erotic\", line)\n",
        "  if len(find_expsex) != 0 and df['label_laporan'][idx] == \"\":\n",
        "    df['label_laporan'][idx] = \"Eksploitasi Seksual\"\n",
        "\n",
        "  #Label no. 1\n",
        "  find_physical = re.findall(r\"assault|violence|hurt|ill|wound|injury|sore|bleed|blood\", line)\n",
        "  if len(find_physical) != 0 and df['label_laporan'][idx] == \"\":\n",
        "    df['label_laporan'][idx] = \"Kekerasan Fisik\"\n",
        "\n",
        "  #Label no. 3\n",
        "  find_sexual = re.findall(r\"sexual|unwanted|force|forcing|household|home|house|housewifery|rape|raped|sex|threat|fuck|sleep|make love|obscene|lewd|dirty|vulgar|sexist|ass|butt|breast|genital\", line)\n",
        "  if len(find_sexual) != 0 and df['label_laporan'][idx] == \"\":\n",
        "    df['label_laporan'][idx] = \"Kekerasan Seksual\"\n",
        "\n",
        "  #Label no. 7\n",
        "  if df['label_laporan'][idx] == \"\":\n",
        "    df['label_laporan'][idx] = \"Kekerasan Lainnya\"\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:8: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  \n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:12: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  if sys.path[0] == '':\n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:27: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:36: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:32: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:22: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:17: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n"
          ],
          "name": "stderr"
        },
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "'\\n  # LABEL FOR REPORTS (RISK MITIGATION)\\n  # Label 1 : Tinggi\\n  find_tinggi = re.findall(r\"\", line)\\n  if len(find_tinggi) != 0 and df[\\'label\\'][idx] == \"\":\\n    df[\\'label\\'][idx] = \"Tinggi\"\\n\\n  # Label 2 : Krisis\\n  find_krisis = re.findall(r\"\", line)\\n  if len(find_krisis) != 0 and df[\\'label\\'][idx] == \"\":\\n    df[\\'label\\'][idx] = \"Krisis\"\\n\\n  # Label 3 : Non-Krisis\\n  find_nonKrisis = re.findall(r\"\", line)\\n  if len(find_nonKrisis) != 0 and df[\\'label\\'][idx] == \"\":\\n    df[\\'label\\'][idx] = \"Non-Krisis\"\\n    '"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 58
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MebUNDrHgV1a",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "641f6798-f5ce-4c87-d156-65d1b86c9a3f"
      },
      "source": [
        "# FOR POST LABELS\n",
        "for idx, line in enumerate(df['text']):\n",
        "\n",
        "  # Label 4 : Educational places\n",
        "  find_educational = re.findall(r\"teacher|classmate|school|university|college|headmaster|principal|preschool|academy|teach|professor|class|mate|research|education|educator|study|universities|bully|lecture|student|dorm|uniform|library|laboratory\", line)\n",
        "  if len(find_educational) != 0 and df['label_post'][idx] == \"\":\n",
        "    df['label_post'][idx] = \"Lokasi Pendidikan\"\n",
        "\n",
        "  # Label 3 : Work places\n",
        "  find_workplace = re.findall(r\"colleague|boss|job|pervert|work|workplace|ceo|partner|leader|manager|department|industry|interview|office|pantry|employee|business|client|staff|career|physical|verbal|company|desk|team|division|unwanted|cornering|chief|mentor|fire|locker|intern\", line)\n",
        "  if len(find_workplace) != 0 and df['label_post'][idx] == \"\":\n",
        "    df['label_post'][idx] = \"Lokasi Kerja\"\n",
        "\n",
        "  # Label 5 : Cyber\n",
        "  find_cyber = re.findall(r\"sexting|call|text|video|photo|picture|comment|cyber|porn|pornography|phone|app|camera|chat|message|image|malicious|virtual|online|webcam|cctv|post|email|hoax|media|website|article|instagram|twitter|snapchat|facebook|whatsapp|messenger|telegram|computer|ip address|record\", line)\n",
        "  if len(find_cyber) != 0 and df['label_post'][idx] == \"\":\n",
        "    df['label_post'][idx] = \"Siber\"\n",
        "\n",
        "  # Label 1 : Private places\n",
        "  find_private = re.findall(r\"private|home|friend|marital rape|abortion|family|boyfriend|ex|ex-boyfriend|stalking|stalker|raped|murder|smack|sleep|touch|sexual|kiss|date|obscene|attempt|sex|harassment|parent|husband|raping|dating|conversation|relationship|kick|attack|genital|married|housewives|masturbate|chest|jerk|neighbor|sodomy|personal|naked|nude|body|strip\", line)\n",
        "  if len(find_private) != 0 and df['label_post'][idx] == \"\":\n",
        "    df['label_post'][idx] = \"Lokasi Privat\"\n",
        "\n",
        "  # Label 2 : Public/community places\n",
        "  find_public = re.findall(r\"public|domestic|hospital|transport|community|spy|catcalling|catcall|rumor|ass|breast|butt|stranger|man|guy|exploitation|slave|hug|abuse|violence|gender|men|accuse|pervert|street|bad|society|violent|criminal|crime|steal|medical|grab|feminism|fenimist|prostitute|park|gun|rob|predator|toilet|kidnap|kidnapping|trade|trafficking|murder|cat|watch|cafe|restaurant|shaming|politic|store|train|station|pocket|customer|pedophile|driver|perv|gym\", line)\n",
        "  if len(find_public) != 0 and df['label_post'][idx] == \"\":\n",
        "    df['label_post'][idx] = \"Lokasi Publik\"\n",
        "\n",
        "  # Label 6 : Neutral (If the tweets doesn't fit the other 5 categories, the tweet will be labelled as 'neutral')\n",
        "  if df['label_post'][idx] == \"\":\n",
        "    df['label_post'][idx] = \"Netral\""
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:12: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  if sys.path[0] == '':\n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:17: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:22: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:7: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  import sys\n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:27: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:31: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "E1p7laGFYj86",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "8497d5f4-623c-4809-f5cd-f1ab87e9542e"
      },
      "source": [
        "#Show the first 50 rows in the dataframe\n",
        "df.head(50)"
      ],
      "execution_count": null,
      "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>index</th>\n",
              "      <th>text</th>\n",
              "      <th>label_laporan</th>\n",
              "      <th>label_post</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>the ironies of the movement are too painfully ...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "      <td>Lokasi Kerja</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>women in kuwait have launched a social media c...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>triger warning raising awareness of sexual ass...</td>\n",
              "      <td>Penelantaran</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>charges brought against the guy that smacked m...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>and the fourth presenter on th may is hannah b...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Pendidikan</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>5</td>\n",
              "      <td>this is so messed up are there any men in the ...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>6</td>\n",
              "      <td>to tackle an epidemic of male violence against...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>7</td>\n",
              "      <td>there has been a new series of harassment alle...</td>\n",
              "      <td>Kekerasan Seksual</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>8</td>\n",
              "      <td>want to see what the movement looks like it s ...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>9</td>\n",
              "      <td>female students don t want to have sex w dolan...</td>\n",
              "      <td>Kekerasan Seksual</td>\n",
              "      <td>Lokasi Pendidikan</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>10</td>\n",
              "      <td>when we talk about and violence we must ensure...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>11</td>\n",
              "      <td>took in million last year in nih funds the nih...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>12</td>\n",
              "      <td>help your students to combat harassment using ...</td>\n",
              "      <td>Kekerasan Seksual</td>\n",
              "      <td>Lokasi Pendidikan</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>13</td>\n",
              "      <td>i m still looking to speak to disabled women w...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>14</td>\n",
              "      <td>glenn greenwald doesn t like the movement supp...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>15</td>\n",
              "      <td>for more on this topic join us for our upcomin...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>16</td>\n",
              "      <td>what does the movement have to do with the mur...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>17</td>\n",
              "      <td>latest op ed from and cuomo needs a time out a...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>18</td>\n",
              "      <td>don t know who this greewald misogynist moron ...</td>\n",
              "      <td>Penelantaran</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>19</td>\n",
              "      <td>morrison believes hearsay about some dude risi...</td>\n",
              "      <td>Kekerasan Seksual</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>20</td>\n",
              "      <td>to tackle an epidemic of male violence against...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Kerja</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>21</td>\n",
              "      <td>when we talk about and violence we must ensure...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>22</td>\n",
              "      <td>when will this violence and hate stop</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>23</td>\n",
              "      <td>anesthesia protected a known sexual predator f...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>24</td>\n",
              "      <td>thank you for your wisdom and outstanding insi...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>25</td>\n",
              "      <td>a few incels on tiktok have dubbed as national...</td>\n",
              "      <td>Kekerasan Seksual</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>26</td>\n",
              "      <td>what has actually changed</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>27</td>\n",
              "      <td>harassment retaliation</td>\n",
              "      <td>Kekerasan Seksual</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>28</td>\n",
              "      <td>looking forward a panel chat today about syste...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Kerja</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>29</td>\n",
              "      <td>this b d is in case does not talk about it</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>30</td>\n",
              "      <td>this is the child that was born as a result of...</td>\n",
              "      <td>Eksploitasi Seksual</td>\n",
              "      <td>Lokasi Kerja</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>31</td>\n",
              "      <td>event a new cultural reckoning gendered violence</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>32</td>\n",
              "      <td>the tail of the anita hill fury got us to rebe...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>33</td>\n",
              "      <td>oh no that s terrible can you please link the ...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>34</td>\n",
              "      <td>turns out it was gary all along</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>35</td>\n",
              "      <td>ever since i bared my soul and jump through he...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>36</td>\n",
              "      <td>to all victims of abuse it is never too late t...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>37</td>\n",
              "      <td>the military claims they take a hard line agai...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>38</td>\n",
              "      <td>we personally believe that victims of any form...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>39</td>\n",
              "      <td>chad s an ex con trying to start over</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>40</td>\n",
              "      <td>we personally believe that victims of any form...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>41</td>\n",
              "      <td>and democrats still failed what a waste of our...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>42</td>\n",
              "      <td>tw sexual assault read recognizing rape findin...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>43</td>\n",
              "      <td>young women don t think it s cool what he did ...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>44</td>\n",
              "      <td>amplify diverse perspectives and stories with ...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>45</td>\n",
              "      <td>actually amazing to see standing up to be coun...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>46</td>\n",
              "      <td>is hugging required play in the</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>47</td>\n",
              "      <td>maybe he was afraid he might get d if his hand...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>48</td>\n",
              "      <td>damn it where is r wisconsin catholic school t...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Pendidikan</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>49</td>\n",
              "      <td>he also had this app on his phones its used to...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    index  ...         label_post\n",
              "0       0  ...       Lokasi Kerja\n",
              "1       1  ...              Siber\n",
              "2       2  ...      Lokasi Privat\n",
              "3       3  ...      Lokasi Privat\n",
              "4       4  ...  Lokasi Pendidikan\n",
              "5       5  ...      Lokasi Publik\n",
              "6       6  ...              Siber\n",
              "7       7  ...      Lokasi Privat\n",
              "8       8  ...      Lokasi Publik\n",
              "9       9  ...  Lokasi Pendidikan\n",
              "10     10  ...      Lokasi Privat\n",
              "11     11  ...      Lokasi Privat\n",
              "12     12  ...  Lokasi Pendidikan\n",
              "13     13  ...      Lokasi Privat\n",
              "14     14  ...      Lokasi Privat\n",
              "15     15  ...             Netral\n",
              "16     16  ...      Lokasi Privat\n",
              "17     17  ...              Siber\n",
              "18     18  ...              Siber\n",
              "19     19  ...      Lokasi Privat\n",
              "20     20  ...       Lokasi Kerja\n",
              "21     21  ...      Lokasi Privat\n",
              "22     22  ...      Lokasi Publik\n",
              "23     23  ...      Lokasi Privat\n",
              "24     24  ...      Lokasi Publik\n",
              "25     25  ...             Netral\n",
              "26     26  ...             Netral\n",
              "27     27  ...      Lokasi Privat\n",
              "28     28  ...       Lokasi Kerja\n",
              "29     29  ...             Netral\n",
              "30     30  ...       Lokasi Kerja\n",
              "31     31  ...      Lokasi Publik\n",
              "32     32  ...      Lokasi Publik\n",
              "33     33  ...             Netral\n",
              "34     34  ...             Netral\n",
              "35     35  ...             Netral\n",
              "36     36  ...      Lokasi Publik\n",
              "37     37  ...      Lokasi Privat\n",
              "38     38  ...      Lokasi Privat\n",
              "39     39  ...      Lokasi Privat\n",
              "40     40  ...      Lokasi Privat\n",
              "41     41  ...             Netral\n",
              "42     42  ...      Lokasi Privat\n",
              "43     43  ...      Lokasi Publik\n",
              "44     44  ...              Siber\n",
              "45     45  ...      Lokasi Publik\n",
              "46     46  ...      Lokasi Publik\n",
              "47     47  ...             Netral\n",
              "48     48  ...  Lokasi Pendidikan\n",
              "49     49  ...              Siber\n",
              "\n",
              "[50 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 60
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "adyoQWddHNdO",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "04641409-de2e-43e3-dec4-e7409b3e1052"
      },
      "source": [
        "#Show the last 50 rows in the dataframe\n",
        "df.tail(50)"
      ],
      "execution_count": null,
      "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>index</th>\n",
              "      <th>text</th>\n",
              "      <th>label_laporan</th>\n",
              "      <th>label_post</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>16226</th>\n",
              "      <td>16226</td>\n",
              "      <td>along with everyone else</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16227</th>\n",
              "      <td>16227</td>\n",
              "      <td>didnt age well</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16228</th>\n",
              "      <td>16228</td>\n",
              "      <td>ping we thought you would fix the culture at t...</td>\n",
              "      <td>Kekerasan Seksual</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16229</th>\n",
              "      <td>16229</td>\n",
              "      <td>i m a survivor my suffering over the decades i...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16230</th>\n",
              "      <td>16230</td>\n",
              "      <td>i was he was a married rnc officer half assed ...</td>\n",
              "      <td>Eksploitasi Seksual</td>\n",
              "      <td>Lokasi Kerja</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16231</th>\n",
              "      <td>16231</td>\n",
              "      <td>horror rape well if you read a few paragraphs ...</td>\n",
              "      <td>Kekerasan Seksual</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16232</th>\n",
              "      <td>16232</td>\n",
              "      <td>sisters</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16233</th>\n",
              "      <td>16233</td>\n",
              "      <td>when shown a video recording of her reaction t...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16234</th>\n",
              "      <td>16234</td>\n",
              "      <td>picking out the best amongst their albums is l...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16235</th>\n",
              "      <td>16235</td>\n",
              "      <td>just wondering would these powerful charities ...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16236</th>\n",
              "      <td>16236</td>\n",
              "      <td>now that the left are all aboard the train wha...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16237</th>\n",
              "      <td>16237</td>\n",
              "      <td>hey are you going to get after your brother s ...</td>\n",
              "      <td>Eksploitasi Seksual</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16238</th>\n",
              "      <td>16238</td>\n",
              "      <td>biden is the end of what happened for tara rei...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16239</th>\n",
              "      <td>16239</td>\n",
              "      <td>it should be completely outlawed there is not ...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16240</th>\n",
              "      <td>16240</td>\n",
              "      <td>good to see trending again i was worried that ...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16241</th>\n",
              "      <td>16241</td>\n",
              "      <td>you were going so well and then you said that ...</td>\n",
              "      <td>Kekerasan Seksual</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16242</th>\n",
              "      <td>16242</td>\n",
              "      <td>ohhh thank god i thought the is relived again</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16243</th>\n",
              "      <td>16243</td>\n",
              "      <td>breaking proud of our courageous client who ha...</td>\n",
              "      <td>Kekerasan Seksual</td>\n",
              "      <td>Lokasi Kerja</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16244</th>\n",
              "      <td>16244</td>\n",
              "      <td>proud of the dedication of the survivor led to...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16245</th>\n",
              "      <td>16245</td>\n",
              "      <td>you ve read in the uk news about david cameron...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16246</th>\n",
              "      <td>16246</td>\n",
              "      <td>a girl from hlaing tsp ygn has confided that s...</td>\n",
              "      <td>Eksploitasi</td>\n",
              "      <td>Lokasi Kerja</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16247</th>\n",
              "      <td>16247</td>\n",
              "      <td>in film abuse everyday in non existent train s...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16248</th>\n",
              "      <td>16248</td>\n",
              "      <td>first describe your experience about i know yo...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16249</th>\n",
              "      <td>16249</td>\n",
              "      <td>its not some morphed voice instead its the voi...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16250</th>\n",
              "      <td>16250</td>\n",
              "      <td>why is back on this is f ckng frustrating to s...</td>\n",
              "      <td>Eksploitasi Seksual</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16251</th>\n",
              "      <td>16251</td>\n",
              "      <td>waiting i probably have more patience</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16252</th>\n",
              "      <td>16252</td>\n",
              "      <td>what happened with was nothing but in the name...</td>\n",
              "      <td>Eksploitasi</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16253</th>\n",
              "      <td>16253</td>\n",
              "      <td>i googled who is ron paul around this time</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16254</th>\n",
              "      <td>16254</td>\n",
              "      <td>ontd university original exploring the apparen...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Pendidikan</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16255</th>\n",
              "      <td>16255</td>\n",
              "      <td>in the era of what the hell are doing giving a...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16256</th>\n",
              "      <td>16256</td>\n",
              "      <td>just reality</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16257</th>\n",
              "      <td>16257</td>\n",
              "      <td>you know what the problem is with male allies ...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16258</th>\n",
              "      <td>16258</td>\n",
              "      <td>kroge to arrest hi honge you both corrupt cum ...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16259</th>\n",
              "      <td>16259</td>\n",
              "      <td>shout out to all the mob who now suddenly care...</td>\n",
              "      <td>Penelantaran</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16260</th>\n",
              "      <td>16260</td>\n",
              "      <td>maybe just maybe you are a trigger pull away f...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16261</th>\n",
              "      <td>16261</td>\n",
              "      <td>what can the giving of the torah teach us abou...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Pendidikan</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16262</th>\n",
              "      <td>16262</td>\n",
              "      <td>the only way that abusive men learn is through...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16263</th>\n",
              "      <td>16263</td>\n",
              "      <td>why does justice move at a glacial pace if at ...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16264</th>\n",
              "      <td>16264</td>\n",
              "      <td>the movement was just an excess to trash peopl...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16265</th>\n",
              "      <td>16265</td>\n",
              "      <td>because the movement has evolved from a positi...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16266</th>\n",
              "      <td>16266</td>\n",
              "      <td>he sucked my dick</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16267</th>\n",
              "      <td>16267</td>\n",
              "      <td>wow so it s the movement the women who tried t...</td>\n",
              "      <td>Kekerasan Seksual</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16268</th>\n",
              "      <td>16268</td>\n",
              "      <td>yes girl me too</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16269</th>\n",
              "      <td>16269</td>\n",
              "      <td>i have a load of fines i m essential</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Netral</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16270</th>\n",
              "      <td>16270</td>\n",
              "      <td>check out our all new legacy kids tv featuring...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Pendidikan</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16271</th>\n",
              "      <td>16271</td>\n",
              "      <td>i am the voice for the women whose tongues hav...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16272</th>\n",
              "      <td>16272</td>\n",
              "      <td>haha it was my favourite show as well and apar...</td>\n",
              "      <td>Eksploitasi Seksual</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16273</th>\n",
              "      <td>16273</td>\n",
              "      <td>i get plenty of one word messages and the occa...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16274</th>\n",
              "      <td>16274</td>\n",
              "      <td>before all the crap men were just being men</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16275</th>\n",
              "      <td>16275</td>\n",
              "      <td>so when you think of arab african muslim women...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Publik</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       index  ...         label_post\n",
              "16226  16226  ...             Netral\n",
              "16227  16227  ...             Netral\n",
              "16228  16228  ...              Siber\n",
              "16229  16229  ...              Siber\n",
              "16230  16230  ...       Lokasi Kerja\n",
              "16231  16231  ...      Lokasi Publik\n",
              "16232  16232  ...             Netral\n",
              "16233  16233  ...              Siber\n",
              "16234  16234  ...             Netral\n",
              "16235  16235  ...              Siber\n",
              "16236  16236  ...      Lokasi Publik\n",
              "16237  16237  ...      Lokasi Privat\n",
              "16238  16238  ...              Siber\n",
              "16239  16239  ...      Lokasi Publik\n",
              "16240  16240  ...      Lokasi Publik\n",
              "16241  16241  ...             Netral\n",
              "16242  16242  ...             Netral\n",
              "16243  16243  ...       Lokasi Kerja\n",
              "16244  16244  ...      Lokasi Publik\n",
              "16245  16245  ...      Lokasi Publik\n",
              "16246  16246  ...       Lokasi Kerja\n",
              "16247  16247  ...      Lokasi Privat\n",
              "16248  16248  ...      Lokasi Privat\n",
              "16249  16249  ...             Netral\n",
              "16250  16250  ...      Lokasi Publik\n",
              "16251  16251  ...      Lokasi Publik\n",
              "16252  16252  ...              Siber\n",
              "16253  16253  ...             Netral\n",
              "16254  16254  ...  Lokasi Pendidikan\n",
              "16255  16255  ...             Netral\n",
              "16256  16256  ...             Netral\n",
              "16257  16257  ...      Lokasi Publik\n",
              "16258  16258  ...      Lokasi Publik\n",
              "16259  16259  ...      Lokasi Publik\n",
              "16260  16260  ...             Netral\n",
              "16261  16261  ...  Lokasi Pendidikan\n",
              "16262  16262  ...      Lokasi Publik\n",
              "16263  16263  ...      Lokasi Privat\n",
              "16264  16264  ...      Lokasi Privat\n",
              "16265  16265  ...      Lokasi Privat\n",
              "16266  16266  ...             Netral\n",
              "16267  16267  ...              Siber\n",
              "16268  16268  ...             Netral\n",
              "16269  16269  ...             Netral\n",
              "16270  16270  ...  Lokasi Pendidikan\n",
              "16271  16271  ...      Lokasi Publik\n",
              "16272  16272  ...      Lokasi Privat\n",
              "16273  16273  ...              Siber\n",
              "16274  16274  ...      Lokasi Publik\n",
              "16275  16275  ...      Lokasi Publik\n",
              "\n",
              "[50 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 61
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "kU--M5NMYqZl",
        "outputId": "beca73c7-4072-4ac9-a3d5-544d72af1394"
      },
      "source": [
        "#Counting the value in every labels\n",
        "df['label_laporan'].value_counts()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Kekerasan Lainnya      8313\n",
              "Kekerasan Fisik        1922\n",
              "Kekerasan Seksual      1864\n",
              "Kekerasan Psikis       1359\n",
              "Penelantaran           1135\n",
              "Eksploitasi             911\n",
              "Eksploitasi Seksual     772\n",
              "Name: label_laporan, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 62
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Q_q7rOhBh7SF",
        "outputId": "67c77cb6-a8a9-43c2-ae2f-efbe0df8300c"
      },
      "source": [
        "#Counting the value in every labels\n",
        "df['label_post'].value_counts()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Netral               4617\n",
              "Lokasi Publik        3679\n",
              "Lokasi Privat        3109\n",
              "Siber                2278\n",
              "Lokasi Kerja         1894\n",
              "Lokasi Pendidikan     699\n",
              "Name: label_post, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 63
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 344
        },
        "id": "AmNZGazFYNn8",
        "outputId": "81b1b3a9-9d9b-4a18-e36f-016d55dd020c"
      },
      "source": [
        "%matplotlib inline\n",
        "my_tags = df['label_post']\n",
        "plt.figure(figsize=(10,4))\n",
        "df.label_post.value_counts().plot(kind='bar');"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAlwAAAFHCAYAAAB05ZJ1AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAd1UlEQVR4nO3df5QlZX3n8feHAcVfA4qzLgHMEIO6xAgSBPxxVNAAihHXEMV1zRzFEHdJgkk2CezJiqImuGtENIkJBgwYT5CNrBAxqywYjIlBhh+CSFwm/FBYEkYBQQUT4Lt/3Gq9jN30zFDPre7q9+uce27VU3W7v/eeO1Ofrnqep1JVSJIkqZ1thi5AkiRp7AxckiRJjRm4JEmSGjNwSZIkNWbgkiRJamzboQt4KE984hNr7dq1Q5chSZK0qMsuu+wbVbVmvm1LOnCtXbuW9evXD12GJEnSopLctNA2LylKkiQ1ZuCSJElqzMAlSZLUmIFLkiSpMQOXJElSYwYuSZKkxgxckiRJjRm4JEmSGjNwSZIkNbakZ5pvbe1x5w9dwla58aTDhi5BkiRtAc9wSZIkNWbgkiRJaszAJUmS1JiBS5IkqTEDlyRJUmMGLkmSpMYMXJIkSY0ZuCRJkhozcEmSJDVm4JIkSWrMwCVJktSYgUuSJKkxA5ckSVJjBi5JkqTGDFySJEmNGbgkSZIaM3BJkiQ1ZuCSJElqzMAlSZLUmIFLkiSpMQOXJElSYwYuSZKkxgxckiRJjW124EqyKskVST7Zre+e5JIkG5J8LMkjuvZHdusbuu1rp37G8V37V5Mc0vebkSRJWoq25AzXscC1U+vvBk6uqh8H7gCO6tqPAu7o2k/u9iPJnsCRwE8AhwJ/mGTVwytfkiRp6duswJVkV+Aw4E+69QAHAX/R7XIG8Mpu+fBunW77i7v9DwfOqqrvVdUNwAZgvz7ehCRJ0lK2uWe43gf8JvBAt74TcGdV3det3wzs0i3vAnwdoNv+rW7/77fP85rvS3J0kvVJ1m/cuHEL3ookSdLStGjgSvJy4LaqumwG9VBVp1bVvlW175o1a2bxKyVJkpradjP2eR7wiiQvA7YHVgOnADsm2bY7i7UrcEu3/y3AbsDNSbYFdgC+OdU+Z/o1kiRJo7XoGa6qOr6qdq2qtUw6vV9UVa8DPgsc0e22Dji3Wz6vW6fbflFVVdd+ZDeKcXdgD+CLvb0TSZKkJWpzznAt5LeAs5K8E7gCOK1rPw34SJINwO1MQhpVdU2Ss4GvAPcBx1TV/Q/j90uSJC0LWxS4quqvgb/ulq9nnlGGVXUv8HMLvP5dwLu2tEhJkqTlzJnmJUmSGjNwSZIkNWbgkiRJaszAJUmS1JiBS5IkqTEDlyRJUmMGLkmSpMYMXJIkSY0ZuCRJkhp7OLf2kbbY2uPOH7qErXLjSYcNXYIkaRnzDJckSVJjBi5JkqTGDFySJEmNGbgkSZIaM3BJkiQ1ZuCSJElqzMAlSZLUmIFLkiSpMQOXJElSYwYuSZKkxgxckiRJjRm4JEmSGjNwSZIkNWbgkiRJaszAJUmS1JiBS5IkqTEDlyRJUmMGLkmSpMYMXJIkSY0ZuCRJkhozcEmSJDVm4JIkSWrMwCVJktSYgUuSJKmxbYcuQFJba487f+gStsqNJx02dAmS1BvPcEmSJDW2aOBKsn2SLyb5UpJrkry9a989ySVJNiT5WJJHdO2P7NY3dNvXTv2s47v2ryY5pNWbkiRJWko25wzX94CDqmovYG/g0CQHAO8GTq6qHwfuAI7q9j8KuKNrP7nbjyR7AkcCPwEcCvxhklV9vhlJkqSlaNHAVRPf7la36x4FHAT8Rdd+BvDKbvnwbp1u+4uTpGs/q6q+V1U3ABuA/Xp5F5IkSUvYZvXhSrIqyZXAbcAFwD8Cd1bVfd0uNwO7dMu7AF8H6LZ/C9hpun2e10z/rqOTrE+yfuPGjVv+jiRJkpaYzQpcVXV/Ve0N7MrkrNTTWxVUVadW1b5Vte+aNWta/RpJkqSZ2aJRilV1J/BZ4DnAjknmppXYFbilW74F2A2g274D8M3p9nleI0mSNFqbM0pxTZIdu+VHAT8NXMskeB3R7bYOOLdbPq9bp9t+UVVV135kN4pxd2AP4It9vRFJkqSlanMmPt0ZOKMbUbgNcHZVfTLJV4CzkrwTuAI4rdv/NOAjSTYAtzMZmUhVXZPkbOArwH3AMVV1f79vR5IkaelZNHBV1VXAs+Zpv555RhlW1b3Azy3ws94FvGvLy5QkSVq+nGlekiSpMQOXJElSYwYuSZKkxgxckiRJjRm4JEmSGjNwSZIkNWbgkiRJaszAJUmS1JiBS5IkqTEDlyRJUmMGLkmSpMYMXJIkSY0ZuCRJkhozcEmSJDVm4JIkSWrMwCVJktSYgUuSJKkxA5ckSVJjBi5JkqTGDFySJEmNGbgkSZIaM3BJkiQ1ZuCSJElqzMAlSZLUmIFLkiSpMQOXJElSYwYuSZKkxrYdugBJGpu1x50/dAlb5caTDhu6BGm0PMMlSZLUmIFLkiSpMQOXJElSYwYuSZKkxgxckiRJjRm4JEmSGjNwSZIkNWbgkiRJamzRwJVktySfTfKVJNckObZrf0KSC5Jc1z0/vmtPkvcn2ZDkqiT7TP2sdd3+1yVZ1+5tSZIkLR2bc4brPuDXq2pP4ADgmCR7AscBF1bVHsCF3TrAS4E9usfRwAdhEtCAE4D9gf2AE+ZCmiRJ0pgtGriq6taqurxbvhu4FtgFOBw4o9vtDOCV3fLhwJk18ffAjkl2Bg4BLqiq26vqDuAC4NBe340kSdIStEV9uJKsBZ4FXAI8qapu7Tb9E/CkbnkX4OtTL7u5a1uofdPfcXSS9UnWb9y4cUvKkyRJWpI2O3AleSzwceAtVXXX9LaqKqD6KKiqTq2qfatq3zVr1vTxIyVJkga1WYEryXZMwtZHq+qcrvmfu0uFdM+3de23ALtNvXzXrm2hdkmSpFHbnFGKAU4Drq2q905tOg+YG2m4Djh3qv3nu9GKBwDf6i49fho4OMnju87yB3dtkiRJo7btZuzzPOD1wNVJruza/itwEnB2kqOAm4BXd9s+BbwM2AB8F3gDQFXdnuQdwKXdfidW1e29vAtJkqQlbNHAVVWfB7LA5hfPs38Bxyzws04HTt+SAiVJWsza484fuoStcuNJhw1dgmbEmeYlSZIaM3BJkiQ1ZuCSJElqzMAlSZLUmIFLkiSpMQOXJElSYwYuSZKkxgxckiRJjRm4JEmSGjNwSZIkNWbgkiRJaszAJUmS1JiBS5IkqTEDlyRJUmMGLkmSpMYMXJIkSY0ZuCRJkhozcEmSJDVm4JIkSWrMwCVJktSYgUuSJKkxA5ckSVJjBi5JkqTGDFySJEmNGbgkSZIaM3BJkiQ1ZuCSJElqzMAlSZLUmIFLkiSpMQOXJElSYwYuSZKkxgxckiRJjRm4JEmSGjNwSZIkNWbgkiRJaszAJUmS1NiigSvJ6UluS/LlqbYnJLkgyXXd8+O79iR5f5INSa5Kss/Ua9Z1+1+XZF2btyNJkrT0bM4Zrj8FDt2k7TjgwqraA7iwWwd4KbBH9zga+CBMAhpwArA/sB9wwlxIkyRJGrtFA1dVfQ64fZPmw4EzuuUzgFdOtZ9ZE38P7JhkZ+AQ4IKqur2q7gAu4IdDnCRJ0ihtbR+uJ1XVrd3yPwFP6pZ3Ab4+td/NXdtC7T8kydFJ1idZv3Hjxq0sT5Ikael42J3mq6qA6qGWuZ93alXtW1X7rlmzpq8fK0mSNJitDVz/3F0qpHu+rWu/Bdhtar9du7aF2iVJkkZvawPXecDcSMN1wLlT7T/fjVY8APhWd+nx08DBSR7fdZY/uGuTJEkavW0X2yHJnwMvAp6Y5GYmow1PAs5OchRwE/DqbvdPAS8DNgDfBd4AUFW3J3kHcGm334lVtWlHfEmSpFFaNHBV1WsX2PTiefYt4JgFfs7pwOlbVJ0kSdIIONO8JElSYwYuSZKkxgxckiRJjRm4JEmSGjNwSZIkNWbgkiRJaszAJUmS1Nii83BJkiRtau1x5w9dwla58aTDBvm9nuGSJElqzMAlSZLUmIFLkiSpMQOXJElSYwYuSZKkxgxckiRJjRm4JEmSGjNwSZIkNWbgkiRJaszAJUmS1JiBS5IkqTEDlyRJUmMGLkmSpMYMXJIkSY0ZuCRJkhozcEmSJDVm4JIkSWrMwCVJktSYgUuSJKkxA5ckSVJjBi5JkqTGDFySJEmNGbgkSZIaM3BJkiQ1ZuCSJElqzMAlSZLUmIFLkiSpMQOXJElSYzMPXEkOTfLVJBuSHDfr3y9JkjRrMw1cSVYBfwC8FNgTeG2SPWdZgyRJ0qzN+gzXfsCGqrq+qv4FOAs4fMY1SJIkzVSqana/LDkCOLSq3tStvx7Yv6p+aWqfo4Gju9WnAV+dWYH9eiLwjaGLWGH8zGfPz3z2/Mxnz8989pbrZ/6jVbVmvg3bzrqSxVTVqcCpQ9fxcCVZX1X7Dl3HSuJnPnt+5rPnZz57fuazN8bPfNaXFG8Bdpta37VrkyRJGq1ZB65LgT2S7J7kEcCRwHkzrkGSJGmmZnpJsaruS/JLwKeBVcDpVXXNLGuYoWV/WXQZ8jOfPT/z2fMznz0/89kb3Wc+007zkiRJK5EzzUuSJDVm4JIkSWrMwKVlK8kj52l7whC1SJL0UAxcWs7OSbLd3EqSnYELBqxn9JJcuDlt6keSVUneM3QdK02SNUnek+RTSS6aewxd19gl2SXJc5O8YO4xdE19WnITny5HSf4SWHD0QVW9YoblrCSfAM7u7mCwG5MpRv7LsCWNU5LtgUcDT0zyeCDdptXALoMVNnJVdX+S5w9dxwr0UeBjwGHAm4F1wMZBKxq5JO8GXgN8Bbi/ay7gc4MV1TNHKfYgyQsfantVXTyrWlaaJMcAhwJrgV+sqr8btqJxSnIs8BbgR5hMVjwXuO4CPlRVvz9UbWOX5INMQu3/BL4z115V5wxW1MgluayqfirJVVX1zK7t0qp69tC1jVWSrwLPrKrvDV1LK57h6oGBaraS/Nr0KvBk4ErggCQHVNV7h6lsvKrqFOCUJL9cVR8Yup4VZnvgm8BBU20FGLja+dfu+dYkhwH/D7B/aFvXA9sBBi4tLskewO8CezL5TxKAqvqxwYoap8dtsn7OAu3qWVV9IMkz+OHv+JnDVTVuVfWGoWtYgd6ZZAfg14EPMLl0/qvDljR63wWu7PqEfj90VdWvDFdSv7yk2KMknwdOAE4GfgZ4A7BNVb110MKkniQ5AXgRk8D1KeClwOer6ogh6xqzJE8FPgg8qaqekeSZwCuq6p0Dlyb1Jsm6+dqr6oxZ19KKgatHU9f9r66qn5xuG7q2MUnyvqp6y0KDFRyk0E6Sq4G9gCuqaq8kTwL+rKp+euDSRivJxcBvAH9cVc/q2r5cVc8YtrLxSfKbVfXfk3yAH/6/pYDbmXzf/3H21Wm585Jiv76XZBvguu6ekbcAjx24pjH6SPfscPnZu6eqHkhyX5LVwG1MRoiqnUdX1ReTTLfdN1QxI3dt97x+ge07MenCsNdsylk5VkKXHANXv45lMnT+V4B3AAcyGU6sHlXVZd2zgxVmb32SHYEPAZcB3wa+MGxJo/eNJE+hO+PSTYNy67AljVNV/WWSVcBPVtW8U8wk+c587XrYPswPuuQcSNclZ9CKeuYlxZ50/0jfvdA/UvWnu6w13xc3QM0N41ZbSdYCq6vqqoFLGbUkPwacCjwXuAO4AXhdVd00aGEjluQLVfWcoetYSVZClxzPcPXECQpn6uVDF7BSJTkPOAs4t6puHLicFaGqrgdekuQxTAbh3D10TSvAld133bnPZmf0XXI8w9UjJyicvST/FtiPyRmvS6vqnwYuadS6SX5fw2QG7kuZhK9PVtW9gxY2Ykl2YnKp5flMvuefB06sqm8OWtiIJfnwPM1VVW+ceTErRJJnM+lDtyOTLjk7MLlqdMmghfXIwNUj/5HOVpI3AW8FLmJyOfGFTA5Epw9a2ArQXUI/CPgF4NCqWj1wSaOV5AImtzf5s67pdcCLquolw1Ul9SvJT831z51qe3lVfXKomvpm4OpRkudV1d8u1qZ+dLeCeO7cX/rdmYC/q6qnDVvZuCV5FJN55l4D7MPkDNcvD1vVeM03BcR0Pxf1z7nPZi/J5cDPV9WXu/UjgV+tqv2Hraw/oxoBsATMd8sTb4PSzjeB6f4sd3dtaiTJ2UxO+x8E/D7wFMNWc59JcmSSbbrHq4FPD13UyH0IOJ7uFj/dwJAjB61o/I4Azkzy9CS/ABwDHDxwTb2y03wPkjyHyQiiNZvc5281sGqYqsZr6jPeAFyS5FwmfVsOBxwx19ZpwGur6v6hCxm7JHcz+V6HyY3D5+afW8VkOg5HRLfj3GczVlXXd2e1PgF8DTi4qu4ZuKxeGbj68Qgmoym25cH387uLSWpXv+Y+43/sHnPOHaCWFSHJQVV1EfAY4PBNDkQODGmgqrw36HCc+2xG5pnm5wlM/qi4JAljmubHPlw9SvKjVXVTkkdX1XeHrkfqS5K3V9UJDgyZnSRPr6p/SLLPfNur6vJZ17RSLDD32eur6oZBCxuhJD/6UNvHNN+cgatH3aXF04DHVtWTk+wF/GJV/eeBSxulJJ9l/nspHjRAOaPXzZFzRFWdPXQtK0GSU6vq6O57Puf733e/5/1Lsm76Zslzc58B9wJnVtVrBytupJKsrqq7kjxhvu1Vdfusa2rFwNWjJJcwuYR4njeZbS/J9AzE2wM/C9xXVb85UEmjl2R9Ve07dB0rQZL9gK/NzS2XZB2T7/iNwNvGdCBaKrqRcn9UVadOtT2Gyf0Tb66qowYrbqSSfLKqXp7kBn7QZ3FOjeleigauHiW5pKr2T3LFVOD6UlV5o9MZSfLFqtpv6DrGKslJwDeAj/HgyX09+PesO/i/pKpuT/ICJpPM/jKwN/Dvqsr+oT3rzrL8b+DPqur9SdYAnwIurKrjhq1Oy52d5vv19STPBSrJdkxuZn3tIq/RVtrkFPQ2wE8xmZ1Y7bymez5mqq2A0fwVuoSsmgqyrwFOraqPAx9PcuWAdY1WF25fAvxVkh9hMvL5j6rqlIFLG62F+ijOGVNfRQNXv94MnMLk9j63AJ/hwQcm9Wt6VuL7mHRs9ZR/Q1W1+9A1rCCrkmxbVfcBLwaOntrm/90NJHlVt3gq8F7gQiZ/SL8KHI3byO91z9sD+wJfYnJZ8ZnAemA0NxH3H22PquobTG67oRnw4D87SfZnchB6CnA18Maq8uxtW38OXJzkG8A9wN8AJPlx4FtDFjZiPzO1fN4mbcWkL5d6VFUHAiQ5B9inqq7u1p8BvG3A0npnH64eJHnrQ2yuqnrHzIpZATz4z16S9Uxm3v4c8ArgTVV1yLBVjV+SA4Cdgc9U1Xe6tqcyGQk9mkstUpJrquonFmtbzgxcPUjy6/M0P4bJ5a2dquqxMy5p1Dz4z16Sy6tqn4XWJenhSPLnTAbiTN+k/bFjmorDwNWzJI9j0ln+KOBs4Peq6rZhqxoXD/6zl+R6HnwrmfdMr9u3RdLDkWR74D8BL+iaPgd8sKruHa6qfhm4etKNmPs1Jqn8DOCUqrpj2KrGyYP/7C0ww/wcZ5qXpEUYuHqQ5H8Ar2LSr+gPqurbA5c0ah78JbUwd8/QqdGKD+Ifc/1LcnZVvXqeeyoCeC9FPViSB4DvMZmaYPoDDZMAsHqQwiRJm817hs5ekp2r6taF7qnovRQlSZK02bYZugBJkpaSJMcmWZ2JP0lyeZKDh65rjJLcneSuhR5D19cnJz6VtCj7tmiFeWNVnZLkEGAn4PXAR5jcPUQ9qqrHASR5B3Ark885TAag7Txgab0zcGnZ8eA/iBcCF/HgmbjnOAO3xibd88uAM6vqmiR5qBfoYXtFVe01tf7BJF8CHmpi8WXFwKXlyIP/jFXVCd3zG4auRZqBy5J8BtgdOL6bX/GBgWsau+8keR1wFpP/x1/LZCLU0bDTvKTNluRY4MPA3cCHgH2A46rKSy0ajSTbAHsD11fVnUl2AnapqqsGLm20kqwFTgGexyRw/S3wlqq6cbiq+mXg0rLlwX/2knypqvbq+ra8Gfht4CPO9K+xSfJ4YA9g+7m2qvrccBVpufOSopYzO7bOnn1bNHpJ3sTkFm27AlcCBwBfAA4asq4xS7IG+AVgLVPZZExznxm4tJx58J89+7ZoJTgWeDbw91V1YJKnA78zcE1jdy7wN8D/Ae4fuJYmDFxazjz4z95R/KBvy3e7vi12pNfY3FtV9yYhySOr6h+SPG3ookbu0VX1W0MX0ZKBS8uZB/8Zq6oHktwAPDXJ9ou+QFqebk6yI/AJ4IIkdwCjucXMEvXJJC+rqk8NXUgrdprXsmbH1tlaqG9LVdm3RaOU5IXADsBfVdW/Dl3PWCW5G3gM8C/dY3T3IvbWPlq2uoP/54BPA2/vnt82ZE0rwFzflpuq6kDgWcCdw5Yk9SvJiXPLVXUxcD7wp4MVtAJU1eOqapuq2r6qVnfrowlbYODS8ubBf/burap7ge/3bQHs26Kx2S3J8TD5njOZTPm6YUsat+6+lf8xyX/r1ndLst/QdfXJwKXlzIP/7G3at+Vc7Nui8Xkj8JNd6PpL4K+r6m3DljR6fwg8B/gP3fq3gT8Yrpz+2Wley5kdW2esqv59t/i2JJ+l69syYElSb5JMT+B7CvDHTGY8vzjJPlV1+TCVrQj7V9U+Sa4AqKo7kjxi6KL6ZKd5jYIdW2cjyYlV9dap9VVM5kB73YBlSb3o/ohYSDk4pJ0klwDPBS7tgtca4DNV9ayBS+uNZ7i0bE0f/Kvq4rmDP+DBv53dkhxfVb/b9W05G7hi6KKkPnR9QTWM9wP/C/g3Sd4FHMHk1mGj4RkuLVtJPgz8300P/va1aKebyf+jwNXAgUzOKJ48bFVSv5LsAJwAvKBruhg4saq+NVxV49fN6P9iJlNCXFhV1w5cUq8MXFq2PPjPziZ9W7bjB31bTgOwb4vGJMnHgS8DZ3RNrwf2qqpXDVfVOCXZHzgVeAqT/8uPqqqvDFtVGwYuLTse/GfPvi1aSZJcWVV7L9amhy/JeuB4JnMqvgJ4U1UdMmxVbRi4tOx48JfUUpIvAL9RVZ/v1p8HvKeqnjNsZeOT5PKq2meh9TGx07yWHTu2Dse+LVoh3gyc2X3fAe4A1g1Yz5jtmORVC61X1TkD1NSEZ7i0bHnwnz37tmglSbIaoKruSvKWqnrf0DWNTTf4aSFVVW+cWTGNGbi0bHnwnz37tmilSvK1qnry0HVo+fKSopazp1TVz06tvz3JlYNVszLck+T5m/RtuWfgmqRZyNAFaHkzcGk58+A/e/Zt0Url5SA9LF5S1LKVZC8mM8s/6OBfVVcNV9XKYN8WjVGSu5k/WAV4VFV5kkJbzcClZc+D/7Ds2yJpayU5qKou2mSk4veNaZSiaV3LXlXdNbX6a4CBa7bs2yJpa70QuAj4mXm2FTCawOUZLo1Kkq9X1W5D17GSeIZLkha3zdAFSD3zL4gGktyd5K55HncDPzJ0fZKWtyTHJlmdiT9JcnmSg4euq0+e4dKyY8dWSRqXJF+qqr2SHMJkNPRvAx8Z021+PDBp2amqxw1dgySpV3N9QV8GnFlV1yQZVf9QLylKkqShXZbkM0wC16eTPA54YOCaeuUlRUmSNKgk2wB7A9dX1Z1JdgJ2GdO8il5SlCRJg6qqB5LcADw1yfZD19OCgUuSJA0qyZuAY4FdgSuBA4AvAAcNWVef7MMlSZKGdizwbOCmqjoQeBZw57Al9cvAJUmShnZvVd0LkOSRVfUPwNMGrqlXXlKUJElDuznJjsAngAuS3AHcNHBNvXKUoiRJWjKSvBDYAfirqvrXoevpi5cUJUnSoJKcOLdcVRcD5wN/OlhBDRi4JEnS0HZLcjxM+nAB5wDXDVtSv7ykKEmSBtXdxuejwNXAgUwuJ548bFX9MnBJkqRBJJm+OfV2wB8DfwucBlBVlw9RVwsGLkmSNIgkn32IzVVVo5n41MAlSZLUmJ3mJUnSoJLskOS9SdZ3j99LssPQdfXJwCVJkoZ2OnA38OrucRfw4UEr6pmXFCVJ0qCSXFlVey/Wtpx5hkuSJA3tniTPn1tJ8jzgngHr6Z1nuCRJ0qCS7AWcyeSWPgB3AOuq6qrhquqXgUuSJC0JSVYDVNVdSd5SVe8buqa+GLgkSdKSk+RrVfXkoevoi324JEnSUpShC+iTgUuSJC1Fo7oEt+3QBUiSpJUpyd3MH6wCPGrG5TRlHy5JkqTGvKQoSZLUmIFLkiSpMQOXJElSYwYuSZKkxgxckiRJjf1/S6mOTmQ4cCAAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 720x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 351
        },
        "id": "5rbNY8wcZcfK",
        "outputId": "cc14e590-efac-4a6b-d9af-31e32b110c0e"
      },
      "source": [
        "%matplotlib inline\n",
        "my_tags = df['label_laporan']\n",
        "plt.figure(figsize=(10,4))\n",
        "df.label_laporan.value_counts().plot(kind='bar');"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAlwAAAFOCAYAAABT6sO9AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3deZhkdXn3//dHEHc2HQkCClESRROQIGA0GiEiaCLEIGI0EkIeNEHjkugDiZEoatQsbhEMEXxwiYhGfyLiQnCLyU9gWETR+GNEEfiBjA6LEVHA+/njfBuKsYeu6u7Tp6vn/bquvuqc7zlVc1dd03XuPt/lTlUhSZKk/txt6AAkSZJWOhMuSZKknplwSZIk9cyES5IkqWcmXJIkST0z4ZIkSerZpkMHcFce8IAH1I477jh0GJIkSXM6//zzv19Vq2Y7tqwTrh133JHVq1cPHYYkSdKckly+oWN2KUqSJPXMhEuSJKlnJlySJEk9M+GSJEnqmQmXJElSz0y4JEmSembCJUmS1DMTLkmSpJ4t64VPF9uOR39i6BDu0nfe8LShQ5AkST3wDpckSVLPTLgkSZJ6ZsIlSZLUs7ESriQvTXJJkq8l+UCSeybZKck5SdYk+WCSzdq592j7a9rxHUde55jW/s0kT+nnLUmSJC0vcyZcSbYD/gzYo6oeBWwCHAq8EXhzVT0MuA44oj3lCOC61v7mdh5JdmnPeySwP3B8kk0W9+1IkiQtP+N2KW4K3CvJpsC9gauBfYAPt+OnAAe17QPbPu34vknS2k+tqp9U1beBNcCeC38LkiRJy9ucCVdVXQX8PfBdukTrBuB84PqqurWddiWwXdveDriiPffWdv79R9tneY4kSdKKNU6X4lZ0d6d2Ah4E3IeuS7AXSY5MsjrJ6rVr1/b1z0iSJC2ZcboUfwv4dlWtrapbgI8AjwO2bF2MANsDV7Xtq4AdANrxLYAfjLbP8pzbVdWJVbVHVe2xatWqebwlSZKk5WWchOu7wN5J7t3GYu0LfB34HHBwO+cw4GNt+/S2Tzv+2aqq1n5om8W4E7AzcO7ivA1JkqTla87SPlV1TpIPAxcAtwIXAicCnwBOTfLa1nZSe8pJwHuTrAHW0c1MpKouSXIaXbJ2K3BUVd22yO9HkiRp2RmrlmJVHQscu17zZcwyy7CqbgaeuYHXeR3wugljlCRJmmquNC9JktQzEy5JkqSemXBJkiT1zIRLkiSpZyZckiRJPTPhkiRJ6pkJlyRJUs9MuCRJknpmwiVJktQzEy5JkqSemXBJkiT1zIRLkiSpZyZckiRJPTPhkiRJ6pkJlyRJUs9MuCRJkno2Z8KV5JeTXDTyc2OSlyTZOslZSS5tj1u185PkbUnWJLk4ye4jr3VYO//SJIf1+cYkSZKWizkTrqr6ZlXtVlW7Ab8G3AR8FDgaOLuqdgbObvsABwA7t58jgRMAkmwNHAvsBewJHDuTpEmSJK1kk3Yp7gt8q6ouBw4ETmntpwAHte0DgfdU58vAlkm2BZ4CnFVV66rqOuAsYP8FvwNJkqRlbtKE61DgA217m6q6um1fA2zTtrcDrhh5zpWtbUPtkiRJK9rYCVeSzYCnAx9a/1hVFVCLEVCSI5OsTrJ67dq1i/GSkiRJg5rkDtcBwAVV9b22/73WVUh7vLa1XwXsMPK87VvbhtrvpKpOrKo9qmqPVatWTRCeJEnS8jRJwvVs7uhOBDgdmJlpeBjwsZH257XZinsDN7Sux08D+yXZqg2W36+1SZIkrWibjnNSkvsATwaeP9L8BuC0JEcAlwOHtPYzgacCa+hmNB4OUFXrkhwHnNfOe01VrVvwO5AkSVrmxkq4qupHwP3Xa/sB3azF9c8t4KgNvM7JwMmThylJkjS9XGlekiSpZyZckiRJPTPhkiRJ6pkJlyRJUs9MuCRJknpmwiVJktQzEy5JkqSemXBJkiT1zIRLkiSpZyZckiRJPTPhkiRJ6pkJlyRJUs9MuCRJknpmwiVJktQzEy5JkqSemXBJkiT1bKyEK8mWST6c5L+TfCPJY5NsneSsJJe2x63auUnytiRrklycZPeR1zmsnX9pksP6elOSJEnLybh3uN4KfKqqHg7sCnwDOBo4u6p2Bs5u+wAHADu3nyOBEwCSbA0cC+wF7AkcO5OkSZIkrWRzJlxJtgCeAJwEUFU/rarrgQOBU9pppwAHte0DgfdU58vAlkm2BZ4CnFVV66rqOuAsYP9FfTeSJEnL0Dh3uHYC1gLvTnJhkncluQ+wTVVd3c65BtimbW8HXDHy/Ctb24baJUmSVrRxEq5Ngd2BE6rq0cCPuKP7EICqKqAWI6AkRyZZnWT12rVrF+MlJUmSBjVOwnUlcGVVndP2P0yXgH2vdRXSHq9tx68Cdhh5/vatbUPtd1JVJ1bVHlW1x6pVqyZ5L5IkScvSnAlXVV0DXJHkl1vTvsDXgdOBmZmGhwEfa9unA89rsxX3Bm5oXY+fBvZLslUbLL9fa5MkSVrRNh3zvBcB70+yGXAZcDhdsnZakiOAy4FD2rlnAk8F1gA3tXOpqnVJjgPOa+e9pqrWLcq7kCRJWsbGSriq6iJgj1kO7TvLuQUctYHXORk4eZIAJUmSpp0rzUuSJPXMhEuSJKlnJlySJEk9M+GSJEnqmQmXJElSz0y4JEmSembCJUmS1DMTLkmSpJ6ZcEmSJPXMhEuSJKlnJlySJEk9M+GSJEnqmQmXJElSz0y4JEmSembCJUmS1DMTLkmSpJ6NlXAl+U6Srya5KMnq1rZ1krOSXNoet2rtSfK2JGuSXJxk95HXOaydf2mSw/p5S5IkScvLJHe4nlRVu1XVHm3/aODsqtoZOLvtAxwA7Nx+jgROgC5BA44F9gL2BI6dSdIkSZJWsoV0KR4InNK2TwEOGml/T3W+DGyZZFvgKcBZVbWuqq4DzgL2X8C/L0mSNBXGTbgK+EyS85Mc2dq2qaqr2/Y1wDZtezvgipHnXtnaNtQuSZK0om065nmPr6qrkjwQOCvJf48erKpKUosRUEvojgR48IMfvBgvKUmSNKix7nBV1VXt8Vrgo3RjsL7Xugppj9e2068Cdhh5+vatbUPt6/9bJ1bVHlW1x6pVqyZ7N5IkScvQnAlXkvskud/MNrAf8DXgdGBmpuFhwMfa9unA89psxb2BG1rX46eB/ZJs1QbL79faJEmSVrRxuhS3AT6aZOb8f62qTyU5DzgtyRHA5cAh7fwzgacCa4CbgMMBqmpdkuOA89p5r6mqdYv2TiRJkpapOROuqroM2HWW9h8A+87SXsBRG3itk4GTJw9TkiRpernSvCRJUs9MuCRJknpmwiVJktQzEy5JkqSemXBJkiT1zIRLkiSpZyZckiRJPTPhkiRJ6pkJlyRJUs9MuCRJknpmwiVJktQzEy5JkqSemXBJkiT1zIRLkiSpZyZckiRJPTPhkiRJ6tnYCVeSTZJcmOSMtr9TknOSrEnywSSbtfZ7tP017fiOI69xTGv/ZpKnLPabkSRJWo4mucP1YuAbI/tvBN5cVQ8DrgOOaO1HANe19je380iyC3Ao8Ehgf+D4JJssLHxJkqTlb6yEK8n2wNOAd7X9APsAH26nnAIc1LYPbPu04/u28w8ETq2qn1TVt4E1wJ6L8SYkSZKWs3HvcL0FeAXws7Z/f+D6qrq17V8JbNe2twOuAGjHb2jn394+y3MkSZJWrDkTriS/DVxbVecvQTwkOTLJ6iSr165duxT/pCRJUq/GucP1OODpSb4DnErXlfhWYMskm7ZztgeuattXATsAtONbAD8YbZ/lOberqhOrao+q2mPVqlUTvyFJkqTlZs6Eq6qOqartq2pHukHvn62q5wCfAw5upx0GfKxtn972acc/W1XV2g9tsxh3AnYGzl20dyJJkrRMbTr3KRv0v4FTk7wWuBA4qbWfBLw3yRpgHV2SRlVdkuQ04OvArcBRVXXbAv59SZKkqTBRwlVVnwc+37YvY5ZZhlV1M/DMDTz/dcDrJg1SkiRpmrnSvCRJUs9MuCRJknpmwiVJktQzEy5JkqSemXBJkiT1zIRLkiSpZyZckiRJPTPhkiRJ6pkJlyRJUs9MuCRJknpmwiVJktQzEy5JkqSemXBJkiT1zIRLkiSpZyZckiRJPTPhkiRJ6tmcCVeSeyY5N8lXklyS5NWtfack5yRZk+SDSTZr7fdo+2va8R1HXuuY1v7NJE/p601JkiQtJ+Pc4foJsE9V7QrsBuyfZG/gjcCbq+phwHXAEe38I4DrWvub23kk2QU4FHgksD9wfJJNFvPNSJIkLUdzJlzV+Z+2e/f2U8A+wIdb+ynAQW37wLZPO75vkrT2U6vqJ1X1bWANsOeivAtJkqRlbKwxXEk2SXIRcC1wFvAt4PqqurWdciWwXdveDrgCoB2/Abj/aPssz5EkSVqxxkq4quq2qtoN2J7urtTD+wooyZFJVidZvXbt2r7+GUmSpCUz0SzFqroe+BzwWGDLJJu2Q9sDV7Xtq4AdANrxLYAfjLbP8pzRf+PEqtqjqvZYtWrVJOFJkiQtS+PMUlyVZMu2fS/gycA36BKvg9tphwEfa9unt33a8c9WVbX2Q9ssxp2AnYFzF+uNSJIkLVebzn0K2wKntBmFdwNOq6ozknwdODXJa4ELgZPa+ScB702yBlhHNzORqrokyWnA14FbgaOq6rbFfTuSJEnLz5wJV1VdDDx6lvbLmGWWYVXdDDxzA6/1OuB1k4cpSZI0vVxpXpIkqWcmXJIkST0z4ZIkSeqZCZckSVLPTLgkSZJ6ZsIlSZLUMxMuSZKknplwSZIk9cyES5IkqWcmXJIkST0z4ZIkSeqZCZckSVLPTLgkSZJ6ZsIlSZLUMxMuSZKknplwSZIk9WzOhCvJDkk+l+TrSS5J8uLWvnWSs5Jc2h63au1J8rYka5JcnGT3kdc6rJ1/aZLD+ntbkiRJy8c4d7huBf68qnYB9gaOSrILcDRwdlXtDJzd9gEOAHZuP0cCJ0CXoAHHAnsBewLHziRpkiRJK9mcCVdVXV1VF7TtHwLfALYDDgROaaedAhzUtg8E3lOdLwNbJtkWeApwVlWtq6rrgLOA/Rf13UiSJC1DE43hSrIj8GjgHGCbqrq6HboG2KZtbwdcMfK0K1vbhtolSZJWtLETriT3Bf4NeElV3Th6rKoKqMUIKMmRSVYnWb127drFeElJkqRBjZVwJbk7XbL1/qr6SGv+XusqpD1e29qvAnYYefr2rW1D7XdSVSdW1R5VtceqVasmeS+SJEnL0qZznZAkwEnAN6rqH0cOnQ4cBryhPX5spP2FSU6lGyB/Q1VdneTTwOtHBsrvBxyzOG9DS2HHoz8xdAh36TtveNrQIUiSNKs5Ey7gccAfAF9NclFr+0u6ROu0JEcAlwOHtGNnAk8F1gA3AYcDVNW6JMcB57XzXlNV6xblXUhTwIRVkjZecyZcVfUlIBs4vO8s5xdw1AZe62Tg5EkClCRJmnauNC9JktQzEy5JkqSemXBJkiT1zIRLkiSpZyZckiRJPTPhkiRJ6pkJlyRJUs9MuCRJknpmwiVJktQzEy5JkqSemXBJkiT1bJzi1ZI0KAt/S5p23uGSJEnqmQmXJElSz0y4JEmSembCJUmS1LM5B80nORn4beDaqnpUa9sa+CCwI/Ad4JCqui5JgLcCTwVuAv6wqi5ozzkMeGV72ddW1SmL+1YkSbNx0oE0vHHucP0fYP/12o4Gzq6qnYGz2z7AAcDO7edI4AS4PUE7FtgL2BM4NslWCw1ekiRpGsyZcFXVF4F16zUfCMzcoToFOGik/T3V+TKwZZJtgacAZ1XVuqq6DjiLn0/iJEmSVqT5juHapqqubtvXANu07e2AK0bOu7K1bahdkiRpxVvwoPmqKqAWIRYAkhyZZHWS1WvXrl2sl5UkSRrMfBOu77WuQtrjta39KmCHkfO2b20bav85VXViVe1RVXusWrVqnuFJkiQtH/Mt7XM6cBjwhvb4sZH2FyY5lW6A/A1VdXWSTwOvHxkovx9wzPzDliRpaTjLU4thnGUhPgD8JvCAJFfSzTZ8A3BakiOAy4FD2uln0i0JsYZuWYjDAapqXZLjgPPaea+pqvUH4kuSJK1IcyZcVfXsDRzad5ZzCzhqA69zMnDyRNFJkiStAPPtUpQkSZrTcu6SXcruWEv7SJIk9cyES5IkqWcmXJIkST0z4ZIkSeqZCZckSVLPTLgkSZJ6ZsIlSZLUMxMuSZKknplwSZIk9cyES5IkqWcmXJIkST0z4ZIkSeqZCZckSVLPTLgkSZJ6ZsIlSZLUsyVPuJLsn+SbSdYkOXqp/31JkqSltqQJV5JNgHcABwC7AM9OsstSxiBJkrTUlvoO157Amqq6rKp+CpwKHLjEMUiSJC2ppU64tgOuGNm/srVJkiStWKmqpfvHkoOB/avqj9v+HwB7VdULR845Ejiy7f4y8M0lC3ByDwC+P3QQU8zPb2H8/ObPz25h/PwWxs9v/pb7Z/eQqlo124FNlziQq4AdRva3b223q6oTgROXMqj5SrK6qvYYOo5p5ee3MH5+8+dntzB+fgvj5zd/0/zZLXWX4nnAzkl2SrIZcChw+hLHIEmStKSW9A5XVd2a5IXAp4FNgJOr6pKljEGSJGmpLXWXIlV1JnDmUv+7PZmKrs9lzM9vYfz85s/PbmH8/BbGz2/+pvazW9JB85IkSRsjS/tIkiT1zIRLSybJ1rO07TRELNp4Jblbks2HjkPSxsUuxXlI8kDgnjP7VfXdAcOZGkn+Ezigqm5s+7sAp1XVo4aNbHlL8nZgg7+oVfVnSxjOVEryr8ALgNvoZktvDry1qv5u0MAkzSrJM+7qeFV9ZKliWSxLPmh+miV5OvAPwIOAa4GHAN8AHjlkXFPk9cDHkzyNblHb9wDPGTakqbB66ABWgF2q6sYkzwE+CRwNnA+YcE0gya8DOzJy7aiq9wwW0BRI8tyqel+Sl812vKr+caljmhK/cxfHCjDhWuGOA/YG/r2qHp3kScBzB45palTVJ5LcHfgMcD/gd6vq/xs4rGWvqk4ZOoYV4O7t/95BwD9V1S1JvL0/gSTvBR4KXER3pxC6C58J1127T3u836BRTJmqOnzoGBabCddkbqmqH7QxIHerqs8lecvQQS13s3SJbQF8C3hhErvExpRkFfC/gV24c5f2PoMFNT3+GfgO8BXgi0keAtw4aETTZw+6O4UmqhOoqn9uj68eOpZp1XpFHsmdv/deM1xE82PCNZnrk9wX+CLw/iTXAj8aOKZpsH6X2PmDRDH93g98EHga3Xikw4C1g0Y0JarqbcDbRpoub3eoNb6vAb8AXD10INMoyZuA1wI/Bj4F/Crw0qp636CBLXNJ3gncG3gS8C7gYODcQYOaJwfNTyDJfYCbgdCNPdoCeH9V/WDQwLRRSHJ+Vf1akour6ldb23lV9ZihY1uuHD+zeJJ8DtiN7mL3k5n2qnr6YEFNkSQXVdVuSX4X+G3gZcAXq2rXgUNb1ma+70Ye7wt8sqp+Y+jYJuUdrsn8EfC+qroOcFzNmJKcVlWHJPkqd+5aDFAzyYPmdEt7vLrdYv//gZ9bakN34viZxfM3Qwcw5Waut08DPlRVNyQZMp5p8eP2eFOSBwE/ALYdMJ55M+GazDbAeUkuAE4GPu14hrG8uD3+9qBRTL/XJtkC+HPg7XRLG7x02JCWt5nxM8Dbq2rd6DHXgJtMVX1h6Bim3BlJ/psugfiTNibz5oFjmgZnJNmSbkbxBXR/tL9r2JDmxy7FCaX7k2Q/4HC6QaSnASdV1bcGDWwKtC7ZH1fVz5L8EvBwulvDt8zxVGlBZlkD7hF0dxlcA25MSfamS/QfAWwGbAL8qKpcRHZMbfHnG6rqtiT3BjavqmuGjmtaJLkHcM+qumHoWObDO1wTqqpKcg1wDXArsBXw4SRnVdUrho1u2fsi8BtJtqJbGuI84Fm4FtdYkrybWRZArao/GiCcaeMacAv3T8ChwIfo/th8HvBLg0Y0fR4E/FaSe460uazGXUjyvFnapnL9NxOuCSR5Md2XzPfpbmm+vK3nczfgUsCE666lqm5KcgRwfFW9KclFQwc1Rc4Y2b4n8Lt047g0B9eAWxxVtSbJJlV1G/DuJBcCxwwd1zRIcizwm3TLupwJHAB8CROuuYxOCronsC9d1+LUfW4mXJPZGnhGVV0+2ti6yByfNLckeSzdnYUjWtsmA8YzVarq30b3k3yA7gtbG+AacIvqpiSbARe1JQ6uxnq8kzgY2BW4sKoOT7IN4JIQc6iqF43ut/Fcpw4UzoKYcE2gqo5NskmbKTFa2uK7VfWNAUObFi+h+2v4o1V1SZJfBD43cEzTbGfggUMHscy5Btzi+QO6BOuFdJM1dgB+b9CIpsvM+NVbW/H0a+k+Q03mR8BUTnhx0PwEkryQbmr094CftWaXNdCSSPJD7ny35hrgmPXvfEmLLckmwHuqynFv85TkeOAv6cbB/TnwP8BFK7GEzWJK8nHu+N67G12X7GlVdfRwUc2PCdcEkqwB9nKh08kkeUtVvWS9X5zbuXCi+uIacIsnyZeAfarqp0PHMu2S7Eg3Q/HigUNZ9pI8cWT3VuDyqrpyqHgWwi7FyVwBTOV01IHNDG78+0GjmHJJHkf3F/GPkjwX2B146/pjCnUnrgG3eC4D/jPJ6YyUNHO1/vEkObuq9gWoqu+s36YNWs2dlxPaPcn3pnE5IROuyVwGfD7JJ7hzaQu/cO7aG4D9quoLSY6pqr8dOqApdQKwa5Jd6bok3kWXzD7xLp+1Eauqmbp/32eWNeCGi2wqfav93A1X7h9bWwLi3sAD2pI4M8vLbw5sN1hg02PFLCdkwjWZ77afzdqPxrNqZPuZgAnX/Nza1oE7EPinqjqpLbGhua2YL+2hVNWrh45hSj2fbsLQg+iWM5hxI93aZrprK2Y5IROuCfiFM28OFFwcP0xyDPBc4Alt/be7DxzTtFgxX9pDaaVoXgE8km49JACqap/BgpoCVfVW4K1JXlRVbx86nim0YpYTMuGaQOuK+AtgR+68LIRfOHftF9u4j4xs385B82N7FvD7wBFVdU2SB9PVF9PcVsyX9oDeD3yQbjzcC4DDgLWDRjQFkuxTVZ8FrkryjPWPV9VHBghrmryYFbKckAnXZD4EvJNu7MxtA8cyTQ4c2Xbg/Pw9enS8YFV9t9Vj09xWzJf2gO7furFf3ApZfyHJeUMHNQWeCHwW+J1ZjhVgwnXXrhj9o7yqLkvy3iEDmi+XhZhAkvOr6teGjkMbpyT/Bbyy/bVMklcAT6qqA4aNbHlLshvwMOASFyievyRfrqq9k3waeBtdWakPV9VDBw5NK1iS84GnV9VVbf+JdGNYf2XYyCZnwjWBJH9DtzrwR7nzLMV1Q8WkjUeSB9DVU3w5sD/dTLtnuy7ShiV5Fd2Yt/OBvYC/rap/GTaq6dTKl/0H3erob6ebZfc3VfXxQQObEkm2AI4FntCavgC8pqpcauguJHkMcDzdHcLd6SZd/XZVXTFoYPNgwjWBJN+epbmq6heXPBhtlJI8EPh3ugTij8pf4LuU5BLgMW3A/P2BT1XVY+Z6nn5eksdV1X/O1abZJfk34GvAKa3pD4Bdq+rnxnXpztr4y38GbgaeVlVTOXbQhEta5mYp6bMZ3YrLRZfwbz5IYFMgyQVVtfvIvsMC5mn9z3JDbZpdkouqare52tSZpTLJLnQF06+D6Zxs5aD5MczMMplthgk4y2RcbZbny4GH4CzPsVWVi0zO3+is2AAPHZ0lO41f2kut3V34dWBVkpeNHNocZ3pO4sdJHl9VX4LbK0f8eOCYlrMVN8HKhGs8zjJZHDOzPP8FZ3lOLEnoljXYqaqOS7IDsG1VnTtwaMvZgevtr7gv8SWwGXBfuuvFaPJ/I3DwIBFNpz8BTmljuQKsA/5w0IiWsTYTFoAkDwF2rqp/bzOzpzLRt0tRS8bunIVJcgLwM7oCwo+YWTXdMUlaCkkeYt3OhUuyOUBV3Th0LNMgyf8CjgS2rqqHJtkZeOc01qD0DteEkjyNn19p+TXDRTRVPp7kT3GW53ztVVW7J7kQoKquS2KJKS2VeyQ5ERd+nsh63bCj7YC1eMdwFLAncA5AVV3aJg9NHROuCSR5J10R0ifRLX56MGB3zvgOa48vH2krwFme47klySa0gaSt1MrPhg1JGxEXfp4fx2AuzE+q6qczCWqSTZnScnF2KU4gycVV9asjj/cFPllVvzF0bFr5kjyHrrzP7nRTyw+mWwj1Q4MGpo2CQwI0hCRvAq4Hnge8CPhT4OtV9VeDBjYPJlwTSHJOVe2V5MvAM4Af0K1e/bCBQ5saSR5FN713tEv2PcNFNF2SPByYGbvwWVdOH48zZBfOhZ8XppWTeiuwN90dmv8XeGlVXTZoYMtckrvR1T/dj26ywaeBd03jGoQmXBNI8td0KyzvC7yD7pfmX6rqVYMGNiWSHAv8Jl3CdSZwAPClqnKm011os3Juqapb2v4vA08FLndJkvEk+Qpdd9j5jHSHVdX5gwU1ZVz4eWHaH+rvAD7Qmg4FXlRVew0X1fRo41UfCVxVVdcOHc98mHDNU5J70N2leXhVnTN0PNMgyVeBXYELq2rXJNsA76uqJw8c2rKW5IvAEW2w6MPoxg2+ny5xPbeqjhk0wClgd5iGNjMUZb22r1TVrkPFtJy1MdNvb8Xmt6C7I3gbsDXwF1X1gbt8gWXIhGuBkny3qh48dBzTIMm5VbVnK0b6JOCHwDeq6uEDh7asJfnqTKHWJMfRTY8+qv3Fd/40FnFdanaHLQ6HBMxfkjfSrZJ+Kl3vyLOArYC/A/8vri/JJVX1yLb9EuA3q+qgJL9AN3b60cNGODlnKS5chg5giqxOsiXdwqfnA/9D91eL7troX0X7cMcX9E+TOEtxPM6QXaANDQkATLjGc0h7fP567Yfi/8XZ/HRk+8l0s2SpqmtmZixOG+9wLZB3uOYnyY7A5lV18cChLHtJ3gdcA1wFHE230vxNLXn9gl0SWgoOCdBSSvI54B/ovvc+Rzd855q2LMTXprFnxDtcY5iliObth4D7L3E4U6vVDruoqn4EPB7YPZ8rC8UAAA0DSURBVMlbXb16Tv8LeDHdgpP7VdVNrX0XLFUzNrvDFuzHVfWzJLe21dKvBXYYOqhpkeSZwKeq6odJXkm3vMtxVXXhwKEtV88H3gb8AvCSqrqmte8LfGKwqBbAO1xjSPLEuzo+WvNJG5bkYrq/kH8V+D90CygeUlV3+flKC+UM2YVLcjzwl3RdYH9ONyTgoqo6fNDApsTI+o2PB15LNzTgVc5S3HiYcGnJJLmglaZ5Fd3U3pNm2oaOTSub3WGLyyEBk0tyYVU9OsnfAl+tqn+daRs6Ni0NuxS1lH6Y5BjgucAT2oJ2dx84Jm0c7A6bpyQb/IMoye5VdcFSxjPFrkryz3QDwN/Ylha628AxaQmZcGkpPQv4fbo1pa5J8mDajDupZ86Qnb9/uItjRTdzVnM7BNgf+Puquj7Jttx51qxWOLsUpSlheZrFYXeYhpDkiKo6ab22N1TV0UPFtJwleW5VvS/Jy2Y7XlX/uNQxLZR3uCbgBW9hkuxNVxrpEcBmwCbA/1TVFoMGNj0+RFee5l8YKU+juTlDduFaiamXAQ+uqiOT7Az8clWdMXBo0+L3ktxcVe8HSPIORmbM6ufcpz3eb9AoFpF3uCZgPbaFSbKabobTh4A96Kq//5KlacZjeZr5c4bswiX5IN133/Oq6lEtAfuvqtpt4NCmQpJ7AacDJ9N1LV5fVS8eNiotJQfsTebWqjqhqs6tqvNnfoYOappU1Rpgk6q6rareTffFo/F8PMmfJtk2ydYzP0MHNSVure6vywOBf6qqd7CC/nJeIg+tqjcBtwC09eCmc8nvJTTye3ov4I+BV9CVNXu1v79zS/KmJJsnuXuSs5OsTfLcoeOaD7sUJ/PxJH+K9djm66ZW/++iJG8CrsakfxKWp5k/Z8gu3E/bXZoCSPJQRr4HtUHn031mGXl8Wvvx93du+1XVK5L8LvAd4BnAF4H3DRrVPNilOIEk356luarKX5gxJHkI8D268VsvBbYAjm93vaTetIK3vw+cV1X/0WbI/qYrzY8vyZOBV9ItHvsZ4HHAH1bV54eMSytbkq+1Lux3AR+uqk8l+co0ljQz4dKSSLIJ8J6qes7QsUwzy9NoSEnuD+xNd5fmy1X1/YFDWvaSvKJ1xZLkmVX1oZFjr6+qvxwuuuUvyRuAg4AfA3sCWwJnTOMK/SZcE/KCN39JvgTsU1U/nfNk/RzL08yfM2QXR5Lt+PlZ2l8cLqLlb7SaxvqVNay0MZ421u2GqrqtTdbYfKS24tRwDNcENnTBA0y4xnMZ8J9JTgd+NNM4jeupDORg7ihPc/hMeZqBY5oW/8QsM2QHjWjKJHkj3eLFlwA/a81FN55GG5YNbM+2r9k9CPitJKPLaEzdddeEazJe8BbmW+3nbjhDbD4sT7MAVbUmySZVdRvw7iQXAi5JMr6D6NbdcqD8ZGoD27Ptaz0r6UaHCddkvOAtQFW9GroFFNuUck3G8jTz5wzZhbuMbmanCddkdk1yI93drHu1bdq+C5/ObcXc6DDhmowXvAVI8ljgJOC+wIOT7Ao8v6r+dNjIpsPI5/TOJJ/C8jST+AO6BOuFdDNkdwB+b9CIps9NdAnr2dx5WZw/Gy6k5a+qNhk6him3Ym50OGh+nqzHNrkk59D9tXJ6VT26tX2tqh41bGTTYbQ8TVv4b3fA8jRzcIbs4khy2GztVXXKUseijUeS44G/pBuD+ed0NzouqqrDBw1sHky4JuAFb2GSnFNVeyW5cCThmsr1VIZgeZr5c4bs4mgLnz64qr45dCza+Ez7jQ7HMEzmBLqxILvSZdrfYgoH7g3oiiS/DlQr0/AXwDeGDmqKWJ5m/mZmyP51kpfN/Awd1DRJ8jvARcCn2v5ubcax1JvWhQ1AVX2nqi4ebZsmJlyT8YK3MC8AjgK2A64CdgMcvzW+0fI0n7A8zUS+BZzBHTNkZ340vr+hW3jyeoCqugjL0qgnSe7Z1t96QJKtRurH7kh3DZk6DpqfjPXYFuYx64+jSfIC4J0DxTNtnkVXnuaIqrqmlaf5u4FjmgrOkF0Ut1TVDcmdlo762YZOlhbo+cBL6NbgumCk/Ua6dfWmjmO4JmA9toVJ8l/AK6vqs23/5XTjag4YNjKtdKMzZKvKGbLzkOQk4GzgaLoZnn8G3L2qXjBoYFrRkryoqt4+dByLwYRLSybJA+i6dV4O7A88HHi2A5nHY3ma+XOG7MK1kip/BezXmj4NvLaqbh4uKq1USfapqs8mecZsx6vqI0sd00LZpTgBL3gLU1XfT/J04N/p1jE7uMz4J2F5mgWoqivW6w67bahYpkkrp/IC4GHAV4HHVtWtw0aljcATgc8CvzPLsQJMuFY4L3jzkOSH3LmExWZ0g20PTlJVtfkwkU0fy9PM251myAIvxhmy4zoFuAX4D7qyKo+gG1sj9aaqjm2PU7fe1oaYcE3IC97kqsrZYIvD8jTz9wLgrdwxQ/YzOEN2XLtU1a/A7eO4zh04Hm1EkmwBHAs8oTV9AXhNVd0wXFTz45f1ZO50wUvyUvwMx5bOc5P8ddvfIcmeQ8c1RUbL0/wIy9NM4jFV9Zyq2qaqHlhVzwUOGTqoKXHLzIZdiRrAycAP6X5fD6GbpfjuQSOaJwfNTyDJQ4Dv0XWJvRTYAji+qtYMGtiUSHIC3TTyfarqEUm2Aj5TVY8ZOLRlz/I0C+MM2flLchtdgg+tADNdXcUADglQr5JcVFW7zdU2DexSHFO74L2+XfBuBl49cEjTaK+q2r11w1JV17U7hppDVd2W5CFJNnNW57w8HTijJVozM2QPHDak6WDxZQ3sx0keX1VfgttL7P144JjmxYRrTF7wFsUtLXEtgCSrcOHEScyUpzmdO+44UFX/OFxI08EZstLU+hPglDaWK8A64A8HjWieTLgm4wVvYd4GfBR4YJLX0a2L9MphQ5oq32o/M+VpNAdnyErTrZWQ2jXJ5m3/xoFDmjfHcE0gybGztc+UDdHskuxQVVe07YcD+9L9pXI28NCqOmPI+KaN5WkkrXRzFZefxhsdJlzz4AVvMkn+G9i/qr6zXvsfAX9VVQ8dJLApY3ma+Uu34ulzgJ2q6rgkOwDbVpVLHEjL0IZucMyYxhsdJlwT8II3P0meCrwFeFpVXdrajqa7AB5QVVcOGd+0sDzN/DlDVtLQXENqMm8BngL8AKCqvsIdi7FpA6rqTLqBj59M8qgkb6GbNfYEk63JzHTNjrA8zXj2qqqj6GYYU1XX0Y3nkrSMJfnFJB9PsjbJtUk+luQXh45rPky4JuQFb36q6mzgcODzdIOW92kXPY3vTuVpkvwFlqcZlzNkpen0r8BpwLbAg+hK631g0IjmyYRrMl7w5iHJD5PcCJwJbE43aP7akXaN5wXAUdxRnmY3LE8zrvVnyH4JeP2wIUkaw72r6r1VdWv7eR9wz6GDmg/HcE0gyQPo6rH9Ft0su88Af1ZV6wYNTBuFJAdU1SfXa3tBVb1zqJiWO2fIStMtyRuB64BT6e5QPwvYCvg7gGm6/ppwTcALnoZkeZrJOUNWmm5Jvn0Xh6uqpmY8lwnXBLzgaUjtDusZwGh5mmdb+WDDnCErabkw4ZqAFzwNLckDuaM8zR9ZnmZuSfYF/hk4CPhjYE+6BMxJG9Iyl+SZwKeq6odJXgnsDhxXVRcOHNrETLgm5AVPS20D5WlubW2WpxlDkt+gGzT/X8AhVXXzwCFJGkOSi6vqV5M8Hngt3ditV1XVXgOHNjETrjF4wZOm08jvboB7ALfQLeUS/N2Vlr0kF1bVo5P8LfDVqvrXmbahY5uUCZc0JSxPI2ljk+QMumVwnkzXnfhj4Nyq2nXQwObBhGsCXvA0JMvTSNrYJLk33Zjpr1bVpUm2BX6lqj4zcGgTc+HTyRwPPBb4/bb/P8A7hgtHGxnL00ja2Dy7qj4yM8u4qq4G9hk4pnnZdOgApsxeVbV7kguhu+Al8YKnpWJ5Gkkbm99LcnNVvR8gyTuY0pXmTbgm4wVPQ1q/PM3BwCuHDUmSevV7wOlJfkbXtXh9VR0xcEzz4hiuCSR5Dl1Zgd2BU2gXvKr60KCBaUWzPI2kjU2SrUd27wf8P8B/Aq+C6SrpM8OEawxe8DQky9NI2ti0kj4zS7rMPM6YqpI+M0y4xuAFT0OyPI0kTT9nKY7nZcBnkuw809AueC8FnjhYVNooVNWZwJ8An0zyqCRvAZ4OPMFkS9JKlOQVI9vPXO/Y65c+ooXzDteYrMemoVmeRtLGIskFVbX7+tuz7U8LZymOqarOTnI48Hm6C94+XvC0FGYpT7MvcG1biNfyNJJWomxge7b9qWDCNQYveBpSVd1v6BgkaYnVBrZn258KdilKkqRlJcltwI/obnTcC7hp5hBwz6q6+1CxzZcJlyRJUs+cpShJktQzEy5JkqSemXBJkiT1zIRLkiSpZyZckiRJPTPhkiRJ6tn/BQdGDwpI9RWQAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 720x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ELpJZGkkHaEu"
      },
      "source": [
        "#Save DataFrame to CSV\n",
        "df.to_csv(\"capstonetweetlabelled.csv\", index=False)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "4ddo3l-SJiHm"
      },
      "source": [
        "#Merging Initial and Additional Dataset (Post)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "n8xM07uWj1PH",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "b7ae2ac4-b1eb-4030-82c6-5886f451a2b1"
      },
      "source": [
        "#Read Initial Dataset\n",
        "df_initial = pd.read_csv(\"capstonetweetlabelled.csv\")\n",
        "df_initial.head()"
      ],
      "execution_count": null,
      "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>index</th>\n",
              "      <th>text</th>\n",
              "      <th>label_laporan</th>\n",
              "      <th>label_post</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>the ironies of the movement are too painfully ...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "      <td>Lokasi Kerja</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>women in kuwait have launched a social media c...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>triger warning raising awareness of sexual ass...</td>\n",
              "      <td>Penelantaran</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>charges brought against the guy that smacked m...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>and the fourth presenter on th may is hannah b...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Pendidikan</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   index  ...         label_post\n",
              "0      0  ...       Lokasi Kerja\n",
              "1      1  ...              Siber\n",
              "2      2  ...      Lokasi Privat\n",
              "3      3  ...      Lokasi Privat\n",
              "4      4  ...  Lokasi Pendidikan\n",
              "\n",
              "[5 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 67
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "id": "jgv2lvWFJrez",
        "outputId": "9731bf64-87e0-4bb2-995b-db049ff92208"
      },
      "source": [
        "#Import Additional Post Dataset\n",
        "url_post = 'https://drive.google.com/file/d/16-zEm0bhmMS6HZPfCrDhqJU2ZiixN-ex/view?usp=sharing'\n",
        "file_id_post = url_post.split('/')[-2]\n",
        "csv_url_post = 'https://drive.google.com/uc?id=' + file_id_post\n",
        "df_post = pd.read_csv(csv_url_post)\n",
        "df_post.head()"
      ],
      "execution_count": null,
      "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>index</th>\n",
              "      <th>text</th>\n",
              "      <th>label</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>schwartz and southern also constructed four se...</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>if you think internet flirting and cybersex ar...</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>if a relationship were strong in the first pla...</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>then of course there s cybersex which mostly c...</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>she says that it is a daily occurrence to be i...</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   index                                               text  label\n",
              "0      0  schwartz and southern also constructed four se...  Siber\n",
              "1      1  if you think internet flirting and cybersex ar...  Siber\n",
              "2      2  if a relationship were strong in the first pla...  Siber\n",
              "3      3  then of course there s cybersex which mostly c...  Siber\n",
              "4      4  she says that it is a daily occurrence to be i...  Siber"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 68
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Mry6IBwGKG_s"
      },
      "source": [
        "#Adjust columns between two datasets\n",
        "df_initial.rename(columns={'label_post': 'label'}, inplace = True)\n",
        "df_initial.drop(columns=['index', 'label_laporan'], inplace=True)\n",
        "df_post = df_post.drop(columns=['index'])"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "id": "ao8dG9BYK2CR",
        "outputId": "d4396a15-640f-4a59-d9b2-3831dfb64190"
      },
      "source": [
        "df_initial.head()"
      ],
      "execution_count": null,
      "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>text</th>\n",
              "      <th>label</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>the ironies of the movement are too painfully ...</td>\n",
              "      <td>Lokasi Kerja</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>women in kuwait have launched a social media c...</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>triger warning raising awareness of sexual ass...</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>charges brought against the guy that smacked m...</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>and the fourth presenter on th may is hannah b...</td>\n",
              "      <td>Lokasi Pendidikan</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                text              label\n",
              "0  the ironies of the movement are too painfully ...       Lokasi Kerja\n",
              "1  women in kuwait have launched a social media c...              Siber\n",
              "2  triger warning raising awareness of sexual ass...      Lokasi Privat\n",
              "3  charges brought against the guy that smacked m...      Lokasi Privat\n",
              "4  and the fourth presenter on th may is hannah b...  Lokasi Pendidikan"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 70
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "id": "CgE3MFqcK3kk",
        "outputId": "8021826a-dbad-4380-a65a-cb8e3a619795"
      },
      "source": [
        "df_post.head()"
      ],
      "execution_count": null,
      "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>text</th>\n",
              "      <th>label</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>schwartz and southern also constructed four se...</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>if you think internet flirting and cybersex ar...</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>if a relationship were strong in the first pla...</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>then of course there s cybersex which mostly c...</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>she says that it is a daily occurrence to be i...</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                text  label\n",
              "0  schwartz and southern also constructed four se...  Siber\n",
              "1  if you think internet flirting and cybersex ar...  Siber\n",
              "2  if a relationship were strong in the first pla...  Siber\n",
              "3  then of course there s cybersex which mostly c...  Siber\n",
              "4  she says that it is a daily occurrence to be i...  Siber"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 71
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "M_H8EvljK44-"
      },
      "source": [
        "df_final_post = pd.concat([df_initial, df_post])"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Q0uTCmyMK95q"
      },
      "source": [
        "#Create Index\n",
        "df_final_post['index'] = range(0, len(df_final_post.index), 1)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "oHfvgeJNLShY",
        "outputId": "feea7584-33ad-4fad-cae6-223cf21d9bdb"
      },
      "source": [
        "df_final_post['label'].value_counts()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Netral               4617\n",
              "Lokasi Publik        3679\n",
              "Lokasi Privat        3109\n",
              "Siber                2313\n",
              "Lokasi Kerja         1894\n",
              "Lokasi Pendidikan    1891\n",
              "Name: label, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 74
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "OBBpi3eSLV2q"
      },
      "source": [
        "#Save DataFrame to CSV\n",
        "df_final_post.to_csv(\"capstonetweetpostlabelled.csv\", index=False)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "eJO376tvMBQ1"
      },
      "source": [
        "#Merging Initial and Additional Dataset (Laporan)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "4mmSqorRMGbS",
        "outputId": "d12e02c0-1e91-431c-bd24-1e3a06e17ddd"
      },
      "source": [
        "#Read Initial Dataset\n",
        "df_initial = pd.read_csv(\"capstonetweetlabelled.csv\")\n",
        "df_initial.head()"
      ],
      "execution_count": null,
      "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>index</th>\n",
              "      <th>text</th>\n",
              "      <th>label_laporan</th>\n",
              "      <th>label_post</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>the ironies of the movement are too painfully ...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "      <td>Lokasi Kerja</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>women in kuwait have launched a social media c...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "      <td>Siber</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>triger warning raising awareness of sexual ass...</td>\n",
              "      <td>Penelantaran</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>charges brought against the guy that smacked m...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "      <td>Lokasi Privat</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>and the fourth presenter on th may is hannah b...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "      <td>Lokasi Pendidikan</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   index  ...         label_post\n",
              "0      0  ...       Lokasi Kerja\n",
              "1      1  ...              Siber\n",
              "2      2  ...      Lokasi Privat\n",
              "3      3  ...      Lokasi Privat\n",
              "4      4  ...  Lokasi Pendidikan\n",
              "\n",
              "[5 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 76
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "PmvV6OD7MTdF",
        "outputId": "0cadc4f4-67e5-47d1-f4ce-fad5b71d0940"
      },
      "source": [
        "#Import Additional Laporan Dataset\n",
        "url_laporan = 'https://drive.google.com/file/d/162J0iMJKq4IuDuo9fnXsmdvMpBKdCXVj/view?usp=sharing'\n",
        "file_id_laporan = url_laporan.split('/')[-2]\n",
        "csv_url_laporan = 'https://drive.google.com/uc?id=' + file_id_laporan\n",
        "df_laporan = pd.read_csv(csv_url_laporan)\n",
        "df_laporan.head()"
      ],
      "execution_count": null,
      "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>index</th>\n",
              "      <th>text</th>\n",
              "      <th>label</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>some people have become so dependent on psychi...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>franzen has always been fond of putting his ch...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>guilt and shame add to their psychic state</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>it s a psychic space in which you feel at once...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>some were trampled in the rush and others surv...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   index                                               text             label\n",
              "0      0  some people have become so dependent on psychi...  Kekerasan Psikis\n",
              "1      1  franzen has always been fond of putting his ch...  Kekerasan Psikis\n",
              "2      2         guilt and shame add to their psychic state  Kekerasan Psikis\n",
              "3      3  it s a psychic space in which you feel at once...  Kekerasan Psikis\n",
              "4      4  some were trampled in the rush and others surv...  Kekerasan Psikis"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 77
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "L8jPpK0qMVKt"
      },
      "source": [
        "#Adjust columns between two datasets\n",
        "df_initial.rename(columns={'label_laporan': 'label'}, inplace = True)\n",
        "df_initial.drop(columns=['index', 'label_post'], inplace=True)\n",
        "df_laporan = df_laporan.drop(columns=['index'])"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "r03fXfrYMWnB",
        "outputId": "e175d880-ba09-4da7-9165-f1b55a0adbbb"
      },
      "source": [
        "df_initial.head()"
      ],
      "execution_count": null,
      "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>text</th>\n",
              "      <th>label</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>the ironies of the movement are too painfully ...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>women in kuwait have launched a social media c...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>triger warning raising awareness of sexual ass...</td>\n",
              "      <td>Penelantaran</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>charges brought against the guy that smacked m...</td>\n",
              "      <td>Kekerasan Fisik</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>and the fourth presenter on th may is hannah b...</td>\n",
              "      <td>Kekerasan Lainnya</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                text              label\n",
              "0  the ironies of the movement are too painfully ...   Kekerasan Psikis\n",
              "1  women in kuwait have launched a social media c...   Kekerasan Psikis\n",
              "2  triger warning raising awareness of sexual ass...       Penelantaran\n",
              "3  charges brought against the guy that smacked m...    Kekerasan Fisik\n",
              "4  and the fourth presenter on th may is hannah b...  Kekerasan Lainnya"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 79
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "HFU_jIReMX4o",
        "outputId": "dbe19549-4642-44ad-d09f-ad0c4be654cc"
      },
      "source": [
        "df_laporan.head()"
      ],
      "execution_count": null,
      "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>text</th>\n",
              "      <th>label</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>some people have become so dependent on psychi...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>franzen has always been fond of putting his ch...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>guilt and shame add to their psychic state</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>it s a psychic space in which you feel at once...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>some were trampled in the rush and others surv...</td>\n",
              "      <td>Kekerasan Psikis</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                text             label\n",
              "0  some people have become so dependent on psychi...  Kekerasan Psikis\n",
              "1  franzen has always been fond of putting his ch...  Kekerasan Psikis\n",
              "2         guilt and shame add to their psychic state  Kekerasan Psikis\n",
              "3  it s a psychic space in which you feel at once...  Kekerasan Psikis\n",
              "4  some were trampled in the rush and others surv...  Kekerasan Psikis"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 80
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8M_jMl3HMbEI"
      },
      "source": [
        "#Merging two datasets\n",
        "df_final_laporan = pd.concat([df_initial, df_laporan])"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PnSv7FGJMi51"
      },
      "source": [
        "#Create Index\n",
        "df_final_laporan['index'] = range(0, len(df_final_laporan.index), 1)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "c8YpXz11Mkoj",
        "outputId": "f27287ad-c3c9-4dce-a3e4-24da2a6908b0"
      },
      "source": [
        "df_final_laporan['label'].value_counts()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Kekerasan Lainnya      8313\n",
              "Kekerasan Fisik        1922\n",
              "Kekerasan Seksual      1864\n",
              "Kekerasan Psikis       1800\n",
              "Eksploitasi Seksual    1295\n",
              "Penelantaran           1135\n",
              "Eksploitasi             911\n",
              "Name: label, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 83
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wg6pkVwDMmAI"
      },
      "source": [
        "#Save DataFrame to CSV\n",
        "df_final_laporan.to_csv(\"capstonetweetlaporanlabelled.csv\", index=False)"
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}