tableScarppingofHTML.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import lxml.html as lh\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'list' object has no attribute 'strip'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-52-cddf8b7a9e25>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      5\u001b[0m \u001b[0mdoc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mlh\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfromstring\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mpage\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcontent\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      6\u001b[0m \u001b[0;31m#Parse data that are stored between <tr>..</tr> of HTML\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 7\u001b[0;31m \u001b[0mtr_elements\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdoc\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mxpath\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'//tr'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstrip\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mTrue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m: 'list' object has no attribute 'strip'"
     ]
    }
   ],
   "source": [
    "url='http://vinanet.vn/thuong-mai-cha/xuat-khau-thuy-san-4-thang-dau-nam-2020-sut-giam-o-da-so-cac-thi-truong-729062.html'\n",
    "#Create a handle, page, to handle the contents of the website\n",
    "page = requests.get(url)\n",
    "#Store the contents of the website under doc\n",
    "doc = lh.fromstring(page.content)\n",
    "#Parse data that are stored between <tr>..</tr> of HTML\n",
    "tr_elements = doc.xpath('//tr')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Check the length of the first 12 rows\n",
    "[len(T) for T in tr_elements[:20]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "tr_elements = doc.xpath('//tr')\n",
    "#Create empty list\n",
    "col=[]\n",
    "i=0\n",
    "#For each row, store each first element (header) and an empty list\n",
    "for t in tr_elements[0]:\n",
    "    i+=1\n",
    "    name=t.text_content()\n",
    "    #print '%d:\"%s\"'%(i,name)\n",
    "    col.append((name,[]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Since out first row is the header, data is stored on the second row onwards\n",
    "for j in range(1,len(tr_elements)):\n",
    "    #T is our j'th row\n",
    "    T=tr_elements[j]\n",
    "    \n",
    "    #If row is not of size 6, the //tr data is not from our table \n",
    "    if len(T)!=6:\n",
    "        break\n",
    "    \n",
    "    #i is the index of our column\n",
    "    i=0\n",
    "    \n",
    "    #Iterate through each element of the row\n",
    "    for t in T.iterchildren():\n",
    "        data=t.text_content() \n",
    "        #Check if row is empty\n",
    "        if i>0:\n",
    "        #Convert any numerical value to integers\n",
    "            try:\n",
    "                data=int(data)\n",
    "            except:\n",
    "                pass\n",
    "        #Append the data to the empty list of the i'th column\n",
    "        col[i][1].append(data)\n",
    "        #Increment i for the next column\n",
    "        i+=1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[54, 54, 54, 54, 54, 54]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[len(C) for (title,C) in col]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "Dict={title:column for (title,column) in col}\n",
    "df=pd.DataFrame(Dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>\\r\\n            Thị trường\\r\\n</th>\n",
       "      <th>\\r\\n            T4/2020\\r\\n</th>\n",
       "      <th>\\r\\n            +/- so với tháng 3/2020 (%)\\r\\n</th>\n",
       "      <th>\\r\\n            4T/2020\\r\\n</th>\n",
       "      <th>\\r\\n            +/- so với cùng kỳ năm 2019 (%)\\r\\n</th>\n",
       "      <th>\\r\\n            Tỷ trọng (%)\\r\\n</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>\\r\\n            Tổng kim ngạch XK\\r\\n</td>\n",
       "      <td>\\r\\n            616.918.921\\r\\n</td>\n",
       "      <td>\\r\\n            -1,92\\r\\n</td>\n",
       "      <td>\\r\\n            2.226.772.128\\r\\n</td>\n",
       "      <td>\\r\\n            -8,10\\r\\n</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>\\r\\n            Nhật Bản\\r\\n</td>\n",
       "      <td>\\r\\n            121.117.534\\r\\n</td>\n",
       "      <td>\\r\\n            -5,82\\r\\n</td>\n",
       "      <td>\\r\\n            434.385.160\\r\\n</td>\n",
       "      <td>\\r\\n            5,64\\r\\n</td>\n",
       "      <td>\\r\\n            19,51\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\\r\\n            Mỹ\\r\\n</td>\n",
       "      <td>\\r\\n            91.000.481\\r\\n</td>\n",
       "      <td>\\r\\n            -14,93\\r\\n</td>\n",
       "      <td>\\r\\n            377.475.117\\r\\n</td>\n",
       "      <td>\\r\\n            -2,09\\r\\n</td>\n",
       "      <td>\\r\\n            16,95\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>\\r\\n            EU\\r\\n</td>\n",
       "      <td>\\r\\n            90.692.738\\r\\n</td>\n",
       "      <td>\\r\\n            1,97\\r\\n</td>\n",
       "      <td>\\r\\n            322.339.637\\r\\n</td>\n",
       "      <td>\\r\\n            -14,8\\r\\n</td>\n",
       "      <td>\\r\\n            14,48\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>\\r\\n            Trung Quốc\\r\\n</td>\n",
       "      <td>\\r\\n            109.387.968\\r\\n</td>\n",
       "      <td>\\r\\n            34,76\\r\\n</td>\n",
       "      <td>\\r\\n            246.264.406\\r\\n</td>\n",
       "      <td>\\r\\n            -7,96\\r\\n</td>\n",
       "      <td>\\r\\n            11,06\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>\\r\\n            Hàn Quốc\\r\\n</td>\n",
       "      <td>\\r\\n            62.521.999\\r\\n</td>\n",
       "      <td>\\r\\n            9,79\\r\\n</td>\n",
       "      <td>\\r\\n            216.437.665\\r\\n</td>\n",
       "      <td>\\r\\n            -8,78\\r\\n</td>\n",
       "      <td>\\r\\n            9,72\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>\\r\\n            Anh\\r\\n</td>\n",
       "      <td>\\r\\n            22.657.352\\r\\n</td>\n",
       "      <td>\\r\\n            2,52\\r\\n</td>\n",
       "      <td>\\r\\n            79.085.768\\r\\n</td>\n",
       "      <td>\\r\\n            3,35\\r\\n</td>\n",
       "      <td>\\r\\n            3,55\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>\\r\\n            Thái Lan\\r\\n</td>\n",
       "      <td>\\r\\n            16.169.940\\r\\n</td>\n",
       "      <td>\\r\\n            -12,43\\r\\n</td>\n",
       "      <td>\\r\\n            74.241.916\\r\\n</td>\n",
       "      <td>\\r\\n            -14,16\\r\\n</td>\n",
       "      <td>\\r\\n            3,33\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>\\r\\n            Canada\\r\\n</td>\n",
       "      <td>\\r\\n            18.800.992\\r\\n</td>\n",
       "      <td>\\r\\n            -12,07\\r\\n</td>\n",
       "      <td>\\r\\n            71.860.397\\r\\n</td>\n",
       "      <td>\\r\\n            12,1\\r\\n</td>\n",
       "      <td>\\r\\n            3,23\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>\\r\\n            Hà Lan\\r\\n</td>\n",
       "      <td>\\r\\n            17.746.166\\r\\n</td>\n",
       "      <td>\\r\\n            -1,81\\r\\n</td>\n",
       "      <td>\\r\\n            57.984.683\\r\\n</td>\n",
       "      <td>\\r\\n            -17,4\\r\\n</td>\n",
       "      <td>\\r\\n            2,6\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>\\r\\n            Australia\\r\\n</td>\n",
       "      <td>\\r\\n            9.748.549\\r\\n</td>\n",
       "      <td>\\r\\n            -43,14\\r\\n</td>\n",
       "      <td>\\r\\n            55.235.560\\r\\n</td>\n",
       "      <td>\\r\\n            -7,41\\r\\n</td>\n",
       "      <td>\\r\\n            2,48\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>\\r\\n            Đức\\r\\n</td>\n",
       "      <td>\\r\\n            14.209.890\\r\\n</td>\n",
       "      <td>\\r\\n            20,84\\r\\n</td>\n",
       "      <td>\\r\\n            46.744.382\\r\\n</td>\n",
       "      <td>\\r\\n            -19,47\\r\\n</td>\n",
       "      <td>\\r\\n            2,1\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>\\r\\n            Nga\\r\\n</td>\n",
       "      <td>\\r\\n            11.656.695\\r\\n</td>\n",
       "      <td>\\r\\n            2,76\\r\\n</td>\n",
       "      <td>\\r\\n            38.062.146\\r\\n</td>\n",
       "      <td>\\r\\n            15,64\\r\\n</td>\n",
       "      <td>\\r\\n            1,71\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>\\r\\n            Hồng Kông (TQ)\\r\\n</td>\n",
       "      <td>\\r\\n            9.141.062\\r\\n</td>\n",
       "      <td>\\r\\n            13,12\\r\\n</td>\n",
       "      <td>\\r\\n            37.106.104\\r\\n</td>\n",
       "      <td>\\r\\n            -29,52\\r\\n</td>\n",
       "      <td>\\r\\n            1,67\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>\\r\\n            Bỉ\\r\\n</td>\n",
       "      <td>\\r\\n            9.985.721\\r\\n</td>\n",
       "      <td>\\r\\n            -1,05\\r\\n</td>\n",
       "      <td>\\r\\n            36.005.230\\r\\n</td>\n",
       "      <td>\\r\\n            -5,41\\r\\n</td>\n",
       "      <td>\\r\\n            1,62\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>\\r\\n            Malaysia\\r\\n</td>\n",
       "      <td>\\r\\n            8.289.985\\r\\n</td>\n",
       "      <td>\\r\\n            -4,84\\r\\n</td>\n",
       "      <td>\\r\\n            33.794.451\\r\\n</td>\n",
       "      <td>\\r\\n            -20,28\\r\\n</td>\n",
       "      <td>\\r\\n            1,52\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>\\r\\n            Singapore\\r\\n</td>\n",
       "      <td>\\r\\n            12.843.379\\r\\n</td>\n",
       "      <td>\\r\\n            81,04\\r\\n</td>\n",
       "      <td>\\r\\n            31.985.217\\r\\n</td>\n",
       "      <td>\\r\\n            -0,59\\r\\n</td>\n",
       "      <td>\\r\\n            1,44\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>\\r\\n            Đài Loan (TQ)\\r\\n</td>\n",
       "      <td>\\r\\n            7.112.383\\r\\n</td>\n",
       "      <td>\\r\\n            -16,01\\r\\n</td>\n",
       "      <td>\\r\\n            29.303.669\\r\\n</td>\n",
       "      <td>\\r\\n            -18,11\\r\\n</td>\n",
       "      <td>\\r\\n            1,32\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>\\r\\n            Philippines\\r\\n</td>\n",
       "      <td>\\r\\n            2.591.027\\r\\n</td>\n",
       "      <td>\\r\\n            -50,97\\r\\n</td>\n",
       "      <td>\\r\\n            24.175.358\\r\\n</td>\n",
       "      <td>\\r\\n            -34,43\\r\\n</td>\n",
       "      <td>\\r\\n            1,09\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>\\r\\n            Italia\\r\\n</td>\n",
       "      <td>\\r\\n            6.963.254\\r\\n</td>\n",
       "      <td>\\r\\n            33,41\\r\\n</td>\n",
       "      <td>\\r\\n            21.959.958\\r\\n</td>\n",
       "      <td>\\r\\n            -31,98\\r\\n</td>\n",
       "      <td>\\r\\n            0,99\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>\\r\\n            Campuchia\\r\\n</td>\n",
       "      <td>\\r\\n            3.914.034\\r\\n</td>\n",
       "      <td>\\r\\n            -45,68\\r\\n</td>\n",
       "      <td>\\r\\n            21.784.722\\r\\n</td>\n",
       "      <td>\\r\\n            190,34\\r\\n</td>\n",
       "      <td>\\r\\n            0,98\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>\\r\\n            Mexico\\r\\n</td>\n",
       "      <td>\\r\\n            2.230.605\\r\\n</td>\n",
       "      <td>\\r\\n            -57,38\\r\\n</td>\n",
       "      <td>\\r\\n            20.804.541\\r\\n</td>\n",
       "      <td>\\r\\n            -55,64\\r\\n</td>\n",
       "      <td>\\r\\n            0,93\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>\\r\\n            Pháp\\r\\n</td>\n",
       "      <td>\\r\\n            4.620.215\\r\\n</td>\n",
       "      <td>\\r\\n            -3,61\\r\\n</td>\n",
       "      <td>\\r\\n            20.065.325\\r\\n</td>\n",
       "      <td>\\r\\n            -36,26\\r\\n</td>\n",
       "      <td>\\r\\n            0,9\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>\\r\\n            Tây Ban Nha\\r\\n</td>\n",
       "      <td>\\r\\n            5.249.706\\r\\n</td>\n",
       "      <td>\\r\\n            7,63\\r\\n</td>\n",
       "      <td>\\r\\n            17.852.271\\r\\n</td>\n",
       "      <td>\\r\\n            -26,21\\r\\n</td>\n",
       "      <td>\\r\\n            0,8\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>\\r\\n            U.A.E\\r\\n</td>\n",
       "      <td>\\r\\n            3.511.794\\r\\n</td>\n",
       "      <td>\\r\\n            -14,61\\r\\n</td>\n",
       "      <td>\\r\\n            16.657.745\\r\\n</td>\n",
       "      <td>\\r\\n            -12,14\\r\\n</td>\n",
       "      <td>\\r\\n            0,75\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>\\r\\n            Brazil\\r\\n</td>\n",
       "      <td>\\r\\n            521.354\\r\\n</td>\n",
       "      <td>\\r\\n            -81,48\\r\\n</td>\n",
       "      <td>\\r\\n            16.164.806\\r\\n</td>\n",
       "      <td>\\r\\n            -31,07\\r\\n</td>\n",
       "      <td>\\r\\n            0,73\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>\\r\\n            Israel\\r\\n</td>\n",
       "      <td>\\r\\n            2.157.139\\r\\n</td>\n",
       "      <td>\\r\\n            -51,05\\r\\n</td>\n",
       "      <td>\\r\\n            14.952.096\\r\\n</td>\n",
       "      <td>\\r\\n            -36,29\\r\\n</td>\n",
       "      <td>\\r\\n            0,67\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>\\r\\n            Đan Mạch\\r\\n</td>\n",
       "      <td>\\r\\n            3.764.123\\r\\n</td>\n",
       "      <td>\\r\\n            3,23\\r\\n</td>\n",
       "      <td>\\r\\n            12.851.798\\r\\n</td>\n",
       "      <td>\\r\\n            3,64\\r\\n</td>\n",
       "      <td>\\r\\n            0,58\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>\\r\\n            Bồ Đào Nha\\r\\n</td>\n",
       "      <td>\\r\\n            2.650.843\\r\\n</td>\n",
       "      <td>\\r\\n            -22,13\\r\\n</td>\n",
       "      <td>\\r\\n            12.010.712\\r\\n</td>\n",
       "      <td>\\r\\n            -25,68\\r\\n</td>\n",
       "      <td>\\r\\n            0,54\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>\\r\\n            Colombia\\r\\n</td>\n",
       "      <td>\\r\\n            682.543\\r\\n</td>\n",
       "      <td>\\r\\n            -72,74\\r\\n</td>\n",
       "      <td>\\r\\n            10.783.737\\r\\n</td>\n",
       "      <td>\\r\\n            -29,81\\r\\n</td>\n",
       "      <td>\\r\\n            0,48\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>\\r\\n            Ai Cập\\r\\n</td>\n",
       "      <td>\\r\\n            2.317.620\\r\\n</td>\n",
       "      <td>\\r\\n            -15,23\\r\\n</td>\n",
       "      <td>\\r\\n            10.259.015\\r\\n</td>\n",
       "      <td>\\r\\n            -28,97\\r\\n</td>\n",
       "      <td>\\r\\n            0,46\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>\\r\\n            Ukraine\\r\\n</td>\n",
       "      <td>\\r\\n            2.461.847\\r\\n</td>\n",
       "      <td>\\r\\n            -20,74\\r\\n</td>\n",
       "      <td>\\r\\n            9.658.514\\r\\n</td>\n",
       "      <td>\\r\\n            35,84\\r\\n</td>\n",
       "      <td>\\r\\n            0,43\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>\\r\\n            Thụy Sỹ\\r\\n</td>\n",
       "      <td>\\r\\n            4.250.044\\r\\n</td>\n",
       "      <td>\\r\\n            40,94\\r\\n</td>\n",
       "      <td>\\r\\n            9.399.712\\r\\n</td>\n",
       "      <td>\\r\\n            9,24\\r\\n</td>\n",
       "      <td>\\r\\n            0,42\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>\\r\\n            Ba Lan\\r\\n</td>\n",
       "      <td>\\r\\n            1.327.707\\r\\n</td>\n",
       "      <td>\\r\\n            -45,92\\r\\n</td>\n",
       "      <td>\\r\\n            8.706.691\\r\\n</td>\n",
       "      <td>\\r\\n            21,79\\r\\n</td>\n",
       "      <td>\\r\\n            0,39\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>\\r\\n            Ấn Độ\\r\\n</td>\n",
       "      <td>\\r\\n            27.534\\r\\n</td>\n",
       "      <td>\\r\\n            -98,1\\r\\n</td>\n",
       "      <td>\\r\\n            5.189.665\\r\\n</td>\n",
       "      <td>\\r\\n            -41,29\\r\\n</td>\n",
       "      <td>\\r\\n            0,23\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>\\r\\n            New Zealand\\r\\n</td>\n",
       "      <td>\\r\\n            1.061.732\\r\\n</td>\n",
       "      <td>\\r\\n            -21,7\\r\\n</td>\n",
       "      <td>\\r\\n            4.620.400\\r\\n</td>\n",
       "      <td>\\r\\n            -29,68\\r\\n</td>\n",
       "      <td>\\r\\n            0,21\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>\\r\\n            Pê Ru\\r\\n</td>\n",
       "      <td>\\r\\n            600.191\\r\\n</td>\n",
       "      <td>\\r\\n            -10,03\\r\\n</td>\n",
       "      <td>\\r\\n            3.915.658\\r\\n</td>\n",
       "      <td>26</td>\n",
       "      <td>\\r\\n            0,18\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>\\r\\n            Chile\\r\\n</td>\n",
       "      <td>\\r\\n            1.172.336\\r\\n</td>\n",
       "      <td>\\r\\n            43,32\\r\\n</td>\n",
       "      <td>\\r\\n            3.760.994\\r\\n</td>\n",
       "      <td>\\r\\n            -33,54\\r\\n</td>\n",
       "      <td>\\r\\n            0,17\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>\\r\\n            Thụy Điển\\r\\n</td>\n",
       "      <td>\\r\\n            584.320\\r\\n</td>\n",
       "      <td>\\r\\n            -40,71\\r\\n</td>\n",
       "      <td>\\r\\n            3.367.449\\r\\n</td>\n",
       "      <td>\\r\\n            -27,88\\r\\n</td>\n",
       "      <td>\\r\\n            0,15\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>\\r\\n            Na Uy\\r\\n</td>\n",
       "      <td>\\r\\n            691.119\\r\\n</td>\n",
       "      <td>\\r\\n            -3,96\\r\\n</td>\n",
       "      <td>\\r\\n            2.710.899\\r\\n</td>\n",
       "      <td>\\r\\n            30,52\\r\\n</td>\n",
       "      <td>\\r\\n            0,12\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>\\r\\n            Thổ Nhĩ Kỳ\\r\\n</td>\n",
       "      <td>\\r\\n            319.527\\r\\n</td>\n",
       "      <td>\\r\\n            -58,76\\r\\n</td>\n",
       "      <td>\\r\\n            2.684.395\\r\\n</td>\n",
       "      <td>\\r\\n            -19,35\\r\\n</td>\n",
       "      <td>\\r\\n            0,12\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>\\r\\n            Romania\\r\\n</td>\n",
       "      <td>\\r\\n            364.053\\r\\n</td>\n",
       "      <td>\\r\\n            -52,3\\r\\n</td>\n",
       "      <td>\\r\\n            2.668.243\\r\\n</td>\n",
       "      <td>\\r\\n            6,89\\r\\n</td>\n",
       "      <td>\\r\\n            0,12\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>\\r\\n            Pakistan\\r\\n</td>\n",
       "      <td>\\r\\n            592.227\\r\\n</td>\n",
       "      <td>\\r\\n            1,752,45\\r\\n</td>\n",
       "      <td>\\r\\n            2.606.980\\r\\n</td>\n",
       "      <td>\\r\\n            13,02\\r\\n</td>\n",
       "      <td>\\r\\n            0,12\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>\\r\\n            Algeria\\r\\n</td>\n",
       "      <td>\\r\\n            609.165\\r\\n</td>\n",
       "      <td>\\r\\n            158,1\\r\\n</td>\n",
       "      <td>\\r\\n            2.460.687\\r\\n</td>\n",
       "      <td>\\r\\n            -20,72\\r\\n</td>\n",
       "      <td>\\r\\n            0,11\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>\\r\\n            Hy Lạp\\r\\n</td>\n",
       "      <td>\\r\\n            434.116\\r\\n</td>\n",
       "      <td>\\r\\n            -21,1\\r\\n</td>\n",
       "      <td>\\r\\n            2.118.817\\r\\n</td>\n",
       "      <td>\\r\\n            -37,95\\r\\n</td>\n",
       "      <td>\\r\\n            0,1\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>\\r\\n            Kuwait\\r\\n</td>\n",
       "      <td>\\r\\n            630.133\\r\\n</td>\n",
       "      <td>\\r\\n            49,54\\r\\n</td>\n",
       "      <td>\\r\\n            2.020.578\\r\\n</td>\n",
       "      <td>\\r\\n            -23,46\\r\\n</td>\n",
       "      <td>\\r\\n            0,09\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>\\r\\n            Iraq\\r\\n</td>\n",
       "      <td>\\r\\n            566.024\\r\\n</td>\n",
       "      <td>\\r\\n            69,45\\r\\n</td>\n",
       "      <td>\\r\\n            1.645.796\\r\\n</td>\n",
       "      <td>\\r\\n            -55,51\\r\\n</td>\n",
       "      <td>\\r\\n            0,07\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>\\r\\n            Panama\\r\\n</td>\n",
       "      <td>\\r\\n            235.390\\r\\n</td>\n",
       "      <td>\\r\\n            -44,61\\r\\n</td>\n",
       "      <td>\\r\\n            1.543.001\\r\\n</td>\n",
       "      <td>\\r\\n            -30,04\\r\\n</td>\n",
       "      <td>\\r\\n            0,07\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>\\r\\n            Sri Lanka\\r\\n</td>\n",
       "      <td>\\r\\n            445.880\\r\\n</td>\n",
       "      <td>\\r\\n            -4,05\\r\\n</td>\n",
       "      <td>\\r\\n            1.141.768\\r\\n</td>\n",
       "      <td>\\r\\n            -45,88\\r\\n</td>\n",
       "      <td>\\r\\n            0,05\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>\\r\\n            Séc\\r\\n</td>\n",
       "      <td>\\r\\n            135.272\\r\\n</td>\n",
       "      <td>\\r\\n            -38,11\\r\\n</td>\n",
       "      <td>\\r\\n            918.310\\r\\n</td>\n",
       "      <td>\\r\\n            -25,93\\r\\n</td>\n",
       "      <td>\\r\\n            0,04\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>\\r\\n            Indonesia\\r\\n</td>\n",
       "      <td>\\r\\n             \\r\\n</td>\n",
       "      <td>-100</td>\n",
       "      <td>\\r\\n            803.754\\r\\n</td>\n",
       "      <td>\\r\\n            -34,62\\r\\n</td>\n",
       "      <td>\\r\\n            0,04\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>\\r\\n            Brunei\\r\\n</td>\n",
       "      <td>\\r\\n            131.246\\r\\n</td>\n",
       "      <td>\\r\\n            -10,92\\r\\n</td>\n",
       "      <td>\\r\\n            492.595\\r\\n</td>\n",
       "      <td>\\r\\n            -26,34\\r\\n</td>\n",
       "      <td>\\r\\n            0,02\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>\\r\\n            Angola\\r\\n</td>\n",
       "      <td>\\r\\n            66.936\\r\\n</td>\n",
       "      <td>\\r\\n            123,43\\r\\n</td>\n",
       "      <td>\\r\\n            273.034\\r\\n</td>\n",
       "      <td>\\r\\n            -29,71\\r\\n</td>\n",
       "      <td>\\r\\n            0,01\\r\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>\\r\\n            Senegal\\r\\n</td>\n",
       "      <td>\\r\\n            69.100\\r\\n</td>\n",
       "      <td>\\r\\n            -5,51\\r\\n</td>\n",
       "      <td>\\r\\n            256.334\\r\\n</td>\n",
       "      <td>\\r\\n            -42,58\\r\\n</td>\n",
       "      <td>\\r\\n            0,01\\r\\n</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           \\r\\n            Thị trường\\r\\n              \\\n",
       "0   \\r\\n            Tổng kim ngạch XK\\r\\n               \n",
       "1            \\r\\n            Nhật Bản\\r\\n               \n",
       "2                  \\r\\n            Mỹ\\r\\n               \n",
       "3                  \\r\\n            EU\\r\\n               \n",
       "4          \\r\\n            Trung Quốc\\r\\n               \n",
       "5            \\r\\n            Hàn Quốc\\r\\n               \n",
       "6                 \\r\\n            Anh\\r\\n               \n",
       "7            \\r\\n            Thái Lan\\r\\n               \n",
       "8              \\r\\n            Canada\\r\\n               \n",
       "9              \\r\\n            Hà Lan\\r\\n               \n",
       "10          \\r\\n            Australia\\r\\n               \n",
       "11                \\r\\n            Đức\\r\\n               \n",
       "12                \\r\\n            Nga\\r\\n               \n",
       "13     \\r\\n            Hồng Kông (TQ)\\r\\n               \n",
       "14                 \\r\\n            Bỉ\\r\\n               \n",
       "15           \\r\\n            Malaysia\\r\\n               \n",
       "16          \\r\\n            Singapore\\r\\n               \n",
       "17      \\r\\n            Đài Loan (TQ)\\r\\n               \n",
       "18        \\r\\n            Philippines\\r\\n               \n",
       "19             \\r\\n            Italia\\r\\n               \n",
       "20          \\r\\n            Campuchia\\r\\n               \n",
       "21             \\r\\n            Mexico\\r\\n               \n",
       "22               \\r\\n            Pháp\\r\\n               \n",
       "23        \\r\\n            Tây Ban Nha\\r\\n               \n",
       "24              \\r\\n            U.A.E\\r\\n               \n",
       "25             \\r\\n            Brazil\\r\\n               \n",
       "26             \\r\\n            Israel\\r\\n               \n",
       "27           \\r\\n            Đan Mạch\\r\\n               \n",
       "28         \\r\\n            Bồ Đào Nha\\r\\n               \n",
       "29           \\r\\n            Colombia\\r\\n               \n",
       "30             \\r\\n            Ai Cập\\r\\n               \n",
       "31            \\r\\n            Ukraine\\r\\n               \n",
       "32            \\r\\n            Thụy Sỹ\\r\\n               \n",
       "33             \\r\\n            Ba Lan\\r\\n               \n",
       "34              \\r\\n            Ấn Độ\\r\\n               \n",
       "35        \\r\\n            New Zealand\\r\\n               \n",
       "36              \\r\\n            Pê Ru\\r\\n               \n",
       "37              \\r\\n            Chile\\r\\n               \n",
       "38          \\r\\n            Thụy Điển\\r\\n               \n",
       "39              \\r\\n            Na Uy\\r\\n               \n",
       "40         \\r\\n            Thổ Nhĩ Kỳ\\r\\n               \n",
       "41            \\r\\n            Romania\\r\\n               \n",
       "42           \\r\\n            Pakistan\\r\\n               \n",
       "43            \\r\\n            Algeria\\r\\n               \n",
       "44             \\r\\n            Hy Lạp\\r\\n               \n",
       "45             \\r\\n            Kuwait\\r\\n               \n",
       "46               \\r\\n            Iraq\\r\\n               \n",
       "47             \\r\\n            Panama\\r\\n               \n",
       "48          \\r\\n            Sri Lanka\\r\\n               \n",
       "49                \\r\\n            Séc\\r\\n               \n",
       "50          \\r\\n            Indonesia\\r\\n               \n",
       "51             \\r\\n            Brunei\\r\\n               \n",
       "52             \\r\\n            Angola\\r\\n               \n",
       "53            \\r\\n            Senegal\\r\\n               \n",
       "\n",
       "        \\r\\n            T4/2020\\r\\n              \\\n",
       "0   \\r\\n            616.918.921\\r\\n               \n",
       "1   \\r\\n            121.117.534\\r\\n               \n",
       "2    \\r\\n            91.000.481\\r\\n               \n",
       "3    \\r\\n            90.692.738\\r\\n               \n",
       "4   \\r\\n            109.387.968\\r\\n               \n",
       "5    \\r\\n            62.521.999\\r\\n               \n",
       "6    \\r\\n            22.657.352\\r\\n               \n",
       "7    \\r\\n            16.169.940\\r\\n               \n",
       "8    \\r\\n            18.800.992\\r\\n               \n",
       "9    \\r\\n            17.746.166\\r\\n               \n",
       "10    \\r\\n            9.748.549\\r\\n               \n",
       "11   \\r\\n            14.209.890\\r\\n               \n",
       "12   \\r\\n            11.656.695\\r\\n               \n",
       "13    \\r\\n            9.141.062\\r\\n               \n",
       "14    \\r\\n            9.985.721\\r\\n               \n",
       "15    \\r\\n            8.289.985\\r\\n               \n",
       "16   \\r\\n            12.843.379\\r\\n               \n",
       "17    \\r\\n            7.112.383\\r\\n               \n",
       "18    \\r\\n            2.591.027\\r\\n               \n",
       "19    \\r\\n            6.963.254\\r\\n               \n",
       "20    \\r\\n            3.914.034\\r\\n               \n",
       "21    \\r\\n            2.230.605\\r\\n               \n",
       "22    \\r\\n            4.620.215\\r\\n               \n",
       "23    \\r\\n            5.249.706\\r\\n               \n",
       "24    \\r\\n            3.511.794\\r\\n               \n",
       "25      \\r\\n            521.354\\r\\n               \n",
       "26    \\r\\n            2.157.139\\r\\n               \n",
       "27    \\r\\n            3.764.123\\r\\n               \n",
       "28    \\r\\n            2.650.843\\r\\n               \n",
       "29      \\r\\n            682.543\\r\\n               \n",
       "30    \\r\\n            2.317.620\\r\\n               \n",
       "31    \\r\\n            2.461.847\\r\\n               \n",
       "32    \\r\\n            4.250.044\\r\\n               \n",
       "33    \\r\\n            1.327.707\\r\\n               \n",
       "34       \\r\\n            27.534\\r\\n               \n",
       "35    \\r\\n            1.061.732\\r\\n               \n",
       "36      \\r\\n            600.191\\r\\n               \n",
       "37    \\r\\n            1.172.336\\r\\n               \n",
       "38      \\r\\n            584.320\\r\\n               \n",
       "39      \\r\\n            691.119\\r\\n               \n",
       "40      \\r\\n            319.527\\r\\n               \n",
       "41      \\r\\n            364.053\\r\\n               \n",
       "42      \\r\\n            592.227\\r\\n               \n",
       "43      \\r\\n            609.165\\r\\n               \n",
       "44      \\r\\n            434.116\\r\\n               \n",
       "45      \\r\\n            630.133\\r\\n               \n",
       "46      \\r\\n            566.024\\r\\n               \n",
       "47      \\r\\n            235.390\\r\\n               \n",
       "48      \\r\\n            445.880\\r\\n               \n",
       "49      \\r\\n            135.272\\r\\n               \n",
       "50            \\r\\n             \\r\\n               \n",
       "51      \\r\\n            131.246\\r\\n               \n",
       "52       \\r\\n            66.936\\r\\n               \n",
       "53       \\r\\n            69.100\\r\\n               \n",
       "\n",
       "   \\r\\n            +/- so với tháng 3/2020 (%)\\r\\n              \\\n",
       "0               \\r\\n            -1,92\\r\\n                        \n",
       "1               \\r\\n            -5,82\\r\\n                        \n",
       "2              \\r\\n            -14,93\\r\\n                        \n",
       "3                \\r\\n            1,97\\r\\n                        \n",
       "4               \\r\\n            34,76\\r\\n                        \n",
       "5                \\r\\n            9,79\\r\\n                        \n",
       "6                \\r\\n            2,52\\r\\n                        \n",
       "7              \\r\\n            -12,43\\r\\n                        \n",
       "8              \\r\\n            -12,07\\r\\n                        \n",
       "9               \\r\\n            -1,81\\r\\n                        \n",
       "10             \\r\\n            -43,14\\r\\n                        \n",
       "11              \\r\\n            20,84\\r\\n                        \n",
       "12               \\r\\n            2,76\\r\\n                        \n",
       "13              \\r\\n            13,12\\r\\n                        \n",
       "14              \\r\\n            -1,05\\r\\n                        \n",
       "15              \\r\\n            -4,84\\r\\n                        \n",
       "16              \\r\\n            81,04\\r\\n                        \n",
       "17             \\r\\n            -16,01\\r\\n                        \n",
       "18             \\r\\n            -50,97\\r\\n                        \n",
       "19              \\r\\n            33,41\\r\\n                        \n",
       "20             \\r\\n            -45,68\\r\\n                        \n",
       "21             \\r\\n            -57,38\\r\\n                        \n",
       "22              \\r\\n            -3,61\\r\\n                        \n",
       "23               \\r\\n            7,63\\r\\n                        \n",
       "24             \\r\\n            -14,61\\r\\n                        \n",
       "25             \\r\\n            -81,48\\r\\n                        \n",
       "26             \\r\\n            -51,05\\r\\n                        \n",
       "27               \\r\\n            3,23\\r\\n                        \n",
       "28             \\r\\n            -22,13\\r\\n                        \n",
       "29             \\r\\n            -72,74\\r\\n                        \n",
       "30             \\r\\n            -15,23\\r\\n                        \n",
       "31             \\r\\n            -20,74\\r\\n                        \n",
       "32              \\r\\n            40,94\\r\\n                        \n",
       "33             \\r\\n            -45,92\\r\\n                        \n",
       "34              \\r\\n            -98,1\\r\\n                        \n",
       "35              \\r\\n            -21,7\\r\\n                        \n",
       "36             \\r\\n            -10,03\\r\\n                        \n",
       "37              \\r\\n            43,32\\r\\n                        \n",
       "38             \\r\\n            -40,71\\r\\n                        \n",
       "39              \\r\\n            -3,96\\r\\n                        \n",
       "40             \\r\\n            -58,76\\r\\n                        \n",
       "41              \\r\\n            -52,3\\r\\n                        \n",
       "42           \\r\\n            1,752,45\\r\\n                        \n",
       "43              \\r\\n            158,1\\r\\n                        \n",
       "44              \\r\\n            -21,1\\r\\n                        \n",
       "45              \\r\\n            49,54\\r\\n                        \n",
       "46              \\r\\n            69,45\\r\\n                        \n",
       "47             \\r\\n            -44,61\\r\\n                        \n",
       "48              \\r\\n            -4,05\\r\\n                        \n",
       "49             \\r\\n            -38,11\\r\\n                        \n",
       "50                                               -100            \n",
       "51             \\r\\n            -10,92\\r\\n                        \n",
       "52             \\r\\n            123,43\\r\\n                        \n",
       "53              \\r\\n            -5,51\\r\\n                        \n",
       "\n",
       "          \\r\\n            4T/2020\\r\\n              \\\n",
       "0   \\r\\n            2.226.772.128\\r\\n               \n",
       "1     \\r\\n            434.385.160\\r\\n               \n",
       "2     \\r\\n            377.475.117\\r\\n               \n",
       "3     \\r\\n            322.339.637\\r\\n               \n",
       "4     \\r\\n            246.264.406\\r\\n               \n",
       "5     \\r\\n            216.437.665\\r\\n               \n",
       "6      \\r\\n            79.085.768\\r\\n               \n",
       "7      \\r\\n            74.241.916\\r\\n               \n",
       "8      \\r\\n            71.860.397\\r\\n               \n",
       "9      \\r\\n            57.984.683\\r\\n               \n",
       "10     \\r\\n            55.235.560\\r\\n               \n",
       "11     \\r\\n            46.744.382\\r\\n               \n",
       "12     \\r\\n            38.062.146\\r\\n               \n",
       "13     \\r\\n            37.106.104\\r\\n               \n",
       "14     \\r\\n            36.005.230\\r\\n               \n",
       "15     \\r\\n            33.794.451\\r\\n               \n",
       "16     \\r\\n            31.985.217\\r\\n               \n",
       "17     \\r\\n            29.303.669\\r\\n               \n",
       "18     \\r\\n            24.175.358\\r\\n               \n",
       "19     \\r\\n            21.959.958\\r\\n               \n",
       "20     \\r\\n            21.784.722\\r\\n               \n",
       "21     \\r\\n            20.804.541\\r\\n               \n",
       "22     \\r\\n            20.065.325\\r\\n               \n",
       "23     \\r\\n            17.852.271\\r\\n               \n",
       "24     \\r\\n            16.657.745\\r\\n               \n",
       "25     \\r\\n            16.164.806\\r\\n               \n",
       "26     \\r\\n            14.952.096\\r\\n               \n",
       "27     \\r\\n            12.851.798\\r\\n               \n",
       "28     \\r\\n            12.010.712\\r\\n               \n",
       "29     \\r\\n            10.783.737\\r\\n               \n",
       "30     \\r\\n            10.259.015\\r\\n               \n",
       "31      \\r\\n            9.658.514\\r\\n               \n",
       "32      \\r\\n            9.399.712\\r\\n               \n",
       "33      \\r\\n            8.706.691\\r\\n               \n",
       "34      \\r\\n            5.189.665\\r\\n               \n",
       "35      \\r\\n            4.620.400\\r\\n               \n",
       "36      \\r\\n            3.915.658\\r\\n               \n",
       "37      \\r\\n            3.760.994\\r\\n               \n",
       "38      \\r\\n            3.367.449\\r\\n               \n",
       "39      \\r\\n            2.710.899\\r\\n               \n",
       "40      \\r\\n            2.684.395\\r\\n               \n",
       "41      \\r\\n            2.668.243\\r\\n               \n",
       "42      \\r\\n            2.606.980\\r\\n               \n",
       "43      \\r\\n            2.460.687\\r\\n               \n",
       "44      \\r\\n            2.118.817\\r\\n               \n",
       "45      \\r\\n            2.020.578\\r\\n               \n",
       "46      \\r\\n            1.645.796\\r\\n               \n",
       "47      \\r\\n            1.543.001\\r\\n               \n",
       "48      \\r\\n            1.141.768\\r\\n               \n",
       "49        \\r\\n            918.310\\r\\n               \n",
       "50        \\r\\n            803.754\\r\\n               \n",
       "51        \\r\\n            492.595\\r\\n               \n",
       "52        \\r\\n            273.034\\r\\n               \n",
       "53        \\r\\n            256.334\\r\\n               \n",
       "\n",
       "   \\r\\n            +/- so với cùng kỳ năm 2019 (%)\\r\\n              \\\n",
       "0               \\r\\n            -8,10\\r\\n                            \n",
       "1                \\r\\n            5,64\\r\\n                            \n",
       "2               \\r\\n            -2,09\\r\\n                            \n",
       "3               \\r\\n            -14,8\\r\\n                            \n",
       "4               \\r\\n            -7,96\\r\\n                            \n",
       "5               \\r\\n            -8,78\\r\\n                            \n",
       "6                \\r\\n            3,35\\r\\n                            \n",
       "7              \\r\\n            -14,16\\r\\n                            \n",
       "8                \\r\\n            12,1\\r\\n                            \n",
       "9               \\r\\n            -17,4\\r\\n                            \n",
       "10              \\r\\n            -7,41\\r\\n                            \n",
       "11             \\r\\n            -19,47\\r\\n                            \n",
       "12              \\r\\n            15,64\\r\\n                            \n",
       "13             \\r\\n            -29,52\\r\\n                            \n",
       "14              \\r\\n            -5,41\\r\\n                            \n",
       "15             \\r\\n            -20,28\\r\\n                            \n",
       "16              \\r\\n            -0,59\\r\\n                            \n",
       "17             \\r\\n            -18,11\\r\\n                            \n",
       "18             \\r\\n            -34,43\\r\\n                            \n",
       "19             \\r\\n            -31,98\\r\\n                            \n",
       "20             \\r\\n            190,34\\r\\n                            \n",
       "21             \\r\\n            -55,64\\r\\n                            \n",
       "22             \\r\\n            -36,26\\r\\n                            \n",
       "23             \\r\\n            -26,21\\r\\n                            \n",
       "24             \\r\\n            -12,14\\r\\n                            \n",
       "25             \\r\\n            -31,07\\r\\n                            \n",
       "26             \\r\\n            -36,29\\r\\n                            \n",
       "27               \\r\\n            3,64\\r\\n                            \n",
       "28             \\r\\n            -25,68\\r\\n                            \n",
       "29             \\r\\n            -29,81\\r\\n                            \n",
       "30             \\r\\n            -28,97\\r\\n                            \n",
       "31              \\r\\n            35,84\\r\\n                            \n",
       "32               \\r\\n            9,24\\r\\n                            \n",
       "33              \\r\\n            21,79\\r\\n                            \n",
       "34             \\r\\n            -41,29\\r\\n                            \n",
       "35             \\r\\n            -29,68\\r\\n                            \n",
       "36                                                 26                \n",
       "37             \\r\\n            -33,54\\r\\n                            \n",
       "38             \\r\\n            -27,88\\r\\n                            \n",
       "39              \\r\\n            30,52\\r\\n                            \n",
       "40             \\r\\n            -19,35\\r\\n                            \n",
       "41               \\r\\n            6,89\\r\\n                            \n",
       "42              \\r\\n            13,02\\r\\n                            \n",
       "43             \\r\\n            -20,72\\r\\n                            \n",
       "44             \\r\\n            -37,95\\r\\n                            \n",
       "45             \\r\\n            -23,46\\r\\n                            \n",
       "46             \\r\\n            -55,51\\r\\n                            \n",
       "47             \\r\\n            -30,04\\r\\n                            \n",
       "48             \\r\\n            -45,88\\r\\n                            \n",
       "49             \\r\\n            -25,93\\r\\n                            \n",
       "50             \\r\\n            -34,62\\r\\n                            \n",
       "51             \\r\\n            -26,34\\r\\n                            \n",
       "52             \\r\\n            -29,71\\r\\n                            \n",
       "53             \\r\\n            -42,58\\r\\n                            \n",
       "\n",
       "   \\r\\n            Tỷ trọng (%)\\r\\n              \n",
       "0                                           100  \n",
       "1         \\r\\n            19,51\\r\\n              \n",
       "2         \\r\\n            16,95\\r\\n              \n",
       "3         \\r\\n            14,48\\r\\n              \n",
       "4         \\r\\n            11,06\\r\\n              \n",
       "5          \\r\\n            9,72\\r\\n              \n",
       "6          \\r\\n            3,55\\r\\n              \n",
       "7          \\r\\n            3,33\\r\\n              \n",
       "8          \\r\\n            3,23\\r\\n              \n",
       "9           \\r\\n            2,6\\r\\n              \n",
       "10         \\r\\n            2,48\\r\\n              \n",
       "11          \\r\\n            2,1\\r\\n              \n",
       "12         \\r\\n            1,71\\r\\n              \n",
       "13         \\r\\n            1,67\\r\\n              \n",
       "14         \\r\\n            1,62\\r\\n              \n",
       "15         \\r\\n            1,52\\r\\n              \n",
       "16         \\r\\n            1,44\\r\\n              \n",
       "17         \\r\\n            1,32\\r\\n              \n",
       "18         \\r\\n            1,09\\r\\n              \n",
       "19         \\r\\n            0,99\\r\\n              \n",
       "20         \\r\\n            0,98\\r\\n              \n",
       "21         \\r\\n            0,93\\r\\n              \n",
       "22          \\r\\n            0,9\\r\\n              \n",
       "23          \\r\\n            0,8\\r\\n              \n",
       "24         \\r\\n            0,75\\r\\n              \n",
       "25         \\r\\n            0,73\\r\\n              \n",
       "26         \\r\\n            0,67\\r\\n              \n",
       "27         \\r\\n            0,58\\r\\n              \n",
       "28         \\r\\n            0,54\\r\\n              \n",
       "29         \\r\\n            0,48\\r\\n              \n",
       "30         \\r\\n            0,46\\r\\n              \n",
       "31         \\r\\n            0,43\\r\\n              \n",
       "32         \\r\\n            0,42\\r\\n              \n",
       "33         \\r\\n            0,39\\r\\n              \n",
       "34         \\r\\n            0,23\\r\\n              \n",
       "35         \\r\\n            0,21\\r\\n              \n",
       "36         \\r\\n            0,18\\r\\n              \n",
       "37         \\r\\n            0,17\\r\\n              \n",
       "38         \\r\\n            0,15\\r\\n              \n",
       "39         \\r\\n            0,12\\r\\n              \n",
       "40         \\r\\n            0,12\\r\\n              \n",
       "41         \\r\\n            0,12\\r\\n              \n",
       "42         \\r\\n            0,12\\r\\n              \n",
       "43         \\r\\n            0,11\\r\\n              \n",
       "44          \\r\\n            0,1\\r\\n              \n",
       "45         \\r\\n            0,09\\r\\n              \n",
       "46         \\r\\n            0,07\\r\\n              \n",
       "47         \\r\\n            0,07\\r\\n              \n",
       "48         \\r\\n            0,05\\r\\n              \n",
       "49         \\r\\n            0,04\\r\\n              \n",
       "50         \\r\\n            0,04\\r\\n              \n",
       "51         \\r\\n            0,02\\r\\n              \n",
       "52         \\r\\n            0,01\\r\\n              \n",
       "53         \\r\\n            0,01\\r\\n              "
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}