web scraping desa mandiri DPMPD Provinsi Kalimantan Timur.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Webscrapping data desa mandiri Provinsi Kalimantan Timur"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Berikut merupakan pengolahan data mengenai desa mandiri di provinsi Kalimantan Timur yang diambil dari website DPMPD Kalimantan Timur.\n",
    "Desa mandiri atau sangat maju merupakan desa maju yang memiliki kemampuan melaksanakan pembangunan desa untuk mnsejahterakan dan meningkatkan kualitas hidup masyarakatnya dengan ketahanan sosial, ketahanan ekonomi, dan ketahanan ekologgi yang berkelanjutan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import urllib.request\n",
    "from bs4 import BeautifulSoup\n",
    "from IPython.display import HTML"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "alamat = \"https://dpmpd.kaltimprov.go.id/desa/mandiri\"\n",
    "req = urllib.request.urlopen(alamat).read()\n",
    "data = BeautifulSoup(req, 'html.parser')\n",
    "table= data.find_all('div', {'class' : 'table-responsive'})[0] #line html tabel yang ingin diambil/discraping \n",
    "#(cara melihat : klik kanan mouse lalu klik inspect (Q))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<div class=\"table-responsive\">\n",
      "<table class=\"table table-bordered table-striped table-hover\" id=\"mytable\">\n",
      "<thead>\n",
      "<tr>\n",
      "<th style=\"max-width: 100px;\">No</th>\n",
      "<th>Kabupaten</th>\n",
      "<th>Kecamatan</th>\n",
      "<th>Desa / Kelurahan</th>\n",
      "<th>Strata</th>\n",
      "</tr>\n",
      "</thead>\n",
      "<tbody>\n",
      "<tr>\n",
      "<td class=\"text-center\">1</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>BATU SOPANG</td>\n",
      "<td>BATU KAJANG</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">2</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>BATU SOPANG</td>\n",
      "<td>SONGKA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">3</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>PASER BELENGKONG</td>\n",
      "<td>PASIR BELENGKONG</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">4</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>TANAH GROGOT</td>\n",
      "<td>PADANG PENGRAPAT</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">5</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>KUARO</td>\n",
      "<td>PADANG JAYA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">6</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>KUARO</td>\n",
      "<td>KLEMPANG SARI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">7</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>LONG IKIS</td>\n",
      "<td>TAJUR</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">8</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>LONG IKIS</td>\n",
      "<td>SAMUNTAI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">9</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>LONG IKIS</td>\n",
      "<td>PAIT</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">10</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>LONG IKIS</td>\n",
      "<td>JEMPARING</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">11</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>LONG IKIS</td>\n",
      "<td>BUKIT SALOKA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">12</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>LONG IKIS</td>\n",
      "<td>KRAYAN MAKMUR</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">13</td>\n",
      "<td>KABUPATEN PASER</td>\n",
      "<td>LONG IKIS</td>\n",
      "<td>ATANG PAIT</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">14</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>MUARA MUNTAI</td>\n",
      "<td>PERIAN</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">15</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>LOA KULU</td>\n",
      "<td>LOA KULU KOTA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">16</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>LOA KULU</td>\n",
      "<td>LOH SUMBER</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">17</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>LOA KULU</td>\n",
      "<td>PONORAGAN</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">18</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>LOA KULU</td>\n",
      "<td>REMPANGA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">19</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>LOA KULU</td>\n",
      "<td>SUMBER SARI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">20</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>LOA JANAN</td>\n",
      "<td>LOA DURI ULU</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">21</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>LOA JANAN</td>\n",
      "<td>LOA JANAN ULU</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">22</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>LOA JANAN</td>\n",
      "<td>BATUAH</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">23</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>LOA JANAN</td>\n",
      "<td>LOA DURI ILIR</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">24</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>ANGGANA</td>\n",
      "<td>SUNGAI MERIAM</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">25</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>MUARA BADAK</td>\n",
      "<td>BADAK BARU</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">26</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>MUARA BADAK</td>\n",
      "<td>GAS ALAM BADAK I</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">27</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>KOTA BANGUN</td>\n",
      "<td>KOTA BANGUN ULU</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">28</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>KEMBANG JANGGUT</td>\n",
      "<td>KEMBANG JANGGUT</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">29</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>MUARA KAMAN</td>\n",
      "<td>PANCA JAYA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">30</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>MUARA KAMAN</td>\n",
      "<td>BUNGA JADI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">31</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>TENGGARONG SEBERANG</td>\n",
      "<td>MANUNGGAL JAYA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">32</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>TENGGARONG SEBERANG</td>\n",
      "<td>EMBALUT</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">33</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>TENGGARONG SEBERANG</td>\n",
      "<td>BANGUN REJO</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">34</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>TENGGARONG SEBERANG</td>\n",
      "<td>BUANA JAYA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">35</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>TENGGARONG SEBERANG</td>\n",
      "<td>PERJIWA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">36</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>TENGGARONG SEBERANG</td>\n",
      "<td>TELUK DALAM</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">37</td>\n",
      "<td>KAB. KUTAI KARTANEGARA</td>\n",
      "<td>MARANG KAYU</td>\n",
      "<td>SEBUNTAL</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">38</td>\n",
      "<td>KABUPATEN BERAU</td>\n",
      "<td>TALISAYAN</td>\n",
      "<td>TALISAYAN</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">39</td>\n",
      "<td>KABUPATEN BERAU</td>\n",
      "<td>SAMBALIUNG</td>\n",
      "<td>PEGAT BUKUR</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">40</td>\n",
      "<td>KABUPATEN BERAU</td>\n",
      "<td>SAMBALIUNG</td>\n",
      "<td>SEI BEBANIR BANGUN</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">41</td>\n",
      "<td>KABUPATEN BERAU</td>\n",
      "<td>SAMBALIUNG</td>\n",
      "<td>GURIMBANG</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">42</td>\n",
      "<td>KABUPATEN BERAU</td>\n",
      "<td>SAMBALIUNG</td>\n",
      "<td>SUKAN TENGAH</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">43</td>\n",
      "<td>KABUPATEN BERAU</td>\n",
      "<td>PULAU DERAWAN</td>\n",
      "<td>TANJUNG BATU</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">44</td>\n",
      "<td>KABUPATEN BERAU</td>\n",
      "<td>PULAU DERAWAN</td>\n",
      "<td>PULAU DERAWAN</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">45</td>\n",
      "<td>KABUPATEN BERAU</td>\n",
      "<td>TELUK BAYUR</td>\n",
      "<td>LABANAN JAYA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">46</td>\n",
      "<td>KABUPATEN BERAU</td>\n",
      "<td>TELUK BAYUR</td>\n",
      "<td>LABANAN MAKMUR</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">47</td>\n",
      "<td>KABUPATEN BERAU</td>\n",
      "<td>BATU PUTIH</td>\n",
      "<td>TEMBUDAN</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">48</td>\n",
      "<td>KABUPATEN BERAU</td>\n",
      "<td>BATU PUTIH</td>\n",
      "<td>BATU PUTIH</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">49</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>LONG IRAM</td>\n",
      "<td>LONG IRAM KOTA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">50</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>LONG IRAM</td>\n",
      "<td>SUKOMULYO</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">51</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>BARONG TONGKOK</td>\n",
      "<td>MENCIMAI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">52</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>BARONG TONGKOK</td>\n",
      "<td>JUAQ ASA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">53</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>BARONG TONGKOK</td>\n",
      "<td>NGENYAN ASA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">54</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>BARONG TONGKOK</td>\n",
      "<td>REJO BASUKI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">55</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>BARONG TONGKOK</td>\n",
      "<td>SUMBER SARI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">56</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>BARONG TONGKOK</td>\n",
      "<td>SENDAWAR</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">57</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>DAMAI</td>\n",
      "<td>DAMAI KOTA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">58</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>MUARA LAWA</td>\n",
      "<td>MUARA LAWA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">59</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>MUARA LAWA</td>\n",
      "<td>LAMBING</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">60</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>BONGAN</td>\n",
      "<td>PENAWAI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">61</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>LINGGANG BIGUNG</td>\n",
      "<td>LINGGANG MELAPEH</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">62</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>LINGGANG BIGUNG</td>\n",
      "<td>LINGGANG MAPAN</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">63</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>LINGGANG BIGUNG</td>\n",
      "<td>LINGGANG BIGUNG</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">64</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>LINGGANG BIGUNG</td>\n",
      "<td>LINGGANG AMER</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">65</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>LINGGANG BIGUNG</td>\n",
      "<td>LINGGANG BANGUNSARI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">66</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>LINGGANG BIGUNG</td>\n",
      "<td>LINGGANG PURWODADI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">67</td>\n",
      "<td>KABUPATEN KUTAI BARAT</td>\n",
      "<td>SEKOLAQ DARAT</td>\n",
      "<td>SEKOLAQ DARAT</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">68</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>MUARA WAHAU</td>\n",
      "<td>WANASARI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">69</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>MUARA BENGKAL</td>\n",
      "<td>MUARA BENGKAL ILIR</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">70</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>MUARA BENGKAL</td>\n",
      "<td>MUARA BENGKAL ULU</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">71</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>MUARA BENGKAL</td>\n",
      "<td>BENUA BARU</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">72</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>SANGATTA UTARA</td>\n",
      "<td>SANGATTA UTARA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">73</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>SANGATTA UTARA</td>\n",
      "<td>SINGA GEMBARA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">74</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>SANGATTA UTARA</td>\n",
      "<td>SWARGA BARA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">75</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>SANGKULIRANG</td>\n",
      "<td>BENUA BARU</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">76</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>SANGKULIRANG</td>\n",
      "<td>BENUA BARU ULU</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">77</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>KOMBENG</td>\n",
      "<td>MARGA MULYA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">78</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>BENGALON</td>\n",
      "<td>SEPASO</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">79</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>SANGATTA SELATAN</td>\n",
      "<td>SANGATTA SELATAN</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">80</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>SANGATTA SELATAN</td>\n",
      "<td>SANGKIMA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">81</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>TELUK PANDAN</td>\n",
      "<td>SUKA RAHMAT</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">82</td>\n",
      "<td>KABUPATEN KUTAI TIMUR</td>\n",
      "<td>BATU AMPAR</td>\n",
      "<td>BATU TIMBAU</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">83</td>\n",
      "<td>KAB. PENAJAM PASER UTARA</td>\n",
      "<td>PENAJAM</td>\n",
      "<td>GIRI MUKTI</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">84</td>\n",
      "<td>KAB. PENAJAM PASER UTARA</td>\n",
      "<td>PENAJAM</td>\n",
      "<td>SIDOREJO</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">85</td>\n",
      "<td>KAB. PENAJAM PASER UTARA</td>\n",
      "<td>PENAJAM</td>\n",
      "<td>GIRI PURWA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">86</td>\n",
      "<td>KAB. PENAJAM PASER UTARA</td>\n",
      "<td>BABULU</td>\n",
      "<td>BABULU DARAT</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr><tr>\n",
      "<td class=\"text-center\">87</td>\n",
      "<td>KAB. PENAJAM PASER UTARA</td>\n",
      "<td>SEPAKU</td>\n",
      "<td>SUKA RAJA</td>\n",
      "<td>MANDIRI</td>\n",
      "</tr> </tbody>\n",
      "</table>\n",
      "</div>\n"
     ]
    }
   ],
   "source": [
    "print(table)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "rows = table.find_all('tr')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "#lakukan iterasi pada variabel row untuk memcah masing2 kolom menjadi sebuah list yg kemudian disimpan ke variabel hasil\n",
    "\n",
    "hasil= []\n",
    "\n",
    "for row in rows:\n",
    "    cols = row.find_all('td')\n",
    "    cols= [ele.text.strip() for ele in cols]\n",
    "    hasil.append(cols)"
   ]
  },
  {
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>KABUPATEN PASER</td>\n",
       "      <td>BATU SOPANG</td>\n",
       "      <td>BATU KAJANG</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>KABUPATEN PASER</td>\n",
       "      <td>BATU SOPANG</td>\n",
       "      <td>SONGKA</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>KABUPATEN PASER</td>\n",
       "      <td>PASER BELENGKONG</td>\n",
       "      <td>PASIR BELENGKONG</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>KABUPATEN PASER</td>\n",
       "      <td>TANAH GROGOT</td>\n",
       "      <td>PADANG PENGRAPAT</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>83</td>\n",
       "      <td>KAB. PENAJAM PASER UTARA</td>\n",
       "      <td>PENAJAM</td>\n",
       "      <td>GIRI MUKTI</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>84</td>\n",
       "      <td>KAB. PENAJAM PASER UTARA</td>\n",
       "      <td>PENAJAM</td>\n",
       "      <td>SIDOREJO</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>85</td>\n",
       "      <td>KAB. PENAJAM PASER UTARA</td>\n",
       "      <td>PENAJAM</td>\n",
       "      <td>GIRI PURWA</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>86</td>\n",
       "      <td>KAB. PENAJAM PASER UTARA</td>\n",
       "      <td>BABULU</td>\n",
       "      <td>BABULU DARAT</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>87</td>\n",
       "      <td>KAB. PENAJAM PASER UTARA</td>\n",
       "      <td>SEPAKU</td>\n",
       "      <td>SUKA RAJA</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>88 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       0                         1                 2                 3  \\\n",
       "0   None                      None              None              None   \n",
       "1      1           KABUPATEN PASER       BATU SOPANG       BATU KAJANG   \n",
       "2      2           KABUPATEN PASER       BATU SOPANG            SONGKA   \n",
       "3      3           KABUPATEN PASER  PASER BELENGKONG  PASIR BELENGKONG   \n",
       "4      4           KABUPATEN PASER      TANAH GROGOT  PADANG PENGRAPAT   \n",
       "..   ...                       ...               ...               ...   \n",
       "83    83  KAB. PENAJAM PASER UTARA           PENAJAM        GIRI MUKTI   \n",
       "84    84  KAB. PENAJAM PASER UTARA           PENAJAM          SIDOREJO   \n",
       "85    85  KAB. PENAJAM PASER UTARA           PENAJAM        GIRI PURWA   \n",
       "86    86  KAB. PENAJAM PASER UTARA            BABULU      BABULU DARAT   \n",
       "87    87  KAB. PENAJAM PASER UTARA            SEPAKU         SUKA RAJA   \n",
       "\n",
       "          4  \n",
       "0      None  \n",
       "1   MANDIRI  \n",
       "2   MANDIRI  \n",
       "3   MANDIRI  \n",
       "4   MANDIRI  \n",
       "..      ...  \n",
       "83  MANDIRI  \n",
       "84  MANDIRI  \n",
       "85  MANDIRI  \n",
       "86  MANDIRI  \n",
       "87  MANDIRI  \n",
       "\n",
       "[88 rows x 5 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_hasil = pd.DataFrame(hasil)\n",
    "df_hasil"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_hasil.columns= ['Kabupaten', 'Kecamatan', 'Desa/Kelurahan', 'Strata']"
   ]
  },
  {
   "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>Kabupaten</th>\n",
       "      <th>Kecamatan</th>\n",
       "      <th>Desa/Kelurahan</th>\n",
       "      <th>Strata</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>KABUPATEN PASER</td>\n",
       "      <td>BATU SOPANG</td>\n",
       "      <td>BATU KAJANG</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>KABUPATEN PASER</td>\n",
       "      <td>BATU SOPANG</td>\n",
       "      <td>SONGKA</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>KABUPATEN PASER</td>\n",
       "      <td>PASER BELENGKONG</td>\n",
       "      <td>PASIR BELENGKONG</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>KABUPATEN PASER</td>\n",
       "      <td>TANAH GROGOT</td>\n",
       "      <td>PADANG PENGRAPAT</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>KABUPATEN PASER</td>\n",
       "      <td>KUARO</td>\n",
       "      <td>PADANG JAYA</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>KAB. PENAJAM PASER UTARA</td>\n",
       "      <td>PENAJAM</td>\n",
       "      <td>GIRI MUKTI</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>KAB. PENAJAM PASER UTARA</td>\n",
       "      <td>PENAJAM</td>\n",
       "      <td>SIDOREJO</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>KAB. PENAJAM PASER UTARA</td>\n",
       "      <td>PENAJAM</td>\n",
       "      <td>GIRI PURWA</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>KAB. PENAJAM PASER UTARA</td>\n",
       "      <td>BABULU</td>\n",
       "      <td>BABULU DARAT</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>KAB. PENAJAM PASER UTARA</td>\n",
       "      <td>SEPAKU</td>\n",
       "      <td>SUKA RAJA</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>87 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Kabupaten         Kecamatan    Desa/Kelurahan   Strata\n",
       "1            KABUPATEN PASER       BATU SOPANG       BATU KAJANG  MANDIRI\n",
       "2            KABUPATEN PASER       BATU SOPANG            SONGKA  MANDIRI\n",
       "3            KABUPATEN PASER  PASER BELENGKONG  PASIR BELENGKONG  MANDIRI\n",
       "4            KABUPATEN PASER      TANAH GROGOT  PADANG PENGRAPAT  MANDIRI\n",
       "5            KABUPATEN PASER             KUARO       PADANG JAYA  MANDIRI\n",
       "..                       ...               ...               ...      ...\n",
       "83  KAB. PENAJAM PASER UTARA           PENAJAM        GIRI MUKTI  MANDIRI\n",
       "84  KAB. PENAJAM PASER UTARA           PENAJAM          SIDOREJO  MANDIRI\n",
       "85  KAB. PENAJAM PASER UTARA           PENAJAM        GIRI PURWA  MANDIRI\n",
       "86  KAB. PENAJAM PASER UTARA            BABULU      BABULU DARAT  MANDIRI\n",
       "87  KAB. PENAJAM PASER UTARA            SEPAKU         SUKA RAJA  MANDIRI\n",
       "\n",
       "[87 rows x 4 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_hasil"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_hasil.to_csv('data desa mandiri kaltim.csv', index=False) #menyimpan tabel ke file berekstensi csv"
   ]
  },
  {
   "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>Kabupaten</th>\n",
       "      <th>Kecamatan</th>\n",
       "      <th>Desa/Kelurahan</th>\n",
       "      <th>Strata</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>87</td>\n",
       "      <td>87</td>\n",
       "      <td>87</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>6</td>\n",
       "      <td>39</td>\n",
       "      <td>85</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>KAB. KUTAI KARTANEGARA</td>\n",
       "      <td>LONG IKIS</td>\n",
       "      <td>BENUA BARU</td>\n",
       "      <td>MANDIRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>24</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Kabupaten  Kecamatan Desa/Kelurahan   Strata\n",
       "count                       87         87             87       87\n",
       "unique                       6         39             85        1\n",
       "top     KAB. KUTAI KARTANEGARA  LONG IKIS     BENUA BARU  MANDIRI\n",
       "freq                        24          7              2       87"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_hasil.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MANDIRI    87\n",
       "Name: Strata, dtype: int64"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_hasil.Strata.value_counts() #menghitung keseluruhan desa mandiri di Kalimantan Timur"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "LONG IKIS              7\n",
       "LINGGANG BIGUNG        6\n",
       "BARONG TONGKOK         6\n",
       "TENGGARONG SEBERANG    6\n",
       "LOA KULU               5\n",
       "LOA JANAN              4\n",
       "SAMBALIUNG             4\n",
       "MUARA BENGKAL          3\n",
       "PENAJAM                3\n",
       "SANGATTA UTARA         3\n",
       "MUARA LAWA             2\n",
       "LONG IRAM              2\n",
       "SANGKULIRANG           2\n",
       "SANGATTA SELATAN       2\n",
       "TELUK BAYUR            2\n",
       "MUARA KAMAN            2\n",
       "PULAU DERAWAN          2\n",
       "KUARO                  2\n",
       "BATU PUTIH             2\n",
       "BATU SOPANG            2\n",
       "MUARA BADAK            2\n",
       "BABULU                 1\n",
       "MUARA WAHAU            1\n",
       "TALISAYAN              1\n",
       "SEKOLAQ DARAT          1\n",
       "KEMBANG JANGGUT        1\n",
       "TELUK PANDAN           1\n",
       "MUARA MUNTAI           1\n",
       "PASER BELENGKONG       1\n",
       "DAMAI                  1\n",
       "KOTA BANGUN            1\n",
       "TANAH GROGOT           1\n",
       "SEPAKU                 1\n",
       "KOMBENG                1\n",
       "ANGGANA                1\n",
       "BATU AMPAR             1\n",
       "BENGALON               1\n",
       "BONGAN                 1\n",
       "MARANG KAYU            1\n",
       "Name: Kecamatan, dtype: int64"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_hasil.Kecamatan.value_counts() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "KAB. KUTAI KARTANEGARA      24\n",
       "KABUPATEN KUTAI BARAT       19\n",
       "KABUPATEN KUTAI TIMUR       15\n",
       "KABUPATEN PASER             13\n",
       "KABUPATEN BERAU             11\n",
       "KAB. PENAJAM PASER UTARA     5\n",
       "Name: Kabupaten, dtype: int64"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_hasil.Kabupaten.value_counts() #menghitung sebaran desa mandiri di tiap kabupaten di kalimantan timur"
   ]
  },
  {
   "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}