dpr_profiling.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# -*- coding: utf-8 -*-\n",
    "\"\"\"\n",
    "Created on Tue Jul 21 23:10:51 2020\n",
    "\n",
    "@author: GhilmanFatih\n",
    "\"\"\"\n",
    "\n",
    "import bs4\n",
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "import pandas as pd\n",
    "from datetime import datetime\n",
    "import numpy as np\n",
    "import pickle\n",
    "\n",
    "pd.set_option('display.max_columns', None)  \n",
    "pd.set_option('max_colwidth', None)\n",
    "pd.set_option('display.max_rows', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = 'http://www.dpr.go.id/'\n",
    "with open('dpr.pickle', 'rb') as f:\n",
    "    ll, m = pickle.load(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_anggota = url+'anggota'\n",
    "agent = {\"User-Agent\":'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36'}\n",
    "response = requests.get(url_anggota, headers=agent)\n",
    "soup = BeautifulSoup(response.content,\"html.parser\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "table = soup.find( \"table\", {\"id\":\"data-anggota2\"} )\n",
    "table_rows = table.find_all('tr')\n",
    "\n",
    "ll = []\n",
    "for tr in table_rows[1:]:\n",
    "    td = tr.find_all('td')\n",
    "    row = [tr.renderContents().decode('UTF-8') for tr in td]\n",
    "    row.append(url + str(tr).split(\"'\")[1])\n",
    "    ll.append(row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "raw = pd.DataFrame(ll, columns=[\"noAnggota\", 'link_foto', \"nama_fraksi_dapil\", \"akd\", 'link_profil'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>noAnggota</th>\n",
       "      <th>link_foto</th>\n",
       "      <th>nama_fraksi_dapil</th>\n",
       "      <th>akd</th>\n",
       "      <th>link_profil</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>567</th>\n",
       "      <td>571</td>\n",
       "      <td>&lt;img class=\"img-responsive\" src=\"/doksigota/photo/1587.jpg\"/&gt;</td>\n",
       "      <td>Hj. ALIYAH MUSTIKA ILHAM, SE&lt;br/&gt;Fraksi Partai Demokrat&lt;br/&gt;SULAWESI SELATAN I</td>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>http://www.dpr.go.id//blog/profil/id/1587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>568</th>\n",
       "      <td>572</td>\n",
       "      <td>&lt;img class=\"img-responsive\" src=\"/doksigota/photo/1830.jpg\"/&gt;</td>\n",
       "      <td>MUHAMMAD DHEVY BIJAK&lt;br/&gt;Fraksi Partai Demokrat&lt;br/&gt;SULAWESI SELATAN III</td>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>http://www.dpr.go.id//blog/profil/id/1830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>569</th>\n",
       "      <td>573</td>\n",
       "      <td>&lt;img class=\"img-responsive\" src=\"/doksigota/photo/1831.jpg\"/&gt;</td>\n",
       "      <td>RUSDA MAHMUD&lt;br/&gt;Fraksi Partai Demokrat&lt;br/&gt;SULAWESI TENGGARA</td>\n",
       "      <td>Komisi VII</td>\n",
       "      <td>http://www.dpr.go.id//blog/profil/id/1831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>574</td>\n",
       "      <td>&lt;img class=\"img-responsive\" src=\"/doksigota/photo/1832.jpg\"/&gt;</td>\n",
       "      <td>DR. H. SUHARDI DUKA, M.M.&lt;br/&gt;Fraksi Partai Demokrat&lt;br/&gt;SULAWESI BARAT</td>\n",
       "      <td>Komisi IV&lt;br/&gt;Badan Anggaran</td>\n",
       "      <td>http://www.dpr.go.id//blog/profil/id/1832</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>571</th>\n",
       "      <td>575</td>\n",
       "      <td>&lt;img class=\"img-responsive\" src=\"/doksigota/photo/1618.jpg\"/&gt;</td>\n",
       "      <td>WILLEM WANDIK, S.Sos&lt;br/&gt;Fraksi Partai Demokrat&lt;br/&gt;PAPUA</td>\n",
       "      <td>Komisi V&lt;br/&gt;Badan Kerja Sama Antar Parlemen</td>\n",
       "      <td>http://www.dpr.go.id//blog/profil/id/1618</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    noAnggota                                                      link_foto  \\\n",
       "567       571  <img class=\"img-responsive\" src=\"/doksigota/photo/1587.jpg\"/>   \n",
       "568       572  <img class=\"img-responsive\" src=\"/doksigota/photo/1830.jpg\"/>   \n",
       "569       573  <img class=\"img-responsive\" src=\"/doksigota/photo/1831.jpg\"/>   \n",
       "570       574  <img class=\"img-responsive\" src=\"/doksigota/photo/1832.jpg\"/>   \n",
       "571       575  <img class=\"img-responsive\" src=\"/doksigota/photo/1618.jpg\"/>   \n",
       "\n",
       "                                                                  nama_fraksi_dapil  \\\n",
       "567  Hj. ALIYAH MUSTIKA ILHAM, SE<br/>Fraksi Partai Demokrat<br/>SULAWESI SELATAN I   \n",
       "568        MUHAMMAD DHEVY BIJAK<br/>Fraksi Partai Demokrat<br/>SULAWESI SELATAN III   \n",
       "569                   RUSDA MAHMUD<br/>Fraksi Partai Demokrat<br/>SULAWESI TENGGARA   \n",
       "570         DR. H. SUHARDI DUKA, M.M.<br/>Fraksi Partai Demokrat<br/>SULAWESI BARAT   \n",
       "571                       WILLEM WANDIK, S.Sos<br/>Fraksi Partai Demokrat<br/>PAPUA   \n",
       "\n",
       "                                              akd  \\\n",
       "567                                     Komisi IX   \n",
       "568                                     Komisi IX   \n",
       "569                                    Komisi VII   \n",
       "570                  Komisi IV<br/>Badan Anggaran   \n",
       "571  Komisi V<br/>Badan Kerja Sama Antar Parlemen   \n",
       "\n",
       "                                   link_profil  \n",
       "567  http://www.dpr.go.id//blog/profil/id/1587  \n",
       "568  http://www.dpr.go.id//blog/profil/id/1830  \n",
       "569  http://www.dpr.go.id//blog/profil/id/1831  \n",
       "570  http://www.dpr.go.id//blog/profil/id/1832  \n",
       "571  http://www.dpr.go.id//blog/profil/id/1618  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# preprocess link untuk foto\n",
    "raw['link_foto'] = url + raw['link_foto'].str.replace(r'(.+)src=\"(.+)\".+', r'\\2')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "raw[\"nama\"] = raw[\"nama_fraksi_dapil\"].str.split(\"<br/>\", n = 3, expand = True)[0]\n",
    "raw[\"fraksi\"] = raw[\"nama_fraksi_dapil\"].str.split(\"<br/>\", n = 3, expand = True)[1]\n",
    "raw[\"dapil\"] = raw[\"nama_fraksi_dapil\"].str.split(\"<br/>\", n = 3, expand = True)[2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "raw['akd_clean'] = [list(item) for item in [set(x) for x in raw['akd'].str.split('<br/>')]]\n",
    "#raw['akd_clean'] = [','.join(map(str, list(item))) for item in [set(x) for x in raw['akd'].str.split('<br/>')]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# drop unnecessary columns\n",
    "raw.drop('akd', axis=1, inplace=True)\n",
    "raw.drop('nama_fraksi_dapil', axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "m = []\n",
    "for i in range(len(raw)):\n",
    "    l = []\n",
    "    print(i)\n",
    "    l.append(raw.noAnggota[i])\n",
    "    l.append(raw.nama[i])\n",
    "    try:\n",
    "        response = requests.get(raw.link_profil[i], headers=agent)\n",
    "        soup = BeautifulSoup(response.content,\"html.parser\")\n",
    "        table = soup.find( \"div\", {\"class\":\"col-md-9 col-md-pull-4 mb30\"} )\n",
    "        table_rows = table.find_all('div')\n",
    "        for tr in table_rows[1:]:\n",
    "            td = tr.find_all('div')\n",
    "            row = [tr.renderContents().decode('UTF-8') for tr in td]\n",
    "            if len(row)>0:\n",
    "                l.append(row)\n",
    "        m.append(list( l[i] for i in [0,1,4,5,6,8,10] ))\n",
    "    except Exception as e:\n",
    "        print(\"Oops!\", e.__class__, \"occurred.\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# with open('dpr.pickle', 'wb') as f:\n",
    "#     pickle.dump([ll, m], f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "detail_profil = pd.DataFrame(m, columns=['noAnggota', 'nama', 'ttl', 'agama', 'pendidikan', 'pekerjaan', 'organisasi'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "detail_profil['ttl'] = [x[1].strip(': ') for x in detail_profil.ttl]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# delete data yang ttl-nya salah\n",
    "detail_profil = detail_profil[-detail_profil.ttl.str.contains('2019')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "detail_profil['kotaLahir'] = detail_profil['ttl'].str.replace(r'(.+) \\/ .+([\\d]{4})', r'\\1')\n",
    "detail_profil['usia'] = datetime.now().year - pd.to_numeric(detail_profil['ttl'].str.replace(r'(.+) \\/ .+([\\d]{4})', r'\\2'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "detail_profil['agama'] = [x[1].strip(': ') for x in detail_profil.agama]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "detail_profil['pendidikan'] = [x[0] for x in detail_profil.pendidikan]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "detail_profil['pekerjaan'] = [x[0] for x in detail_profil.pekerjaan]\n",
    "detail_profil['organisasi'] = [x[0] for x in detail_profil.organisasi]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "profil_raw = raw.merge(detail_profil, how='left', on=['noAnggota', 'nama'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "profil_raw['pendidikan_terakhir'] = profil_raw.pendidikan.str.replace(r'(.+)<li>(.+)<\\/li>.+', r'\\2')\n",
    "profil_raw['pendidikan_terakhir'] = profil_raw.pendidikan_terakhir.str.replace('\\n<div class=\"stitle\">Riwayat Pendidikan</div>\\n<ul class=\"custom-button\">\\n', '').str.strip('<li>\\n')\n",
    "profil_raw['pendidikan_terakhir'] = profil_raw.pendidikan_terakhir.str.split(',', expand=True)[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "profil_raw['pendidikan_terakhir'] = np.where(profil_raw.pendidikan_terakhir.isnull(),'0_no_data',\n",
    "    np.where(profil_raw.pendidikan_terakhir.str.contains('smp', case=False), '1_smp', \n",
    "    np.where(profil_raw.pendidikan_terakhir.str.contains('sma', case=False), '2_sma',\n",
    "    np.where(profil_raw.pendidikan_terakhir.str.contains('diploma', case=False), '3_d3',\n",
    "    np.where(profil_raw.pendidikan_terakhir.str.contains('s1', case=False), '4_s1',\n",
    "    np.where(profil_raw.pendidikan_terakhir.str.contains('s2', case=False), '5_s2',\n",
    "    np.where(profil_raw.pendidikan_terakhir.str.contains('s3', case=False), '6_s3', '0_no_data')))))))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "profil_raw['is_kader'] = np.where(((profil_raw.fraksi.str.contains('amanat nasional', case=False)) & (profil_raw.organisasi.str.contains('PAN') | profil_raw.organisasi.str.contains('amanat nasional', case=False))) |\n",
    "    ((profil_raw.fraksi.str.contains('demokrasi indonesia perjuangan', case=False)) & (profil_raw.organisasi.str.contains('PDIP') | profil_raw.organisasi.str.contains('demokrasi indonesia perjuangan', case=False))) |\n",
    "    ((profil_raw.fraksi.str.contains('demokrat', case=False)) & (profil_raw.organisasi.str.contains('PD') | profil_raw.organisasi.str.contains('demokrat', case=False))) |\n",
    "    ((profil_raw.fraksi.str.contains('gerakan indonesia raya', case=False)) & (profil_raw.organisasi.str.contains('gerindra', case=False) | profil_raw.organisasi.str.contains('gerakan indonesia raya', case=False))) |\n",
    "    ((profil_raw.fraksi.str.contains('golongan karya', case=False)) & (profil_raw.organisasi.str.contains('golkar', case=False) | profil_raw.organisasi.str.contains('golongan karya', case=False))) |\n",
    "    ((profil_raw.fraksi.str.contains('keadilan sejahtera', case=False)) & (profil_raw.organisasi.str.contains('PKS') | profil_raw.organisasi.str.contains('keadilan sejahtera', case=False))) |\n",
    "    ((profil_raw.fraksi.str.contains('kebangkitan bangsa', case=False)) & (profil_raw.organisasi.str.contains('PKB') | profil_raw.organisasi.str.contains('kebangkitan bangsa', case=False))) |\n",
    "    ((profil_raw.fraksi.str.contains('nasdem', case=False)) & (profil_raw.organisasi.str.contains('nasdem', case=False) | profil_raw.organisasi.str.contains('nasional demokrat', case=False))) |\n",
    "    ((profil_raw.fraksi.str.contains('persatuan pembangunan', case=False)) & (profil_raw.organisasi.str.contains('PPP') | profil_raw.organisasi.str.contains('Persatuan Pembangunan', case=False)))\n",
    "    , 'internal', np.where(profil_raw.organisasi.isnull(), 'no_data', 'eksternal'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "profil_raw['is_dewan'] = np.where(\n",
    "    (profil_raw.pekerjaan.str.contains('DPD')) | \n",
    "    (profil_raw.pekerjaan.str.contains('DPR')) | \n",
    "    (profil_raw.pekerjaan.str.contains('MPR')) | \n",
    "    (profil_raw.pekerjaan.str.contains('DPRD')), 'dewan', \n",
    "    np.where(profil_raw.organisasi.isnull(), 'no_data','non-dewan'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "profil_raw['usia_kategori'] = pd.qcut(profil_raw['usia'], q=5, precision=0).astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "c = profil_raw.groupby('fraksi')['noAnggota'].nunique().rank(ascending=False).reset_index(name='rank_partai')\n",
    "profil_raw = profil_raw.merge(c, on='fraksi')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "profil_raw['partai'] = np.where(profil_raw.fraksi.str.contains('amanat nasional', case=False), 'PAN',\n",
    "    np.where(profil_raw.fraksi.str.contains('demokrasi indonesia perjuangan', case=False), 'PDIP', \n",
    "    np.where(profil_raw.fraksi.str.contains('demokrat', case=False), 'PD',  \n",
    "    np.where(profil_raw.fraksi.str.contains('gerakan indonesia raya', case=False), 'Gerindra', \n",
    "    np.where(profil_raw.fraksi.str.contains('golongan karya', case=False), 'Golkar', \n",
    "    np.where(profil_raw.fraksi.str.contains('keadilan sejahtera', case=False), 'PKS',\n",
    "    np.where(profil_raw.fraksi.str.contains('kebangkitan bangsa', case=False), 'PKB', \n",
    "    np.where(profil_raw.fraksi.str.contains('nasdem', case=False), 'Nasdem',\n",
    "    np.where(profil_raw.fraksi.str.contains('persatuan pembangunan', case=False), 'PPP', 'no_data')))))))))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "# exploding akd_clean so we can analyse akd data from array data into long data\n",
    "profil_long = profil_raw.explode('akd_clean')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "profil_raw.to_csv('data_anggota_dpr_2019.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "def univar_analysis(col):\n",
    "    c = profil_raw.groupby([col])[col].size().reset_index(name='cnt')\n",
    "    c['pct'] = round(100 * c['cnt'] / c.cnt.sum(),2)\n",
    "    return c.sort_values('pct', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>partai</th>\n",
       "      <th>cnt</th>\n",
       "      <th>pct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>127</td>\n",
       "      <td>22.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>85</td>\n",
       "      <td>14.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>76</td>\n",
       "      <td>13.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>59</td>\n",
       "      <td>10.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PKB</td>\n",
       "      <td>58</td>\n",
       "      <td>10.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PD</td>\n",
       "      <td>54</td>\n",
       "      <td>9.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>PKS</td>\n",
       "      <td>50</td>\n",
       "      <td>8.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PAN</td>\n",
       "      <td>44</td>\n",
       "      <td>7.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PPP</td>\n",
       "      <td>19</td>\n",
       "      <td>3.32</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     partai  cnt    pct\n",
       "5      PDIP  127  22.20\n",
       "1    Golkar   85  14.86\n",
       "0  Gerindra   76  13.29\n",
       "2    Nasdem   59  10.31\n",
       "6       PKB   58  10.14\n",
       "4        PD   54   9.44\n",
       "7       PKS   50   8.74\n",
       "3       PAN   44   7.69\n",
       "8       PPP   19   3.32"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "univar_analysis('partai')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agama</th>\n",
       "      <th>cnt</th>\n",
       "      <th>pct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Islam</td>\n",
       "      <td>465</td>\n",
       "      <td>83.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kristen</td>\n",
       "      <td>52</td>\n",
       "      <td>9.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Katolik</td>\n",
       "      <td>24</td>\n",
       "      <td>4.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hindu</td>\n",
       "      <td>11</td>\n",
       "      <td>1.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Budha</td>\n",
       "      <td>4</td>\n",
       "      <td>0.72</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     agama  cnt    pct\n",
       "2    Islam  465  83.63\n",
       "4  Kristen   52   9.35\n",
       "3  Katolik   24   4.32\n",
       "1    Hindu   11   1.98\n",
       "0    Budha    4   0.72"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "univar_analysis('agama')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>pendidikan_terakhir</th>\n",
       "      <th>cnt</th>\n",
       "      <th>pct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5_s2</td>\n",
       "      <td>218</td>\n",
       "      <td>38.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4_s1</td>\n",
       "      <td>193</td>\n",
       "      <td>33.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6_s3</td>\n",
       "      <td>84</td>\n",
       "      <td>14.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0_no_data</td>\n",
       "      <td>37</td>\n",
       "      <td>6.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2_sma</td>\n",
       "      <td>32</td>\n",
       "      <td>5.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3_d3</td>\n",
       "      <td>6</td>\n",
       "      <td>1.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1_smp</td>\n",
       "      <td>2</td>\n",
       "      <td>0.35</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  pendidikan_terakhir  cnt    pct\n",
       "5                5_s2  218  38.11\n",
       "4                4_s1  193  33.74\n",
       "6                6_s3   84  14.69\n",
       "0           0_no_data   37   6.47\n",
       "2               2_sma   32   5.59\n",
       "3                3_d3    6   1.05\n",
       "1               1_smp    2   0.35"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "univar_analysis('pendidikan_terakhir')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>is_dewan</th>\n",
       "      <th>cnt</th>\n",
       "      <th>pct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>dewan</td>\n",
       "      <td>288</td>\n",
       "      <td>50.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>non-dewan</td>\n",
       "      <td>268</td>\n",
       "      <td>46.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>no_data</td>\n",
       "      <td>16</td>\n",
       "      <td>2.80</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    is_dewan  cnt    pct\n",
       "0      dewan  288  50.35\n",
       "2  non-dewan  268  46.85\n",
       "1    no_data   16   2.80"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "univar_analysis('is_dewan')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>is_kader</th>\n",
       "      <th>cnt</th>\n",
       "      <th>pct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>eksternal</td>\n",
       "      <td>322</td>\n",
       "      <td>56.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>internal</td>\n",
       "      <td>234</td>\n",
       "      <td>40.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>no_data</td>\n",
       "      <td>16</td>\n",
       "      <td>2.80</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    is_kader  cnt    pct\n",
       "0  eksternal  322  56.29\n",
       "1   internal  234  40.91\n",
       "2    no_data   16   2.80"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "univar_analysis('is_kader')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "mean    51.757194\n",
       "max     81.000000\n",
       "min     24.000000\n",
       "Name: usia, dtype: float64"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "profil_raw['usia'].agg(['mean', 'max', 'min'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>noAnggota</th>\n",
       "      <th>link_foto</th>\n",
       "      <th>link_profil</th>\n",
       "      <th>nama</th>\n",
       "      <th>fraksi</th>\n",
       "      <th>dapil</th>\n",
       "      <th>akd_clean</th>\n",
       "      <th>ttl</th>\n",
       "      <th>agama</th>\n",
       "      <th>pendidikan</th>\n",
       "      <th>pekerjaan</th>\n",
       "      <th>organisasi</th>\n",
       "      <th>kotaLahir</th>\n",
       "      <th>usia</th>\n",
       "      <th>pendidikan_terakhir</th>\n",
       "      <th>is_kader</th>\n",
       "      <th>is_dewan</th>\n",
       "      <th>usia_kategori</th>\n",
       "      <th>rank_partai</th>\n",
       "      <th>partai</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>394</td>\n",
       "      <td>http://www.dpr.go.id//doksigota/photo/1870.jpg</td>\n",
       "      <td>http://www.dpr.go.id//blog/profil/id/1870</td>\n",
       "      <td>HILLARY BRIGITTA LASUT, S.H., LLM</td>\n",
       "      <td>Fraksi Partai NasDem</td>\n",
       "      <td>SULAWESI UTARA</td>\n",
       "      <td>[Komisi I]</td>\n",
       "      <td>Manado / 22 Mei 1996</td>\n",
       "      <td>Katolik</td>\n",
       "      <td>\\n&lt;div class=\"stitle\"&gt;Riwayat Pendidikan&lt;/div&gt;\\n&lt;ul class=\"custom-button\"&gt;\\n&lt;li&gt;SD , KAT 01 ST THERST. Tahun: 2003 - 2009&lt;/li&gt;&lt;li&gt;SMP , MANADO INTERNASIONAL . Tahun: 2009 - 2011&lt;/li&gt;&lt;li&gt;SMA , SMU 1 MANADO . Tahun: 2011 - 2014&lt;/li&gt;&lt;li&gt;S1 ILMU HUKUM, UNIV PELITA HARAPAN. Tahun: 2014 - 2018&lt;/li&gt;&lt;li&gt;S2 , WASHINGTON SCHOLL OF LOW. Tahun: 2018 - 2019&lt;/li&gt; &lt;/ul&gt;\\n</td>\n",
       "      <td>\\n&lt;div class=\"stitle\"&gt;Riwayat Pekerjaan&lt;/div&gt;\\n&lt;ul class=\"custom-button\"&gt;\\n&lt;li&gt;CV MUTIARA SAKTI , Sebagai: OPERASIONAL DIREKTUR . Tahun: 2019 - 2019&lt;/li&gt;&lt;li&gt;LIPPO MALL PURI , Sebagai: ARTA OFFICER . Tahun: 2018 - 2019&lt;/li&gt;&lt;li&gt;AKHH LOW FI, Sebagai: MANGONG . Tahun: 2017 - 2017&lt;/li&gt; &lt;/ul&gt;\\n</td>\n",
       "      <td>\\n&lt;div class=\"stitle\"&gt;Riwayat Organisasi&lt;/div&gt;\\n&lt;ul class=\"custom-button\"&gt;\\n&lt;li&gt;OSIS SMAN 1 MANADO , Sebagai: KETUA . Tahun:  - &lt;/li&gt;&lt;li&gt;PASKIBRAKA KOTA MANADO , Sebagai: . Tahun:  - &lt;/li&gt;&lt;li&gt;HIMA FH.UPH , Sebagai: BENDAHARA . Tahun:  - &lt;/li&gt;&lt;li&gt;C.P NASDEM SULUT , Sebagai: BENDAHARA . Tahun:  - &lt;/li&gt; &lt;/ul&gt;\\n</td>\n",
       "      <td>Manado</td>\n",
       "      <td>24.0</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>internal</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Nasdem</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>501</td>\n",
       "      <td>http://www.dpr.go.id//doksigota/photo/1784.jpg</td>\n",
       "      <td>http://www.dpr.go.id//blog/profil/id/1784</td>\n",
       "      <td>Hj. FARAH PUTERI NAHLIA, B.A, M.Sc.</td>\n",
       "      <td>Fraksi Partai Amanat Nasional</td>\n",
       "      <td>JAWA BARAT IX</td>\n",
       "      <td>[Badan Anggaran, Komisi I]</td>\n",
       "      <td>Semarang / 02 Januari 1996</td>\n",
       "      <td>Islam</td>\n",
       "      <td>\\n&lt;div class=\"stitle\"&gt;Riwayat Pendidikan&lt;/div&gt;\\n&lt;ul class=\"custom-button\"&gt;\\n&lt;li&gt;SD , Al Kamal, Kebon Jeruk. Tahun: 2001 - 2007&lt;/li&gt;&lt;li&gt;SMP , Al Azhar Bumi Serpong Damai, Tanggerang. Tahun: 2007 - 2010&lt;/li&gt;&lt;li&gt;SMA , Sinarmas World Acedemy. Tahun: 2010 - 2012&lt;/li&gt;&lt;li&gt;DIPLOMA , University Foundation, David Game College, London. Tahun: 2013 - 2016&lt;/li&gt;&lt;li&gt;S1 , Royal holloway, University Of London. Tahun: 2013 - 2016&lt;/li&gt;&lt;li&gt;S2 , Royal holloway, University Of London. Tahun: 2016 - 2017&lt;/li&gt; &lt;/ul&gt;\\n</td>\n",
       "      <td>\\n&lt;div class=\"stitle\"&gt;Riwayat Pekerjaan&lt;/div&gt;\\n&lt;ul class=\"custom-button\"&gt;\\n&lt;li&gt;Masa Studio, Sebagai: Komisaris Utama. Tahun: 2018 - 2018&lt;/li&gt;&lt;li&gt;Kementerian Luar Negri, Sebagai: Kementerian Luar Negeri, Direktorat HAM dan Kemanusiaan (Intership) Direktorat Jendral Kerjasama Multilateral. Tahun: 2018 - 2018&lt;/li&gt; &lt;/ul&gt;\\n</td>\n",
       "      <td>\\n&lt;div class=\"stitle\"&gt;Riwayat Organisasi&lt;/div&gt;\\n&lt;ul class=\"custom-button\"&gt;\\n&lt;li&gt;Habitat For Humanity Indonesia, Sebagai: Anggota. Tahun: 2011 - 2012&lt;/li&gt;&lt;li&gt;English Teaching Programme, Sebagai: Relawan. Tahun: 2011 - 2011&lt;/li&gt;&lt;li&gt;OSIS SMP Al Azhar BSD, Sebagai: Wakil Bendahara. Tahun: 2008 - 2009&lt;/li&gt; &lt;/ul&gt;\\n</td>\n",
       "      <td>Semarang</td>\n",
       "      <td>24.0</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>8.0</td>\n",
       "      <td>PAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>524</td>\n",
       "      <td>http://www.dpr.go.id//doksigota/photo/499.jpeg</td>\n",
       "      <td>http://www.dpr.go.id//blog/profil/id/499</td>\n",
       "      <td>H. ABDUL WAHAB DALIMUNTHE, SH</td>\n",
       "      <td>Fraksi Partai Demokrat</td>\n",
       "      <td>SUMATERA UTARA I</td>\n",
       "      <td>[Komisi VII]</td>\n",
       "      <td>Rantau Rapat / 10 Januari 1939</td>\n",
       "      <td>Islam</td>\n",
       "      <td>\\n&lt;div class=\"stitle\"&gt;Riwayat Pendidikan&lt;/div&gt;\\n&lt;ul class=\"custom-button\"&gt;\\n&lt;li&gt;SD , SD Rantau Prapat . Tahun: 1948 - 1954&lt;/li&gt;&lt;li&gt;SMP , SMP Rantau Prapat. Tahun: 1954 - 1957&lt;/li&gt;&lt;li&gt;SMA , SMA Negeri III Medan . Tahun: 1957 - 1960&lt;/li&gt;&lt;li&gt;S1 Hukum, Universitas Sumatera Utara . Tahun: 1960 - 1965&lt;/li&gt; &lt;/ul&gt;\\n</td>\n",
       "      <td>\\n&lt;div class=\"stitle\"&gt;Riwayat Pekerjaan&lt;/div&gt;\\n&lt;ul class=\"custom-button\"&gt;\\n&lt;li&gt;DPR/MPR RI , Sebagai: Anggota FPD DPR RI . Tahun: 2014 - 2019&lt;/li&gt;&lt;li&gt;DPR/MPR RI , Sebagai: Anggota FPD DPR RI . Tahun: 2009 - 2014&lt;/li&gt;&lt;li&gt;DPRD Provinsi Sumatera Utara , Sebagai: Ketua DPRD . Tahun: 2004 - 2009&lt;/li&gt;&lt;li&gt;Pemerintah Provinsi Sumatera Utara , Sebagai: Wakil Gubernur . Tahun: 1999 - 2004&lt;/li&gt;&lt;li&gt;Pemerintah Provinsi Sumatera Utara , Sebagai: Sekretaris Daerah . Tahun: 1996 - 1999&lt;/li&gt;&lt;li&gt;Pemerintah Provinsi Sumatera Utara, Sebagai: Asisten Kesra . Tahun: 1992 - 1995&lt;/li&gt;&lt;li&gt;Pemerintah Provinsi Sumatera Utara , Sebagai: Inspektur . Tahun: 1989 - 1992&lt;/li&gt;&lt;li&gt;Pemerintah Daerah Kabupaten Tapanuli Tengah, Sebagai: Bupati. Tahun: 1984 - 1989&lt;/li&gt;&lt;li&gt;Pemerintah Propinsi Sumatera Utara , Sebagai: Kepala Biro Pemerintahan . Tahun: 1981 - 1983&lt;/li&gt;&lt;li&gt;Pemerintah Daerah Kabupaten Labuhan Batu, Sebagai: Sekretaris Daerah. Tahun: 1967 - 1980&lt;/li&gt; &lt;/ul&gt;\\n</td>\n",
       "      <td>\\n&lt;div class=\"stitle\"&gt;Riwayat Organisasi&lt;/div&gt;\\n&lt;ul class=\"custom-button\"&gt;\\n&lt;li&gt;Partai Demokrat , Sebagai: Anggota . Tahun: 2003 - skrg&lt;/li&gt;&lt;li&gt;Partai Golkar , Sebagai: Anggota . Tahun: 1999 - 2003&lt;/li&gt;&lt;li&gt;Pandu Al-Washliyah , Sebagai: Anggota . Tahun:  - &lt;/li&gt;&lt;li&gt;Nadhlatul Ulama (NU) , Sebagai: Anggota. Tahun:  - &lt;/li&gt;&lt;li&gt;PMII , Sebagai: Anggota. Tahun:  - &lt;/li&gt; &lt;/ul&gt;\\n</td>\n",
       "      <td>Rantau Rapat</td>\n",
       "      <td>81.0</td>\n",
       "      <td>4_s1</td>\n",
       "      <td>internal</td>\n",
       "      <td>dewan</td>\n",
       "      <td>(61.0, 81.0]</td>\n",
       "      <td>6.0</td>\n",
       "      <td>PD</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    noAnggota                                       link_foto  \\\n",
       "390       394  http://www.dpr.go.id//doksigota/photo/1870.jpg   \n",
       "497       501  http://www.dpr.go.id//doksigota/photo/1784.jpg   \n",
       "520       524  http://www.dpr.go.id//doksigota/photo/499.jpeg   \n",
       "\n",
       "                                   link_profil  \\\n",
       "390  http://www.dpr.go.id//blog/profil/id/1870   \n",
       "497  http://www.dpr.go.id//blog/profil/id/1784   \n",
       "520   http://www.dpr.go.id//blog/profil/id/499   \n",
       "\n",
       "                                    nama                         fraksi  \\\n",
       "390    HILLARY BRIGITTA LASUT, S.H., LLM           Fraksi Partai NasDem   \n",
       "497  Hj. FARAH PUTERI NAHLIA, B.A, M.Sc.  Fraksi Partai Amanat Nasional   \n",
       "520        H. ABDUL WAHAB DALIMUNTHE, SH         Fraksi Partai Demokrat   \n",
       "\n",
       "                dapil                   akd_clean  \\\n",
       "390    SULAWESI UTARA                  [Komisi I]   \n",
       "497     JAWA BARAT IX  [Badan Anggaran, Komisi I]   \n",
       "520  SUMATERA UTARA I                [Komisi VII]   \n",
       "\n",
       "                                ttl    agama  \\\n",
       "390            Manado / 22 Mei 1996  Katolik   \n",
       "497      Semarang / 02 Januari 1996    Islam   \n",
       "520  Rantau Rapat / 10 Januari 1939    Islam   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             pendidikan  \\\n",
       "390                                                                                                                                             \\n<div class=\"stitle\">Riwayat Pendidikan</div>\\n<ul class=\"custom-button\">\\n<li>SD , KAT 01 ST THERST. Tahun: 2003 - 2009</li><li>SMP , MANADO INTERNASIONAL . Tahun: 2009 - 2011</li><li>SMA , SMU 1 MANADO . Tahun: 2011 - 2014</li><li>S1 ILMU HUKUM, UNIV PELITA HARAPAN. Tahun: 2014 - 2018</li><li>S2 , WASHINGTON SCHOLL OF LOW. Tahun: 2018 - 2019</li> </ul>\\n   \n",
       "497  \\n<div class=\"stitle\">Riwayat Pendidikan</div>\\n<ul class=\"custom-button\">\\n<li>SD , Al Kamal, Kebon Jeruk. Tahun: 2001 - 2007</li><li>SMP , Al Azhar Bumi Serpong Damai, Tanggerang. Tahun: 2007 - 2010</li><li>SMA , Sinarmas World Acedemy. Tahun: 2010 - 2012</li><li>DIPLOMA , University Foundation, David Game College, London. Tahun: 2013 - 2016</li><li>S1 , Royal holloway, University Of London. Tahun: 2013 - 2016</li><li>S2 , Royal holloway, University Of London. Tahun: 2016 - 2017</li> </ul>\\n   \n",
       "520                                                                                                                                                                                               \\n<div class=\"stitle\">Riwayat Pendidikan</div>\\n<ul class=\"custom-button\">\\n<li>SD , SD Rantau Prapat . Tahun: 1948 - 1954</li><li>SMP , SMP Rantau Prapat. Tahun: 1954 - 1957</li><li>SMA , SMA Negeri III Medan . Tahun: 1957 - 1960</li><li>S1 Hukum, Universitas Sumatera Utara . Tahun: 1960 - 1965</li> </ul>\\n   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             pekerjaan  \\\n",
       "390                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  \\n<div class=\"stitle\">Riwayat Pekerjaan</div>\\n<ul class=\"custom-button\">\\n<li>CV MUTIARA SAKTI , Sebagai: OPERASIONAL DIREKTUR . Tahun: 2019 - 2019</li><li>LIPPO MALL PURI , Sebagai: ARTA OFFICER . Tahun: 2018 - 2019</li><li>AKHH LOW FI, Sebagai: MANGONG . Tahun: 2017 - 2017</li> </ul>\\n   \n",
       "497                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   \\n<div class=\"stitle\">Riwayat Pekerjaan</div>\\n<ul class=\"custom-button\">\\n<li>Masa Studio, Sebagai: Komisaris Utama. Tahun: 2018 - 2018</li><li>Kementerian Luar Negri, Sebagai: Kementerian Luar Negeri, Direktorat HAM dan Kemanusiaan (Intership) Direktorat Jendral Kerjasama Multilateral. Tahun: 2018 - 2018</li> </ul>\\n   \n",
       "520  \\n<div class=\"stitle\">Riwayat Pekerjaan</div>\\n<ul class=\"custom-button\">\\n<li>DPR/MPR RI , Sebagai: Anggota FPD DPR RI . Tahun: 2014 - 2019</li><li>DPR/MPR RI , Sebagai: Anggota FPD DPR RI . Tahun: 2009 - 2014</li><li>DPRD Provinsi Sumatera Utara , Sebagai: Ketua DPRD . Tahun: 2004 - 2009</li><li>Pemerintah Provinsi Sumatera Utara , Sebagai: Wakil Gubernur . Tahun: 1999 - 2004</li><li>Pemerintah Provinsi Sumatera Utara , Sebagai: Sekretaris Daerah . Tahun: 1996 - 1999</li><li>Pemerintah Provinsi Sumatera Utara, Sebagai: Asisten Kesra . Tahun: 1992 - 1995</li><li>Pemerintah Provinsi Sumatera Utara , Sebagai: Inspektur . Tahun: 1989 - 1992</li><li>Pemerintah Daerah Kabupaten Tapanuli Tengah, Sebagai: Bupati. Tahun: 1984 - 1989</li><li>Pemerintah Propinsi Sumatera Utara , Sebagai: Kepala Biro Pemerintahan . Tahun: 1981 - 1983</li><li>Pemerintah Daerah Kabupaten Labuhan Batu, Sebagai: Sekretaris Daerah. Tahun: 1967 - 1980</li> </ul>\\n   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                organisasi  \\\n",
       "390                                                                  \\n<div class=\"stitle\">Riwayat Organisasi</div>\\n<ul class=\"custom-button\">\\n<li>OSIS SMAN 1 MANADO , Sebagai: KETUA . Tahun:  - </li><li>PASKIBRAKA KOTA MANADO , Sebagai: . Tahun:  - </li><li>HIMA FH.UPH , Sebagai: BENDAHARA . Tahun:  - </li><li>C.P NASDEM SULUT , Sebagai: BENDAHARA . Tahun:  - </li> </ul>\\n   \n",
       "497                                                                 \\n<div class=\"stitle\">Riwayat Organisasi</div>\\n<ul class=\"custom-button\">\\n<li>Habitat For Humanity Indonesia, Sebagai: Anggota. Tahun: 2011 - 2012</li><li>English Teaching Programme, Sebagai: Relawan. Tahun: 2011 - 2011</li><li>OSIS SMP Al Azhar BSD, Sebagai: Wakil Bendahara. Tahun: 2008 - 2009</li> </ul>\\n   \n",
       "520  \\n<div class=\"stitle\">Riwayat Organisasi</div>\\n<ul class=\"custom-button\">\\n<li>Partai Demokrat , Sebagai: Anggota . Tahun: 2003 - skrg</li><li>Partai Golkar , Sebagai: Anggota . Tahun: 1999 - 2003</li><li>Pandu Al-Washliyah , Sebagai: Anggota . Tahun:  - </li><li>Nadhlatul Ulama (NU) , Sebagai: Anggota. Tahun:  - </li><li>PMII , Sebagai: Anggota. Tahun:  - </li> </ul>\\n   \n",
       "\n",
       "        kotaLahir  usia pendidikan_terakhir   is_kader   is_dewan  \\\n",
       "390        Manado  24.0                5_s2   internal  non-dewan   \n",
       "497      Semarang  24.0                5_s2  eksternal  non-dewan   \n",
       "520  Rantau Rapat  81.0                4_s1   internal      dewan   \n",
       "\n",
       "    usia_kategori  rank_partai  partai  \n",
       "390  (23.0, 44.0]          4.0  Nasdem  \n",
       "497  (23.0, 44.0]          8.0     PAN  \n",
       "520  (61.0, 81.0]          6.0      PD  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "profil_raw[(profil_raw.usia==24) | (profil_raw.usia==81)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>akd_clean</th>\n",
       "      <th>cnt</th>\n",
       "      <th>pct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Badan Anggaran</td>\n",
       "      <td>99</td>\n",
       "      <td>10.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Badan Legislasi</td>\n",
       "      <td>76</td>\n",
       "      <td>8.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Panitia Khusus</td>\n",
       "      <td>61</td>\n",
       "      <td>6.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Komisi IV</td>\n",
       "      <td>55</td>\n",
       "      <td>5.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Komisi V</td>\n",
       "      <td>53</td>\n",
       "      <td>5.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Badan Kerja Sama Antar Parlemen</td>\n",
       "      <td>53</td>\n",
       "      <td>5.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Komisi I</td>\n",
       "      <td>53</td>\n",
       "      <td>5.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Komisi VI</td>\n",
       "      <td>53</td>\n",
       "      <td>5.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Komisi X</td>\n",
       "      <td>52</td>\n",
       "      <td>5.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Komisi VIII</td>\n",
       "      <td>52</td>\n",
       "      <td>5.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Komisi III</td>\n",
       "      <td>52</td>\n",
       "      <td>5.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>51</td>\n",
       "      <td>5.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Komisi VII</td>\n",
       "      <td>51</td>\n",
       "      <td>5.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Komisi XI</td>\n",
       "      <td>51</td>\n",
       "      <td>5.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Badan Musyawarah</td>\n",
       "      <td>48</td>\n",
       "      <td>5.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Komisi II</td>\n",
       "      <td>44</td>\n",
       "      <td>4.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Badan Urusan Rumah Tangga</td>\n",
       "      <td>19</td>\n",
       "      <td>2.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Badan Akuntabilitas Keuangan Negara</td>\n",
       "      <td>9</td>\n",
       "      <td>0.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-</td>\n",
       "      <td>5</td>\n",
       "      <td>0.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Mahkamah Kehormatan Dewan</td>\n",
       "      <td>5</td>\n",
       "      <td>0.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Pimpinan</td>\n",
       "      <td>5</td>\n",
       "      <td>0.53</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              akd_clean  cnt    pct\n",
       "2                        Badan Anggaran   99  10.45\n",
       "4                       Badan Legislasi   76   8.03\n",
       "19                       Panitia Khusus   61   6.44\n",
       "10                            Komisi IV   55   5.81\n",
       "12                             Komisi V   53   5.60\n",
       "3       Badan Kerja Sama Antar Parlemen   53   5.60\n",
       "7                              Komisi I   53   5.60\n",
       "13                            Komisi VI   53   5.60\n",
       "16                             Komisi X   52   5.49\n",
       "15                          Komisi VIII   52   5.49\n",
       "9                            Komisi III   52   5.49\n",
       "11                            Komisi IX   51   5.39\n",
       "14                           Komisi VII   51   5.39\n",
       "17                            Komisi XI   51   5.39\n",
       "5                      Badan Musyawarah   48   5.07\n",
       "8                             Komisi II   44   4.65\n",
       "6             Badan Urusan Rumah Tangga   19   2.01\n",
       "1   Badan Akuntabilitas Keuangan Negara    9   0.95\n",
       "0                                     -    5   0.53\n",
       "18            Mahkamah Kehormatan Dewan    5   0.53\n",
       "20                             Pimpinan    5   0.53"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c = profil_long.groupby(['akd_clean'])['noAnggota'].nunique().reset_index(name='cnt')\n",
    "c['pct'] = round(100 * c['cnt'] / c.cnt.sum(),2)\n",
    "c.sort_values('pct', ascending=[False])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Pendekatan pada beberapa Kolom:\n",
    "Ada beberapa kolom yang kita derive berdasarkan kolom yang ada di website DPR. Berikut kolom-kolom tersebut beserta tujuannya:\n",
    "* is_dewan: pendekatan untuk mengetahui apakah seorang anggota DPR sebelumnya pernah menjabat menjadi anggota dewan, baik di DPR, MPR, DPD maupun di DPRD. Data ini derive dari kolom pekerjaan dari masing-masing anggota DPR.\n",
    "* pendidikan_terakhir: pendekatan yg diambil berdasarkan biodata pendidikan yang ada di website DPR dari masing-masing anggota. Selanjutnya diambil pendidikan terakhir yang ada di kolom pendidikan.\n",
    "* is_kader: diderive dari kolom organisasi. Tujuannya untuk mengetahui apakah anggota DPR dari suatu partai sebelumnya sudah pernah memegang jabatan dalam partai.\n",
    "* usia_kategori: usia per tahun 2020 (saat script ini di run). Selanjutnya dibuat binning berdasarkan quintile (5 bin sama besar) agar sebaran usia tidak lagi numerical."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Univariate Findings:\n",
    "1. Partai tua nasionalis masih menjadi favorit. PDIP di urutan pertama diikuti golkar di urutan kedua. Partai islamis anjlok menempati posisi 3 terbawah.\n",
    "2. 5 agama terbesar di Indonesia memiliki wakil di DPR, dengan jumlah proporsi yang hampir mirip (https://id.wikipedia.org/wiki/Agama_di_Indonesia)\n",
    "3. Lebih dari 50% anggota DPR berpendidikan minimal S2.\n",
    "4. Lebih dari 50% anggota DPR saat ini memiliki pengalaman menjabat sebagai anggota dewan sebelumnya.\n",
    "5. Mayoritas anggota DPR tidak pernah memegang jabatan partai di partai yang mengusung mereka.\n",
    "6. Rata-rata usia anggota DPR ialah 51.75 tahun. Anggota termuda berumur 24 tahun dari partai Nasdem dapil SULUT dan anggota tertua berumur 81 tahun dari partai Demokrat dapil SUMUT 1. \n",
    "7. Seorang anggota DPR dapat ditempatkan pada satu atau lebih Alat Kelengkapan Dewan (AKD). Badan Anggaran dan Badan Legislasi menjadi badan yang paling vital. Sebaliknya, komisi 2 menjadi komisi yang tidak difavoritkan. (http://www.dpr.go.id/akd/komisi)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "def bivariate_analysis(col, sortcol = 'p(B|A)'):\n",
    "    c = profil_long.groupby(['partai','rank_partai', col])['noAnggota'].nunique().reset_index(name='cnt')\n",
    "    c['p(A|B)'] = c['cnt'] / c.groupby('partai')['cnt'].transform('sum')\n",
    "    c['p(B|A)'] =  (c['cnt'] / c.groupby(col)['cnt'].transform('sum'))\n",
    "    return c.sort_values(['rank_partai', sortcol], ascending=[True, False])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>partai</th>\n",
       "      <th>rank_partai</th>\n",
       "      <th>akd_clean</th>\n",
       "      <th>cnt</th>\n",
       "      <th>p(A|B)</th>\n",
       "      <th>p(B|A)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Badan Anggaran</td>\n",
       "      <td>21</td>\n",
       "      <td>0.108247</td>\n",
       "      <td>0.212121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Badan Legislasi</td>\n",
       "      <td>15</td>\n",
       "      <td>0.077320</td>\n",
       "      <td>0.197368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Badan Kerja Sama Antar Parlemen</td>\n",
       "      <td>12</td>\n",
       "      <td>0.061856</td>\n",
       "      <td>0.226415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Komisi III</td>\n",
       "      <td>12</td>\n",
       "      <td>0.061856</td>\n",
       "      <td>0.230769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Komisi IV</td>\n",
       "      <td>12</td>\n",
       "      <td>0.061856</td>\n",
       "      <td>0.218182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Komisi V</td>\n",
       "      <td>12</td>\n",
       "      <td>0.061856</td>\n",
       "      <td>0.226415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Komisi VI</td>\n",
       "      <td>12</td>\n",
       "      <td>0.061856</td>\n",
       "      <td>0.226415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Komisi VII</td>\n",
       "      <td>12</td>\n",
       "      <td>0.061856</td>\n",
       "      <td>0.235294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Komisi VIII</td>\n",
       "      <td>12</td>\n",
       "      <td>0.061856</td>\n",
       "      <td>0.230769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Badan Musyawarah</td>\n",
       "      <td>11</td>\n",
       "      <td>0.056701</td>\n",
       "      <td>0.229167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Komisi I</td>\n",
       "      <td>11</td>\n",
       "      <td>0.056701</td>\n",
       "      <td>0.207547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Komisi II</td>\n",
       "      <td>11</td>\n",
       "      <td>0.056701</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>11</td>\n",
       "      <td>0.056701</td>\n",
       "      <td>0.215686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Komisi X</td>\n",
       "      <td>11</td>\n",
       "      <td>0.056701</td>\n",
       "      <td>0.211538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Komisi XI</td>\n",
       "      <td>10</td>\n",
       "      <td>0.051546</td>\n",
       "      <td>0.196078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Badan Urusan Rumah Tangga</td>\n",
       "      <td>4</td>\n",
       "      <td>0.020619</td>\n",
       "      <td>0.210526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Panitia Khusus</td>\n",
       "      <td>2</td>\n",
       "      <td>0.010309</td>\n",
       "      <td>0.032787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Badan Akuntabilitas Keuangan Negara</td>\n",
       "      <td>1</td>\n",
       "      <td>0.005155</td>\n",
       "      <td>0.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Mahkamah Kehormatan Dewan</td>\n",
       "      <td>1</td>\n",
       "      <td>0.005155</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Pimpinan</td>\n",
       "      <td>1</td>\n",
       "      <td>0.005155</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Badan Anggaran</td>\n",
       "      <td>15</td>\n",
       "      <td>0.107914</td>\n",
       "      <td>0.151515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Badan Legislasi</td>\n",
       "      <td>12</td>\n",
       "      <td>0.086331</td>\n",
       "      <td>0.157895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Badan Musyawarah</td>\n",
       "      <td>9</td>\n",
       "      <td>0.064748</td>\n",
       "      <td>0.187500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Badan Kerja Sama Antar Parlemen</td>\n",
       "      <td>8</td>\n",
       "      <td>0.057554</td>\n",
       "      <td>0.150943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Komisi I</td>\n",
       "      <td>8</td>\n",
       "      <td>0.057554</td>\n",
       "      <td>0.150943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Komisi III</td>\n",
       "      <td>8</td>\n",
       "      <td>0.057554</td>\n",
       "      <td>0.153846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Komisi IV</td>\n",
       "      <td>8</td>\n",
       "      <td>0.057554</td>\n",
       "      <td>0.145455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Komisi V</td>\n",
       "      <td>8</td>\n",
       "      <td>0.057554</td>\n",
       "      <td>0.150943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Komisi VI</td>\n",
       "      <td>8</td>\n",
       "      <td>0.057554</td>\n",
       "      <td>0.150943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Komisi VII</td>\n",
       "      <td>8</td>\n",
       "      <td>0.057554</td>\n",
       "      <td>0.156863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Komisi VIII</td>\n",
       "      <td>8</td>\n",
       "      <td>0.057554</td>\n",
       "      <td>0.153846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Komisi XI</td>\n",
       "      <td>8</td>\n",
       "      <td>0.057554</td>\n",
       "      <td>0.156863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Komisi II</td>\n",
       "      <td>7</td>\n",
       "      <td>0.050360</td>\n",
       "      <td>0.159091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>7</td>\n",
       "      <td>0.050360</td>\n",
       "      <td>0.137255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Komisi X</td>\n",
       "      <td>7</td>\n",
       "      <td>0.050360</td>\n",
       "      <td>0.134615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Badan Urusan Rumah Tangga</td>\n",
       "      <td>4</td>\n",
       "      <td>0.028777</td>\n",
       "      <td>0.210526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Mahkamah Kehormatan Dewan</td>\n",
       "      <td>2</td>\n",
       "      <td>0.014388</td>\n",
       "      <td>0.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Panitia Khusus</td>\n",
       "      <td>2</td>\n",
       "      <td>0.014388</td>\n",
       "      <td>0.032787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Badan Akuntabilitas Keuangan Negara</td>\n",
       "      <td>1</td>\n",
       "      <td>0.007194</td>\n",
       "      <td>0.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Pimpinan</td>\n",
       "      <td>1</td>\n",
       "      <td>0.007194</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Badan Anggaran</td>\n",
       "      <td>14</td>\n",
       "      <td>0.114754</td>\n",
       "      <td>0.141414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Badan Legislasi</td>\n",
       "      <td>10</td>\n",
       "      <td>0.081967</td>\n",
       "      <td>0.131579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Komisi III</td>\n",
       "      <td>8</td>\n",
       "      <td>0.065574</td>\n",
       "      <td>0.153846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Badan Kerja Sama Antar Parlemen</td>\n",
       "      <td>7</td>\n",
       "      <td>0.057377</td>\n",
       "      <td>0.132075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Badan Musyawarah</td>\n",
       "      <td>7</td>\n",
       "      <td>0.057377</td>\n",
       "      <td>0.145833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Komisi I</td>\n",
       "      <td>7</td>\n",
       "      <td>0.057377</td>\n",
       "      <td>0.132075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Komisi IV</td>\n",
       "      <td>7</td>\n",
       "      <td>0.057377</td>\n",
       "      <td>0.127273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>7</td>\n",
       "      <td>0.057377</td>\n",
       "      <td>0.137255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Komisi V</td>\n",
       "      <td>7</td>\n",
       "      <td>0.057377</td>\n",
       "      <td>0.132075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Komisi VII</td>\n",
       "      <td>7</td>\n",
       "      <td>0.057377</td>\n",
       "      <td>0.137255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Komisi VIII</td>\n",
       "      <td>7</td>\n",
       "      <td>0.057377</td>\n",
       "      <td>0.134615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Komisi X</td>\n",
       "      <td>7</td>\n",
       "      <td>0.057377</td>\n",
       "      <td>0.134615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Komisi XI</td>\n",
       "      <td>7</td>\n",
       "      <td>0.057377</td>\n",
       "      <td>0.137255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Komisi VI</td>\n",
       "      <td>6</td>\n",
       "      <td>0.049180</td>\n",
       "      <td>0.113208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Komisi II</td>\n",
       "      <td>5</td>\n",
       "      <td>0.040984</td>\n",
       "      <td>0.113636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Panitia Khusus</td>\n",
       "      <td>3</td>\n",
       "      <td>0.024590</td>\n",
       "      <td>0.049180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>0.016393</td>\n",
       "      <td>0.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Badan Urusan Rumah Tangga</td>\n",
       "      <td>2</td>\n",
       "      <td>0.016393</td>\n",
       "      <td>0.105263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Badan Akuntabilitas Keuangan Negara</td>\n",
       "      <td>1</td>\n",
       "      <td>0.008197</td>\n",
       "      <td>0.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Pimpinan</td>\n",
       "      <td>1</td>\n",
       "      <td>0.008197</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Badan Anggaran</td>\n",
       "      <td>10</td>\n",
       "      <td>0.111111</td>\n",
       "      <td>0.101010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Badan Legislasi</td>\n",
       "      <td>8</td>\n",
       "      <td>0.088889</td>\n",
       "      <td>0.105263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Komisi IV</td>\n",
       "      <td>6</td>\n",
       "      <td>0.066667</td>\n",
       "      <td>0.109091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Komisi XI</td>\n",
       "      <td>6</td>\n",
       "      <td>0.066667</td>\n",
       "      <td>0.117647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Badan Kerja Sama Antar Parlemen</td>\n",
       "      <td>5</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Badan Musyawarah</td>\n",
       "      <td>5</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.104167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Komisi I</td>\n",
       "      <td>5</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Komisi II</td>\n",
       "      <td>5</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.113636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Komisi III</td>\n",
       "      <td>5</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.096154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>5</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.098039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Komisi V</td>\n",
       "      <td>5</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Komisi VI</td>\n",
       "      <td>5</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Komisi VII</td>\n",
       "      <td>5</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.098039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Komisi VIII</td>\n",
       "      <td>5</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.096154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Komisi X</td>\n",
       "      <td>5</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.096154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>0.022222</td>\n",
       "      <td>0.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Badan Akuntabilitas Keuangan Negara</td>\n",
       "      <td>1</td>\n",
       "      <td>0.011111</td>\n",
       "      <td>0.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Panitia Khusus</td>\n",
       "      <td>1</td>\n",
       "      <td>0.011111</td>\n",
       "      <td>0.016393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Pimpinan</td>\n",
       "      <td>1</td>\n",
       "      <td>0.011111</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Panitia Khusus</td>\n",
       "      <td>49</td>\n",
       "      <td>0.357664</td>\n",
       "      <td>0.803279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Badan Anggaran</td>\n",
       "      <td>10</td>\n",
       "      <td>0.072993</td>\n",
       "      <td>0.101010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Badan Legislasi</td>\n",
       "      <td>8</td>\n",
       "      <td>0.058394</td>\n",
       "      <td>0.105263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Komisi I</td>\n",
       "      <td>6</td>\n",
       "      <td>0.043796</td>\n",
       "      <td>0.113208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Komisi IV</td>\n",
       "      <td>6</td>\n",
       "      <td>0.043796</td>\n",
       "      <td>0.109091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>6</td>\n",
       "      <td>0.043796</td>\n",
       "      <td>0.117647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Komisi V</td>\n",
       "      <td>6</td>\n",
       "      <td>0.043796</td>\n",
       "      <td>0.113208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Komisi VI</td>\n",
       "      <td>6</td>\n",
       "      <td>0.043796</td>\n",
       "      <td>0.113208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Komisi X</td>\n",
       "      <td>6</td>\n",
       "      <td>0.043796</td>\n",
       "      <td>0.115385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Badan Kerja Sama Antar Parlemen</td>\n",
       "      <td>5</td>\n",
       "      <td>0.036496</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Komisi III</td>\n",
       "      <td>5</td>\n",
       "      <td>0.036496</td>\n",
       "      <td>0.096154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Komisi VII</td>\n",
       "      <td>5</td>\n",
       "      <td>0.036496</td>\n",
       "      <td>0.098039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Komisi XI</td>\n",
       "      <td>5</td>\n",
       "      <td>0.036496</td>\n",
       "      <td>0.098039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Komisi VIII</td>\n",
       "      <td>4</td>\n",
       "      <td>0.029197</td>\n",
       "      <td>0.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Badan Musyawarah</td>\n",
       "      <td>3</td>\n",
       "      <td>0.021898</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Komisi II</td>\n",
       "      <td>3</td>\n",
       "      <td>0.021898</td>\n",
       "      <td>0.068182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Badan Urusan Rumah Tangga</td>\n",
       "      <td>2</td>\n",
       "      <td>0.014599</td>\n",
       "      <td>0.105263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Badan Akuntabilitas Keuangan Negara</td>\n",
       "      <td>1</td>\n",
       "      <td>0.007299</td>\n",
       "      <td>0.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Pimpinan</td>\n",
       "      <td>1</td>\n",
       "      <td>0.007299</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Badan Anggaran</td>\n",
       "      <td>9</td>\n",
       "      <td>0.108434</td>\n",
       "      <td>0.090909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Badan Legislasi</td>\n",
       "      <td>7</td>\n",
       "      <td>0.084337</td>\n",
       "      <td>0.092105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Badan Kerja Sama Antar Parlemen</td>\n",
       "      <td>5</td>\n",
       "      <td>0.060241</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Komisi I</td>\n",
       "      <td>5</td>\n",
       "      <td>0.060241</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Komisi III</td>\n",
       "      <td>5</td>\n",
       "      <td>0.060241</td>\n",
       "      <td>0.096154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Komisi IV</td>\n",
       "      <td>5</td>\n",
       "      <td>0.060241</td>\n",
       "      <td>0.090909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>5</td>\n",
       "      <td>0.060241</td>\n",
       "      <td>0.098039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Komisi V</td>\n",
       "      <td>5</td>\n",
       "      <td>0.060241</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Komisi VI</td>\n",
       "      <td>5</td>\n",
       "      <td>0.060241</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Komisi VII</td>\n",
       "      <td>5</td>\n",
       "      <td>0.060241</td>\n",
       "      <td>0.098039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Komisi VIII</td>\n",
       "      <td>5</td>\n",
       "      <td>0.060241</td>\n",
       "      <td>0.096154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Komisi X</td>\n",
       "      <td>5</td>\n",
       "      <td>0.060241</td>\n",
       "      <td>0.096154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Komisi XI</td>\n",
       "      <td>5</td>\n",
       "      <td>0.060241</td>\n",
       "      <td>0.098039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Badan Musyawarah</td>\n",
       "      <td>4</td>\n",
       "      <td>0.048193</td>\n",
       "      <td>0.083333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Komisi II</td>\n",
       "      <td>3</td>\n",
       "      <td>0.036145</td>\n",
       "      <td>0.068182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Badan Urusan Rumah Tangga</td>\n",
       "      <td>2</td>\n",
       "      <td>0.024096</td>\n",
       "      <td>0.105263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>0.012048</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Badan Akuntabilitas Keuangan Negara</td>\n",
       "      <td>1</td>\n",
       "      <td>0.012048</td>\n",
       "      <td>0.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Panitia Khusus</td>\n",
       "      <td>1</td>\n",
       "      <td>0.012048</td>\n",
       "      <td>0.016393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Badan Anggaran</td>\n",
       "      <td>9</td>\n",
       "      <td>0.115385</td>\n",
       "      <td>0.090909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Badan Legislasi</td>\n",
       "      <td>7</td>\n",
       "      <td>0.089744</td>\n",
       "      <td>0.092105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Badan Kerja Sama Antar Parlemen</td>\n",
       "      <td>5</td>\n",
       "      <td>0.064103</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Komisi I</td>\n",
       "      <td>5</td>\n",
       "      <td>0.064103</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Komisi IV</td>\n",
       "      <td>5</td>\n",
       "      <td>0.064103</td>\n",
       "      <td>0.090909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>5</td>\n",
       "      <td>0.064103</td>\n",
       "      <td>0.098039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Komisi VI</td>\n",
       "      <td>5</td>\n",
       "      <td>0.064103</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Komisi VIII</td>\n",
       "      <td>5</td>\n",
       "      <td>0.064103</td>\n",
       "      <td>0.096154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Komisi X</td>\n",
       "      <td>5</td>\n",
       "      <td>0.064103</td>\n",
       "      <td>0.096154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Komisi II</td>\n",
       "      <td>4</td>\n",
       "      <td>0.051282</td>\n",
       "      <td>0.090909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Komisi III</td>\n",
       "      <td>4</td>\n",
       "      <td>0.051282</td>\n",
       "      <td>0.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Komisi V</td>\n",
       "      <td>4</td>\n",
       "      <td>0.051282</td>\n",
       "      <td>0.075472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Komisi VII</td>\n",
       "      <td>4</td>\n",
       "      <td>0.051282</td>\n",
       "      <td>0.078431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Komisi XI</td>\n",
       "      <td>4</td>\n",
       "      <td>0.051282</td>\n",
       "      <td>0.078431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Badan Musyawarah</td>\n",
       "      <td>3</td>\n",
       "      <td>0.038462</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Badan Urusan Rumah Tangga</td>\n",
       "      <td>2</td>\n",
       "      <td>0.025641</td>\n",
       "      <td>0.105263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Badan Akuntabilitas Keuangan Negara</td>\n",
       "      <td>1</td>\n",
       "      <td>0.012821</td>\n",
       "      <td>0.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Panitia Khusus</td>\n",
       "      <td>1</td>\n",
       "      <td>0.012821</td>\n",
       "      <td>0.016393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Badan Anggaran</td>\n",
       "      <td>8</td>\n",
       "      <td>0.112676</td>\n",
       "      <td>0.080808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Badan Legislasi</td>\n",
       "      <td>6</td>\n",
       "      <td>0.084507</td>\n",
       "      <td>0.078947</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Badan Kerja Sama Antar Parlemen</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.075472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Badan Musyawarah</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.083333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Komisi I</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.075472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Komisi II</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.090909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Komisi III</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Komisi IV</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.072727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.078431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Komisi V</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.075472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Komisi VI</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.075472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Komisi VII</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.078431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Komisi VIII</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Komisi X</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Komisi XI</td>\n",
       "      <td>4</td>\n",
       "      <td>0.056338</td>\n",
       "      <td>0.078431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Badan Urusan Rumah Tangga</td>\n",
       "      <td>2</td>\n",
       "      <td>0.028169</td>\n",
       "      <td>0.105263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Badan Akuntabilitas Keuangan Negara</td>\n",
       "      <td>1</td>\n",
       "      <td>0.014085</td>\n",
       "      <td>0.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Mahkamah Kehormatan Dewan</td>\n",
       "      <td>1</td>\n",
       "      <td>0.014085</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Panitia Khusus</td>\n",
       "      <td>1</td>\n",
       "      <td>0.014085</td>\n",
       "      <td>0.016393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Badan Anggaran</td>\n",
       "      <td>3</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.030303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Badan Legislasi</td>\n",
       "      <td>3</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.039474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Badan Kerja Sama Antar Parlemen</td>\n",
       "      <td>2</td>\n",
       "      <td>0.060606</td>\n",
       "      <td>0.037736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Badan Musyawarah</td>\n",
       "      <td>2</td>\n",
       "      <td>0.060606</td>\n",
       "      <td>0.041667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Komisi I</td>\n",
       "      <td>2</td>\n",
       "      <td>0.060606</td>\n",
       "      <td>0.037736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Komisi II</td>\n",
       "      <td>2</td>\n",
       "      <td>0.060606</td>\n",
       "      <td>0.045455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Komisi IV</td>\n",
       "      <td>2</td>\n",
       "      <td>0.060606</td>\n",
       "      <td>0.036364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Komisi V</td>\n",
       "      <td>2</td>\n",
       "      <td>0.060606</td>\n",
       "      <td>0.037736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Komisi VI</td>\n",
       "      <td>2</td>\n",
       "      <td>0.060606</td>\n",
       "      <td>0.037736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Komisi VIII</td>\n",
       "      <td>2</td>\n",
       "      <td>0.060606</td>\n",
       "      <td>0.038462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Komisi X</td>\n",
       "      <td>2</td>\n",
       "      <td>0.060606</td>\n",
       "      <td>0.038462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Komisi XI</td>\n",
       "      <td>2</td>\n",
       "      <td>0.060606</td>\n",
       "      <td>0.039216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Badan Akuntabilitas Keuangan Negara</td>\n",
       "      <td>1</td>\n",
       "      <td>0.030303</td>\n",
       "      <td>0.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Badan Urusan Rumah Tangga</td>\n",
       "      <td>1</td>\n",
       "      <td>0.030303</td>\n",
       "      <td>0.052632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Komisi III</td>\n",
       "      <td>1</td>\n",
       "      <td>0.030303</td>\n",
       "      <td>0.019231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Komisi IX</td>\n",
       "      <td>1</td>\n",
       "      <td>0.030303</td>\n",
       "      <td>0.019608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Komisi VII</td>\n",
       "      <td>1</td>\n",
       "      <td>0.030303</td>\n",
       "      <td>0.019608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Mahkamah Kehormatan Dewan</td>\n",
       "      <td>1</td>\n",
       "      <td>0.030303</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Panitia Khusus</td>\n",
       "      <td>1</td>\n",
       "      <td>0.030303</td>\n",
       "      <td>0.016393</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       partai  rank_partai                            akd_clean  cnt  \\\n",
       "98       PDIP          1.0                       Badan Anggaran   21   \n",
       "100      PDIP          1.0                      Badan Legislasi   15   \n",
       "99       PDIP          1.0      Badan Kerja Sama Antar Parlemen   12   \n",
       "105      PDIP          1.0                           Komisi III   12   \n",
       "106      PDIP          1.0                            Komisi IV   12   \n",
       "108      PDIP          1.0                             Komisi V   12   \n",
       "109      PDIP          1.0                            Komisi VI   12   \n",
       "110      PDIP          1.0                           Komisi VII   12   \n",
       "111      PDIP          1.0                          Komisi VIII   12   \n",
       "101      PDIP          1.0                     Badan Musyawarah   11   \n",
       "103      PDIP          1.0                             Komisi I   11   \n",
       "104      PDIP          1.0                            Komisi II   11   \n",
       "107      PDIP          1.0                            Komisi IX   11   \n",
       "112      PDIP          1.0                             Komisi X   11   \n",
       "113      PDIP          1.0                            Komisi XI   10   \n",
       "102      PDIP          1.0            Badan Urusan Rumah Tangga    4   \n",
       "115      PDIP          1.0                       Panitia Khusus    2   \n",
       "97       PDIP          1.0  Badan Akuntabilitas Keuangan Negara    1   \n",
       "114      PDIP          1.0            Mahkamah Kehormatan Dewan    1   \n",
       "116      PDIP          1.0                             Pimpinan    1   \n",
       "21     Golkar          2.0                       Badan Anggaran   15   \n",
       "23     Golkar          2.0                      Badan Legislasi   12   \n",
       "24     Golkar          2.0                     Badan Musyawarah    9   \n",
       "22     Golkar          2.0      Badan Kerja Sama Antar Parlemen    8   \n",
       "26     Golkar          2.0                             Komisi I    8   \n",
       "28     Golkar          2.0                           Komisi III    8   \n",
       "29     Golkar          2.0                            Komisi IV    8   \n",
       "31     Golkar          2.0                             Komisi V    8   \n",
       "32     Golkar          2.0                            Komisi VI    8   \n",
       "33     Golkar          2.0                           Komisi VII    8   \n",
       "34     Golkar          2.0                          Komisi VIII    8   \n",
       "36     Golkar          2.0                            Komisi XI    8   \n",
       "27     Golkar          2.0                            Komisi II    7   \n",
       "30     Golkar          2.0                            Komisi IX    7   \n",
       "35     Golkar          2.0                             Komisi X    7   \n",
       "25     Golkar          2.0            Badan Urusan Rumah Tangga    4   \n",
       "37     Golkar          2.0            Mahkamah Kehormatan Dewan    2   \n",
       "38     Golkar          2.0                       Panitia Khusus    2   \n",
       "20     Golkar          2.0  Badan Akuntabilitas Keuangan Negara    1   \n",
       "39     Golkar          2.0                             Pimpinan    1   \n",
       "2    Gerindra          3.0                       Badan Anggaran   14   \n",
       "4    Gerindra          3.0                      Badan Legislasi   10   \n",
       "9    Gerindra          3.0                           Komisi III    8   \n",
       "3    Gerindra          3.0      Badan Kerja Sama Antar Parlemen    7   \n",
       "5    Gerindra          3.0                     Badan Musyawarah    7   \n",
       "7    Gerindra          3.0                             Komisi I    7   \n",
       "10   Gerindra          3.0                            Komisi IV    7   \n",
       "11   Gerindra          3.0                            Komisi IX    7   \n",
       "12   Gerindra          3.0                             Komisi V    7   \n",
       "14   Gerindra          3.0                           Komisi VII    7   \n",
       "15   Gerindra          3.0                          Komisi VIII    7   \n",
       "16   Gerindra          3.0                             Komisi X    7   \n",
       "17   Gerindra          3.0                            Komisi XI    7   \n",
       "13   Gerindra          3.0                            Komisi VI    6   \n",
       "8    Gerindra          3.0                            Komisi II    5   \n",
       "18   Gerindra          3.0                       Panitia Khusus    3   \n",
       "0    Gerindra          3.0                                    -    2   \n",
       "6    Gerindra          3.0            Badan Urusan Rumah Tangga    2   \n",
       "1    Gerindra          3.0  Badan Akuntabilitas Keuangan Negara    1   \n",
       "19   Gerindra          3.0                             Pimpinan    1   \n",
       "42     Nasdem          4.0                       Badan Anggaran   10   \n",
       "44     Nasdem          4.0                      Badan Legislasi    8   \n",
       "49     Nasdem          4.0                            Komisi IV    6   \n",
       "56     Nasdem          4.0                            Komisi XI    6   \n",
       "43     Nasdem          4.0      Badan Kerja Sama Antar Parlemen    5   \n",
       "45     Nasdem          4.0                     Badan Musyawarah    5   \n",
       "46     Nasdem          4.0                             Komisi I    5   \n",
       "47     Nasdem          4.0                            Komisi II    5   \n",
       "48     Nasdem          4.0                           Komisi III    5   \n",
       "50     Nasdem          4.0                            Komisi IX    5   \n",
       "51     Nasdem          4.0                             Komisi V    5   \n",
       "52     Nasdem          4.0                            Komisi VI    5   \n",
       "53     Nasdem          4.0                           Komisi VII    5   \n",
       "54     Nasdem          4.0                          Komisi VIII    5   \n",
       "55     Nasdem          4.0                             Komisi X    5   \n",
       "40     Nasdem          4.0                                    -    2   \n",
       "41     Nasdem          4.0  Badan Akuntabilitas Keuangan Negara    1   \n",
       "57     Nasdem          4.0                       Panitia Khusus    1   \n",
       "58     Nasdem          4.0                             Pimpinan    1   \n",
       "134       PKB          5.0                       Panitia Khusus   49   \n",
       "118       PKB          5.0                       Badan Anggaran   10   \n",
       "120       PKB          5.0                      Badan Legislasi    8   \n",
       "123       PKB          5.0                             Komisi I    6   \n",
       "126       PKB          5.0                            Komisi IV    6   \n",
       "127       PKB          5.0                            Komisi IX    6   \n",
       "128       PKB          5.0                             Komisi V    6   \n",
       "129       PKB          5.0                            Komisi VI    6   \n",
       "132       PKB          5.0                             Komisi X    6   \n",
       "119       PKB          5.0      Badan Kerja Sama Antar Parlemen    5   \n",
       "125       PKB          5.0                           Komisi III    5   \n",
       "130       PKB          5.0                           Komisi VII    5   \n",
       "133       PKB          5.0                            Komisi XI    5   \n",
       "131       PKB          5.0                          Komisi VIII    4   \n",
       "121       PKB          5.0                     Badan Musyawarah    3   \n",
       "124       PKB          5.0                            Komisi II    3   \n",
       "122       PKB          5.0            Badan Urusan Rumah Tangga    2   \n",
       "117       PKB          5.0  Badan Akuntabilitas Keuangan Negara    1   \n",
       "135       PKB          5.0                             Pimpinan    1   \n",
       "80         PD          6.0                       Badan Anggaran    9   \n",
       "82         PD          6.0                      Badan Legislasi    7   \n",
       "81         PD          6.0      Badan Kerja Sama Antar Parlemen    5   \n",
       "85         PD          6.0                             Komisi I    5   \n",
       "87         PD          6.0                           Komisi III    5   \n",
       "88         PD          6.0                            Komisi IV    5   \n",
       "89         PD          6.0                            Komisi IX    5   \n",
       "90         PD          6.0                             Komisi V    5   \n",
       "91         PD          6.0                            Komisi VI    5   \n",
       "92         PD          6.0                           Komisi VII    5   \n",
       "93         PD          6.0                          Komisi VIII    5   \n",
       "94         PD          6.0                             Komisi X    5   \n",
       "95         PD          6.0                            Komisi XI    5   \n",
       "83         PD          6.0                     Badan Musyawarah    4   \n",
       "86         PD          6.0                            Komisi II    3   \n",
       "84         PD          6.0            Badan Urusan Rumah Tangga    2   \n",
       "78         PD          6.0                                    -    1   \n",
       "79         PD          6.0  Badan Akuntabilitas Keuangan Negara    1   \n",
       "96         PD          6.0                       Panitia Khusus    1   \n",
       "137       PKS          7.0                       Badan Anggaran    9   \n",
       "139       PKS          7.0                      Badan Legislasi    7   \n",
       "138       PKS          7.0      Badan Kerja Sama Antar Parlemen    5   \n",
       "142       PKS          7.0                             Komisi I    5   \n",
       "145       PKS          7.0                            Komisi IV    5   \n",
       "146       PKS          7.0                            Komisi IX    5   \n",
       "148       PKS          7.0                            Komisi VI    5   \n",
       "150       PKS          7.0                          Komisi VIII    5   \n",
       "151       PKS          7.0                             Komisi X    5   \n",
       "143       PKS          7.0                            Komisi II    4   \n",
       "144       PKS          7.0                           Komisi III    4   \n",
       "147       PKS          7.0                             Komisi V    4   \n",
       "149       PKS          7.0                           Komisi VII    4   \n",
       "152       PKS          7.0                            Komisi XI    4   \n",
       "140       PKS          7.0                     Badan Musyawarah    3   \n",
       "141       PKS          7.0            Badan Urusan Rumah Tangga    2   \n",
       "136       PKS          7.0  Badan Akuntabilitas Keuangan Negara    1   \n",
       "153       PKS          7.0                       Panitia Khusus    1   \n",
       "60        PAN          8.0                       Badan Anggaran    8   \n",
       "62        PAN          8.0                      Badan Legislasi    6   \n",
       "61        PAN          8.0      Badan Kerja Sama Antar Parlemen    4   \n",
       "63        PAN          8.0                     Badan Musyawarah    4   \n",
       "65        PAN          8.0                             Komisi I    4   \n",
       "66        PAN          8.0                            Komisi II    4   \n",
       "67        PAN          8.0                           Komisi III    4   \n",
       "68        PAN          8.0                            Komisi IV    4   \n",
       "69        PAN          8.0                            Komisi IX    4   \n",
       "70        PAN          8.0                             Komisi V    4   \n",
       "71        PAN          8.0                            Komisi VI    4   \n",
       "72        PAN          8.0                           Komisi VII    4   \n",
       "73        PAN          8.0                          Komisi VIII    4   \n",
       "74        PAN          8.0                             Komisi X    4   \n",
       "75        PAN          8.0                            Komisi XI    4   \n",
       "64        PAN          8.0            Badan Urusan Rumah Tangga    2   \n",
       "59        PAN          8.0  Badan Akuntabilitas Keuangan Negara    1   \n",
       "76        PAN          8.0            Mahkamah Kehormatan Dewan    1   \n",
       "77        PAN          8.0                       Panitia Khusus    1   \n",
       "155       PPP          9.0                       Badan Anggaran    3   \n",
       "157       PPP          9.0                      Badan Legislasi    3   \n",
       "156       PPP          9.0      Badan Kerja Sama Antar Parlemen    2   \n",
       "158       PPP          9.0                     Badan Musyawarah    2   \n",
       "160       PPP          9.0                             Komisi I    2   \n",
       "161       PPP          9.0                            Komisi II    2   \n",
       "163       PPP          9.0                            Komisi IV    2   \n",
       "165       PPP          9.0                             Komisi V    2   \n",
       "166       PPP          9.0                            Komisi VI    2   \n",
       "168       PPP          9.0                          Komisi VIII    2   \n",
       "169       PPP          9.0                             Komisi X    2   \n",
       "170       PPP          9.0                            Komisi XI    2   \n",
       "154       PPP          9.0  Badan Akuntabilitas Keuangan Negara    1   \n",
       "159       PPP          9.0            Badan Urusan Rumah Tangga    1   \n",
       "162       PPP          9.0                           Komisi III    1   \n",
       "164       PPP          9.0                            Komisi IX    1   \n",
       "167       PPP          9.0                           Komisi VII    1   \n",
       "171       PPP          9.0            Mahkamah Kehormatan Dewan    1   \n",
       "172       PPP          9.0                       Panitia Khusus    1   \n",
       "\n",
       "       p(A|B)    p(B|A)  \n",
       "98   0.108247  0.212121  \n",
       "100  0.077320  0.197368  \n",
       "99   0.061856  0.226415  \n",
       "105  0.061856  0.230769  \n",
       "106  0.061856  0.218182  \n",
       "108  0.061856  0.226415  \n",
       "109  0.061856  0.226415  \n",
       "110  0.061856  0.235294  \n",
       "111  0.061856  0.230769  \n",
       "101  0.056701  0.229167  \n",
       "103  0.056701  0.207547  \n",
       "104  0.056701  0.250000  \n",
       "107  0.056701  0.215686  \n",
       "112  0.056701  0.211538  \n",
       "113  0.051546  0.196078  \n",
       "102  0.020619  0.210526  \n",
       "115  0.010309  0.032787  \n",
       "97   0.005155  0.111111  \n",
       "114  0.005155  0.200000  \n",
       "116  0.005155  0.200000  \n",
       "21   0.107914  0.151515  \n",
       "23   0.086331  0.157895  \n",
       "24   0.064748  0.187500  \n",
       "22   0.057554  0.150943  \n",
       "26   0.057554  0.150943  \n",
       "28   0.057554  0.153846  \n",
       "29   0.057554  0.145455  \n",
       "31   0.057554  0.150943  \n",
       "32   0.057554  0.150943  \n",
       "33   0.057554  0.156863  \n",
       "34   0.057554  0.153846  \n",
       "36   0.057554  0.156863  \n",
       "27   0.050360  0.159091  \n",
       "30   0.050360  0.137255  \n",
       "35   0.050360  0.134615  \n",
       "25   0.028777  0.210526  \n",
       "37   0.014388  0.400000  \n",
       "38   0.014388  0.032787  \n",
       "20   0.007194  0.111111  \n",
       "39   0.007194  0.200000  \n",
       "2    0.114754  0.141414  \n",
       "4    0.081967  0.131579  \n",
       "9    0.065574  0.153846  \n",
       "3    0.057377  0.132075  \n",
       "5    0.057377  0.145833  \n",
       "7    0.057377  0.132075  \n",
       "10   0.057377  0.127273  \n",
       "11   0.057377  0.137255  \n",
       "12   0.057377  0.132075  \n",
       "14   0.057377  0.137255  \n",
       "15   0.057377  0.134615  \n",
       "16   0.057377  0.134615  \n",
       "17   0.057377  0.137255  \n",
       "13   0.049180  0.113208  \n",
       "8    0.040984  0.113636  \n",
       "18   0.024590  0.049180  \n",
       "0    0.016393  0.400000  \n",
       "6    0.016393  0.105263  \n",
       "1    0.008197  0.111111  \n",
       "19   0.008197  0.200000  \n",
       "42   0.111111  0.101010  \n",
       "44   0.088889  0.105263  \n",
       "49   0.066667  0.109091  \n",
       "56   0.066667  0.117647  \n",
       "43   0.055556  0.094340  \n",
       "45   0.055556  0.104167  \n",
       "46   0.055556  0.094340  \n",
       "47   0.055556  0.113636  \n",
       "48   0.055556  0.096154  \n",
       "50   0.055556  0.098039  \n",
       "51   0.055556  0.094340  \n",
       "52   0.055556  0.094340  \n",
       "53   0.055556  0.098039  \n",
       "54   0.055556  0.096154  \n",
       "55   0.055556  0.096154  \n",
       "40   0.022222  0.400000  \n",
       "41   0.011111  0.111111  \n",
       "57   0.011111  0.016393  \n",
       "58   0.011111  0.200000  \n",
       "134  0.357664  0.803279  \n",
       "118  0.072993  0.101010  \n",
       "120  0.058394  0.105263  \n",
       "123  0.043796  0.113208  \n",
       "126  0.043796  0.109091  \n",
       "127  0.043796  0.117647  \n",
       "128  0.043796  0.113208  \n",
       "129  0.043796  0.113208  \n",
       "132  0.043796  0.115385  \n",
       "119  0.036496  0.094340  \n",
       "125  0.036496  0.096154  \n",
       "130  0.036496  0.098039  \n",
       "133  0.036496  0.098039  \n",
       "131  0.029197  0.076923  \n",
       "121  0.021898  0.062500  \n",
       "124  0.021898  0.068182  \n",
       "122  0.014599  0.105263  \n",
       "117  0.007299  0.111111  \n",
       "135  0.007299  0.200000  \n",
       "80   0.108434  0.090909  \n",
       "82   0.084337  0.092105  \n",
       "81   0.060241  0.094340  \n",
       "85   0.060241  0.094340  \n",
       "87   0.060241  0.096154  \n",
       "88   0.060241  0.090909  \n",
       "89   0.060241  0.098039  \n",
       "90   0.060241  0.094340  \n",
       "91   0.060241  0.094340  \n",
       "92   0.060241  0.098039  \n",
       "93   0.060241  0.096154  \n",
       "94   0.060241  0.096154  \n",
       "95   0.060241  0.098039  \n",
       "83   0.048193  0.083333  \n",
       "86   0.036145  0.068182  \n",
       "84   0.024096  0.105263  \n",
       "78   0.012048  0.200000  \n",
       "79   0.012048  0.111111  \n",
       "96   0.012048  0.016393  \n",
       "137  0.115385  0.090909  \n",
       "139  0.089744  0.092105  \n",
       "138  0.064103  0.094340  \n",
       "142  0.064103  0.094340  \n",
       "145  0.064103  0.090909  \n",
       "146  0.064103  0.098039  \n",
       "148  0.064103  0.094340  \n",
       "150  0.064103  0.096154  \n",
       "151  0.064103  0.096154  \n",
       "143  0.051282  0.090909  \n",
       "144  0.051282  0.076923  \n",
       "147  0.051282  0.075472  \n",
       "149  0.051282  0.078431  \n",
       "152  0.051282  0.078431  \n",
       "140  0.038462  0.062500  \n",
       "141  0.025641  0.105263  \n",
       "136  0.012821  0.111111  \n",
       "153  0.012821  0.016393  \n",
       "60   0.112676  0.080808  \n",
       "62   0.084507  0.078947  \n",
       "61   0.056338  0.075472  \n",
       "63   0.056338  0.083333  \n",
       "65   0.056338  0.075472  \n",
       "66   0.056338  0.090909  \n",
       "67   0.056338  0.076923  \n",
       "68   0.056338  0.072727  \n",
       "69   0.056338  0.078431  \n",
       "70   0.056338  0.075472  \n",
       "71   0.056338  0.075472  \n",
       "72   0.056338  0.078431  \n",
       "73   0.056338  0.076923  \n",
       "74   0.056338  0.076923  \n",
       "75   0.056338  0.078431  \n",
       "64   0.028169  0.105263  \n",
       "59   0.014085  0.111111  \n",
       "76   0.014085  0.200000  \n",
       "77   0.014085  0.016393  \n",
       "155  0.090909  0.030303  \n",
       "157  0.090909  0.039474  \n",
       "156  0.060606  0.037736  \n",
       "158  0.060606  0.041667  \n",
       "160  0.060606  0.037736  \n",
       "161  0.060606  0.045455  \n",
       "163  0.060606  0.036364  \n",
       "165  0.060606  0.037736  \n",
       "166  0.060606  0.037736  \n",
       "168  0.060606  0.038462  \n",
       "169  0.060606  0.038462  \n",
       "170  0.060606  0.039216  \n",
       "154  0.030303  0.111111  \n",
       "159  0.030303  0.052632  \n",
       "162  0.030303  0.019231  \n",
       "164  0.030303  0.019608  \n",
       "167  0.030303  0.019608  \n",
       "171  0.030303  0.200000  \n",
       "172  0.030303  0.016393  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bivariate_analysis('akd_clean', 'cnt')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>partai</th>\n",
       "      <th>rank_partai</th>\n",
       "      <th>is_dewan</th>\n",
       "      <th>cnt</th>\n",
       "      <th>p(A|B)</th>\n",
       "      <th>p(B|A)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>dewan</td>\n",
       "      <td>93</td>\n",
       "      <td>0.732283</td>\n",
       "      <td>0.322917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>4</td>\n",
       "      <td>0.031496</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>30</td>\n",
       "      <td>0.236220</td>\n",
       "      <td>0.111940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>dewan</td>\n",
       "      <td>46</td>\n",
       "      <td>0.541176</td>\n",
       "      <td>0.159722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>37</td>\n",
       "      <td>0.435294</td>\n",
       "      <td>0.138060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>2</td>\n",
       "      <td>0.023529</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>55</td>\n",
       "      <td>0.723684</td>\n",
       "      <td>0.205224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>dewan</td>\n",
       "      <td>20</td>\n",
       "      <td>0.263158</td>\n",
       "      <td>0.069444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>1</td>\n",
       "      <td>0.013158</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>35</td>\n",
       "      <td>0.593220</td>\n",
       "      <td>0.130597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>dewan</td>\n",
       "      <td>23</td>\n",
       "      <td>0.389831</td>\n",
       "      <td>0.079861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>1</td>\n",
       "      <td>0.016949</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>dewan</td>\n",
       "      <td>32</td>\n",
       "      <td>0.551724</td>\n",
       "      <td>0.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>25</td>\n",
       "      <td>0.431034</td>\n",
       "      <td>0.093284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>1</td>\n",
       "      <td>0.017241</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>3</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.187500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>27</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.100746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>dewan</td>\n",
       "      <td>24</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>0.083333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>2</td>\n",
       "      <td>0.040000</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>29</td>\n",
       "      <td>0.580000</td>\n",
       "      <td>0.108209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>dewan</td>\n",
       "      <td>19</td>\n",
       "      <td>0.380000</td>\n",
       "      <td>0.065972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>2</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>26</td>\n",
       "      <td>0.590909</td>\n",
       "      <td>0.097015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>dewan</td>\n",
       "      <td>16</td>\n",
       "      <td>0.363636</td>\n",
       "      <td>0.055556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>dewan</td>\n",
       "      <td>15</td>\n",
       "      <td>0.789474</td>\n",
       "      <td>0.052083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>4</td>\n",
       "      <td>0.210526</td>\n",
       "      <td>0.014925</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      partai  rank_partai   is_dewan  cnt    p(A|B)    p(B|A)\n",
       "15      PDIP          1.0      dewan   93  0.732283  0.322917\n",
       "16      PDIP          1.0    no_data    4  0.031496  0.250000\n",
       "17      PDIP          1.0  non-dewan   30  0.236220  0.111940\n",
       "3     Golkar          2.0      dewan   46  0.541176  0.159722\n",
       "5     Golkar          2.0  non-dewan   37  0.435294  0.138060\n",
       "4     Golkar          2.0    no_data    2  0.023529  0.125000\n",
       "2   Gerindra          3.0  non-dewan   55  0.723684  0.205224\n",
       "0   Gerindra          3.0      dewan   20  0.263158  0.069444\n",
       "1   Gerindra          3.0    no_data    1  0.013158  0.062500\n",
       "8     Nasdem          4.0  non-dewan   35  0.593220  0.130597\n",
       "6     Nasdem          4.0      dewan   23  0.389831  0.079861\n",
       "7     Nasdem          4.0    no_data    1  0.016949  0.062500\n",
       "18       PKB          5.0      dewan   32  0.551724  0.111111\n",
       "20       PKB          5.0  non-dewan   25  0.431034  0.093284\n",
       "19       PKB          5.0    no_data    1  0.017241  0.062500\n",
       "13        PD          6.0    no_data    3  0.055556  0.187500\n",
       "14        PD          6.0  non-dewan   27  0.500000  0.100746\n",
       "12        PD          6.0      dewan   24  0.444444  0.083333\n",
       "22       PKS          7.0    no_data    2  0.040000  0.125000\n",
       "23       PKS          7.0  non-dewan   29  0.580000  0.108209\n",
       "21       PKS          7.0      dewan   19  0.380000  0.065972\n",
       "10       PAN          8.0    no_data    2  0.045455  0.125000\n",
       "11       PAN          8.0  non-dewan   26  0.590909  0.097015\n",
       "9        PAN          8.0      dewan   16  0.363636  0.055556\n",
       "24       PPP          9.0      dewan   15  0.789474  0.052083\n",
       "25       PPP          9.0  non-dewan    4  0.210526  0.014925"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bivariate_analysis('is_dewan')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>partai</th>\n",
       "      <th>rank_partai</th>\n",
       "      <th>agama</th>\n",
       "      <th>cnt</th>\n",
       "      <th>p(A|B)</th>\n",
       "      <th>p(B|A)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Hindu</td>\n",
       "      <td>7</td>\n",
       "      <td>0.056911</td>\n",
       "      <td>0.636364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Kristen</td>\n",
       "      <td>32</td>\n",
       "      <td>0.260163</td>\n",
       "      <td>0.615385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Budha</td>\n",
       "      <td>2</td>\n",
       "      <td>0.016260</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Katolik</td>\n",
       "      <td>11</td>\n",
       "      <td>0.089431</td>\n",
       "      <td>0.458333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>71</td>\n",
       "      <td>0.577236</td>\n",
       "      <td>0.152688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Budha</td>\n",
       "      <td>1</td>\n",
       "      <td>0.012048</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Hindu</td>\n",
       "      <td>2</td>\n",
       "      <td>0.024096</td>\n",
       "      <td>0.181818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Katolik</td>\n",
       "      <td>4</td>\n",
       "      <td>0.048193</td>\n",
       "      <td>0.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>72</td>\n",
       "      <td>0.867470</td>\n",
       "      <td>0.154839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Kristen</td>\n",
       "      <td>4</td>\n",
       "      <td>0.048193</td>\n",
       "      <td>0.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>69</td>\n",
       "      <td>0.920000</td>\n",
       "      <td>0.148387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Katolik</td>\n",
       "      <td>3</td>\n",
       "      <td>0.040000</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Kristen</td>\n",
       "      <td>3</td>\n",
       "      <td>0.040000</td>\n",
       "      <td>0.057692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Katolik</td>\n",
       "      <td>4</td>\n",
       "      <td>0.068966</td>\n",
       "      <td>0.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Kristen</td>\n",
       "      <td>8</td>\n",
       "      <td>0.137931</td>\n",
       "      <td>0.153846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>46</td>\n",
       "      <td>0.793103</td>\n",
       "      <td>0.098925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Budha</td>\n",
       "      <td>1</td>\n",
       "      <td>0.017544</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>54</td>\n",
       "      <td>0.947368</td>\n",
       "      <td>0.116129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Katolik</td>\n",
       "      <td>2</td>\n",
       "      <td>0.035088</td>\n",
       "      <td>0.083333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Hindu</td>\n",
       "      <td>2</td>\n",
       "      <td>0.039216</td>\n",
       "      <td>0.181818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>46</td>\n",
       "      <td>0.901961</td>\n",
       "      <td>0.098925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Kristen</td>\n",
       "      <td>3</td>\n",
       "      <td>0.058824</td>\n",
       "      <td>0.057692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>48</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.103226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>40</td>\n",
       "      <td>0.952381</td>\n",
       "      <td>0.086022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Kristen</td>\n",
       "      <td>2</td>\n",
       "      <td>0.047619</td>\n",
       "      <td>0.038462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>19</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.040860</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      partai  rank_partai    agama  cnt    p(A|B)    p(B|A)\n",
       "17      PDIP          1.0    Hindu    7  0.056911  0.636364\n",
       "20      PDIP          1.0  Kristen   32  0.260163  0.615385\n",
       "16      PDIP          1.0    Budha    2  0.016260  0.500000\n",
       "19      PDIP          1.0  Katolik   11  0.089431  0.458333\n",
       "18      PDIP          1.0    Islam   71  0.577236  0.152688\n",
       "3     Golkar          2.0    Budha    1  0.012048  0.250000\n",
       "4     Golkar          2.0    Hindu    2  0.024096  0.181818\n",
       "6     Golkar          2.0  Katolik    4  0.048193  0.166667\n",
       "5     Golkar          2.0    Islam   72  0.867470  0.154839\n",
       "7     Golkar          2.0  Kristen    4  0.048193  0.076923\n",
       "0   Gerindra          3.0    Islam   69  0.920000  0.148387\n",
       "1   Gerindra          3.0  Katolik    3  0.040000  0.125000\n",
       "2   Gerindra          3.0  Kristen    3  0.040000  0.057692\n",
       "9     Nasdem          4.0  Katolik    4  0.068966  0.166667\n",
       "10    Nasdem          4.0  Kristen    8  0.137931  0.153846\n",
       "8     Nasdem          4.0    Islam   46  0.793103  0.098925\n",
       "21       PKB          5.0    Budha    1  0.017544  0.250000\n",
       "22       PKB          5.0    Islam   54  0.947368  0.116129\n",
       "23       PKB          5.0  Katolik    2  0.035088  0.083333\n",
       "13        PD          6.0    Hindu    2  0.039216  0.181818\n",
       "14        PD          6.0    Islam   46  0.901961  0.098925\n",
       "15        PD          6.0  Kristen    3  0.058824  0.057692\n",
       "24       PKS          7.0    Islam   48  1.000000  0.103226\n",
       "11       PAN          8.0    Islam   40  0.952381  0.086022\n",
       "12       PAN          8.0  Kristen    2  0.047619  0.038462\n",
       "25       PPP          9.0    Islam   19  1.000000  0.040860"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bivariate_analysis('agama')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>mean</th>\n",
       "      <th>max</th>\n",
       "      <th>min</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>partai</th>\n",
       "      <th>rank_partai</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Gerindra</th>\n",
       "      <th>3.0</th>\n",
       "      <td>51.373333</td>\n",
       "      <td>71.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Golkar</th>\n",
       "      <th>2.0</th>\n",
       "      <td>52.168675</td>\n",
       "      <td>74.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nasdem</th>\n",
       "      <th>4.0</th>\n",
       "      <td>49.568966</td>\n",
       "      <td>72.0</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PAN</th>\n",
       "      <th>8.0</th>\n",
       "      <td>49.738095</td>\n",
       "      <td>71.0</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PD</th>\n",
       "      <th>6.0</th>\n",
       "      <td>51.764706</td>\n",
       "      <td>81.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PDIP</th>\n",
       "      <th>1.0</th>\n",
       "      <td>53.040650</td>\n",
       "      <td>77.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PKB</th>\n",
       "      <th>5.0</th>\n",
       "      <td>50.508772</td>\n",
       "      <td>75.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PKS</th>\n",
       "      <th>7.0</th>\n",
       "      <td>54.666667</td>\n",
       "      <td>71.0</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PPP</th>\n",
       "      <th>9.0</th>\n",
       "      <td>50.684211</td>\n",
       "      <td>65.0</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           mean   max   min\n",
       "partai   rank_partai                       \n",
       "Gerindra 3.0          51.373333  71.0  25.0\n",
       "Golkar   2.0          52.168675  74.0  26.0\n",
       "Nasdem   4.0          49.568966  72.0  24.0\n",
       "PAN      8.0          49.738095  71.0  24.0\n",
       "PD       6.0          51.764706  81.0  26.0\n",
       "PDIP     1.0          53.040650  77.0  28.0\n",
       "PKB      5.0          50.508772  75.0  30.0\n",
       "PKS      7.0          54.666667  71.0  43.0\n",
       "PPP      9.0          50.684211  65.0  29.0"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "profil_raw.groupby(['partai','rank_partai'])['usia'].agg(['mean', 'max', 'min'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>partai</th>\n",
       "      <th>rank_partai</th>\n",
       "      <th>usia_kategori</th>\n",
       "      <th>cnt</th>\n",
       "      <th>p(A|B)</th>\n",
       "      <th>p(B|A)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(55.0, 61.0]</td>\n",
       "      <td>27</td>\n",
       "      <td>0.212598</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>4</td>\n",
       "      <td>0.031496</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(49.0, 55.0]</td>\n",
       "      <td>31</td>\n",
       "      <td>0.244094</td>\n",
       "      <td>0.244094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(44.0, 49.0]</td>\n",
       "      <td>24</td>\n",
       "      <td>0.188976</td>\n",
       "      <td>0.237624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(61.0, 81.0]</td>\n",
       "      <td>21</td>\n",
       "      <td>0.165354</td>\n",
       "      <td>0.221053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>20</td>\n",
       "      <td>0.157480</td>\n",
       "      <td>0.160000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(55.0, 61.0]</td>\n",
       "      <td>20</td>\n",
       "      <td>0.235294</td>\n",
       "      <td>0.185185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>21</td>\n",
       "      <td>0.247059</td>\n",
       "      <td>0.168000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(61.0, 81.0]</td>\n",
       "      <td>15</td>\n",
       "      <td>0.176471</td>\n",
       "      <td>0.157895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(44.0, 49.0]</td>\n",
       "      <td>13</td>\n",
       "      <td>0.152941</td>\n",
       "      <td>0.128713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>2</td>\n",
       "      <td>0.023529</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>(49.0, 55.0]</td>\n",
       "      <td>14</td>\n",
       "      <td>0.164706</td>\n",
       "      <td>0.110236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>23</td>\n",
       "      <td>0.302632</td>\n",
       "      <td>0.184000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>(61.0, 81.0]</td>\n",
       "      <td>15</td>\n",
       "      <td>0.197368</td>\n",
       "      <td>0.157895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>(49.0, 55.0]</td>\n",
       "      <td>18</td>\n",
       "      <td>0.236842</td>\n",
       "      <td>0.141732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>(55.0, 61.0]</td>\n",
       "      <td>13</td>\n",
       "      <td>0.171053</td>\n",
       "      <td>0.120370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0.013158</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>(44.0, 49.0]</td>\n",
       "      <td>6</td>\n",
       "      <td>0.078947</td>\n",
       "      <td>0.059406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>18</td>\n",
       "      <td>0.305085</td>\n",
       "      <td>0.144000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>(44.0, 49.0]</td>\n",
       "      <td>12</td>\n",
       "      <td>0.203390</td>\n",
       "      <td>0.118812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>(49.0, 55.0]</td>\n",
       "      <td>11</td>\n",
       "      <td>0.186441</td>\n",
       "      <td>0.086614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>(61.0, 81.0]</td>\n",
       "      <td>8</td>\n",
       "      <td>0.135593</td>\n",
       "      <td>0.084211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>(55.0, 61.0]</td>\n",
       "      <td>9</td>\n",
       "      <td>0.152542</td>\n",
       "      <td>0.083333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0.016949</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(44.0, 49.0]</td>\n",
       "      <td>18</td>\n",
       "      <td>0.310345</td>\n",
       "      <td>0.178218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(61.0, 81.0]</td>\n",
       "      <td>10</td>\n",
       "      <td>0.172414</td>\n",
       "      <td>0.105263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>13</td>\n",
       "      <td>0.224138</td>\n",
       "      <td>0.104000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(49.0, 55.0]</td>\n",
       "      <td>9</td>\n",
       "      <td>0.155172</td>\n",
       "      <td>0.070866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>(55.0, 61.0]</td>\n",
       "      <td>7</td>\n",
       "      <td>0.120690</td>\n",
       "      <td>0.064815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0.017241</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>3</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.187500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>(61.0, 81.0]</td>\n",
       "      <td>13</td>\n",
       "      <td>0.240741</td>\n",
       "      <td>0.136842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>15</td>\n",
       "      <td>0.277778</td>\n",
       "      <td>0.120000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>(44.0, 49.0]</td>\n",
       "      <td>10</td>\n",
       "      <td>0.185185</td>\n",
       "      <td>0.099010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>(55.0, 61.0]</td>\n",
       "      <td>7</td>\n",
       "      <td>0.129630</td>\n",
       "      <td>0.064815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>(49.0, 55.0]</td>\n",
       "      <td>6</td>\n",
       "      <td>0.111111</td>\n",
       "      <td>0.047244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>(49.0, 55.0]</td>\n",
       "      <td>23</td>\n",
       "      <td>0.460000</td>\n",
       "      <td>0.181102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>2</td>\n",
       "      <td>0.040000</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>(55.0, 61.0]</td>\n",
       "      <td>13</td>\n",
       "      <td>0.260000</td>\n",
       "      <td>0.120370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>(44.0, 49.0]</td>\n",
       "      <td>6</td>\n",
       "      <td>0.120000</td>\n",
       "      <td>0.059406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>(61.0, 81.0]</td>\n",
       "      <td>5</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>0.052632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>1</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>0.008000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>2</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>(55.0, 61.0]</td>\n",
       "      <td>10</td>\n",
       "      <td>0.227273</td>\n",
       "      <td>0.092593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>11</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.088000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>(44.0, 49.0]</td>\n",
       "      <td>8</td>\n",
       "      <td>0.181818</td>\n",
       "      <td>0.079208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>(49.0, 55.0]</td>\n",
       "      <td>8</td>\n",
       "      <td>0.181818</td>\n",
       "      <td>0.062992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>(61.0, 81.0]</td>\n",
       "      <td>5</td>\n",
       "      <td>0.113636</td>\n",
       "      <td>0.052632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>(49.0, 55.0]</td>\n",
       "      <td>7</td>\n",
       "      <td>0.368421</td>\n",
       "      <td>0.055118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>(44.0, 49.0]</td>\n",
       "      <td>4</td>\n",
       "      <td>0.210526</td>\n",
       "      <td>0.039604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>(61.0, 81.0]</td>\n",
       "      <td>3</td>\n",
       "      <td>0.157895</td>\n",
       "      <td>0.031579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>3</td>\n",
       "      <td>0.157895</td>\n",
       "      <td>0.024000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>(55.0, 61.0]</td>\n",
       "      <td>2</td>\n",
       "      <td>0.105263</td>\n",
       "      <td>0.018519</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      partai  rank_partai usia_kategori  cnt    p(A|B)    p(B|A)\n",
       "33      PDIP          1.0  (55.0, 61.0]   27  0.212598  0.250000\n",
       "35      PDIP          1.0           nan    4  0.031496  0.250000\n",
       "32      PDIP          1.0  (49.0, 55.0]   31  0.244094  0.244094\n",
       "31      PDIP          1.0  (44.0, 49.0]   24  0.188976  0.237624\n",
       "34      PDIP          1.0  (61.0, 81.0]   21  0.165354  0.221053\n",
       "30      PDIP          1.0  (23.0, 44.0]   20  0.157480  0.160000\n",
       "9     Golkar          2.0  (55.0, 61.0]   20  0.235294  0.185185\n",
       "6     Golkar          2.0  (23.0, 44.0]   21  0.247059  0.168000\n",
       "10    Golkar          2.0  (61.0, 81.0]   15  0.176471  0.157895\n",
       "7     Golkar          2.0  (44.0, 49.0]   13  0.152941  0.128713\n",
       "11    Golkar          2.0           nan    2  0.023529  0.125000\n",
       "8     Golkar          2.0  (49.0, 55.0]   14  0.164706  0.110236\n",
       "0   Gerindra          3.0  (23.0, 44.0]   23  0.302632  0.184000\n",
       "4   Gerindra          3.0  (61.0, 81.0]   15  0.197368  0.157895\n",
       "2   Gerindra          3.0  (49.0, 55.0]   18  0.236842  0.141732\n",
       "3   Gerindra          3.0  (55.0, 61.0]   13  0.171053  0.120370\n",
       "5   Gerindra          3.0           nan    1  0.013158  0.062500\n",
       "1   Gerindra          3.0  (44.0, 49.0]    6  0.078947  0.059406\n",
       "12    Nasdem          4.0  (23.0, 44.0]   18  0.305085  0.144000\n",
       "13    Nasdem          4.0  (44.0, 49.0]   12  0.203390  0.118812\n",
       "14    Nasdem          4.0  (49.0, 55.0]   11  0.186441  0.086614\n",
       "16    Nasdem          4.0  (61.0, 81.0]    8  0.135593  0.084211\n",
       "15    Nasdem          4.0  (55.0, 61.0]    9  0.152542  0.083333\n",
       "17    Nasdem          4.0           nan    1  0.016949  0.062500\n",
       "37       PKB          5.0  (44.0, 49.0]   18  0.310345  0.178218\n",
       "40       PKB          5.0  (61.0, 81.0]   10  0.172414  0.105263\n",
       "36       PKB          5.0  (23.0, 44.0]   13  0.224138  0.104000\n",
       "38       PKB          5.0  (49.0, 55.0]    9  0.155172  0.070866\n",
       "39       PKB          5.0  (55.0, 61.0]    7  0.120690  0.064815\n",
       "41       PKB          5.0           nan    1  0.017241  0.062500\n",
       "29        PD          6.0           nan    3  0.055556  0.187500\n",
       "28        PD          6.0  (61.0, 81.0]   13  0.240741  0.136842\n",
       "24        PD          6.0  (23.0, 44.0]   15  0.277778  0.120000\n",
       "25        PD          6.0  (44.0, 49.0]   10  0.185185  0.099010\n",
       "27        PD          6.0  (55.0, 61.0]    7  0.129630  0.064815\n",
       "26        PD          6.0  (49.0, 55.0]    6  0.111111  0.047244\n",
       "44       PKS          7.0  (49.0, 55.0]   23  0.460000  0.181102\n",
       "47       PKS          7.0           nan    2  0.040000  0.125000\n",
       "45       PKS          7.0  (55.0, 61.0]   13  0.260000  0.120370\n",
       "43       PKS          7.0  (44.0, 49.0]    6  0.120000  0.059406\n",
       "46       PKS          7.0  (61.0, 81.0]    5  0.100000  0.052632\n",
       "42       PKS          7.0  (23.0, 44.0]    1  0.020000  0.008000\n",
       "23       PAN          8.0           nan    2  0.045455  0.125000\n",
       "21       PAN          8.0  (55.0, 61.0]   10  0.227273  0.092593\n",
       "18       PAN          8.0  (23.0, 44.0]   11  0.250000  0.088000\n",
       "19       PAN          8.0  (44.0, 49.0]    8  0.181818  0.079208\n",
       "20       PAN          8.0  (49.0, 55.0]    8  0.181818  0.062992\n",
       "22       PAN          8.0  (61.0, 81.0]    5  0.113636  0.052632\n",
       "50       PPP          9.0  (49.0, 55.0]    7  0.368421  0.055118\n",
       "49       PPP          9.0  (44.0, 49.0]    4  0.210526  0.039604\n",
       "52       PPP          9.0  (61.0, 81.0]    3  0.157895  0.031579\n",
       "48       PPP          9.0  (23.0, 44.0]    3  0.157895  0.024000\n",
       "51       PPP          9.0  (55.0, 61.0]    2  0.105263  0.018519"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bivariate_analysis('usia_kategori')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>partai</th>\n",
       "      <th>rank_partai</th>\n",
       "      <th>pendidikan_terakhir</th>\n",
       "      <th>cnt</th>\n",
       "      <th>p(A|B)</th>\n",
       "      <th>p(B|A)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3_d3</td>\n",
       "      <td>3</td>\n",
       "      <td>0.023622</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4_s1</td>\n",
       "      <td>51</td>\n",
       "      <td>0.401575</td>\n",
       "      <td>0.264249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6_s3</td>\n",
       "      <td>22</td>\n",
       "      <td>0.173228</td>\n",
       "      <td>0.261905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0_no_data</td>\n",
       "      <td>7</td>\n",
       "      <td>0.055118</td>\n",
       "      <td>0.189189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>39</td>\n",
       "      <td>0.307087</td>\n",
       "      <td>0.178899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2_sma</td>\n",
       "      <td>5</td>\n",
       "      <td>0.039370</td>\n",
       "      <td>0.156250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>42</td>\n",
       "      <td>0.494118</td>\n",
       "      <td>0.192661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4_s1</td>\n",
       "      <td>27</td>\n",
       "      <td>0.317647</td>\n",
       "      <td>0.139896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0_no_data</td>\n",
       "      <td>5</td>\n",
       "      <td>0.058824</td>\n",
       "      <td>0.135135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6_s3</td>\n",
       "      <td>8</td>\n",
       "      <td>0.094118</td>\n",
       "      <td>0.095238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2_sma</td>\n",
       "      <td>3</td>\n",
       "      <td>0.035294</td>\n",
       "      <td>0.093750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0_no_data</td>\n",
       "      <td>7</td>\n",
       "      <td>0.092105</td>\n",
       "      <td>0.189189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2_sma</td>\n",
       "      <td>5</td>\n",
       "      <td>0.065789</td>\n",
       "      <td>0.156250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4_s1</td>\n",
       "      <td>27</td>\n",
       "      <td>0.355263</td>\n",
       "      <td>0.139896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6_s3</td>\n",
       "      <td>11</td>\n",
       "      <td>0.144737</td>\n",
       "      <td>0.130952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>26</td>\n",
       "      <td>0.342105</td>\n",
       "      <td>0.119266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1_smp</td>\n",
       "      <td>1</td>\n",
       "      <td>0.016949</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>29</td>\n",
       "      <td>0.491525</td>\n",
       "      <td>0.133028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2_sma</td>\n",
       "      <td>4</td>\n",
       "      <td>0.067797</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4_s1</td>\n",
       "      <td>19</td>\n",
       "      <td>0.322034</td>\n",
       "      <td>0.098446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6_s3</td>\n",
       "      <td>5</td>\n",
       "      <td>0.084746</td>\n",
       "      <td>0.059524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0_no_data</td>\n",
       "      <td>1</td>\n",
       "      <td>0.016949</td>\n",
       "      <td>0.027027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2_sma</td>\n",
       "      <td>6</td>\n",
       "      <td>0.103448</td>\n",
       "      <td>0.187500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>29</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.133028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4_s1</td>\n",
       "      <td>20</td>\n",
       "      <td>0.344828</td>\n",
       "      <td>0.103627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0_no_data</td>\n",
       "      <td>1</td>\n",
       "      <td>0.017241</td>\n",
       "      <td>0.027027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6_s3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.034483</td>\n",
       "      <td>0.023810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3_d3</td>\n",
       "      <td>1</td>\n",
       "      <td>0.018519</td>\n",
       "      <td>0.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0_no_data</td>\n",
       "      <td>5</td>\n",
       "      <td>0.092593</td>\n",
       "      <td>0.135135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6_s3</td>\n",
       "      <td>9</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>0.107143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>21</td>\n",
       "      <td>0.388889</td>\n",
       "      <td>0.096330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4_s1</td>\n",
       "      <td>16</td>\n",
       "      <td>0.296296</td>\n",
       "      <td>0.082902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2_sma</td>\n",
       "      <td>2</td>\n",
       "      <td>0.037037</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1_smp</td>\n",
       "      <td>1</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0_no_data</td>\n",
       "      <td>8</td>\n",
       "      <td>0.160000</td>\n",
       "      <td>0.216216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3_d3</td>\n",
       "      <td>1</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>0.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6_s3</td>\n",
       "      <td>14</td>\n",
       "      <td>0.280000</td>\n",
       "      <td>0.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4_s1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.280000</td>\n",
       "      <td>0.072539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>11</td>\n",
       "      <td>0.220000</td>\n",
       "      <td>0.050459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2_sma</td>\n",
       "      <td>1</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>0.031250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6_s3</td>\n",
       "      <td>8</td>\n",
       "      <td>0.181818</td>\n",
       "      <td>0.095238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2_sma</td>\n",
       "      <td>3</td>\n",
       "      <td>0.068182</td>\n",
       "      <td>0.093750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0_no_data</td>\n",
       "      <td>3</td>\n",
       "      <td>0.068182</td>\n",
       "      <td>0.081081</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4_s1</td>\n",
       "      <td>15</td>\n",
       "      <td>0.340909</td>\n",
       "      <td>0.077720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>15</td>\n",
       "      <td>0.340909</td>\n",
       "      <td>0.068807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3_d3</td>\n",
       "      <td>1</td>\n",
       "      <td>0.052632</td>\n",
       "      <td>0.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2_sma</td>\n",
       "      <td>3</td>\n",
       "      <td>0.157895</td>\n",
       "      <td>0.093750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6_s3</td>\n",
       "      <td>5</td>\n",
       "      <td>0.263158</td>\n",
       "      <td>0.059524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>6</td>\n",
       "      <td>0.315789</td>\n",
       "      <td>0.027523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4_s1</td>\n",
       "      <td>4</td>\n",
       "      <td>0.210526</td>\n",
       "      <td>0.020725</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      partai  rank_partai pendidikan_terakhir  cnt    p(A|B)    p(B|A)\n",
       "29      PDIP          1.0                3_d3    3  0.023622  0.500000\n",
       "30      PDIP          1.0                4_s1   51  0.401575  0.264249\n",
       "32      PDIP          1.0                6_s3   22  0.173228  0.261905\n",
       "27      PDIP          1.0           0_no_data    7  0.055118  0.189189\n",
       "31      PDIP          1.0                5_s2   39  0.307087  0.178899\n",
       "28      PDIP          1.0               2_sma    5  0.039370  0.156250\n",
       "8     Golkar          2.0                5_s2   42  0.494118  0.192661\n",
       "7     Golkar          2.0                4_s1   27  0.317647  0.139896\n",
       "5     Golkar          2.0           0_no_data    5  0.058824  0.135135\n",
       "9     Golkar          2.0                6_s3    8  0.094118  0.095238\n",
       "6     Golkar          2.0               2_sma    3  0.035294  0.093750\n",
       "0   Gerindra          3.0           0_no_data    7  0.092105  0.189189\n",
       "1   Gerindra          3.0               2_sma    5  0.065789  0.156250\n",
       "2   Gerindra          3.0                4_s1   27  0.355263  0.139896\n",
       "4   Gerindra          3.0                6_s3   11  0.144737  0.130952\n",
       "3   Gerindra          3.0                5_s2   26  0.342105  0.119266\n",
       "11    Nasdem          4.0               1_smp    1  0.016949  0.500000\n",
       "14    Nasdem          4.0                5_s2   29  0.491525  0.133028\n",
       "12    Nasdem          4.0               2_sma    4  0.067797  0.125000\n",
       "13    Nasdem          4.0                4_s1   19  0.322034  0.098446\n",
       "15    Nasdem          4.0                6_s3    5  0.084746  0.059524\n",
       "10    Nasdem          4.0           0_no_data    1  0.016949  0.027027\n",
       "34       PKB          5.0               2_sma    6  0.103448  0.187500\n",
       "36       PKB          5.0                5_s2   29  0.500000  0.133028\n",
       "35       PKB          5.0                4_s1   20  0.344828  0.103627\n",
       "33       PKB          5.0           0_no_data    1  0.017241  0.027027\n",
       "37       PKB          5.0                6_s3    2  0.034483  0.023810\n",
       "23        PD          6.0                3_d3    1  0.018519  0.166667\n",
       "21        PD          6.0           0_no_data    5  0.092593  0.135135\n",
       "26        PD          6.0                6_s3    9  0.166667  0.107143\n",
       "25        PD          6.0                5_s2   21  0.388889  0.096330\n",
       "24        PD          6.0                4_s1   16  0.296296  0.082902\n",
       "22        PD          6.0               2_sma    2  0.037037  0.062500\n",
       "39       PKS          7.0               1_smp    1  0.020000  0.500000\n",
       "38       PKS          7.0           0_no_data    8  0.160000  0.216216\n",
       "41       PKS          7.0                3_d3    1  0.020000  0.166667\n",
       "44       PKS          7.0                6_s3   14  0.280000  0.166667\n",
       "42       PKS          7.0                4_s1   14  0.280000  0.072539\n",
       "43       PKS          7.0                5_s2   11  0.220000  0.050459\n",
       "40       PKS          7.0               2_sma    1  0.020000  0.031250\n",
       "20       PAN          8.0                6_s3    8  0.181818  0.095238\n",
       "17       PAN          8.0               2_sma    3  0.068182  0.093750\n",
       "16       PAN          8.0           0_no_data    3  0.068182  0.081081\n",
       "18       PAN          8.0                4_s1   15  0.340909  0.077720\n",
       "19       PAN          8.0                5_s2   15  0.340909  0.068807\n",
       "46       PPP          9.0                3_d3    1  0.052632  0.166667\n",
       "45       PPP          9.0               2_sma    3  0.157895  0.093750\n",
       "49       PPP          9.0                6_s3    5  0.263158  0.059524\n",
       "48       PPP          9.0                5_s2    6  0.315789  0.027523\n",
       "47       PPP          9.0                4_s1    4  0.210526  0.020725"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bivariate_analysis('pendidikan_terakhir')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>partai</th>\n",
       "      <th>p(A|B)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>PKS</td>\n",
       "      <td>0.280000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PPP</td>\n",
       "      <td>0.263158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PAN</td>\n",
       "      <td>0.181818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>0.173228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PD</td>\n",
       "      <td>0.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>0.144737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>0.094118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>0.084746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PKB</td>\n",
       "      <td>0.034483</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     partai    p(A|B)\n",
       "7       PKS  0.280000\n",
       "8       PPP  0.263158\n",
       "3       PAN  0.181818\n",
       "5      PDIP  0.173228\n",
       "4        PD  0.166667\n",
       "0  Gerindra  0.144737\n",
       "1    Golkar  0.094118\n",
       "2    Nasdem  0.084746\n",
       "6       PKB  0.034483"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c = bivariate_analysis('pendidikan_terakhir')\n",
    "c[c.pendidikan_terakhir.str.contains('s3')].groupby('partai')['p(A|B)'].sum().reset_index().sort_values('p(A|B)', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>partai</th>\n",
       "      <th>rank_partai</th>\n",
       "      <th>is_kader</th>\n",
       "      <th>cnt</th>\n",
       "      <th>p(A|B)</th>\n",
       "      <th>p(B|A)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>110</td>\n",
       "      <td>0.866142</td>\n",
       "      <td>0.341615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>internal</td>\n",
       "      <td>13</td>\n",
       "      <td>0.102362</td>\n",
       "      <td>0.055556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>4</td>\n",
       "      <td>0.031496</td>\n",
       "      <td>0.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>internal</td>\n",
       "      <td>51</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.217949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>32</td>\n",
       "      <td>0.376471</td>\n",
       "      <td>0.099379</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>2</td>\n",
       "      <td>0.023529</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>46</td>\n",
       "      <td>0.605263</td>\n",
       "      <td>0.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>internal</td>\n",
       "      <td>29</td>\n",
       "      <td>0.381579</td>\n",
       "      <td>0.123932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>1</td>\n",
       "      <td>0.013158</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>33</td>\n",
       "      <td>0.559322</td>\n",
       "      <td>0.102484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>internal</td>\n",
       "      <td>25</td>\n",
       "      <td>0.423729</td>\n",
       "      <td>0.106838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Nasdem</td>\n",
       "      <td>4.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>1</td>\n",
       "      <td>0.016949</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>internal</td>\n",
       "      <td>35</td>\n",
       "      <td>0.603448</td>\n",
       "      <td>0.149573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>22</td>\n",
       "      <td>0.379310</td>\n",
       "      <td>0.068323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>1</td>\n",
       "      <td>0.017241</td>\n",
       "      <td>0.062500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>internal</td>\n",
       "      <td>29</td>\n",
       "      <td>0.537037</td>\n",
       "      <td>0.123932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>22</td>\n",
       "      <td>0.407407</td>\n",
       "      <td>0.068323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>3</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.187500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>30</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.093168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>internal</td>\n",
       "      <td>18</td>\n",
       "      <td>0.360000</td>\n",
       "      <td>0.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>PKS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>2</td>\n",
       "      <td>0.040000</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>23</td>\n",
       "      <td>0.522727</td>\n",
       "      <td>0.071429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>internal</td>\n",
       "      <td>19</td>\n",
       "      <td>0.431818</td>\n",
       "      <td>0.081197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>no_data</td>\n",
       "      <td>2</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>internal</td>\n",
       "      <td>15</td>\n",
       "      <td>0.789474</td>\n",
       "      <td>0.064103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>PPP</td>\n",
       "      <td>9.0</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>4</td>\n",
       "      <td>0.210526</td>\n",
       "      <td>0.012422</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      partai  rank_partai   is_kader  cnt    p(A|B)    p(B|A)\n",
       "15      PDIP          1.0  eksternal  110  0.866142  0.341615\n",
       "16      PDIP          1.0   internal   13  0.102362  0.055556\n",
       "17      PDIP          1.0    no_data    4  0.031496  0.250000\n",
       "4     Golkar          2.0   internal   51  0.600000  0.217949\n",
       "3     Golkar          2.0  eksternal   32  0.376471  0.099379\n",
       "5     Golkar          2.0    no_data    2  0.023529  0.125000\n",
       "0   Gerindra          3.0  eksternal   46  0.605263  0.142857\n",
       "1   Gerindra          3.0   internal   29  0.381579  0.123932\n",
       "2   Gerindra          3.0    no_data    1  0.013158  0.062500\n",
       "6     Nasdem          4.0  eksternal   33  0.559322  0.102484\n",
       "7     Nasdem          4.0   internal   25  0.423729  0.106838\n",
       "8     Nasdem          4.0    no_data    1  0.016949  0.062500\n",
       "19       PKB          5.0   internal   35  0.603448  0.149573\n",
       "18       PKB          5.0  eksternal   22  0.379310  0.068323\n",
       "20       PKB          5.0    no_data    1  0.017241  0.062500\n",
       "13        PD          6.0   internal   29  0.537037  0.123932\n",
       "12        PD          6.0  eksternal   22  0.407407  0.068323\n",
       "14        PD          6.0    no_data    3  0.055556  0.187500\n",
       "21       PKS          7.0  eksternal   30  0.600000  0.093168\n",
       "22       PKS          7.0   internal   18  0.360000  0.076923\n",
       "23       PKS          7.0    no_data    2  0.040000  0.125000\n",
       "9        PAN          8.0  eksternal   23  0.522727  0.071429\n",
       "10       PAN          8.0   internal   19  0.431818  0.081197\n",
       "11       PAN          8.0    no_data    2  0.045455  0.125000\n",
       "25       PPP          9.0   internal   15  0.789474  0.064103\n",
       "24       PPP          9.0  eksternal    4  0.210526  0.012422"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bivariate_analysis('is_kader', 'p(A|B)')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Bivariate Findings\n",
    "P(A) adalah probabilitas dari kolom yang dipanggil dalam fungsi bivariate_analysis\n",
    "P(B) adalah probabilitas dari partai\n",
    "\n",
    "1. Sebaran AKD pada tiap partai hampir sama.Hanya saja, ada beberapa partai yang condong terhadap komisi-komisi tertentu terlihat dari jumlah penempatan anggotanya. Badan Anggaran dan Badan Legislasi menjadi vital dari semua partai. Terdapat pencilan pada partai PKB dimana mayoritas anggotanya masuk dalam panitia khusus. Pimpinan diambil 1 dari masing-masing 5 partai teratas. \n",
    "2. PDIP dan PPP adalah partai veteran dimana mayoritas anggotanya melanjutkan tugasnya sebagai anggota dewan. Bisa jadi ini menandakan PDIP sangat baik dalam menjaga suaranya di tingkat masyarakat sedangkan PPP memiliki kantung-kantung suara yang loyal. Dilain hal, Gerindra adalah partai pembaruan. Hal ini menjadi wajar mengingat Prabowo menjadi ikon pembaruan di pemilu kemarin. Mayoritas (72%) anggota Gerindra belum memiliki pengalaman menjadi anggota legislatif sebelumnya.\n",
    "3. Hanya PDIP dan Golkar yang mewakili 5 agama mayoritas di Indonesia. Hal ini selaras dengan ideologi nasionalis yang mereka usung. Seorang caleg yang beragama non-islam lebih besar kemungkinannya terpilih via PDIP (metric P(B|A) terbesar). PKS dan PPP menjadi partai yang anggotanya 100% muslim.\n",
    "4. PKS memiliki rerata usia anggota tertua dengan 54,67 tahun sedangkan Nasdem menjadi partai termuda dengan rerata usia 49,56. PDIP dan Golkar memiliki sebaran umur_kategorical yang cukup rata dimana selisih max dan min P(A|B) nya serupa, 0.09.\n",
    "5. PKS mengokohkan dirinya menjadi partai terdidik dengan memiliki porsi S3 terbesar dalam partainya. PKB untuk S2, PDIP untuk S1, dan PPP untuk SMA. SMP adalah data outlier mengingat syarat minimum untuk menjadi anggota DPR ialah SMA.\n",
    "6. Golkar, PKB, PKS dan PPP adalah partai kaderisasi. Minimal 60% anggotanya pernah menjabat di internal partai."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>usia_kategori</th>\n",
       "      <th>partai</th>\n",
       "      <th>rank_partai</th>\n",
       "      <th>agama</th>\n",
       "      <th>is_dewan</th>\n",
       "      <th>is_kader</th>\n",
       "      <th>pendidikan_terakhir</th>\n",
       "      <th>cnt</th>\n",
       "      <th>p(A|B)</th>\n",
       "      <th>p(B|A)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>Gerindra</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>5</td>\n",
       "      <td>0.066667</td>\n",
       "      <td>0.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>PDIP</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>3</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>PKB</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>3</td>\n",
       "      <td>0.052632</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>Golkar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>2</td>\n",
       "      <td>0.024096</td>\n",
       "      <td>0.133333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>PAN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.023810</td>\n",
       "      <td>0.066667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>PD</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Islam</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.019608</td>\n",
       "      <td>0.066667</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   usia_kategori    partai  rank_partai  agama   is_dewan   is_kader  \\\n",
       "7   (23.0, 44.0]  Gerindra          3.0  Islam  non-dewan  eksternal   \n",
       "67  (23.0, 44.0]      PDIP          1.0  Islam  non-dewan  eksternal   \n",
       "77  (23.0, 44.0]       PKB          5.0  Islam  non-dewan  eksternal   \n",
       "21  (23.0, 44.0]    Golkar          2.0  Islam  non-dewan  eksternal   \n",
       "45  (23.0, 44.0]       PAN          8.0  Islam  non-dewan  eksternal   \n",
       "57  (23.0, 44.0]        PD          6.0  Islam  non-dewan  eksternal   \n",
       "\n",
       "   pendidikan_terakhir  cnt    p(A|B)    p(B|A)  \n",
       "7                 5_s2    5  0.066667  0.333333  \n",
       "67                5_s2    3  0.024390  0.200000  \n",
       "77                5_s2    3  0.052632  0.200000  \n",
       "21                5_s2    2  0.024096  0.133333  \n",
       "45                5_s2    1  0.023810  0.066667  \n",
       "57                5_s2    1  0.019608  0.066667  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## given my profile, which party has the best chance for me to be picked as one of their legislative :)\n",
    "c = profil_raw.groupby(['usia_kategori','partai', 'rank_partai', 'agama', 'is_dewan', 'is_kader', 'pendidikan_terakhir'])['noAnggota'].nunique().reset_index(name='cnt')\n",
    "c['p(A|B)'] = c['cnt'] / c.groupby('partai')['cnt'].transform('sum')\n",
    "c['p(B|A)'] =  c['cnt'] / c.groupby(['usia_kategori', 'agama','is_dewan', 'is_kader', 'pendidikan_terakhir'])['cnt'].transform('sum')\n",
    "\n",
    "d = c.sort_values(['agama', 'is_dewan', 'is_kader', 'pendidikan_terakhir', 'p(B|A)'], ascending=[True, False, False, True,False])\n",
    "d[(d.usia_kategori=='(23.0, 44.0]') & (d.agama=='Islam') & (d.is_dewan=='non-dewan') & (d.is_kader=='eksternal') & (d.pendidikan_terakhir=='5_s2')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.02697841726618705"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# probability of me being a legislative\n",
    "d[(d.usia_kategori=='(23.0, 44.0]') & (d.agama=='Islam') & (d.is_dewan=='non-dewan') & (d.is_kader=='eksternal') & (d.pendidikan_terakhir=='5_s2')].cnt.sum()/d.cnt.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>usia_kategori</th>\n",
       "      <th>agama</th>\n",
       "      <th>is_dewan</th>\n",
       "      <th>is_kader</th>\n",
       "      <th>pendidikan_terakhir</th>\n",
       "      <th>cnt</th>\n",
       "      <th>pct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>(44.0, 49.0]</td>\n",
       "      <td>Islam</td>\n",
       "      <td>dewan</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>16</td>\n",
       "      <td>0.028777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>(49.0, 55.0]</td>\n",
       "      <td>Islam</td>\n",
       "      <td>dewan</td>\n",
       "      <td>internal</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>15</td>\n",
       "      <td>0.026978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>(23.0, 44.0]</td>\n",
       "      <td>Islam</td>\n",
       "      <td>non-dewan</td>\n",
       "      <td>eksternal</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>15</td>\n",
       "      <td>0.026978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>(61.0, 81.0]</td>\n",
       "      <td>Islam</td>\n",
       "      <td>dewan</td>\n",
       "      <td>internal</td>\n",
       "      <td>4_s1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.025180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>(55.0, 61.0]</td>\n",
       "      <td>Islam</td>\n",
       "      <td>dewan</td>\n",
       "      <td>internal</td>\n",
       "      <td>5_s2</td>\n",
       "      <td>14</td>\n",
       "      <td>0.025180</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    usia_kategori  agama   is_dewan   is_kader pendidikan_terakhir  cnt  \\\n",
       "39   (44.0, 49.0]  Islam      dewan  eksternal                5_s2   16   \n",
       "71   (49.0, 55.0]  Islam      dewan   internal                5_s2   15   \n",
       "13   (23.0, 44.0]  Islam  non-dewan  eksternal                5_s2   15   \n",
       "130  (61.0, 81.0]  Islam      dewan   internal                4_s1   14   \n",
       "100  (55.0, 61.0]  Islam      dewan   internal                5_s2   14   \n",
       "\n",
       "          pct  \n",
       "39   0.028777  \n",
       "71   0.026978  \n",
       "13   0.026978  \n",
       "130  0.025180  \n",
       "100  0.025180  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# karakteristik anak soleh\n",
    "c = profil_raw.groupby(['usia_kategori', 'agama', 'is_dewan', 'is_kader', 'pendidikan_terakhir'])['noAnggota'].nunique().reset_index(name='cnt')\n",
    "c['pct'] = c['cnt'] / c['cnt'].sum()\n",
    "c.sort_values('cnt', ascending=False).head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Trivia\n",
    "* Anggota DPR yang disukai masyarakat: islam, pernah menjadi anggota dewan, kader partai, pendidikan minimal S2.  \n",
    "* Partai mana yang paling besar memungkinkan saya (<44 tahun, islam, non-dewan, eksternal, S2) lolos menjadi anggota DPR: Gerindra (33.3%)  \n",
    "* Probabilitas saya terpilih menjadi anggota DPR: 2.7%. Small but its actually joint second largest segment over all segments.\n",
    "* Karakteristik yang disukai masyarakat: islam, pernah menjabat sebagai anggota dewan, pendidikan minimal s2.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}