exploring car sales ebay.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "This project does exploraation of ebay car sales "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "autos = pd.read_csv('autos.csv' , encoding='Latin-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dateCrawled</th>\n",
       "      <th>name</th>\n",
       "      <th>seller</th>\n",
       "      <th>offerType</th>\n",
       "      <th>price</th>\n",
       "      <th>abtest</th>\n",
       "      <th>vehicleType</th>\n",
       "      <th>yearOfRegistration</th>\n",
       "      <th>gearbox</th>\n",
       "      <th>powerPS</th>\n",
       "      <th>model</th>\n",
       "      <th>odometer</th>\n",
       "      <th>monthOfRegistration</th>\n",
       "      <th>fuelType</th>\n",
       "      <th>brand</th>\n",
       "      <th>notRepairedDamage</th>\n",
       "      <th>dateCreated</th>\n",
       "      <th>nrOfPictures</th>\n",
       "      <th>postalCode</th>\n",
       "      <th>lastSeen</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-03-26 17:47:46</td>\n",
       "      <td>Peugeot_807_160_NAVTECH_ON_BOARD</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$5,000</td>\n",
       "      <td>control</td>\n",
       "      <td>bus</td>\n",
       "      <td>2004</td>\n",
       "      <td>manuell</td>\n",
       "      <td>158</td>\n",
       "      <td>andere</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>3</td>\n",
       "      <td>lpg</td>\n",
       "      <td>peugeot</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-26 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>79588</td>\n",
       "      <td>2016-04-06 06:45:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-04-04 13:38:56</td>\n",
       "      <td>BMW_740i_4_4_Liter_HAMANN_UMBAU_Mega_Optik</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$8,500</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>1997</td>\n",
       "      <td>automatik</td>\n",
       "      <td>286</td>\n",
       "      <td>7er</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>6</td>\n",
       "      <td>benzin</td>\n",
       "      <td>bmw</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-04 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>71034</td>\n",
       "      <td>2016-04-06 14:45:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016-03-26 18:57:24</td>\n",
       "      <td>Volkswagen_Golf_1.6_United</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$8,990</td>\n",
       "      <td>test</td>\n",
       "      <td>limousine</td>\n",
       "      <td>2009</td>\n",
       "      <td>manuell</td>\n",
       "      <td>102</td>\n",
       "      <td>golf</td>\n",
       "      <td>70,000km</td>\n",
       "      <td>7</td>\n",
       "      <td>benzin</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-26 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>35394</td>\n",
       "      <td>2016-04-06 20:15:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016-03-12 16:58:10</td>\n",
       "      <td>Smart_smart_fortwo_coupe_softouch/F1/Klima/Pan...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$4,350</td>\n",
       "      <td>control</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>2007</td>\n",
       "      <td>automatik</td>\n",
       "      <td>71</td>\n",
       "      <td>fortwo</td>\n",
       "      <td>70,000km</td>\n",
       "      <td>6</td>\n",
       "      <td>benzin</td>\n",
       "      <td>smart</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-12 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>33729</td>\n",
       "      <td>2016-03-15 03:16:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016-04-01 14:38:50</td>\n",
       "      <td>Ford_Focus_1_6_Benzin_TÜV_neu_ist_sehr_gepfleg...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$1,350</td>\n",
       "      <td>test</td>\n",
       "      <td>kombi</td>\n",
       "      <td>2003</td>\n",
       "      <td>manuell</td>\n",
       "      <td>0</td>\n",
       "      <td>focus</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>7</td>\n",
       "      <td>benzin</td>\n",
       "      <td>ford</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-01 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>39218</td>\n",
       "      <td>2016-04-01 14:38:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2016-03-21 13:47:45</td>\n",
       "      <td>Chrysler_Grand_Voyager_2.8_CRD_Aut.Limited_Sto...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$7,900</td>\n",
       "      <td>test</td>\n",
       "      <td>bus</td>\n",
       "      <td>2006</td>\n",
       "      <td>automatik</td>\n",
       "      <td>150</td>\n",
       "      <td>voyager</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>4</td>\n",
       "      <td>diesel</td>\n",
       "      <td>chrysler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-21 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>22962</td>\n",
       "      <td>2016-04-06 09:45:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2016-03-20 17:55:21</td>\n",
       "      <td>VW_Golf_III_GT_Special_Electronic_Green_Metall...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$300</td>\n",
       "      <td>test</td>\n",
       "      <td>limousine</td>\n",
       "      <td>1995</td>\n",
       "      <td>manuell</td>\n",
       "      <td>90</td>\n",
       "      <td>golf</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>8</td>\n",
       "      <td>benzin</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-20 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>31535</td>\n",
       "      <td>2016-03-23 02:48:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2016-03-16 18:55:19</td>\n",
       "      <td>Golf_IV_1.9_TDI_90PS</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$1,990</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>1998</td>\n",
       "      <td>manuell</td>\n",
       "      <td>90</td>\n",
       "      <td>golf</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>12</td>\n",
       "      <td>diesel</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-16 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>53474</td>\n",
       "      <td>2016-04-07 03:17:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2016-03-22 16:51:34</td>\n",
       "      <td>Seat_Arosa</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$250</td>\n",
       "      <td>test</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "      <td>manuell</td>\n",
       "      <td>0</td>\n",
       "      <td>arosa</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>seat</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-22 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>7426</td>\n",
       "      <td>2016-03-26 18:18:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2016-03-16 13:47:02</td>\n",
       "      <td>Renault_Megane_Scenic_1.6e_RT_Klimaanlage</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$590</td>\n",
       "      <td>control</td>\n",
       "      <td>bus</td>\n",
       "      <td>1997</td>\n",
       "      <td>manuell</td>\n",
       "      <td>90</td>\n",
       "      <td>megane</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>7</td>\n",
       "      <td>benzin</td>\n",
       "      <td>renault</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-16 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>15749</td>\n",
       "      <td>2016-04-06 10:46:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2016-03-15 01:41:36</td>\n",
       "      <td>VW_Golf_Tuning_in_siber/grau</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$999</td>\n",
       "      <td>test</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017</td>\n",
       "      <td>manuell</td>\n",
       "      <td>90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>4</td>\n",
       "      <td>benzin</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-14 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>86157</td>\n",
       "      <td>2016-04-07 03:16:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2016-03-16 18:45:34</td>\n",
       "      <td>Mercedes_A140_Motorschaden</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$350</td>\n",
       "      <td>control</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>0</td>\n",
       "      <td>benzin</td>\n",
       "      <td>mercedes_benz</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-16 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>17498</td>\n",
       "      <td>2016-03-16 18:45:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2016-03-31 19:48:22</td>\n",
       "      <td>Smart_smart_fortwo_coupe_softouch_pure_MHD_Pan...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$5,299</td>\n",
       "      <td>control</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>2010</td>\n",
       "      <td>automatik</td>\n",
       "      <td>71</td>\n",
       "      <td>fortwo</td>\n",
       "      <td>50,000km</td>\n",
       "      <td>9</td>\n",
       "      <td>benzin</td>\n",
       "      <td>smart</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-31 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>34590</td>\n",
       "      <td>2016-04-06 14:17:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2016-03-23 10:48:32</td>\n",
       "      <td>Audi_A3_1.6_tuning</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$1,350</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>1999</td>\n",
       "      <td>manuell</td>\n",
       "      <td>101</td>\n",
       "      <td>a3</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>11</td>\n",
       "      <td>benzin</td>\n",
       "      <td>audi</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-23 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>12043</td>\n",
       "      <td>2016-04-01 14:17:13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2016-03-23 11:50:46</td>\n",
       "      <td>Renault_Clio_3__Dynamique_1.2__16_V;_viele_Ver...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$3,999</td>\n",
       "      <td>test</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>2007</td>\n",
       "      <td>manuell</td>\n",
       "      <td>75</td>\n",
       "      <td>clio</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>9</td>\n",
       "      <td>benzin</td>\n",
       "      <td>renault</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-23 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>81737</td>\n",
       "      <td>2016-04-01 15:46:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2016-04-01 12:06:20</td>\n",
       "      <td>Corvette_C3_Coupe_T_Top_Crossfire_Injection</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$18,900</td>\n",
       "      <td>test</td>\n",
       "      <td>coupe</td>\n",
       "      <td>1982</td>\n",
       "      <td>automatik</td>\n",
       "      <td>203</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80,000km</td>\n",
       "      <td>6</td>\n",
       "      <td>benzin</td>\n",
       "      <td>sonstige_autos</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-01 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>61276</td>\n",
       "      <td>2016-04-02 21:10:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2016-03-16 14:59:02</td>\n",
       "      <td>Opel_Vectra_B_Kombi</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$350</td>\n",
       "      <td>test</td>\n",
       "      <td>kombi</td>\n",
       "      <td>1999</td>\n",
       "      <td>manuell</td>\n",
       "      <td>101</td>\n",
       "      <td>vectra</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>5</td>\n",
       "      <td>benzin</td>\n",
       "      <td>opel</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-16 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>57299</td>\n",
       "      <td>2016-03-18 05:29:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2016-03-29 11:46:22</td>\n",
       "      <td>Volkswagen_Scirocco_2_G60</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$5,500</td>\n",
       "      <td>test</td>\n",
       "      <td>coupe</td>\n",
       "      <td>1990</td>\n",
       "      <td>manuell</td>\n",
       "      <td>205</td>\n",
       "      <td>scirocco</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>6</td>\n",
       "      <td>benzin</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-29 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>74821</td>\n",
       "      <td>2016-04-05 20:46:26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2016-03-26 19:57:44</td>\n",
       "      <td>Verkaufen_mein_bmw_e36_320_i_touring</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$300</td>\n",
       "      <td>control</td>\n",
       "      <td>bus</td>\n",
       "      <td>1995</td>\n",
       "      <td>manuell</td>\n",
       "      <td>150</td>\n",
       "      <td>3er</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>0</td>\n",
       "      <td>benzin</td>\n",
       "      <td>bmw</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-26 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>54329</td>\n",
       "      <td>2016-04-02 12:16:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2016-03-17 13:36:21</td>\n",
       "      <td>mazda_tribute_2.0_mit_gas_und_tuev_neu_2018</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$4,150</td>\n",
       "      <td>control</td>\n",
       "      <td>suv</td>\n",
       "      <td>2004</td>\n",
       "      <td>manuell</td>\n",
       "      <td>124</td>\n",
       "      <td>andere</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>2</td>\n",
       "      <td>lpg</td>\n",
       "      <td>mazda</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-17 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>40878</td>\n",
       "      <td>2016-03-17 14:45:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2016-03-05 19:57:31</td>\n",
       "      <td>Audi_A4_Avant_1.9_TDI_*6_Gang*AHK*Klimatronik*...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$3,500</td>\n",
       "      <td>test</td>\n",
       "      <td>kombi</td>\n",
       "      <td>2003</td>\n",
       "      <td>manuell</td>\n",
       "      <td>131</td>\n",
       "      <td>a4</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>5</td>\n",
       "      <td>diesel</td>\n",
       "      <td>audi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-05 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>53913</td>\n",
       "      <td>2016-03-07 05:46:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2016-03-06 19:07:10</td>\n",
       "      <td>Porsche_911_Carrera_4S_Cabrio</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$41,500</td>\n",
       "      <td>test</td>\n",
       "      <td>cabrio</td>\n",
       "      <td>2004</td>\n",
       "      <td>manuell</td>\n",
       "      <td>320</td>\n",
       "      <td>911</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>4</td>\n",
       "      <td>benzin</td>\n",
       "      <td>porsche</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-06 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>65428</td>\n",
       "      <td>2016-04-05 23:46:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2016-03-28 20:50:54</td>\n",
       "      <td>MINI_Cooper_S_Cabrio</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$25,450</td>\n",
       "      <td>control</td>\n",
       "      <td>cabrio</td>\n",
       "      <td>2015</td>\n",
       "      <td>manuell</td>\n",
       "      <td>184</td>\n",
       "      <td>cooper</td>\n",
       "      <td>10,000km</td>\n",
       "      <td>1</td>\n",
       "      <td>benzin</td>\n",
       "      <td>mini</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-28 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>44789</td>\n",
       "      <td>2016-04-01 06:45:30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2016-03-10 19:55:34</td>\n",
       "      <td>Peugeot_Boxer_2_2_HDi_120_Ps_9_Sitzer_inkl_Klima</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$7,999</td>\n",
       "      <td>control</td>\n",
       "      <td>bus</td>\n",
       "      <td>2010</td>\n",
       "      <td>manuell</td>\n",
       "      <td>120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>2</td>\n",
       "      <td>diesel</td>\n",
       "      <td>peugeot</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-10 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>30900</td>\n",
       "      <td>2016-03-17 08:45:17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2016-04-03 11:57:02</td>\n",
       "      <td>BMW_535i_xDrive_Sport_Aut.</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$48,500</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>2014</td>\n",
       "      <td>automatik</td>\n",
       "      <td>306</td>\n",
       "      <td>5er</td>\n",
       "      <td>30,000km</td>\n",
       "      <td>12</td>\n",
       "      <td>benzin</td>\n",
       "      <td>bmw</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-03 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>22547</td>\n",
       "      <td>2016-04-07 13:16:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2016-03-21 21:56:18</td>\n",
       "      <td>Ford_escort_kombi_an_bastler_mit_ghia_ausstattung</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$90</td>\n",
       "      <td>control</td>\n",
       "      <td>kombi</td>\n",
       "      <td>1996</td>\n",
       "      <td>manuell</td>\n",
       "      <td>116</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>4</td>\n",
       "      <td>benzin</td>\n",
       "      <td>ford</td>\n",
       "      <td>ja</td>\n",
       "      <td>2016-03-21 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>27574</td>\n",
       "      <td>2016-04-01 05:16:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2016-04-03 22:46:28</td>\n",
       "      <td>Volkswagen_Polo_Fox</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$777</td>\n",
       "      <td>control</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>1992</td>\n",
       "      <td>manuell</td>\n",
       "      <td>54</td>\n",
       "      <td>polo</td>\n",
       "      <td>125,000km</td>\n",
       "      <td>2</td>\n",
       "      <td>benzin</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-03 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>38110</td>\n",
       "      <td>2016-04-05 23:46:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2016-03-27 18:45:01</td>\n",
       "      <td>Hat_einer_Ahnung_mit_Ford_Galaxy_HILFE</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$0</td>\n",
       "      <td>control</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-27 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>66701</td>\n",
       "      <td>2016-03-27 18:45:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2016-03-19 21:56:19</td>\n",
       "      <td>MINI_Cooper_D</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$5,250</td>\n",
       "      <td>control</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>2007</td>\n",
       "      <td>manuell</td>\n",
       "      <td>110</td>\n",
       "      <td>cooper</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>7</td>\n",
       "      <td>diesel</td>\n",
       "      <td>mini</td>\n",
       "      <td>ja</td>\n",
       "      <td>2016-03-19 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>15745</td>\n",
       "      <td>2016-04-07 14:58:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2016-04-02 12:45:44</td>\n",
       "      <td>Mercedes_Benz_E_320_T_CDI_Avantgarde_DPF7_Sitz...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$4,999</td>\n",
       "      <td>test</td>\n",
       "      <td>kombi</td>\n",
       "      <td>2004</td>\n",
       "      <td>automatik</td>\n",
       "      <td>204</td>\n",
       "      <td>e_klasse</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>10</td>\n",
       "      <td>diesel</td>\n",
       "      <td>mercedes_benz</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-02 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>47638</td>\n",
       "      <td>2016-04-02 12:45:44</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",
       "      <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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49970</th>\n",
       "      <td>2016-03-21 22:47:37</td>\n",
       "      <td>c4_Grand_Picasso_mit_Automatik_Leder_Navi_Temp...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$15,800</td>\n",
       "      <td>control</td>\n",
       "      <td>bus</td>\n",
       "      <td>2010</td>\n",
       "      <td>automatik</td>\n",
       "      <td>136</td>\n",
       "      <td>c4</td>\n",
       "      <td>60,000km</td>\n",
       "      <td>4</td>\n",
       "      <td>diesel</td>\n",
       "      <td>citroen</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-21 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>14947</td>\n",
       "      <td>2016-04-07 04:17:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49971</th>\n",
       "      <td>2016-03-29 14:54:12</td>\n",
       "      <td>W.Lupo_1.0</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$950</td>\n",
       "      <td>test</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>2001</td>\n",
       "      <td>manuell</td>\n",
       "      <td>50</td>\n",
       "      <td>lupo</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>4</td>\n",
       "      <td>benzin</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-29 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>65197</td>\n",
       "      <td>2016-03-29 20:41:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49972</th>\n",
       "      <td>2016-03-26 22:25:23</td>\n",
       "      <td>Mercedes_Benz_Vito_115_CDI_Extralang_Aut.</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$3,300</td>\n",
       "      <td>control</td>\n",
       "      <td>bus</td>\n",
       "      <td>2004</td>\n",
       "      <td>automatik</td>\n",
       "      <td>150</td>\n",
       "      <td>vito</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>10</td>\n",
       "      <td>diesel</td>\n",
       "      <td>mercedes_benz</td>\n",
       "      <td>ja</td>\n",
       "      <td>2016-03-26 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>65326</td>\n",
       "      <td>2016-03-28 11:28:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49973</th>\n",
       "      <td>2016-03-27 05:32:39</td>\n",
       "      <td>Mercedes_Benz_SLK_200_Kompressor</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$6,000</td>\n",
       "      <td>control</td>\n",
       "      <td>cabrio</td>\n",
       "      <td>2004</td>\n",
       "      <td>manuell</td>\n",
       "      <td>163</td>\n",
       "      <td>slk</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>11</td>\n",
       "      <td>benzin</td>\n",
       "      <td>mercedes_benz</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-27 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>53567</td>\n",
       "      <td>2016-03-27 08:25:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49974</th>\n",
       "      <td>2016-03-20 10:52:31</td>\n",
       "      <td>Golf_1_Cabrio_Tuev_Neu_viele_Extras_alles_eing...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$0</td>\n",
       "      <td>control</td>\n",
       "      <td>cabrio</td>\n",
       "      <td>1983</td>\n",
       "      <td>manuell</td>\n",
       "      <td>70</td>\n",
       "      <td>golf</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>2</td>\n",
       "      <td>benzin</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-20 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>8209</td>\n",
       "      <td>2016-03-27 19:48:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49975</th>\n",
       "      <td>2016-03-27 20:51:39</td>\n",
       "      <td>Honda_Jazz_1.3_DSi_i_VTEC_IMA_CVT_Comfort</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$9,700</td>\n",
       "      <td>control</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>2012</td>\n",
       "      <td>automatik</td>\n",
       "      <td>88</td>\n",
       "      <td>jazz</td>\n",
       "      <td>100,000km</td>\n",
       "      <td>11</td>\n",
       "      <td>hybrid</td>\n",
       "      <td>honda</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-27 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>84385</td>\n",
       "      <td>2016-04-05 19:45:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49976</th>\n",
       "      <td>2016-03-19 18:56:05</td>\n",
       "      <td>Audi_80_Avant_2.6_E__Vollausstattung!!_Einziga...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$5,900</td>\n",
       "      <td>test</td>\n",
       "      <td>kombi</td>\n",
       "      <td>1992</td>\n",
       "      <td>automatik</td>\n",
       "      <td>150</td>\n",
       "      <td>80</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>12</td>\n",
       "      <td>benzin</td>\n",
       "      <td>audi</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-19 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>36100</td>\n",
       "      <td>2016-04-07 06:16:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49977</th>\n",
       "      <td>2016-03-31 18:37:18</td>\n",
       "      <td>Mercedes_Benz_C200_Cdi_W203</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$5,500</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>2003</td>\n",
       "      <td>manuell</td>\n",
       "      <td>116</td>\n",
       "      <td>c_klasse</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>2</td>\n",
       "      <td>diesel</td>\n",
       "      <td>mercedes_benz</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-31 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>33739</td>\n",
       "      <td>2016-04-06 12:16:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49978</th>\n",
       "      <td>2016-04-04 10:37:14</td>\n",
       "      <td>Mercedes_Benz_E_200_Classic</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$900</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>1996</td>\n",
       "      <td>automatik</td>\n",
       "      <td>136</td>\n",
       "      <td>e_klasse</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>9</td>\n",
       "      <td>benzin</td>\n",
       "      <td>mercedes_benz</td>\n",
       "      <td>ja</td>\n",
       "      <td>2016-04-04 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>24405</td>\n",
       "      <td>2016-04-06 12:44:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49979</th>\n",
       "      <td>2016-03-20 18:38:40</td>\n",
       "      <td>Volkswagen_Polo_1.6_TDI_Style</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$11,000</td>\n",
       "      <td>test</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>2011</td>\n",
       "      <td>manuell</td>\n",
       "      <td>90</td>\n",
       "      <td>polo</td>\n",
       "      <td>70,000km</td>\n",
       "      <td>11</td>\n",
       "      <td>diesel</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-20 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>48455</td>\n",
       "      <td>2016-04-07 01:45:12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49980</th>\n",
       "      <td>2016-03-12 10:55:54</td>\n",
       "      <td>Ford_Escort_Turnier_16V</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$400</td>\n",
       "      <td>control</td>\n",
       "      <td>kombi</td>\n",
       "      <td>1995</td>\n",
       "      <td>manuell</td>\n",
       "      <td>105</td>\n",
       "      <td>escort</td>\n",
       "      <td>125,000km</td>\n",
       "      <td>3</td>\n",
       "      <td>benzin</td>\n",
       "      <td>ford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-12 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>56218</td>\n",
       "      <td>2016-04-06 17:16:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49981</th>\n",
       "      <td>2016-03-15 09:38:21</td>\n",
       "      <td>Opel_Astra_Kombi_mit_Anhaengerkupplung</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$2,000</td>\n",
       "      <td>control</td>\n",
       "      <td>kombi</td>\n",
       "      <td>1998</td>\n",
       "      <td>manuell</td>\n",
       "      <td>115</td>\n",
       "      <td>astra</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>12</td>\n",
       "      <td>benzin</td>\n",
       "      <td>opel</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-15 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>86859</td>\n",
       "      <td>2016-04-05 17:21:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49982</th>\n",
       "      <td>2016-03-29 18:51:08</td>\n",
       "      <td>Skoda_Fabia_4_Tuerer_Bj:2004__85.000Tkm</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$1,950</td>\n",
       "      <td>control</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>2004</td>\n",
       "      <td>manuell</td>\n",
       "      <td>0</td>\n",
       "      <td>fabia</td>\n",
       "      <td>90,000km</td>\n",
       "      <td>7</td>\n",
       "      <td>benzin</td>\n",
       "      <td>skoda</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-29 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>45884</td>\n",
       "      <td>2016-03-29 18:51:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49983</th>\n",
       "      <td>2016-03-06 12:43:04</td>\n",
       "      <td>Ford_focus_99</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$600</td>\n",
       "      <td>test</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>1999</td>\n",
       "      <td>manuell</td>\n",
       "      <td>101</td>\n",
       "      <td>focus</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>4</td>\n",
       "      <td>benzin</td>\n",
       "      <td>ford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-06 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>52477</td>\n",
       "      <td>2016-03-09 06:16:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49984</th>\n",
       "      <td>2016-03-31 22:48:48</td>\n",
       "      <td>Student_sucht_ein__Anfaengerauto___ab_2000_BJ_...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$0</td>\n",
       "      <td>test</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>sonstige_autos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-31 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>12103</td>\n",
       "      <td>2016-04-02 19:44:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49985</th>\n",
       "      <td>2016-04-02 16:38:23</td>\n",
       "      <td>Verkaufe_meinen_vw_vento!</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$1,000</td>\n",
       "      <td>control</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1995</td>\n",
       "      <td>automatik</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>0</td>\n",
       "      <td>benzin</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-04-02 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>30900</td>\n",
       "      <td>2016-04-06 15:17:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49986</th>\n",
       "      <td>2016-04-04 20:46:02</td>\n",
       "      <td>Chrysler_300C_3.0_CRD_DPF_Automatik_Voll_Ausst...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$15,900</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>2010</td>\n",
       "      <td>automatik</td>\n",
       "      <td>218</td>\n",
       "      <td>300c</td>\n",
       "      <td>125,000km</td>\n",
       "      <td>11</td>\n",
       "      <td>diesel</td>\n",
       "      <td>chrysler</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-04 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>73527</td>\n",
       "      <td>2016-04-06 23:16:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49987</th>\n",
       "      <td>2016-03-22 20:47:27</td>\n",
       "      <td>Audi_A3_Limousine_2.0_TDI_DPF_Ambition__NAVI__...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$21,990</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>2013</td>\n",
       "      <td>manuell</td>\n",
       "      <td>150</td>\n",
       "      <td>a3</td>\n",
       "      <td>50,000km</td>\n",
       "      <td>11</td>\n",
       "      <td>diesel</td>\n",
       "      <td>audi</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-22 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>94362</td>\n",
       "      <td>2016-03-26 22:46:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49988</th>\n",
       "      <td>2016-03-28 19:49:51</td>\n",
       "      <td>BMW_330_Ci</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$9,550</td>\n",
       "      <td>control</td>\n",
       "      <td>coupe</td>\n",
       "      <td>2001</td>\n",
       "      <td>manuell</td>\n",
       "      <td>231</td>\n",
       "      <td>3er</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>10</td>\n",
       "      <td>benzin</td>\n",
       "      <td>bmw</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-28 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>83646</td>\n",
       "      <td>2016-04-07 02:17:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49989</th>\n",
       "      <td>2016-03-11 19:50:37</td>\n",
       "      <td>VW_Polo_zum_Ausschlachten_oder_Wiederaufbau</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$150</td>\n",
       "      <td>test</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>1997</td>\n",
       "      <td>manuell</td>\n",
       "      <td>0</td>\n",
       "      <td>polo</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>5</td>\n",
       "      <td>benzin</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>ja</td>\n",
       "      <td>2016-03-11 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>21244</td>\n",
       "      <td>2016-03-12 10:17:55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49990</th>\n",
       "      <td>2016-03-21 19:54:19</td>\n",
       "      <td>Mercedes_Benz_A_200__BlueEFFICIENCY__Urban</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$17,500</td>\n",
       "      <td>test</td>\n",
       "      <td>limousine</td>\n",
       "      <td>2012</td>\n",
       "      <td>manuell</td>\n",
       "      <td>156</td>\n",
       "      <td>a_klasse</td>\n",
       "      <td>30,000km</td>\n",
       "      <td>12</td>\n",
       "      <td>benzin</td>\n",
       "      <td>mercedes_benz</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-21 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>58239</td>\n",
       "      <td>2016-04-06 22:46:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49991</th>\n",
       "      <td>2016-03-06 15:25:19</td>\n",
       "      <td>Kleinwagen</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$500</td>\n",
       "      <td>control</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016</td>\n",
       "      <td>manuell</td>\n",
       "      <td>0</td>\n",
       "      <td>twingo</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>0</td>\n",
       "      <td>benzin</td>\n",
       "      <td>renault</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-06 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>61350</td>\n",
       "      <td>2016-03-06 18:24:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49992</th>\n",
       "      <td>2016-03-10 19:37:38</td>\n",
       "      <td>Fiat_Grande_Punto_1.4_T_Jet_16V_Sport</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$4,800</td>\n",
       "      <td>control</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>2009</td>\n",
       "      <td>manuell</td>\n",
       "      <td>120</td>\n",
       "      <td>andere</td>\n",
       "      <td>125,000km</td>\n",
       "      <td>9</td>\n",
       "      <td>lpg</td>\n",
       "      <td>fiat</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-10 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>68642</td>\n",
       "      <td>2016-03-13 01:44:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49993</th>\n",
       "      <td>2016-03-15 18:47:35</td>\n",
       "      <td>Audi_A3__1_8l__Silber;_schoenes_Fahrzeug</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$1,650</td>\n",
       "      <td>control</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>1997</td>\n",
       "      <td>manuell</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>7</td>\n",
       "      <td>benzin</td>\n",
       "      <td>audi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-15 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>65203</td>\n",
       "      <td>2016-04-06 19:46:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49994</th>\n",
       "      <td>2016-03-22 17:36:42</td>\n",
       "      <td>Audi_A6__S6__Avant_4.2_quattro_eventuell_Tausc...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$5,000</td>\n",
       "      <td>control</td>\n",
       "      <td>kombi</td>\n",
       "      <td>2001</td>\n",
       "      <td>automatik</td>\n",
       "      <td>299</td>\n",
       "      <td>a6</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>1</td>\n",
       "      <td>benzin</td>\n",
       "      <td>audi</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-22 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>46537</td>\n",
       "      <td>2016-04-06 08:16:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49995</th>\n",
       "      <td>2016-03-27 14:38:19</td>\n",
       "      <td>Audi_Q5_3.0_TDI_qu._S_tr.__Navi__Panorama__Xenon</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$24,900</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>2011</td>\n",
       "      <td>automatik</td>\n",
       "      <td>239</td>\n",
       "      <td>q5</td>\n",
       "      <td>100,000km</td>\n",
       "      <td>1</td>\n",
       "      <td>diesel</td>\n",
       "      <td>audi</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-27 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>82131</td>\n",
       "      <td>2016-04-01 13:47:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49996</th>\n",
       "      <td>2016-03-28 10:50:25</td>\n",
       "      <td>Opel_Astra_F_Cabrio_Bertone_Edition___TÜV_neu+...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$1,980</td>\n",
       "      <td>control</td>\n",
       "      <td>cabrio</td>\n",
       "      <td>1996</td>\n",
       "      <td>manuell</td>\n",
       "      <td>75</td>\n",
       "      <td>astra</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>5</td>\n",
       "      <td>benzin</td>\n",
       "      <td>opel</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-28 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>44807</td>\n",
       "      <td>2016-04-02 14:18:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49997</th>\n",
       "      <td>2016-04-02 14:44:48</td>\n",
       "      <td>Fiat_500_C_1.2_Dualogic_Lounge</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$13,200</td>\n",
       "      <td>test</td>\n",
       "      <td>cabrio</td>\n",
       "      <td>2014</td>\n",
       "      <td>automatik</td>\n",
       "      <td>69</td>\n",
       "      <td>500</td>\n",
       "      <td>5,000km</td>\n",
       "      <td>11</td>\n",
       "      <td>benzin</td>\n",
       "      <td>fiat</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-02 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>73430</td>\n",
       "      <td>2016-04-04 11:47:27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49998</th>\n",
       "      <td>2016-03-08 19:25:42</td>\n",
       "      <td>Audi_A3_2.0_TDI_Sportback_Ambition</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$22,900</td>\n",
       "      <td>control</td>\n",
       "      <td>kombi</td>\n",
       "      <td>2013</td>\n",
       "      <td>manuell</td>\n",
       "      <td>150</td>\n",
       "      <td>a3</td>\n",
       "      <td>40,000km</td>\n",
       "      <td>11</td>\n",
       "      <td>diesel</td>\n",
       "      <td>audi</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-08 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>35683</td>\n",
       "      <td>2016-04-05 16:45:07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49999</th>\n",
       "      <td>2016-03-14 00:42:12</td>\n",
       "      <td>Opel_Vectra_1.6_16V</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$1,250</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>1996</td>\n",
       "      <td>manuell</td>\n",
       "      <td>101</td>\n",
       "      <td>vectra</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>1</td>\n",
       "      <td>benzin</td>\n",
       "      <td>opel</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-13 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>45897</td>\n",
       "      <td>2016-04-06 21:18:48</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>50000 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               dateCrawled                                               name  \\\n",
       "0      2016-03-26 17:47:46                   Peugeot_807_160_NAVTECH_ON_BOARD   \n",
       "1      2016-04-04 13:38:56         BMW_740i_4_4_Liter_HAMANN_UMBAU_Mega_Optik   \n",
       "2      2016-03-26 18:57:24                         Volkswagen_Golf_1.6_United   \n",
       "3      2016-03-12 16:58:10  Smart_smart_fortwo_coupe_softouch/F1/Klima/Pan...   \n",
       "4      2016-04-01 14:38:50  Ford_Focus_1_6_Benzin_TÜV_neu_ist_sehr_gepfleg...   \n",
       "5      2016-03-21 13:47:45  Chrysler_Grand_Voyager_2.8_CRD_Aut.Limited_Sto...   \n",
       "6      2016-03-20 17:55:21  VW_Golf_III_GT_Special_Electronic_Green_Metall...   \n",
       "7      2016-03-16 18:55:19                               Golf_IV_1.9_TDI_90PS   \n",
       "8      2016-03-22 16:51:34                                         Seat_Arosa   \n",
       "9      2016-03-16 13:47:02          Renault_Megane_Scenic_1.6e_RT_Klimaanlage   \n",
       "10     2016-03-15 01:41:36                       VW_Golf_Tuning_in_siber/grau   \n",
       "11     2016-03-16 18:45:34                         Mercedes_A140_Motorschaden   \n",
       "12     2016-03-31 19:48:22  Smart_smart_fortwo_coupe_softouch_pure_MHD_Pan...   \n",
       "13     2016-03-23 10:48:32                                 Audi_A3_1.6_tuning   \n",
       "14     2016-03-23 11:50:46  Renault_Clio_3__Dynamique_1.2__16_V;_viele_Ver...   \n",
       "15     2016-04-01 12:06:20        Corvette_C3_Coupe_T_Top_Crossfire_Injection   \n",
       "16     2016-03-16 14:59:02                                Opel_Vectra_B_Kombi   \n",
       "17     2016-03-29 11:46:22                          Volkswagen_Scirocco_2_G60   \n",
       "18     2016-03-26 19:57:44               Verkaufen_mein_bmw_e36_320_i_touring   \n",
       "19     2016-03-17 13:36:21        mazda_tribute_2.0_mit_gas_und_tuev_neu_2018   \n",
       "20     2016-03-05 19:57:31  Audi_A4_Avant_1.9_TDI_*6_Gang*AHK*Klimatronik*...   \n",
       "21     2016-03-06 19:07:10                      Porsche_911_Carrera_4S_Cabrio   \n",
       "22     2016-03-28 20:50:54                               MINI_Cooper_S_Cabrio   \n",
       "23     2016-03-10 19:55:34   Peugeot_Boxer_2_2_HDi_120_Ps_9_Sitzer_inkl_Klima   \n",
       "24     2016-04-03 11:57:02                         BMW_535i_xDrive_Sport_Aut.   \n",
       "25     2016-03-21 21:56:18  Ford_escort_kombi_an_bastler_mit_ghia_ausstattung   \n",
       "26     2016-04-03 22:46:28                                Volkswagen_Polo_Fox   \n",
       "27     2016-03-27 18:45:01             Hat_einer_Ahnung_mit_Ford_Galaxy_HILFE   \n",
       "28     2016-03-19 21:56:19                                      MINI_Cooper_D   \n",
       "29     2016-04-02 12:45:44  Mercedes_Benz_E_320_T_CDI_Avantgarde_DPF7_Sitz...   \n",
       "...                    ...                                                ...   \n",
       "49970  2016-03-21 22:47:37  c4_Grand_Picasso_mit_Automatik_Leder_Navi_Temp...   \n",
       "49971  2016-03-29 14:54:12                                         W.Lupo_1.0   \n",
       "49972  2016-03-26 22:25:23          Mercedes_Benz_Vito_115_CDI_Extralang_Aut.   \n",
       "49973  2016-03-27 05:32:39                   Mercedes_Benz_SLK_200_Kompressor   \n",
       "49974  2016-03-20 10:52:31  Golf_1_Cabrio_Tuev_Neu_viele_Extras_alles_eing...   \n",
       "49975  2016-03-27 20:51:39          Honda_Jazz_1.3_DSi_i_VTEC_IMA_CVT_Comfort   \n",
       "49976  2016-03-19 18:56:05  Audi_80_Avant_2.6_E__Vollausstattung!!_Einziga...   \n",
       "49977  2016-03-31 18:37:18                        Mercedes_Benz_C200_Cdi_W203   \n",
       "49978  2016-04-04 10:37:14                        Mercedes_Benz_E_200_Classic   \n",
       "49979  2016-03-20 18:38:40                      Volkswagen_Polo_1.6_TDI_Style   \n",
       "49980  2016-03-12 10:55:54                            Ford_Escort_Turnier_16V   \n",
       "49981  2016-03-15 09:38:21             Opel_Astra_Kombi_mit_Anhaengerkupplung   \n",
       "49982  2016-03-29 18:51:08            Skoda_Fabia_4_Tuerer_Bj:2004__85.000Tkm   \n",
       "49983  2016-03-06 12:43:04                                      Ford_focus_99   \n",
       "49984  2016-03-31 22:48:48  Student_sucht_ein__Anfaengerauto___ab_2000_BJ_...   \n",
       "49985  2016-04-02 16:38:23                          Verkaufe_meinen_vw_vento!   \n",
       "49986  2016-04-04 20:46:02  Chrysler_300C_3.0_CRD_DPF_Automatik_Voll_Ausst...   \n",
       "49987  2016-03-22 20:47:27  Audi_A3_Limousine_2.0_TDI_DPF_Ambition__NAVI__...   \n",
       "49988  2016-03-28 19:49:51                                         BMW_330_Ci   \n",
       "49989  2016-03-11 19:50:37        VW_Polo_zum_Ausschlachten_oder_Wiederaufbau   \n",
       "49990  2016-03-21 19:54:19         Mercedes_Benz_A_200__BlueEFFICIENCY__Urban   \n",
       "49991  2016-03-06 15:25:19                                         Kleinwagen   \n",
       "49992  2016-03-10 19:37:38              Fiat_Grande_Punto_1.4_T_Jet_16V_Sport   \n",
       "49993  2016-03-15 18:47:35           Audi_A3__1_8l__Silber;_schoenes_Fahrzeug   \n",
       "49994  2016-03-22 17:36:42  Audi_A6__S6__Avant_4.2_quattro_eventuell_Tausc...   \n",
       "49995  2016-03-27 14:38:19   Audi_Q5_3.0_TDI_qu._S_tr.__Navi__Panorama__Xenon   \n",
       "49996  2016-03-28 10:50:25  Opel_Astra_F_Cabrio_Bertone_Edition___TÜV_neu+...   \n",
       "49997  2016-04-02 14:44:48                     Fiat_500_C_1.2_Dualogic_Lounge   \n",
       "49998  2016-03-08 19:25:42                 Audi_A3_2.0_TDI_Sportback_Ambition   \n",
       "49999  2016-03-14 00:42:12                                Opel_Vectra_1.6_16V   \n",
       "\n",
       "       seller offerType    price   abtest vehicleType  yearOfRegistration  \\\n",
       "0      privat   Angebot   $5,000  control         bus                2004   \n",
       "1      privat   Angebot   $8,500  control   limousine                1997   \n",
       "2      privat   Angebot   $8,990     test   limousine                2009   \n",
       "3      privat   Angebot   $4,350  control  kleinwagen                2007   \n",
       "4      privat   Angebot   $1,350     test       kombi                2003   \n",
       "5      privat   Angebot   $7,900     test         bus                2006   \n",
       "6      privat   Angebot     $300     test   limousine                1995   \n",
       "7      privat   Angebot   $1,990  control   limousine                1998   \n",
       "8      privat   Angebot     $250     test         NaN                2000   \n",
       "9      privat   Angebot     $590  control         bus                1997   \n",
       "10     privat   Angebot     $999     test         NaN                2017   \n",
       "11     privat   Angebot     $350  control         NaN                2000   \n",
       "12     privat   Angebot   $5,299  control  kleinwagen                2010   \n",
       "13     privat   Angebot   $1,350  control   limousine                1999   \n",
       "14     privat   Angebot   $3,999     test  kleinwagen                2007   \n",
       "15     privat   Angebot  $18,900     test       coupe                1982   \n",
       "16     privat   Angebot     $350     test       kombi                1999   \n",
       "17     privat   Angebot   $5,500     test       coupe                1990   \n",
       "18     privat   Angebot     $300  control         bus                1995   \n",
       "19     privat   Angebot   $4,150  control         suv                2004   \n",
       "20     privat   Angebot   $3,500     test       kombi                2003   \n",
       "21     privat   Angebot  $41,500     test      cabrio                2004   \n",
       "22     privat   Angebot  $25,450  control      cabrio                2015   \n",
       "23     privat   Angebot   $7,999  control         bus                2010   \n",
       "24     privat   Angebot  $48,500  control   limousine                2014   \n",
       "25     privat   Angebot      $90  control       kombi                1996   \n",
       "26     privat   Angebot     $777  control  kleinwagen                1992   \n",
       "27     privat   Angebot       $0  control         NaN                2005   \n",
       "28     privat   Angebot   $5,250  control  kleinwagen                2007   \n",
       "29     privat   Angebot   $4,999     test       kombi                2004   \n",
       "...       ...       ...      ...      ...         ...                 ...   \n",
       "49970  privat   Angebot  $15,800  control         bus                2010   \n",
       "49971  privat   Angebot     $950     test  kleinwagen                2001   \n",
       "49972  privat   Angebot   $3,300  control         bus                2004   \n",
       "49973  privat   Angebot   $6,000  control      cabrio                2004   \n",
       "49974  privat   Angebot       $0  control      cabrio                1983   \n",
       "49975  privat   Angebot   $9,700  control  kleinwagen                2012   \n",
       "49976  privat   Angebot   $5,900     test       kombi                1992   \n",
       "49977  privat   Angebot   $5,500  control   limousine                2003   \n",
       "49978  privat   Angebot     $900  control   limousine                1996   \n",
       "49979  privat   Angebot  $11,000     test  kleinwagen                2011   \n",
       "49980  privat   Angebot     $400  control       kombi                1995   \n",
       "49981  privat   Angebot   $2,000  control       kombi                1998   \n",
       "49982  privat   Angebot   $1,950  control  kleinwagen                2004   \n",
       "49983  privat   Angebot     $600     test  kleinwagen                1999   \n",
       "49984  privat   Angebot       $0     test         NaN                2000   \n",
       "49985  privat   Angebot   $1,000  control         NaN                1995   \n",
       "49986  privat   Angebot  $15,900  control   limousine                2010   \n",
       "49987  privat   Angebot  $21,990  control   limousine                2013   \n",
       "49988  privat   Angebot   $9,550  control       coupe                2001   \n",
       "49989  privat   Angebot     $150     test  kleinwagen                1997   \n",
       "49990  privat   Angebot  $17,500     test   limousine                2012   \n",
       "49991  privat   Angebot     $500  control         NaN                2016   \n",
       "49992  privat   Angebot   $4,800  control  kleinwagen                2009   \n",
       "49993  privat   Angebot   $1,650  control  kleinwagen                1997   \n",
       "49994  privat   Angebot   $5,000  control       kombi                2001   \n",
       "49995  privat   Angebot  $24,900  control   limousine                2011   \n",
       "49996  privat   Angebot   $1,980  control      cabrio                1996   \n",
       "49997  privat   Angebot  $13,200     test      cabrio                2014   \n",
       "49998  privat   Angebot  $22,900  control       kombi                2013   \n",
       "49999  privat   Angebot   $1,250  control   limousine                1996   \n",
       "\n",
       "         gearbox  powerPS     model   odometer  monthOfRegistration fuelType  \\\n",
       "0        manuell      158    andere  150,000km                    3      lpg   \n",
       "1      automatik      286       7er  150,000km                    6   benzin   \n",
       "2        manuell      102      golf   70,000km                    7   benzin   \n",
       "3      automatik       71    fortwo   70,000km                    6   benzin   \n",
       "4        manuell        0     focus  150,000km                    7   benzin   \n",
       "5      automatik      150   voyager  150,000km                    4   diesel   \n",
       "6        manuell       90      golf  150,000km                    8   benzin   \n",
       "7        manuell       90      golf  150,000km                   12   diesel   \n",
       "8        manuell        0     arosa  150,000km                   10      NaN   \n",
       "9        manuell       90    megane  150,000km                    7   benzin   \n",
       "10       manuell       90       NaN  150,000km                    4   benzin   \n",
       "11           NaN        0       NaN  150,000km                    0   benzin   \n",
       "12     automatik       71    fortwo   50,000km                    9   benzin   \n",
       "13       manuell      101        a3  150,000km                   11   benzin   \n",
       "14       manuell       75      clio  150,000km                    9   benzin   \n",
       "15     automatik      203       NaN   80,000km                    6   benzin   \n",
       "16       manuell      101    vectra  150,000km                    5   benzin   \n",
       "17       manuell      205  scirocco  150,000km                    6   benzin   \n",
       "18       manuell      150       3er  150,000km                    0   benzin   \n",
       "19       manuell      124    andere  150,000km                    2      lpg   \n",
       "20       manuell      131        a4  150,000km                    5   diesel   \n",
       "21       manuell      320       911  150,000km                    4   benzin   \n",
       "22       manuell      184    cooper   10,000km                    1   benzin   \n",
       "23       manuell      120       NaN  150,000km                    2   diesel   \n",
       "24     automatik      306       5er   30,000km                   12   benzin   \n",
       "25       manuell      116       NaN  150,000km                    4   benzin   \n",
       "26       manuell       54      polo  125,000km                    2   benzin   \n",
       "27           NaN        0       NaN  150,000km                    0      NaN   \n",
       "28       manuell      110    cooper  150,000km                    7   diesel   \n",
       "29     automatik      204  e_klasse  150,000km                   10   diesel   \n",
       "...          ...      ...       ...        ...                  ...      ...   \n",
       "49970  automatik      136        c4   60,000km                    4   diesel   \n",
       "49971    manuell       50      lupo  150,000km                    4   benzin   \n",
       "49972  automatik      150      vito  150,000km                   10   diesel   \n",
       "49973    manuell      163       slk  150,000km                   11   benzin   \n",
       "49974    manuell       70      golf  150,000km                    2   benzin   \n",
       "49975  automatik       88      jazz  100,000km                   11   hybrid   \n",
       "49976  automatik      150        80  150,000km                   12   benzin   \n",
       "49977    manuell      116  c_klasse  150,000km                    2   diesel   \n",
       "49978  automatik      136  e_klasse  150,000km                    9   benzin   \n",
       "49979    manuell       90      polo   70,000km                   11   diesel   \n",
       "49980    manuell      105    escort  125,000km                    3   benzin   \n",
       "49981    manuell      115     astra  150,000km                   12   benzin   \n",
       "49982    manuell        0     fabia   90,000km                    7   benzin   \n",
       "49983    manuell      101     focus  150,000km                    4   benzin   \n",
       "49984        NaN        0       NaN  150,000km                    0      NaN   \n",
       "49985  automatik        0       NaN  150,000km                    0   benzin   \n",
       "49986  automatik      218      300c  125,000km                   11   diesel   \n",
       "49987    manuell      150        a3   50,000km                   11   diesel   \n",
       "49988    manuell      231       3er  150,000km                   10   benzin   \n",
       "49989    manuell        0      polo  150,000km                    5   benzin   \n",
       "49990    manuell      156  a_klasse   30,000km                   12   benzin   \n",
       "49991    manuell        0    twingo  150,000km                    0   benzin   \n",
       "49992    manuell      120    andere  125,000km                    9      lpg   \n",
       "49993    manuell        0       NaN  150,000km                    7   benzin   \n",
       "49994  automatik      299        a6  150,000km                    1   benzin   \n",
       "49995  automatik      239        q5  100,000km                    1   diesel   \n",
       "49996    manuell       75     astra  150,000km                    5   benzin   \n",
       "49997  automatik       69       500    5,000km                   11   benzin   \n",
       "49998    manuell      150        a3   40,000km                   11   diesel   \n",
       "49999    manuell      101    vectra  150,000km                    1   benzin   \n",
       "\n",
       "                brand notRepairedDamage          dateCreated  nrOfPictures  \\\n",
       "0             peugeot              nein  2016-03-26 00:00:00             0   \n",
       "1                 bmw              nein  2016-04-04 00:00:00             0   \n",
       "2          volkswagen              nein  2016-03-26 00:00:00             0   \n",
       "3               smart              nein  2016-03-12 00:00:00             0   \n",
       "4                ford              nein  2016-04-01 00:00:00             0   \n",
       "5            chrysler               NaN  2016-03-21 00:00:00             0   \n",
       "6          volkswagen               NaN  2016-03-20 00:00:00             0   \n",
       "7          volkswagen              nein  2016-03-16 00:00:00             0   \n",
       "8                seat              nein  2016-03-22 00:00:00             0   \n",
       "9             renault              nein  2016-03-16 00:00:00             0   \n",
       "10         volkswagen              nein  2016-03-14 00:00:00             0   \n",
       "11      mercedes_benz               NaN  2016-03-16 00:00:00             0   \n",
       "12              smart              nein  2016-03-31 00:00:00             0   \n",
       "13               audi              nein  2016-03-23 00:00:00             0   \n",
       "14            renault               NaN  2016-03-23 00:00:00             0   \n",
       "15     sonstige_autos              nein  2016-04-01 00:00:00             0   \n",
       "16               opel              nein  2016-03-16 00:00:00             0   \n",
       "17         volkswagen              nein  2016-03-29 00:00:00             0   \n",
       "18                bmw               NaN  2016-03-26 00:00:00             0   \n",
       "19              mazda              nein  2016-03-17 00:00:00             0   \n",
       "20               audi               NaN  2016-03-05 00:00:00             0   \n",
       "21            porsche              nein  2016-03-06 00:00:00             0   \n",
       "22               mini              nein  2016-03-28 00:00:00             0   \n",
       "23            peugeot              nein  2016-03-10 00:00:00             0   \n",
       "24                bmw              nein  2016-04-03 00:00:00             0   \n",
       "25               ford                ja  2016-03-21 00:00:00             0   \n",
       "26         volkswagen              nein  2016-04-03 00:00:00             0   \n",
       "27               ford               NaN  2016-03-27 00:00:00             0   \n",
       "28               mini                ja  2016-03-19 00:00:00             0   \n",
       "29      mercedes_benz              nein  2016-04-02 00:00:00             0   \n",
       "...               ...               ...                  ...           ...   \n",
       "49970         citroen              nein  2016-03-21 00:00:00             0   \n",
       "49971      volkswagen              nein  2016-03-29 00:00:00             0   \n",
       "49972   mercedes_benz                ja  2016-03-26 00:00:00             0   \n",
       "49973   mercedes_benz              nein  2016-03-27 00:00:00             0   \n",
       "49974      volkswagen              nein  2016-03-20 00:00:00             0   \n",
       "49975           honda              nein  2016-03-27 00:00:00             0   \n",
       "49976            audi              nein  2016-03-19 00:00:00             0   \n",
       "49977   mercedes_benz              nein  2016-03-31 00:00:00             0   \n",
       "49978   mercedes_benz                ja  2016-04-04 00:00:00             0   \n",
       "49979      volkswagen              nein  2016-03-20 00:00:00             0   \n",
       "49980            ford               NaN  2016-03-12 00:00:00             0   \n",
       "49981            opel              nein  2016-03-15 00:00:00             0   \n",
       "49982           skoda               NaN  2016-03-29 00:00:00             0   \n",
       "49983            ford               NaN  2016-03-06 00:00:00             0   \n",
       "49984  sonstige_autos               NaN  2016-03-31 00:00:00             0   \n",
       "49985      volkswagen               NaN  2016-04-02 00:00:00             0   \n",
       "49986        chrysler              nein  2016-04-04 00:00:00             0   \n",
       "49987            audi              nein  2016-03-22 00:00:00             0   \n",
       "49988             bmw              nein  2016-03-28 00:00:00             0   \n",
       "49989      volkswagen                ja  2016-03-11 00:00:00             0   \n",
       "49990   mercedes_benz              nein  2016-03-21 00:00:00             0   \n",
       "49991         renault               NaN  2016-03-06 00:00:00             0   \n",
       "49992            fiat              nein  2016-03-10 00:00:00             0   \n",
       "49993            audi               NaN  2016-03-15 00:00:00             0   \n",
       "49994            audi              nein  2016-03-22 00:00:00             0   \n",
       "49995            audi              nein  2016-03-27 00:00:00             0   \n",
       "49996            opel              nein  2016-03-28 00:00:00             0   \n",
       "49997            fiat              nein  2016-04-02 00:00:00             0   \n",
       "49998            audi              nein  2016-03-08 00:00:00             0   \n",
       "49999            opel              nein  2016-03-13 00:00:00             0   \n",
       "\n",
       "       postalCode             lastSeen  \n",
       "0           79588  2016-04-06 06:45:54  \n",
       "1           71034  2016-04-06 14:45:08  \n",
       "2           35394  2016-04-06 20:15:37  \n",
       "3           33729  2016-03-15 03:16:28  \n",
       "4           39218  2016-04-01 14:38:50  \n",
       "5           22962  2016-04-06 09:45:21  \n",
       "6           31535  2016-03-23 02:48:59  \n",
       "7           53474  2016-04-07 03:17:32  \n",
       "8            7426  2016-03-26 18:18:10  \n",
       "9           15749  2016-04-06 10:46:35  \n",
       "10          86157  2016-04-07 03:16:21  \n",
       "11          17498  2016-03-16 18:45:34  \n",
       "12          34590  2016-04-06 14:17:52  \n",
       "13          12043  2016-04-01 14:17:13  \n",
       "14          81737  2016-04-01 15:46:47  \n",
       "15          61276  2016-04-02 21:10:48  \n",
       "16          57299  2016-03-18 05:29:37  \n",
       "17          74821  2016-04-05 20:46:26  \n",
       "18          54329  2016-04-02 12:16:41  \n",
       "19          40878  2016-03-17 14:45:58  \n",
       "20          53913  2016-03-07 05:46:46  \n",
       "21          65428  2016-04-05 23:46:19  \n",
       "22          44789  2016-04-01 06:45:30  \n",
       "23          30900  2016-03-17 08:45:17  \n",
       "24          22547  2016-04-07 13:16:50  \n",
       "25          27574  2016-04-01 05:16:49  \n",
       "26          38110  2016-04-05 23:46:48  \n",
       "27          66701  2016-03-27 18:45:01  \n",
       "28          15745  2016-04-07 14:58:48  \n",
       "29          47638  2016-04-02 12:45:44  \n",
       "...           ...                  ...  \n",
       "49970       14947  2016-04-07 04:17:34  \n",
       "49971       65197  2016-03-29 20:41:51  \n",
       "49972       65326  2016-03-28 11:28:18  \n",
       "49973       53567  2016-03-27 08:25:24  \n",
       "49974        8209  2016-03-27 19:48:16  \n",
       "49975       84385  2016-04-05 19:45:34  \n",
       "49976       36100  2016-04-07 06:16:44  \n",
       "49977       33739  2016-04-06 12:16:11  \n",
       "49978       24405  2016-04-06 12:44:20  \n",
       "49979       48455  2016-04-07 01:45:12  \n",
       "49980       56218  2016-04-06 17:16:49  \n",
       "49981       86859  2016-04-05 17:21:46  \n",
       "49982       45884  2016-03-29 18:51:08  \n",
       "49983       52477  2016-03-09 06:16:08  \n",
       "49984       12103  2016-04-02 19:44:53  \n",
       "49985       30900  2016-04-06 15:17:52  \n",
       "49986       73527  2016-04-06 23:16:00  \n",
       "49987       94362  2016-03-26 22:46:06  \n",
       "49988       83646  2016-04-07 02:17:40  \n",
       "49989       21244  2016-03-12 10:17:55  \n",
       "49990       58239  2016-04-06 22:46:57  \n",
       "49991       61350  2016-03-06 18:24:19  \n",
       "49992       68642  2016-03-13 01:44:51  \n",
       "49993       65203  2016-04-06 19:46:53  \n",
       "49994       46537  2016-04-06 08:16:39  \n",
       "49995       82131  2016-04-01 13:47:40  \n",
       "49996       44807  2016-04-02 14:18:02  \n",
       "49997       73430  2016-04-04 11:47:27  \n",
       "49998       35683  2016-04-05 16:45:07  \n",
       "49999       45897  2016-04-06 21:18:48  \n",
       "\n",
       "[50000 rows x 20 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dateCrawled</th>\n",
       "      <th>name</th>\n",
       "      <th>seller</th>\n",
       "      <th>offerType</th>\n",
       "      <th>price</th>\n",
       "      <th>abtest</th>\n",
       "      <th>vehicleType</th>\n",
       "      <th>yearOfRegistration</th>\n",
       "      <th>gearbox</th>\n",
       "      <th>powerPS</th>\n",
       "      <th>model</th>\n",
       "      <th>odometer</th>\n",
       "      <th>monthOfRegistration</th>\n",
       "      <th>fuelType</th>\n",
       "      <th>brand</th>\n",
       "      <th>notRepairedDamage</th>\n",
       "      <th>dateCreated</th>\n",
       "      <th>nrOfPictures</th>\n",
       "      <th>postalCode</th>\n",
       "      <th>lastSeen</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-03-26 17:47:46</td>\n",
       "      <td>Peugeot_807_160_NAVTECH_ON_BOARD</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$5,000</td>\n",
       "      <td>control</td>\n",
       "      <td>bus</td>\n",
       "      <td>2004</td>\n",
       "      <td>manuell</td>\n",
       "      <td>158</td>\n",
       "      <td>andere</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>3</td>\n",
       "      <td>lpg</td>\n",
       "      <td>peugeot</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-26 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>79588</td>\n",
       "      <td>2016-04-06 06:45:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-04-04 13:38:56</td>\n",
       "      <td>BMW_740i_4_4_Liter_HAMANN_UMBAU_Mega_Optik</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$8,500</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>1997</td>\n",
       "      <td>automatik</td>\n",
       "      <td>286</td>\n",
       "      <td>7er</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>6</td>\n",
       "      <td>benzin</td>\n",
       "      <td>bmw</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-04 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>71034</td>\n",
       "      <td>2016-04-06 14:45:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016-03-26 18:57:24</td>\n",
       "      <td>Volkswagen_Golf_1.6_United</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$8,990</td>\n",
       "      <td>test</td>\n",
       "      <td>limousine</td>\n",
       "      <td>2009</td>\n",
       "      <td>manuell</td>\n",
       "      <td>102</td>\n",
       "      <td>golf</td>\n",
       "      <td>70,000km</td>\n",
       "      <td>7</td>\n",
       "      <td>benzin</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-26 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>35394</td>\n",
       "      <td>2016-04-06 20:15:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016-03-12 16:58:10</td>\n",
       "      <td>Smart_smart_fortwo_coupe_softouch/F1/Klima/Pan...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$4,350</td>\n",
       "      <td>control</td>\n",
       "      <td>kleinwagen</td>\n",
       "      <td>2007</td>\n",
       "      <td>automatik</td>\n",
       "      <td>71</td>\n",
       "      <td>fortwo</td>\n",
       "      <td>70,000km</td>\n",
       "      <td>6</td>\n",
       "      <td>benzin</td>\n",
       "      <td>smart</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-12 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>33729</td>\n",
       "      <td>2016-03-15 03:16:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016-04-01 14:38:50</td>\n",
       "      <td>Ford_Focus_1_6_Benzin_TÜV_neu_ist_sehr_gepfleg...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$1,350</td>\n",
       "      <td>test</td>\n",
       "      <td>kombi</td>\n",
       "      <td>2003</td>\n",
       "      <td>manuell</td>\n",
       "      <td>0</td>\n",
       "      <td>focus</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>7</td>\n",
       "      <td>benzin</td>\n",
       "      <td>ford</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-01 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>39218</td>\n",
       "      <td>2016-04-01 14:38:50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           dateCrawled                                               name  \\\n",
       "0  2016-03-26 17:47:46                   Peugeot_807_160_NAVTECH_ON_BOARD   \n",
       "1  2016-04-04 13:38:56         BMW_740i_4_4_Liter_HAMANN_UMBAU_Mega_Optik   \n",
       "2  2016-03-26 18:57:24                         Volkswagen_Golf_1.6_United   \n",
       "3  2016-03-12 16:58:10  Smart_smart_fortwo_coupe_softouch/F1/Klima/Pan...   \n",
       "4  2016-04-01 14:38:50  Ford_Focus_1_6_Benzin_TÜV_neu_ist_sehr_gepfleg...   \n",
       "\n",
       "   seller offerType   price   abtest vehicleType  yearOfRegistration  \\\n",
       "0  privat   Angebot  $5,000  control         bus                2004   \n",
       "1  privat   Angebot  $8,500  control   limousine                1997   \n",
       "2  privat   Angebot  $8,990     test   limousine                2009   \n",
       "3  privat   Angebot  $4,350  control  kleinwagen                2007   \n",
       "4  privat   Angebot  $1,350     test       kombi                2003   \n",
       "\n",
       "     gearbox  powerPS   model   odometer  monthOfRegistration fuelType  \\\n",
       "0    manuell      158  andere  150,000km                    3      lpg   \n",
       "1  automatik      286     7er  150,000km                    6   benzin   \n",
       "2    manuell      102    golf   70,000km                    7   benzin   \n",
       "3  automatik       71  fortwo   70,000km                    6   benzin   \n",
       "4    manuell        0   focus  150,000km                    7   benzin   \n",
       "\n",
       "        brand notRepairedDamage          dateCreated  nrOfPictures  \\\n",
       "0     peugeot              nein  2016-03-26 00:00:00             0   \n",
       "1         bmw              nein  2016-04-04 00:00:00             0   \n",
       "2  volkswagen              nein  2016-03-26 00:00:00             0   \n",
       "3       smart              nein  2016-03-12 00:00:00             0   \n",
       "4        ford              nein  2016-04-01 00:00:00             0   \n",
       "\n",
       "   postalCode             lastSeen  \n",
       "0       79588  2016-04-06 06:45:54  \n",
       "1       71034  2016-04-06 14:45:08  \n",
       "2       35394  2016-04-06 20:15:37  \n",
       "3       33729  2016-03-15 03:16:28  \n",
       "4       39218  2016-04-01 14:38:50  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 50000 entries, 0 to 49999\n",
      "Data columns (total 20 columns):\n",
      "dateCrawled            50000 non-null object\n",
      "name                   50000 non-null object\n",
      "seller                 50000 non-null object\n",
      "offerType              50000 non-null object\n",
      "price                  50000 non-null object\n",
      "abtest                 50000 non-null object\n",
      "vehicleType            44905 non-null object\n",
      "yearOfRegistration     50000 non-null int64\n",
      "gearbox                47320 non-null object\n",
      "powerPS                50000 non-null int64\n",
      "model                  47242 non-null object\n",
      "odometer               50000 non-null object\n",
      "monthOfRegistration    50000 non-null int64\n",
      "fuelType               45518 non-null object\n",
      "brand                  50000 non-null object\n",
      "notRepairedDamage      40171 non-null object\n",
      "dateCreated            50000 non-null object\n",
      "nrOfPictures           50000 non-null int64\n",
      "postalCode             50000 non-null int64\n",
      "lastSeen               50000 non-null object\n",
      "dtypes: int64(5), object(15)\n",
      "memory usage: 7.6+ MB\n"
     ]
    }
   ],
   "source": [
    "autos.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "pretty small dataset, only has 7.6mb in memory. Describes cars and its features. It has 50k entries of diff cars sold. Need to convert some numeric values to numbers from objects. Some columns have lots of missing values."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['dateCrawled', 'name', 'seller', 'offerType', 'price', 'abtest',\n",
       "       'vehicleType', 'yearOfRegistration', 'gearbox', 'powerPS', 'model',\n",
       "       'odometer', 'monthOfRegistration', 'fuelType', 'brand',\n",
       "       'notRepairedDamage', 'dateCreated', 'nrOfPictures', 'postalCode',\n",
       "       'lastSeen'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "copied = autos.columns.tolist().copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['dateCrawled',\n",
       " 'name',\n",
       " 'seller',\n",
       " 'offerType',\n",
       " 'price',\n",
       " 'abtest',\n",
       " 'vehicleType',\n",
       " 'yearOfRegistration',\n",
       " 'gearbox',\n",
       " 'powerPS',\n",
       " 'model',\n",
       " 'odometer',\n",
       " 'monthOfRegistration',\n",
       " 'fuelType',\n",
       " 'brand',\n",
       " 'notRepairedDamage',\n",
       " 'dateCreated',\n",
       " 'nrOfPictures',\n",
       " 'postalCode',\n",
       " 'lastSeen']"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "copied"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "copied = ['date_crawled',\n",
    " 'name',\n",
    " 'seller',\n",
    " 'offer_type',\n",
    " 'price',\n",
    " 'abtest',\n",
    " 'vehicle_type',\n",
    " 'registration_year',\n",
    " 'gearbox',\n",
    " 'power_ps',\n",
    " 'model',\n",
    " 'odometer',\n",
    " 'registration_month',\n",
    " 'fuel_type',\n",
    " 'brand',\n",
    " 'unrepaired_damage',\n",
    " 'ad_created',\n",
    " 'nr_of_pictures',\n",
    " 'postal_code',\n",
    " 'last_seen']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "autos.columns = copied"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date_crawled</th>\n",
       "      <th>name</th>\n",
       "      <th>seller</th>\n",
       "      <th>offer_type</th>\n",
       "      <th>price</th>\n",
       "      <th>abtest</th>\n",
       "      <th>vehicle_type</th>\n",
       "      <th>registration_year</th>\n",
       "      <th>gearbox</th>\n",
       "      <th>power_ps</th>\n",
       "      <th>model</th>\n",
       "      <th>odometer</th>\n",
       "      <th>registration_month</th>\n",
       "      <th>fuel_type</th>\n",
       "      <th>brand</th>\n",
       "      <th>unrepaired_damage</th>\n",
       "      <th>ad_created</th>\n",
       "      <th>nr_of_pictures</th>\n",
       "      <th>postal_code</th>\n",
       "      <th>last_seen</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-03-26 17:47:46</td>\n",
       "      <td>Peugeot_807_160_NAVTECH_ON_BOARD</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$5,000</td>\n",
       "      <td>control</td>\n",
       "      <td>bus</td>\n",
       "      <td>2004</td>\n",
       "      <td>manuell</td>\n",
       "      <td>158</td>\n",
       "      <td>andere</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>3</td>\n",
       "      <td>lpg</td>\n",
       "      <td>peugeot</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-26 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>79588</td>\n",
       "      <td>2016-04-06 06:45:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-04-04 13:38:56</td>\n",
       "      <td>BMW_740i_4_4_Liter_HAMANN_UMBAU_Mega_Optik</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>$8,500</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>1997</td>\n",
       "      <td>automatik</td>\n",
       "      <td>286</td>\n",
       "      <td>7er</td>\n",
       "      <td>150,000km</td>\n",
       "      <td>6</td>\n",
       "      <td>benzin</td>\n",
       "      <td>bmw</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-04 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>71034</td>\n",
       "      <td>2016-04-06 14:45:08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          date_crawled                                        name  seller  \\\n",
       "0  2016-03-26 17:47:46            Peugeot_807_160_NAVTECH_ON_BOARD  privat   \n",
       "1  2016-04-04 13:38:56  BMW_740i_4_4_Liter_HAMANN_UMBAU_Mega_Optik  privat   \n",
       "\n",
       "  offer_type   price   abtest vehicle_type  registration_year    gearbox  \\\n",
       "0    Angebot  $5,000  control          bus               2004    manuell   \n",
       "1    Angebot  $8,500  control    limousine               1997  automatik   \n",
       "\n",
       "   power_ps   model   odometer  registration_month fuel_type    brand  \\\n",
       "0       158  andere  150,000km                   3       lpg  peugeot   \n",
       "1       286     7er  150,000km                   6    benzin      bmw   \n",
       "\n",
       "  unrepaired_damage           ad_created  nr_of_pictures  postal_code  \\\n",
       "0              nein  2016-03-26 00:00:00               0        79588   \n",
       "1              nein  2016-04-04 00:00:00               0        71034   \n",
       "\n",
       "             last_seen  \n",
       "0  2016-04-06 06:45:54  \n",
       "1  2016-04-06 14:45:08  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos.head(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "snake case is for readability."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>registration_year</th>\n",
       "      <th>power_ps</th>\n",
       "      <th>registration_month</th>\n",
       "      <th>nr_of_pictures</th>\n",
       "      <th>postal_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>50000.000000</td>\n",
       "      <td>50000.000000</td>\n",
       "      <td>50000.000000</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>50000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2005.073280</td>\n",
       "      <td>116.355920</td>\n",
       "      <td>5.723360</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50813.627300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>105.712813</td>\n",
       "      <td>209.216627</td>\n",
       "      <td>3.711984</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25779.747957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1000.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1067.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1999.000000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30451.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2003.000000</td>\n",
       "      <td>105.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>49577.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2008.000000</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>71540.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>9999.000000</td>\n",
       "      <td>17700.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>99998.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       registration_year      power_ps  registration_month  nr_of_pictures  \\\n",
       "count       50000.000000  50000.000000        50000.000000         50000.0   \n",
       "mean         2005.073280    116.355920            5.723360             0.0   \n",
       "std           105.712813    209.216627            3.711984             0.0   \n",
       "min          1000.000000      0.000000            0.000000             0.0   \n",
       "25%          1999.000000     70.000000            3.000000             0.0   \n",
       "50%          2003.000000    105.000000            6.000000             0.0   \n",
       "75%          2008.000000    150.000000            9.000000             0.0   \n",
       "max          9999.000000  17700.000000           12.000000             0.0   \n",
       "\n",
       "        postal_code  \n",
       "count  50000.000000  \n",
       "mean   50813.627300  \n",
       "std    25779.747957  \n",
       "min     1067.000000  \n",
       "25%    30451.000000  \n",
       "50%    49577.000000  \n",
       "75%    71540.000000  \n",
       "max    99998.000000  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "registration year cant' be 1000 or 9999, nr of pics needs more closer look\n",
    "unrepaired damage is 'nein' must be 'no'. price and odometer must be numeric."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "autos['odometer'] = autos['odometer'].str.replace('km', '').str.replace(',', '').astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "autos['price'] = autos['price'].str.replace('$', '').str.replace(',', '').astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "autos.rename({'odometer': 'odometer_km'}, inplace=True, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(50000,)"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['price'].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(50000,)"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['odometer_km'].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 5000,  8500,  8990, ...,   385, 22200, 16995])"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['price'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "150000.0    32424\n",
       "125000.0     5170\n",
       "100000.0     2169\n",
       "90000.0      1757\n",
       "80000.0      1436\n",
       "70000.0      1230\n",
       "60000.0      1164\n",
       "50000.0      1027\n",
       "5000.0        967\n",
       "40000.0       819\n",
       "30000.0       789\n",
       "20000.0       784\n",
       "10000.0       264\n",
       "Name: odometer_km, dtype: int64"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['odometer_km'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date_crawled</th>\n",
       "      <th>ad_created</th>\n",
       "      <th>last_seen</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-03-26 17:47:46</td>\n",
       "      <td>2016-03-26 00:00:00</td>\n",
       "      <td>2016-04-06 06:45:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-04-04 13:38:56</td>\n",
       "      <td>2016-04-04 00:00:00</td>\n",
       "      <td>2016-04-06 14:45:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016-03-26 18:57:24</td>\n",
       "      <td>2016-03-26 00:00:00</td>\n",
       "      <td>2016-04-06 20:15:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016-03-12 16:58:10</td>\n",
       "      <td>2016-03-12 00:00:00</td>\n",
       "      <td>2016-03-15 03:16:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016-04-01 14:38:50</td>\n",
       "      <td>2016-04-01 00:00:00</td>\n",
       "      <td>2016-04-01 14:38:50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          date_crawled           ad_created            last_seen\n",
       "0  2016-03-26 17:47:46  2016-03-26 00:00:00  2016-04-06 06:45:54\n",
       "1  2016-04-04 13:38:56  2016-04-04 00:00:00  2016-04-06 14:45:08\n",
       "2  2016-03-26 18:57:24  2016-03-26 00:00:00  2016-04-06 20:15:37\n",
       "3  2016-03-12 16:58:10  2016-03-12 00:00:00  2016-03-15 03:16:28\n",
       "4  2016-04-01 14:38:50  2016-04-01 00:00:00  2016-04-01 14:38:50"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos[['date_crawled', 'ad_created', 'last_seen']][0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2016-03    0.8379\n",
       "2016-04    0.1621\n",
       "Name: date_crawled, dtype: float64"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['date_crawled'].str[:7].value_counts(normalize=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2016-03    41866\n",
       "2016-04     8053\n",
       "2016-02       63\n",
       "2016-01       12\n",
       "2015-12        2\n",
       "2015-06        1\n",
       "2015-11        1\n",
       "2015-08        1\n",
       "2015-09        1\n",
       "Name: ad_created, dtype: int64"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['ad_created'].sort_index().str[:7].value_counts(normalize=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2016-04    28709\n",
       "2016-03    21291\n",
       "Name: last_seen, dtype: int64"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['last_seen'].sort_index().str[:7].value_counts(normalize=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2000    3354\n",
       "2005    3015\n",
       "1999    3000\n",
       "Name: registration_year, dtype: int64"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['registration_year'].sort_index().value_counts().head(3)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "top 3 registration years for cars are 2000, 2005,1999."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "last seen cars are both in 2016"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "most ads are created in the first 4 months of 2016"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "highest and lowest value for registration year is 1950 and 2019 as when the cars were created and the current year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date_crawled</th>\n",
       "      <th>name</th>\n",
       "      <th>seller</th>\n",
       "      <th>offer_type</th>\n",
       "      <th>price</th>\n",
       "      <th>abtest</th>\n",
       "      <th>vehicle_type</th>\n",
       "      <th>registration_year</th>\n",
       "      <th>gearbox</th>\n",
       "      <th>power_ps</th>\n",
       "      <th>model</th>\n",
       "      <th>odometer_km</th>\n",
       "      <th>registration_month</th>\n",
       "      <th>fuel_type</th>\n",
       "      <th>brand</th>\n",
       "      <th>unrepaired_damage</th>\n",
       "      <th>ad_created</th>\n",
       "      <th>nr_of_pictures</th>\n",
       "      <th>postal_code</th>\n",
       "      <th>last_seen</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8012</th>\n",
       "      <td>2016-03-23 16:43:29</td>\n",
       "      <td>Opel_GT_Karosserie_mit_Brief!</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>700</td>\n",
       "      <td>test</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>andere</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>opel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-23 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>21769</td>\n",
       "      <td>2016-04-05 20:16:15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14341</th>\n",
       "      <td>2016-03-23 01:36:20</td>\n",
       "      <td>Hole_kostenlos_ab</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>0</td>\n",
       "      <td>test</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>bmw</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-23 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>32689</td>\n",
       "      <td>2016-03-23 08:47:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33950</th>\n",
       "      <td>2016-03-23 21:52:25</td>\n",
       "      <td>58er_karmann_ghia_lowlight_Kaefer__zum_restaur...</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>7999</td>\n",
       "      <td>test</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>kaefer</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-03-23 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>47638</td>\n",
       "      <td>2016-04-06 03:46:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38076</th>\n",
       "      <td>2016-04-04 22:54:47</td>\n",
       "      <td>Mercedes_Benz_A180</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>18000</td>\n",
       "      <td>test</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>a_klasse</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>benzin</td>\n",
       "      <td>mercedes_benz</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-04-04 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>51379</td>\n",
       "      <td>2016-04-07 02:44:52</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              date_crawled                                               name  \\\n",
       "8012   2016-03-23 16:43:29                      Opel_GT_Karosserie_mit_Brief!   \n",
       "14341  2016-03-23 01:36:20                                  Hole_kostenlos_ab   \n",
       "33950  2016-03-23 21:52:25  58er_karmann_ghia_lowlight_Kaefer__zum_restaur...   \n",
       "38076  2016-04-04 22:54:47                                 Mercedes_Benz_A180   \n",
       "\n",
       "       seller offer_type  price abtest vehicle_type  registration_year  \\\n",
       "8012   privat    Angebot    700   test          NaN               9999   \n",
       "14341  privat    Angebot      0   test          NaN               9999   \n",
       "33950  privat    Angebot   7999   test          NaN               9999   \n",
       "38076  privat    Angebot  18000   test          NaN               9999   \n",
       "\n",
       "      gearbox  power_ps     model  odometer_km  registration_month fuel_type  \\\n",
       "8012      NaN         0    andere      10000.0                   0       NaN   \n",
       "14341     NaN         0       NaN      10000.0                   0       NaN   \n",
       "33950     NaN         0    kaefer      10000.0                   0       NaN   \n",
       "38076     NaN         0  a_klasse      10000.0                   0    benzin   \n",
       "\n",
       "               brand unrepaired_damage           ad_created  nr_of_pictures  \\\n",
       "8012            opel               NaN  2016-03-23 00:00:00               0   \n",
       "14341            bmw               NaN  2016-03-23 00:00:00               0   \n",
       "33950     volkswagen               NaN  2016-03-23 00:00:00               0   \n",
       "38076  mercedes_benz               NaN  2016-04-04 00:00:00               0   \n",
       "\n",
       "       postal_code            last_seen  \n",
       "8012         21769  2016-04-05 20:16:15  \n",
       "14341        32689  2016-03-23 08:47:00  \n",
       "33950        47638  2016-04-06 03:46:40  \n",
       "38076        51379  2016-04-07 02:44:52  "
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos[autos['registration_year'] == 9999]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['date_crawled', 'name', 'seller', 'offer_type', 'price', 'abtest',\n",
       "       'vehicle_type', 'registration_year', 'gearbox', 'power_ps', 'model',\n",
       "       'odometer_km', 'registration_month', 'fuel_type', 'brand',\n",
       "       'unrepaired_damage', 'ad_created', 'nr_of_pictures', 'postal_code',\n",
       "       'last_seen'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "autos.iloc[[8012,14341,33950,38076], 7] =2019"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9996"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['registration_year'].max()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "hmm seems like after i removed 9999 year, i still have some bad years like 9996, need to check what are the max years!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9996       1\n",
       "9000       2\n",
       "8888       1\n",
       "6200       1\n",
       "5911       1\n",
       "5000       4\n",
       "4800       1\n",
       "4500       1\n",
       "4100       1\n",
       "2800       1\n",
       "2019       7\n",
       "2018     492\n",
       "2017    1453\n",
       "2016    1316\n",
       "2015     399\n",
       "2014     666\n",
       "2013     806\n",
       "2012    1323\n",
       "2011    1634\n",
       "2010    1597\n",
       "2009    2098\n",
       "2008    2231\n",
       "2007    2304\n",
       "2006    2708\n",
       "2005    3015\n",
       "2004    2737\n",
       "2003    2727\n",
       "2002    2533\n",
       "2001    2703\n",
       "2000    3354\n",
       "        ... \n",
       "1963       9\n",
       "1962       4\n",
       "1961       6\n",
       "1960      34\n",
       "1959       7\n",
       "1958       4\n",
       "1957       2\n",
       "1956       5\n",
       "1955       2\n",
       "1954       2\n",
       "1953       1\n",
       "1952       1\n",
       "1951       2\n",
       "1950       3\n",
       "1948       1\n",
       "1943       1\n",
       "1941       2\n",
       "1939       1\n",
       "1938       1\n",
       "1937       4\n",
       "1934       2\n",
       "1931       1\n",
       "1929       1\n",
       "1927       1\n",
       "1910       9\n",
       "1800       2\n",
       "1500       1\n",
       "1111       1\n",
       "1001       1\n",
       "1000       1\n",
       "Name: registration_year, Length: 96, dtype: int64"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['registration_year'].value_counts().sort_index(ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "When removing outliers, we can \n",
    "do df[(df[\"col\"] > x ) & (df[\"col\"] < y )], but\n",
    "it's more readable to use df[df[\"col\"].between(x,y)]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "bad_years = autos[autos['registration_year'] > 2019]['registration_year']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "453      4500\n",
       "4164     5000\n",
       "4549     4100\n",
       "6308     9996\n",
       "8360     6200\n",
       "13559    9000\n",
       "22799    5000\n",
       "24519    5000\n",
       "25003    8888\n",
       "27578    2800\n",
       "27618    5911\n",
       "42079    4800\n",
       "49153    5000\n",
       "49910    9000\n",
       "Name: registration_year, dtype: int64"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bad_years"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "bad_index = bad_years.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[4500,\n",
       " 5000,\n",
       " 4100,\n",
       " 9996,\n",
       " 6200,\n",
       " 9000,\n",
       " 5000,\n",
       " 5000,\n",
       " 8888,\n",
       " 2800,\n",
       " 5911,\n",
       " 4800,\n",
       " 5000,\n",
       " 9000]"
      ]
     },
     "execution_count": 112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bad_index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "min_bad_years = autos[autos['registration_year'] <1950 ]['registration_year'].tolist()\n",
    "#min_bad_index = min_bad_years.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[1934,\n",
       " 1934,\n",
       " 1910,\n",
       " 1800,\n",
       " 1948,\n",
       " 1931,\n",
       " 1943,\n",
       " 1941,\n",
       " 1910,\n",
       " 1927,\n",
       " 1937,\n",
       " 1929,\n",
       " 1000,\n",
       " 1910,\n",
       " 1937,\n",
       " 1111,\n",
       " 1939,\n",
       " 1941,\n",
       " 1938,\n",
       " 1937,\n",
       " 1910,\n",
       " 1910,\n",
       " 1800,\n",
       " 1910,\n",
       " 1500,\n",
       " 1937,\n",
       " 1910,\n",
       " 1910,\n",
       " 1910,\n",
       " 1001]"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "min_bad_years"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['peugeot', 'bmw', 'volkswagen', 'smart', 'ford', 'chrysler',\n",
       "       'seat', 'renault', 'mercedes_benz', 'audi', 'sonstige_autos',\n",
       "       'opel', 'mazda', 'porsche', 'mini', 'toyota', 'dacia', 'nissan',\n",
       "       'jeep', 'saab', 'volvo', 'mitsubishi', 'jaguar', 'fiat', 'skoda',\n",
       "       'subaru', 'kia', 'citroen', 'chevrolet', 'hyundai', 'honda',\n",
       "       'daewoo', 'suzuki', 'trabant', 'land_rover', 'alfa_romeo', 'lada',\n",
       "       'rover', 'daihatsu', 'lancia'], dtype=object)"
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['brand'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "x = autos['brand'].value_counts().sort_values(ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "x = pd.DataFrame(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "x = x.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>brand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>volkswagen</th>\n",
       "      <td>10687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>opel</th>\n",
       "      <td>5461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bmw</th>\n",
       "      <td>5429</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            brand\n",
       "volkswagen  10687\n",
       "opel         5461\n",
       "bmw          5429"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "дывоадывдаоыдоаоыдвдыодоыдоаыодо\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "ыдвоадыоадыдаоыдовадыовдоафждводао209о203о\n",
    "230ок230ао2-а0о3а-03оа20ао\n",
    "ывоа\n",
    "ывао-23оа02оавыоыдао\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "autos['mean_price'] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "autos['mean_mileage'] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date_crawled</th>\n",
       "      <th>name</th>\n",
       "      <th>seller</th>\n",
       "      <th>offer_type</th>\n",
       "      <th>price</th>\n",
       "      <th>abtest</th>\n",
       "      <th>vehicle_type</th>\n",
       "      <th>registration_year</th>\n",
       "      <th>gearbox</th>\n",
       "      <th>power_ps</th>\n",
       "      <th>...</th>\n",
       "      <th>registration_month</th>\n",
       "      <th>fuel_type</th>\n",
       "      <th>brand</th>\n",
       "      <th>unrepaired_damage</th>\n",
       "      <th>ad_created</th>\n",
       "      <th>nr_of_pictures</th>\n",
       "      <th>postal_code</th>\n",
       "      <th>last_seen</th>\n",
       "      <th>mean_price</th>\n",
       "      <th>mean_mileage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-03-26 17:47:46</td>\n",
       "      <td>Peugeot_807_160_NAVTECH_ON_BOARD</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>5000</td>\n",
       "      <td>control</td>\n",
       "      <td>bus</td>\n",
       "      <td>2004</td>\n",
       "      <td>manuell</td>\n",
       "      <td>158</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>lpg</td>\n",
       "      <td>peugeot</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-26 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>79588</td>\n",
       "      <td>2016-04-06 06:45:54</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-04-04 13:38:56</td>\n",
       "      <td>BMW_740i_4_4_Liter_HAMANN_UMBAU_Mega_Optik</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>8500</td>\n",
       "      <td>control</td>\n",
       "      <td>limousine</td>\n",
       "      <td>1997</td>\n",
       "      <td>automatik</td>\n",
       "      <td>286</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>benzin</td>\n",
       "      <td>bmw</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-04-04 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>71034</td>\n",
       "      <td>2016-04-06 14:45:08</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016-03-26 18:57:24</td>\n",
       "      <td>Volkswagen_Golf_1.6_United</td>\n",
       "      <td>privat</td>\n",
       "      <td>Angebot</td>\n",
       "      <td>8990</td>\n",
       "      <td>test</td>\n",
       "      <td>limousine</td>\n",
       "      <td>2009</td>\n",
       "      <td>manuell</td>\n",
       "      <td>102</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>benzin</td>\n",
       "      <td>volkswagen</td>\n",
       "      <td>nein</td>\n",
       "      <td>2016-03-26 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>35394</td>\n",
       "      <td>2016-04-06 20:15:37</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          date_crawled                                        name  seller  \\\n",
       "0  2016-03-26 17:47:46            Peugeot_807_160_NAVTECH_ON_BOARD  privat   \n",
       "1  2016-04-04 13:38:56  BMW_740i_4_4_Liter_HAMANN_UMBAU_Mega_Optik  privat   \n",
       "2  2016-03-26 18:57:24                  Volkswagen_Golf_1.6_United  privat   \n",
       "\n",
       "  offer_type  price   abtest vehicle_type  registration_year    gearbox  \\\n",
       "0    Angebot   5000  control          bus               2004    manuell   \n",
       "1    Angebot   8500  control    limousine               1997  automatik   \n",
       "2    Angebot   8990     test    limousine               2009    manuell   \n",
       "\n",
       "   power_ps     ...      registration_month  fuel_type       brand  \\\n",
       "0       158     ...                       3        lpg     peugeot   \n",
       "1       286     ...                       6     benzin         bmw   \n",
       "2       102     ...                       7     benzin  volkswagen   \n",
       "\n",
       "  unrepaired_damage           ad_created nr_of_pictures postal_code  \\\n",
       "0              nein  2016-03-26 00:00:00              0       79588   \n",
       "1              nein  2016-04-04 00:00:00              0       71034   \n",
       "2              nein  2016-03-26 00:00:00              0       35394   \n",
       "\n",
       "             last_seen  mean_price mean_mileage  \n",
       "0  2016-04-06 06:45:54           0            0  \n",
       "1  2016-04-06 14:45:08           0            0  \n",
       "2  2016-04-06 20:15:37           0            0  \n",
       "\n",
       "[3 rows x 22 columns]"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "privat        49999\n",
       "gewerblich        1\n",
       "Name: seller, dtype: int64"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['seller'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "autos[autos['seller'] == 'privat'] = 'private'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "private       49999\n",
       "gewerblich        1\n",
       "Name: seller, dtype: int64"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos['seller'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "autos[autos['seller'] == 'gewerblich'] = 'public'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date_crawled</th>\n",
       "      <th>name</th>\n",
       "      <th>seller</th>\n",
       "      <th>offer_type</th>\n",
       "      <th>price</th>\n",
       "      <th>abtest</th>\n",
       "      <th>vehicle_type</th>\n",
       "      <th>registration_year</th>\n",
       "      <th>gearbox</th>\n",
       "      <th>power_ps</th>\n",
       "      <th>...</th>\n",
       "      <th>registration_month</th>\n",
       "      <th>fuel_type</th>\n",
       "      <th>brand</th>\n",
       "      <th>unrepaired_damage</th>\n",
       "      <th>ad_created</th>\n",
       "      <th>nr_of_pictures</th>\n",
       "      <th>postal_code</th>\n",
       "      <th>last_seen</th>\n",
       "      <th>mean_price</th>\n",
       "      <th>mean_mileage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</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",
       "      <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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49970</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49971</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49972</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49973</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49974</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49975</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49976</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49977</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49978</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49979</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49980</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49981</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49982</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49983</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49984</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49985</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49986</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49987</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49988</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49989</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49990</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49991</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49992</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49993</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49994</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49995</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49996</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49997</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49998</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49999</th>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>...</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "      <td>private</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>50000 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      date_crawled     name   seller offer_type    price   abtest  \\\n",
       "0          private  private  private    private  private  private   \n",
       "1          private  private  private    private  private  private   \n",
       "2          private  private  private    private  private  private   \n",
       "3          private  private  private    private  private  private   \n",
       "4          private  private  private    private  private  private   \n",
       "5          private  private  private    private  private  private   \n",
       "6          private  private  private    private  private  private   \n",
       "7          private  private  private    private  private  private   \n",
       "8          private  private  private    private  private  private   \n",
       "9          private  private  private    private  private  private   \n",
       "10         private  private  private    private  private  private   \n",
       "11         private  private  private    private  private  private   \n",
       "12         private  private  private    private  private  private   \n",
       "13         private  private  private    private  private  private   \n",
       "14         private  private  private    private  private  private   \n",
       "15         private  private  private    private  private  private   \n",
       "16         private  private  private    private  private  private   \n",
       "17         private  private  private    private  private  private   \n",
       "18         private  private  private    private  private  private   \n",
       "19         private  private  private    private  private  private   \n",
       "20         private  private  private    private  private  private   \n",
       "21         private  private  private    private  private  private   \n",
       "22         private  private  private    private  private  private   \n",
       "23         private  private  private    private  private  private   \n",
       "24         private  private  private    private  private  private   \n",
       "25         private  private  private    private  private  private   \n",
       "26         private  private  private    private  private  private   \n",
       "27         private  private  private    private  private  private   \n",
       "28         private  private  private    private  private  private   \n",
       "29         private  private  private    private  private  private   \n",
       "...            ...      ...      ...        ...      ...      ...   \n",
       "49970      private  private  private    private  private  private   \n",
       "49971      private  private  private    private  private  private   \n",
       "49972      private  private  private    private  private  private   \n",
       "49973      private  private  private    private  private  private   \n",
       "49974      private  private  private    private  private  private   \n",
       "49975      private  private  private    private  private  private   \n",
       "49976      private  private  private    private  private  private   \n",
       "49977      private  private  private    private  private  private   \n",
       "49978      private  private  private    private  private  private   \n",
       "49979      private  private  private    private  private  private   \n",
       "49980      private  private  private    private  private  private   \n",
       "49981      private  private  private    private  private  private   \n",
       "49982      private  private  private    private  private  private   \n",
       "49983      private  private  private    private  private  private   \n",
       "49984      private  private  private    private  private  private   \n",
       "49985      private  private  private    private  private  private   \n",
       "49986      private  private  private    private  private  private   \n",
       "49987      private  private  private    private  private  private   \n",
       "49988      private  private  private    private  private  private   \n",
       "49989      private  private  private    private  private  private   \n",
       "49990      private  private  private    private  private  private   \n",
       "49991      private  private  private    private  private  private   \n",
       "49992      private  private  private    private  private  private   \n",
       "49993      private  private  private    private  private  private   \n",
       "49994      private  private  private    private  private  private   \n",
       "49995      private  private  private    private  private  private   \n",
       "49996      private  private  private    private  private  private   \n",
       "49997      private  private  private    private  private  private   \n",
       "49998      private  private  private    private  private  private   \n",
       "49999      private  private  private    private  private  private   \n",
       "\n",
       "      vehicle_type registration_year  gearbox power_ps     ...       \\\n",
       "0          private           private  private  private     ...        \n",
       "1          private           private  private  private     ...        \n",
       "2          private           private  private  private     ...        \n",
       "3          private           private  private  private     ...        \n",
       "4          private           private  private  private     ...        \n",
       "5          private           private  private  private     ...        \n",
       "6          private           private  private  private     ...        \n",
       "7          private           private  private  private     ...        \n",
       "8          private           private  private  private     ...        \n",
       "9          private           private  private  private     ...        \n",
       "10         private           private  private  private     ...        \n",
       "11         private           private  private  private     ...        \n",
       "12         private           private  private  private     ...        \n",
       "13         private           private  private  private     ...        \n",
       "14         private           private  private  private     ...        \n",
       "15         private           private  private  private     ...        \n",
       "16         private           private  private  private     ...        \n",
       "17         private           private  private  private     ...        \n",
       "18         private           private  private  private     ...        \n",
       "19         private           private  private  private     ...        \n",
       "20         private           private  private  private     ...        \n",
       "21         private           private  private  private     ...        \n",
       "22         private           private  private  private     ...        \n",
       "23         private           private  private  private     ...        \n",
       "24         private           private  private  private     ...        \n",
       "25         private           private  private  private     ...        \n",
       "26         private           private  private  private     ...        \n",
       "27         private           private  private  private     ...        \n",
       "28         private           private  private  private     ...        \n",
       "29         private           private  private  private     ...        \n",
       "...            ...               ...      ...      ...     ...        \n",
       "49970      private           private  private  private     ...        \n",
       "49971      private           private  private  private     ...        \n",
       "49972      private           private  private  private     ...        \n",
       "49973      private           private  private  private     ...        \n",
       "49974      private           private  private  private     ...        \n",
       "49975      private           private  private  private     ...        \n",
       "49976      private           private  private  private     ...        \n",
       "49977      private           private  private  private     ...        \n",
       "49978      private           private  private  private     ...        \n",
       "49979      private           private  private  private     ...        \n",
       "49980      private           private  private  private     ...        \n",
       "49981      private           private  private  private     ...        \n",
       "49982      private           private  private  private     ...        \n",
       "49983      private           private  private  private     ...        \n",
       "49984      private           private  private  private     ...        \n",
       "49985      private           private  private  private     ...        \n",
       "49986      private           private  private  private     ...        \n",
       "49987      private           private  private  private     ...        \n",
       "49988      private           private  private  private     ...        \n",
       "49989      private           private  private  private     ...        \n",
       "49990      private           private  private  private     ...        \n",
       "49991      private           private  private  private     ...        \n",
       "49992      private           private  private  private     ...        \n",
       "49993      private           private  private  private     ...        \n",
       "49994      private           private  private  private     ...        \n",
       "49995      private           private  private  private     ...        \n",
       "49996      private           private  private  private     ...        \n",
       "49997      private           private  private  private     ...        \n",
       "49998      private           private  private  private     ...        \n",
       "49999      private           private  private  private     ...        \n",
       "\n",
       "      registration_month fuel_type    brand unrepaired_damage ad_created  \\\n",
       "0                private   private  private           private    private   \n",
       "1                private   private  private           private    private   \n",
       "2                private   private  private           private    private   \n",
       "3                private   private  private           private    private   \n",
       "4                private   private  private           private    private   \n",
       "5                private   private  private           private    private   \n",
       "6                private   private  private           private    private   \n",
       "7                private   private  private           private    private   \n",
       "8                private   private  private           private    private   \n",
       "9                private   private  private           private    private   \n",
       "10               private   private  private           private    private   \n",
       "11               private   private  private           private    private   \n",
       "12               private   private  private           private    private   \n",
       "13               private   private  private           private    private   \n",
       "14               private   private  private           private    private   \n",
       "15               private   private  private           private    private   \n",
       "16               private   private  private           private    private   \n",
       "17               private   private  private           private    private   \n",
       "18               private   private  private           private    private   \n",
       "19               private   private  private           private    private   \n",
       "20               private   private  private           private    private   \n",
       "21               private   private  private           private    private   \n",
       "22               private   private  private           private    private   \n",
       "23               private   private  private           private    private   \n",
       "24               private   private  private           private    private   \n",
       "25               private   private  private           private    private   \n",
       "26               private   private  private           private    private   \n",
       "27               private   private  private           private    private   \n",
       "28               private   private  private           private    private   \n",
       "29               private   private  private           private    private   \n",
       "...                  ...       ...      ...               ...        ...   \n",
       "49970            private   private  private           private    private   \n",
       "49971            private   private  private           private    private   \n",
       "49972            private   private  private           private    private   \n",
       "49973            private   private  private           private    private   \n",
       "49974            private   private  private           private    private   \n",
       "49975            private   private  private           private    private   \n",
       "49976            private   private  private           private    private   \n",
       "49977            private   private  private           private    private   \n",
       "49978            private   private  private           private    private   \n",
       "49979            private   private  private           private    private   \n",
       "49980            private   private  private           private    private   \n",
       "49981            private   private  private           private    private   \n",
       "49982            private   private  private           private    private   \n",
       "49983            private   private  private           private    private   \n",
       "49984            private   private  private           private    private   \n",
       "49985            private   private  private           private    private   \n",
       "49986            private   private  private           private    private   \n",
       "49987            private   private  private           private    private   \n",
       "49988            private   private  private           private    private   \n",
       "49989            private   private  private           private    private   \n",
       "49990            private   private  private           private    private   \n",
       "49991            private   private  private           private    private   \n",
       "49992            private   private  private           private    private   \n",
       "49993            private   private  private           private    private   \n",
       "49994            private   private  private           private    private   \n",
       "49995            private   private  private           private    private   \n",
       "49996            private   private  private           private    private   \n",
       "49997            private   private  private           private    private   \n",
       "49998            private   private  private           private    private   \n",
       "49999            private   private  private           private    private   \n",
       "\n",
       "      nr_of_pictures postal_code last_seen mean_price mean_mileage  \n",
       "0            private     private   private    private      private  \n",
       "1            private     private   private    private      private  \n",
       "2            private     private   private    private      private  \n",
       "3            private     private   private    private      private  \n",
       "4            private     private   private    private      private  \n",
       "5            private     private   private    private      private  \n",
       "6            private     private   private    private      private  \n",
       "7            private     private   private    private      private  \n",
       "8            private     private   private    private      private  \n",
       "9            private     private   private    private      private  \n",
       "10           private     private   private    private      private  \n",
       "11           private     private   private    private      private  \n",
       "12           private     private   private    private      private  \n",
       "13           private     private   private    private      private  \n",
       "14           private     private   private    private      private  \n",
       "15           private     private   private    private      private  \n",
       "16           private     private   private    private      private  \n",
       "17           private     private   private    private      private  \n",
       "18           private     private   private    private      private  \n",
       "19           private     private   private    private      private  \n",
       "20           private     private   private    private      private  \n",
       "21           private     private   private    private      private  \n",
       "22           private     private   private    private      private  \n",
       "23           private     private   private    private      private  \n",
       "24           private     private   private    private      private  \n",
       "25           private     private   private    private      private  \n",
       "26           private     private   private    private      private  \n",
       "27           private     private   private    private      private  \n",
       "28           private     private   private    private      private  \n",
       "29           private     private   private    private      private  \n",
       "...              ...         ...       ...        ...          ...  \n",
       "49970        private     private   private    private      private  \n",
       "49971        private     private   private    private      private  \n",
       "49972        private     private   private    private      private  \n",
       "49973        private     private   private    private      private  \n",
       "49974        private     private   private    private      private  \n",
       "49975        private     private   private    private      private  \n",
       "49976        private     private   private    private      private  \n",
       "49977        private     private   private    private      private  \n",
       "49978        private     private   private    private      private  \n",
       "49979        private     private   private    private      private  \n",
       "49980        private     private   private    private      private  \n",
       "49981        private     private   private    private      private  \n",
       "49982        private     private   private    private      private  \n",
       "49983        private     private   private    private      private  \n",
       "49984        private     private   private    private      private  \n",
       "49985        private     private   private    private      private  \n",
       "49986        private     private   private    private      private  \n",
       "49987        private     private   private    private      private  \n",
       "49988        private     private   private    private      private  \n",
       "49989        private     private   private    private      private  \n",
       "49990        private     private   private    private      private  \n",
       "49991        private     private   private    private      private  \n",
       "49992        private     private   private    private      private  \n",
       "49993        private     private   private    private      private  \n",
       "49994        private     private   private    private      private  \n",
       "49995        private     private   private    private      private  \n",
       "49996        private     private   private    private      private  \n",
       "49997        private     private   private    private      private  \n",
       "49998        private     private   private    private      private  \n",
       "49999        private     private   private    private      private  \n",
       "\n",
       "[50000 rows x 22 columns]"
      ]
     },
     "execution_count": 142,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.4.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}