CAR_PRICE.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp = pd.read_csv('car_price.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['name', 'year', 'selling_price', 'km_driven', 'fuel', 'seller_type',\n",
       "       'transmission', 'owner', 'mileage', 'engine', 'max_power', 'torque',\n",
       "       'seats'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "temp.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = temp[['year', 'selling_price', 'km_driven', 'fuel', 'seller_type',\n",
    "       'transmission', 'owner', 'mileage', 'engine', 'max_power', 'torque',\n",
    "       'seats'\n",
    "            ]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "data['Current_Year'] = 2020\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>selling_price</th>\n",
       "      <th>km_driven</th>\n",
       "      <th>fuel</th>\n",
       "      <th>seller_type</th>\n",
       "      <th>transmission</th>\n",
       "      <th>owner</th>\n",
       "      <th>mileage</th>\n",
       "      <th>engine</th>\n",
       "      <th>max_power</th>\n",
       "      <th>torque</th>\n",
       "      <th>seats</th>\n",
       "      <th>Current_Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014</td>\n",
       "      <td>450000</td>\n",
       "      <td>145500</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Individual</td>\n",
       "      <td>Manual</td>\n",
       "      <td>First Owner</td>\n",
       "      <td>23.4 kmpl</td>\n",
       "      <td>1248 CC</td>\n",
       "      <td>74 bhp</td>\n",
       "      <td>190Nm@ 2000rpm</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014</td>\n",
       "      <td>370000</td>\n",
       "      <td>120000</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Individual</td>\n",
       "      <td>Manual</td>\n",
       "      <td>Second Owner</td>\n",
       "      <td>21.14 kmpl</td>\n",
       "      <td>1498 CC</td>\n",
       "      <td>103.52 bhp</td>\n",
       "      <td>250Nm@ 1500-2500rpm</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2006</td>\n",
       "      <td>158000</td>\n",
       "      <td>140000</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Individual</td>\n",
       "      <td>Manual</td>\n",
       "      <td>Third Owner</td>\n",
       "      <td>17.7 kmpl</td>\n",
       "      <td>1497 CC</td>\n",
       "      <td>78 bhp</td>\n",
       "      <td>12.7@ 2,700(kgm@ rpm)</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2010</td>\n",
       "      <td>225000</td>\n",
       "      <td>127000</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Individual</td>\n",
       "      <td>Manual</td>\n",
       "      <td>First Owner</td>\n",
       "      <td>23.0 kmpl</td>\n",
       "      <td>1396 CC</td>\n",
       "      <td>90 bhp</td>\n",
       "      <td>22.4 kgm at 1750-2750rpm</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2007</td>\n",
       "      <td>130000</td>\n",
       "      <td>120000</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Individual</td>\n",
       "      <td>Manual</td>\n",
       "      <td>First Owner</td>\n",
       "      <td>16.1 kmpl</td>\n",
       "      <td>1298 CC</td>\n",
       "      <td>88.2 bhp</td>\n",
       "      <td>11.5@ 4,500(kgm@ rpm)</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year  selling_price  km_driven    fuel seller_type transmission  \\\n",
       "0  2014         450000     145500  Diesel  Individual       Manual   \n",
       "1  2014         370000     120000  Diesel  Individual       Manual   \n",
       "2  2006         158000     140000  Petrol  Individual       Manual   \n",
       "3  2010         225000     127000  Diesel  Individual       Manual   \n",
       "4  2007         130000     120000  Petrol  Individual       Manual   \n",
       "\n",
       "          owner     mileage   engine   max_power                    torque  \\\n",
       "0   First Owner   23.4 kmpl  1248 CC      74 bhp            190Nm@ 2000rpm   \n",
       "1  Second Owner  21.14 kmpl  1498 CC  103.52 bhp       250Nm@ 1500-2500rpm   \n",
       "2   Third Owner   17.7 kmpl  1497 CC      78 bhp     12.7@ 2,700(kgm@ rpm)   \n",
       "3   First Owner   23.0 kmpl  1396 CC      90 bhp  22.4 kgm at 1750-2750rpm   \n",
       "4   First Owner   16.1 kmpl  1298 CC    88.2 bhp     11.5@ 4,500(kgm@ rpm)   \n",
       "\n",
       "   seats  Current_Year  \n",
       "0    5.0          2020  \n",
       "1    5.0          2020  \n",
       "2    5.0          2020  \n",
       "3    5.0          2020  \n",
       "4    5.0          2020  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "data['# Years'] = data['Current_Year'] - data['year']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "to_drop = ['Current_Year','year','torque','max_power','seller_type','owner']\n",
    "data.drop(to_drop, inplace = True, axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>selling_price</th>\n",
       "      <th>km_driven</th>\n",
       "      <th>fuel</th>\n",
       "      <th>transmission</th>\n",
       "      <th>mileage</th>\n",
       "      <th>engine</th>\n",
       "      <th>seats</th>\n",
       "      <th># Years</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>450000</td>\n",
       "      <td>145500</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Manual</td>\n",
       "      <td>23.4 kmpl</td>\n",
       "      <td>1248 CC</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>370000</td>\n",
       "      <td>120000</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Manual</td>\n",
       "      <td>21.14 kmpl</td>\n",
       "      <td>1498 CC</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>158000</td>\n",
       "      <td>140000</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Manual</td>\n",
       "      <td>17.7 kmpl</td>\n",
       "      <td>1497 CC</td>\n",
       "      <td>5.0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>225000</td>\n",
       "      <td>127000</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Manual</td>\n",
       "      <td>23.0 kmpl</td>\n",
       "      <td>1396 CC</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>130000</td>\n",
       "      <td>120000</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Manual</td>\n",
       "      <td>16.1 kmpl</td>\n",
       "      <td>1298 CC</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   selling_price  km_driven    fuel transmission     mileage   engine  seats  \\\n",
       "0         450000     145500  Diesel       Manual   23.4 kmpl  1248 CC    5.0   \n",
       "1         370000     120000  Diesel       Manual  21.14 kmpl  1498 CC    5.0   \n",
       "2         158000     140000  Petrol       Manual   17.7 kmpl  1497 CC    5.0   \n",
       "3         225000     127000  Diesel       Manual   23.0 kmpl  1396 CC    5.0   \n",
       "4         130000     120000  Petrol       Manual   16.1 kmpl  1298 CC    5.0   \n",
       "\n",
       "   # Years  \n",
       "0        6  \n",
       "1        6  \n",
       "2       14  \n",
       "3       10  \n",
       "4       13  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "data['engine']= data['engine'].str.replace('[^\\d.]', '',regex = True).astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "data['mileage'] = data['mileage'].str.replace('[^\\d.]', '',regex = True).astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>selling_price</th>\n",
       "      <th>km_driven</th>\n",
       "      <th>fuel</th>\n",
       "      <th>transmission</th>\n",
       "      <th>mileage</th>\n",
       "      <th>engine</th>\n",
       "      <th>seats</th>\n",
       "      <th># Years</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>450000</td>\n",
       "      <td>145500</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Manual</td>\n",
       "      <td>23.40</td>\n",
       "      <td>1248.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>370000</td>\n",
       "      <td>120000</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Manual</td>\n",
       "      <td>21.14</td>\n",
       "      <td>1498.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>158000</td>\n",
       "      <td>140000</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Manual</td>\n",
       "      <td>17.70</td>\n",
       "      <td>1497.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>225000</td>\n",
       "      <td>127000</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Manual</td>\n",
       "      <td>23.00</td>\n",
       "      <td>1396.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>130000</td>\n",
       "      <td>120000</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Manual</td>\n",
       "      <td>16.10</td>\n",
       "      <td>1298.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   selling_price  km_driven    fuel transmission  mileage  engine  seats  \\\n",
       "0         450000     145500  Diesel       Manual    23.40  1248.0    5.0   \n",
       "1         370000     120000  Diesel       Manual    21.14  1498.0    5.0   \n",
       "2         158000     140000  Petrol       Manual    17.70  1497.0    5.0   \n",
       "3         225000     127000  Diesel       Manual    23.00  1396.0    5.0   \n",
       "4         130000     120000  Petrol       Manual    16.10  1298.0    5.0   \n",
       "\n",
       "   # Years  \n",
       "0        6  \n",
       "1        6  \n",
       "2       14  \n",
       "3       10  \n",
       "4       13  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.replace(to_replace = ['Diesel','Petrol','LPG','CNG'],value=[1,2,3,4],inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>selling_price</th>\n",
       "      <th>km_driven</th>\n",
       "      <th>fuel</th>\n",
       "      <th>transmission</th>\n",
       "      <th>mileage</th>\n",
       "      <th>engine</th>\n",
       "      <th>seats</th>\n",
       "      <th># Years</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>450000</td>\n",
       "      <td>145500</td>\n",
       "      <td>1</td>\n",
       "      <td>Manual</td>\n",
       "      <td>23.40</td>\n",
       "      <td>1248.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>370000</td>\n",
       "      <td>120000</td>\n",
       "      <td>1</td>\n",
       "      <td>Manual</td>\n",
       "      <td>21.14</td>\n",
       "      <td>1498.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>158000</td>\n",
       "      <td>140000</td>\n",
       "      <td>2</td>\n",
       "      <td>Manual</td>\n",
       "      <td>17.70</td>\n",
       "      <td>1497.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>225000</td>\n",
       "      <td>127000</td>\n",
       "      <td>1</td>\n",
       "      <td>Manual</td>\n",
       "      <td>23.00</td>\n",
       "      <td>1396.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>130000</td>\n",
       "      <td>120000</td>\n",
       "      <td>2</td>\n",
       "      <td>Manual</td>\n",
       "      <td>16.10</td>\n",
       "      <td>1298.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   selling_price  km_driven  fuel transmission  mileage  engine  seats  \\\n",
       "0         450000     145500     1       Manual    23.40  1248.0    5.0   \n",
       "1         370000     120000     1       Manual    21.14  1498.0    5.0   \n",
       "2         158000     140000     2       Manual    17.70  1497.0    5.0   \n",
       "3         225000     127000     1       Manual    23.00  1396.0    5.0   \n",
       "4         130000     120000     2       Manual    16.10  1298.0    5.0   \n",
       "\n",
       "   # Years  \n",
       "0        6  \n",
       "1        6  \n",
       "2       14  \n",
       "3       10  \n",
       "4       13  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.replace(to_replace = ['Manual','Automatic'],value=[1.0,2.0],inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>selling_price</th>\n",
       "      <th>km_driven</th>\n",
       "      <th>fuel</th>\n",
       "      <th>transmission</th>\n",
       "      <th>mileage</th>\n",
       "      <th>engine</th>\n",
       "      <th>seats</th>\n",
       "      <th># Years</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>450000</td>\n",
       "      <td>145500</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.40</td>\n",
       "      <td>1248.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>370000</td>\n",
       "      <td>120000</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.14</td>\n",
       "      <td>1498.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>158000</td>\n",
       "      <td>140000</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.70</td>\n",
       "      <td>1497.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>225000</td>\n",
       "      <td>127000</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.00</td>\n",
       "      <td>1396.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>130000</td>\n",
       "      <td>120000</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16.10</td>\n",
       "      <td>1298.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   selling_price  km_driven  fuel  transmission  mileage  engine  seats  \\\n",
       "0         450000     145500     1           1.0    23.40  1248.0    5.0   \n",
       "1         370000     120000     1           1.0    21.14  1498.0    5.0   \n",
       "2         158000     140000     2           1.0    17.70  1497.0    5.0   \n",
       "3         225000     127000     1           1.0    23.00  1396.0    5.0   \n",
       "4         130000     120000     2           1.0    16.10  1298.0    5.0   \n",
       "\n",
       "   # Years  \n",
       "0        6  \n",
       "1        6  \n",
       "2       14  \n",
       "3       10  \n",
       "4       13  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>selling_price</th>\n",
       "      <th>km_driven</th>\n",
       "      <th>fuel</th>\n",
       "      <th>transmission</th>\n",
       "      <th>mileage</th>\n",
       "      <th>engine</th>\n",
       "      <th>seats</th>\n",
       "      <th># Years</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>450000</td>\n",
       "      <td>145500</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.40</td>\n",
       "      <td>1248.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>370000</td>\n",
       "      <td>120000</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.14</td>\n",
       "      <td>1498.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>158000</td>\n",
       "      <td>140000</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.70</td>\n",
       "      <td>1497.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>225000</td>\n",
       "      <td>127000</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.00</td>\n",
       "      <td>1396.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>130000</td>\n",
       "      <td>120000</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16.10</td>\n",
       "      <td>1298.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   selling_price  km_driven  fuel  transmission  mileage  engine  seats  \\\n",
       "0         450000     145500     1           1.0    23.40  1248.0    5.0   \n",
       "1         370000     120000     1           1.0    21.14  1498.0    5.0   \n",
       "2         158000     140000     2           1.0    17.70  1497.0    5.0   \n",
       "3         225000     127000     1           1.0    23.00  1396.0    5.0   \n",
       "4         130000     120000     2           1.0    16.10  1298.0    5.0   \n",
       "\n",
       "   # Years  \n",
       "0        6  \n",
       "1        6  \n",
       "2       14  \n",
       "3       10  \n",
       "4       13  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[ 1.          1.33828022 -0.86972865 ... -0.41797619 -0.43426926\n",
      "  -0.04846121]\n",
      " [ 1.          0.88735626 -0.86972865 ...  0.07813794 -0.43426926\n",
      "  -0.04846121]\n",
      " [ 1.          1.24102211  0.95315801 ...  0.07615349 -0.43426926\n",
      "   1.92965648]\n",
      " ...\n",
      " [ 1.          0.88735626 -0.86972865 ... -0.41797619 -0.43426926\n",
      "   1.18786235]\n",
      " [ 1.         -0.79255652 -0.86972865 ... -0.12427662 -0.43426926\n",
      "   0.1988035 ]\n",
      " [ 1.         -0.79255652 -0.86972865 ... -0.12427662 -0.43426926\n",
      "   0.1988035 ]]\n",
      "[[nan nan nan nan nan nan nan nan]]\n",
      "nan\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Text(0.5, 1.0, 'Error vs. Training Epoch')"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZAAAAEWCAYAAABIVsEJAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/Il7ecAAAACXBIWXMAAAsTAAALEwEAmpwYAAAXFklEQVR4nO3dfZQldX3n8fcHRhAj8jgiMkwGhdWMJmBsMT5tMCIPHnEIsoKaOLtqiFnJrhpWh5BVRHcDomJcH3ZZ9cj6BEqijDGRDCBZYxKkB0FFxRlBlxlBRwZRJICD3/3j1sClvdPT8+u+fbvT79c593TVr35V9f11ndOfrqp766aqkCRpR+006gIkSfOTASJJamKASJKaGCCSpCYGiCSpiQEiSWpigEhzSJI/TfKBme471yVZlqSSLBp1LZq6+DkQzaYk3wX2A+7ra/5wVZ06moqmL8nfAs/qZncFCri3m/9oVb1qJIVNQ5IC7qI3lq3Oqqq3DWl/y4CbgIdU1ZZh7EMzz7TXKBxXVZdtr1OSRRP/mCTZuaru29Y6A7axQ/1bVNWxffv7MLChqv5sQC2/NJ457tCqWj/qIjR3eQlLc0aSf5/kS0nOS3IbcGaSDyd5f5K/SfIz4NlJfi3JlUl+nOT6JC/o28Yv9Z+wj5OSjE9oe22S1d3085J8I8lPk2xMcto0x1RJXp1kHbCua/uLJDcn+UmStUme1df/zCQf7aa3XtZZmeT/JflRkjMa++6W5IIktyf5ZpLXJ9nQOKYzk1yc5KLu93RNkkP7lk92fHZL8o4k30tyR5J/SLJb3+ZfOqh+zU0GiOaapwI30rvM9d+6tpd007sDVwGfBf4OeCTwx8DHkjyubxv9/f9hwvY/CzwuySET+n+8m/4g8IdVtTvwROCKGRjT8d24lnfzVwOHAXt3+/1UkodOsv4zgccBzwHemOTXGvq+CVgGPAZ4LvB7DePotwL4FA+M4TNJHpLkIUx+fN4OPBl4erfu64FfTKF+zUEGiEbhM91/p1tff9C37PtV9T+qaktV/UvXdklVfamqfkHvD+/DgbOr6t6qugL4a+DFfdu4v39V3d2/46q6C7hka/8uSB4PrO66/BxYnuQRVXV7VV0zA+P986ravHU8VfXRqrqtG+M76N03edwk67+5qv6lqq4DrgMObej7IuC/d2PaALx7CnVfM+E4Hd23bG1VXVxVPwfeCTwU+K3uNfD4JNkJeDnwn6tqY1XdV1X/WFX3NI5VI2aAaBSOr6o9+17/u2/ZzQP697c9Gri5C5OtvgccsJ1t9Ps4DwTOS4DPdMEC8ELgecD3kvx9kqdtbzBT8KB6kpzWXUa6I8mPgT2AfSdZ/9a+6bvo/YHe0b6PnlDH9n5HAL854ThdOmj97lhs6PYx2fHZl17QfKehfs1BBojmmkFvC+xv+z5wYPff7FZLgY3b2Ua/NcDiJIfRC5Ktl6+oqquragW9yy+fAT455cq37f56uvsdr6d3RrBXVe0J3AFkBvYzmVuAJX3zB05ze/ev3x2LJfSOzWTH50fA3cBjp7lvzREGiOabq+j9Z/r67pr7EcBxwIVT3UB32eVTwLn0rsOvAUiyS5KXJtmj6/MTHnx9fibsDmwBNgGLkrwReMQM72OQTwKnJ9kryQHAdN82/eQkJ6T3uY3XAPcA/8wkx6c7K/kQ8M4kj06yc5KnJdl1mrVoRAwQjcJnk9zZ9/r0VFesqnvp/UE6lt5/tO8DXlZV39rBGj4OHAl8asJba38f+G6SnwCvAl4KkGRpV+vSHdzPRJcCnwe+Te/Szt1M7XLSdJ1F7zLTTcBlwMX0/uhP5roJx+ldfcsuAU4Cbqf3Ozuhqn4+heNzGvA1em8k2Aycg3+H5i0/SCgtQEn+CDi5qn67Yd0zgYOrarrv5NI8Z/JLC0CS/ZM8I8lO3Vtq/wSY8pmfNIifRJcWhl2A/wUcBPyY3j2j942yIM1/XsKSJDXxEpYkqcmCuoS177771rJly0ZdhiTNK2vXrv1RVS2e2L6gAmTZsmWMj49vv6Mk6X5Jvjeo3UtYkqQmBogkqYkBIklqYoBIkpoYIJKkJgaIJKmJASJJamKASJKaGCCSpCYGiCSpiQEiSWpigEiSmhggkqQmBogkqYkBIklqYoBIkpoYIJKkJgaIJKmJASJJamKASJKaGCCSpCYGiCSpiQEiSWpigEiSmhggkqQmIw2QJMckuSHJ+iSrBizfNclF3fKrkiybsHxpkjuTnDZrRUuSgBEGSJKdgfcCxwLLgRcnWT6h2yuA26vqYOA84JwJy98J/O2wa5Uk/bJRnoEcDqyvqhur6l7gQmDFhD4rgAu66YuB5yQJQJLjgZuA62enXElSv1EGyAHAzX3zG7q2gX2qagtwB7BPkocDbwDevL2dJDklyXiS8U2bNs1I4ZKk+XsT/UzgvKq6c3sdq+r8qhqrqrHFixcPvzJJWiAWjXDfG4ED++aXdG2D+mxIsgjYA7gNeCpwYpK3AXsCv0hyd1W9Z+hVS5KA0QbI1cAhSQ6iFxQnAy+Z0Gc1sBL4J+BE4IqqKuBZWzskORO40/CQpNk1sgCpqi1JTgUuBXYGPlRV1yc5CxivqtXAB4GPJFkPbKYXMpKkOSC9f+gXhrGxsRofHx91GZI0ryRZW1VjE9vn6010SdKIGSCSpCYGiCSpiQEiSWpigEiSmhggkqQmBogkqYkBIklqYoBIkpoYIJKkJgaIJKmJASJJamKASJKaGCCSpCYGiCSpiQEiSWpigEiSmhggkqQmBogkqYkBIklqYoBIkpoYIJKkJgaIJKmJASJJamKASJKaGCCSpCYGiCSpiQEiSWpigEiSmhggkqQmIw2QJMckuSHJ+iSrBizfNclF3fKrkizr2p+bZG2Sr3U/f2fWi5ekBW5kAZJkZ+C9wLHAcuDFSZZP6PYK4PaqOhg4Dzina/8RcFxV/TqwEvjI7FQtSdpqlGcghwPrq+rGqroXuBBYMaHPCuCCbvpi4DlJUlVfqarvd+3XA7sl2XVWqpYkAaMNkAOAm/vmN3RtA/tU1RbgDmCfCX1eCFxTVfcMqU5J0gCLRl3AdCR5Ar3LWkdN0ucU4BSApUuXzlJlkvSv3yjPQDYCB/bNL+naBvZJsgjYA7itm18CfBp4WVV9Z1s7qarzq2qsqsYWL148g+VL0sI2ygC5GjgkyUFJdgFOBlZP6LOa3k1ygBOBK6qqkuwJfA5YVVVfmq2CJUkPGFmAdPc0TgUuBb4JfLKqrk9yVpIXdN0+COyTZD3wOmDrW31PBQ4G3pjk2u71yFkegiQtaKmqUdcwa8bGxmp8fHzUZUjSvJJkbVWNTWz3k+iSpCYGiCSpiQEiSWpigEiSmhggkqQmBogkqYkBIklqYoBIkpoYIJKkJgaIJKmJASJJamKASJKaGCCSpCYGiCSpiQEiSWpigEiSmhggkqQmBogkqYkBIklqYoBIkpoYIJKkJgaIJKmJASJJamKASJKaGCCSpCYGiCSpyZQCJMlHptImSVo4pnoG8oT+mSQ7A0+e+XIkSfPFpAGS5PQkPwV+I8lPutdPgR8Cl8xKhZKkOWnSAKmqP6+q3YFzq+oR3Wv3qtqnqk6fpRolSXPQVC9h/XWSXwFI8ntJ3pnkV4dYlyRpjptqgLwfuCvJocCfAN8B/s90d57kmCQ3JFmfZNWA5bsmuahbflWSZX3LTu/ab0hy9HRrkSTtmKkGyJaqKmAF8J6qei+w+3R23N2Ify9wLLAceHGS5RO6vQK4vaoOBs4DzunWXQ6cTO/m/jHA+7rtSZJmyVQD5KdJTgd+H/hckp2Ah0xz34cD66vqxqq6F7iQXkD1WwFc0E1fDDwnSbr2C6vqnqq6CVjfbU+SNEumGiAnAfcAL6+qW4ElwLnT3PcBwM198xu6toF9qmoLcAewzxTXBSDJKUnGk4xv2rRpmiVLkraaUoB0ofExYI8kzwfurqpp3wOZDVV1flWNVdXY4sWLR12OJP2rMdVPor8I+DLw74AXAVclOXGa+94IHNg3v6RrG9gnySJgD+C2Ka4rSRqiqV7COgN4SlWtrKqX0bvf8F+nue+rgUOSHJRkF3o3xVdP6LMaWNlNnwhc0d3MXw2c3L1L6yDgEHoBJ0maJYum2G+nqvph3/xtTPNBjFW1JcmpwKXAzsCHqur6JGcB41W1Gvgg8JEk64HN9EKGrt8ngW8AW4BXV9V906lHkrRj0vuHfjudknOB3wA+0TWdBHy1qt4wxNpm3NjYWI2Pj4+6DEmaV5Ksraqxie2TnoEkORjYr6r+S5ITgGd2i/6J3k11SdICtb1LWO8CTgeoqr8C/gogya93y44bYm2SpDlse/cx9quqr01s7NqWDaUiSdK8sL0A2XOSZbvNYB2SpHlmewEynuQPJjYmeSWwdjglSZLmg+3dA3kN8OkkL+WBwBgDdgF+d4h1SZLmuEkDpKp+ADw9ybOBJ3bNn6uqK4ZemSRpTpvSBwmr6gvAF4ZciyRpHpnWp8klSQuXASJJamKASJKaGCCSpCYGiCSpiQEiSWpigEiSmhggkqQmBogkqYkBIklqYoBIkpoYIJKkJgaIJKmJASJJamKASJKaGCCSpCYGiCSpiQEiSWpigEiSmhggkqQmBogkqYkBIklqMpIASbJ3kjVJ1nU/99pGv5Vdn3VJVnZtD0vyuSTfSnJ9krNnt3pJEozuDGQVcHlVHQJc3s0/SJK9gTcBTwUOB97UFzRvr6rHA08CnpHk2NkpW5K01agCZAVwQTd9AXD8gD5HA2uqanNV3Q6sAY6pqruq6gsAVXUvcA2wZPglS5L6jSpA9quqW7rpW4H9BvQ5ALi5b35D13a/JHsCx9E7i5EkzaJFw9pwksuARw1YdEb/TFVVkmrY/iLgE8C7q+rGSfqdApwCsHTp0h3djSRpG4YWIFV15LaWJflBkv2r6pYk+wM/HNBtI3BE3/wS4Mq++fOBdVX1ru3UcX7Xl7GxsR0OKknSYKO6hLUaWNlNrwQuGdDnUuCoJHt1N8+P6tpI8lZgD+A1wy9VkjTIqALkbOC5SdYBR3bzJBlL8gGAqtoMvAW4unudVVWbkyyhdxlsOXBNkmuTvHIUg5CkhSxVC+eqztjYWI2Pj4+6DEmaV5Ksraqxie1+El2S1MQAkSQ1MUAkSU0MEElSEwNEktTEAJEkNTFAJElNDBBJUhMDRJLUxACRJDUxQCRJTQwQSVITA0SS1MQAkSQ1MUAkSU0MEElSEwNEktTEAJEkNTFAJElNDBBJUhMDRJLUxACRJDUxQCRJTQwQSVITA0SS1MQAkSQ1MUAkSU0MEElSEwNEktTEAJEkNTFAJElNRhIgSfZOsibJuu7nXtvot7Lrsy7JygHLVyf5+vArliRNNKozkFXA5VV1CHB5N/8gSfYG3gQ8FTgceFN/0CQ5AbhzdsqVJE00qgBZAVzQTV8AHD+gz9HAmqraXFW3A2uAYwCSPBx4HfDW4ZcqSRpkVAGyX1Xd0k3fCuw3oM8BwM198xu6NoC3AO8A7trejpKckmQ8yfimTZumUbIkqd+iYW04yWXAowYsOqN/pqoqSe3Adg8DHltVr02ybHv9q+p84HyAsbGxKe9HkjS5oQVIVR25rWVJfpBk/6q6Jcn+wA8HdNsIHNE3vwS4EngaMJbku/Tqf2SSK6vqCCRJs2ZUl7BWA1vfVbUSuGRAn0uBo5Ls1d08Pwq4tKreX1WPrqplwDOBbxsekjT7RhUgZwPPTbIOOLKbJ8lYkg8AVNVmevc6ru5eZ3VtkqQ5IFUL57bA2NhYjY+Pj7oMSZpXkqytqrGJ7X4SXZLUxACRJDUxQCRJTQwQSVITA0SS1MQAkSQ1MUAkSU0MEElSEwNEktTEAJEkNTFAJElNDBBJUhMDRJLUxACRJDUxQCRJTQwQSVITA0SS1MQAkSQ1MUAkSU0MEElSEwNEktTEAJEkNTFAJElNDBBJUpNU1ahrmDVJNgHfG3UdO2hf4EejLmKWOeaFwTHPH79aVYsnNi6oAJmPkoxX1dio65hNjnlhcMzzn5ewJElNDBBJUhMDZO47f9QFjIBjXhgc8zznPRBJUhPPQCRJTQwQSVITA2QOSLJ3kjVJ1nU/99pGv5Vdn3VJVg5YvjrJ14df8fRNZ8xJHpbkc0m+leT6JGfPbvU7JskxSW5Isj7JqgHLd01yUbf8qiTL+pad3rXfkOToWS18GlrHnOS5SdYm+Vr383dmvfgG0znG3fKlSe5MctqsFT0TqsrXiF/A24BV3fQq4JwBffYGbux+7tVN79W3/ATg48DXRz2eYY8ZeBjw7K7PLsAXgWNHPaZtjHNn4DvAY7parwOWT+jzH4H/2U2fDFzUTS/v+u8KHNRtZ+dRj2nIY34S8Ohu+onAxlGPZ5jj7Vt+MfAp4LRRj2dHXp6BzA0rgAu66QuA4wf0ORpYU1Wbq+p2YA1wDECShwOvA946/FJnTPOYq+quqvoCQFXdC1wDLBl+yU0OB9ZX1Y1drRfSG3u//t/FxcBzkqRrv7Cq7qmqm4D13fbmuuYxV9VXqur7Xfv1wG5Jdp2VqttN5xiT5HjgJnrjnVcMkLlhv6q6pZu+FdhvQJ8DgJv75jd0bQBvAd4B3DW0CmfedMcMQJI9geOAy4dQ40zY7hj6+1TVFuAOYJ8prjsXTWfM/V4IXFNV9wypzpnSPN7un783AG+ehTpn3KJRF7BQJLkMeNSARWf0z1RVJZnye6uTHAY8tqpeO/G66qgNa8x9218EfAJ4d1Xd2Fal5qIkTwDOAY4adS1DdiZwXlXd2Z2QzCsGyCypqiO3tSzJD5LsX1W3JNkf+OGAbhuBI/rmlwBXAk8DxpJ8l97xfGSSK6vqCEZsiGPe6nxgXVW9a/rVDs1G4MC++SVd26A+G7pQ3AO4bYrrzkXTGTNJlgCfBl5WVd8ZfrnTNp3xPhU4McnbgD2BXyS5u6reM/SqZ8Kob8L4KoBzefAN5bcN6LM3veuke3Wvm4C9J/RZxvy5iT6tMdO73/OXwE6jHst2xrmI3s3/g3jgBusTJvR5NQ++wfrJbvoJPPgm+o3Mj5vo0xnznl3/E0Y9jtkY74Q+ZzLPbqKPvABfBb1rv5cD64DL+v5IjgEf6Ov3cno3UtcD/2HAduZTgDSPmd5/eAV8E7i2e71y1GOaZKzPA75N7506Z3RtZwEv6KYfSu8dOOuBLwOP6Vv3jG69G5ij7zSbyTEDfwb8rO+4Xgs8ctTjGeYx7tvGvAsQH2UiSWriu7AkSU0MEElSEwNEktTEAJEkNTFAJElNDBBpipLc2f1cluQlM7ztP50w/48zuX1pGAwQacctA3YoQLpPH0/mQQFSVU/fwZqkWWeASDvubOBZSa5N8tokOyc5N8nVSb6a5A8BkhyR5ItJVgPf6No+033PxfVJTunazqb31Nlrk3ysa9t6tpNu21/vviPjpL5tX5nk4u57UT7W93TXs5N8o6vl7bP+29GC4bOwpB23it4nhp8P0AXBHVX1lO7R419K8ndd398Enli9x7EDvLyqNifZDbg6yV9W1aokp1bVYQP2dQJwGHAosG+3zv/tlj2J3uNOvg98CXhGkm8Cvws8vqqqe1qxNBSegUjTdxTwsiTXAlfRe0zLId2yL/eFB8B/SnId8M/0Hq53CJN7JvCJqrqvqn4A/D3wlL5tb6iqX9B75Mcyeo8Jvxv4YJITmF+P+Nc8Y4BI0xfgj6vqsO51UFVtPQP52f2dkiOAI4GnVdWhwFfoPSOpVf/3ZNwHLKred00cTu9Li54PfH4a25cmZYBIO+6nwO5985cCf5TkIQBJ/k2SXxmw3h7A7VV1V5LHA7/Vt+znW9ef4IvASd19lsXAv6X3ML6Bui8o2qOq/gZ4Lb1LX9JQeA9E2nFfBe7rLkV9GPgLepePruluZG9i8Ff0fh54VXef4gZ6l7G2Oh/4apJrquqlfe2fpvedL9fRewLx66vq1i6ABtkduCTJQ+mdGb2uaYTSFPg0XklSEy9hSZKaGCCSpCYGiCSpiQEiSWpigEiSmhggkqQmBogkqcn/B2wjoL3JKBaLAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "data = (data - data.mean())/data.std()\n",
    "\n",
    "\n",
    "\n",
    "X = data.iloc[:,1:8]\n",
    "\n",
    "ones = np.ones([X.shape[0],1])\n",
    "X = np.concatenate((ones,X),axis=1)\n",
    "\n",
    "y = data.iloc[:,0:1].values \n",
    "theta = np.zeros([1,8])\n",
    "\n",
    "print(X)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "def computeCost(X,y,theta):\n",
    "    tobesummed = np.power(((X @ theta.T)-y),2)\n",
    "    return np.sum(tobesummed)/(2 * len(X))\n",
    "\n",
    "def gradientDescent(X,y,theta,iters,alpha):\n",
    "    cost = np.zeros(iters)\n",
    "    for i in range(iters):\n",
    "        theta = theta - (alpha/len(X)) * np.sum(X * (X @ theta.T - y), axis=0)\n",
    "        cost[i] = computeCost(X, y, theta)\n",
    "        \n",
    "    \n",
    "    return theta,cost\n",
    "\n",
    "\n",
    "alpha = 0.01\n",
    "iters = 1000\n",
    "\n",
    "g,cost = gradientDescent(X,y,theta,iters,alpha)\n",
    "print(g)\n",
    "\n",
    "finalCost = computeCost(X,y,g)\n",
    "print(finalCost)\n",
    "\n",
    "\n",
    " \n",
    "fig, ax = plt.subplots()  \n",
    "ax.plot(np.arange(iters), cost, 'r')  \n",
    "ax.set_xlabel('Iterations')  \n",
    "ax.set_ylabel('Cost')  \n",
    "ax.set_title('Error vs. Training Epoch')  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}