pandas_exel_skiprow.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>Seq</th>\n",
       "      <th>Brand</th>\n",
       "      <th>1300cc</th>\n",
       "      <th>1600cc</th>\n",
       "      <th>1800cc</th>\n",
       "      <th>2000cc</th>\n",
       "      <th>Gtc2000cc</th>\n",
       "      <th>elec</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>ALFA ROMEO</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>ASTON MARTIN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>AUDI</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>111</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>BENTLEY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>BMW</td>\n",
       "      <td>2</td>\n",
       "      <td>596</td>\n",
       "      <td>0</td>\n",
       "      <td>6159</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>7319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>CADILLAC</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>CHERY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>CHEVROLET</td>\n",
       "      <td>0</td>\n",
       "      <td>409</td>\n",
       "      <td>413</td>\n",
       "      <td>651</td>\n",
       "      <td>5469</td>\n",
       "      <td>0</td>\n",
       "      <td>6942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>CHRYSLER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>CITROEN</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>DAEWOO</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>DAIHATSU</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>DAIMLER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>DFM</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>FERRARI</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>FIAT</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>FORD</td>\n",
       "      <td>315</td>\n",
       "      <td>3910</td>\n",
       "      <td>1</td>\n",
       "      <td>294</td>\n",
       "      <td>25911</td>\n",
       "      <td>0</td>\n",
       "      <td>30431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>GEELY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>HINO</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>HOLDEN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>HONDA</td>\n",
       "      <td>1890</td>\n",
       "      <td>69590</td>\n",
       "      <td>32547</td>\n",
       "      <td>9524</td>\n",
       "      <td>2575</td>\n",
       "      <td>0</td>\n",
       "      <td>116126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>HUMMER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>HYUNDAI</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>330</td>\n",
       "      <td>33</td>\n",
       "      <td>495</td>\n",
       "      <td>0</td>\n",
       "      <td>878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>ISUZU</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>35943</td>\n",
       "      <td>12144</td>\n",
       "      <td>0</td>\n",
       "      <td>48087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>JAGUAR</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>JEEP</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>KIA</td>\n",
       "      <td>5</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>LAMBORGHINI</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>LAND ROVER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>36</td>\n",
       "      <td>MAZDA</td>\n",
       "      <td>14962</td>\n",
       "      <td>8423</td>\n",
       "      <td>0</td>\n",
       "      <td>11384</td>\n",
       "      <td>5137</td>\n",
       "      <td>0</td>\n",
       "      <td>39906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>37</td>\n",
       "      <td>MERCEDES BENZ</td>\n",
       "      <td>1</td>\n",
       "      <td>1583</td>\n",
       "      <td>335</td>\n",
       "      <td>5441</td>\n",
       "      <td>5271</td>\n",
       "      <td>0</td>\n",
       "      <td>12631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>38</td>\n",
       "      <td>MG</td>\n",
       "      <td>0</td>\n",
       "      <td>6447</td>\n",
       "      <td>683</td>\n",
       "      <td>188</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>39</td>\n",
       "      <td>MINI COOPER</td>\n",
       "      <td>7</td>\n",
       "      <td>391</td>\n",
       "      <td>0</td>\n",
       "      <td>679</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40</td>\n",
       "      <td>MITSUBISHI</td>\n",
       "      <td>15342</td>\n",
       "      <td>3</td>\n",
       "      <td>64</td>\n",
       "      <td>173</td>\n",
       "      <td>32286</td>\n",
       "      <td>0</td>\n",
       "      <td>47868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>41</td>\n",
       "      <td>MITSUOKA</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>42</td>\n",
       "      <td>NAZA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>43</td>\n",
       "      <td>NISSAN</td>\n",
       "      <td>17541</td>\n",
       "      <td>4125</td>\n",
       "      <td>522</td>\n",
       "      <td>5325</td>\n",
       "      <td>5243</td>\n",
       "      <td>0</td>\n",
       "      <td>32756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>PERODUA</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>PEUGEOT</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>PORSCHE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>171</td>\n",
       "      <td>536</td>\n",
       "      <td>0</td>\n",
       "      <td>707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>PROTON</td>\n",
       "      <td>3</td>\n",
       "      <td>146</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>48</td>\n",
       "      <td>RADICAL</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>49</td>\n",
       "      <td>RANGE ROVER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>50</td>\n",
       "      <td>ROLLS-ROYCE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>51</td>\n",
       "      <td>ROVER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>52</td>\n",
       "      <td>SAAB</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>53</td>\n",
       "      <td>SEAT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>54</td>\n",
       "      <td>SKODA</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>55</td>\n",
       "      <td>SMART</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>56</td>\n",
       "      <td>SOKON</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>57</td>\n",
       "      <td>SSANGYONG</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>58</td>\n",
       "      <td>SUBARU</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>3980</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>4055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>59</td>\n",
       "      <td>SUZUKI</td>\n",
       "      <td>18217</td>\n",
       "      <td>892</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>60</td>\n",
       "      <td>TATA</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>61</td>\n",
       "      <td>TOYOTA</td>\n",
       "      <td>37713</td>\n",
       "      <td>36105</td>\n",
       "      <td>7715</td>\n",
       "      <td>4359</td>\n",
       "      <td>72058</td>\n",
       "      <td>0</td>\n",
       "      <td>157950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>62</td>\n",
       "      <td>VOLKSWAGEN</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>63</td>\n",
       "      <td>VOLVO</td>\n",
       "      <td>0</td>\n",
       "      <td>227</td>\n",
       "      <td>0</td>\n",
       "      <td>651</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>64</td>\n",
       "      <td>WULING</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>65</td>\n",
       "      <td>อื่น ๆ</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>65 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Seq          Brand  1300cc  1600cc  1800cc  2000cc  Gtc2000cc  elec  \\\n",
       "0     1     ALFA ROMEO       0       0       3       0          3     0   \n",
       "1     2   ASTON MARTIN       0       0       0       0         14     0   \n",
       "2     3           AUDI       0       4       0     111          9     0   \n",
       "3     4         AUSTIN       0       0       0       0          0     0   \n",
       "4     5        BENTLEY       0       0       0       0         15     0   \n",
       "5     6            BMW       2     596       0    6159        562     0   \n",
       "6     7       CADILLAC       0       0       0       0          5     0   \n",
       "7     8          CHERY       0       0       0       3          0     0   \n",
       "8     9      CHEVROLET       0     409     413     651       5469     0   \n",
       "9    10       CHRYSLER       0       0       0       1          0     0   \n",
       "10   11        CITROEN       1       4       0       0          0     0   \n",
       "11   12         DAEWOO       0       0       0       0          0     0   \n",
       "12   13       DAIHATSU       4       0       0       0          0     0   \n",
       "13   14        DAIMLER       0       0       0       0          0     0   \n",
       "14   15            DFM       0       0       0       0          0     0   \n",
       "15   16        FERRARI       0       0       0       0         42     0   \n",
       "16   17           FIAT       0       6       0       0          3     0   \n",
       "17   18           FORD     315    3910       1     294      25911     0   \n",
       "18   19          GEELY       0       0       0       0          0     0   \n",
       "19   20           HINO       0       0       0       0          0     0   \n",
       "20   21         HOLDEN       0       0       0       0          0     0   \n",
       "21   22          HONDA    1890   69590   32547    9524       2575     0   \n",
       "22   23         HUMMER       0       0       0       0          1     0   \n",
       "23   24        HYUNDAI       0      20     330      33        495     0   \n",
       "24   25          ISUZU       0       0       0   35943      12144     0   \n",
       "25   26         JAGUAR       0       0       0      23         16     0   \n",
       "26   27           JEEP       0       0       0       1         13     0   \n",
       "27   28            KIA       5      48       1      15         18     0   \n",
       "28   29    LAMBORGHINI       0       0       0       0         38     0   \n",
       "29   30     LAND ROVER       0       0       0       1         41     0   \n",
       "..  ...            ...     ...     ...     ...     ...        ...   ...   \n",
       "35   36          MAZDA   14962    8423       0   11384       5137     0   \n",
       "36   37  MERCEDES BENZ       1    1583     335    5441       5271     0   \n",
       "37   38             MG       0    6447     683     188          0     0   \n",
       "38   39    MINI COOPER       7     391       0     679          0     0   \n",
       "39   40     MITSUBISHI   15342       3      64     173      32286     0   \n",
       "40   41       MITSUOKA       0       0       0       3          1     0   \n",
       "41   42           NAZA       1       0       0       0          1     0   \n",
       "42   43         NISSAN   17541    4125     522    5325       5243     0   \n",
       "43   44        PERODUA       0       4       0       0          0     0   \n",
       "44   45        PEUGEOT       0      63       0       2          0     0   \n",
       "45   46        PORSCHE       0       0       0     171        536     0   \n",
       "46   47         PROTON       3     146       0       0          0     0   \n",
       "47   48        RADICAL       0       0       0       0          0     0   \n",
       "48   49    RANGE ROVER       0       0       0       1         46     0   \n",
       "49   50    ROLLS-ROYCE       0       0       0       0         18     0   \n",
       "50   51          ROVER       0       0       0       0          0     0   \n",
       "51   52           SAAB       0       0       0       0          0     0   \n",
       "52   53           SEAT       0       0       0       0          0     0   \n",
       "53   54          SKODA       0       1       2       1          0     0   \n",
       "54   55          SMART       0       0       0       0          0     0   \n",
       "55   56          SOKON       0       0       0       0          0     0   \n",
       "56   57      SSANGYONG       0       0       0       7          3     0   \n",
       "57   58         SUBARU       0      17       0    3980         58     0   \n",
       "58   59         SUZUKI   18217     892       0       3          0     0   \n",
       "59   60           TATA       0       0       0       0         48     0   \n",
       "60   61         TOYOTA   37713   36105    7715    4359      72058     0   \n",
       "61   62     VOLKSWAGEN      13      13       0      38          1     0   \n",
       "62   63          VOLVO       0     227       0     651         45     0   \n",
       "63   64         WULING       0       0       0       0          0     0   \n",
       "64   65        อื่น ๆ        3       1       0       0         27     2   \n",
       "\n",
       "     Total  \n",
       "0        6  \n",
       "1       14  \n",
       "2      124  \n",
       "3        0  \n",
       "4       15  \n",
       "5     7319  \n",
       "6        5  \n",
       "7        3  \n",
       "8     6942  \n",
       "9        1  \n",
       "10       5  \n",
       "11       0  \n",
       "12       4  \n",
       "13       0  \n",
       "14       0  \n",
       "15      42  \n",
       "16       9  \n",
       "17   30431  \n",
       "18       0  \n",
       "19       0  \n",
       "20       0  \n",
       "21  116126  \n",
       "22       1  \n",
       "23     878  \n",
       "24   48087  \n",
       "25      39  \n",
       "26      14  \n",
       "27      87  \n",
       "28      38  \n",
       "29      42  \n",
       "..     ...  \n",
       "35   39906  \n",
       "36   12631  \n",
       "37    7318  \n",
       "38    1077  \n",
       "39   47868  \n",
       "40       4  \n",
       "41       2  \n",
       "42   32756  \n",
       "43       4  \n",
       "44      65  \n",
       "45     707  \n",
       "46     149  \n",
       "47       0  \n",
       "48      47  \n",
       "49      18  \n",
       "50       0  \n",
       "51       0  \n",
       "52       0  \n",
       "53       4  \n",
       "54       0  \n",
       "55       0  \n",
       "56      10  \n",
       "57    4055  \n",
       "58   19112  \n",
       "59      48  \n",
       "60  157950  \n",
       "61      65  \n",
       "62     923  \n",
       "63       0  \n",
       "64      33  \n",
       "\n",
       "[65 rows x 9 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# df=pd.read_excel(\"https://github.com/prasertcbs/basic-dataset/raw/master/Car1_whole2559.xls\")\n",
    "# df=pd.read_excel(\"https://github.com/prasertcbs/basic-dataset/raw/master/Car1_whole2559.xls\",sheet_name=\"Total\",skiprows=6)\n",
    "# df=pd.read_excel(\"https://github.com/prasertcbs/basic-dataset/raw/master/Car1_whole2559.xls\",sheet_name=\"Total\",skiprows=6,skipfooter=3,usecols=\"B:I\")\n",
    "info=[\"Seq\",\"Brand\",\"1300cc\",\"1600cc\",\"1800cc\",\"2000cc\",\"Gtc2000cc\",\"elec\",\"Total\"]\n",
    "df=pd.read_excel(\"https://github.com/prasertcbs/basic-dataset/raw/master/Car1_whole2559.xls\",sheet_name=\"Total\",skiprows=7,header=None,names=info,skipfooter=3)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>Brand</th>\n",
       "      <th>1300cc</th>\n",
       "      <th>1600cc</th>\n",
       "      <th>1800cc</th>\n",
       "      <th>2000cc</th>\n",
       "      <th>Gtc2000cc</th>\n",
       "      <th>elec</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ALFA ROMEO</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ASTON MARTIN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AUDI</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>111</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BENTLEY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BMW</td>\n",
       "      <td>2</td>\n",
       "      <td>596</td>\n",
       "      <td>0</td>\n",
       "      <td>6159</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>7319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CADILLAC</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CHERY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CHEVROLET</td>\n",
       "      <td>0</td>\n",
       "      <td>409</td>\n",
       "      <td>413</td>\n",
       "      <td>651</td>\n",
       "      <td>5469</td>\n",
       "      <td>0</td>\n",
       "      <td>6942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CHRYSLER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>CITROEN</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>DAEWOO</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>DAIHATSU</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>DAIMLER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>DFM</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>FERRARI</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>FIAT</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>FORD</td>\n",
       "      <td>315</td>\n",
       "      <td>3910</td>\n",
       "      <td>1</td>\n",
       "      <td>294</td>\n",
       "      <td>25911</td>\n",
       "      <td>0</td>\n",
       "      <td>30431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>GEELY</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>HINO</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>HOLDEN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>HONDA</td>\n",
       "      <td>1890</td>\n",
       "      <td>69590</td>\n",
       "      <td>32547</td>\n",
       "      <td>9524</td>\n",
       "      <td>2575</td>\n",
       "      <td>0</td>\n",
       "      <td>116126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>HUMMER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>HYUNDAI</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>330</td>\n",
       "      <td>33</td>\n",
       "      <td>495</td>\n",
       "      <td>0</td>\n",
       "      <td>878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>ISUZU</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>35943</td>\n",
       "      <td>12144</td>\n",
       "      <td>0</td>\n",
       "      <td>48087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>JAGUAR</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>JEEP</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>KIA</td>\n",
       "      <td>5</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>LAMBORGHINI</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>LAND ROVER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>MAZDA</td>\n",
       "      <td>14962</td>\n",
       "      <td>8423</td>\n",
       "      <td>0</td>\n",
       "      <td>11384</td>\n",
       "      <td>5137</td>\n",
       "      <td>0</td>\n",
       "      <td>39906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>MERCEDES BENZ</td>\n",
       "      <td>1</td>\n",
       "      <td>1583</td>\n",
       "      <td>335</td>\n",
       "      <td>5441</td>\n",
       "      <td>5271</td>\n",
       "      <td>0</td>\n",
       "      <td>12631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>MG</td>\n",
       "      <td>0</td>\n",
       "      <td>6447</td>\n",
       "      <td>683</td>\n",
       "      <td>188</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>MINI COOPER</td>\n",
       "      <td>7</td>\n",
       "      <td>391</td>\n",
       "      <td>0</td>\n",
       "      <td>679</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>MITSUBISHI</td>\n",
       "      <td>15342</td>\n",
       "      <td>3</td>\n",
       "      <td>64</td>\n",
       "      <td>173</td>\n",
       "      <td>32286</td>\n",
       "      <td>0</td>\n",
       "      <td>47868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>MITSUOKA</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>NAZA</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>NISSAN</td>\n",
       "      <td>17541</td>\n",
       "      <td>4125</td>\n",
       "      <td>522</td>\n",
       "      <td>5325</td>\n",
       "      <td>5243</td>\n",
       "      <td>0</td>\n",
       "      <td>32756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>PERODUA</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>PEUGEOT</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>PORSCHE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>171</td>\n",
       "      <td>536</td>\n",
       "      <td>0</td>\n",
       "      <td>707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>PROTON</td>\n",
       "      <td>3</td>\n",
       "      <td>146</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>RADICAL</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>RANGE ROVER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>ROLLS-ROYCE</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>ROVER</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>SAAB</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>SEAT</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>SKODA</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>SMART</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>SOKON</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>SSANGYONG</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>SUBARU</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>3980</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>4055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>SUZUKI</td>\n",
       "      <td>18217</td>\n",
       "      <td>892</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>TATA</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>TOYOTA</td>\n",
       "      <td>37713</td>\n",
       "      <td>36105</td>\n",
       "      <td>7715</td>\n",
       "      <td>4359</td>\n",
       "      <td>72058</td>\n",
       "      <td>0</td>\n",
       "      <td>157950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>VOLKSWAGEN</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>VOLVO</td>\n",
       "      <td>0</td>\n",
       "      <td>227</td>\n",
       "      <td>0</td>\n",
       "      <td>651</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>WULING</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>อื่น ๆ</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>65 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Brand  1300cc  1600cc  1800cc  2000cc  Gtc2000cc  elec   Total\n",
       "0      ALFA ROMEO       0       0       3       0          3     0       6\n",
       "1    ASTON MARTIN       0       0       0       0         14     0      14\n",
       "2            AUDI       0       4       0     111          9     0     124\n",
       "3          AUSTIN       0       0       0       0          0     0       0\n",
       "4         BENTLEY       0       0       0       0         15     0      15\n",
       "5             BMW       2     596       0    6159        562     0    7319\n",
       "6        CADILLAC       0       0       0       0          5     0       5\n",
       "7           CHERY       0       0       0       3          0     0       3\n",
       "8       CHEVROLET       0     409     413     651       5469     0    6942\n",
       "9        CHRYSLER       0       0       0       1          0     0       1\n",
       "10        CITROEN       1       4       0       0          0     0       5\n",
       "11         DAEWOO       0       0       0       0          0     0       0\n",
       "12       DAIHATSU       4       0       0       0          0     0       4\n",
       "13        DAIMLER       0       0       0       0          0     0       0\n",
       "14            DFM       0       0       0       0          0     0       0\n",
       "15        FERRARI       0       0       0       0         42     0      42\n",
       "16           FIAT       0       6       0       0          3     0       9\n",
       "17           FORD     315    3910       1     294      25911     0   30431\n",
       "18          GEELY       0       0       0       0          0     0       0\n",
       "19           HINO       0       0       0       0          0     0       0\n",
       "20         HOLDEN       0       0       0       0          0     0       0\n",
       "21          HONDA    1890   69590   32547    9524       2575     0  116126\n",
       "22         HUMMER       0       0       0       0          1     0       1\n",
       "23        HYUNDAI       0      20     330      33        495     0     878\n",
       "24          ISUZU       0       0       0   35943      12144     0   48087\n",
       "25         JAGUAR       0       0       0      23         16     0      39\n",
       "26           JEEP       0       0       0       1         13     0      14\n",
       "27            KIA       5      48       1      15         18     0      87\n",
       "28    LAMBORGHINI       0       0       0       0         38     0      38\n",
       "29     LAND ROVER       0       0       0       1         41     0      42\n",
       "..            ...     ...     ...     ...     ...        ...   ...     ...\n",
       "35          MAZDA   14962    8423       0   11384       5137     0   39906\n",
       "36  MERCEDES BENZ       1    1583     335    5441       5271     0   12631\n",
       "37             MG       0    6447     683     188          0     0    7318\n",
       "38    MINI COOPER       7     391       0     679          0     0    1077\n",
       "39     MITSUBISHI   15342       3      64     173      32286     0   47868\n",
       "40       MITSUOKA       0       0       0       3          1     0       4\n",
       "41           NAZA       1       0       0       0          1     0       2\n",
       "42         NISSAN   17541    4125     522    5325       5243     0   32756\n",
       "43        PERODUA       0       4       0       0          0     0       4\n",
       "44        PEUGEOT       0      63       0       2          0     0      65\n",
       "45        PORSCHE       0       0       0     171        536     0     707\n",
       "46         PROTON       3     146       0       0          0     0     149\n",
       "47        RADICAL       0       0       0       0          0     0       0\n",
       "48    RANGE ROVER       0       0       0       1         46     0      47\n",
       "49    ROLLS-ROYCE       0       0       0       0         18     0      18\n",
       "50          ROVER       0       0       0       0          0     0       0\n",
       "51           SAAB       0       0       0       0          0     0       0\n",
       "52           SEAT       0       0       0       0          0     0       0\n",
       "53          SKODA       0       1       2       1          0     0       4\n",
       "54          SMART       0       0       0       0          0     0       0\n",
       "55          SOKON       0       0       0       0          0     0       0\n",
       "56      SSANGYONG       0       0       0       7          3     0      10\n",
       "57         SUBARU       0      17       0    3980         58     0    4055\n",
       "58         SUZUKI   18217     892       0       3          0     0   19112\n",
       "59           TATA       0       0       0       0         48     0      48\n",
       "60         TOYOTA   37713   36105    7715    4359      72058     0  157950\n",
       "61     VOLKSWAGEN      13      13       0      38          1     0      65\n",
       "62          VOLVO       0     227       0     651         45     0     923\n",
       "63         WULING       0       0       0       0          0     0       0\n",
       "64        อื่น ๆ        3       1       0       0         27     2      33\n",
       "\n",
       "[65 rows x 8 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=df.drop(\"Seq\",axis=1)"
   ]
  },
  {
   "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>Seq</th>\n",
       "      <th>1300cc</th>\n",
       "      <th>1600cc</th>\n",
       "      <th>1800cc</th>\n",
       "      <th>2000cc</th>\n",
       "      <th>Gtc2000cc</th>\n",
       "      <th>elec</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brand</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ALFA ROMEO</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASTON MARTIN</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AUDI</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>111</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AUSTIN</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BENTLEY</th>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BMW</th>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>596</td>\n",
       "      <td>0</td>\n",
       "      <td>6159</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>7319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CADILLAC</th>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHERY</th>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHEVROLET</th>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>409</td>\n",
       "      <td>413</td>\n",
       "      <td>651</td>\n",
       "      <td>5469</td>\n",
       "      <td>0</td>\n",
       "      <td>6942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHRYSLER</th>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CITROEN</th>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAEWOO</th>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAIHATSU</th>\n",
       "      <td>13</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAIMLER</th>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DFM</th>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FERRARI</th>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FIAT</th>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FORD</th>\n",
       "      <td>18</td>\n",
       "      <td>315</td>\n",
       "      <td>3910</td>\n",
       "      <td>1</td>\n",
       "      <td>294</td>\n",
       "      <td>25911</td>\n",
       "      <td>0</td>\n",
       "      <td>30431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GEELY</th>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HINO</th>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOLDEN</th>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HONDA</th>\n",
       "      <td>22</td>\n",
       "      <td>1890</td>\n",
       "      <td>69590</td>\n",
       "      <td>32547</td>\n",
       "      <td>9524</td>\n",
       "      <td>2575</td>\n",
       "      <td>0</td>\n",
       "      <td>116126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HUMMER</th>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HYUNDAI</th>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>330</td>\n",
       "      <td>33</td>\n",
       "      <td>495</td>\n",
       "      <td>0</td>\n",
       "      <td>878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ISUZU</th>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>35943</td>\n",
       "      <td>12144</td>\n",
       "      <td>0</td>\n",
       "      <td>48087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JAGUAR</th>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JEEP</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KIA</th>\n",
       "      <td>28</td>\n",
       "      <td>5</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAMBORGHINI</th>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAND ROVER</th>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MAZDA</th>\n",
       "      <td>36</td>\n",
       "      <td>14962</td>\n",
       "      <td>8423</td>\n",
       "      <td>0</td>\n",
       "      <td>11384</td>\n",
       "      <td>5137</td>\n",
       "      <td>0</td>\n",
       "      <td>39906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MERCEDES BENZ</th>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>1583</td>\n",
       "      <td>335</td>\n",
       "      <td>5441</td>\n",
       "      <td>5271</td>\n",
       "      <td>0</td>\n",
       "      <td>12631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MG</th>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>6447</td>\n",
       "      <td>683</td>\n",
       "      <td>188</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MINI COOPER</th>\n",
       "      <td>39</td>\n",
       "      <td>7</td>\n",
       "      <td>391</td>\n",
       "      <td>0</td>\n",
       "      <td>679</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MITSUBISHI</th>\n",
       "      <td>40</td>\n",
       "      <td>15342</td>\n",
       "      <td>3</td>\n",
       "      <td>64</td>\n",
       "      <td>173</td>\n",
       "      <td>32286</td>\n",
       "      <td>0</td>\n",
       "      <td>47868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MITSUOKA</th>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NAZA</th>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NISSAN</th>\n",
       "      <td>43</td>\n",
       "      <td>17541</td>\n",
       "      <td>4125</td>\n",
       "      <td>522</td>\n",
       "      <td>5325</td>\n",
       "      <td>5243</td>\n",
       "      <td>0</td>\n",
       "      <td>32756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PERODUA</th>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PEUGEOT</th>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PORSCHE</th>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>171</td>\n",
       "      <td>536</td>\n",
       "      <td>0</td>\n",
       "      <td>707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PROTON</th>\n",
       "      <td>47</td>\n",
       "      <td>3</td>\n",
       "      <td>146</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RADICAL</th>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RANGE ROVER</th>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROLLS-ROYCE</th>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROVER</th>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAAB</th>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SEAT</th>\n",
       "      <td>53</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SKODA</th>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SMART</th>\n",
       "      <td>55</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SOKON</th>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SSANGYONG</th>\n",
       "      <td>57</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SUBARU</th>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>3980</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>4055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SUZUKI</th>\n",
       "      <td>59</td>\n",
       "      <td>18217</td>\n",
       "      <td>892</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TATA</th>\n",
       "      <td>60</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TOYOTA</th>\n",
       "      <td>61</td>\n",
       "      <td>37713</td>\n",
       "      <td>36105</td>\n",
       "      <td>7715</td>\n",
       "      <td>4359</td>\n",
       "      <td>72058</td>\n",
       "      <td>0</td>\n",
       "      <td>157950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VOLKSWAGEN</th>\n",
       "      <td>62</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VOLVO</th>\n",
       "      <td>63</td>\n",
       "      <td>0</td>\n",
       "      <td>227</td>\n",
       "      <td>0</td>\n",
       "      <td>651</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WULING</th>\n",
       "      <td>64</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>อื่น ๆ</th>\n",
       "      <td>65</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>65 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Seq  1300cc  1600cc  1800cc  2000cc  Gtc2000cc  elec   Total\n",
       "Brand                                                                      \n",
       "ALFA ROMEO       1       0       0       3       0          3     0       6\n",
       "ASTON MARTIN     2       0       0       0       0         14     0      14\n",
       "AUDI             3       0       4       0     111          9     0     124\n",
       "AUSTIN           4       0       0       0       0          0     0       0\n",
       "BENTLEY          5       0       0       0       0         15     0      15\n",
       "BMW              6       2     596       0    6159        562     0    7319\n",
       "CADILLAC         7       0       0       0       0          5     0       5\n",
       "CHERY            8       0       0       0       3          0     0       3\n",
       "CHEVROLET        9       0     409     413     651       5469     0    6942\n",
       "CHRYSLER        10       0       0       0       1          0     0       1\n",
       "CITROEN         11       1       4       0       0          0     0       5\n",
       "DAEWOO          12       0       0       0       0          0     0       0\n",
       "DAIHATSU        13       4       0       0       0          0     0       4\n",
       "DAIMLER         14       0       0       0       0          0     0       0\n",
       "DFM             15       0       0       0       0          0     0       0\n",
       "FERRARI         16       0       0       0       0         42     0      42\n",
       "FIAT            17       0       6       0       0          3     0       9\n",
       "FORD            18     315    3910       1     294      25911     0   30431\n",
       "GEELY           19       0       0       0       0          0     0       0\n",
       "HINO            20       0       0       0       0          0     0       0\n",
       "HOLDEN          21       0       0       0       0          0     0       0\n",
       "HONDA           22    1890   69590   32547    9524       2575     0  116126\n",
       "HUMMER          23       0       0       0       0          1     0       1\n",
       "HYUNDAI         24       0      20     330      33        495     0     878\n",
       "ISUZU           25       0       0       0   35943      12144     0   48087\n",
       "JAGUAR          26       0       0       0      23         16     0      39\n",
       "JEEP            27       0       0       0       1         13     0      14\n",
       "KIA             28       5      48       1      15         18     0      87\n",
       "LAMBORGHINI     29       0       0       0       0         38     0      38\n",
       "LAND ROVER      30       0       0       0       1         41     0      42\n",
       "...            ...     ...     ...     ...     ...        ...   ...     ...\n",
       "MAZDA           36   14962    8423       0   11384       5137     0   39906\n",
       "MERCEDES BENZ   37       1    1583     335    5441       5271     0   12631\n",
       "MG              38       0    6447     683     188          0     0    7318\n",
       "MINI COOPER     39       7     391       0     679          0     0    1077\n",
       "MITSUBISHI      40   15342       3      64     173      32286     0   47868\n",
       "MITSUOKA        41       0       0       0       3          1     0       4\n",
       "NAZA            42       1       0       0       0          1     0       2\n",
       "NISSAN          43   17541    4125     522    5325       5243     0   32756\n",
       "PERODUA         44       0       4       0       0          0     0       4\n",
       "PEUGEOT         45       0      63       0       2          0     0      65\n",
       "PORSCHE         46       0       0       0     171        536     0     707\n",
       "PROTON          47       3     146       0       0          0     0     149\n",
       "RADICAL         48       0       0       0       0          0     0       0\n",
       "RANGE ROVER     49       0       0       0       1         46     0      47\n",
       "ROLLS-ROYCE     50       0       0       0       0         18     0      18\n",
       "ROVER           51       0       0       0       0          0     0       0\n",
       "SAAB            52       0       0       0       0          0     0       0\n",
       "SEAT            53       0       0       0       0          0     0       0\n",
       "SKODA           54       0       1       2       1          0     0       4\n",
       "SMART           55       0       0       0       0          0     0       0\n",
       "SOKON           56       0       0       0       0          0     0       0\n",
       "SSANGYONG       57       0       0       0       7          3     0      10\n",
       "SUBARU          58       0      17       0    3980         58     0    4055\n",
       "SUZUKI          59   18217     892       0       3          0     0   19112\n",
       "TATA            60       0       0       0       0         48     0      48\n",
       "TOYOTA          61   37713   36105    7715    4359      72058     0  157950\n",
       "VOLKSWAGEN      62      13      13       0      38          1     0      65\n",
       "VOLVO           63       0     227       0     651         45     0     923\n",
       "WULING          64       0       0       0       0          0     0       0\n",
       "อื่น ๆ          65       3       1       0       0         27     2      33\n",
       "\n",
       "[65 rows x 8 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=df.set_index(\"Brand\",inplace=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>Seq</th>\n",
       "      <th>Brand</th>\n",
       "      <th>1300cc</th>\n",
       "      <th>1600cc</th>\n",
       "      <th>1800cc</th>\n",
       "      <th>2000cc</th>\n",
       "      <th>Gtc2000cc</th>\n",
       "      <th>elec</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>61</td>\n",
       "      <td>TOYOTA</td>\n",
       "      <td>37713</td>\n",
       "      <td>36105</td>\n",
       "      <td>7715</td>\n",
       "      <td>4359</td>\n",
       "      <td>72058</td>\n",
       "      <td>0</td>\n",
       "      <td>157950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>HONDA</td>\n",
       "      <td>1890</td>\n",
       "      <td>69590</td>\n",
       "      <td>32547</td>\n",
       "      <td>9524</td>\n",
       "      <td>2575</td>\n",
       "      <td>0</td>\n",
       "      <td>116126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>ISUZU</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>35943</td>\n",
       "      <td>12144</td>\n",
       "      <td>0</td>\n",
       "      <td>48087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40</td>\n",
       "      <td>MITSUBISHI</td>\n",
       "      <td>15342</td>\n",
       "      <td>3</td>\n",
       "      <td>64</td>\n",
       "      <td>173</td>\n",
       "      <td>32286</td>\n",
       "      <td>0</td>\n",
       "      <td>47868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>36</td>\n",
       "      <td>MAZDA</td>\n",
       "      <td>14962</td>\n",
       "      <td>8423</td>\n",
       "      <td>0</td>\n",
       "      <td>11384</td>\n",
       "      <td>5137</td>\n",
       "      <td>0</td>\n",
       "      <td>39906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>43</td>\n",
       "      <td>NISSAN</td>\n",
       "      <td>17541</td>\n",
       "      <td>4125</td>\n",
       "      <td>522</td>\n",
       "      <td>5325</td>\n",
       "      <td>5243</td>\n",
       "      <td>0</td>\n",
       "      <td>32756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>FORD</td>\n",
       "      <td>315</td>\n",
       "      <td>3910</td>\n",
       "      <td>1</td>\n",
       "      <td>294</td>\n",
       "      <td>25911</td>\n",
       "      <td>0</td>\n",
       "      <td>30431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>59</td>\n",
       "      <td>SUZUKI</td>\n",
       "      <td>18217</td>\n",
       "      <td>892</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>37</td>\n",
       "      <td>MERCEDES BENZ</td>\n",
       "      <td>1</td>\n",
       "      <td>1583</td>\n",
       "      <td>335</td>\n",
       "      <td>5441</td>\n",
       "      <td>5271</td>\n",
       "      <td>0</td>\n",
       "      <td>12631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>BMW</td>\n",
       "      <td>2</td>\n",
       "      <td>596</td>\n",
       "      <td>0</td>\n",
       "      <td>6159</td>\n",
       "      <td>562</td>\n",
       "      <td>0</td>\n",
       "      <td>7319</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Seq          Brand  1300cc  1600cc  1800cc  2000cc  Gtc2000cc  elec  \\\n",
       "60   61         TOYOTA   37713   36105    7715    4359      72058     0   \n",
       "21   22          HONDA    1890   69590   32547    9524       2575     0   \n",
       "24   25          ISUZU       0       0       0   35943      12144     0   \n",
       "39   40     MITSUBISHI   15342       3      64     173      32286     0   \n",
       "35   36          MAZDA   14962    8423       0   11384       5137     0   \n",
       "42   43         NISSAN   17541    4125     522    5325       5243     0   \n",
       "17   18           FORD     315    3910       1     294      25911     0   \n",
       "58   59         SUZUKI   18217     892       0       3          0     0   \n",
       "36   37  MERCEDES BENZ       1    1583     335    5441       5271     0   \n",
       "5     6            BMW       2     596       0    6159        562     0   \n",
       "\n",
       "     Total  \n",
       "60  157950  \n",
       "21  116126  \n",
       "24   48087  \n",
       "39   47868  \n",
       "35   39906  \n",
       "42   32756  \n",
       "17   30431  \n",
       "58   19112  \n",
       "36   12631  \n",
       "5     7319  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=df[df.Total!=0]\n",
    "df.nlargest(10,\"Total\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fad3303e3c8>"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXgAAAD8CAYAAAB9y7/cAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAFDJJREFUeJzt3X+wX3V95/HnqyH8RgISMCVMI7b1B7CA3rJV1lYjVYqM7XbbCrvr0FYnY+101VpdWGa6uDOdabWt9tcKWX80bdFKEdodumizIKvMOGRvIEBigvww2hBqZJ3QoCMWeO8f33PhJr3JPd+f9+vh+Zj5zj3fzznn+3nnc3Nf99zzPd/PSVUhSeqeH1jqAiRJ42HAS1JHGfCS1FEGvCR1lAEvSR1lwEtSRxnwktRRBrwkdZQBL0kdddgkOzvppJNqzZo1k+xSkr7vbd68+dGqWtnvfhMN+DVr1jA7OzvJLiXp+16Srw2yn6doJKmjDHhJ6igDXpI6yoCXpI6a6Jusd+/7Di/4/JZJdilJS+4fX3vOkvTrEbwkdVSrgE+yIsn1SXYk2Z7klUlOTLIxyf3N1xPGXawkqb22R/B/CHy2ql4CnA1sBy4HbqmqHwFuaZ5LkqbEogGf5HnATwAfA6iq71XVXuBngA3NZhuAnx1XkZKk/rU5gj8d+CbwiSR3JflokmOAU6rqEYDm68kL7ZxkXZLZJLNPP7Z3ZIVLkg6tTcAfBrwc+EhVnQt8mz5Ox1TV+qqaqaqZHzh+xYBlSpL61SbgdwG7quqO5vn19AL/G0lWATRf94ynREnSIBYN+Kr6R+Afkry4aXod8GXgfwKXNW2XAX87lgolSQNp+0GnXweuTXI48BDwy/R+OVyX5K3A14FfGE+JkqRBtAr4qtoCzCyw6nWjLUeSNCoTnarg7OOOZnaJPrIrSc81TlUgSR1lwEtSRxnwktRRBrwkdZQBL0kdZcBLUkcZ8JLUUQa8JHWUAS9JHWXAS1JHTXSqgn377uWWW180yS4l9el1ax9c6hI0Im1u2Xdaks83N9veluSdTfsvNM+fTrLQRGSSpCXU5gj+SeA9VXVnkuOAzUk2AluBnwOuGWeBkqTBLBrwzf1W5+69ui/JduDUqtoIkGS8FUqSBtLXm6xJ1gDnAnccektJ0lJrHfBJjgU+A7yrqv6pj/3WJZlNMrt379OD1ChJGkCrgE+ynF64X1tVN/TTQVWtr6qZqppZscKrMiVpUtpcRRPgY8D2qvqD8ZckSRqFNlfRnA+8Bbg3yZam7b8ARwB/DKwE/i7Jlqp6w3jKlCT1q81VNLcDB7tU5sbRliNJGpWJfpL1uOPO4nVrZyfZpSQ9Z/mupyR1lAEvSR1lwEtSRxnwktRRBrwkdZQBL0kdZcBLUkcZ8JLUUQa8JHWUAS9JHTXRqQp2797NVVddNckudQDHX3ru8AhekjqqzXzwpyX5fJLtSbYleecB638zSSU5aXxlSpL61eYUzZPAe6rqziTHAZuTbKyqLyc5Dfgp4OtjrVKS1LdFj+Cr6pGqurNZ3gdsB05tVn8IeB9QY6tQkjSQvs7BJ1kDnAvckeRNwMNVdfcY6pIkDan1VTRJjqV34+130TttcyXw+hb7rQPWARx//PGDVSlJ6lurI/gky+mF+7VVdQPwIuCFwN1JdgKrgTuTvODAfatqfVXNVNXM0UcfPbrKJUmHtOgRfJIAHwO2V9UfAFTVvcDJ87bZCcxU1aNjqlOS1Kc2R/DnA28B1ibZ0jwuGnNdkqQhLXoEX1W3A1lkmzWjKkiSNBqpmtwVjjMzMzU7Ozux/iSpC5JsrqqZfvdzqgJJ6igDXpI6yoCXpI4y4CWpowx4SeooA16SOsqAl6SOMuAlqaMMeEnqKANekjqq9Xzwo/C9hx9n1+VfnGSXOsDq33n1UpcgaUI8gpekjlo04JMcmWRTkruTbEvy/qZ9bZI7k2xNsiHJRP8akCQdWpsj+CeAtVV1NnAOcGGSVwEbgEuq6kzga8Bl4ytTktSvRQO+eh5vni5vHk8BT1TVV5r2jcC/G0+JkqRBtL0n67IkW4A99MJ8E7A8ydz8xD8PnHaQfdclmU0y+63v7B1FzZKkFloFfFU9VVXn0Lu59nnAGcAlwIeSbAL2AU8eZN9nbrp94tErRlS2JGkxfV1FU1V7gduAC6vqS1X16qo6D/gCcP8Y6pMkDajNVTQrk6xolo8CLgB2JDm5aTsC+M/A1eMsVJLUnzaXNq4CNiRZRu8XwnVVdVOSDya5uGn7SFXdOs5CJUn9WTTgq+oe4NwF2t8LvHccRUmShjfRDycdfuqxflRekibEqQokqaMMeEnqKANekjrKgJekjjLgJamjDHhJ6igDXpI6yoCXpI4y4CWpowx4SeqoiU5V8I2HHuD333zxJLvsnPd8+qalLkHS9wmP4CWpo9rMB39kkk1J7k6yLcn7m/Y/S/LVJFuaxznjL1eS1FabUzRPAGur6vEky4Hbk9zcrHtvVV0/vvIkSYNqMx98AY83T5c3jxpnUZKk4bU6B59kWZItwB5gY1Xd0az67ST3JPlQc+u+hfZdl2Q2yey3n/jeiMqWJC2mVcBX1VNVdQ6wGjgvyZnAFcBLgB8DTqR3X9aF9l1fVTNVNXPMEYePqGxJ0mL6uoqmqvYCtwEXVtUj1fME8AngvDHUJ0kaUJuraFYmWdEsHwVcAOxIsqppC/CzwNZxFipJ6k+bq2hWARuSLKP3C+G6qropya1JVgIBtgBvH2OdkqQ+tbmK5h7g3AXa146lIknSSEx0qoJTTv9hP2ovSRPiVAWS1FEGvCR1lAEvSR1lwEtSRxnwktRRBrwkdZQBL0kdZcBLUkcZ8JLUUQa8JHXURKcq2PO1ffzp22+dZJdT6deudhofSePX+gi+uavTXUluap5fm+S+JFuTfLy5X6skaUr0c4rmncD2ec+vpXdHp7OAo4C3jbAuSdKQ2t6TdTXwRuCjc21V9b+aOzoVsIne7fwkSVOi7RH8h4H3AU8fuKI5NfMW4LMjrEuSNKQ2t+y7GNhTVZsPssl/B75QVV88yP7rkswmmX38u3uHKFWS1I82R/DnA29KshP4K2Btkr8ESPJfgZXAbxxs56paX1UzVTVz7JErRlCyJKmNRQO+qq6oqtVVtQa4BLi1qv5jkrcBbwAurap/cepGkrS0hvmg09XAKcCXkmxJ8lsjqkmSNAJ9fdCpqm4DbmuWJ/ohKUlSfyYa0if/0HF+ilOSJsS5aCSpowx4SeooA16SOsqAl6SOMuAlqaMMeEnqKANekjrKgJekjjLgJamjDHhJ6qiJTlXw3a3b2P6Sl06yyyX30h3bF99IksbAI3hJ6qg2d3T6eJI9SbbOa/t0M0XwliQ7k2wZb5mSpH61OUXzZ8CfAH8+11BVb55bTvL7wGMjr0ySNJRFA76qvpBkzULrkgT4RcA5gCVpygx7Dv7VwDeq6v5RFCNJGp1hA/5S4FOH2iDJuiSzSWa/9dSTQ3YnSWpr4MskkxwG/BzwikNtV1XrgfUAZx55VA3anySpP8McwV8A7KiqXaMqRpI0Om0uk/wU8CXgxUl2JXlrs+oSFjk9I0laOm2uorn0IO2/NPJqJEkjM9GpCo488wxeOjs7yS4l6TnLqQokqaMMeEnqKANekjrKgJekjjLgJamjDHhJ6igDXpI6yoCXpI4y4CWpowx4SeqoiU5VsO3/beOsDWdNssvW7r3s3qUuQZJGyiN4SeqoVkfwSXYC+4CngCeraibJOcDVwJHAk8A7qmrTuAqVJPWnn1M0r62qR+c9/wDw/qq6OclFzfPXjLI4SdLghjlFU8DzmuXjgd3DlyNJGpW2R/AF/H2SAq5p7rP6LuBzSX6P3i+KVy20Y5J1wDqA5c9fPnzFkqRW2gb8+VW1O8nJwMYkO4CfB95dVZ9J8ovAx+jdp3U/82+6fdQLvem2JE1Kq1M0VbW7+boHuBE4D7gMuKHZ5K+bNknSlGhz0+1jkhw3twy8HthK75z7TzabrQXuH1eRkqT+tTlFcwpwY5K57T9ZVZ9N8jjwh0kOA75Lc55dkjQdFg34qnoIOHuB9tuBV4yjKEnS8CY6VcEZzz+D2ctmJ9mlJD1nOVWBJHWUAS9JHWXAS1JHGfCS1FEGvCR1lAEvSR1lwEtSRxnwktRRBrwkdZQBL0kdNdGpCth9F1x1/Hj7uOqx8b6+JH2f8AhekjqqzXzwRybZlOTuJNuSvL9pT5LfTvKVJNuT/KfxlytJaqvNKZongLVV9XiS5cDtSW4GXgqcBrykqp5ubucnSZoSbeaDL+Dx5uny5lHArwL/vqqebrbbM64iJUn9a3UOPsmyJFuAPcDGqroDeBHw5iSzSW5O8iMH2Xdds83sN7/jPbclaVLa3nT7qao6B1gNnJfkTOAI4LtVNQP8D+DjB9l3fVXNVNXMyqMzqrolSYvo6yqaqtoL3AZcCOwCPtOsuhH4VyOtTJI0lDZX0axMsqJZPgq4ANgB/A2wttnsJ4GvjKtISVL/2lxFswrYkGQZvV8I11XVTUluB65N8m56b8K+bYx1SpL61OYqmnuAcxdo3wu8cRxFSZKGN9mpCn7wXLhqdqJdStJzlVMVSFJHGfCS1FEGvCR1lAEvSR1lwEtSRxnwktRRBrwkdZQBL0kdZcBLUkdN9JOs9z78GGsu/7uB9t35O86KIEn98AhekjpqqCP4JDuBfcBTwJPNzT8kSVNgFKdoXltVj47gdSRJI+QpGknqqGEDvoC/T7I5ybpRFCRJGo1hT9GcX1W7k5wMbEyyo6q+MH+DJvjXASx73sohu5MktTXUEXxV7W6+7qF34+3zFthmfVXNVNXMsqOPH6Y7SVIfBg74JMckOW5uGXg9sHVUhUmShjPMKZpTgBuTzL3OJ6vqsyOpSpI0tIEDvqoeAs4eYS2SpBGa6FQFZ516PLNOOSBJE+F18JLUUQa8JHWUAS9JHWXAS1JHGfCS1FGpqsl1luwD7ptYh/07CZj2mTGnvUbrG9601zjt9cH019hvfT9UVX3P9TLRyySB+6Z5zvgks9NcH0x/jdY3vGmvcdrrg+mvcVL1eYpGkjrKgJekjpp0wK+fcH/9mvb6YPprtL7hTXuN014fTH+NE6lvom+ySpImx1M0ktRVVTX2B3AhvcsjHwAuH3NfpwGfB7YD24B3Nu0nAhuB+5uvJzTtAf6oqe0e4OXzXuuyZvv7gcvmtb8CuLfZ549o/hIaoNZlwF3ATc3zFwJ3NP19Gji8aT+ief5As37NvNe4omm/D3jDqMYcWAFcD+xoxvKV0zSGwLub7+9W4FPAkUs9fsDHgT3A1nltYx+zg/XRsr4PNt/je+jdtGfFoGMzyPi3qXHeut+kd5vQk6ZpDJv2X2/GZBvwgaUcw/3qGiSY+vxBXAY8CJwOHA7cDbxsjP2tmvtGA8cBXwFeBnxgbiCBy4HfbZYvAm5u/rP8OHDHvG/4Q83XE5rluR/OTfQCL82+Pz1grb8BfJJnA/464JJm+WrgV5vldwBXN8uXAJ9ull/WjOcRzX+MB5vxHnrMgQ3A25rlw+kF/lSMIXAq8FXgqHnj9ktLPX7ATwAvZ/8AHfuYHayPlvW9HjisWf7defX1PTb9jn/bGpv204DPAV/j2YCfljF8LfC/gSOa5ycv5RjuV+8gwdRnULwS+Ny851cAV4y733n9/S3wU/R+W65q2lbRuyYf4Brg0nnb39esvxS4Zl77NU3bKmDHvPb9tuujrtXALcBa4KbmP9yjPPvD9sy4Nf+xX9ksH9ZslwPHcm67YccceB69AM0B7VMxhvQC/h/o/QAf1ozfG6Zh/IA17P/DP/YxO1gfbeo7YN2/Ba5d6N+82NgM8v+3nxrp/TV5NrCTZwN+KsaQXihfsMB2SzaGc49JnIOf+2Gcs6tpG7ska4Bz6f1Jc0pVPQLQfD15kfoO1b5rgfZ+fRh4H/B08/z5wN6qenKB132mlmb9Y832/dbe1unAN4FPJLkryUeb2zJOxRhW1cPA7wFfBx6hNx6bmZ7xm28SY3awPvr1K/SOagepb5D/v60keRPwcFXdfcCqaRnDHwVeneSOJP8nyY8NWN/Ix3ASAZ8F2mrsnSbHAp8B3lVV/3SoTRdoqwHa+6ntYmBPVW1uUcdS1HgYvT9DP1JV5wLfpvdn68FMtL4kJwA/Q+/P3h8EjgF++hCvOfHvcQtTVVOSK4EngWvnmvqsY5D/v23qOhq4EvithVaPsMZhHEbvVNCPA+8FrkvvXqZLPoaTCPhd9M6fzVkN7B5nh0mW0wv3a6vqhqb5G0lWNetX0Xuj5FD1Hap99QLt/TgfeFOSncBf0TtN82FgRZK56SPmv+4ztTTrjwe+NUDtbe0CdlXVHc3z6+kF/rSM4QXAV6vqm1X1z8ANwKuYnvGbbxJjdrA+WklyGXAx8B+qOQcwQH2P0v/4t/Eier/I725+XlYDdyZ5wQA1jmsMdwE3VM8men+VnzRAfaMfwzbnFYd50Pvt9hC9b9LcGwpnjLG/AH8OfPiA9g+y/5soH2iW38j+b9RsatpPpHce+oTm8VXgxGbd/222nXuj5qIh6n0Nz77J+tfs/wbLO5rlX2P/N1iua5bPYP83cR6i9wbO0GMOfBF4cbN8VTN+UzGGwL+md7XC0c3+G+hdxbDk48e/PD879jE7WB8t67sQ+DKw8oDt+h6bfse/bY0HrNvJs+fgp2UM3w78t2b5R+mdSslSjuEztQ0aTH2GxUX0rmZ5ELhyzH39G3p/utwDbGkeF9E7X3ULvcuPbpn3DQ/wp01t9wIz817rV+hdlvQA8Mvz2mfoXZ73IPAnDHiZZPNar+HZgD+d3rv8DzTf6Ll35Y9snj/QrD993v5XNnXcx7wrUYYdc+AcYLYZx79pflCmZgyB99O7vG8r8BfND9GSjh+9yzUfAf6Z3hHXWycxZgfro2V9D9ALpLmflasHHZtBxr9NjQes38n+l0lOwxgeDvxl87p3AmuXcgznP/wkqyR1lJ9klaSOMuAlqaMMeEnqKANekjrKgJekjjLgJamjDHhJ6igDXpI66v8DCYogRNuG4+kAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df.nlargest(10,\"Total\")[\"Total\"].sort_values().plot(kind='barh')"
   ]
  },
  {
   "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}