03_Ebay_used_cars.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "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"
    },
    "colab": {
      "name": "Ebay_used_cars.ipynb",
      "version": "0.3.2",
      "provenance": [],
      "include_colab_link": true
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Said-Akbar/Data-science/blob/master/Ebay_used_cars.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "collapsed": true,
        "id": "HYHzPrJ3MDoC",
        "colab_type": "text"
      },
      "source": [
        "## Ebay dataset of used cars"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "VHtk4TlYMDoF",
        "colab_type": "text"
      },
      "source": [
        "In this project, we are going to analyze a dataset of used cars from Ebay, which was scraped and cleaned to use by a Kaggle user. The link for the dataset is [here](https://www.kaggle.com/orgesleka/used-cars-database/data). The dataset contains around 50,000 records and 20 columns that includes car price, condition, year and more. Because the dataset is not clean, we will first do data cleaning and then dive into analyses. "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZpI8GNDKMDoI",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "\n",
        "autos = pd.read_csv(\"autos.csv\", encoding=\"Latin-1\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LzdpOmSMMDoR",
        "colab_type": "code",
        "colab": {},
        "outputId": "a1aafe55-205a-4f12-d7c3-2f9c1610eb3c"
      },
      "source": [
        "autos"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "A4iZ3yvLMDod",
        "colab_type": "code",
        "colab": {},
        "outputId": "bf2283be-88c8-405a-fab2-571e6928422e"
      },
      "source": [
        "autos.info()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "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"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7t8xW6ENMDok",
        "colab_type": "code",
        "colab": {},
        "outputId": "88bc2a0b-8bf4-4de9-e02d-d0d2bc9779c6"
      },
      "source": [
        "autos.head()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "FAdn2ZolMDop",
        "colab_type": "text"
      },
      "source": [
        "Above summary tables show that the dataset was crawled in 2016 and cars were listed online also in 2016. There are some missing values in'vehicleType', 'Gearbox', 'model', 'fuelType' and 'notRepairedDamage'. Although prices are shown in US dollars, other columns information is presented in German, not English. Moreover, only 5 columns are of numeric type and the rest of the 15 columns are string type."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "rWGrXLkYMDos",
        "colab_type": "text"
      },
      "source": [
        "Column names are in CamelCase. But we need to convert them into snake_case."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SfI47Q9xMDou",
        "colab_type": "code",
        "colab": {},
        "outputId": "5b267445-1ae1-4533-ce5c-72f635b9e1ac"
      },
      "source": [
        "autos.columns"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YY_J7OOvMDo2",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "new_columns = ['date_crawled', 'name', 'seller', 'offer_type', 'price', 'abtest',\n",
        "       'vehicle_type', 'registration_year', 'gearbox', 'power_ps', 'model',\n",
        "       'odometer', 'registration_month', 'fuel_type', 'brand',\n",
        "       'unrepaired_damage', 'ad_created', 'n_pictures', 'postal_code',\n",
        "       'last_seen']"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8-Syx7WDMDo8",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "autos.columns = new_columns"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AkIWnLdIMDpF",
        "colab_type": "code",
        "colab": {},
        "outputId": "1002d3f1-3592-495c-f91c-7a9364905c06"
      },
      "source": [
        "autos.head()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>n_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",
              "    <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": [
              "          date_crawled                                               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 offer_type   price   abtest vehicle_type  registration_year  \\\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  power_ps   model   odometer  registration_month fuel_type  \\\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 unrepaired_damage           ad_created  n_pictures  postal_code  \\\n",
              "0     peugeot              nein  2016-03-26 00:00:00           0        79588   \n",
              "1         bmw              nein  2016-04-04 00:00:00           0        71034   \n",
              "2  volkswagen              nein  2016-03-26 00:00:00           0        35394   \n",
              "3       smart              nein  2016-03-12 00:00:00           0        33729   \n",
              "4        ford              nein  2016-04-01 00:00:00           0        39218   \n",
              "\n",
              "             last_seen  \n",
              "0  2016-04-06 06:45:54  \n",
              "1  2016-04-06 14:45:08  \n",
              "2  2016-04-06 20:15:37  \n",
              "3  2016-03-15 03:16:28  \n",
              "4  2016-04-01 14:38:50  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "oEwIgWwNMDpL",
        "colab_type": "text"
      },
      "source": [
        "We changed column names to snake_case and shortened some of the names so that column names are easier to access."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tmiL03PnMDpR",
        "colab_type": "code",
        "colab": {},
        "outputId": "3b28cad2-6b94-4124-bdec-b7fbddc43c49"
      },
      "source": [
        "autos.describe(include='all')"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>n_pictures</th>\n",
              "      <th>postal_code</th>\n",
              "      <th>last_seen</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>50000</td>\n",
              "      <td>50000</td>\n",
              "      <td>50000</td>\n",
              "      <td>50000</td>\n",
              "      <td>50000</td>\n",
              "      <td>50000</td>\n",
              "      <td>44905</td>\n",
              "      <td>50000.000000</td>\n",
              "      <td>47320</td>\n",
              "      <td>50000.000000</td>\n",
              "      <td>47242</td>\n",
              "      <td>50000</td>\n",
              "      <td>50000.000000</td>\n",
              "      <td>45518</td>\n",
              "      <td>50000</td>\n",
              "      <td>40171</td>\n",
              "      <td>50000</td>\n",
              "      <td>50000.0</td>\n",
              "      <td>50000.000000</td>\n",
              "      <td>50000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>unique</th>\n",
              "      <td>48213</td>\n",
              "      <td>38754</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>2357</td>\n",
              "      <td>2</td>\n",
              "      <td>8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>245</td>\n",
              "      <td>13</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>40</td>\n",
              "      <td>2</td>\n",
              "      <td>76</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>39481</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>top</th>\n",
              "      <td>2016-03-11 22:38:16</td>\n",
              "      <td>Ford_Fiesta</td>\n",
              "      <td>privat</td>\n",
              "      <td>Angebot</td>\n",
              "      <td>$0</td>\n",
              "      <td>test</td>\n",
              "      <td>limousine</td>\n",
              "      <td>NaN</td>\n",
              "      <td>manuell</td>\n",
              "      <td>NaN</td>\n",
              "      <td>golf</td>\n",
              "      <td>150,000km</td>\n",
              "      <td>NaN</td>\n",
              "      <td>benzin</td>\n",
              "      <td>volkswagen</td>\n",
              "      <td>nein</td>\n",
              "      <td>2016-04-03 00:00:00</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2016-04-07 06:17:27</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>freq</th>\n",
              "      <td>3</td>\n",
              "      <td>78</td>\n",
              "      <td>49999</td>\n",
              "      <td>49999</td>\n",
              "      <td>1421</td>\n",
              "      <td>25756</td>\n",
              "      <td>12859</td>\n",
              "      <td>NaN</td>\n",
              "      <td>36993</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4024</td>\n",
              "      <td>32424</td>\n",
              "      <td>NaN</td>\n",
              "      <td>30107</td>\n",
              "      <td>10687</td>\n",
              "      <td>35232</td>\n",
              "      <td>1946</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2005.073280</td>\n",
              "      <td>NaN</td>\n",
              "      <td>116.355920</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.723360</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>50813.627300</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>105.712813</td>\n",
              "      <td>NaN</td>\n",
              "      <td>209.216627</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.711984</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>25779.747957</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1000.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1067.000000</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1999.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>70.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>30451.000000</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2003.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>105.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>49577.000000</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2008.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>150.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>71540.000000</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9999.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>17700.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>99998.000000</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "               date_crawled         name  seller offer_type  price abtest  \\\n",
              "count                 50000        50000   50000      50000  50000  50000   \n",
              "unique                48213        38754       2          2   2357      2   \n",
              "top     2016-03-11 22:38:16  Ford_Fiesta  privat    Angebot     $0   test   \n",
              "freq                      3           78   49999      49999   1421  25756   \n",
              "mean                    NaN          NaN     NaN        NaN    NaN    NaN   \n",
              "std                     NaN          NaN     NaN        NaN    NaN    NaN   \n",
              "min                     NaN          NaN     NaN        NaN    NaN    NaN   \n",
              "25%                     NaN          NaN     NaN        NaN    NaN    NaN   \n",
              "50%                     NaN          NaN     NaN        NaN    NaN    NaN   \n",
              "75%                     NaN          NaN     NaN        NaN    NaN    NaN   \n",
              "max                     NaN          NaN     NaN        NaN    NaN    NaN   \n",
              "\n",
              "       vehicle_type  registration_year  gearbox      power_ps  model  \\\n",
              "count         44905       50000.000000    47320  50000.000000  47242   \n",
              "unique            8                NaN        2           NaN    245   \n",
              "top       limousine                NaN  manuell           NaN   golf   \n",
              "freq          12859                NaN    36993           NaN   4024   \n",
              "mean            NaN        2005.073280      NaN    116.355920    NaN   \n",
              "std             NaN         105.712813      NaN    209.216627    NaN   \n",
              "min             NaN        1000.000000      NaN      0.000000    NaN   \n",
              "25%             NaN        1999.000000      NaN     70.000000    NaN   \n",
              "50%             NaN        2003.000000      NaN    105.000000    NaN   \n",
              "75%             NaN        2008.000000      NaN    150.000000    NaN   \n",
              "max             NaN        9999.000000      NaN  17700.000000    NaN   \n",
              "\n",
              "         odometer  registration_month fuel_type       brand unrepaired_damage  \\\n",
              "count       50000        50000.000000     45518       50000             40171   \n",
              "unique         13                 NaN         7          40                 2   \n",
              "top     150,000km                 NaN    benzin  volkswagen              nein   \n",
              "freq        32424                 NaN     30107       10687             35232   \n",
              "mean          NaN            5.723360       NaN         NaN               NaN   \n",
              "std           NaN            3.711984       NaN         NaN               NaN   \n",
              "min           NaN            0.000000       NaN         NaN               NaN   \n",
              "25%           NaN            3.000000       NaN         NaN               NaN   \n",
              "50%           NaN            6.000000       NaN         NaN               NaN   \n",
              "75%           NaN            9.000000       NaN         NaN               NaN   \n",
              "max           NaN           12.000000       NaN         NaN               NaN   \n",
              "\n",
              "                 ad_created  n_pictures   postal_code            last_seen  \n",
              "count                 50000     50000.0  50000.000000                50000  \n",
              "unique                   76         NaN           NaN                39481  \n",
              "top     2016-04-03 00:00:00         NaN           NaN  2016-04-07 06:17:27  \n",
              "freq                   1946         NaN           NaN                    8  \n",
              "mean                    NaN         0.0  50813.627300                  NaN  \n",
              "std                     NaN         0.0  25779.747957                  NaN  \n",
              "min                     NaN         0.0   1067.000000                  NaN  \n",
              "25%                     NaN         0.0  30451.000000                  NaN  \n",
              "50%                     NaN         0.0  49577.000000                  NaN  \n",
              "75%                     NaN         0.0  71540.000000                  NaN  \n",
              "max                     NaN         0.0  99998.000000                  NaN  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "FzoKDoYJMDpY",
        "colab_type": "text"
      },
      "source": [
        "Above summary illustrates that 'seller' and 'offer_type' columns contain only one type of value for all records.\n",
        "Anomalies:\n",
        "'Price' contains some zero and NaN values. 'registration_year' also has a min value of 1000. There are Power_ps with zero values. ad_created contains value of 1946. "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "I88pXZcjMDpa",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "autos['price'] = autos['price'].str.replace('$','').str.replace(',','').astype(float)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "88hNdNwiMDpg",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "autos['odometer'] = autos['odometer'].str.replace('km','').str.replace(',','').astype(float)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Vxg5Igi8MDpm",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "autos.rename({'odometer':'odometer_km'}, axis=1, inplace=True)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "bV4vV4imMDpt",
        "colab_type": "text"
      },
      "source": [
        "We have converted 'price' and 'odometer' columns into a numeric datatype. This will facilitate our further analysis on outliers."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VraYQV9WMDpz",
        "colab_type": "code",
        "colab": {},
        "outputId": "17b6d2e1-d486-4286-c797-64e73560429a"
      },
      "source": [
        "print(autos['price'].unique().shape)\n",
        "print('\\nhighest prices:\\n\\n',autos['price'].value_counts().sort_index(ascending=False).head(10))\n",
        "print('\\nlowest prices:\\n\\n',autos['price'].value_counts().sort_index().head(10))\n",
        "\n",
        "autos['price'].describe()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "(2357,)\n",
            "\n",
            "highest prices:\n",
            "\n",
            " 99999999.0    1\n",
            "27322222.0    1\n",
            "12345678.0    3\n",
            "11111111.0    2\n",
            "10000000.0    1\n",
            "3890000.0     1\n",
            "1300000.0     1\n",
            "1234566.0     1\n",
            "999999.0      2\n",
            "999990.0      1\n",
            "Name: price, dtype: int64\n",
            "\n",
            "lowest prices:\n",
            "\n",
            " 0.0     1421\n",
            "1.0      156\n",
            "2.0        3\n",
            "3.0        1\n",
            "5.0        2\n",
            "8.0        1\n",
            "9.0        1\n",
            "10.0       7\n",
            "11.0       2\n",
            "12.0       3\n",
            "Name: price, dtype: int64\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "count    5.000000e+04\n",
              "mean     9.840044e+03\n",
              "std      4.811044e+05\n",
              "min      0.000000e+00\n",
              "25%      1.100000e+03\n",
              "50%      2.950000e+03\n",
              "75%      7.200000e+03\n",
              "max      1.000000e+08\n",
              "Name: price, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "vGZRnreMMDqI",
        "colab_type": "text"
      },
      "source": [
        "Based on the outliers information we can discard the outliers since they will distort our analysis. Furthermore, some of the prices are unreasonable high or low. By keeping a certain threshold we make sure our analysis is reasonable."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nlzpOq0FMDqK",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "autos = autos[autos['price'].between(500, 100000)]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pF7In5bKMDqa",
        "colab_type": "code",
        "colab": {},
        "outputId": "36684dba-a591-481d-c6a4-ab3aec4dd283"
      },
      "source": [
        "print(autos['odometer_km'].unique().shape)\n",
        "print('\\nhighest km:\\n\\n',autos['odometer_km'].value_counts().sort_index(ascending=False).head(10))\n",
        "print('\\nlowest km:\\n\\n',autos['odometer_km'].value_counts().sort_index().head(10))\n",
        "\n",
        "autos['odometer_km'].describe()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "(13,)\n",
            "\n",
            "highest km:\n",
            "\n",
            " 150000.0    28695\n",
            "125000.0     4836\n",
            "100000.0     2029\n",
            "90000.0      1676\n",
            "80000.0      1384\n",
            "70000.0      1189\n",
            "60000.0      1129\n",
            "50000.0       994\n",
            "40000.0       807\n",
            "30000.0       759\n",
            "Name: odometer_km, dtype: int64\n",
            "\n",
            "lowest km:\n",
            "\n",
            " 5000.0      607\n",
            "10000.0     234\n",
            "20000.0     719\n",
            "30000.0     759\n",
            "40000.0     807\n",
            "50000.0     994\n",
            "60000.0    1129\n",
            "70000.0    1189\n",
            "80000.0    1384\n",
            "90000.0    1676\n",
            "Name: odometer_km, dtype: int64\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "count     45058.000000\n",
              "mean     125364.752097\n",
              "std       39542.959058\n",
              "min        5000.000000\n",
              "25%      100000.000000\n",
              "50%      150000.000000\n",
              "75%      150000.000000\n",
              "max      150000.000000\n",
              "Name: odometer_km, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 37
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_6WET79VMDqh",
        "colab_type": "text"
      },
      "source": [
        "Mileage data looks like within reasonable range: there are no huge or negative values. "
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "gxkncA4XMDqn",
        "colab_type": "text"
      },
      "source": [
        "We have five date columns. In order to analyze them, we will need to check whether they also contain outliers."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wvMZT2-DMDqq",
        "colab_type": "code",
        "colab": {},
        "outputId": "56ffa655-0cd1-4115-a02a-c12ed0259462"
      },
      "source": [
        "autos[['date_crawled', 'ad_created', 'last_seen']][:5]"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 39
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4WSsAI4eMDq0",
        "colab_type": "code",
        "colab": {},
        "outputId": "6eb02222-7496-4a49-e4e7-e9ac5831ed2f"
      },
      "source": [
        "autos['date_c rawled'].str[:10].value_counts(normalize=True, dropna=False).sort_index()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "2016-03-05    0.025545\n",
              "2016-03-06    0.014137\n",
              "2016-03-07    0.036220\n",
              "2016-03-08    0.033157\n",
              "2016-03-09    0.032913\n",
              "2016-03-10    0.032736\n",
              "2016-03-11    0.033046\n",
              "2016-03-12    0.037330\n",
              "2016-03-13    0.015536\n",
              "2016-03-14    0.036331\n",
              "2016-03-15    0.034001\n",
              "2016-03-16    0.029362\n",
              "2016-03-17    0.031160\n",
              "2016-03-18    0.012850\n",
              "2016-03-19    0.034777\n",
              "2016-03-20    0.038084\n",
              "2016-03-21    0.037729\n",
              "2016-03-22    0.032935\n",
              "2016-03-23    0.032403\n",
              "2016-03-24    0.028985\n",
              "2016-03-25    0.031093\n",
              "2016-03-26    0.032625\n",
              "2016-03-27    0.031160\n",
              "2016-03-28    0.034822\n",
              "2016-03-29    0.033290\n",
              "2016-03-30    0.033290\n",
              "2016-03-31    0.031670\n",
              "2016-04-01    0.033867\n",
              "2016-04-02    0.035798\n",
              "2016-04-03    0.038817\n",
              "2016-04-04    0.036642\n",
              "2016-04-05    0.013161\n",
              "2016-04-06    0.003174\n",
              "2016-04-07    0.001354\n",
              "Name: date_crawled, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 42
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "5ZuXs3zBMDrB",
        "colab_type": "text"
      },
      "source": [
        "Most of the values for 'date_crawled' equally distributed for occured dates."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MP4fhF5CMDrD",
        "colab_type": "code",
        "colab": {},
        "outputId": "85281066-1675-4b32-fc7a-afb4b3bcae6b"
      },
      "source": [
        "autos['ad_created'].str[:10].value_counts(normalize=True, dropna=False).sort_index()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "2015-06-11    0.000022\n",
              "2015-08-10    0.000022\n",
              "2015-09-09    0.000022\n",
              "2015-11-10    0.000022\n",
              "2015-12-05    0.000022\n",
              "2015-12-30    0.000022\n",
              "2016-01-03    0.000022\n",
              "2016-01-07    0.000022\n",
              "2016-01-10    0.000044\n",
              "2016-01-13    0.000022\n",
              "2016-01-14    0.000022\n",
              "2016-01-16    0.000022\n",
              "2016-01-22    0.000022\n",
              "2016-01-27    0.000067\n",
              "2016-01-29    0.000022\n",
              "2016-02-01    0.000022\n",
              "2016-02-02    0.000044\n",
              "2016-02-05    0.000044\n",
              "2016-02-07    0.000022\n",
              "2016-02-08    0.000022\n",
              "2016-02-09    0.000022\n",
              "2016-02-11    0.000022\n",
              "2016-02-12    0.000044\n",
              "2016-02-14    0.000044\n",
              "2016-02-16    0.000022\n",
              "2016-02-17    0.000022\n",
              "2016-02-18    0.000044\n",
              "2016-02-19    0.000067\n",
              "2016-02-20    0.000044\n",
              "2016-02-21    0.000044\n",
              "                ...   \n",
              "2016-03-09    0.033024\n",
              "2016-03-10    0.032469\n",
              "2016-03-11    0.033357\n",
              "2016-03-12    0.037108\n",
              "2016-03-13    0.016978\n",
              "2016-03-14    0.034911\n",
              "2016-03-15    0.033779\n",
              "2016-03-16    0.029850\n",
              "2016-03-17    0.030805\n",
              "2016-03-18    0.013494\n",
              "2016-03-19    0.033646\n",
              "2016-03-20    0.038217\n",
              "2016-03-21    0.037951\n",
              "2016-03-22    0.032691\n",
              "2016-03-23    0.032225\n",
              "2016-03-24    0.028963\n",
              "2016-03-25    0.031249\n",
              "2016-03-26    0.032625\n",
              "2016-03-27    0.031115\n",
              "2016-03-28    0.034866\n",
              "2016-03-29    0.033246\n",
              "2016-03-30    0.033179\n",
              "2016-03-31    0.031737\n",
              "2016-04-01    0.033801\n",
              "2016-04-02    0.035488\n",
              "2016-04-03    0.039039\n",
              "2016-04-04    0.037019\n",
              "2016-04-05    0.011896\n",
              "2016-04-06    0.003262\n",
              "2016-04-07    0.001198\n",
              "Name: ad_created, Length: 76, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 43
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "8HEi1dHfMDrO",
        "colab_type": "text"
      },
      "source": [
        "'ad_created' has many early dates representing only small proportion of the entire date column."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Ogpm1wx5MDrQ",
        "colab_type": "code",
        "colab": {},
        "outputId": "9ba81f4d-db3c-4f94-dbe5-1124be918777"
      },
      "source": [
        "autos['last_seen'].str[:10].value_counts(normalize=True, dropna=False).sort_index()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "2016-03-05    0.001087\n",
              "2016-03-06    0.004172\n",
              "2016-03-07    0.005216\n",
              "2016-03-08    0.007013\n",
              "2016-03-09    0.009454\n",
              "2016-03-10    0.010298\n",
              "2016-03-11    0.012051\n",
              "2016-03-12    0.023925\n",
              "2016-03-13    0.008877\n",
              "2016-03-14    0.012295\n",
              "2016-03-15    0.015691\n",
              "2016-03-16    0.016157\n",
              "2016-03-17    0.027698\n",
              "2016-03-18    0.007390\n",
              "2016-03-19    0.015425\n",
              "2016-03-20    0.020418\n",
              "2016-03-21    0.020662\n",
              "2016-03-22    0.021261\n",
              "2016-03-23    0.018399\n",
              "2016-03-24    0.019508\n",
              "2016-03-25    0.018598\n",
              "2016-03-26    0.016423\n",
              "2016-03-27    0.015447\n",
              "2016-03-28    0.020529\n",
              "2016-03-29    0.021372\n",
              "2016-03-30    0.024169\n",
              "2016-03-31    0.023459\n",
              "2016-04-01    0.022882\n",
              "2016-04-02    0.024879\n",
              "2016-04-03    0.024946\n",
              "2016-04-04    0.024324\n",
              "2016-04-05    0.126481\n",
              "2016-04-06    0.225354\n",
              "2016-04-07    0.134138\n",
              "Name: last_seen, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 44
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "tm8SsyBNMDrX",
        "colab_type": "text"
      },
      "source": [
        "'last_seen' has dates that belong to 2016. Only one date seems to have more records: 2016-04-06: around 22.5% of the records are on this date. "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "e7BwoaUGMDra",
        "colab_type": "code",
        "colab": {},
        "outputId": "0d375caa-bed9-4fe8-ee44-9b354e7ad3ae"
      },
      "source": [
        "autos['registration_year'].value_counts().sort_index()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "1000       1\n",
              "1001       1\n",
              "1910       2\n",
              "1927       1\n",
              "1929       1\n",
              "1931       1\n",
              "1934       2\n",
              "1937       4\n",
              "1938       1\n",
              "1939       1\n",
              "1941       2\n",
              "1943       1\n",
              "1948       1\n",
              "1950       1\n",
              "1951       1\n",
              "1952       1\n",
              "1953       1\n",
              "1954       2\n",
              "1955       2\n",
              "1956       4\n",
              "1957       2\n",
              "1958       4\n",
              "1959       6\n",
              "1960      19\n",
              "1961       6\n",
              "1962       4\n",
              "1963       8\n",
              "1964      11\n",
              "1965      17\n",
              "1966      21\n",
              "        ... \n",
              "2000    2714\n",
              "2001    2519\n",
              "2002    2419\n",
              "2003    2657\n",
              "2004    2683\n",
              "2005    2864\n",
              "2006    2666\n",
              "2007    2269\n",
              "2008    2204\n",
              "2009    2078\n",
              "2010    1582\n",
              "2011    1616\n",
              "2012    1304\n",
              "2013     793\n",
              "2014     650\n",
              "2015     360\n",
              "2016     944\n",
              "2017    1296\n",
              "2018     462\n",
              "2019       1\n",
              "2800       1\n",
              "4100       1\n",
              "4500       1\n",
              "4800       1\n",
              "5000       2\n",
              "5911       1\n",
              "6200       1\n",
              "8888       1\n",
              "9000       1\n",
              "9999       3\n",
              "Name: registration_year, Length: 93, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 46
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "NewidWU9MDrf",
        "colab_type": "text"
      },
      "source": [
        "'registration_year' has several outliers: some values are around 1000 and above 2800."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "b_OznB83MDrh",
        "colab_type": "text"
      },
      "source": [
        "Obviously, cars were not made in those years. We can safely remove those rows."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Ro18NmhqMDrp",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "autos = autos[autos['registration_year'].between(1900,2016)]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LLzX9n70MDrv",
        "colab_type": "code",
        "colab": {},
        "outputId": "2169659f-0dba-42a1-9742-5201c578d3bf"
      },
      "source": [
        "autos['registration_year'].value_counts(normalize=True).sort_index()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "1910    0.000046\n",
              "1927    0.000023\n",
              "1929    0.000023\n",
              "1931    0.000023\n",
              "1934    0.000046\n",
              "1937    0.000092\n",
              "1938    0.000023\n",
              "1939    0.000023\n",
              "1941    0.000046\n",
              "1943    0.000023\n",
              "1948    0.000023\n",
              "1950    0.000023\n",
              "1951    0.000023\n",
              "1952    0.000023\n",
              "1953    0.000023\n",
              "1954    0.000046\n",
              "1955    0.000046\n",
              "1956    0.000092\n",
              "1957    0.000046\n",
              "1958    0.000092\n",
              "1959    0.000139\n",
              "1960    0.000439\n",
              "1961    0.000139\n",
              "1962    0.000092\n",
              "1963    0.000185\n",
              "1964    0.000254\n",
              "1965    0.000393\n",
              "1966    0.000485\n",
              "1967    0.000601\n",
              "1968    0.000578\n",
              "          ...   \n",
              "1987    0.001571\n",
              "1988    0.002957\n",
              "1989    0.003581\n",
              "1990    0.006330\n",
              "1991    0.006769\n",
              "1992    0.007023\n",
              "1993    0.007855\n",
              "1994    0.011552\n",
              "1995    0.019846\n",
              "1996    0.024767\n",
              "1997    0.034909\n",
              "1998    0.046738\n",
              "1999    0.059421\n",
              "2000    0.062702\n",
              "2001    0.058197\n",
              "2002    0.055887\n",
              "2003    0.061385\n",
              "2004    0.061986\n",
              "2005    0.066168\n",
              "2006    0.061593\n",
              "2007    0.052421\n",
              "2008    0.050920\n",
              "2009    0.048009\n",
              "2010    0.036549\n",
              "2011    0.037335\n",
              "2012    0.030127\n",
              "2013    0.018321\n",
              "2014    0.015017\n",
              "2015    0.008317\n",
              "2016    0.021809\n",
              "Name: registration_year, Length: 78, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 53
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "RcsahPjuMDr0",
        "colab_type": "text"
      },
      "source": [
        "Next, let us analyze the 'brand column to see the top, average and lowest selling car brands."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "TgcacJKBMDr2",
        "colab_type": "code",
        "colab": {},
        "outputId": "1cb10d9f-3dcd-44bd-bea4-240c9e8b6616"
      },
      "source": [
        "autos['brand'].value_counts(sorted)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "volkswagen        0.212088\n",
              "bmw               0.115054\n",
              "mercedes_benz     0.102278\n",
              "opel              0.100430\n",
              "audi              0.090565\n",
              "ford              0.065197\n",
              "renault           0.043942\n",
              "peugeot           0.029387\n",
              "fiat              0.023542\n",
              "seat              0.017905\n",
              "skoda             0.017166\n",
              "smart             0.015133\n",
              "mazda             0.015017\n",
              "nissan            0.015017\n",
              "citroen           0.014162\n",
              "toyota            0.013423\n",
              "hyundai           0.010165\n",
              "sonstige_autos    0.009588\n",
              "mini              0.009380\n",
              "volvo             0.009380\n",
              "honda             0.007809\n",
              "mitsubishi        0.007740\n",
              "kia               0.007347\n",
              "alfa_romeo        0.006631\n",
              "chevrolet         0.006030\n",
              "suzuki            0.005914\n",
              "porsche           0.005822\n",
              "chrysler          0.003604\n",
              "dacia             0.002842\n",
              "jeep              0.002449\n",
              "land_rover        0.002264\n",
              "daihatsu          0.002172\n",
              "subaru            0.001987\n",
              "saab              0.001663\n",
              "jaguar            0.001617\n",
              "daewoo            0.001340\n",
              "rover             0.001248\n",
              "trabant           0.001109\n",
              "lancia            0.000993\n",
              "lada              0.000601\n",
              "Name: brand, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 57
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "mjs3zzGkMDsA",
        "colab_type": "text"
      },
      "source": [
        "As we can see volkswagen, bmw and mecredes_benz are the most popular brands while trabant, lancia and lada are the least popular in German Ebay."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "toTE1nFaMDsC",
        "colab_type": "text"
      },
      "source": [
        "We will analyze the mean price of top 10 selling brands to see if they have substantial price differences."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mSU4to7pMDsD",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "top10 = list(autos['brand'].value_counts(sorted).index[:10])"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "o9EXzAb_MDsK",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "mean_prices = {}\n",
        "for brand in top10:\n",
        "    one_brand = autos[autos['brand']==brand]\n",
        "    mean_pr = one_brand['price'].mean()\n",
        "    mean_prices[brand] = mean_pr"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "veyziUkdMDsP",
        "colab_type": "code",
        "colab": {},
        "outputId": "de0710d6-4af2-4a91-df27-f12f0befedb7"
      },
      "source": [
        "mean_prices"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'audi': 9571.457397959184,\n",
              " 'bmw': 8447.069879518072,\n",
              " 'fiat': 3256.152109911678,\n",
              " 'ford': 4247.120481927711,\n",
              " 'mercedes_benz': 8666.677208041563,\n",
              " 'opel': 3394.0395675178283,\n",
              " 'peugeot': 3360.9205974842766,\n",
              " 'renault': 2819.059411146162,\n",
              " 'seat': 4810.883870967742,\n",
              " 'volkswagen': 5783.622984749455}"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 90
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "shLdd08HMDsd",
        "colab_type": "text"
      },
      "source": [
        "Based on the dataset analysis, the highest mean price for cars are of audi brand and then mercedes_benz brand with 9571 and 8666 accordingly. The lowest mean prices belong to renault and then fiat with 2819 and 3256 prices accordingly. "
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "jYIUxAPoMDsh",
        "colab_type": "text"
      },
      "source": [
        "Mean mileage for top 10 brands"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "46_Iw90nMDsi",
        "colab_type": "code",
        "colab": {},
        "outputId": "82d9edea-3b71-4de2-9a1b-a9b0ae87d28e"
      },
      "source": [
        "mean_mileage = {}\n",
        "for brand in top10:\n",
        "    one_brand = autos[autos['brand']==brand]\n",
        "    mean_km = one_brand['odometer_km'].mean()\n",
        "    mean_mileage[brand] = mean_km\n",
        "mean_mileage"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'audi': 128941.32653061225,\n",
              " 'bmw': 132928.71485943775,\n",
              " 'fiat': 114416.09421000982,\n",
              " 'ford': 123520.55279943303,\n",
              " 'mercedes_benz': 131083.12627061215,\n",
              " 'opel': 128012.42236024844,\n",
              " 'peugeot': 126073.11320754717,\n",
              " 'renault': 126351.20925341746,\n",
              " 'seat': 120058.06451612903,\n",
              " 'volkswagen': 128234.74945533769}"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 92
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "eKDJCrjKMDsp",
        "colab_type": "code",
        "colab": {},
        "outputId": "1297d522-56e6-4d15-bf00-ed7a53ba161b"
      },
      "source": [
        "mean_prices = pd.Series(mean_prices)\n",
        "mean_mileage = pd.Series(mean_mileage)\n",
        "price_km = pd.DataFrame(mean_prices, columns=[\"mean_price\"])\n",
        "price_km[\"mean_mileage\"] = mean_mileage\n",
        "\n",
        "print(price_km)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "                mean_price   mean_mileage\n",
            "audi           9571.457398  128941.326531\n",
            "bmw            8447.069880  132928.714859\n",
            "fiat           3256.152110  114416.094210\n",
            "ford           4247.120482  123520.552799\n",
            "mercedes_benz  8666.677208  131083.126271\n",
            "opel           3394.039568  128012.422360\n",
            "peugeot        3360.920597  126073.113208\n",
            "renault        2819.059411  126351.209253\n",
            "seat           4810.883871  120058.064516\n",
            "volkswagen     5783.622985  128234.749455\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "GvNnRVg8MDsu",
        "colab_type": "text"
      },
      "source": [
        "Most of the cars from top 10 brands have over 110k km mileage and there are no substantial difference in their mileage on average. This means their prices are not influence by mileage. "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "njhDRIiQMDsw",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}