Group1_Data_Analysis.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Group1 Data Analysis.ipynb",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "id": "RP9HfJTEZqJT",
        "outputId": "1ac0c7e4-ab18-4109-a30f-42e7b4d4f16c",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 258
        }
      },
      "source": [
        "%%bash\n",
        "# Need to install pyspark\n",
        "# if pyspark is already installed, will print a message indicating pyspark already isntalled\n",
        "pip install pyspark\n",
        "pip install seaborn"
      ],
      "execution_count": 30,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Requirement already satisfied: pyspark in /usr/local/lib/python3.6/dist-packages (3.0.1)\n",
            "Requirement already satisfied: py4j==0.10.9 in /usr/local/lib/python3.6/dist-packages (from pyspark) (0.10.9)\n",
            "Requirement already satisfied: seaborn in /usr/local/lib/python3.6/dist-packages (0.11.0)\n",
            "Requirement already satisfied: matplotlib>=2.2 in /usr/local/lib/python3.6/dist-packages (from seaborn) (3.2.2)\n",
            "Requirement already satisfied: pandas>=0.23 in /usr/local/lib/python3.6/dist-packages (from seaborn) (1.1.2)\n",
            "Requirement already satisfied: scipy>=1.0 in /usr/local/lib/python3.6/dist-packages (from seaborn) (1.4.1)\n",
            "Requirement already satisfied: numpy>=1.15 in /usr/local/lib/python3.6/dist-packages (from seaborn) (1.18.5)\n",
            "Requirement already satisfied: kiwisolver>=1.0.1 in /usr/local/lib/python3.6/dist-packages (from matplotlib>=2.2->seaborn) (1.2.0)\n",
            "Requirement already satisfied: python-dateutil>=2.1 in /usr/local/lib/python3.6/dist-packages (from matplotlib>=2.2->seaborn) (2.8.1)\n",
            "Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.1 in /usr/local/lib/python3.6/dist-packages (from matplotlib>=2.2->seaborn) (2.4.7)\n",
            "Requirement already satisfied: cycler>=0.10 in /usr/local/lib/python3.6/dist-packages (from matplotlib>=2.2->seaborn) (0.10.0)\n",
            "Requirement already satisfied: pytz>=2017.2 in /usr/local/lib/python3.6/dist-packages (from pandas>=0.23->seaborn) (2018.9)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.6/dist-packages (from python-dateutil>=2.1->matplotlib>=2.2->seaborn) (1.15.0)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qlRNgJJUOybF",
        "outputId": "05c9c8b2-a83a-467d-dd2f-56b74c3bf35e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "%matplotlib inline\n",
        "from pyspark.sql import SparkSession\n",
        "from pyspark.sql import SQLContext\n",
        "spark = SparkSession.builder.getOrCreate()\n",
        "sc = spark.sparkContext\n",
        "sqlContext = SQLContext(sc)\n",
        "import os\n",
        "import pandas as pd\n",
        "\n",
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "0OuApHQTRRH0"
      },
      "source": [
        "sampled_df = spark.read.format(\"csv\").option(\"header\", \"true\").option('inferSchema','true').load(\"drive/Shared drives/IST 718 Group1/sampled_used_cars_data_nodesc.csv\")\n"
      ],
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "028f5u5SaZoZ",
        "outputId": "ce078808-6e24-4f4a-c902-3f7f2405699b",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 207
        }
      },
      "source": [
        "sampled_df.describe().show()"
      ],
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "+-------+------------+-----+----------+----------+-----------+-----------+-----------+-----------------+--------------------+------------------+------------------+--------------------+-------------------+--------------------+------------------+--------------+-------------+----------------+---------+-------+--------------------+------------------+--------------------+------------+-----------------+------+-----------+-------------+--------------------+------------------+--------------------+--------------------+----------+---------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+--------------------+--------------------+------------+--------------------+------+------------------+-----------------------+------------+--------------------+---------+-------+------------------+\n",
            "|summary|back_legroom|  bed|bed_height|bed_length|  body_type|      cabin|       city|city_fuel_economy|combine_fuel_economy|      daysonmarket|        dealer_zip|    engine_cylinders|engine_displacement|         engine_type|    exterior_color|franchise_make|front_legroom|fuel_tank_volume|fuel_type| height|highway_fuel_economy|        horsepower|      interior_color|is_certified|         latitude|length|listed_date|listing_color|          listing_id|         longitude|    main_picture_url|       major_options| make_name|maximum_seating|           mileage|        model_name|       owner_count|             power|             price|    savings_amount|     seller_rating|             sp_id|             sp_name|              torque|transmission|transmission_display|trimId|         trim_name|vehicle_damage_category|wheel_system|wheel_system_display|wheelbase|  width|              year|\n",
            "+-------+------------+-----+----------+----------+-----------+-----------+-----------+-----------------+--------------------+------------------+------------------+--------------------+-------------------+--------------------+------------------+--------------+-------------+----------------+---------+-------+--------------------+------------------+--------------------+------------+-----------------+------+-----------+-------------+--------------------+------------------+--------------------+--------------------+----------+---------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+--------------------+--------------------+------------+--------------------+------+------------------+-----------------------+------------+--------------------+---------+-------+------------------+\n",
            "|  count|      568235| 3872|     85681|     85681|     597258|      12689|     600000|           501620|                   0|            600000|            600000|              579902|             565512|              579902|            600000|        486291|       568235|          568235|   583464| 568235|              501620|            565512|              600000|           0|           600000|568235|     600000|       600000|              600000|            600000|              526054|              560352|    600000|         568235|            571257|            600000|            295968|            503732|            600000|            600000|            591822|            599978|              600000|              496466|      587236|              587236|576755|            576660|                      0|      570574|              570574|   568235| 568235|            600000|\n",
            "|   mean|        null| null|      null|      null|       null|       null|       null|22.70774690004386|                null| 76.10529833333334|50683.833049420784|                null|  2964.978108333687|                null|3394.3119054054055|          null|         null|            null|     null|   null|  29.492167377696266|247.81264588549845|   20302.30188679245|        null|36.98211039349812|  null|       null|         null|2.7549502796125835E8|-90.63669713883004|                null|                null|      null|           null|30966.390706809718|1597.8020671361933|1.5295876581252028|              null|29943.799059681663|        552.019285|  4.27172864437797|233140.01327048658|                null|                null|        null|                null|  null|103.86844262295082|                   null|        null|                null|     null|   null|2017.7420083333334|\n",
            "| stddev|        null| null|      null|      null|       null|       null|       null|8.841890053898126|                null|108.86019361929651|27346.850170305876|                null| 1348.7357940641214|                null| 17875.31755485475|          null|         null|            null|     null|   null|   7.797579801661734| 90.50039714538332|    48058.7743531833|        null|5.001287184248553|  null|       null|         null|    8892084.07543214|13.892728378699621|                null|                null|      null|           null| 45229.39412627619| 765.6960222014462|  0.91639462021543|              null|19395.820934146363|1104.4836025822794|0.5118994987864424|132333.77791986245|                null|                null|        null|                null|  null| 520.7522367955858|                   null|        null|                null|     null|   null| 4.184478599503004|\n",
            "|    min|          --| Long|        --|        --|Convertible|   Crew Cab|    Hayward|                8|                null|                 0|        08816-4351|                  H4|                700|                  H4|            #NAME?|         Acura|           --|              --|Biodiesel|     --|                  10|                67|              #NAME?|        null|          18.3988|    --|   1/1/2018|        BLACK|            40920314|          -157.913|https://11ee4e48a...|['101A Mid Equipm...|AM General|             --|                 0|          1 Series|                 1|100 hp @ 4,000 RPM|             165.0|                 0|               1.0|             41593|\t Dijie Auto Sale...|100 lb-ft @ 4,500...|           A|   1-Speed Automatic|t10002|                 !|                   null|         4WD|                 4X2|       --|     --|              1923|\n",
            "|    max|     47.5 in|Short|        --|   98.6 in|      Wagon|Regular Cab|north hills|              127|                null|              2979|             99403|W12 Flex Fuel Veh...|               8400|W12 Flex Fuel Veh...|            yellow|         smart|        67 in|         9.5 gal|  Propane|99.2 in|                 127|               808|xDrive35i Premium...|        null|          48.9237|290 in|   9/9/2020|       YELLOW|           282000747|          -66.0785|https://www.track...|     ['Z71 Package']|     smart|        9 seats|           1225238|                xD|                16| 99 hp @ 4,800 RPM|         2000000.0|            147414|               5.0|            440951|      vBs Auto Sales|98 lb-ft @ 5,000 RPM|           M|              Manual| t9993|     xDrive50i AWD|                   null|         RWD|    Rear-Wheel Drive|  99.9 in|99.6 in|              2021|\n",
            "+-------+------------+-----+----------+----------+-----------+-----------+-----------+-----------------+--------------------+------------------+------------------+--------------------+-------------------+--------------------+------------------+--------------+-------------+----------------+---------+-------+--------------------+------------------+--------------------+------------+-----------------+------+-----------+-------------+--------------------+------------------+--------------------+--------------------+----------+---------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+--------------------+--------------------+------------+--------------------+------+------------------+-----------------------+------------+--------------------+---------+-------+------------------+\n",
            "\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FjUBMFA2eb8I",
        "outputId": "ac8088f1-102c-4446-fa40-47b9508e2537",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "sampled_df.limit(25).toPandas()"
      ],
      "execution_count": 5,
      "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>back_legroom</th>\n",
              "      <th>bed</th>\n",
              "      <th>bed_height</th>\n",
              "      <th>bed_length</th>\n",
              "      <th>body_type</th>\n",
              "      <th>cabin</th>\n",
              "      <th>city</th>\n",
              "      <th>city_fuel_economy</th>\n",
              "      <th>combine_fuel_economy</th>\n",
              "      <th>daysonmarket</th>\n",
              "      <th>dealer_zip</th>\n",
              "      <th>engine_cylinders</th>\n",
              "      <th>engine_displacement</th>\n",
              "      <th>engine_type</th>\n",
              "      <th>exterior_color</th>\n",
              "      <th>fleet</th>\n",
              "      <th>frame_damaged</th>\n",
              "      <th>franchise_dealer</th>\n",
              "      <th>franchise_make</th>\n",
              "      <th>front_legroom</th>\n",
              "      <th>fuel_tank_volume</th>\n",
              "      <th>fuel_type</th>\n",
              "      <th>has_accidents</th>\n",
              "      <th>height</th>\n",
              "      <th>highway_fuel_economy</th>\n",
              "      <th>horsepower</th>\n",
              "      <th>interior_color</th>\n",
              "      <th>isCab</th>\n",
              "      <th>is_certified</th>\n",
              "      <th>is_cpo</th>\n",
              "      <th>is_new</th>\n",
              "      <th>is_oemcpo</th>\n",
              "      <th>latitude</th>\n",
              "      <th>length</th>\n",
              "      <th>listed_date</th>\n",
              "      <th>listing_color</th>\n",
              "      <th>listing_id</th>\n",
              "      <th>longitude</th>\n",
              "      <th>main_picture_url</th>\n",
              "      <th>major_options</th>\n",
              "      <th>make_name</th>\n",
              "      <th>maximum_seating</th>\n",
              "      <th>mileage</th>\n",
              "      <th>model_name</th>\n",
              "      <th>owner_count</th>\n",
              "      <th>power</th>\n",
              "      <th>price</th>\n",
              "      <th>salvage</th>\n",
              "      <th>savings_amount</th>\n",
              "      <th>seller_rating</th>\n",
              "      <th>sp_id</th>\n",
              "      <th>sp_name</th>\n",
              "      <th>theft_title</th>\n",
              "      <th>torque</th>\n",
              "      <th>transmission</th>\n",
              "      <th>transmission_display</th>\n",
              "      <th>trimId</th>\n",
              "      <th>trim_name</th>\n",
              "      <th>vehicle_damage_category</th>\n",
              "      <th>wheel_system</th>\n",
              "      <th>wheel_system_display</th>\n",
              "      <th>wheelbase</th>\n",
              "      <th>width</th>\n",
              "      <th>year</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>35.1 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>Bayamon</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>522</td>\n",
              "      <td>960</td>\n",
              "      <td>I4</td>\n",
              "      <td>1300.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>Solar Yellow</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Jeep</td>\n",
              "      <td>41.2 in</td>\n",
              "      <td>12.7 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>66.5 in</td>\n",
              "      <td>NaN</td>\n",
              "      <td>177.0</td>\n",
              "      <td>Black</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>18.3988</td>\n",
              "      <td>166.6 in</td>\n",
              "      <td>4/6/2019</td>\n",
              "      <td>YELLOW</td>\n",
              "      <td>237132766</td>\n",
              "      <td>-66.1582</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Quick Order Package']</td>\n",
              "      <td>Jeep</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>7</td>\n",
              "      <td>Renegade</td>\n",
              "      <td>NaN</td>\n",
              "      <td>177 hp @ 5,750 RPM</td>\n",
              "      <td>23141.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>2.800000</td>\n",
              "      <td>370599</td>\n",
              "      <td>Flagship Chrysler</td>\n",
              "      <td>None</td>\n",
              "      <td>200 lb-ft @ 1,750 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>9-Speed Automatic Overdrive</td>\n",
              "      <td>t83804</td>\n",
              "      <td>Latitude FWD</td>\n",
              "      <td>None</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>101.2 in</td>\n",
              "      <td>79.6 in</td>\n",
              "      <td>2019</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>38.1 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>San Juan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>207</td>\n",
              "      <td>922</td>\n",
              "      <td>I4</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>Narvik Black</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Land Rover</td>\n",
              "      <td>39.1 in</td>\n",
              "      <td>17.7 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>68 in</td>\n",
              "      <td>NaN</td>\n",
              "      <td>246.0</td>\n",
              "      <td>Black (Ebony)</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>18.4439</td>\n",
              "      <td>181 in</td>\n",
              "      <td>2/15/2020</td>\n",
              "      <td>BLACK</td>\n",
              "      <td>265946296</td>\n",
              "      <td>-66.0785</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Adaptive Cruise Control']</td>\n",
              "      <td>Land Rover</td>\n",
              "      <td>7 seats</td>\n",
              "      <td>8</td>\n",
              "      <td>Discovery Sport</td>\n",
              "      <td>NaN</td>\n",
              "      <td>246 hp @ 5,500 RPM</td>\n",
              "      <td>46500.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>389227</td>\n",
              "      <td>Land Rover San Juan</td>\n",
              "      <td>None</td>\n",
              "      <td>269 lb-ft @ 1,400 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>9-Speed Automatic Overdrive</td>\n",
              "      <td>t86759</td>\n",
              "      <td>S AWD</td>\n",
              "      <td>None</td>\n",
              "      <td>AWD</td>\n",
              "      <td>All-Wheel Drive</td>\n",
              "      <td>107.9 in</td>\n",
              "      <td>85.6 in</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>33.4 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>Tampa</td>\n",
              "      <td>25.0</td>\n",
              "      <td>None</td>\n",
              "      <td>194</td>\n",
              "      <td>33614</td>\n",
              "      <td>I4</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>Brilliant Silver Metallic</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>42.8 in</td>\n",
              "      <td>14.5 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>62.5 in</td>\n",
              "      <td>32.0</td>\n",
              "      <td>141.0</td>\n",
              "      <td>Black (Charcoal)</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>27.9959</td>\n",
              "      <td>172.8 in</td>\n",
              "      <td>2/29/2020</td>\n",
              "      <td>SILVER</td>\n",
              "      <td>267331641</td>\n",
              "      <td>-82.5076</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Steel Wheels', 'Bluetooth', 'Backup Camera',...</td>\n",
              "      <td>Nissan</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>2</td>\n",
              "      <td>Rogue Sport</td>\n",
              "      <td>NaN</td>\n",
              "      <td>141 hp @ 6,000 RPM</td>\n",
              "      <td>21466.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>4.233333</td>\n",
              "      <td>377115</td>\n",
              "      <td>Courtesy Nissan of Tampa</td>\n",
              "      <td>None</td>\n",
              "      <td>147 lb-ft @ 4,400 RPM</td>\n",
              "      <td>CVT</td>\n",
              "      <td>Continuously Variable Transmission</td>\n",
              "      <td>t89963</td>\n",
              "      <td>S FWD</td>\n",
              "      <td>None</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>104.2 in</td>\n",
              "      <td>72.3 in</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>--</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Coupe</td>\n",
              "      <td>None</td>\n",
              "      <td>Phoenix</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>80</td>\n",
              "      <td>85034</td>\n",
              "      <td>H6</td>\n",
              "      <td>3800.0</td>\n",
              "      <td>H6</td>\n",
              "      <td>Guards Red</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>--</td>\n",
              "      <td>16.9 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>False</td>\n",
              "      <td>51.2 in</td>\n",
              "      <td>NaN</td>\n",
              "      <td>355.0</td>\n",
              "      <td>Black</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>33.4225</td>\n",
              "      <td>174.3 in</td>\n",
              "      <td>6/23/2020</td>\n",
              "      <td>RED</td>\n",
              "      <td>274772549</td>\n",
              "      <td>-111.9890</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Leather Seats', 'Backup Camera']</td>\n",
              "      <td>Porsche</td>\n",
              "      <td>4 seats</td>\n",
              "      <td>82632</td>\n",
              "      <td>911</td>\n",
              "      <td>5.0</td>\n",
              "      <td>355 hp @ 6,600 RPM</td>\n",
              "      <td>40950.0</td>\n",
              "      <td>False</td>\n",
              "      <td>5077</td>\n",
              "      <td>4.642857</td>\n",
              "      <td>379334</td>\n",
              "      <td>Distinctive Auto Brokers</td>\n",
              "      <td>False</td>\n",
              "      <td>295 lb-ft @ 4,600 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>6-Speed Automatic</td>\n",
              "      <td>t33302</td>\n",
              "      <td>Carrera S</td>\n",
              "      <td>None</td>\n",
              "      <td>RWD</td>\n",
              "      <td>Rear-Wheel Drive</td>\n",
              "      <td>92.5 in</td>\n",
              "      <td>71.2 in</td>\n",
              "      <td>2008</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>33.7 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Coupe</td>\n",
              "      <td>None</td>\n",
              "      <td>Knoxville</td>\n",
              "      <td>22.0</td>\n",
              "      <td>None</td>\n",
              "      <td>36</td>\n",
              "      <td>37912</td>\n",
              "      <td>I6</td>\n",
              "      <td>3000.0</td>\n",
              "      <td>I6</td>\n",
              "      <td>Estoril Blue Metallic</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>Chevrolet</td>\n",
              "      <td>41.8 in</td>\n",
              "      <td>15.8 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>False</td>\n",
              "      <td>54.2 in</td>\n",
              "      <td>32.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Black</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>35.9991</td>\n",
              "      <td>182.6 in</td>\n",
              "      <td>8/5/2020</td>\n",
              "      <td>BLUE</td>\n",
              "      <td>278419497</td>\n",
              "      <td>-83.9644</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Sport Package', 'Driver Assistance Package',...</td>\n",
              "      <td>BMW</td>\n",
              "      <td>4 seats</td>\n",
              "      <td>78975</td>\n",
              "      <td>4 Series</td>\n",
              "      <td>2.0</td>\n",
              "      <td>300 hp @ 5,800 RPM</td>\n",
              "      <td>20993.0</td>\n",
              "      <td>False</td>\n",
              "      <td>1024</td>\n",
              "      <td>4.555556</td>\n",
              "      <td>53420</td>\n",
              "      <td>Reeder Chevrolet</td>\n",
              "      <td>False</td>\n",
              "      <td>300 lb-ft @ 1,300 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>Automatic</td>\n",
              "      <td>t52660</td>\n",
              "      <td>435i Coupe RWD</td>\n",
              "      <td>None</td>\n",
              "      <td>RWD</td>\n",
              "      <td>Rear-Wheel Drive</td>\n",
              "      <td>110.6 in</td>\n",
              "      <td>79.4 in</td>\n",
              "      <td>2014</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Pickup Truck</td>\n",
              "      <td>None</td>\n",
              "      <td>Albuquerque</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>16</td>\n",
              "      <td>87112</td>\n",
              "      <td>V8 Biodiesel</td>\n",
              "      <td>NaN</td>\n",
              "      <td>V8 Biodiesel</td>\n",
              "      <td>Oxford White</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Ford</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Biodiesel</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>35.0872</td>\n",
              "      <td>None</td>\n",
              "      <td>8/26/2020</td>\n",
              "      <td>WHITE</td>\n",
              "      <td>280318985</td>\n",
              "      <td>-106.5480</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Value Package', 'Steel Wheels', 'Bluetooth',...</td>\n",
              "      <td>Ford</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>F-450 Super Duty</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>53355.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>56927</td>\n",
              "      <td>Rich Ford</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>A</td>\n",
              "      <td>Automatic</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>40.6 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>Murfreesboro</td>\n",
              "      <td>20.0</td>\n",
              "      <td>None</td>\n",
              "      <td>40</td>\n",
              "      <td>37129</td>\n",
              "      <td>I4</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>Red</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>Ford</td>\n",
              "      <td>42.6 in</td>\n",
              "      <td>18.5 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>False</td>\n",
              "      <td>68.7 in</td>\n",
              "      <td>27.0</td>\n",
              "      <td>245.0</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>35.8689</td>\n",
              "      <td>188.1 in</td>\n",
              "      <td>8/2/2020</td>\n",
              "      <td>RED</td>\n",
              "      <td>278207490</td>\n",
              "      <td>-86.4126</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Leather Seats', 'Navigation System', 'Alloy ...</td>\n",
              "      <td>Ford</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>23700</td>\n",
              "      <td>Edge</td>\n",
              "      <td>1.0</td>\n",
              "      <td>280 hp @ 6,500 RPM</td>\n",
              "      <td>27404.0</td>\n",
              "      <td>False</td>\n",
              "      <td>1238</td>\n",
              "      <td>3.888889</td>\n",
              "      <td>289819</td>\n",
              "      <td>Ford of Murfreesboro</td>\n",
              "      <td>False</td>\n",
              "      <td>250 lb-ft @ 4,000 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>Automatic</td>\n",
              "      <td>t73862</td>\n",
              "      <td>SEL AWD</td>\n",
              "      <td>None</td>\n",
              "      <td>AWD</td>\n",
              "      <td>All-Wheel Drive</td>\n",
              "      <td>112.2 in</td>\n",
              "      <td>85.8 in</td>\n",
              "      <td>2018</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>37.1 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>San Juan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>70</td>\n",
              "      <td>922</td>\n",
              "      <td>I4</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>Fuji White</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Land Rover</td>\n",
              "      <td>40.2 in</td>\n",
              "      <td>16.6 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>66.3 in</td>\n",
              "      <td>NaN</td>\n",
              "      <td>247.0</td>\n",
              "      <td>White (Eclipse / Ebony / Ebony)</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>18.4439</td>\n",
              "      <td>188.9 in</td>\n",
              "      <td>7/1/2020</td>\n",
              "      <td>WHITE</td>\n",
              "      <td>275458784</td>\n",
              "      <td>-66.0785</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Adaptive Cruise Control']</td>\n",
              "      <td>Land Rover</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>11</td>\n",
              "      <td>Range Rover Velar</td>\n",
              "      <td>NaN</td>\n",
              "      <td>247 hp @ 5,500 RPM</td>\n",
              "      <td>68520.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>389227</td>\n",
              "      <td>Land Rover San Juan</td>\n",
              "      <td>None</td>\n",
              "      <td>269 lb-ft @ 1,200 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>8-Speed Automatic Overdrive</td>\n",
              "      <td>t85614</td>\n",
              "      <td>P250 R-Dynamic S AWD</td>\n",
              "      <td>None</td>\n",
              "      <td>AWD</td>\n",
              "      <td>All-Wheel Drive</td>\n",
              "      <td>113.1 in</td>\n",
              "      <td>84.4 in</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>35.7 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Sedan</td>\n",
              "      <td>None</td>\n",
              "      <td>Greeley</td>\n",
              "      <td>30.0</td>\n",
              "      <td>None</td>\n",
              "      <td>363</td>\n",
              "      <td>80634</td>\n",
              "      <td>I4</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>Phantom Black</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Hyundai</td>\n",
              "      <td>42.2 in</td>\n",
              "      <td>14 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>56.5 in</td>\n",
              "      <td>40.0</td>\n",
              "      <td>147.0</td>\n",
              "      <td>Gray</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>40.3903</td>\n",
              "      <td>181.9 in</td>\n",
              "      <td>9/14/2019</td>\n",
              "      <td>BLACK</td>\n",
              "      <td>252269092</td>\n",
              "      <td>-104.7540</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Sunroof/Moonroof', 'Bluetooth', 'Cargo Packa...</td>\n",
              "      <td>Hyundai</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>42</td>\n",
              "      <td>Elantra</td>\n",
              "      <td>NaN</td>\n",
              "      <td>147 hp @ 6,200 RPM</td>\n",
              "      <td>21440.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>278480</td>\n",
              "      <td>Hyundai of Greeley</td>\n",
              "      <td>None</td>\n",
              "      <td>132 lb-ft @ 4,500 RPM</td>\n",
              "      <td>CVT</td>\n",
              "      <td>Continuously Variable Transmission</td>\n",
              "      <td>t85684</td>\n",
              "      <td>Value Edition Sedan FWD</td>\n",
              "      <td>None</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>106.3 in</td>\n",
              "      <td>70.9 in</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>36.7 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>Irving</td>\n",
              "      <td>27.0</td>\n",
              "      <td>None</td>\n",
              "      <td>315</td>\n",
              "      <td>75062</td>\n",
              "      <td>I3</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>I3</td>\n",
              "      <td>Lightning Blue</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Ford</td>\n",
              "      <td>42.9 in</td>\n",
              "      <td>13.6 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>64.8 in</td>\n",
              "      <td>29.0</td>\n",
              "      <td>123.0</td>\n",
              "      <td>EBONY BLACK</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>32.8374</td>\n",
              "      <td>161.3 in</td>\n",
              "      <td>11/1/2019</td>\n",
              "      <td>BLUE</td>\n",
              "      <td>256802826</td>\n",
              "      <td>-96.9558</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Sunroof/Moonroof', 'Backup Camera', 'Parking...</td>\n",
              "      <td>Ford</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>549</td>\n",
              "      <td>EcoSport</td>\n",
              "      <td>NaN</td>\n",
              "      <td>123 hp @ 6,000 RPM</td>\n",
              "      <td>21051.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>3.250000</td>\n",
              "      <td>57912</td>\n",
              "      <td>Westway Ford</td>\n",
              "      <td>None</td>\n",
              "      <td>125 lb-ft @ 3,500 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>6-Speed Automatic</td>\n",
              "      <td>t85565</td>\n",
              "      <td>SE FWD</td>\n",
              "      <td>None</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>99.2 in</td>\n",
              "      <td>81 in</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>36.8 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>Marietta</td>\n",
              "      <td>19.0</td>\n",
              "      <td>None</td>\n",
              "      <td>50</td>\n",
              "      <td>30067</td>\n",
              "      <td>I6</td>\n",
              "      <td>3000.0</td>\n",
              "      <td>I6</td>\n",
              "      <td>BLACK</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>39.9 in</td>\n",
              "      <td>17.7 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>False</td>\n",
              "      <td>65.4 in</td>\n",
              "      <td>26.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Red</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>33.9239</td>\n",
              "      <td>183 in</td>\n",
              "      <td>7/22/2020</td>\n",
              "      <td>BLACK</td>\n",
              "      <td>277214032</td>\n",
              "      <td>-84.4921</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Sport Package', 'Leather Seats', 'Sunroof/Mo...</td>\n",
              "      <td>BMW</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>87283</td>\n",
              "      <td>X3</td>\n",
              "      <td>1.0</td>\n",
              "      <td>300 hp @ 5,800 RPM</td>\n",
              "      <td>16995.0</td>\n",
              "      <td>False</td>\n",
              "      <td>405</td>\n",
              "      <td>4.485714</td>\n",
              "      <td>407017</td>\n",
              "      <td>Quality Autos</td>\n",
              "      <td>False</td>\n",
              "      <td>300 lb-ft @ 1,300 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>Automatic</td>\n",
              "      <td>t50846</td>\n",
              "      <td>xDrive35i AWD</td>\n",
              "      <td>None</td>\n",
              "      <td>AWD</td>\n",
              "      <td>All-Wheel Drive</td>\n",
              "      <td>110.6 in</td>\n",
              "      <td>82.6 in</td>\n",
              "      <td>2014</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Pickup Truck</td>\n",
              "      <td>None</td>\n",
              "      <td>Weatherford</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>50</td>\n",
              "      <td>76087</td>\n",
              "      <td>I4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>I4</td>\n",
              "      <td>Midnight Black Metallic</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Toyota</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Black (Cement)</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>32.7569</td>\n",
              "      <td>None</td>\n",
              "      <td>7/23/2020</td>\n",
              "      <td>BLACK</td>\n",
              "      <td>277344587</td>\n",
              "      <td>-97.7000</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Adaptive Cruise Control', 'RS Package', 'Ste...</td>\n",
              "      <td>Toyota</td>\n",
              "      <td>None</td>\n",
              "      <td>8</td>\n",
              "      <td>Tacoma</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>28529.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>3.726190</td>\n",
              "      <td>327035</td>\n",
              "      <td>Shottenkirk Toyota Weatherford</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>A</td>\n",
              "      <td>Automatic</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>34.6 in</td>\n",
              "      <td>None</td>\n",
              "      <td>--</td>\n",
              "      <td>78.9 in</td>\n",
              "      <td>Pickup Truck</td>\n",
              "      <td>None</td>\n",
              "      <td>Rhinelander</td>\n",
              "      <td>16.0</td>\n",
              "      <td>None</td>\n",
              "      <td>40</td>\n",
              "      <td>54501</td>\n",
              "      <td>V8</td>\n",
              "      <td>5300.0</td>\n",
              "      <td>V8</td>\n",
              "      <td>Onyx Black</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>GMC</td>\n",
              "      <td>45.3 in</td>\n",
              "      <td>26 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>True</td>\n",
              "      <td>73.9 in</td>\n",
              "      <td>22.0</td>\n",
              "      <td>355.0</td>\n",
              "      <td>jet black</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>45.6560</td>\n",
              "      <td>229.5 in</td>\n",
              "      <td>8/1/2020</td>\n",
              "      <td>BLACK</td>\n",
              "      <td>278142195</td>\n",
              "      <td>-89.3844</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Value Package', 'Navigation System', 'Alloy ...</td>\n",
              "      <td>GMC</td>\n",
              "      <td>6 seats</td>\n",
              "      <td>82195</td>\n",
              "      <td>Sierra 1500</td>\n",
              "      <td>1.0</td>\n",
              "      <td>355 hp @ 5,600 RPM</td>\n",
              "      <td>27990.0</td>\n",
              "      <td>False</td>\n",
              "      <td>334</td>\n",
              "      <td>4.500000</td>\n",
              "      <td>53243</td>\n",
              "      <td>Rhinelander GM Auto Center</td>\n",
              "      <td>False</td>\n",
              "      <td>383 lb-ft @ 4,100 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>6-Speed Automatic Overdrive</td>\n",
              "      <td>t67850</td>\n",
              "      <td>SLE Double Cab 4WD</td>\n",
              "      <td>None</td>\n",
              "      <td>4WD</td>\n",
              "      <td>Four-Wheel Drive</td>\n",
              "      <td>143.5 in</td>\n",
              "      <td>80 in</td>\n",
              "      <td>2017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>38.5 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>Englewood</td>\n",
              "      <td>20.0</td>\n",
              "      <td>None</td>\n",
              "      <td>254</td>\n",
              "      <td>34223</td>\n",
              "      <td>I4</td>\n",
              "      <td>2400.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>SILVER</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>41.3 in</td>\n",
              "      <td>15.3 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>False</td>\n",
              "      <td>66.1 in</td>\n",
              "      <td>27.0</td>\n",
              "      <td>166.0</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>26.9679</td>\n",
              "      <td>177.9 in</td>\n",
              "      <td>1/1/2020</td>\n",
              "      <td>SILVER</td>\n",
              "      <td>261940689</td>\n",
              "      <td>-82.3530</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Leather Seats', 'Sunroof/Moonroof', 'Alloy W...</td>\n",
              "      <td>Honda</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>70308</td>\n",
              "      <td>CR-V</td>\n",
              "      <td>4.0</td>\n",
              "      <td>166 hp @ 5,800 RPM</td>\n",
              "      <td>9490.0</td>\n",
              "      <td>False</td>\n",
              "      <td>1102</td>\n",
              "      <td>4.857143</td>\n",
              "      <td>387529</td>\n",
              "      <td>Carma Motors</td>\n",
              "      <td>False</td>\n",
              "      <td>161 lb-ft @ 4,200 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>Automatic</td>\n",
              "      <td>t27128</td>\n",
              "      <td>EX-L FWD</td>\n",
              "      <td>None</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>103.1 in</td>\n",
              "      <td>71.6 in</td>\n",
              "      <td>2007</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>35.2 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Sedan</td>\n",
              "      <td>None</td>\n",
              "      <td>Gainesville</td>\n",
              "      <td>28.0</td>\n",
              "      <td>None</td>\n",
              "      <td>32</td>\n",
              "      <td>30504</td>\n",
              "      <td>I4</td>\n",
              "      <td>2500.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>Super Black</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Nissan</td>\n",
              "      <td>43.8 in</td>\n",
              "      <td>16.2 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>56.7 in</td>\n",
              "      <td>39.0</td>\n",
              "      <td>188.0</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>34.2758</td>\n",
              "      <td>192.9 in</td>\n",
              "      <td>8/9/2020</td>\n",
              "      <td>BLACK</td>\n",
              "      <td>278839418</td>\n",
              "      <td>-83.8584</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Steel Wheels', 'Backup Camera', 'Remote Start']</td>\n",
              "      <td>Nissan</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>1</td>\n",
              "      <td>Altima</td>\n",
              "      <td>NaN</td>\n",
              "      <td>188 hp @ 6,000 RPM</td>\n",
              "      <td>21176.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>4.111111</td>\n",
              "      <td>65153</td>\n",
              "      <td>Carriage Nissan</td>\n",
              "      <td>None</td>\n",
              "      <td>180 lb-ft @ 3,600 RPM</td>\n",
              "      <td>CVT</td>\n",
              "      <td>Continuously Variable Transmission</td>\n",
              "      <td>t87015</td>\n",
              "      <td>2.5 S FWD</td>\n",
              "      <td>None</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>111.2 in</td>\n",
              "      <td>72.9 in</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>38.3 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Sedan</td>\n",
              "      <td>None</td>\n",
              "      <td>Maple Heights</td>\n",
              "      <td>23.0</td>\n",
              "      <td>None</td>\n",
              "      <td>8</td>\n",
              "      <td>44137</td>\n",
              "      <td>I4</td>\n",
              "      <td>2500.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>Oxford White</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Ford</td>\n",
              "      <td>44.3 in</td>\n",
              "      <td>16.5 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>58.1 in</td>\n",
              "      <td>34.0</td>\n",
              "      <td>175.0</td>\n",
              "      <td>White (Light Putty)</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>41.4126</td>\n",
              "      <td>191.7 in</td>\n",
              "      <td>9/2/2020</td>\n",
              "      <td>WHITE</td>\n",
              "      <td>280926627</td>\n",
              "      <td>-81.5374</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Backup Camera', 'Parking Sensors', 'Android ...</td>\n",
              "      <td>Ford</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>6</td>\n",
              "      <td>Fusion</td>\n",
              "      <td>NaN</td>\n",
              "      <td>181 hp @ 6,000 RPM</td>\n",
              "      <td>25534.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>4.095238</td>\n",
              "      <td>57323</td>\n",
              "      <td>Liberty Ford Of Maple Heights</td>\n",
              "      <td>None</td>\n",
              "      <td>185 lb-ft @ 4,320 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>6-Speed Automatic</td>\n",
              "      <td>t86414</td>\n",
              "      <td>SE FWD</td>\n",
              "      <td>None</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>112.2 in</td>\n",
              "      <td>83.5 in</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>35.2 in</td>\n",
              "      <td>None</td>\n",
              "      <td>--</td>\n",
              "      <td>79.4 in</td>\n",
              "      <td>Pickup Truck</td>\n",
              "      <td>None</td>\n",
              "      <td>Stow</td>\n",
              "      <td>16.0</td>\n",
              "      <td>None</td>\n",
              "      <td>57</td>\n",
              "      <td>44224</td>\n",
              "      <td>V8</td>\n",
              "      <td>5300.0</td>\n",
              "      <td>V8</td>\n",
              "      <td>Satin Steel Metallic</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Chevrolet</td>\n",
              "      <td>44.5 in</td>\n",
              "      <td>24 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>75.6 in</td>\n",
              "      <td>22.0</td>\n",
              "      <td>355.0</td>\n",
              "      <td>Black</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>41.1584</td>\n",
              "      <td>231.7 in</td>\n",
              "      <td>7/15/2020</td>\n",
              "      <td>UNKNOWN</td>\n",
              "      <td>276526768</td>\n",
              "      <td>-81.4400</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Bluetooth', 'Backup Camera', 'Off Road Packa...</td>\n",
              "      <td>Chevrolet</td>\n",
              "      <td>6 seats</td>\n",
              "      <td>2</td>\n",
              "      <td>Silverado 1500</td>\n",
              "      <td>NaN</td>\n",
              "      <td>355 hp @ 5,600 RPM</td>\n",
              "      <td>41650.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>4.492308</td>\n",
              "      <td>276599</td>\n",
              "      <td>Ron Marhofer Chevrolet</td>\n",
              "      <td>None</td>\n",
              "      <td>383 lb-ft @ 4,100 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>8-Speed Automatic</td>\n",
              "      <td>t86498</td>\n",
              "      <td>LT Double Cab 4WD</td>\n",
              "      <td>None</td>\n",
              "      <td>4WD</td>\n",
              "      <td>Four-Wheel Drive</td>\n",
              "      <td>147.5 in</td>\n",
              "      <td>81.2 in</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>40.9 in</td>\n",
              "      <td>None</td>\n",
              "      <td>--</td>\n",
              "      <td>69.3 in</td>\n",
              "      <td>Pickup Truck</td>\n",
              "      <td>Crew Cab</td>\n",
              "      <td>Jasper</td>\n",
              "      <td>16.0</td>\n",
              "      <td>None</td>\n",
              "      <td>12</td>\n",
              "      <td>35501</td>\n",
              "      <td>V8 Flex Fuel Vehicle</td>\n",
              "      <td>5300.0</td>\n",
              "      <td>V8 Flex Fuel Vehicle</td>\n",
              "      <td>Red</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>45.3 in</td>\n",
              "      <td>26 gal</td>\n",
              "      <td>Flex Fuel Vehicle</td>\n",
              "      <td>True</td>\n",
              "      <td>74 in</td>\n",
              "      <td>22.0</td>\n",
              "      <td>355.0</td>\n",
              "      <td>jet black</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>33.8117</td>\n",
              "      <td>230 in</td>\n",
              "      <td>8/30/2020</td>\n",
              "      <td>RED</td>\n",
              "      <td>280770371</td>\n",
              "      <td>-87.2835</td>\n",
              "      <td>None</td>\n",
              "      <td>['Leather Seats', 'Navigation System', 'Appear...</td>\n",
              "      <td>Chevrolet</td>\n",
              "      <td>6 seats</td>\n",
              "      <td>91153</td>\n",
              "      <td>Silverado 1500</td>\n",
              "      <td>1.0</td>\n",
              "      <td>None</td>\n",
              "      <td>34900.0</td>\n",
              "      <td>False</td>\n",
              "      <td>4291</td>\n",
              "      <td>4.500000</td>\n",
              "      <td>311646</td>\n",
              "      <td>Jasper Auto Sales Select</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>A</td>\n",
              "      <td>Automatic</td>\n",
              "      <td>t52320</td>\n",
              "      <td>LTZ Crew Cab 4WD</td>\n",
              "      <td>None</td>\n",
              "      <td>4WD</td>\n",
              "      <td>Four-Wheel Drive</td>\n",
              "      <td>143.5 in</td>\n",
              "      <td>80 in</td>\n",
              "      <td>2014</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>37.4 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Sedan</td>\n",
              "      <td>None</td>\n",
              "      <td>Charlotte</td>\n",
              "      <td>32.0</td>\n",
              "      <td>None</td>\n",
              "      <td>16</td>\n",
              "      <td>28269</td>\n",
              "      <td>I4</td>\n",
              "      <td>1500.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>Black</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>42.3 in</td>\n",
              "      <td>12.4 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>False</td>\n",
              "      <td>55.7 in</td>\n",
              "      <td>42.0</td>\n",
              "      <td>174.0</td>\n",
              "      <td>Black</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>35.3393</td>\n",
              "      <td>182.3 in</td>\n",
              "      <td>8/25/2020</td>\n",
              "      <td>BLACK</td>\n",
              "      <td>280195366</td>\n",
              "      <td>-80.8437</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Leather Seats', 'Sunroof/Moonroof', 'Alloy W...</td>\n",
              "      <td>Honda</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>25012</td>\n",
              "      <td>Civic</td>\n",
              "      <td>1.0</td>\n",
              "      <td>174 hp @ 6,000 RPM</td>\n",
              "      <td>20590.0</td>\n",
              "      <td>False</td>\n",
              "      <td>867</td>\n",
              "      <td>3.833333</td>\n",
              "      <td>405279</td>\n",
              "      <td>Carvana</td>\n",
              "      <td>False</td>\n",
              "      <td>162 lb-ft @ 1,700 RPM</td>\n",
              "      <td>CVT</td>\n",
              "      <td>Continuously Variable Transmission</td>\n",
              "      <td>t69376</td>\n",
              "      <td>EX-L with Navigation</td>\n",
              "      <td>None</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>106.3 in</td>\n",
              "      <td>70.8 in</td>\n",
              "      <td>2017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>36.8 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Sedan</td>\n",
              "      <td>None</td>\n",
              "      <td>Killeen</td>\n",
              "      <td>24.0</td>\n",
              "      <td>None</td>\n",
              "      <td>25</td>\n",
              "      <td>76543</td>\n",
              "      <td>I4</td>\n",
              "      <td>2500.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>Butte Red Metallic</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>Kia</td>\n",
              "      <td>42.1 in</td>\n",
              "      <td>18.5 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>True</td>\n",
              "      <td>57.6 in</td>\n",
              "      <td>34.0</td>\n",
              "      <td>197.0</td>\n",
              "      <td>jet black</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>31.0768</td>\n",
              "      <td>191.5 in</td>\n",
              "      <td>8/17/2020</td>\n",
              "      <td>RED</td>\n",
              "      <td>279541570</td>\n",
              "      <td>-97.6920</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Leather Seats', 'Navigation System', 'Alloy ...</td>\n",
              "      <td>Chevrolet</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>44783</td>\n",
              "      <td>Malibu</td>\n",
              "      <td>2.0</td>\n",
              "      <td>None</td>\n",
              "      <td>14997.0</td>\n",
              "      <td>False</td>\n",
              "      <td>108</td>\n",
              "      <td>4.153846</td>\n",
              "      <td>302088</td>\n",
              "      <td>Dennis Eakin Kia</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>A</td>\n",
              "      <td>6-Speed Automatic Overdrive</td>\n",
              "      <td>t69690</td>\n",
              "      <td>Limited LTZ FWD</td>\n",
              "      <td>None</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>107.8 in</td>\n",
              "      <td>79.8 in</td>\n",
              "      <td>2016</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>Nicholasville</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>16</td>\n",
              "      <td>40356</td>\n",
              "      <td>V6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>V6</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>Kia</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>37.9286</td>\n",
              "      <td>None</td>\n",
              "      <td>8/26/2020</td>\n",
              "      <td>UNKNOWN</td>\n",
              "      <td>280291621</td>\n",
              "      <td>-84.5497</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Bluetooth', 'Backup Camera']</td>\n",
              "      <td>Toyota</td>\n",
              "      <td>None</td>\n",
              "      <td>41681</td>\n",
              "      <td>4Runner</td>\n",
              "      <td>1.0</td>\n",
              "      <td>None</td>\n",
              "      <td>35988.0</td>\n",
              "      <td>False</td>\n",
              "      <td>1641</td>\n",
              "      <td>3.500000</td>\n",
              "      <td>67547</td>\n",
              "      <td>Car Town Kia USA - Nicholasville</td>\n",
              "      <td>False</td>\n",
              "      <td>None</td>\n",
              "      <td>A</td>\n",
              "      <td>5-Speed Automatic Overdrive</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>2017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>43.6 in</td>\n",
              "      <td>None</td>\n",
              "      <td>--</td>\n",
              "      <td>67.1 in</td>\n",
              "      <td>Pickup Truck</td>\n",
              "      <td>None</td>\n",
              "      <td>Crosby</td>\n",
              "      <td>16.0</td>\n",
              "      <td>None</td>\n",
              "      <td>225</td>\n",
              "      <td>77532</td>\n",
              "      <td>V6</td>\n",
              "      <td>3500.0</td>\n",
              "      <td>V6</td>\n",
              "      <td>Rapid Red</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Ford</td>\n",
              "      <td>43.9 in</td>\n",
              "      <td>26 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>77.2 in</td>\n",
              "      <td>22.0</td>\n",
              "      <td>375.0</td>\n",
              "      <td>Black</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>29.8911</td>\n",
              "      <td>231.9 in</td>\n",
              "      <td>1/30/2020</td>\n",
              "      <td>RED</td>\n",
              "      <td>264507843</td>\n",
              "      <td>-95.0602</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['LE Package', 'Leather Seats', 'Appearance Pa...</td>\n",
              "      <td>Ford</td>\n",
              "      <td>6 seats</td>\n",
              "      <td>0</td>\n",
              "      <td>F-150</td>\n",
              "      <td>NaN</td>\n",
              "      <td>395 hp @ 5,750 RPM</td>\n",
              "      <td>53932.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>3.800000</td>\n",
              "      <td>58045</td>\n",
              "      <td>Friendly Ford of Crosby LP</td>\n",
              "      <td>None</td>\n",
              "      <td>400 lb-ft @ 4,500 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>Automatic</td>\n",
              "      <td>t87721</td>\n",
              "      <td>Lariat SuperCrew 4WD</td>\n",
              "      <td>None</td>\n",
              "      <td>4WD</td>\n",
              "      <td>Four-Wheel Drive</td>\n",
              "      <td>145 in</td>\n",
              "      <td>96.8 in</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>--</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>Walnut Creek</td>\n",
              "      <td>19.0</td>\n",
              "      <td>None</td>\n",
              "      <td>48</td>\n",
              "      <td>94597</td>\n",
              "      <td>V6</td>\n",
              "      <td>3000.0</td>\n",
              "      <td>V6</td>\n",
              "      <td>Black</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Porsche</td>\n",
              "      <td>--</td>\n",
              "      <td>23.7 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>66.8 in</td>\n",
              "      <td>23.0</td>\n",
              "      <td>335.0</td>\n",
              "      <td>Black</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>37.9186</td>\n",
              "      <td>193.7 in</td>\n",
              "      <td>7/26/2020</td>\n",
              "      <td>BLACK</td>\n",
              "      <td>277629018</td>\n",
              "      <td>-122.0650</td>\n",
              "      <td>None</td>\n",
              "      <td>['Leather Seats', 'Navigation System', 'Blueto...</td>\n",
              "      <td>Porsche</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>0</td>\n",
              "      <td>Cayenne</td>\n",
              "      <td>NaN</td>\n",
              "      <td>335 hp @ 5,300 RPM</td>\n",
              "      <td>78830.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>66413</td>\n",
              "      <td>Porsche Walnut Creek</td>\n",
              "      <td>None</td>\n",
              "      <td>332 lb-ft @ 1,340 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>8-Speed Automatic</td>\n",
              "      <td>t87632</td>\n",
              "      <td>SUV AWD</td>\n",
              "      <td>None</td>\n",
              "      <td>AWD</td>\n",
              "      <td>All-Wheel Drive</td>\n",
              "      <td>114 in</td>\n",
              "      <td>86.4 in</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>34.8 in</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Sedan</td>\n",
              "      <td>None</td>\n",
              "      <td>Greer</td>\n",
              "      <td>30.0</td>\n",
              "      <td>None</td>\n",
              "      <td>12</td>\n",
              "      <td>29651</td>\n",
              "      <td>I4</td>\n",
              "      <td>1800.0</td>\n",
              "      <td>I4</td>\n",
              "      <td>CELESTITE GRAY</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>Toyota</td>\n",
              "      <td>42 in</td>\n",
              "      <td>13.2 gal</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>56.5 in</td>\n",
              "      <td>38.0</td>\n",
              "      <td>139.0</td>\n",
              "      <td>LT GRAY</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>34.9528</td>\n",
              "      <td>182.3 in</td>\n",
              "      <td>8/29/2020</td>\n",
              "      <td>GRAY</td>\n",
              "      <td>280710935</td>\n",
              "      <td>-82.1802</td>\n",
              "      <td>https://static.cargurus.com/images/forsale/202...</td>\n",
              "      <td>['Adaptive Cruise Control', 'Backup Camera']</td>\n",
              "      <td>Toyota</td>\n",
              "      <td>5 seats</td>\n",
              "      <td>10</td>\n",
              "      <td>Corolla</td>\n",
              "      <td>NaN</td>\n",
              "      <td>None</td>\n",
              "      <td>22547.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>3.058824</td>\n",
              "      <td>281628</td>\n",
              "      <td>Toyota of Greer</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>CVT</td>\n",
              "      <td>Continuously Variable Transmission</td>\n",
              "      <td>t92966</td>\n",
              "      <td>LE FWD</td>\n",
              "      <td>None</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>106.3 in</td>\n",
              "      <td>70.1 in</td>\n",
              "      <td>2021</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>45.2 in</td>\n",
              "      <td>None</td>\n",
              "      <td>--</td>\n",
              "      <td>67.4 in</td>\n",
              "      <td>Pickup Truck</td>\n",
              "      <td>None</td>\n",
              "      <td>North Olmsted</td>\n",
              "      <td>19.0</td>\n",
              "      <td>None</td>\n",
              "      <td>204</td>\n",
              "      <td>44070</td>\n",
              "      <td>V6 Flex Fuel Vehicle</td>\n",
              "      <td>3600.0</td>\n",
              "      <td>V6 Flex Fuel Vehicle</td>\n",
              "      <td>Maximum Steel Metallic Clearcoat</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>RAM</td>\n",
              "      <td>40.9 in</td>\n",
              "      <td>26 gal</td>\n",
              "      <td>Flex Fuel Vehicle</td>\n",
              "      <td>None</td>\n",
              "      <td>77.6 in</td>\n",
              "      <td>24.0</td>\n",
              "      <td>305.0</td>\n",
              "      <td>Diesel Gray/Black</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>41.4140</td>\n",
              "      <td>232.9 in</td>\n",
              "      <td>2/19/2020</td>\n",
              "      <td>UNKNOWN</td>\n",
              "      <td>266129936</td>\n",
              "      <td>-81.9266</td>\n",
              "      <td>None</td>\n",
              "      <td>['Alloy Wheels', 'Backup Camera', 'Remote Star...</td>\n",
              "      <td>RAM</td>\n",
              "      <td>6 seats</td>\n",
              "      <td>11</td>\n",
              "      <td>1500</td>\n",
              "      <td>NaN</td>\n",
              "      <td>395 hp @ 5,600 RPM</td>\n",
              "      <td>40495.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>4.343750</td>\n",
              "      <td>62592</td>\n",
              "      <td>North Olmsted Chrysler Jeep Dodge Ram</td>\n",
              "      <td>None</td>\n",
              "      <td>410 lb-ft @ 3,950 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>8-Speed Automatic</td>\n",
              "      <td>t87071</td>\n",
              "      <td>Lone Star Crew Cab 4WD</td>\n",
              "      <td>None</td>\n",
              "      <td>4WD</td>\n",
              "      <td>Four-Wheel Drive</td>\n",
              "      <td>144.6 in</td>\n",
              "      <td>82.1 in</td>\n",
              "      <td>2020</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   back_legroom   bed bed_height  ... wheelbase    width  year\n",
              "0       35.1 in  None       None  ...  101.2 in  79.6 in  2019\n",
              "1       38.1 in  None       None  ...  107.9 in  85.6 in  2020\n",
              "2       33.4 in  None       None  ...  104.2 in  72.3 in  2020\n",
              "3            --  None       None  ...   92.5 in  71.2 in  2008\n",
              "4       33.7 in  None       None  ...  110.6 in  79.4 in  2014\n",
              "5          None  None       None  ...      None     None  2020\n",
              "6       40.6 in  None       None  ...  112.2 in  85.8 in  2018\n",
              "7       37.1 in  None       None  ...  113.1 in  84.4 in  2020\n",
              "8       35.7 in  None       None  ...  106.3 in  70.9 in  2020\n",
              "9       36.7 in  None       None  ...   99.2 in    81 in  2020\n",
              "10      36.8 in  None       None  ...  110.6 in  82.6 in  2014\n",
              "11         None  None       None  ...      None     None  2020\n",
              "12      34.6 in  None         --  ...  143.5 in    80 in  2017\n",
              "13      38.5 in  None       None  ...  103.1 in  71.6 in  2007\n",
              "14      35.2 in  None       None  ...  111.2 in  72.9 in  2020\n",
              "15      38.3 in  None       None  ...  112.2 in  83.5 in  2020\n",
              "16      35.2 in  None         --  ...  147.5 in  81.2 in  2020\n",
              "17      40.9 in  None         --  ...  143.5 in    80 in  2014\n",
              "18      37.4 in  None       None  ...  106.3 in  70.8 in  2017\n",
              "19      36.8 in  None       None  ...  107.8 in  79.8 in  2016\n",
              "20         None  None       None  ...      None     None  2017\n",
              "21      43.6 in  None         --  ...    145 in  96.8 in  2020\n",
              "22           --  None       None  ...    114 in  86.4 in  2020\n",
              "23      34.8 in  None       None  ...  106.3 in  70.1 in  2021\n",
              "24      45.2 in  None         --  ...  144.6 in  82.1 in  2020\n",
              "\n",
              "[25 rows x 64 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kOkD6tF2ekcI",
        "outputId": "da88adcd-920d-40bc-c512-bf8af6282276",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 51
        }
      },
      "source": [
        "# EDA: Dimension Inspection\n",
        "from pyspark.sql import functions as fn # import functions\n",
        "print(\"Number of Observations:\",sampled_df.count())\n",
        "print(\"Number of Columns:\",len(sampled_df.columns))"
      ],
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Number of Observations: 600000\n",
            "Number of Columns: 64\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fdrlvz0nB-Ha"
      },
      "source": [
        "# Drop the index column\n",
        "sampled_df = sampled_df.drop(*['power','main_picture_url',\n",
        "                               'combine_fuel_economy', 'listing_id',\n",
        "                               'vehicle_damage_category','trimId',\n",
        "                               'trim_name','exterior_color'])"
      ],
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VXuOeElFCe_v",
        "outputId": "843508ee-1a33-4df1-a6d2-3c83cb35ce6d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 51
        }
      },
      "source": [
        "# Inspect the drop\n",
        "print(\"Number of Observations:\",sampled_df.count())\n",
        "print(\"Number of Columns:\",len(sampled_df.columns))"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Number of Observations: 600000\n",
            "Number of Columns: 56\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KnaZelRZO7af",
        "outputId": "7e21fdce-f231-4f15-c31f-e340b2c0d741",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "# EDA: Data Type Inspection\n",
        "sampled_df.printSchema()"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "root\n",
            " |-- back_legroom: string (nullable = true)\n",
            " |-- bed: string (nullable = true)\n",
            " |-- bed_height: string (nullable = true)\n",
            " |-- bed_length: string (nullable = true)\n",
            " |-- body_type: string (nullable = true)\n",
            " |-- cabin: string (nullable = true)\n",
            " |-- city: string (nullable = true)\n",
            " |-- city_fuel_economy: integer (nullable = true)\n",
            " |-- daysonmarket: integer (nullable = true)\n",
            " |-- dealer_zip: string (nullable = true)\n",
            " |-- engine_cylinders: string (nullable = true)\n",
            " |-- engine_displacement: integer (nullable = true)\n",
            " |-- engine_type: string (nullable = true)\n",
            " |-- fleet: boolean (nullable = true)\n",
            " |-- frame_damaged: boolean (nullable = true)\n",
            " |-- franchise_dealer: boolean (nullable = true)\n",
            " |-- franchise_make: string (nullable = true)\n",
            " |-- front_legroom: string (nullable = true)\n",
            " |-- fuel_tank_volume: string (nullable = true)\n",
            " |-- fuel_type: string (nullable = true)\n",
            " |-- has_accidents: boolean (nullable = true)\n",
            " |-- height: string (nullable = true)\n",
            " |-- highway_fuel_economy: integer (nullable = true)\n",
            " |-- horsepower: integer (nullable = true)\n",
            " |-- interior_color: string (nullable = true)\n",
            " |-- isCab: boolean (nullable = true)\n",
            " |-- is_certified: string (nullable = true)\n",
            " |-- is_cpo: boolean (nullable = true)\n",
            " |-- is_new: boolean (nullable = true)\n",
            " |-- is_oemcpo: boolean (nullable = true)\n",
            " |-- latitude: double (nullable = true)\n",
            " |-- length: string (nullable = true)\n",
            " |-- listed_date: string (nullable = true)\n",
            " |-- listing_color: string (nullable = true)\n",
            " |-- longitude: double (nullable = true)\n",
            " |-- major_options: string (nullable = true)\n",
            " |-- make_name: string (nullable = true)\n",
            " |-- maximum_seating: string (nullable = true)\n",
            " |-- mileage: integer (nullable = true)\n",
            " |-- model_name: string (nullable = true)\n",
            " |-- owner_count: integer (nullable = true)\n",
            " |-- price: double (nullable = true)\n",
            " |-- salvage: boolean (nullable = true)\n",
            " |-- savings_amount: integer (nullable = true)\n",
            " |-- seller_rating: double (nullable = true)\n",
            " |-- sp_id: integer (nullable = true)\n",
            " |-- sp_name: string (nullable = true)\n",
            " |-- theft_title: boolean (nullable = true)\n",
            " |-- torque: string (nullable = true)\n",
            " |-- transmission: string (nullable = true)\n",
            " |-- transmission_display: string (nullable = true)\n",
            " |-- wheel_system: string (nullable = true)\n",
            " |-- wheel_system_display: string (nullable = true)\n",
            " |-- wheelbase: string (nullable = true)\n",
            " |-- width: string (nullable = true)\n",
            " |-- year: integer (nullable = true)\n",
            "\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YZWuRiE0-frV"
      },
      "source": [
        "# EDA: Duplicate Data Removal\n",
        "sampled_df = sampled_df.distinct()"
      ],
      "execution_count": 10,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ETdAoCtd-3CO"
      },
      "source": [
        "# Generate of list of column names for future use\n",
        "colList = sampled_df.columns\n",
        "numColList = []\n",
        "catColList = []"
      ],
      "execution_count": 11,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6_KuR2EHF0sn"
      },
      "source": [
        "import re\n",
        "from pyspark.sql.functions import col, regexp_replace, split\n",
        "\n",
        "sampled_df = sampled_df.withColumn('back_legroom',\n",
        "                                   regexp_replace(col('back_legroom'),r'\\sin',''))\n",
        "sampled_df = sampled_df.withColumn('front_legroom',\n",
        "                                   regexp_replace(col('front_legroom'),r'\\sin',''))\n",
        "sampled_df = sampled_df.withColumn('height',\n",
        "                                   regexp_replace(col('height'),r'\\sin',''))\n",
        "sampled_df = sampled_df.withColumn('length',\n",
        "                                   regexp_replace(col('length'),r'\\sin',''))\n",
        "sampled_df = sampled_df.withColumn('wheelbase',\n",
        "                                   regexp_replace(col('wheelbase'),r'\\sin',''))\n",
        "sampled_df = sampled_df.withColumn('width',\n",
        "                                   regexp_replace(col('width'),r'\\sin',''))\n",
        "sampled_df = sampled_df.withColumn('bed_height',\n",
        "                                   regexp_replace(col('bed_height'),r'\\sin',''))\n",
        "sampled_df = sampled_df.withColumn('bed_length',\n",
        "                                   regexp_replace(col('bed_length'),r'\\sin',''))\n",
        "sampled_df = sampled_df.withColumn('engine_cylinders',\n",
        "                                   regexp_replace(col('engine_cylinders'),r'[a-zA-Z]',''))\n",
        "sampled_df = sampled_df.withColumn('engine_type',\n",
        "                                   regexp_replace(col('engine_type'),r'\\d',''))\n",
        "sampled_df = sampled_df.withColumn('maximum_seating',\n",
        "                                   regexp_replace(col('maximum_seating'),r'\\sseats',''))\n",
        "sampled_df = sampled_df.withColumn('fuel_tank_volume',\n",
        "                                   regexp_replace(col('fuel_tank_volume'),r'\\sgal',''))\n",
        "sampled_df = sampled_df.withColumn('major_options',\n",
        "                                   regexp_replace(col('major_options'),r\"[\\[]'\",''))\n",
        "sampled_df = sampled_df.withColumn('major_options',\n",
        "                                   regexp_replace(col('major_options'),r\"'[\\]]\",''))\n",
        "sampled_df = sampled_df.withColumn('major_options',\n",
        "                                   regexp_replace(col('major_options'),r\"'\",''))\n",
        "\n",
        "split_torque = split(sampled_df['torque'],r'\\slb-ft\\s@')\n",
        "sampled_df = sampled_df.withColumn('torque_ftlb',split_torque.getItem(0))\n",
        "sampled_df = sampled_df.withColumn('torque_rpm',split_torque.getItem(1))\n",
        "\n",
        "sampled_df = sampled_df.withColumn('torque_rpm',\n",
        "                                   regexp_replace(col('torque_rpm'),r'\\sRPM',''))\n",
        "\n",
        "from pyspark.sql.types import IntegerType, DateType\n",
        "sampled_df = sampled_df.withColumn('back_legroom',\n",
        "                                   sampled_df['back_legroom'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('bed_height',\n",
        "                                   sampled_df['bed_height'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('bed_length',\n",
        "                                   sampled_df['bed_length'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('engine_cylinders',\n",
        "                                   sampled_df['engine_cylinders'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('front_legroom',\n",
        "                                   sampled_df['front_legroom'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('fuel_tank_volume',\n",
        "                                   sampled_df['fuel_tank_volume'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('height',\n",
        "                                   sampled_df['height'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('length',\n",
        "                                   sampled_df['length'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('listed_date',\n",
        "                                   sampled_df['listed_date'].cast(DateType()))\n",
        "sampled_df = sampled_df.withColumn('maximum_seating',\n",
        "                                   sampled_df['maximum_seating'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('wheelbase',\n",
        "                                   sampled_df['wheelbase'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('width',\n",
        "                                   sampled_df['width'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('torque_ftlb',\n",
        "                                   sampled_df['torque_ftlb'].cast(IntegerType()))\n",
        "sampled_df = sampled_df.withColumn('torque_rpm',\n",
        "                                   sampled_df['torque_rpm'].cast(IntegerType()))"
      ],
      "execution_count": 12,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7s8AQOejqzUb"
      },
      "source": [
        "sampled_df = sampled_df.withColumn('torque_grade',\n",
        "                                   sampled_df.torque_ftlb/sampled_df.torque_rpm)\n",
        "sampled_df = sampled_df.withColumn('torque_grade',\n",
        "                                   sampled_df['torque_grade'].cast(IntegerType()))"
      ],
      "execution_count": 13,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "93B8_6SdDUMj"
      },
      "source": [
        "for x in sampled_df.columns:\n",
        "  sampled_df = sampled_df.withColumn(x, regexp_replace(col(x),r'--',''))\n",
        "  sampled_df = sampled_df.withColumn(x, regexp_replace(col(x),r'None',''))"
      ],
      "execution_count": 14,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Gu_VbCLHqOed",
        "outputId": "8eb7ca90-9f44-4e41-8487-29fc09867b32",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 496
        }
      },
      "source": [
        "sampled_df.limit(5).toPandas()"
      ],
      "execution_count": 15,
      "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>back_legroom</th>\n",
              "      <th>bed</th>\n",
              "      <th>bed_height</th>\n",
              "      <th>bed_length</th>\n",
              "      <th>body_type</th>\n",
              "      <th>cabin</th>\n",
              "      <th>city</th>\n",
              "      <th>city_fuel_economy</th>\n",
              "      <th>daysonmarket</th>\n",
              "      <th>dealer_zip</th>\n",
              "      <th>engine_cylinders</th>\n",
              "      <th>engine_displacement</th>\n",
              "      <th>engine_type</th>\n",
              "      <th>fleet</th>\n",
              "      <th>frame_damaged</th>\n",
              "      <th>franchise_dealer</th>\n",
              "      <th>franchise_make</th>\n",
              "      <th>front_legroom</th>\n",
              "      <th>fuel_tank_volume</th>\n",
              "      <th>fuel_type</th>\n",
              "      <th>has_accidents</th>\n",
              "      <th>height</th>\n",
              "      <th>highway_fuel_economy</th>\n",
              "      <th>horsepower</th>\n",
              "      <th>interior_color</th>\n",
              "      <th>isCab</th>\n",
              "      <th>is_certified</th>\n",
              "      <th>is_cpo</th>\n",
              "      <th>is_new</th>\n",
              "      <th>is_oemcpo</th>\n",
              "      <th>latitude</th>\n",
              "      <th>length</th>\n",
              "      <th>listed_date</th>\n",
              "      <th>listing_color</th>\n",
              "      <th>longitude</th>\n",
              "      <th>major_options</th>\n",
              "      <th>make_name</th>\n",
              "      <th>maximum_seating</th>\n",
              "      <th>mileage</th>\n",
              "      <th>model_name</th>\n",
              "      <th>owner_count</th>\n",
              "      <th>price</th>\n",
              "      <th>salvage</th>\n",
              "      <th>savings_amount</th>\n",
              "      <th>seller_rating</th>\n",
              "      <th>sp_id</th>\n",
              "      <th>sp_name</th>\n",
              "      <th>theft_title</th>\n",
              "      <th>torque</th>\n",
              "      <th>transmission</th>\n",
              "      <th>transmission_display</th>\n",
              "      <th>wheel_system</th>\n",
              "      <th>wheel_system_display</th>\n",
              "      <th>wheelbase</th>\n",
              "      <th>width</th>\n",
              "      <th>year</th>\n",
              "      <th>torque_ftlb</th>\n",
              "      <th>torque_rpm</th>\n",
              "      <th>torque_grade</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>34</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>Valencia</td>\n",
              "      <td>27</td>\n",
              "      <td>163</td>\n",
              "      <td>91355</td>\n",
              "      <td>4</td>\n",
              "      <td>2000</td>\n",
              "      <td>I</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>true</td>\n",
              "      <td>Buick</td>\n",
              "      <td>41</td>\n",
              "      <td>13</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>61</td>\n",
              "      <td>33</td>\n",
              "      <td>147</td>\n",
              "      <td>Black</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>true</td>\n",
              "      <td>None</td>\n",
              "      <td>34.4193</td>\n",
              "      <td>164</td>\n",
              "      <td>None</td>\n",
              "      <td>GRAY</td>\n",
              "      <td>-118.556</td>\n",
              "      <td>Alloy Wheels, Backup Camera, Heated Seats</td>\n",
              "      <td>Hyundai</td>\n",
              "      <td>5</td>\n",
              "      <td>8</td>\n",
              "      <td>Kona</td>\n",
              "      <td>None</td>\n",
              "      <td>22912.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>4.142857143</td>\n",
              "      <td>303474</td>\n",
              "      <td>Parkway Cadillac Buick GMC</td>\n",
              "      <td>None</td>\n",
              "      <td>132 lb-ft @ 4,500 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>6-Speed Automatic</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>102</td>\n",
              "      <td>70</td>\n",
              "      <td>2020</td>\n",
              "      <td>132</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Van</td>\n",
              "      <td>None</td>\n",
              "      <td>Ann Arbor</td>\n",
              "      <td>None</td>\n",
              "      <td>2</td>\n",
              "      <td>48103</td>\n",
              "      <td>6</td>\n",
              "      <td>3500</td>\n",
              "      <td>V Flex Fuel Vehicle</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>true</td>\n",
              "      <td>Ford</td>\n",
              "      <td>41</td>\n",
              "      <td>25</td>\n",
              "      <td>Flex Fuel Vehicle</td>\n",
              "      <td>None</td>\n",
              "      <td>82</td>\n",
              "      <td>None</td>\n",
              "      <td>275</td>\n",
              "      <td>Gray (Dark Palazzo Grey)</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>true</td>\n",
              "      <td>None</td>\n",
              "      <td>42.2852</td>\n",
              "      <td>219</td>\n",
              "      <td>None</td>\n",
              "      <td>WHITE</td>\n",
              "      <td>-83.7983</td>\n",
              "      <td>Bluetooth, Backup Camera</td>\n",
              "      <td>Ford</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>Transit Cargo</td>\n",
              "      <td>None</td>\n",
              "      <td>33200.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>4.277777778</td>\n",
              "      <td>334275</td>\n",
              "      <td>Varsity Ford</td>\n",
              "      <td>None</td>\n",
              "      <td>400 lb-ft @ 2,500 RPM</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>RWD</td>\n",
              "      <td>Rear-Wheel Drive</td>\n",
              "      <td>129</td>\n",
              "      <td>97</td>\n",
              "      <td>2020</td>\n",
              "      <td>400</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>39</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>Lawrenceville</td>\n",
              "      <td>13</td>\n",
              "      <td>25</td>\n",
              "      <td>30044</td>\n",
              "      <td>8</td>\n",
              "      <td>5400</td>\n",
              "      <td>V Flex Fuel Vehicle</td>\n",
              "      <td>true</td>\n",
              "      <td>false</td>\n",
              "      <td>false</td>\n",
              "      <td>None</td>\n",
              "      <td>41</td>\n",
              "      <td>28</td>\n",
              "      <td>Flex Fuel Vehicle</td>\n",
              "      <td>true</td>\n",
              "      <td>78</td>\n",
              "      <td>18</td>\n",
              "      <td>310</td>\n",
              "      <td></td>\n",
              "      <td>true</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>false</td>\n",
              "      <td>None</td>\n",
              "      <td>33.927</td>\n",
              "      <td>208</td>\n",
              "      <td>None</td>\n",
              "      <td>BLUE</td>\n",
              "      <td>-84.0574</td>\n",
              "      <td>Leather Seats, Navigation System, Alloy Wheels...</td>\n",
              "      <td>Lincoln</td>\n",
              "      <td>8</td>\n",
              "      <td>155051</td>\n",
              "      <td>Navigator</td>\n",
              "      <td>3</td>\n",
              "      <td>13444.0</td>\n",
              "      <td>false</td>\n",
              "      <td>60</td>\n",
              "      <td>4.818181818</td>\n",
              "      <td>311449</td>\n",
              "      <td>Gwinnett Motor Company</td>\n",
              "      <td>false</td>\n",
              "      <td>365 lb-ft @ 3,600 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>Automatic</td>\n",
              "      <td>4WD</td>\n",
              "      <td>Four-Wheel Drive</td>\n",
              "      <td>119</td>\n",
              "      <td>91</td>\n",
              "      <td>2013</td>\n",
              "      <td>365</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>38</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>East Hartford</td>\n",
              "      <td>18</td>\n",
              "      <td>221</td>\n",
              "      <td>6108</td>\n",
              "      <td>6</td>\n",
              "      <td>None</td>\n",
              "      <td>V</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>true</td>\n",
              "      <td>Jeep</td>\n",
              "      <td>40</td>\n",
              "      <td>24</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>None</td>\n",
              "      <td>69</td>\n",
              "      <td>25</td>\n",
              "      <td>None</td>\n",
              "      <td>Black</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>true</td>\n",
              "      <td>None</td>\n",
              "      <td>41.7696</td>\n",
              "      <td>189</td>\n",
              "      <td>None</td>\n",
              "      <td>WHITE</td>\n",
              "      <td>-72.6545</td>\n",
              "      <td>Sunroof/Moonroof, Navigation System, Adaptive ...</td>\n",
              "      <td>Jeep</td>\n",
              "      <td>5</td>\n",
              "      <td>19</td>\n",
              "      <td>Grand Cherokee</td>\n",
              "      <td>None</td>\n",
              "      <td>43861.0</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td>4.377777778</td>\n",
              "      <td>60510</td>\n",
              "      <td>Gengras Chrysler Dodge Jeep Ram</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>A</td>\n",
              "      <td>Automatic</td>\n",
              "      <td>4WD</td>\n",
              "      <td>Four-Wheel Drive</td>\n",
              "      <td>114</td>\n",
              "      <td>84</td>\n",
              "      <td>2020</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>38</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>SUV / Crossover</td>\n",
              "      <td>None</td>\n",
              "      <td>Livermore</td>\n",
              "      <td>23</td>\n",
              "      <td>44</td>\n",
              "      <td>94551</td>\n",
              "      <td>4</td>\n",
              "      <td>2000</td>\n",
              "      <td>I</td>\n",
              "      <td>false</td>\n",
              "      <td>false</td>\n",
              "      <td>true</td>\n",
              "      <td>Honda</td>\n",
              "      <td>41</td>\n",
              "      <td>16</td>\n",
              "      <td>Gasoline</td>\n",
              "      <td>false</td>\n",
              "      <td>65</td>\n",
              "      <td>30</td>\n",
              "      <td>164</td>\n",
              "      <td>Black</td>\n",
              "      <td>false</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>false</td>\n",
              "      <td>None</td>\n",
              "      <td>37.7007</td>\n",
              "      <td>176</td>\n",
              "      <td>None</td>\n",
              "      <td>BLACK</td>\n",
              "      <td>-121.76</td>\n",
              "      <td>Leather Seats, Navigation System, Alloy Wheels...</td>\n",
              "      <td>Hyundai</td>\n",
              "      <td>5</td>\n",
              "      <td>5075</td>\n",
              "      <td>Tucson</td>\n",
              "      <td>1</td>\n",
              "      <td>20292.0</td>\n",
              "      <td>false</td>\n",
              "      <td>338</td>\n",
              "      <td>3.625</td>\n",
              "      <td>58661</td>\n",
              "      <td>Livermore Honda</td>\n",
              "      <td>false</td>\n",
              "      <td>151 lb-ft @ 4,000 RPM</td>\n",
              "      <td>A</td>\n",
              "      <td>6-Speed Automatic</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Front-Wheel Drive</td>\n",
              "      <td>105</td>\n",
              "      <td>72</td>\n",
              "      <td>2017</td>\n",
              "      <td>151</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  back_legroom   bed bed_height  ... torque_ftlb torque_rpm torque_grade\n",
              "0           34  None       None  ...         132       None         None\n",
              "1         None  None       None  ...         400       None         None\n",
              "2           39  None       None  ...         365       None         None\n",
              "3           38  None       None  ...        None       None         None\n",
              "4           38  None       None  ...         151       None         None\n",
              "\n",
              "[5 rows x 59 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "sVvCdRvtDD3Y",
        "outputId": "adf1e3d2-b826-494c-fb53-5bc785275393",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "sampled_df.printSchema()"
      ],
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "root\n",
            " |-- back_legroom: string (nullable = true)\n",
            " |-- bed: string (nullable = true)\n",
            " |-- bed_height: string (nullable = true)\n",
            " |-- bed_length: string (nullable = true)\n",
            " |-- body_type: string (nullable = true)\n",
            " |-- cabin: string (nullable = true)\n",
            " |-- city: string (nullable = true)\n",
            " |-- city_fuel_economy: string (nullable = true)\n",
            " |-- daysonmarket: string (nullable = true)\n",
            " |-- dealer_zip: string (nullable = true)\n",
            " |-- engine_cylinders: string (nullable = true)\n",
            " |-- engine_displacement: string (nullable = true)\n",
            " |-- engine_type: string (nullable = true)\n",
            " |-- fleet: string (nullable = true)\n",
            " |-- frame_damaged: string (nullable = true)\n",
            " |-- franchise_dealer: string (nullable = true)\n",
            " |-- franchise_make: string (nullable = true)\n",
            " |-- front_legroom: string (nullable = true)\n",
            " |-- fuel_tank_volume: string (nullable = true)\n",
            " |-- fuel_type: string (nullable = true)\n",
            " |-- has_accidents: string (nullable = true)\n",
            " |-- height: string (nullable = true)\n",
            " |-- highway_fuel_economy: string (nullable = true)\n",
            " |-- horsepower: string (nullable = true)\n",
            " |-- interior_color: string (nullable = true)\n",
            " |-- isCab: string (nullable = true)\n",
            " |-- is_certified: string (nullable = true)\n",
            " |-- is_cpo: string (nullable = true)\n",
            " |-- is_new: string (nullable = true)\n",
            " |-- is_oemcpo: string (nullable = true)\n",
            " |-- latitude: string (nullable = true)\n",
            " |-- length: string (nullable = true)\n",
            " |-- listed_date: string (nullable = true)\n",
            " |-- listing_color: string (nullable = true)\n",
            " |-- longitude: string (nullable = true)\n",
            " |-- major_options: string (nullable = true)\n",
            " |-- make_name: string (nullable = true)\n",
            " |-- maximum_seating: string (nullable = true)\n",
            " |-- mileage: string (nullable = true)\n",
            " |-- model_name: string (nullable = true)\n",
            " |-- owner_count: string (nullable = true)\n",
            " |-- price: string (nullable = true)\n",
            " |-- salvage: string (nullable = true)\n",
            " |-- savings_amount: string (nullable = true)\n",
            " |-- seller_rating: string (nullable = true)\n",
            " |-- sp_id: string (nullable = true)\n",
            " |-- sp_name: string (nullable = true)\n",
            " |-- theft_title: string (nullable = true)\n",
            " |-- torque: string (nullable = true)\n",
            " |-- transmission: string (nullable = true)\n",
            " |-- transmission_display: string (nullable = true)\n",
            " |-- wheel_system: string (nullable = true)\n",
            " |-- wheel_system_display: string (nullable = true)\n",
            " |-- wheelbase: string (nullable = true)\n",
            " |-- width: string (nullable = true)\n",
            " |-- year: string (nullable = true)\n",
            " |-- torque_ftlb: string (nullable = true)\n",
            " |-- torque_rpm: string (nullable = true)\n",
            " |-- torque_grade: string (nullable = true)\n",
            "\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lsXOSBngD93x",
        "outputId": "2796a151-9b13-48f3-fdf0-c1826f3d4dea",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 207
        }
      },
      "source": [
        "sampled_df.describe().show()"
      ],
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "+-------+------------------+-----+----------+-----------------+-----------+-----------+-----------+------------------+------------------+------------------+-----------------+-------------------+-------------------+------+-------------+----------------+--------------+------------------+------------------+---------+-------------+------------------+--------------------+------------------+--------------------+------+------------+------+------+---------+------------------+------------------+-----------+-------------+------------------+--------------------+----------+------------------+------------------+------------------+------------------+------------------+-------+------------------+------------------+------------------+--------------------+-----------+--------------------+------------+--------------------+------------+--------------------+------------------+-----------------+-----------------+------------------+------------------+--------------------+\n",
            "|summary|      back_legroom|  bed|bed_height|       bed_length|  body_type|      cabin|       city| city_fuel_economy|      daysonmarket|        dealer_zip| engine_cylinders|engine_displacement|        engine_type| fleet|frame_damaged|franchise_dealer|franchise_make|     front_legroom|  fuel_tank_volume|fuel_type|has_accidents|            height|highway_fuel_economy|        horsepower|      interior_color| isCab|is_certified|is_cpo|is_new|is_oemcpo|          latitude|            length|listed_date|listing_color|         longitude|       major_options| make_name|   maximum_seating|           mileage|        model_name|       owner_count|             price|salvage|    savings_amount|     seller_rating|             sp_id|             sp_name|theft_title|              torque|transmission|transmission_display|wheel_system|wheel_system_display|         wheelbase|            width|             year|       torque_ftlb|        torque_rpm|        torque_grade|\n",
            "+-------+------------------+-----+----------+-----------------+-----------+-----------+-----------+------------------+------------------+------------------+-----------------+-------------------+-------------------+------+-------------+----------------+--------------+------------------+------------------+---------+-------------+------------------+--------------------+------------------+--------------------+------+------------+------+------+---------+------------------+------------------+-----------+-------------+------------------+--------------------+----------+------------------+------------------+------------------+------------------+------------------+-------+------------------+------------------+------------------+--------------------+-----------+--------------------+------------+--------------------+------------+--------------------+------------------+-----------------+-----------------+------------------+------------------+--------------------+\n",
            "|  count|            548674| 3871|         0|            83589|     593912|      12665|     596623|            498938|            596623|            596623|           576701|             562441|             576701|313962|       313962|          596623|        482926|            561922|            564874|   580247|       313962|            565069|              498938|            562441|              596623|313962|           0| 36507|596623|    27061|            596623|            565072|          0|       596623|            596623|              557429|    596623|            565068|            568410|            596623|            295962|            596623| 313962|            596623|            588460|            596601|              596623|     313962|              493762|      584013|              584013|      567483|              567483|            565079|           565070|           596623|            493762|             10800|               10800|\n",
            "|   mean| 37.52465762912039| null|      null|71.88524805895513|       null|       null|       null|22.694763678052183| 76.15350229541939| 50674.84509072623|5.127501079415503|  2967.340574389136|               null|  null|         null|            null|          null| 41.76971003092956|18.266275310954303|     null|         null| 65.41629783265407|   29.47970489319314|248.01937269864752|   20302.30188679245|  null|        null|  null|  null|     null|36.988186852836705|193.21146862700684|       null|         null|-90.63183965217564|                null|      null| 5.476231179256302|31121.334647525553|1597.6868311055991| 1.529595015576324| 29941.16002797243|   null| 555.1398186124236| 4.272497424963937| 233312.3968414401|                null|       null|                null|        null|                null|        null|                null|114.91555693982612|77.90917054524218|2017.728634330222|265.24805675608894|201.06027777777777|0.008240740740740741|\n",
            "| stddev|3.1781849444287684| null|      null|9.334593090697304|       null|       null|       null|  8.84975576633252|108.99123581799334|27342.830708155816|1.467394216788439| 1348.9328234302232|               null|  null|         null|            null|          null|1.5578340924358465| 5.571092695016505|     null|         null|7.5649158580804645|  7.8033317465342655| 90.51068887156629|   48058.77435318329|  null|        null|  null|  null|     null| 4.998795987566549|20.170584954250536|       null|         null|13.887045529699622|                null|      null|1.1747726534987772| 45289.33909558511| 766.4592275444486|0.9164009159911009|19376.948934573888|   null|1106.8211469238438|0.5115473752001239|132333.55804361476|                null|       null|                null|        null|                null|        null|                null|14.539718939426916|7.646950036341266|4.192412371968664|119.65088256004232| 9.521488455015193| 0.09040789648291168|\n",
            "|    min|                 0| Long|      null|               41|Convertible|   Crew Cab|    Hayward|                10|                 0|        08816-4351|               10|               1000|                  H| false|        false|           false|         Acura|                 0|                 1|Biodiesel|        false|               100|                  10|               100|                    | false|        null|  true| false|     true|           18.3988|               106|       null|        BLACK|          -100.012|101A Mid Equipmen...|AM General|                10|                 0|          1 Series|                 1|            1000.0|  false|                 0|               1.0|            100004|\t Dijie Auto Sale...|      false|100 lb-ft @ 4,500...|           A|   1-Speed Automatic|         4WD|                 4X2|               100|              101|             1923|               100|               200|                   0|\n",
            "|    max|                47|Short|      null|               98|      Wagon|Regular Cab|north hills|                98|               999|             99403|                8|                900|W Flex Fuel Vehicle|  true|         true|            true|         smart|                67|                 9|  Propane|         true|                99|                  99|                99|xDrive35i Premium...|  true|        null|  true|  true|     true|           48.9237|               290|       null|       YELLOW|          -99.9991|         Z71 Package|     smart|                 9|             99999|                xD|                 9|           99999.0|   true|               999|               5.0|             99978|      vBs Auto Sales|       true|98 lb-ft @ 5,000 RPM|           M|              Manual|         RWD|    Rear-Wheel Drive|                99|               99|             2021|                98|               400|                   1|\n",
            "+-------+------------------+-----+----------+-----------------+-----------+-----------+-----------+------------------+------------------+------------------+-----------------+-------------------+-------------------+------+-------------+----------------+--------------+------------------+------------------+---------+-------------+------------------+--------------------+------------------+--------------------+------+------------+------+------+---------+------------------+------------------+-----------+-------------+------------------+--------------------+----------+------------------+------------------+------------------+------------------+------------------+-------+------------------+------------------+------------------+--------------------+-----------+--------------------+------------+--------------------+------------+--------------------+------------------+-----------------+-----------------+------------------+------------------+--------------------+\n",
            "\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Q-IqUmbFD-f1",
        "outputId": "aedbecac-e6fe-4af4-fd65-ad9a0d9031c1",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "len(sampled_df.columns)"
      ],
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "59"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5aylkRFyGB11",
        "outputId": "c9b23818-66a7-4cff-c917-439279f9af3b",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "sampled_df.count()"
      ],
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "596623"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gxuT4A4uGYiN",
        "outputId": "e8fef514-04f3-4254-eddd-7bde781654c0",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 376
        }
      },
      "source": [
        "import matplotlib.pyplot as plt\n",
        "from pyspark.sql import functions as fn\n",
        "\n",
        "make_count_df = sampled_df.groupBy('make_name').count().orderBy(fn.desc('count')).limit(40).toPandas()\n",
        "\n",
        "plt.bar(make_count_df['make_name'],make_count_df['count'])\n",
        "plt.xticks(rotation='vertical')\n",
        "plt.xlabel('Vehicle Make')\n",
        "plt.ylabel('Number of Listings')\n",
        "plt.title('Vehicle Make Summary \\nLimited to Top 40 Makes')\n",
        "plt.show()"
      ],
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZEAAAFnCAYAAABn6nRTAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nOydd9gcVfXHP9+EEloIXXpAQQSUFhBBqYJ0EKV3EPQnVVSaIAgqICICokiv0ruA9NCUltCrMaG30HsJnN8f50x23nl39913875v8pLzeZ55dufOnTt3Zmfvufecc8+VmZEkSZIk7TBgYlcgSZIk6b+kEEmSJEnaJoVIkiRJ0jYpRJIkSZK2SSGSJEmStE0KkSRJkqRtUogk/QJJQyWZpCkaHD9A0iktlHOGpN/2fA1bQ9Iqkp6fWNdPkp4mhUjSZ0j6l6RD66RvKOnlRgKiFczs92b2owmrYXNCiL1arqekKSOtTydcSZpK0tGSnpf0nqSnJf25L+uQJJBCJOlbzgS2lqRK+jbAuWY2biLUqbu8Caxd2l870vqa/YFhwHLADMAqwMiJUI8JYkI6DsmkQQqRpC+5HJgF+E6RIGkmYD3gLEkDJO0n6X+SXpd0oaSZK2VsJelZSa9J+lWpnEMknVPa/7akf0t6S9JzkravVyFJ60l6IPL9W9I3uriHs4FtS/vbAmdVytxB0uOS3pU0WtKPGxUmaQ9Jj0maR9LUkv4Y9/eKpBMlTdPg1GWBy8zsRXOeNrOzSuWapK+U9ser8QqVmqR9YhT1kqSNJK0j6SlJb0g6oHTuIZIuknRO3NPDkhaWtH+c/5ykNVu5/9K195X0MnC6pEckrV/KM2X8vks1/hmSSYUUIkmfYWYfAhfSsRHeFHjCzB4Edgc2AlYG5sJ7+CdUivk28FVgdeDXkr5WvY6k+YFrgeOB2YAlgQfq5FsKOA34MS7c/g5cKWnqJrdxObCSpCEhAL8DXFHJ8youGAcDOwDHSFq6zvV/DWwPrGxmzwNHAAtHfb8CzA38ukE97gL2lvRTSV+vM7rrii8Bg0rXOBnYGlgm7ukgSQuU8q+PC9CZgPuB6/D2Y27gUPzZtXr/XwJmBuYHdsGF8Nal4+sAL5nZ/d28p2RiYGa55dZnGy4E3gIGxf6dwM/i++PA6qW8cwKfAlMAQwED5ikdvwfYPL4fApwT3/fHe+n1rn8G8Nv4/jfgsMrxJ/FGvd65hjfup+CC5yd44/sV/ys1vOfLgT3j+yrAC8CfgDuAGSNdwPvAl0vnfQsY06DMgcCu8fw+Bl4EtqvWtcF9rwJ8CAyM/Rki/zdL+UcAG5We7Q2lY+sD79U5f0iL9/9J8ftH2lzAu8Dg2L8Y2Gdiv6u5tbalPjLpU8zsDkmvARtJuhfX6W8ch+cHLpP0eemUz4A5Svsvl75/AExf5zLzAv9roTrzA9tJ2r2UNhXeqDXjLOBwvOHft3pQ0trAwfioYgAwLfBwKcsQvAe+mZm9HWmzRb4RpUGFcGHRCTP7DB+lnRAqrx2B0yTdY2aPd1F/gNejDHCBAvBK6fiHdHy21WOv1Tl/euCtFu5/rJl9VLqXFyXdCfxA0mW4nWnPFu4hmQRIdVYyMTgLV2ltDVxnZkUD9RywtpkNKW2DzOyFbpb/HPDlFvP9rnK9ac3svC7Oux0fJc2BjybGE6qwS4A/AnOY2RDgGlwgFLyJq3tOl7RipL2GN8aLleoyo5nVE5IdMLMPzeyEKHfRSP4Ab7wLvtRVOT1Bi/dfz5PtTPx92AT4Txu/eTKRSCGSTAzOAr4L7Iw3HgUnAr8LmwaSZpO0YRvlnwt8V9KmkqaQNIukJevkOxn4iaRvyplO0rqSZmhWuJkZrtLZIL6XmQqYGhgLjIte+ZqVPJjZcGAr4FJJy5nZ51GfYyTNDiBpbknfq1cHSXuFkXqauMftcLVSYUd4ANhS0kBJa+F2pr6gpfuvw+XA0vgI5Kwu8iaTEClEkj7HzJ4G/g1MB1xZOnRs7F8v6V3cePzNNsp/FjfO/hx4A29Ql6iT7z5ckP0F78WPwg3drVzjUTN7tE76u8AeuAPBm8CWdLzHct4bcDXUVWF43jfqcJekd4AbcSeCenwAHI2r917D7SM/MLPRcXxPXNC9hQury1u5rwmlO/dfOe9DfASzAHBpb9Yx6VnUuSOVJEnS94S32sJmtnWXmZNJhjSsJ0ky0ZHPB9oJn3ia9CNSnZUkyURF0s64k8O1ZnbbxK5P0j1SnZUkSZK0TY5EkiRJkrZJIZJMdCR9R9KTbZ47nzyKbd1JeW2Ut72kO7rOmbSCKjHNki8eKUSSPkMervy71XQzu93MGrmyNsXMnjWz6YvZ05KGS+qVkPDqYk2TLs7dKoTde5I+lPR5af+9XqjrtlHXH5XSJOlIeXDL1+N73ZhbMQfFYgZ5OX2JSB/e03VO+icpRJKkDzCzc0PYTY+H9Xix2G9lVnp3iMCQBwDVeSy74AEulwC+gc8jaRhhGJ8w+C1Js5TStgOe6rnaJv2dFCLJREeV1f5ixPJLSQ9Jel/SqZLmkHRthBe/MRrKDqMDSb/DI9D+JXr4f4k8i0i6QR7i/ElJm5auNYukKyW9I+kemodLKTyH3oryvyUPX3+gpGfkYdHPkjRjN+//azGCekvSo5I2KB07Qx4S/oa491uLGf1NOBw4Dp+EWGY74Ggzez7CihxN88mVn+CTFDePugwENsMjApTrf6w8HPw7kkZI+k7nosaHeD9P0iXyRbXmiu9jJY2RtEcp73KS7osyX5H0py7uOZlIpBBJJlV+AKyBB/FbHw/tfgAeqHAAPiu6A2b2Kzyu1W7Rw99N0nTADcA/gNnxBvGvkooYUycAH+GxsHaMrRErxeeQKP8/eCO8PbAqsCAehPAvrd6kpCmBq4Dro367A+dKKqv3tgIOA2bFZ9+fWy2nVN5y+GJVJ9Y5vBjwYGn/wUhrRhHnDOB7wCN4xOAy9+Lh62fGn/NFkgZV6jUNLpA+xsP/j8Pv+0E8nPzqwF6qhXk5FjjWzAbjgv3CLuqZTCRSiCSTKseb2SvRY74duNvM7o/or5cBrS5YtB7wtJmdbmbjzNeouATYJHrWPwB+bWbvm9kjdIzl1QpbAX8ys9Fm9h4ehn7zbthNlscFzxFm9omZ3Qz8E9iilOdqM7vNzD4GfoWrmOatFhT381dciH5ePR7Xebu0/zYwfSO7CICZ/RuYOYRapwW4Is85ZvZ6PN+j8dhZZSE4GPgXHll5h7BfLQvMZmaHxn2PxmOHbR7nfAp8RdKsZvaemd3VqI7JxCWFSDKpUg093ixMeTPmB74ZqqK3JBWxpL6Ej2qmwCe6FTzTzXrOVTnnmShzjvrZ657/XKXRfwbvnReMr18IqjeoH67+p8BDTRrc9/AGvWAw8F6dIJJVzgZ2w0dbl1UPSvqFfCXDt+P5zoiPmgqWx20wR5SuNT8wV+V3OYDac9sJH4U+IeleSet1UcdkIpFhT5IvGtUG8TngVjNbo5oxeu7j8PVHnojk+bpRNrhqp2yjmC/KfKVO3nq8CMwraUBJkMxHR+P1+FGHpOlxtVFVpQSuElpZ0jqxPzOwlKQlzWw33NC+BL6YF/G9UxDJOpyNB4Y8y8w+KA9cwv6xT1z7UTP7XNKbdAz9fj3wEHCTpFUi9P9z+IJbC9W7oJn9F9hC0gB8vZmLJc1iZu+3UN+kD8mRSNLXTClpUGnr6Y7MK7htouCfwMKStgnD7pSSlpX0tVCrXAocImnasJNs16TsscDnlfLPA34maYFo4H8PXGBm41qs7914RN59om6r4Dag80t51pGvGT8Vbhu5y8ye61wU2wNfw+0TSwL3Ab/BVWDgqqi95SHm58KjHJ/RVQXNbAweSv5XdQ7PgAvNscAU8iCKg6uZzOwPuL3kJkmz4oLsXfla69PIQ9YvLmlZAElbS5otBOtbUUw9FV0ykUkhkvQ11+DqqGI7pIfLPxb4oaQ3JR0XocnXxHXtL+Kh04/E9fbgaprpI/0M4PRGBZvZB8DvgDtDBbM8vkb72bjn1hjcSL97ozLqlPkJLjTWxr2p/gpsa2ZPlLL9A18p8A18DfS6UW7N7C0ze7nYcO+qd0qrJ/4dN2Y/jBvIr6bj2ujN6nmHmdUb/VyH2zuewtVwH9FRPVgu4zDcuH4jrvJaDxd2Y+LeT4l0gLWAR+VzaI7Fl0H+sFOhyUQnY2clySSMpDOA583swIldlySpR45EkiRJkrZJIZIkSZK0TaqzkiRJkrbJkUiSJEnSNilEkiRJkraZ7CYbzjrrrDZ06NCJXY0kSZJ+w4gRI14zs9nqHZvshMjQoUO57777JnY1kiRJ+g2SGoYDSnVWkiRJ0jYpRJIkSZK2SSGSJEmStE0KkSRJkqRtUogkSZIkbZNCJEmSJGmbFCJJkiRJ26QQSZIkSdpmsptsOCEM3e/quulPH7FuH9ckSZJk0iBHIkmSJEnbpBBJkiRJ2iaFSJIkSdI2KUSSJEmStkkhkiRJkrRNCpEkSZKkbVKIJEmSJG2TQiRJkiRpmxQiSZIkSdukEEmSJEnaJoVIkiRJ0jYpRJIkSZK2SSGSJEmStE0KkSRJkqRtUogkSZIkbZNCJEmSJGmbFCJJkiRJ26QQSZIkSdomhUiSJEnSNilEkiRJkrZJIZIkSZK0TQqRJEmSpG1SiCRJkiRtk0IkSZIkaZsUIkmSJEnbpBBJkiRJ2iaFSJIkSdI2KUSSJEmStulVISLpZ5IelfSIpPMkDZK0gKS7JY2SdIGkqSLv1LE/Ko4PLZWzf6Q/Kel7pfS1Im2UpP16816SJEmSzvSaEJE0N7AHMMzMFgcGApsDRwLHmNlXgDeBneKUnYA3I/2YyIekReO8xYC1gL9KGihpIHACsDawKLBF5E2SJEn6iN5WZ00BTCNpCmBa4CVgNeDiOH4msFF83zD2ieOrS1Kkn29mH5vZGGAUsFxso8xstJl9ApwfeZMkSZI+oteEiJm9APwReBYXHm8DI4C3zGxcZHsemDu+zw08F+eOi/yzlNMr5zRK74SkXSTdJ+m+sWPHTvjNJUmSJEDvqrNmwkcGCwBzAdPh6qg+x8xOMrNhZjZsttlmmxhVSJIk+ULSm+qs7wJjzGysmX0KXAqsCAwJ9RbAPMAL8f0FYF6AOD4j8Ho5vXJOo/QkSZKkj+hNIfIssLykacO2sTrwGHAL8MPIsx1wRXy/MvaJ4zebmUX65uG9tQCwEHAPcC+wUHh7TYUb36/sxftJkiRJKkzRdZb2MLO7JV0MjATGAfcDJwFXA+dL+m2knRqnnAqcLWkU8AYuFDCzRyVdiAugccCuZvYZgKTdgOtwz6/TzOzR3rqfJEmSpDO9JkQAzOxg4OBK8mjcs6qa9yNgkwbl/A74XZ30a4BrJrymSZIkSTvkjPUkSZKkbVKIJEmSJG2TQiRJkiRpmxQiSZIkSdukEEmSJEnaple9syYnhu53dcNjTx+xbh/WJEmSpO/IkUiSJEnSNilEkiRJkrZJIZIkSZK0TQqRJEmSpG1SiCRJkiRtk0IkSZIkaZsUIkmSJEnbpBBJkiRJ2iaFSJIkSdI2XQoRSZtImiG+HyjpUklL937VkiRJkkmdVkYiB5nZu5K+ja+bfirwt96tVpIkSdIfaEWIfBaf6wInmdnVwFS9V6UkSZKkv9CKEHlB0t+BzYBrJE3d4nlJkiTJF5xWhMGmwHXA98zsLWBm4Je9WqskSZKkX9BKKPhBwHAASTMDHwO39GKdkiRJkn5CKyORkcBY4Cngv/H9aUkjJS3Tm5VLkiRJJm1aESI3AOuY2axmNguwNnA18FPgr71ZuSRJkmTSphUhsryZXVfsmNn1kXYXMHWv1SxJkiSZ5GnFJvKSpH2B82N/M+AVSQOBz3utZkmSJMkkTysjkS2BeYDLY5sv0gbinltJkiTJZEqXIxEzew3YvcHhUT1bnSRJkqQ/0aUQkbQw8AtgaDm/ma3We9VKkiRJ+gOt2EQuAk4ETqEWAiVJkiRJWhIi48wsAy4mSZIknWjFsH6VpJ9KmlPSzMXW6zVLkiRJJnlaGYlsF5/leFkGLNjz1UmSJEn6E614Zy3QFxVJkiRJ+h8NhYik1czsZkkb1ztuZpf2XrWSJEmS/kCzkcjKwM3A+nWOGZBCJEmSZDKnoRAxs4Pj66FmNqZ8TFJLKi5JQ3DX4MVxwbMj8CRwAT7v5GlgUzN7U5KAY4F1gA+A7c1sZJSzHXBgFPtbMzsz0pcBzgCmAa4B9jQza6VuSZIkyYTTinfWJXXSLm6x/GOBf5nZIsASwOPAfsBNZrYQcFPsg0cHXii2XYh13MMT7GDgm8BywMGSZopz/gbsXDpvrRbrlSRJkvQAzWwiiwCLATNW7CKD8YWqmiJpRmAlYHsAM/sE+ETShsAqke1MfMGrfYENgbNiJHGXpCGS5oy8N5jZG1HuDcBakoYDgyOaMJLOAjYCrm3hvpMkSZIeoJlN5KvAesAQOtpF3sV7/12xAL6A1emSlgBGAHsCc5jZS5HnZWCO+D438Fzp/OcjrVn683XSOyFpF3x0w3zzzddC1ZMkSZJWaGYTuQK4QtK3zOw/bZa9NLC7md0t6VhqqqviGiap120YZnYScBLAsGHD0maSJEnSQ7RiE/m+pMGSppR0k6SxkrZu4bzngefN7O7YvxgXKq+Emor4fDWOvwDMWzp/nkhrlj5PnfQkSZKkj2hFiKxpZu/gqq2nga/QcfZ6XczsZeA5SV+NpNWBx4Arqc2C3w64Ir5fCWwrZ3ng7VB7XQesKWmmMKivCVwXx96RtHx4dm1bKitJkiTpA1oJezJlfK4LXGRmb3ub3RK7A+dKmgoYDeyAC64LJe0EPENtYatrcPfeUbiL7w4AZvaGpMOAeyPfoYWRHV/n/Qzcxfda0qieJEnSp7QiRK6S9ATwIfB/kmYDPmqlcDN7ABhW59DqdfIasGuDck4DTquTfh8+ByVJkiSZCHSpzjKz/YAVgGFm9inwPu6OmyRJkkzmdCt2VkWNlWFPkiRJJnMydlaSJEnSNl3GzjKzHarHJP2gNyuVJEmS9A9acfGtxzE9WoskSZKkX9KuEGnZxzdJkiT54tKuEMnQIUmSJElT76yHqS8sRC1oYpIkSTIZ08w7a70+q0WSJEnSL2nmnfVMX1YkSZIk6X+0axNJkiRJkhQiSZIkSfs0FCKSborPI/uuOkmSJEl/oplhfU5JKwAbSDqfytwQMxvZqzVLkiRJJnmaCZFfAwfhKwb+qXLMgNV6q1JJkiRJ/6CZd9bFwMWSDjKzw/qwTkmSJEk/octFqczsMEkbACtF0nAz+2fvVitJkiTpD3TpnSXpcGBPfH30x4A9Jf2+tyuWJEmSTPq0sjzuusCSZvY5gKQzgfuBA3qzYkmSJMmkT6vzRIaUvs/YGxVJkiRJ+h+tjEQOB+6XdAvu5rsSsF+v1ipJkiTpF7RiWD9P0nBg2Uja18xe7tVafQEZut/VddOfPmLdPq5JkiRJz9HKSAQzewm4spfrkiRJkvQzMnZWkiRJ0jYpRJIkSZK2aSpEJA2U9ERfVSZJkiTpXzQVImb2GfCkpPn6qD5JkiRJP6IVw/pMwKOS7gHeLxLNbINeq1WSJEnSL2hFiBzU67VIkiRJ+iWtzBO5VdL8wEJmdqOkaYGBvV+1JEmSZFKnlQCMOwMXA3+PpLmBy3uzUkmSJEn/oBV11q7AcsDdAGb2X0mz92qtJkNyRnuSJP2RVoTIx2b2ieSr40qaAl/ZMOkjGgkYSCGTJMnEpZXJhrdKOgCYRtIawEXAVb1brSRJkqQ/0IoQ2Q8YCzwM/Bi4Bjiw1QvEhMX7Jf0z9heQdLekUZIukDRVpE8d+6Pi+NBSGftH+pOSvldKXyvSRknKyMJJkiR9TJdCJBajOhM4DPgNcKaZdUedtSfweGn/SOAYM/sK8CawU6TvBLwZ6cdEPiQtCmwOLAasBfw1BNNA4ARgbWBRYIvImyRJkvQRrXhnrQv8DzgO+AswStLarRQuaR58ZcRTYl/Aari3F7hw2ii+bxj7xPHVI/+GwPlm9rGZjQFG4Yb+5YBRZjbazD4Bzo+8SZIkSR/RimH9aGBVMxsFIOnLwNXAtS2c+2dgH2CG2J8FeMvMxsX+87jLMPH5HICZjZP0duSfG7irVGb5nOcq6d9soU5JkiRJD9GKTeTdQoAEo4F3uzpJ0nrAq2Y2ot3K9RSSdpF0n6T7xo4dO7GrkyRJ8oWh4UhE0sbx9T5J1wAX4q69mwD3tlD2isAGktYBBgGDgWOBIZKmiNHIPMALkf8FYF7g+XAjnhF4vZReUD6nUXoHzOwk4CSAYcOGpXtykiRJD9FsJLJ+bIOAV4CVgVVwT61puirYzPY3s3nMbChuGL/ZzLYCbgF+GNm2A66I71fGPnH85jDgXwlsHt5bCwALAffggmyh8PaaKq6Rqy8mSZL0IQ1HIma2Qy9dc1/gfEm/Be4HTo30U4GzJY0C3sCFAmb2qKQLgceAccCuEaIeSbsB1+GxvE4zs0d7qc5JkiRJHbo0rEfvf3dgaDl/d0LBm9lwYHh8H417VlXzfISryuqd/zvgd3XSr8HnrSRJkiQTgVa8sy7HRwlXAZ/3bnWSJEmS/kQrQuQjMzuu12uSJEmS9DtaESLHSjoYuB74uEg0s5G9VqskSZKkX9CKEPk6sA0+07xQZ1nsJ0mSJJMxrQiRTYAFI7RIkiRJkoynlRnrjwBDersiSZIkSf+jlZHIEOAJSffS0SbSsotvkiRJ8sWkFSFycK/XIkmSJOmXdClEzOzWvqhIkiRJ0v9oZcb6u9TWVJ8KmBJ438wG92bFktZptAZ7rr+eJElv08pIpFgLhNIiUcv3ZqWSJEmS/kEr3lnjMedy4HtdZk6SJEm+8LSiztq4tDsAGAZ81Gs1SpIkSfoNrXhnrV/6Pg54mlzLPEmSJKE1m0hvrSuSJEmS9HOaLY/76ybnmZkd1gv1SZIkSfoRzUYi79dJmw7YCZgFSCGSJEkymdNsedyji++SZgD2BHYAzgeObnRekiRJMvnQ1CYiaWZgb2Ar4ExgaTN7sy8qliRJkkz6NLOJHAVsDJwEfN3M3uuzWiVJkiT9gmaTDX8OzAUcCLwo6Z3Y3pX0Tt9UL0mSJJmUaWYT6dZs9iRJkmTyIwVFkiRJ0jatzFhP+jkZ5TdJkt4iRyJJkiRJ26QQSZIkSdomhUiSJEnSNilEkiRJkrZJIZIkSZK0TQqRJEmSpG1SiCRJkiRtk0IkSZIkaZsUIkmSJEnbpBBJkiRJ2ibDnkzmZEiUJEkmhF4biUiaV9Itkh6T9KikPSN9Zkk3SPpvfM4U6ZJ0nKRRkh6StHSprO0i/38lbVdKX0bSw3HOcZLUW/eTJEmSdKY31VnjgJ+b2aLA8sCukhYF9gNuMrOFgJtiH2BtYKHYdgH+BuNXVzwY+CawHHBwIXgiz86l89bqxftJkiRJKvSaEDGzl8xsZHx/F3gcmBvYEF9ql/jcKL5vCJxlzl3AEElzAt8DbjCzN2Jp3huAteLYYDO7y8wMOKtUVpIkSdIH9IlNRNJQYCngbmAOM3spDr0MzBHf5waeK532fKQ1S3++Tnq96++Cj26Yb7752r+RyZC0mSRJ0oxeFyKSpgcuAfYys3fKZgszM0nW23Uws5PwteIZNmxYr19vciKFTJJM3vSqi6+kKXEBcq6ZXRrJr4Qqivh8NdJfAOYtnT5PpDVLn6dOepIkSdJH9KZ3loBTgcfN7E+lQ1cChYfVdsAVpfRtw0treeDtUHtdB6wpaaYwqK8JXBfH3pG0fFxr21JZSZIkSR/Qm+qsFYFtgIclPRBpBwBHABdK2gl4Btg0jl0DrAOMAj4AdgAwszckHQbcG/kONbM34vtPgTOAaYBrY0smEVLVlSRffHpNiJjZHUCjeRur18lvwK4NyjoNOK1O+n3A4hNQzSRJkmQCyLAnSZIkSdukEEmSJEnaJoVIkiRJ0jYpRJIkSZK2SSGSJEmStE2Ggk8mGukCnCT9nxyJJEmSJG2TQiRJkiRpm1RnJZMsqe5KkkmfFCJJvyQFTJJMGqQQSb6QpJBJkr4hhUgyWZJCJkl6hjSsJ0mSJG2TQiRJkiRpmxQiSZIkSdukTSRJKqS9JElaJ0ciSZIkSdukEEmSJEnaJtVZSdJNUt2VJDVyJJIkSZK0TY5EkqQHaTRKgRypJF9MciSSJEmStE2ORJKkD+nKnpL2lqS/kSORJEmSpG1yJJIk/YS0tySTIilEkuQLQqrCkolBCpEkmUxIIZP0BmkTSZIkSdomRyJJkuQoJWmbFCJJknRJCpmkEanOSpIkSdomhUiSJEnSNqnOSpJkgmmm7kpV2BebHIkkSZIkbZMjkSRJJioZT6x/0+9HIpLWkvSkpFGS9pvY9UmSJJmc6NcjEUkDgROANYDngXslXWlmj03cmiVJ0hfkKGbi06+FCLAcMMrMRgNIOh/YEEghkiRJl0yIQ0A75/ZF2X2NzKzPL9pTSPohsJaZ/Sj2twG+aWa7VfLtAuwSu18FnuyBy88KvNbGsQk9nmVn2ZNyvbLsvi17QuvVKvOb2Wx1j5hZv92AHwKnlPa3Af7SR9e+r51jE3o8y86yJ+V6Zdn96z3oia2/G9ZfAOYt7c8TaUmSJEkf0N+FyL3AQpIWkDQVsDlw5USuU5IkyWRDvzasm9k4SbsB1wEDgdPM7NE+uvxJbR6b0ONZdpY9oedm2V+csie0XhNMvzasJ0mSJBOX/q7OSpIkSSYiKUSSJEmStunXNpEkSSZvwqFm4dh90sw+nZj1mRzJkUgfIWkmSctJWqnYeqjcWSQdL2mkpBGSjpU0S0+U3VNImrYXytxG0gyVtPVK36euc87MPV2PnkLSQEl/nNj16C5R7ycmRrmSVgH+i4c++ivwVKP/Vfz/vtFDdTtjAs+fTdIfJV0j6eZiq+SZpP7DzciRSAtIehho6IFgZt+QdLaZbVM572wz20bSj4A98XksDwDLA/8BVivlnRr4ATCU0u9iZofG8XWBxYBBlWPnA7fFuQBbARcA35W0j5n9QdLx9epvZntIGgTsVC0b+EWTR7IJ8IGZnV25322Az8zsH1EVnZsAACAASURBVLG/AnAKMD0wn6QlgB+b2U/j+NzA/JX7vS2Ond6gzjvG1+OBn0vawswej7RDgX/G90slbVT0TCXNCfxT0lDgbuBO4N/A3Wb2QfU6jZ63pBuATczsrcg3E3C+mX2vdO50wIdm9rmkhYEDgJ2BPzW4pz3M7DNJ364eq9RptihnKB2f2Y6NzonzNm523MwulTQHsGwk3WNmr8a5fzazvSRd1aDuG0QA1PnM7Nkmdfg2sJCZnR73Mb2ZjWlSp89aKPdoYE0zezKusTBwHrBM7A8HNsCf1QjgVUl3mtnekhYxsyckLd3g+iMl/R74Q+W3/jnQkjCK2H5z0PG3ehY4F/+Prgv8BNgOGFs5/S5JDwCnA9daxQOqXtnA3l39Vq3Uu7ukEGmNooe7a3wWjedWpTyLlU+IH3mZ2N0T/4PeZWarSloE+H3lGlcAb+Mv+8eVsk4EpgVWxRvlHwL3xOE5zeywUvbfStosvheN631N7u1s4Ange3gjvFWc9xoe1HJcUY3SOXPi4RSqXIoLtH/E/jFR7pUAZvZg0VOUdCSwGR7n7LPIb3E+1IQBeEP+feDFUtoYXPhdLOkQM7uoUsfLgQsjNM68UYdfAHfhQnwFYH9gGUljcKFyp5ld2MXznrVoVOKe3pQ0e+U53AZ8Jxqd6/HneEZ8b8b9kq4ELgLeL13j0vh6BXA7cCO1ZwaApOVxwfo1YCrc5f19MxsMrN/kmiZpCuAoYDj+DI+X9Eszu5jau95slDQT8Kikeyr13iDqdjAwDA85dDowJXBOjAzqdc4U6Q80KxeYshAgkf6UpClL5cxoZu9EJ+4sMztY0kNxbG88FNLR9Z4J3sFb28wOKJX/pqR1gGklLUXH941SvpGSdgcOBl4BPi+V+w1gFjM7VdKeZnYrcKukeyvFLAx8F9gROE7ShcAZcY+Nyt4hvvftiLa3p8R/kTbg/jppLwDv4o3tO/H9XeB14PDIc298PgBMHd8frZTzSJPrPlT5nB64Pb7/CZ9kOSC2TYE/dveeSmVPiTe0fwYexNUE3yHcwSPPyK7qGt/vrj434MH4fLJ4Fi3WcwDw72odcGF2A/7Heahyzq7AVcDDwAoNyp0O2A0YhY+iunreI4D5SufPX30epbrtDuxT/PYt3OPpdbbTSscbloF3FL4C3I8LkB1K79/GXVz3QWD20v5sxe/U4m+zcr2tXG+8wS2/Bw/1QLmn4UJ+ldhOrjyvh/EOz/XAsvWuCwyqc91BRd7yOwpMAzyK/79vBm6ps90ceUfhwqLefd0Vn9fho5GlgP81eQ6r4u3MW8CteKekUdkDgXNb/e16YsuRSPeQpBXN7M7YWQEYa2ZzSzrczPZvcN7zkobgveMbJL0JPFPJ829JXzezh+uc/2F8fiBpLlxAzRlpOwN7AefgvZGBwPuSfgyYmQ0O9cG+wKJ0VM+sBhSGyLckLQ68jDcoe0kS/ufcBu+dXg/8DZhG0nRmNr53GM9jBrwXXPBcPCOLHuKe1EZHo3GB1WHU1YSFgHKP/6W4h9ckfQ84Elhc0t7lKgHzESrE6K2fj49CVqCmvhkBHIirGKH58/4VcIekW6P871AL7ll6FPoWPqrbKdQLC8YooxMWPWsz26He8RL/lLSOmV3ToJxRkgaa2WfA6ZLux0dbB+KjxEYMsFBfBa9TsZdKWhE4hJr6UX5JW9DMbpU0P66uulFuAxtYOv0TMzNJFmVN18V9FvdzaxdZ/g/vKOwR+7fjnZ6CQ/GG+g4zu1fSgrgNpcy/gapKq0g7F7gpVKvggvlMYIv47zTjOVyzUI/fSpoRV40dDwwGflbOEDaRrfH/3it4h+RKYMm4z7plm6sB55c0lZl90kUde4ScbNgNQn96OjBjJL0F7Gg+fB0AbAksYGaHSZoXVzXdUylj5Tj/Wit5kkh6DO9JjsEb1uJP+g1JB+Ev2+q4EdHwwJMHtVjv63Ed7C8o6WDNbN8Y6l+CD7NPx3vdvzazE0vnD8FHO4fh+v0Zoy4/MbNnIs/QqNtwMzsq0mYFjsWH5cJ7hHua2euSLgGWAG6iJEjMbI849106qjpeBvY3s0u6uNeDu3gcBwMjcVXbRfX+aF0977iv5SP7XWb2WuX8lfEG4k4zO1LS5rgd6XngS7jAB9gCeMXMfhbnLYwL6TnMbPFQ92xgZr8tPZPp8Of1KbV3ZLCk2/DnfEo8q5eA7c1sCUkjzayu7j/KPQr//c+LpM3wHvu+pTxP4A3dCEqqtPgtd8YF6cxm9mVJCwEnmtnqce4v8E7AGsDhuIrmH7hK1+ioFjJcSE0FfJvGKrqiXtPgI8NuReaW9CVgbvy32LJUh8FR90Ui39r4ewBwg5ldJ+l+M1uqQbnLhsA6FVffXU3H9/tPLdbvKVyVeLqZPV85dm+UWbdsSWfhz+xKOqoBW7p2d0kh0iJh49jDzI6JXgRm9nbp+N9w/eRqZva1Qh9uZsuqidG9tD9/vesWjXQp39T4cPvt2Bfe420ovCSNMLNlJD1kZt+ItHvNbFkaEL3FDfEGZTa8J3uhhZFT0k/wXu70+B/wXeAIM/tb46fYofztGtzvmXFP81pzQ+3CwC/pbJhv2kOMEcK38JHIAsDT+AjkP3jE06o9qsPzjrSZ8EaxPKq7jS6QdJ+ZDWuUFqObXwJ/LxopSY+Y2eItlD0/3mOdCm/sZwT+GqOTD3D1SqfTqHVUNsYbbXDV3WWV8u82s282uPYD+No+d5fq/bCZfb2UZw1gzbjmdWZ2Q51ypsdHFj8GLsPVV5vjNqJhwLbAwsWIX9IGuC1nKjNbQNKS+OjjDuvaoWQ7YPsot2wzfBe3PTQcuUla08yuL+0vincItgDeMrNhDToz6+BOHXUpdaAG4gb9nze4ft2Okpn9ppXjPU0KkW4g6R4zW67BsZFmtnS5lyLpwXo9wXhJHjazReuUMzu1xmktmqwFYO5V01B4lcq8y8yWl3QdcBxuoP6Xmc1RUf+UOQwf+p8fnx1elOJPFioszOzdOvdyXJ1y38Yb6yua9SKrjVCd4w8CJ9K5ZzwijnfpRRXpQ3HD85646mvzRteM513X064svCTdQn2D8ZzAulZbRG0B4Boz+1rs3xudjvI79ADec2/Gg7jheKt6ByU9ijdgjfgBcIGZdYqArZr30qb4SOBSOvZ+RxYCpqi33FA/suiwdEWMdPfChcQ/gGNihHNfNMjlzk/52YzADeDDy8ILOMDMrmrWUSld+weNRrdq4qwQ700hOD7FOzPDzOzpShnTxzXfa1SfBvX6j5l9q06dBtLkt54YpE2ke9wp6S+4aqg8TBwJfBo/cKH3nQ2YLVQQ00h6h9qQ+RMqgdGiV3U0MBfwKv5Svo3bUWbHe86FL/mquN72UnwRrqXl+m/MPUjKdgmor4O9OI7NQGcM7/0ZPiT/auX4ovEnKte/dnJt2DwIWCTKAm+sxgBLSNoxjk0FjO9FWs3zZmShGqhTP4BxXYx6ZrMGXlRy77jCLrIiMAR3JngDFyjNnncrnnZl9+hBcd/jorzhkkbj78L8eK+74DVJX6b2Dv0QV0vV8yAq3ZqtpuZ68E+qI9oy0RG4XtIb+Lt9kZm9Eoer1y6PpAovplslHYC/52sAP8UdGoryN8ZtVrPHfRfeVwvi7+RmuJF8qfKID7dJTQU8IOkP8SzKtppPzezt8rsXz+Oq+FJulAfgbsXvVDJfosbu83+hzkhI0n/w/9D5wA/M7L+SxpQFiNy+eDYwc+y/BmxrlQCxjeoV91zXU6+L37poe/apc09d2XHaIoVI91gyPg8tpRV/pOPwIfjskn6Hu4XuaWYXqbnRveAwvFd7Y/TmVgW2NrOd5DaNRc3sJaCY83BGnFdPeH1eLtjMCnfZt/EGEbnaq+4QV9J68Seqi6TPcaP4tdTsN/X4BrCiuaG3UPndjqtN3sPtA8OjHg/IDZ8F3wS2kvQM/icar3qJ41dJ+in+zMs94zfi62cqzTEIdY/Fn/lFXH11G66C66Dq6eJ5f2RmH0lC0tTmcw06CNliNFTizhjF7iO3FywS6U9U1Ge74p2LRSS9gAvcrau92waMjuvU04Pf2ezEeAd+I7fBbIYLhefN7LtmtmoL194Pd7d+GBeK1+C2mYI/AOtbbT4PAJLex+dHnA58gDshlLNsg/f+d8NVdPNSmw8F7v67JTAwnuseuLAvyv8HbgP8DF82YrCkYy1sdpGnmTt3I2eFZ3B7yhy4qrfTSB3/Hfc2s1viOqvg3mMrtFIvvPF/ndJcsrjGpTT/raE2D2U9Gs9D6TFSiHSDZn8oMzs3hter4w3eRsWfxsz2j5FGMZt2eKlhL/g0hvADJA0ws1sk/TmOzVs0aMEruOoFasJrjpLwOhBADXTCwdaSlq4z/N4hzv9nJX0I/gfeElexXY+7J47ADbI3WWfd6Ey4zaToXU6HG18/k/R5nV5kWfh1UDvVoVAN/LKUVvRuobEX1V2V3m49mj3vLj3t1HFm/AB8vtCMkratXGcJSZjZWQCh5vqu3B41oKoilHu4/R+l9wi3n3wK/C+2AXQeXY5RY7VlufF5FTfKv05HTzgk7Yk39u/ijeHSwH7mtoGNcBXLyQ0u8UpVgARHUXs/O42IS6OnD4F6+vzd8d/5Y/wdvA7vjBUsaj5PZCu8w7Mf/r6WG+sVzG1CD5nZbyQdHXmhwUjIzDaKkf3GwCEhwIZIWs5qtsjpCgES9zJcNa+0LutlzT31mv3W0No8lB4jhUg3iBfnYGp/4lvxRrz4s79KzcMFSTOb2RuSDscNj+fGoT0lrWCliUy4i+30eO/4XEmvUutl3CS3Z5S9Z26E5sKLmsFwRdy994LY3wRX31wvaV0z+2/Ud39cSKwc+9PgxvUtcV/2GfAG4zYz+xzYT+7CuwXuAryvmZXdWP+A/wGHR91WAn4ff6b/NetFWs3rq2wjonR8gWpa5fi/5Pr8wotqL3N34OMqgqt63h40f97fj7RD5LaPGYF/VYoZQc3raBy1iZGblfIMwn+zkXJvr04U9Sw18n/DR4CFG+s2kfajeiPKEtM3OUaM6DbFe9UXATub2WOVbDua2bFyd+pZ4tpn452J9YFj5B5iF+D2tnGqzZS/T9IFuOAtjxoP6aJeY6hvGF8wPj/AhcivGhQxZQjejfBlsz9VuBmX+Cg+67lzNxwJRUfkdHx0Mgf+/I6J0e+8wGi5l18xWXNrfATRUr3UJGJDF7811Nz2X5Kr6l4k1Gq9QRrWu4HcLfUR3Fcc/CXbB++p1muZzMwWlM+SXTIa3sI4dn9JNVN4Q32I9y62whunc83s9Ti+Md6bBm/ELyud2zSkhKS7gG+b2bjYnxJXK/0K+Dv+Mv8IF3Trhv3gH3G963Hd783AqHLjHdfaFBdKnwIHmdldlWc2Z5QLPunyxUifNq4/3mMHOMzMPorj9WxEj5vZYqXz98YN87uEIPpq1LFhOAtceD4CXIj/uaoK9TOj/O9T6yzchncYGlJSo7VMjGjOpzY/pVHZhdfNg2a2RKWMwnmjrjG/FT14dHIuMLMHmuR5KHrsx+Ij6cvU0cg9JbA2Lii/jU8AHdiovKjre11UrdxYDsLfs5nN7NdxzWG4y/lQOnroFUb4PfD5UQ/io+b5gHPMrPgfofru3CcX1+gukuY3s2fkjhy/oeTxBhwS/61W6lVW242P2GDuWdb0t5bHkLsdF3qFDfQ3lQ5ej5FCpBtIesDMluwqrc55DwGrFA1NqDuG1xMiVou3tAiVuSQNyj6YCClhZgtHb+oiM1uxlOdJ4Ful68+Eq3W+Kuk7uDrs38CmpUb8AVygnYV7NT0vaXQIxR1x4TEIN9BfaKXJak0acGC8I0JT5N5Xq1HHRhTHL8B7/Nuaz6mYNu7hnhAqt9Qp1vCGaBO8sRuH95wvtpIRPhqWM8zsuVLaa3hEgoadhVLew/AGo7AFDQaOraooouF91MwWpgUkjcQ9zv4X+wtG3ZeWtEwp63hjvrkdplGDOA3+TOqGySgLxugZzw0sgM/vGYi/w8uU8kyJexTuAKxkZnVHWKX8LXsrlc4ZUVwz3utf4raYz0vnNXMimKLUmRoALG9m/479qfFnd7KZbarGMfOeaZBeXL/bMarK9WpwfADuurxCF7/1+KkI3a1Du6Q6q3t8KOnbZnYHgHwWbzG7ueg917N7HI7HRbqFmlpnv0rZ1XhL9+IN3VZq4N1iPunq+7iqaSSe+KIq0W2BI+pc/0uqeYxNjffEXpXrUMzcjXERXFV1YzSiM8TQ/RS8N/8MbrtYs6IiKq4/CBdwD8Z1voGr2L6l+kHi3o7jf6e5jQjgy2a2maQt4r4/kCQz2yX2mxmETwROlDQP7n3zmFwVV6gedgc2l7Sb1fTaz1qTCXsVpgDukduX5sC9fI6v3PNA3HX0wuIkud79t/g79S/8ef3MzIrJib8EblFH764d4n7rGvPj+/t0Zroob0A8g6pwLNuXwNVxSwKj41nPUlxbPiFvMzy6wXD8/di0dF9n4k4mZXfro63rwJHl5z0Af5fKbdbYZr3reFd/D8xlZmvL53N8CzgVIDpsJ+D/H8ydHD6W23+gFjOvytAm1d4trt0sYGXTejVgfMSGZr+1ub1xC3wybZ+QQqR7/AQ4SzHZEHiTMPBKOgJ3/exk9zCz8+R2gWLuxr5m9nKlbMWfcyd8ktgfYjQADbxbgi5DSoSa61rc46nR9TthZk/gNqCDo/ezJS7cHsMb2g7ZS/dxa9TlUmBpi1AucrfHQyLfaFwHX7Y7vIsHnjuZmo3odjrbiAA+kdtsivv+MiV9uzobsYt7OiuOL40LyDVw42b5j/kCbgu6SNLF5l4z0zYbYZVHV+aOFDfiE8vexHvlo6JnWzAOFyRlO8ma0Zv8Pj4JcmO8c3FOlHuTamo78PUzPo77qWvMj/PGu+lGB2NPXAAcjTfm5ZAnHVBEu6XmmbigOtuUtsVHdD+2ymTN4BvW2d16KTUIA1Oi3Bkahz+TTUtpB0s6hc5RD4qJgmfgdovCZvJU1LPcWN8UqqNLLdQyVnOq+KmVZu0DyAOHnmANJsJKKlR0zYIgdlkv1Y/YsG8ca/hbB82mIvQ81oeBuvrrRingXuwPBgZX0h7CPTeK/YHUAvhdgk/2GtDkGvfjvZG7gMUi7eH4vLPJeb/Ae+6j8Thad+HD2Wq+ufG5DysVW5vPYkp8QtiupbR7cOPxaFzdUqQ/Wuf8R+Pz3jrHikCVj+I95YF4R2c73PA+SynvGridYiwuuJ/GVYbF8eNL28lRt4tx9+wReMO8HjBFvd8iPgfhf/bCV/+WBtvNlfNXinvYP57VtXivE7zXe1TU9xZgt9J5j8TnKcBa8f3B0vFdgSGl/Znwho7S8x+Du5xej9vBirwz46OcMbggn6lS5w3whu+PwHql9JPis+l94yOu9WKbvVL2g+XrRV0ejt9uJD4iWokGgRabvIvn4CPXM6kfsLJ4n8qBHx+olPEurgr7lFoA1XfiWKdAo/j/fGRp/5IGdSs87MrtwQyt1quL++7qt+7yHe3JrVcK/aJtLb40D+FGv2J/ZmpC5Lt4Q/c/XLX01Trnr4zHutk39hcEjovvx+K9ii3w3unGlCKz4g3qUbF9t07ZR+KN1tX4JLCrgCu7uOfBeCP4F2rG793ixX0dd4Md/wfAPXbmw119i/Tz6Bxl9bw49jgdo+HOhxvOx/+58HkkG+DeP1+qU8dZcMPkeniI9mb3MwRXEX0ev8PDsT0U28Ol3+vkyrm74mqcVt+Xe3A3zvL5Y/GQ+3fgo7hn6px3ROS5HxfWsxGRkIvnXOecTpGl6+Q5Ku55X9zpot51b8Jnxu+IG8V/34373QRXbZ6J29DGAD8sHd827uswXJA9Qc3zaa047/44tljpvL3rbDvhTirgI7Fm9Roe70gRVXl54NYW7uf/4n14v/R+PBT3dQ4dG/+6zx/vzE1f2p8eeK/VeuFq6hkr7+9G8b1e5OEiOvhAXAXad+1jX16sv24tvjSbxx/pjPhTjAE2q+SZEVeJPYcbgXfA10SoljWA0kiH+iHCi55TOfx8sY2Nl3j1OL9bYdfjnCviXn6M6+2H4z3/JamMInA3xeL7XaXvg3DXyMti+xm1MNvrAM/ivaTh8ezWxXtwe+HeYs+WnufTuJspRBTZ+D4vPjdmqS7uZ8p4DvM325qcv1p8blxvq+QdWNn/HJ/w95VSWl2hhHc+Bsb36SgJT7xhK4fkH0htZNdslPI5bmd5t/TOvFPabziKrvyWe+OT3S6J36j4LbsMJY+7mO8W26J17ntqPJbVWGJ0ho/iniLUbvH7XYSrVPfB/wedyiqVuXQ897fj8ylctVbOI9z99qDS+7Qqbvc4r/J+zBx5yp3KussiUF/gf9CNejXsMNS7ZqVO93Tnvz6hW59dqD9vXb001NbxmBPvOW9ApeeM9zz2xIffV+K68ONxA3zxhxmMNxyP4RFff9lmfQfiHjSFeuRa6vRAuyjj4Up5r5YajVFNzvtfZX8q4OvA4lQEZjQcS8Q2qHLsSTqqr2aJtJ3x8CTPxvencDfZJ4lRXOS/Kp7zlfjEydH47PR6dZ6Vjo3zQrjq67E4bzTwRhyrJ9BPq5S3MN6zL57/nnhD/Rw+GlsdGFOnHiPwkCEzNajnUbhAXz22C3GbRtNGp4XfuuEoupR2Ia6zXzW2k3EvwA7vSun/UH5/vkytp7wKrpocUnoHNqYmHA4C5o5jt9G5N38r7lX2GD6a/SR++w6jydI5U+DhPzq9f3H8b7hrbzEKnolSJwl/9+fCR8rF9hk1IVysI1RVhd2J2wOLcobhdptiRPUL3CZyIK7O27v6m9Sp6+O4/eNxXC26dGyr4NEPinzH4BqE75TyLF0tr6e2NKy3xhIlT6YiDhaUvKTkS9FeSKziV0bSZbgx9GzcQF4Y7i6QVEwIbDiLNbyIjscnDYIbm/e0SojoAnPX0gflM9bBQ0o8IKlu2PUGfFrK95k8DEYxMetuSTtbZYayfA2TcvTgVaiNIgTMK2k7q0W8LYzEg6jM3sZVZuUZ28VCX3vhjdIM+J9pfvNJhNPijdCRkb9s2ByHq4+elwfVOwIXRIfhv8mswABJ25rZv3DBcDD+Z1wVHzEOiGfRbCZxwclENN4451h5uPRFcIP9Xnh4nL8Bl1ktIuxmca174704HQ+maXF8X3xk+H+xfwO18CIDwzvNu9fu6jlVfG800ewP+Kji9/ikx+E09h5c3DoGDL1FvnwBwL/UeXLmtaW8lwDDJH0lnsmVwD/C429xPEzKb8zskco1Z6fjejOf4mHyP5T0MT6/qSuWozaPZOnKOwZNYs9J2g23H3VYQdDMms1/KdgLd8woVuOcExc0RdTrMtPWOf8+SX/CBRz4SPM1/L2eB1+MruBdfL5MQbPwTD1OzhPpIcI76zU6e0S8IWlVK4VAaHD+o/iP/w9cPXSrahPJboj08uzXrcxsjRbrtl29dKvjh18657PSfQjv/X1A7Q/wMP4HLzw+lsF7lRtZBO+Tz6Tf0iprYJuHpT8Y70Etijcia+P2gmLW+pL4COYK/A+wId7bXMIqUZJLda67zoN8RvjrZmbROBdropyEL4F6V7gzn2c+J6UInT8+krCk52jiNmmltRrUIBqvleYThZvrJrjKc/VyWfI5AevhveTPcGFyrDWZ0ChfE2R+QnDhwuZZM/uFajO/q41XMfJ9GR85PY3bt+61iveepHPw9/Ku2P8m7lyxbez/gI6dnMtLAq2IcL0PPhfq+Gi0l6D2jpUboiJA41G4beCKSF8fF0BH4wb/rSQtQW0S7u1m9mCpzmfjHY4HKC3BXO48Sbobdzi5N+o4Gy64l5I0Chcyr1efdyMkLQs8Z2Yvy+fN/BgfaT0GfMcqk0WblDMdPir7bjyLG4Dfmdn7ahJ5eGKQI5Geo3DV3LWUZriB/A75LNVyuJQTreNEwr/jf+IHgdvkAQOLEc9sZnZ6Ke8ZkvZqtWLNhEWTc7rsbUlajdra8leb2c2VLM3WwP4h3ojcb2Y7hO/8OdTcOov4QAVFQ7K8fH3rAcBUqq11LWBQVyMN3Bvr+qj/oUWjaD7LvbjWx9GQ/zd6oy/gQnQGfOS0LLUR5/qURl9Bo2i84zGzN3EhVo3m/A18NLIO3oM/F5/1fLOkXWmwuiA+StkFt7mBC9wvxbWahoiJd23z2LbCRwnnmUenLSbcTYmvvvls7M8PPBEjnpmiUbskevHb443m1+ISn8rnLmxLbb33Kc2sw+qJDer2L7yRB18ErRi5byWfz7EztVUbz5F0kpkVI/Bh+Ai/WU+5XuDUA+NYs9UJG/F3vOEH97Y8AHekWJJa/LWmxDP9pzWY62TNIw83nB9jZs3mobRPb+nJcuugyzwFV+usFtvp+Ep5XZ03RXzehI8+Bsa2NSUvqBbKGUNNtz9+64P7brgGNmH8w1V2g/EG8YkWyryli+0+3JtsE3yOxvJx3iK4B1BD+xY1b5llcbXDPPFbXVoq5zbCVTP2Z8DD0JTLWRCPtfUBLoDuoInRvnTeiPitt6TiCBF1eAIfsc2O24hmoaPdqHAffoaS+zAd3YgX66IOS8VzKtabn7/JthveyL6Id4zWxG15l9HRHrAo3lhvEfsLULJftfBcZqdkkyilP4QHOiz2p6NkS8DtLHO2UP4ieOdvN+BrpfRT47fbn5KHWBdllV2yT8AjFxT7D3dVl1Lemyh5Z1WOnYh7wT2Hq10fBk4tHb8Wt9E+GPtTdOfa3d1yJNJDyEObnIfHICoWHSpCGSxrHYexN8vDeiBpazM7R42jrP4Jd7s8HlenGDXPrlYprwExPgZRN85vl2ZrYN8njx11Mt54vkcphpQaxwfq1DuTNKfVwrY/YM1HGs3sW4MibxHx9D06P+c5cGNuwSeRVq5jp2i8MXIsz7iv3sMA3H28ujZJUebG8sWfrq2ct3CM0LoCXgAAFR9JREFUlragpk6tPqcdcUMr+Mhs6UoZU+DCaXPcYD+cmBRqtUCY9XrRuwPLmE+kXBr//X5osZ5HnDcQ+JWVFlEyj+t2ZKfSKqhz/LT5cEFajH5FaUGy+F5W2c2KRyO4h462wPFhSWLEOMbMTggb3hqSXjKfHPlsbFPF1goDS//71fHR4fjLtVgG+Lv3cKiyy+rxPWgeeRjc3f1CeUBVzINhfkYvkUKk51gfV2ldJF9v4wJ8ktzX8bUtvmwdYx4VP2oxw7xeSGdg/B+52/F4SudXdbp/DntFW0HmunHdj0MvfbaZja0c+2l8PTFUFoPN7KFSlkYLO9XjamoNYzmc/IeVfGZN1HSSrlSTWdTR+JyFhzQpAmBuRC0gZzV/eYb93jQRIuYhODam8wJXZW4J20d5dcH7cOG8nsW6KJJ+1qSM8Q2ZfAGpLXDV2T24l9sulXoXXE3NrjIIH018WlzTfIXD/5YFSKR/pi4WUWpC3TV2SsdPx508yr/FaaXjh7RwjbpGf2AdqwW+HL86YQvlnYeHXn8Nf/9ujzK+QvdUY5dSU9NVKd7rIvLwG9QiDwO8Lw9LU6hTl+/mtbtFGtZ7AXloioOAbcxMYTs4g1oo6KHADta1sb3ZeiBFr6SV+tSLQfR/1qKRr7vIu/wH4+qBQu/9GXC81fS2Z+OqodvNw2q0Um7d5YkrBuzCIaDsDEDsDzKzKavnl8oZi6sIzsNDllQj/BbhXJahFp31NjO7v4W6P2ceIrxZnobOGXG83vsyC25/WBGfTHk+riotR1seja8gOAD3yCrWYPkN/hscaG6jaZl4p27H3/OCvSl5DVk4G0g6C7ePNFpEqdE1iuVxH8TnAX2uzs4US9MxUu5TZSEY9p6FzOxGuQffQCut06IGRv8QWh1WJ8R/m06rE9ap9/J4o359URe5U8n01o3QI2qwfLRqkYdXo+a9dYqZHVR6Jsfjnm+P4PN2fljppPUYORLpQeKF3Sy2z4C3S2qqv1MLjf0Zrnu+RY0jrIIP44ue8W/whrkdykucFutbbNogb0/wM7xRWzZUF8Xo62+SfmYeYfQ03Kvm+FAp3I83yMdG/mp8oGF0jA9UZryrcbORRgt8CZ/9vwVul7ga99jq0GiY2Qi5t9agqOv4FRSb0EpvrZlzRl1VXkGozhq5D99KbSR7GzXj9n3ANN0VIFGXkfI4UeUR9MnUH1F3tYhSIxrGT5M0N95QPxR1mR2/9+3x/w1yt+pdcCHwZTz0z4m4mqmgrtE/PhuuTtis0lZZDiHSnurGfSNpfdydt7x89HF4pO3DIs/0uD3kCWprmTwbz2Nl3AlE+Mz+ptHAJ4QcifQQclfBKXFj3gVmNlrSS7ibZl1daOgzf17n0HR4eIdZzGz6KL+u+2qLdSuW9+wT5O6ba5jZa5X08e6TRb1wI/aquFfRh2a2SBwr3FKhFnzvUKtFUP4y8HyozFbBI96eZaVAfxN4D1PjwuQofA7DXyK9rp7ezBZT56B544vDG+u2Om3qwm5W7dGriftwu1SuXQT9m9nMulqBslxGd9RCxMjhIxg/q3ww7q22LT5RbxTuVv5X3MZyFvCHsn0Mnydyd+mdG++2HfuL4u/ef8wDpS6AN9RHVkc9kb9TWm8Q6ubV8MnIRd0/xCdiviFpJXzUWXh+fQ1Y0CLStKRLzOwH9UvvWXIk0nNsWx12Ai9Zk7XKoWmE1fPpOIKYEGn/X/mCWqdZ/UjAPc2UVQECYGZjFS6+8omP0+HG2NvxUcurqvnZLxD5tsPtIU/japuChrrsCal4CI91cQEylJoLaEFDPb2ZdaeX3ej6K1BZZAlXy0H9Xnw954MO7sNqENG4ln18CPxmVCPq/hP/DbqkqhYKe0FDtVADYVx0xH6NvzdbmtnlcoP/U8CK1jlE+sdm9onCdVvuQNChXPMVHPco7ZeN/s1WJ+xtPrXOy0ePV23io9aTrOZa/QAd721B+ogUIj3HW5JOpaNv9iytnBiqm71xH/0zcffIbqsYmrAE7nlzqtwL6DR8oal3mp/WNs0MqMWxh/De7OK40e8tSf+h5Gcfva3DqfW2TsL9+AE+N/c6+T4+Ca6YwNY2obtvNoMaul7nZEKu33RynNVZFlWtzRdatkH6BriKp0shUr52vEPTWy2CQVd0Sy3UTBjH6PURPFjj5Wb2rKQn6wgQcAP3AbgX3hp4SJkOhn+5/fJw3A25POdiQdyr7Te4gdvwzk7TNVB6kEfVefnoD9XY82sKOv7v+kzFlOqsHkK+XsfpuDvjEtHrecg6hoqod95R+IzWk/B1Ct4rHSv3yKalo5HYzBel6m49V8Z77EPw+FCHWXjY9BTqONu9wyEqxu0YfW2Pe2N9CVcNLRHHTsAXHjok9sfP+g714Z9xtcb6ZjZG0iNmtvgE1PtzmsygNg9vcyPuBXQ47kL6Kj6Kaqonb/H6j9P15LjqOc+aWUuT2CK/8M7KvvjI7netGFzlyyX/BBdu9+KqpWPN11rp6tweVQuFbeSR2MA7SOcXxwuhG8JuJ3z+CsB1ZnZKqaj/b+/sg+0qqzP+e4x8yZdja22tFjSIKIghUGpEHASltRAoDA6J0/JR2um0FohKUTvMlNphQPtHq0htdcqM/TBQkQAFB6EtkUhADBATKdCgpXVKhpYiLejUD/L0j/WenHNPzsc+5+x9zr256zdz596993nfvXJzz1n7Xe9az0LSV2lL3KykiKISQpCHEHsO1za5p9AL9W4f/cNy/DQRRl1u22U1/jlihdwvqWSsz4tKtqYTqQdVkLroM24Hka75Y/p8cNVg2xIiRHM+ESr5ayK2fDwh+V2pPWudKGobjidWI08QT3kbiPDRsrLKeJRIOb27jNnpJAbFshuy9xCiHmQzkWL5IuLD+CCiWr/Xk/Co9/gC0Qtm+9AXt8cMzfoqr3sxbWd9H3Blj/DroPGbbS9TaLstJ7S1/o0BzZfczs5aR8jjdIaFjrZ9RtX7d9nSU8ang2eBV9m+prz+fiJDycCltm/omKuXxM0zxGp0A1E/84TtygoRTaKaMr/qJMNZ9TFWbrYrSD/UwDaigvmPXfpJF24oIaNZsDeRDvqAO3pLS6qUZ2/7nyV9iCIl4YoFbBPwp8BH3E4f3QF8TtKbiNqOlX1HDkHtVqr7M6Q4rgdDnwIVcikXE1XQv2T7iTHM3KPsZ/0KET78UXnSryIFU2tYyENkfCTdQ6xOWuxJPKzsR0QLbui41kviZl/bv1rm+kt2lbVpDA3p9tjrb8EjZn7VTTqR+vgA8SZaWv6IX047fj9rjuyXEeOKtSYNsI7Irvqx5mZXXVE23VtPW60PyRfR0ZJXvVMgPzrkA3cSXuHS5rcT21slHTzh3LcQq5wNXeePB7b32WiGdthiGFcTYbe3Acd1bNa2VrtHVpijl7bbNkeG4d1EaOU5AEmXA7dJ2ptYLbbCQh+cUlhoT9vf6Tj+atmQfka7to++mAgVX0QkTZxIpMADO6u9m7a3kxUMqFWaj2Q4q0ZKyGAqudkV7amlWLEJSjbJMUR47UuEwOLhtitlV6l3CuREeyJD7rfN9uv6XHvc9iETzH0rscrZ2nX+TUS4cexVTpnnoEHXXaRNhszxmrLaax2LaLK1TdJjxINKq9/7XkTixGZCvn2qYaFB/x+SvmV76ZDxgxSsG9tbKPdeQrtW6Uj61CrNJ3IlUi/DehdMm00dP09SrNgEndlVV4+RXdUrBXJHvxfXwCb17qHyG4T21yQ0ucqp5CQq8EU6NLfKhu51RJionxTM6o59hmmGhYb2uxkSNrqtwRXtQBz1XLcTPVpatUrrJe2sVZpvpBOpCfVJzyTeYDOhM3Ysac2wWPKUaVUKn8uulcJV6JUCuXHImElYA6wrG8stp3EMEU4ba4O4g5cOuFYlXDWQIeGwgU/Wij4rhwMHKrS9WhxAW7DyCoX+WUt+5HzbDykk8CmvqT0sVMJlF9AliU4oJtxU/j526XdTjudt2EjDa5XmFRnOqolx0jOniYpG0KztaDFpdlWfFMg/cvXahbFQFBe2QmYPe9ceKuPMuRb4pz6rnHfZPrv3yOaRdDrxwXsac7t2PkfUGm0sr1tC7Ot0Ppj+Kw2GhUo226OERM1HiWy5R2xfXK539ruZ8381X8NGmlurdJ171yrNK9KJ1MQ46ZnTZB46kaO702IlnWr71lnZNCsUTYTWEXUAu6xy3NVlcBZIWmH73j7XLiRCpU/RlmOvumE/iU0tocQtDmn0PQhBz7eMOE9PiZtZoAq1StO3ajDpRCakKz1zGRFzrZqe2ShqoFixLiQ9SEhffLMcrwbW2P6FIeNav++ezPL3PSlNrHImRdKltj/eL0nD9kUao41sTbbdb/vYkh32O0Sb3/sd1eZVxneHjW4hCgv/oyGTd0tyT2RyBqZnTt+cNq5By6lBziLqVN5L/K7OoV1ZPIhWcduZRIX735Tj1cST8ILFIQsysD3ADGhprW0a8Jpx2sjWwWcUYpOXEe/D/ZgrTd8XVZO4SSqQK5EJaTo9c3dGUWl7E9E97gzb3U2kBo3dZPuYYeeS5imZV68n9hU6V+ED+4VMcL+LbX9C0nG27xlzjgUXNpqv5EpkchpNz9zdkLSVuW/alxF9Vr5WUqKrxtH3lfRat1sRv4Z2l8ikJipWUI/TRnYSzgc+QRRRjrXP5+koRSwK0olMTqPpmbshp9Y0z/uJ/PlvE0+PBwG/VdPcSZuhqbDuoS7cMI9I2ga8UlKneORUNvSTuWQ4a0Lmc3rmfERzOxbugtv9EqrMtRdwWDl8tFUxndRHlVRYRbOxS+mq17B9YoN2/TSR1t1LS6qO4sqkIulEJmQhpGfOJ9TuWNiruMsjZNa8hNArO8j2b5aCw9cvxhThadEvFVbSHURf+EuI2p9zCQn/D83K1mR6pBOpifmYnrk7I+l6wmmfY/uI4lQ2eoj0fjI6w1Jh1ZZT39IKJam0RmjInu59tZ2XyHDW1Mk9kZqYp+mZ8xpFv/KWFP36EVcRS22fXepLsP191a2rkVRNhW0JjW6XdArwJKUVbkPUta+W1ECuRJKZIOkqogfF35ZTq4Gv2/79iuM3Ei1C77G9XNJSIlZ/bCMGL1KqpMJKOpWok3o1kTF1AHC57TmtaKdg69sI0cf3TfO+i510IslMKFk1y2zvKMdLgIeqhiIUPbMvI3pj3wEcB5xne30zFiejUAQ/a+k9P+Q+RxHaWe8htLputH110/dN2qQTSWZCcSIntLKxStbW+lHi2YpOkm8hnorvs/10I8YmI6MRe7+POPehxMp1NdFv/HrgEtsD+6YkzZBOJJkqkq4hag5eBVwFrCecwNuBD9u+vuI8ZxCp1f9Tjl9KOKWbmrA7GQ1V7P0+5tw7iPDZBbYfL+e+XTWzL6mXrNpMps2/ECmiVxE9v79F9LxeUdWBFP6g5UAAbD/L/Gq6tdhp8un0TEKX7i5Jn5V0EvOoH8hiI1ciyUxQtGxdVb72AT5PbIxvqzh+S3foS9JWl056SfMMaXa1j+1Gsz8V/dJPJ8JaJxIN4NbZvqPJ+yZzSSeSzJyyOXot0ad7ScUx1wLPAteUU+8DXmb7vEaMTOY1Rc33PcDZtk+atT2LiXQiyUyQ9GLg3cRK5CRib2St7Zsrjt+XkP1+J/E0fCdwhe3vDRyYJEmtpBNJpkpJzV0N/DLRwOs64OZRPvxLOvA/2H5HM1YmSVKVrFhPps1HiP2PD9r+7jgT2H5B0g5JB3ZuridJMn3SiSRTpUZl1+eBrZLupF1Rje2Lapo/SZIKpBNJFio3lq8kSWZI7okkCxZJ+wA/Z/uxWduSJIuVLDZMFiSSVgKbgdvL8bJhrVyTJKmfdCLJQuVy4FiiVgTbm4GUvUiSKZNOJFmo/KhHZtaOmViSJIuY3FhPFioPS3ovsKS0xr0I2Dhjm5Jk0ZErkWShciFwOPADQhX4f4E1M7UoSRYhmZ2VJEmSjE2Gs5IFxbAMLNunTcuWJEnSiSQLjxXAd4gQ1tfIPhJJMlMynJUsKIr4YkvE8UjgNkL99+GZGpYki5TcWE8WFLZfsH277XOJ/uqPA+sl/e6MTUuSRUmGs5IFh6S9gFOI1cjBwCeBdbO0KUkWKxnOShYUkv4KOAL4EnCd7W/O2KQkWdSkE0kWFJJ20JZ+7/zjFWDbB0zfqiRZvKQTSZIkScYmN9aTJEmSsUknkiRJkoxNOpEkASTdJekXu86tkfTpAWOekPSTPc6fJunDQ+73/Ij2PSFpQ9e5zZIGJhZIOkHSraPcK0lGIZ1IkgRrgVVd51aV8yNh+xbbV9Vi1Vz2l/RqAElvaGD+JBmZdCJJEtwAnCJpTwBJBwOvBDZIOlnSvZIelPQFSft1jLuwnN8q6bAy9jxJnyo/v0LSOknfKF9v7b6xpN+T9HVJWyT94QAb/w44u/y8mg4HJ+lgSRuKLQ/2uc/PS3pI0lJJR0v6iqQHJH1Z0s+M8stKkhbpRJIEsP0McD/w7nJqFfGh/RPAZcA7bS8HNgEf6Bj6dDn/aeCSHlN/EviK7TcDy4E58iySTgZeR3RpXAYcLentfcz8InBm+Xkl8Pcd1/4TeFex5exy3877vBX4c+B04N+Bq4GzbB8NXAtc0eeeSTKQrFhPkjatkNbN5fsFhLTKG4F7JAHsCdzbMebG8v0B2h/wnZwInAMh2QJ0d2M8uXw9VI73I5zK3T3m+m/gu5JWAY8A3++4tgfwKUnLgBeAQzuuvQH4DHCy7SclHUEUbN5Z/k1LgO097pckQ0knkiRtbgb+RNJy4CW2H5C0ErjT9uo+Y35Qvr/AeO8nAVfa/ouKr78euAY4r+v8+4GngDcTEYb/67i2HdgbOAp4stzzYdsrxrA3SeaQ4awkKdh+HriLCO+09hvuA46TdAiApH0lHdpnil78I/DbZewSSQd2Xf8y8OutfRZJPyvppwbMtw74eBnXyYHAdts7gF8jVhctniW0xq6UdALwGPBySSvKPfeQdPgI/6Yk2Uk6kSSZy1riaX4tgO3/Ip7610raQoSyDhthvouBd0jaSoS83th50fYdwOeBe8trbgD27zeZ7edsf8z2D7su/RlwrqRvFPu+1zXuKeBUYhVzFHAW8LHy+s3ALhvxSVKFlD1JkiRJxiZXIkmSJMnYpBNJkiRJxiadSJIkSTI26USSJEmSsUknkiRJkoxNOpEkSZJkbNKJJEmSJGOTTiRJkiQZm/8HiWTvdJRIdH4AAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lHB4ryefI2ru",
        "outputId": "5f85288b-7c42-4e63-8a3d-81a507c5e6e6",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 365
        }
      },
      "source": [
        "body_count_df = sampled_df.groupBy('body_type').count().orderBy(fn.desc('count')).dropna().toPandas()\n",
        "\n",
        "plt.bar(body_count_df['body_type'],body_count_df['count'])\n",
        "plt.xticks(rotation='vertical')\n",
        "plt.xlabel('Vehicle Body Type')\n",
        "plt.ylabel('Number of Listings')\n",
        "plt.title('Vehicle Body Type Summary')\n",
        "plt.show()"
      ],
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZcAAAFcCAYAAAAESfN6AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3dd7xcVbn/8c+X0EINJSI9SFMEgRC6XikKoUkRISgSuAheQQXlquAVwY6VnyiiKJEgSJEapQREQERaAkioEiEYeiD0IiY8vz/WGrIzzJlM4p69J+d836/XvM7M2mU9p80ze62111JEYGZmVqYF6g7AzMz6HycXMzMrnZOLmZmVzsnFzMxK5+RiZmalc3IxM7PSOblYz5A0TFJIWrCP7V+W9KsOznO6pG+WH+HckbSNpEfqjsOsDk4uVipJV0j6eovy3SU90Vfi6EREfDsiPvGfRdheTm4vS3pJ0tOSzpY0pJt1tojhpcLjDUmvFl5/rIL6F5b0Q0mP5DqnSPp/3a7X+hcnFyvbWGB/SWoq/zhwVkTMqCGmubVhRCwBvANYBji+ysojYonGA/gnsFuh7KwKQjgGGAFsBiwJbAPcVkG9pfpPPsjYf87Jxcp2MbAc8L5GgaRlgF2BMyQtIOloSf+Q9Iyk8yQt23SOj0n6Z75y+L/CeY6XdGbh9Xsl/VXSc5KmSjqwVUCSdpV0R97vr5Le08k3EhEvAOOA9QrnWknSOEnTJU2WdEhh2+DcJPespHuATQvbviDpgqa4TpL0405iyVcT0yVtUCh7m6RXJA1tNMHlpsOn89XGxwr7LiLpB/nn+qSkn0sa3Ed1mwIXRcRjkUyJiDMK5wpJaxVev9kMWYjji5KekvS4pD0k7Szp7/l7+HLh2OMl/U7SmZJelDRJ0jqSjsnHT5W0Q2H/gyTdm/d9UNInC9sadX9J0hPAryXdJWm3wj4L5Z/Pxp383G3eOblYqSLiVeA84IBC8T7AfRHxN+AzwB7A+4GVgGeBk5tO815gXWB74KuS3tVcj6TVgcuBnwBDgY2AO1rstzEwBvgkKen9AhgnaZE5fS85Ke4B3FQoPgd4JMe+N/BtSdvlbccBa+bHjsDownFnAiMbTWz5U/Uo4Aw6EBGv57r3LxTvB1wdEdPy67cDywMr57pPlbRu3nYCsA7p57RW3uerfVR3E/B5SYdJ2qDFVeicvB1YtFDHL3Pcm5A+dBwraY3C/rsBvyFdJd4OjCe9N60MfJ30O2t4ivRBZSngIOBEScOb6l4WWB04lPTzLf7MdgYej4jb5/J7srkVEX74UeqDlByeAxbNr28APpef3wtsX9h3ReDfwILAMCCAVQrbbwFG5efHA2fm58eQPl23qv904Jv5+SnAN5q23w+8v49jA3ghxz8TuA9YOW9bNZctWdj/O8Dp+fmDwMjCtkOBRwqvLwcOyc93Be7p4Gc5BfhAfr45qZlM+fUEYJ/8fBtgBrB44djzgGMBAS8Daxa2bQk81Eedg4DD8+/tX8BjwOimn9Faffy8twFeBQbl10vm/Tcv7D8R2KPwO72qsG034KUWxw/pI9aLgSMKdb9O/rvLZSsBLwJL5dfnA1+s+39kIDx85WKli4i/AE8De0hak9R2/9u8eXXgotxE9Rwp2cwEViic4onC81eAJVpUsyrwjw7CWR04qlFfrnNV0ptOX4ZHxBDSp+9TgOslLZqPmR4RLxb2fZj0CZu8fWrTtqKxzPoUvT/p03rHIuJm0s9jG0nvJF2BjCvs8mxEvNxU/0qkK7vFgImFn8EVubxVPTMj4uSI2BoYAnwLGNPqCrIPz0TEzPz81fz1ycL2V5n9d9q87ekWxy8BIGknSTfl5rXnSFciyxeOnxYRrxW+l8dISfLD+apxJ6CKfqsBz8nFuuUMUtPY/sD4iGi8gUwFdoqIIYXHohHx6Fyefyqp+amT/b7VVN9iEXH2nA6MiH8DvwLWANYnfYJfVtKShd1WAxqxP05KXMVtRRcD75G0PunKZV7e5BoJ6uPA+cU3UmAZSYs31f8YKdG/Cry78DNYOtKAgbYi4tWIOJnUfNnoe3qFlKwa3j4P38dcy02ZFwA/AFbIHwAuI12ZNbSa5r3xM/sIcOM8/K3ZPHBysW45A/gAcAjpn7vh58C3cp8JuTN693k4/1nAByTtI2lBSctJ2qjFfr8E/kfS5koWl7RLU4JoSdIgUrv+q8CDETEV+CvwHUmL5oEBB5P6UyA1Qx0jaRlJq5D6l96UE8H5pKu4WyLin/PwfZ8J7El6s2zVX/O13Pn/PlIC+11EvEH6OZwo6W35e1tZ0o59fN9H5s7xwflnO5rUPNXop7gD+KikQZJGkvrPqrAwsAgwDZghaSdgh/aHACmpDweOoMM+LvvPOblYV0TEFNIb8eLM3nTz4/z6SkkvkjqPN5+H8/+T1CRyFDCd9Ia3YYv9JpAS3E9Jn74nAwfO4fR/k/RS3n80sGdETM/b9iP1DT0GXAQcFxF/zNu+RmqKegi4ktbNXmOBDfrYNkc5wd1G+oR+fdPmJ3LMj5GS7/9ExH1525dI3/tNkl4A/kgaNNHKK8AP8/meJvW/fDgiHszbjyD1jTwHfIz05t11uTnys6Qk/izwUWb/2+rruFdJVzxrABd2M0abpdExaGYVkLQaaZDA2yMNdZ6Xc4wBHouIrxTKtiENdlillED7GUlfBdaJiP3nuLOVwjcZmVVE0gLA54Fz/oPEMgzYC/B9Gh1Suo/qYFI/lVXEzWJmFcgd7S8AHyTdDzMv5/gGcBfw/Yh4qMTw+i2lm1ynApdHxJ/rjmcgcbOYmZmVzlcuZmZWOicXMzMrnTv0s+WXXz6GDRtWdxhmZvOViRMnPh0Rb5ntwcklGzZsGBMmTKg7DDOz+Yqk5mmOADeLmZlZFzi5mJlZ6ZxczMysdE4uZmZWOicXMzMrnZOLmZmVzsnFzMxK5+RiZmal802UJRh29KWV1jflhF0qrc/MbG75ysXMzErn5GJmZqVzcjEzs9I5uZiZWemcXMzMrHROLmZmVjonFzMzK52Ti5mZlc7JxczMSufkYmZmpXNyMTOz0jm5mJlZ6ZxczMysdE4uZmZWOicXMzMrnZOLmZmVzsnFzMxK5+RiZmalc3IxM7PSdS25SFpV0jWS7pF0t6Qjcvnxkh6VdEd+7Fw45hhJkyXdL2nHQvnIXDZZ0tGF8jUk3ZzLz5W0cC5fJL+enLcP69b3aWZmb9XNK5cZwFERsR6wBXC4pPXythMjYqP8uAwgbxsFvBsYCfxM0iBJg4CTgZ2A9YD9Cuf5bj7XWsCzwMG5/GDg2Vx+Yt7PzMwq0rXkEhGPR8Rt+fmLwL3Aym0O2R04JyL+FREPAZOBzfJjckQ8GBGvA+cAu0sSsB1wfj5+LLBH4Vxj8/Pzge3z/mZmVoFK+lxys9TGwM256NOS7pQ0RtIyuWxlYGrhsEdyWV/lywHPRcSMpvLZzpW3P5/3b47rUEkTJE2YNm3af/Q9mpnZLF1PLpKWAC4AjoyIF4BTgDWBjYDHgR92O4a+RMSpETEiIkYMHTq0rjDMzPqdriYXSQuREstZEXEhQEQ8GREzI+IN4JekZi+AR4FVC4evksv6Kn8GGCJpwaby2c6Vty+d9zczswp0c7SYgNOAeyPiR4XyFQu77QnclZ+PA0blkV5rAGsDtwC3AmvnkWELkzr9x0VEANcAe+fjRwOXFM41Oj/fG/hT3t/MzCqw4Jx3mWdbAx8HJkm6I5d9mTTaayMggCnAJwEi4m5J5wH3kEaaHR4RMwEkfRoYDwwCxkTE3fl8XwLOkfRN4HZSMiN//Y2kycB0UkIyM7OKdC25RMRfgFYjtC5rc8y3gG+1KL+s1XER8SCzmtWK5a8BH5mbeM3MrDy+Q9/MzErn5GJmZqVzcjEzs9I5uZiZWemcXMzMrHROLmZmVjonFzMzK52Ti5mZlc7JxczMSufkYmZmpXNyMTOz0jm5mJlZ6ZxczMysdE4uZmZWOicXMzMrnZOLmZmVzsnFzMxK5+RiZmalc3IxM7PSObmYmVnpnFzMzKx0Ti5mZlY6JxczMyudk4uZmZVujslF0kckLZmff0XShZKGdz80MzObX3Vy5XJsRLwo6b3AB4DTgFO6G5aZmc3POkkuM/PXXYBTI+JSYOHuhWRmZvO7TpLLo5J+AewLXCZpkU6Ok7SqpGsk3SPpbklH5PJlJV0l6YH8dZlcLkknSZos6c5i05uk0Xn/BySNLpRvImlSPuYkSWpXh5mZVaOT5LIPMB7YMSKeA5YFvtDBcTOAoyJiPWAL4HBJ6wFHA1dHxNrA1fk1wE7A2vlxKLnpTdKywHHA5sBmwHGFZHEKcEjhuJG5vK86zMysAp0kl0WBa4Fn8hv9v4Br5nRQRDweEbfl5y8C9wIrA7sDY/NuY4E98vPdgTMiuQkYImlFYEfgqoiYHhHPAlcBI/O2pSLipogI4Iymc7Wqw8zMKtBJcrkNmAb8HXggP58i6TZJm3RSiaRhwMbAzcAKEfF43vQEsEJ+vjIwtXDYI7msXfkjLcppU4eZmVWgk+RyFbBzRCwfEcuRmq8uBQ4DfjangyUtAVwAHBkRLxS35SuOmOuo50K7OiQdKmmCpAnTpk3rZhhmZgNKJ8lli4gY33gREVfmspuARdodKGkhUmI5KyIuzMVP5iYt8tencvmjwKqFw1fJZe3KV2lR3q6O2UTEqRExIiJGDB06tN23YmZmc6GT5PK4pC9JWj0/vkh68x4EvNHXQXnk1mnAvRHxo8KmcUBjxNdo4JJC+QF51NgWwPO5aWs8sIOkZXJH/g7A+LztBUlb5LoOaDpXqzrMzKwCC3awz0dJo7Uuzq9vyGWDSCPJ+rI18HFgkqQ7ctmXgROA8yQdDDxcOMdlwM7AZOAV4CCAiJgu6RvArXm/r0fE9Pz8MOB0YDBweX7Qpg4zM6vAHJNLRDwNfKaPzZPbHPcXQH1s3r7F/gEc3se5xgBjWpRPANZvUf5MqzrMzKwac0wuktYB/hcYVtw/IrbrXlhmZjY/66RZ7HfAz4FfMWsqGDMzsz51klxmRIQnqjQzs451Mlrs95IOk7RinrNr2XynvpmZWUudXLk0hvQW5xML4B3lh2NmZv1BJ6PF1qgiEDMz6z/6TC6StouIP0naq9X2wh33ZmZms2l35fJ+4E/Abi22BeDkYmZmLfWZXCLiuPz06xHxUHGbJDeVmZlZnzoZLXZBi7Lzyw7EzMz6j3Z9Lu8E3g0s3dTvshRpATEzM7OW2vW5rAvsCgxh9n6XF0lLC5uZmbXUrs/lEuASSVtGxI0VxmRmZvO5Tvpc9pS0lKSFJF0taZqk/bsemZmZzbc6SS475OWJdwWmAGsx+936ZmZms+kkuSyUv+4C/C4inu9iPGZm1g90MrfY7yXdB7wKfErSUOC17oZlZmbzszleuUTE0cBWwIiI+DfwMrB7twMzM7P511zNLSbNtmqxp38xM7OWPLeYmZmVbo5zi0XEQc3bJH24m0GZmdn8rZPRYq2cWGoUZmbWr8xrctGcdzEzs4FqXpNLlBqFmZn1K+1Gi02idRIRsELXIjIzs/leu9Fiu1YWhZmZ9SvtRos9XGUgZmbWf8xrn4uZmVmfupZcJI2R9JSkuwplx0t6VNId+bFzYdsxkiZLul/SjoXykblssqSjC+VrSLo5l58raeFcvkh+PTlvH9at79HMzFrrM7lIujp//e48nvt0YGSL8hMjYqP8uCzXsR4wirSs8kjgZ5IGSRoEnAzsBKwH7Jf3BfhuPtdawLPAwbn8YODZXH5i3s/MzCrU7splRUlbAR+StLGk4cXHnE4cEX8GpncYx+7AORHxr4h4CJgMbJYfkyPiwYh4HTgH2F1pkrPtgPPz8WOBPQrnGpufnw9sr6ZJ0czMrLvajRb7KnAssArwo6ZtQXpznxeflnQAMAE4KiKeBVYGbirs80guA5jaVL45sBzwXETMaLH/yo1jImKGpOfz/k/PY7xmZjaX+rxyiYjzI2In4HsRsW3TY14TyynAmsBGwOPAD+fxPKWQdKikCZImTJs2rc5QzMz6lTkuFhYR35D0IeC/ctG1EfGHeaksIp5sPJf0S6BxnkeBVQu7rpLL6KP8GWCIpAXz1Utx/8a5HpG0ILB03r9VPKcCpwKMGDHCsw6YmZVkjslF0ndIfR9n5aIjJG0VEV+e28okrRgRj+eXewKNkWTjgN9K+hGwErA2cAtpNoC1Ja1BShqjgI9GREi6Btib1A8zGrikcK7RwI15+58iYsAkjmFHX1pZXVNO2KWyusxs/tLJMse7ABtFxBsAksYCtwNtk4uks4FtgOUlPQIcB2wjaSNSn80U4JMAEXG3pPOAe4AZwOERMTOf59PAeGAQMCYi7s5VfAk4R9I3czyn5fLTgN9ImkwaUDCqg+/RzMxK1ElyARjCrJFfS3dyQETs16L4tBZljf2/BXyrRfllwGUtyh8kXVE1l78GfKSTGM3MrDs6SS7fAW7PzVAi9b0c3f4QMzMbyDrp0D9b0rXAprnoSxHxRFejMjOz+VpHzWK5E35cl2MxM7N+whNXmplZ6ZxczMysdG2TS5488r6qgjEzs/6hbXLJ95rcL2m1iuIxM7N+oJMO/WWAuyXdArzcKIyID3UtKjMzm691klyO7XoUZmbWr3Ryn8t1klYH1o6IP0pajDQVi5mZWUtzHC0m6RDSolu/yEUrAxd3MygzM5u/dTIU+XBga+AFgIh4AHhbN4MyM7P5WyfJ5V95iWEA8hopA2YKezMzm3udJJfrJH0ZGCzpg8DvgN93NywzM5ufdZJcjgamAZNI669cBnylm0GZmdn8rZPRYm/kBcJuJjWH3T+QVnY0M7O518kyx7sAPwf+QVrPZQ1Jn4yIy7sdnJmZzZ86uYnyh8C2ETEZQNKawKWAk4uZmbXUSZ/Li43Ekj0IvNileMzMrB/o88pF0l756QRJlwHnkfpcPgLcWkFsZmY2n2rXLLZb4fmTwPvz82nA4K5FZGZm870+k0tEHFRlIGZm1n90MlpsDeAzwLDi/p5y38zM+tLJaLGLgdNId+W/0d1wzMysP+gkubwWESd1PRIzM+s3OkkuP5Z0HHAl8K9GYUTc1rWozMxsvtZJctkA+DiwHbOaxSK/NjMze4tOkstHgHcUp903MzNrp5M79O8ChsztiSWNkfSUpLsKZctKukrSA/nrMrlckk6SNFnSnZKGF44Znfd/QNLoQvkmkiblY06SpHZ1mJlZdTpJLkOA+ySNlzSu8ejguNOBkU1lRwNXR8TawNX5NcBOwNr5cShwCqREARwHbA5sBhxXSBanAIcUjhs5hzrMzKwinTSLHTcvJ46IP0sa1lS8O7BNfj4WuBb4Ui4/I0/lf5OkIZJWzPteFRHTASRdBYyUdC2wVETclMvPAPYgTabZVx1mZlaRTtZzua7E+laIiMfz8yeAFfLzlYGphf0eyWXtyh9pUd6uDjMzq0gnd+i/SBodBrAwsBDwckQs9Z9UHBEhqauLjs2pDkmHkprhWG211boZipnZgDLHPpeIWDIilsrJZDDwYeBn81jfk7m5i/z1qVz+KLBqYb9Vclm78lValLer4y0i4tSIGBERI4YOHTqP35KZmTXrpEP/TZFcDOw4j/WNAxojvkYDlxTKD8ijxrYAns9NW+OBHSQtkzvydwDG520vSNoijxI7oOlcreowM7OKdNIstlfh5QLACOC1Do47m9SxvrykR0gDA04AzpN0MPAwsE/e/TJgZ2Ay8ApwEEBETJf0DWatH/P1Ruc+cBhpRNpgUkd+Y2XMvuowM7OKdDJarLiuywxgCmlEVlsRsV8fm7ZvsW8Ah/dxnjHAmBblE4D1W5Q/06oOq9awoy+ttL4pJ+xSaX1m1l4no8W8rouZmc2Vdsscf7XNcRER3+hCPGZm1g+0u3J5uUXZ4sDBwHKAk4uZmbXUbpnjHzaeS1oSOILU0X4O8MO+jjMzM2vb55Ln9vo88DHSVCrDI+LZKgIzM7P5V7s+l+8DewGnAhtExEuVRWVmZvO1djdRHgWsBHwFeEzSC/nxoqQXqgnPzMzmR+36XObq7n0zM7MGJxAzMyudk4uZmZXOycXMzErn5GJmZqVzcjEzs9I5uZiZWemcXMzMrHROLmZmVjonFzMzK52Ti5mZlc7JxczMSufkYmZmpXNyMTOz0jm5mJlZ6ZxczMysdE4uZmZWOicXMzMrnZOLmZmVzsnFzMxK5+RiZmalqyW5SJoiaZKkOyRNyGXLSrpK0gP56zK5XJJOkjRZ0p2ShhfOMzrv/4Ck0YXyTfL5J+djVf13aWY2cNV55bJtRGwUESPy66OBqyNibeDq/BpgJ2Dt/DgUOAVSMgKOAzYHNgOOaySkvM8hheNGdv/bMTOzhl5qFtsdGJufjwX2KJSfEclNwBBJKwI7AldFxPSIeBa4ChiZty0VETdFRABnFM5lZmYVqCu5BHClpImSDs1lK0TE4/n5E8AK+fnKwNTCsY/ksnblj7QoNzOziixYU73vjYhHJb0NuErSfcWNERGSottB5MR2KMBqq63W7erMzAaMWq5cIuLR/PUp4CJSn8mTuUmL/PWpvPujwKqFw1fJZe3KV2lR3iqOUyNiRESMGDp06H/6bZmZWVZ5cpG0uKQlG8+BHYC7gHFAY8TXaOCS/HwccEAeNbYF8HxuPhsP7CBpmdyRvwMwPm97QdIWeZTYAYVzmZlZBepoFlsBuCiPDl4Q+G1EXCHpVuA8SQcDDwP75P0vA3YGJgOvAAcBRMR0Sd8Abs37fT0ipufnhwGnA4OBy/PDzMwqUnlyiYgHgQ1blD8DbN+iPIDD+zjXGGBMi/IJwPr/cbBmZjZPemkospmZ9RNOLmZmVjonFzMzK52Ti5mZlc7JxczMSufkYmZmpXNyMTOz0jm5mJlZ6ZxczMysdE4uZmZWOicXMzMrnZOLmZmVzsnFzMxK5+RiZmalc3IxM7PSObmYmVnpnFzMzKx0Ti5mZla6ypc5NqvasKMvrbS+KSfsUml9Zr3IVy5mZlY6X7mYVajKqyhfQVmdnFzMBiA3FVq3uVnMzMxK5+RiZmalc7OYmdXK/VD9k5OLmRnuhyqbm8XMzKx0vnIxM+sx/eEqqt9euUgaKel+SZMlHV13PGZmA0m/TC6SBgEnAzsB6wH7SVqv3qjMzAaOfplcgM2AyRHxYES8DpwD7F5zTGZmA4Yiou4YSidpb2BkRHwiv/44sHlEfLppv0OBQ/PLdYH7Kw0UlgeerrjOvvRKLL0SB/ROLL0SBziWVnolDqgnltUjYmhz4YDu0I+IU4FT66pf0oSIGFFX/UW9EkuvxAG9E0uvxAGOpZfjgN6Kpb82iz0KrFp4vUouMzOzCvTX5HIrsLakNSQtDIwCxtUck5nZgNEvm8UiYoakTwPjgUHAmIi4u+awWqmtSa6FXomlV+KA3omlV+IAx9JKr8QBPRRLv+zQNzOzevXXZjEzM6uRk4uZmZXOyaUikgZJ+lzdcfQaSWu0KNu0jljMrDxOLhWJiJnAfnXH0YMukLRy44Wk9wNjaozHWpC0WN0x2PzFHfoVknQisBBwLvByozwibqspnq2AYRRGDUbEGRXHsCnwM2A3YDjwHWDXiJhaZRyFeA6OiNOayk6IiMonP81Jd3Vm//38ueIYtgJ+BSwREatJ2hD4ZEQcVmUcOZZ1gC/w1p/JdjXEUvvvJsexAvBtYKWI2CnPobhl899wHZxcKiTpmhbFUdM/x2+ANYE7gJmFWD5bQyxbAr8AXgN2iYhpVcdQiOUy4KyIOCu/PhlYNCIOrjiO7wL7Avcw++/nQxXHcTOwNzAuIjbOZXdFxPpVxpHr/Rvwc2Ais34mRMTEiuPoid9NjuVy4NfA/0XEhpIWBG6PiA2qjqVZv7zPpVdFxLZ1x1AwAlgvavp0Ien3QLHuxYDngdMkUcc/avZhYJykN4CRwHNVJ5ZsD2DdiPhXDXXPJiKmSioWzexr3y6bERGn1FR3Uc/8boDlI+I8ScfAm/f41fX7mY2TS4V67BL2LuDtwOM11A3wg5rqbUnSsoWXnwAuBm4AviZp2YiYXnFID5KaUOt+A5uam8ZC0kLAEcC9NcXye0mHARdR+LkM4N8NwMuSliN/UJO0BelDWu3cLFahXrqEzU10GwG3MPs/atXNLmsAj0fEa/n1YGCFiJhScRwPkf5BVfjaEBHxjorjuQDYELia2X8/lTZbSloe+DHwAdIAoPHAERHxTJVx5FgealE8YH83OZbhwE+A9UkfGIcCe0fEnVXH0szJpUKSbo2ITSXdXmi/viMiNqohlve3Ko+I6yqOYwKwVV53hzwX3A0RMaCHI0sa3ao8IsZWHYvNrtd+N/lD6rqkD0T3R8S/64ijmZvFqtUzl7BVJ5E2FmwkFoCIeD0nmFpIOpzUof9cfr0MsF9E/KzKOHoliUh6B+nKZQvS3+2NwOci4sGa4lmftLrsoo2yqkc4RsTY/De6Ti6q/A1d0l59bFon91leWGU8rTi5VOso0uzMa0q6gXwJW0cgObH9BHgXsDBpgs+XI2KpikOZJulDETEux7U79S68dEhEnNx4ERHPSjqENFy6MpLWJg3Lbn4jrbQJCPgtacnwPfPrUcDZwOYVx4Gk44BtSD+Ty0jLmP8FqHr4/DbAWGAK6WphVUmjKx6KvFubbQHUnlzcLFaxXrmEzc1Ro4DfkUaOHQCsExHHVBzHmsBZwEqkn8lU4ICImFxlHIV4JgHvaYyikzQIuDMi3l1xHH8BjgNOJL2RHAQsEBFfrTiOOyPiPU1lf4uIDauMI9c7idTXcXvus1wBODMiPlhxHBOBj0bE/fn1OsDZEbFJlXH0Ot+hXyFJdwJfBF6LiLvqbhvNb+CDImJmRPyaNPS26hj+ERFbkD6NvisitqorsWRXAOdK2l7S9qRP6VfUEMfgiLia9AHw4Yg4Htilhjgul3S0pGGSVpf0ReAyScs2jbCrwmsR8QYwQ9JSwFPMvihgVRZqJBaAiPg7afRY5SQtJ+kkSbdJmijpx7npvXZuFqvWbqSbr87L91GcC5wXEf+sIZZXcrvxHZK+RxqSXPmHDUlfbXoNQCHUg30AABOaSURBVER8vepYsi8BnwQ+lV9fRbpDvWr/krQA8EBem+hRYIka4tgnf/1kU/koUvNL15vp8o2sZwO3SBoC/JJ0I+VLpD6gqk2Q9CvgzPz6Y8CEGuIAOAf4M+n+rEYs55JG99XKzWI1yW3qxwIfi4hBNdS/OumT30LA54ClgZ9VfdUg6ajCy0WBXYF7I+K/q4yj1+Rpce4FhgDfAJYCvh8RN9UaWA0kHUFKZiuR3jjPBp4FlqpjyK2kRYDDgffmoutJ/zuV3/fSarYESZN64Q59J5eK5Tf1ffNjJnBuRPyw3qh6R/7HHR8R29RUf090pEsaHjXNOdcUxwGtyqseoZVjWZ2UZEYBg0lJ5rcR8UDVsfQKST8i3at2Xi7aG9gsIv63vqgSJ5cK5XmaFiJ1op9bx3DO3Cna5y+9ufO2anno760RsVZN9fdKR/o1pBkUzif9rdxVZf2FOH5SeLkosD1wW0TUMsqxQdLGpNmz31P1lX8f/0PPk5rGvlnFDaaSXmTWzb6LM2tKnkHASzWM+nwLJ5cKSVq32BFYUwyr56eH56+/yV/3J93tXOnsv03/qINIw7O/HhE/rTKOQjwTI2KTYtNCo6yGWN5O6vPYl9Qsdm5EfLPqOJpiGgKcExGVD/7IIy13Il25bA9cSxqldUnFcXyP9Gb+21w0ijQ33hPAeyOi3TDhAcPJpUKSliZ9Kv6vXHQd6Y208hspi7MEFMpui4jhFcexeuHlDODJiJhRZQxN8fyV1JZ+PvAnUkf6CRGxbo0xbUAaZbhvRNR2g2mOZSHgrip/HpI+SFoLaWdSE9A5wCUR8XLbA7sXz1v+TxplVfV3SHpnRNyXp395i15oUvVosWqNIc3/0xiB83HSXGN93W3bTZK0dUTckF9sRcWjxfI9JOMj4p1V1jsHR5A+hX6W1JG+HdByuo9ukvQu0hXLh4FnSB3ZR7U9qDtxFGevHkS66fa8vo/oimNIVwlHRcSzFdfdyiBJm0XELfDm4ItG01xVH4w+DxwKtOqvDdLfba185VKhVvOI1Ti32CakZLd0LnoO+O+qP/FIugT4TE3DsfuU76OIiHixpvpvZNZQ9cfqiCHHUZyDbgbwcEQ8Ulc8vSAnkzGkoeECXiDNpH03aT2iypKvpEUjT/rarqwOTi4Vym8YX4iIv+TXWwM/iIgta4xpaYCqm+Yk7RURF0r6M7AxqbmjuDpnLeu5SBpBuppcMhc9T0q6lS5I1UvynfCNiURviYin6oynV9T1v9MUQ59NdHXF1OBmsWp9Chib/ygFTAcOrCMQ1b+2zFdI8x8dW1F9nRoDHBYR1wNIei8p2VQyik7SeRGxT4sRSSJdSVU6mk/SPsD3SZ3nAn4i6QsRcX6VcfQaSbsA7wYWrePG3zzYY2VgcB4511giYilSs27tfOVSg9zkQkS8UGMMta4t0yufrprVPdBB0ooR8XjTQIc3RcTDVcRRiOdvwAcbVyuShgJ/rGNusV4h6eekN/BtSbM37E26oqtsxVKlaf8PJM0LeCuzkssLwNjogVmRnVwqlO80/jXwImkKi+HA0RFxZQ2x1Lq2jKRXgD5nA6jhE3ojeRzArBv0gtSp/lpEfL7KeHpF8+inPCXN33rhDvC6KE/mWfi6BHB5RLyv4jgWIC0HcVaV9XbKzWLV+u+I+LGkHYHlSKPFfgNUnlyof22Zh2g/bXjVmkfdHFd4XvknMKX1Or4LvI30qbTRLFb1zXFXSBpPSraQku1lFcfQaxqd5a9IWok0mm/FqoOIiDckfY40q3jPcXKpVuPSdWfgjIi4W40G2+p9nnrXlnm96iaediJi27pjaPI9YLeIqGW9eklrkZab/kJOdI15tG6kR9/Muk3SkcBfgXH5ZtLvAbeRPnzUMbkpwB8l/S9pZGFxQMz0muJ5k5vFKiTp16ROuDVI61IMAq6t8u7vPIxyakQ8kftZPkm6l+Ie4KtV/VFK+mlEfLqKuuZGntvsw8AwCh++quyszXHcEBFbV1lnU/1/AI6JiElN5RsA3x6Id6FL+gGwFelenzuBG0jJ9q9VTPnSR0wPtSiOqufCa8XJpUK5jXQj4MGIeE5pPYxVosKZXSXdBnwgIqZL+i/S3c6fyXG9q+45o+om6QpS8+BEZs3XRFQ8uaikH5PmFrsYeHO23ao6aht9cn1s64lZd+uitFTFCFKi2TI/nouI9WoNrMe4WaxaWwJ3RMTLkvYndej/uOIYBhWuTvYFTo2IC4ALJN1RcSy9aJU65s1qYSngFWCHQlmVy9cOabNtcEUx9KrBpN/P0vnxGDCp7RFdImkxUhP3ahFxqNKs3utGxB/qiKfIyaVapwAbStqQNJXHr0jrf7+/7VHlGiRpwTx/1/akKSQa/PcAf5W0QXNzUNUi4qA66yctiHVIRPyyWCjpE6SrugFH0qmke1teBG4m9b/8qOYpaX5N+n1slV8/Spp13cllgJkRESFpd+CnEXGapMrGxmdnA9dJehp4lbTQUaMDt44JNBcFDiN1GAfwF+CUqqevKNy0uCBwkKQHSc1Rld68KOmLEfE9panu39JmHRGfrSIO4EjgIkkfY1YyGQEsDOxZUQy9ZjVgEeAB0pv4I6Rpk+q0ZkTsK2k/gIh4pcZBQrNxcqnWi5KOIQ1Bfl/ug6l07e2I+Jakq0lDJ6+MWZ1uC5D6Xqp2BumTYGPdkI+Shmd/pOI4dq24vr40RofVtWwuABHxJLCVpG2BxkqHl0bEn2oMq1YRMTK/cb+bdKVwFLC+pOnAjRFxXNsTdMfrkgYz65aCNSn00dXJHfoVylM2fJS0GNb1klYDtokaVvXrFZLuae4IbVVWYTxbAHc3JqzMsym8KyJuriMe602SVgG2JiWZXYHlIqJdP1W34tgB+D/SyqlX5pgOjIhrq46lmZNLxTwJ4OwknUlqIrwpv94cODwiWi6vW0E8twPDG1d0+epyQoXTv4xrt72uCT0NJH2WlEy2Av5N6nNpPCZFxBs1xbUcsAWpCfemiHi6jjiauVmsQp4EsKVNSJ3ojSn3VwPub/SBVD0NDOkD15ufuPJd0FX+n2wJTCX1jd3MrBtvrX7DSJ3ln4uIx2uOBXhzvZ3fAuOipsXT+uIrlwp5EsC36muCxoYaJmq8kJT8T8lFhwHbRsQeFdU/CGisvPge4FLSUr53V1G/zV+U1tvZF9iFNIHlOcAfqh4Q00qlKw8aCzQ1gz2DfwfR6hERD9c0Pcz/kJo9GqOBNgcOqaryiJgZEVdExGhSU8dk4FpJPTebgdUvIq6LiMOAdwC/IK1y2xNN7W4Wq5YnAXyrS0kJRcCipKlx7ieNyKnD2hExqligtKjbtKoCyFPQ7EK6ehkGnARcVFX9Nn/Jo8V2I72fDAfG1htR4maxiuQhjKuQOvMbkwBeHxF+0yjIU98fFhGfqKn+Wlf2k3QGaejvZcA5EXFXFfXa/EnSecBmwBWkySuvq2tgQTMnlwoN9DmZOlXHz0nSlqTmsCOBEwublgL2rKpfTNIbzJrdttVKlFVPuW89LC/f8ceImDnHnSvmZrFq3SZp04i4te5AeoWk4iJcC5Au6x+rIZSFgSVI/xNLFspfoMKlCCJioPfB2VyIiPGStpI0jNln8a793jlfuVRI0n3AWsDDpE+ntayL3kskFe9qngFMAS6oa7SLpNV7aZ0Zs3Yk/QZYE7iDWbN4R4XTBPXJVy7V2rHuAHrQLRFxebFA0v8AP68pnlckfZ80oGDRRmFEbFdTPGbtjADWix68SvAleAUkbSppp8bw2sIw2/WA5euOr2bHSnrzjVvSF4Hda4znLOA+0qi1r5GupNyMab3qLtK6Pz3HzWIVkPQn4KDm5pZ8A+GvB/KnYknLk6YH/wIwEngnsF9EvF5TPBMjYhNJdzaaK9stnGVWJ0nXkBb6u4XZF5WrfZogN4tVY8lW7fgR8XB+cx2wIuJpSR8C/kia2n3vmi/x/52/Pi5pF9LggmVrjMesnePrDqAvvnKpgKTJEbHW3G7rzyS9yKybJ4M0WmsGs+7Qr2XIraRdSWvcrEpaBmAp4GsR0XZCSbO69OpkuE4uFZD0c9JUL18pzLYrUpv+2yPi0HbHm5m10mIy3PcBPTEZrpNLBSQtTlrSeDPSkEGADUkLQn0iIl6qK7a6SdoT+FNEPJ9fDyGtcXNxxXG0XPmxoReGdpo16+XJcJ1cKiTpHcyaM+vuiHiwznh6gaQ7ImKjprLbI2LjiuMYXXj5NWC2VQUjoifmazIrap7NIq8/9LdemAnEHfoVyslkwCeUJq2Gw1f+d1lMHpKOdDKx+UTPTobr5GJ1myDpR8DJ+fXhpFFjdfLlvPU0SWsBK0TEFyTtxazJcG8k3atVOzeLWa1yf9SxwAdy0VXAN+tcVa/KWZDN5oWkPwDHRMSkpvINgG9HxG71RFaIxcml+yRNBP4CXA5c2wurxNnsCkOjARYDXmlswrMRW49pd2Nvr8y+7maxamxOumwdCXxN0jPAeODyiPh7rZHVRNL/i4gj8xrgb/mEU/UdxhGx5Jz3MusZQ9psG1xZFG34yqUGklYiJZqRpBlNb85LlQ4YkjaJiIl5DfC3iIjrqo7JbH4h6WzSEP5fNpV/gjQ0ed96IivE4uRSrzx0cMuIuKHuWKokaVHSevVrAZOA0yJiRr1Rmc0f8l35FwGvM2sAzAjSTBd7RsQTdcXW4ORitZB0Lmker+uBnYCHI+KIeqMym79I2pa0LDake+f+VGc8RU4uVotip6OkBUlzInmEllk/4fVcKiDJ07W/VWP2YdwcZtb/+MqlApJuJ63Pfg5wdkTcU3NItZM0k7TUM6ThvoNJw3899NesH3ByqYikdYFRpOkZ/k2aruGciJhSZ1xmZt3g5FIDSRuSEs0+wBMRsXXNIZmZlcp9LhXLQ4/fBqwALA70xMI+ZmZl8pVLRSS9D9gP2IN0X8c5wIWNdUzMzPoTJ5cKSJoKPExKKOf1yjKkZmbd4uRSAUmrR8TDdcdhZlYVJ5cKtJicMYCngWsi4sx6ojIz6x4nlwr0MTnjssD+wAMRcXTFIZmZdZWTS40kDQImNq8hb2Y2v/NQ5BpFxMy6YzAz6wYvFlYBScu2KF4GOAC4u+JwzMy6zsmlGhNJnfjKrwN4BrgW+FRNMZmZdY37XMzMrHTuc6mApE0lvb3w+gBJl0g6qY8mMzOz+ZqTSzV+QVqOFEn/BZwAnAE8D5xaY1xmZl3hPpdqDIqI6fn5vsCpEXEBcIGkO2qMy8ysK3zlUo1BeSlfgO2B4jrXTvBm1u/4ja0aZwPXSXoaeBW4HkDSWqSmMTOzfsWjxSoiaQtgReDKiHg5l60DLBERt9UanJlZyZxczMysdO5zMTOz0jm5mJlZ6ZxcbECRdI2kHZvKjpR0SptjpkhavkX5hyS1XS5B0ktzGd8USZMk3ZG/7j6Xxx8v6X873PfkXM89kl7Nz++QtPfc1GnWikeL2UBzNjAKGF8oGwV8cW5PFBHjgHElxVW0bUQ8LWld4Ergki7UQUQcDiBpGPAHL/1gZfKViw005wO7SFoY3nxjXQm4XtIOkm6UdJuk30laonDcZ3L5JEnvzMceKOmn+fkKki6S9Lf82Kq5YklfkHSrpDslfa2DWJcCni0c/3lJd+XHkYXy/5P0d0l/AdbNZWtKuq2wz9rF132RdIakPQqvz5K0e/5eL5F0raQHJB1X2Gd/Sbfkq55f5HWKbIBzcrEBJc+UcAuwUy4aBZwHLAd8BfhARAwHJgCfLxz6dC4/BWjV7HQScF1EbAgMp2kpBUk7AGsDmwEbAZvkqYBauUbSXcB1OSYkbQIcBGwObAEcImnjXD4qn3NnYNP8ff4DeF5S42rkIODX7X86AJwGHJjrXBrYCrg0b9sM+DDwHuAjkkZIehdp1omt85XPTOBjHdRj/ZybxWwgajSNXZK/Hkx6w14PuEESwMLAjYVjLsxfJwJ7tTjndqT1eRqLwDXfHLtDftyeXy9BSjZ/bnGuRrPYmsDVkq4F3gtcVLhH6kLgfaQPiBdFxCu5vNhM9yvgIEmfJyWAzVr/OGaJiOsk/UzSUFIiuSAiZuSfyVUR8Uyh/vcCM4BNgFvzPoOBp+ZUj/V/Ti42EF0CnChpOLBYREyUtBvpzXO/Po75V/46k3n7vxHwnYj4RacHRMQ/JD1JSnrz4gLgONJ0QxMbiaEDZwD7kxLvQcWQmkMkfV9jI+KYeYzR+ik3i9mAExEvAdcAY0hXMQA3AVvnKXmQtHieQaFTV5MXfpM0KDcpFY0H/rvRjyNpZUlva3fCvH0N4GHSlEF7SFpM0uLAnrnsz7l8sKQlgd0K3+drud5T6KxJrOF04Mh8jnsK5R+UtKykwcAewA35+9678b3k7avPRV3WT/nKxQaqs4GLSJ/OiYhpkg4Ezpa0SN7nK8DfOzzfEcCpkg4mXd18ikKzWkRcmfsnbszNRy+Rrg5aNSFdI2kmsBBwdEQ8CTwp6XRSfxHAryLidgBJ5wJ/y+e6telcZ5ES0ZUdfh9ExJOS7gUubtp0C+lqaBXgzIiYkOv/CnClpAWAfwOHkxKiDWCe/sWsH8v3vCwdEcfOxTGLAZOA4RHxfC47EBgREZ/uSqDW7/jKxayfknQRsCZpsEGnx3yANGLsxEZiMZsXvnIxM7PSuUPfzMxK5+RiZmalc3IxM7PSObmYmVnpnFzMzKx0Ti5mZla6/w/WMQFS7utw3gAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "2v4u-f49JMT0",
        "outputId": "050ef982-0dd2-4d33-c32d-4c6add5af52a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 391
        }
      },
      "source": [
        "import seaborn as sns\n",
        "import matplotlib as plt\n",
        "sns.set(style='ticks') # Set style\n",
        "\n",
        "\n",
        "sampled_df = sampled_df.withColumn(\"Price(in thousands)\", (sampled_df['price'] / 1000))\n",
        "\n",
        "\n",
        "n1 = sns.relplot(data = sampled_df.toPandas(),\n",
        "                 x = \"daysonmarket\",\n",
        "                 y = \"Price(in thousands)\",\n",
        "                 alpha = 0.5) #set plotting parameters\n",
        "\n",
        "n1.ax.xaxis.grid(True, \"minor\", linewidth=.25)\n",
        "n1.ax.yaxis.grid(True, \"minor\", linewidth=.25)\n",
        "#sns.plt.ticklabel_format(style = 'plain', axis = \"y\", useOffset = False)\n",
        "n1.ax.set_title(\"Scatter of Days on Market vs Price(in thousands)\")\n",
        "n1.fig.set_size_inches(5,5)\n",
        "display(n1)"
      ],
      "execution_count": 31,
      "outputs": [
        {
          "output_type": "error",
          "ename": "Py4JJavaError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mPy4JJavaError\u001b[0m                             Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-31-4123da9f70ca>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      7\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      8\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 9\u001b[0;31m n1 = sns.relplot(data = sampled_df.toPandas(),\n\u001b[0m\u001b[1;32m     10\u001b[0m                  \u001b[0mx\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"daysonmarket\"\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     11\u001b[0m                  \u001b[0my\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"Price(in thousands)\"\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pyspark/sql/pandas/conversion.py\u001b[0m in \u001b[0;36mtoPandas\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    136\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    137\u001b[0m         \u001b[0;31m# Below is toPandas without Arrow optimization.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 138\u001b[0;31m         \u001b[0mpdf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mDataFrame\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfrom_records\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcollect\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcolumns\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    139\u001b[0m         \u001b[0mcolumn_counter\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mCounter\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    140\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pyspark/sql/dataframe.py\u001b[0m in \u001b[0;36mcollect\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    594\u001b[0m         \"\"\"\n\u001b[1;32m    595\u001b[0m         \u001b[0;32mwith\u001b[0m \u001b[0mSCCallSiteSync\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_sc\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0mcss\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 596\u001b[0;31m             \u001b[0msock_info\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_jdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcollectToPython\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    597\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mlist\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0m_load_from_socket\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msock_info\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mBatchedSerializer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mPickleSerializer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    598\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/py4j/java_gateway.py\u001b[0m in \u001b[0;36m__call__\u001b[0;34m(self, *args)\u001b[0m\n\u001b[1;32m   1303\u001b[0m         \u001b[0manswer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mgateway_client\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msend_command\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcommand\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1304\u001b[0m         return_value = get_return_value(\n\u001b[0;32m-> 1305\u001b[0;31m             answer, self.gateway_client, self.target_id, self.name)\n\u001b[0m\u001b[1;32m   1306\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1307\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0mtemp_arg\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mtemp_args\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pyspark/sql/utils.py\u001b[0m in \u001b[0;36mdeco\u001b[0;34m(*a, **kw)\u001b[0m\n\u001b[1;32m    126\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mdeco\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0ma\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkw\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    127\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 128\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mf\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0ma\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkw\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    129\u001b[0m         \u001b[0;32mexcept\u001b[0m \u001b[0mpy4j\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mprotocol\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mPy4JJavaError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    130\u001b[0m             \u001b[0mconverted\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mconvert_exception\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0me\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mjava_exception\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/py4j/protocol.py\u001b[0m in \u001b[0;36mget_return_value\u001b[0;34m(answer, gateway_client, target_id, name)\u001b[0m\n\u001b[1;32m    326\u001b[0m                 raise Py4JJavaError(\n\u001b[1;32m    327\u001b[0m                     \u001b[0;34m\"An error occurred while calling {0}{1}{2}.\\n\"\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 328\u001b[0;31m                     format(target_id, \".\", name), value)\n\u001b[0m\u001b[1;32m    329\u001b[0m             \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    330\u001b[0m                 raise Py4JError(\n",
            "\u001b[0;31mPy4JJavaError\u001b[0m: An error occurred while calling o597.collectToPython.\n: java.lang.OutOfMemoryError: Java heap space\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bT81_ONpI8l-"
      },
      "source": [
        "n3 = sns.relplot(data = sampled_df.toPandas(),\n",
        "                 x = \"mileage\",\n",
        "                 y = \"Price(in thousands)\",\n",
        "                 alpha = 0.5) #set plotting parameters\n",
        "\n",
        "n3.ax.xaxis.grid(True, \"minor\", linewidth=.25)\n",
        "n3.ax.yaxis.grid(True, \"minor\", linewidth=.25)\n",
        "n3.ax.set_title(\"Scatter of Mileage vs Price(in thousands)\")\n",
        "n3.fig.set_size_inches(5,5)\n",
        "display(n3)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "yDYbRAfEJIG9"
      },
      "source": [
        "n2 = sns.relplot(data = sampled_df.toPandas(),\n",
        "                 x = \"city_fuel_economy\",\n",
        "                 y = \"Price(in thousands)\",\n",
        "                 alpha = 0.5) #set plotting parameters\n",
        "\n",
        "n2.ax.xaxis.grid(True, \"minor\", linewidth=.25)\n",
        "n2.ax.yaxis.grid(True, \"minor\", linewidth=.25)\n",
        "n2.ax.set_title(\"Scatter of City Fuel Economy vs Price(in thousands)\")\n",
        "n2.fig.set_size_inches(5,5)\n",
        "display(n2)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZY4Bhs_9JQjF"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}