preprocessing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "1cc74ab2",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from sklearn.preprocessing import LabelEncoder, OneHotEncoder\n",
    "from sklearn.compose import ColumnTransformer\n",
    "from sklearn.pipeline import Pipeline\n",
    "from sklearn.preprocessing import MinMaxScaler\n",
    "import pickle\n",
    "import pandas as pd\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.linear_model import LinearRegression, Ridge, Lasso\n",
    "from sklearn.metrics import mean_squared_error\n",
    "from sklearn.metrics import r2_score\n",
    "from flask import Flask, request, jsonify\n",
    "import numpy as np\n",
    "from transformation_functions import square_root_transformation , log_transformation , Reciprocal_transformation\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "27a4ce21",
   "metadata": {},
   "outputs": [],
   "source": [
    "cleaned_cars_data = pd.read_csv('cleaned_cars_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "6ec9d1f2",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('ridge_model.pkl', \"rb\") as file:\n",
    "    ridge_model = pickle.load(file)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "3e85ee91",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "with open('scaler_other.pkl', 'rb') as scaler_other_file:\n",
    "    scaler_info_other = pickle.load(scaler_other_file)\n",
    "# Access the actual scaler object from the loaded information\n",
    "loaded_scaler_for_other = scaler_info_other['scaler']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "fcd86bfe",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('Reciprocal_transformation_info.pkl', 'rb') as file:\n",
    "    load_Reciprocal_transformation_info = pickle.load(file)\n",
    "    \n",
    "loaded_reciprocal_transform = load_Reciprocal_transformation_info['transformation_function']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "ef4c6f37",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('root_transformation_info.pkl', 'rb') as file:\n",
    "    load_root_transformation_info = pickle.load(file)\n",
    "    \n",
    "loaded_root_transform = load_root_transformation_info['transformation_function']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "2c42f977",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('scaler_price.pkl', 'rb') as scaler_price_file:\n",
    "    scaler_info_price = pickle.load(scaler_price_file)\n",
    "# Access the actual scaler object from the loaded information\n",
    "loaded_scaler_for_price =  scaler_info_price['scaler']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "9a6edc6c",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('inverse_transform_info_price.pkl' , 'rb') as inverse_transform_info_price:\n",
    "    inverse_transform_info_price = pickle.load(inverse_transform_info_price)\n",
    "# Access the actual scaler object from the loaded information\n",
    "loaded_inverse_transform_info_price =  inverse_transform_info_price['transformation_function']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "93813641",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "def Reciprocal_transformation(feature_to_transform):\n",
    "    feature_reciprocal_transformation = 1 / feature_to_transform\n",
    "    return feature_reciprocal_transformation\n",
    "\n",
    "\n",
    "def min_max_normalization(dataframe , features_to_normalize): #must be  list \n",
    "    scaler = MinMaxScaler()\n",
    "    dataframe[features_to_normalize] = scaler.fit_transform( dataframe[features_to_normalize])\n",
    "    return  dataframe\n",
    "\n",
    "def Label_Encoder(The_feature):\n",
    "    label_encoder = LabelEncoder()\n",
    "    The_feature_encoded = label_encoder.fit_transform(The_feature)\n",
    "    return The_feature_encoded\n",
    "\n",
    "def OneHot_Encoder(data, column):\n",
    "    onehot_encoded_columns = pd.get_dummies(data[column], prefix=f'{column}-')\n",
    "    data = pd.concat([data, onehot_encoded_columns], axis=1)\n",
    "    data.drop(column, axis=1, inplace=True)\n",
    "    return data\n",
    "\n",
    "\n",
    "reciprocal_cols = ['passengers']\n",
    "min_max_cols = ['model', 'motor_power', 'car_speedometer', 'passengers', 'ex_owners', 'Number_of_Additions']\n",
    "\n",
    "def preprocess_data(input_data, loaded_scaler , loaded_Reciprocal_transformation):\n",
    "    # Reciprocal transformation\n",
    "    input_data[reciprocal_cols] = loaded_Reciprocal_transformation(input_data[reciprocal_cols])\n",
    "\n",
    "    # Min-Max normalization\n",
    "    input_data[min_max_cols] = loaded_scaler.transform(input_data[min_max_cols])\n",
    "\n",
    "    return input_data\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "f188ceed",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * Serving Flask app \"__main__\" (lazy loading)\n",
      " * Environment: production\n",
      "\u001b[31m   WARNING: This is a development server. Do not use it in a production deployment.\u001b[0m\n",
      "\u001b[2m   Use a production WSGI server instead.\u001b[0m\n",
      " * Debug mode: off\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      " * Running on http://127.0.0.1:5000/ (Press CTRL+C to quit)\n"
     ]
    }
   ],
   "source": [
    "app = Flask(__name__)\n",
    "\n",
    "@app.route('/predict', methods=['POST'])\n",
    "def predict():\n",
    "    try:\n",
    "        # Get the data from the request\n",
    "        data = request.get_json(force=True)\n",
    "        features_to_modify = ['Name', 'color', 'fuel_type', 'origin_car', 'lime_type']\n",
    "        features_that_have_two_values = ['car_license', 'glass']\n",
    "        updated_data = {}\n",
    "        for key, value in data.items():\n",
    "            if key in features_to_modify:\n",
    "                updated_key = f'{key}-_{value}'  # Assuming you want to concatenate the key and value\n",
    "                updated_data[updated_key] = 1\n",
    "            elif key in features_that_have_two_values:\n",
    "                # Modify values for features with two values\n",
    "                if key == 'car_license' and value == 'نمرة صفراء':\n",
    "                    updated_data[key] = 1\n",
    "                else:\n",
    "                    updated_data[key] = 0\n",
    "\n",
    "                if key == 'glass' and value == 'يدوي':\n",
    "                    updated_data[key] = 1\n",
    "                else:\n",
    "                    updated_data[key] = 0\n",
    "            else:\n",
    "                updated_data[key] = value\n",
    "                #it is ready  \n",
    "        data_2.update(pd.DataFrame([updated_data]))\n",
    "        input_data = preprocess_data(data_2 , loaded_scaler_for_other , loaded_reciprocal_transform) # \n",
    "        # Make predictions\n",
    "        prediction = ridge_model.predict(input_data)\n",
    "        prediction_2d = prediction.reshape(-1, 1)\n",
    "        \n",
    "        #---------------------------------------------------------------------------------------------------\n",
    "        # there is may some problem in the inverse process in target *******************\n",
    "        #---------------------------------------------------------------------------------------------------\n",
    "        inverse_normalized_predictions = prediction_2d * (393.70039370059055 - 34.64101615137755) + 34.64101615137755\n",
    "\n",
    "        # Inverse Transform for Root Transformation\n",
    "        prediction_without_root =  np.power(inverse_normalized_predictions, 2) \n",
    "\n",
    "        # Inverse Transform \n",
    "        #prediction_original_scale = loaded_inverse_transform_info_price(prediction_without_root)\n",
    "\n",
    "        # Now, 'prediction_original_scale' contains the predictions in their original scale\n",
    "        #print(prediction_original_scale)\n",
    "\n",
    "        response = {'prediction For Price': prediction_2d[0].tolist()}\n",
    "        return jsonify(response)\n",
    "\n",
    "\n",
    "    except Exception as e:\n",
    "        return jsonify({'error': str(e)})\n",
    "\n",
    "if __name__ == '__main__':\n",
    "    app.run(port=5000)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "0d249363",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('cars_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "4b90d164",
   "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>اسم السيارة</th>\n",
       "      <th>موديل السيارة</th>\n",
       "      <th>سعر السيارة</th>\n",
       "      <th>لون السيارة</th>\n",
       "      <th>نوع الوقود</th>\n",
       "      <th>أصل السيارة</th>\n",
       "      <th>رخصة السيارة</th>\n",
       "      <th>نوع الجير</th>\n",
       "      <th>الزجاج</th>\n",
       "      <th>قوة الماتور</th>\n",
       "      <th>...</th>\n",
       "      <th>وسيلة الدفع</th>\n",
       "      <th>معروضة</th>\n",
       "      <th>أصحاب سابقون</th>\n",
       "      <th>إضافات</th>\n",
       "      <th>حالة الإعلان</th>\n",
       "      <th>تاريخ نشر الإعلان</th>\n",
       "      <th>تاريخ إنتهاء الإعلان</th>\n",
       "      <th>Number_of_Additions</th>\n",
       "      <th>فتحة السقف</th>\n",
       "      <th>الدفع</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>كيا اوبتيما</td>\n",
       "      <td>موديل سنة 2014</td>\n",
       "      <td>100000 شيكل</td>\n",
       "      <td>أبيض عاجي</td>\n",
       "      <td>بنزين</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>نقدا فقط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>يد اولى</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>2017-09-15</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>كيا سورينتو</td>\n",
       "      <td>موديل سنة 2007</td>\n",
       "      <td>60000 شيكل</td>\n",
       "      <td>سكني</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>نصف اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>...</td>\n",
       "      <td>إمكانية التقسيط</td>\n",
       "      <td>للبيع أو التبديل</td>\n",
       "      <td>2</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>2017-09-30</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>هونداي افانتي</td>\n",
       "      <td>موديل سنة 2006</td>\n",
       "      <td>43500 شيكل</td>\n",
       "      <td>سكني</td>\n",
       "      <td>بنزين</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>...</td>\n",
       "      <td>نقدا فقط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>NaN</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2017-08-19</td>\n",
       "      <td>2017-09-18</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6983</th>\n",
       "      <td>مرسيدس C220</td>\n",
       "      <td>موديل سنة 2009</td>\n",
       "      <td>90000 شيكل</td>\n",
       "      <td>فيراني</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>نقدا فقط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>يد ثانية</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2022-05-07</td>\n",
       "      <td>2022-07-06</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>دفع خلفي</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6984</th>\n",
       "      <td>نيسان كشكاي</td>\n",
       "      <td>موديل سنة 2014</td>\n",
       "      <td>95000 شيكل</td>\n",
       "      <td>فيراني</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>...</td>\n",
       "      <td>إمكانية التقسيط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>يد اولا</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقففرش ...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2022-05-07</td>\n",
       "      <td>2022-06-06</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>دفع أمامي</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6985</th>\n",
       "      <td>سكودا اوكتافيا</td>\n",
       "      <td>موديل سنة 2020</td>\n",
       "      <td>160000 شيكل</td>\n",
       "      <td>أبيض</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>إمكانية التقسيط</td>\n",
       "      <td>للبيع أو التبديل</td>\n",
       "      <td>0</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2022-05-08</td>\n",
       "      <td>2022-07-07</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>دفع أمامي</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6986</th>\n",
       "      <td>سكودا سوبيرب</td>\n",
       "      <td>موديل سنة 2018</td>\n",
       "      <td>119000 شيكل</td>\n",
       "      <td>أسود</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>نقدا فقط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>0</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2022-05-08</td>\n",
       "      <td>2022-06-12</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>دفع أمامي</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6987</th>\n",
       "      <td>كيا سورينتو</td>\n",
       "      <td>موديل سنة 2018</td>\n",
       "      <td>185000 شيكل</td>\n",
       "      <td>أبيض عاجي</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>نصف اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>إمكانية التقسيط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>اولى</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2022-05-08</td>\n",
       "      <td>2022-07-07</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>دفع أمامي</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6988 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         اسم السيارة   موديل السيارة  سعر السيارة لون السيارة نوع الوقود  \\\n",
       "0        كيا اوبتيما  موديل سنة 2014  100000 شيكل   أبيض عاجي      بنزين   \n",
       "1                NaN             NaN          NaN         NaN        NaN   \n",
       "2                NaN             NaN          NaN         NaN        NaN   \n",
       "3        كيا سورينتو  موديل سنة 2007   60000 شيكل        سكني       ديزل   \n",
       "4      هونداي افانتي  موديل سنة 2006   43500 شيكل        سكني      بنزين   \n",
       "...              ...             ...          ...         ...        ...   \n",
       "6983     مرسيدس C220  موديل سنة 2009   90000 شيكل      فيراني       ديزل   \n",
       "6984     نيسان كشكاي  موديل سنة 2014   95000 شيكل      فيراني       ديزل   \n",
       "6985  سكودا اوكتافيا  موديل سنة 2020  160000 شيكل        أبيض       ديزل   \n",
       "6986    سكودا سوبيرب  موديل سنة 2018  119000 شيكل        أسود       ديزل   \n",
       "6987     كيا سورينتو  موديل سنة 2018  185000 شيكل   أبيض عاجي       ديزل   \n",
       "\n",
       "     أصل السيارة رخصة السيارة      نوع الجير    الزجاج  قوة الماتور  ...  \\\n",
       "0          خصوصي     فلسطينية      اوتوماتيك  الكتروني       2000.0  ...   \n",
       "1            NaN          NaN            NaN       NaN          NaN  ...   \n",
       "2            NaN          NaN            NaN       NaN          NaN  ...   \n",
       "3          خصوصي     فلسطينية  نصف اوتوماتيك  الكتروني       2500.0  ...   \n",
       "4          خصوصي     فلسطينية      اوتوماتيك  الكتروني       1600.0  ...   \n",
       "...          ...          ...            ...       ...          ...  ...   \n",
       "6983       خصوصي     فلسطينية      اوتوماتيك  الكتروني       2200.0  ...   \n",
       "6984       خصوصي     فلسطينية      اوتوماتيك  الكتروني       1600.0  ...   \n",
       "6985       خصوصي     فلسطينية      اوتوماتيك  الكتروني       2000.0  ...   \n",
       "6986       خصوصي     فلسطينية      اوتوماتيك  الكتروني       2000.0  ...   \n",
       "6987       خصوصي     فلسطينية  نصف اوتوماتيك  الكتروني       2200.0  ...   \n",
       "\n",
       "          وسيلة الدفع            معروضة أصحاب سابقون  \\\n",
       "0            نقدا فقط         للبيع فقط      يد اولى   \n",
       "1                 NaN               NaN          NaN   \n",
       "2                 NaN               NaN          NaN   \n",
       "3     إمكانية التقسيط  للبيع أو التبديل            2   \n",
       "4            نقدا فقط         للبيع فقط          NaN   \n",
       "...               ...               ...          ...   \n",
       "6983         نقدا فقط         للبيع فقط     يد ثانية   \n",
       "6984  إمكانية التقسيط         للبيع فقط      يد اولا   \n",
       "6985  إمكانية التقسيط  للبيع أو التبديل            0   \n",
       "6986         نقدا فقط         للبيع فقط            0   \n",
       "6987  إمكانية التقسيط         للبيع فقط         اولى   \n",
       "\n",
       "                                                 إضافات حالة الإعلان  \\\n",
       "0     مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...  إعلان منتهي   \n",
       "1                                                   NaN          NaN   \n",
       "2                                                   NaN          NaN   \n",
       "3     مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...  إعلان منتهي   \n",
       "4     مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...  إعلان منتهي   \n",
       "...                                                 ...          ...   \n",
       "6983  مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...  إعلان منتهي   \n",
       "6984  مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقففرش ...  إعلان منتهي   \n",
       "6985  مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...  إعلان منتهي   \n",
       "6986  مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...  إعلان منتهي   \n",
       "6987  مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...  إعلان منتهي   \n",
       "\n",
       "     تاريخ نشر الإعلان تاريخ إنتهاء الإعلان Number_of_Additions فتحة السقف  \\\n",
       "0           2017-08-16           2017-09-15                 7.0        1.0   \n",
       "1                  NaN                  NaN                 NaN        NaN   \n",
       "2                  NaN                  NaN                 NaN        NaN   \n",
       "3           2017-08-16           2017-09-30                 7.0        1.0   \n",
       "4           2017-08-19           2017-09-18                 7.0        0.0   \n",
       "...                ...                  ...                 ...        ...   \n",
       "6983        2022-05-07           2022-07-06                 7.0        1.0   \n",
       "6984        2022-05-07           2022-06-06                 6.0        1.0   \n",
       "6985        2022-05-08           2022-07-07                 7.0        0.0   \n",
       "6986        2022-05-08           2022-06-12                 6.0        0.0   \n",
       "6987        2022-05-08           2022-07-07                 6.0        1.0   \n",
       "\n",
       "          الدفع  \n",
       "0           NaN  \n",
       "1           NaN  \n",
       "2           NaN  \n",
       "3           NaN  \n",
       "4           NaN  \n",
       "...         ...  \n",
       "6983   دفع خلفي  \n",
       "6984  دفع أمامي  \n",
       "6985  دفع أمامي  \n",
       "6986  دفع أمامي  \n",
       "6987  دفع أمامي  \n",
       "\n",
       "[6988 rows x 22 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "664a3d9c",
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'sample_row' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[16], line 1\u001b[0m\n\u001b[1;32m----> 1\u001b[0m \u001b[43msample_row\u001b[49m\n",
      "\u001b[1;31mNameError\u001b[0m: name 'sample_row' is not defined"
     ]
    }
   ],
   "source": [
    "sample_row"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "1676082e",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_2 = cleaned_cars_data.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "5af242fa",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_2 = pd.DataFrame(0, index=[0], columns=data_2.columns)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "2a0cb5fd",
   "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>model</th>\n",
       "      <th>Price(NIS)</th>\n",
       "      <th>car_license</th>\n",
       "      <th>glass</th>\n",
       "      <th>motor_power</th>\n",
       "      <th>car_speedometer</th>\n",
       "      <th>passengers</th>\n",
       "      <th>ex_owners</th>\n",
       "      <th>Number_of_Additions</th>\n",
       "      <th>sunroof</th>\n",
       "      <th>...</th>\n",
       "      <th>fuel_type-_هايبرد</th>\n",
       "      <th>origin_car-_تأجير</th>\n",
       "      <th>origin_car-_تجاري</th>\n",
       "      <th>origin_car-_تدريب سياقة</th>\n",
       "      <th>origin_car-_حكومي</th>\n",
       "      <th>origin_car-_خصوصي</th>\n",
       "      <th>origin_car-_عمومي</th>\n",
       "      <th>lime_type-_اوتوماتيك</th>\n",
       "      <th>lime_type-_عادي</th>\n",
       "      <th>lime_type-_نصف اوتوماتيك</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 481 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   model  Price(NIS)  car_license  glass  motor_power  car_speedometer  \\\n",
       "0      0           0            0      0            0                0   \n",
       "\n",
       "   passengers  ex_owners  Number_of_Additions  sunroof  ...  \\\n",
       "0           0          0                    0        0  ...   \n",
       "\n",
       "   fuel_type-_هايبرد  origin_car-_تأجير  origin_car-_تجاري  \\\n",
       "0                  0                  0                  0   \n",
       "\n",
       "   origin_car-_تدريب سياقة  origin_car-_حكومي  origin_car-_خصوصي  \\\n",
       "0                        0                  0                  0   \n",
       "\n",
       "   origin_car-_عمومي  lime_type-_اوتوماتيك  lime_type-_عادي  \\\n",
       "0                  0                     0                0   \n",
       "\n",
       "   lime_type-_نصف اوتوماتيك  \n",
       "0                         0  \n",
       "\n",
       "[1 rows x 481 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "3e1aee2b",
   "metadata": {},
   "outputs": [],
   "source": [
    " data_2.drop('Price(NIS)', axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "c581e725",
   "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>model</th>\n",
       "      <th>car_license</th>\n",
       "      <th>glass</th>\n",
       "      <th>motor_power</th>\n",
       "      <th>car_speedometer</th>\n",
       "      <th>passengers</th>\n",
       "      <th>ex_owners</th>\n",
       "      <th>Number_of_Additions</th>\n",
       "      <th>sunroof</th>\n",
       "      <th>Name-_أفيكو  50c18دبل كابينه</th>\n",
       "      <th>...</th>\n",
       "      <th>fuel_type-_هايبرد</th>\n",
       "      <th>origin_car-_تأجير</th>\n",
       "      <th>origin_car-_تجاري</th>\n",
       "      <th>origin_car-_تدريب سياقة</th>\n",
       "      <th>origin_car-_حكومي</th>\n",
       "      <th>origin_car-_خصوصي</th>\n",
       "      <th>origin_car-_عمومي</th>\n",
       "      <th>lime_type-_اوتوماتيك</th>\n",
       "      <th>lime_type-_عادي</th>\n",
       "      <th>lime_type-_نصف اوتوماتيك</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 480 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   model  car_license  glass  motor_power  car_speedometer  passengers  \\\n",
       "0      0            0      0            0                0           0   \n",
       "\n",
       "   ex_owners  Number_of_Additions  sunroof  Name-_أفيكو  50c18دبل كابينه  ...  \\\n",
       "0          0                    0        0                             0  ...   \n",
       "\n",
       "   fuel_type-_هايبرد  origin_car-_تأجير  origin_car-_تجاري  \\\n",
       "0                  0                  0                  0   \n",
       "\n",
       "   origin_car-_تدريب سياقة  origin_car-_حكومي  origin_car-_خصوصي  \\\n",
       "0                        0                  0                  0   \n",
       "\n",
       "   origin_car-_عمومي  lime_type-_اوتوماتيك  lime_type-_عادي  \\\n",
       "0                  0                     0                0   \n",
       "\n",
       "   lime_type-_نصف اوتوماتيك  \n",
       "0                         0  \n",
       "\n",
       "[1 rows x 480 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    " data_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "fe06ba07",
   "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>model</th>\n",
       "      <th>Price(NIS)</th>\n",
       "      <th>car_license</th>\n",
       "      <th>glass</th>\n",
       "      <th>motor_power</th>\n",
       "      <th>car_speedometer</th>\n",
       "      <th>passengers</th>\n",
       "      <th>ex_owners</th>\n",
       "      <th>Number_of_Additions</th>\n",
       "      <th>sunroof</th>\n",
       "      <th>...</th>\n",
       "      <th>fuel_type-_هايبرد</th>\n",
       "      <th>origin_car-_تأجير</th>\n",
       "      <th>origin_car-_تجاري</th>\n",
       "      <th>origin_car-_تدريب سياقة</th>\n",
       "      <th>origin_car-_حكومي</th>\n",
       "      <th>origin_car-_خصوصي</th>\n",
       "      <th>origin_car-_عمومي</th>\n",
       "      <th>lime_type-_اوتوماتيك</th>\n",
       "      <th>lime_type-_عادي</th>\n",
       "      <th>lime_type-_نصف اوتوماتيك</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.484392</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.474289</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.399985</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.494322</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.474289</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.003998</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.460534</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.453582</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.439239</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.000399</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>765</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.460534</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.550779</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>864</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.460534</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.000648</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.474289</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1371</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.500851</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.388785</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1500</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.446430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1627</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.409453</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1724</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.494322</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1927</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.446430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1951</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.446430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.291589</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1977</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.442846</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.615576</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2082</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.446430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2110</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.417062</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.550779</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2112</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.439239</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2223</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.442846</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.609096</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2342</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.453527</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2355</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.409453</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2655</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.417062</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2691</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.401729</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2721</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.424559</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.000875</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2792</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.393882</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2931</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.424559</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.042118</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2937</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.424559</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3097</th>\n",
       "      <td>0.740741</td>\n",
       "      <td>0.401729</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3110</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.352599</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3259</th>\n",
       "      <td>0.740741</td>\n",
       "      <td>0.424559</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.000713</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3332</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.424559</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.463302</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3365</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.424559</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3572</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.446430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3797</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.393882</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.447103</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3813</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.446430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3879</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.297389</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.054754</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3956</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.424559</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.780810</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4130</th>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.439239</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4144</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.439239</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.226791</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4188</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.424559</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.000940</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4366</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.385908</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.809968</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4672</th>\n",
       "      <td>0.722222</td>\n",
       "      <td>0.424559</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.594286</td>\n",
       "      <td>0.615576</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>43 rows × 481 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         model  Price(NIS)  car_license  glass  motor_power  car_speedometer  \\\n",
       "2     0.722222    0.484392            0      0     0.428571         0.226791   \n",
       "29    0.722222    0.474289            0      0     0.428571         0.399985   \n",
       "168   0.703704    0.494322            0      0     0.428571         0.000000   \n",
       "288   0.722222    0.474289            0      0     0.428571         0.003998   \n",
       "304   0.722222    0.460534            0      0     0.428571         0.453582   \n",
       "370   0.722222    0.439239            0      0     0.428571         0.000399   \n",
       "765   0.722222    0.460534            0      0     0.428571         0.550779   \n",
       "864   0.703704    0.460534            0      0     0.428571         0.000648   \n",
       "993   0.722222    0.474289            0      0     0.428571         0.226791   \n",
       "1371  0.722222    0.500851            0      0     0.428571         0.388785   \n",
       "1500  0.703704    0.446430            0      0     0.428571         0.226791   \n",
       "1627  0.722222    0.409453            0      0     0.428571         0.226791   \n",
       "1724  0.722222    0.494322            0      0     0.428571         0.000000   \n",
       "1927  0.722222    0.446430            0      0     0.428571         0.226791   \n",
       "1951  0.722222    0.446430            0      0     0.428571         0.291589   \n",
       "1977  0.703704    0.442846            0      0     0.428571         0.615576   \n",
       "2082  0.703704    0.446430            0      0     0.428571         0.226791   \n",
       "2110  0.722222    0.417062            0      0     0.428571         0.550779   \n",
       "2112  0.703704    0.439239            0      0     0.428571         0.226791   \n",
       "2223  0.722222    0.442846            0      0     0.428571         0.609096   \n",
       "2342  0.722222    0.453527            0      0     0.428571         0.226791   \n",
       "2355  0.722222    0.409453            0      0     0.428571         0.226791   \n",
       "2655  0.722222    0.417062            0      0     0.428571         0.226791   \n",
       "2691  0.722222    0.401729            0      0     0.428571         0.226791   \n",
       "2721  0.703704    0.424559            0      0     0.428571         0.000875   \n",
       "2792  0.703704    0.393882            0      0     0.428571         0.226791   \n",
       "2931  0.703704    0.424559            0      0     0.428571         0.042118   \n",
       "2937  0.703704    0.424559            0      0     0.428571         0.226791   \n",
       "3097  0.740741    0.401729            0      0     0.428571         0.226791   \n",
       "3110  0.722222    0.352599            0      0     0.428571         0.226791   \n",
       "3259  0.740741    0.424559            0      0     0.428571         0.000713   \n",
       "3332  0.722222    0.424559            0      0     0.428571         0.463302   \n",
       "3365  0.722222    0.424559            0      0     0.428571         0.226791   \n",
       "3572  0.722222    0.446430            0      0     0.428571         0.226791   \n",
       "3797  0.722222    0.393882            0      0     0.428571         0.447103   \n",
       "3813  0.703704    0.446430            0      0     0.428571         0.226791   \n",
       "3879  0.722222    0.297389            0      0     0.428571         0.054754   \n",
       "3956  0.722222    0.424559            0      0     0.428571         0.780810   \n",
       "4130  0.703704    0.439239            0      0     0.428571         0.226791   \n",
       "4144  0.722222    0.439239            0      0     0.428571         0.226791   \n",
       "4188  0.722222    0.424559            0      0     0.428571         0.000940   \n",
       "4366  0.722222    0.385908            0      0     0.428571         0.809968   \n",
       "4672  0.722222    0.424559            0      0     0.594286         0.615576   \n",
       "\n",
       "      passengers  ex_owners  Number_of_Additions  sunroof  ...  \\\n",
       "2           0.40        0.2             1.000000      0.0  ...   \n",
       "29          0.40        0.4             0.000000      0.0  ...   \n",
       "168         0.40        0.6             1.000000      1.0  ...   \n",
       "288         0.40        0.4             0.857143      0.0  ...   \n",
       "304         0.25        0.4             0.857143      0.0  ...   \n",
       "370         0.40        0.6             0.571429      0.0  ...   \n",
       "765         0.40        0.4             0.857143      0.0  ...   \n",
       "864         0.40        0.8             1.000000      0.0  ...   \n",
       "993         0.40        0.2             1.000000      0.0  ...   \n",
       "1371        0.40        0.2             0.285714      0.0  ...   \n",
       "1500        0.40        0.6             0.000000      0.0  ...   \n",
       "1627        0.40        0.2             0.857143      0.0  ...   \n",
       "1724        0.40        0.2             0.857143      0.0  ...   \n",
       "1927        0.40        0.6             0.571429      0.0  ...   \n",
       "1951        0.40        0.6             0.571429      0.0  ...   \n",
       "1977        0.40        0.6             0.857143      0.0  ...   \n",
       "2082        0.40        0.2             0.714286      0.0  ...   \n",
       "2110        0.40        1.0             0.857143      0.0  ...   \n",
       "2112        0.40        0.2             0.857143      0.0  ...   \n",
       "2223        0.40        0.2             1.000000      0.0  ...   \n",
       "2342        0.40        0.2             1.000000      0.0  ...   \n",
       "2355        0.40        0.2             1.000000      0.0  ...   \n",
       "2655        0.40        0.2             0.714286      0.0  ...   \n",
       "2691        0.40        0.8             0.857143      0.0  ...   \n",
       "2721        0.40        0.2             0.857143      0.0  ...   \n",
       "2792        0.40        0.2             0.714286      0.0  ...   \n",
       "2931        0.40        0.4             0.857143      0.0  ...   \n",
       "2937        0.40        0.2             0.857143      0.0  ...   \n",
       "3097        0.40        0.4             0.571429      0.0  ...   \n",
       "3110        0.40        0.4             1.000000      0.0  ...   \n",
       "3259        0.40        0.4             0.714286      0.0  ...   \n",
       "3332        0.40        0.8             1.000000      0.0  ...   \n",
       "3365        0.40        0.2             1.000000      0.0  ...   \n",
       "3572        0.40        0.2             0.857143      0.0  ...   \n",
       "3797        0.40        0.8             0.857143      0.0  ...   \n",
       "3813        0.40        0.2             0.714286      0.0  ...   \n",
       "3879        0.40        0.2             0.428571      0.0  ...   \n",
       "3956        0.40        0.6             0.714286      0.0  ...   \n",
       "4130        0.40        0.2             0.285714      0.0  ...   \n",
       "4144        0.40        0.8             0.000000      0.0  ...   \n",
       "4188        0.40        0.8             0.571429      0.0  ...   \n",
       "4366        0.40        0.6             1.000000      0.0  ...   \n",
       "4672        0.40        0.4             0.714286      0.0  ...   \n",
       "\n",
       "      fuel_type-_هايبرد  origin_car-_تأجير  origin_car-_تجاري  \\\n",
       "2                     0                  0                  0   \n",
       "29                    0                  0                  0   \n",
       "168                   0                  0                  0   \n",
       "288                   0                  0                  0   \n",
       "304                   0                  0                  0   \n",
       "370                   0                  0                  0   \n",
       "765                   0                  0                  0   \n",
       "864                   0                  0                  0   \n",
       "993                   0                  0                  0   \n",
       "1371                  0                  0                  0   \n",
       "1500                  0                  0                  0   \n",
       "1627                  0                  0                  0   \n",
       "1724                  0                  0                  0   \n",
       "1927                  0                  0                  0   \n",
       "1951                  0                  0                  0   \n",
       "1977                  0                  0                  0   \n",
       "2082                  0                  0                  0   \n",
       "2110                  0                  0                  0   \n",
       "2112                  0                  0                  0   \n",
       "2223                  0                  0                  0   \n",
       "2342                  0                  0                  0   \n",
       "2355                  0                  0                  0   \n",
       "2655                  0                  0                  0   \n",
       "2691                  0                  0                  0   \n",
       "2721                  0                  0                  0   \n",
       "2792                  0                  0                  0   \n",
       "2931                  0                  0                  0   \n",
       "2937                  0                  0                  0   \n",
       "3097                  0                  0                  0   \n",
       "3110                  0                  0                  0   \n",
       "3259                  0                  0                  0   \n",
       "3332                  0                  0                  0   \n",
       "3365                  0                  0                  0   \n",
       "3572                  0                  0                  0   \n",
       "3797                  0                  0                  0   \n",
       "3813                  0                  0                  0   \n",
       "3879                  0                  0                  0   \n",
       "3956                  0                  0                  0   \n",
       "4130                  0                  0                  0   \n",
       "4144                  0                  0                  0   \n",
       "4188                  0                  0                  0   \n",
       "4366                  0                  0                  0   \n",
       "4672                  0                  0                  0   \n",
       "\n",
       "      origin_car-_تدريب سياقة  origin_car-_حكومي  origin_car-_خصوصي  \\\n",
       "2                           0                  0                  1   \n",
       "29                          0                  0                  1   \n",
       "168                         0                  0                  1   \n",
       "288                         0                  0                  1   \n",
       "304                         0                  0                  1   \n",
       "370                         0                  0                  1   \n",
       "765                         0                  0                  1   \n",
       "864                         0                  0                  1   \n",
       "993                         0                  0                  1   \n",
       "1371                        0                  0                  1   \n",
       "1500                        0                  0                  1   \n",
       "1627                        0                  0                  1   \n",
       "1724                        0                  0                  1   \n",
       "1927                        0                  0                  1   \n",
       "1951                        0                  0                  1   \n",
       "1977                        0                  0                  1   \n",
       "2082                        0                  0                  1   \n",
       "2110                        0                  0                  1   \n",
       "2112                        0                  0                  1   \n",
       "2223                        0                  0                  1   \n",
       "2342                        0                  0                  1   \n",
       "2355                        0                  0                  1   \n",
       "2655                        0                  0                  1   \n",
       "2691                        0                  0                  1   \n",
       "2721                        0                  0                  1   \n",
       "2792                        0                  0                  1   \n",
       "2931                        0                  0                  1   \n",
       "2937                        0                  0                  1   \n",
       "3097                        1                  0                  0   \n",
       "3110                        0                  0                  1   \n",
       "3259                        0                  0                  1   \n",
       "3332                        0                  0                  1   \n",
       "3365                        0                  0                  1   \n",
       "3572                        0                  0                  1   \n",
       "3797                        0                  0                  1   \n",
       "3813                        0                  0                  1   \n",
       "3879                        0                  0                  1   \n",
       "3956                        1                  0                  0   \n",
       "4130                        0                  0                  1   \n",
       "4144                        0                  0                  1   \n",
       "4188                        0                  0                  1   \n",
       "4366                        1                  0                  0   \n",
       "4672                        0                  0                  1   \n",
       "\n",
       "      origin_car-_عمومي  lime_type-_اوتوماتيك  lime_type-_عادي  \\\n",
       "2                     0                     1                0   \n",
       "29                    0                     1                0   \n",
       "168                   0                     1                0   \n",
       "288                   0                     1                0   \n",
       "304                   0                     1                0   \n",
       "370                   0                     1                0   \n",
       "765                   0                     1                0   \n",
       "864                   0                     1                0   \n",
       "993                   0                     0                1   \n",
       "1371                  0                     1                0   \n",
       "1500                  0                     1                0   \n",
       "1627                  0                     1                0   \n",
       "1724                  0                     1                0   \n",
       "1927                  0                     0                1   \n",
       "1951                  0                     1                0   \n",
       "1977                  0                     1                0   \n",
       "2082                  0                     0                1   \n",
       "2110                  0                     1                0   \n",
       "2112                  0                     0                1   \n",
       "2223                  0                     1                0   \n",
       "2342                  0                     1                0   \n",
       "2355                  0                     1                0   \n",
       "2655                  0                     1                0   \n",
       "2691                  0                     1                0   \n",
       "2721                  0                     1                0   \n",
       "2792                  0                     1                0   \n",
       "2931                  0                     1                0   \n",
       "2937                  0                     0                1   \n",
       "3097                  0                     1                0   \n",
       "3110                  0                     1                0   \n",
       "3259                  0                     1                0   \n",
       "3332                  0                     0                1   \n",
       "3365                  0                     1                0   \n",
       "3572                  0                     1                0   \n",
       "3797                  0                     1                0   \n",
       "3813                  0                     1                0   \n",
       "3879                  0                     1                0   \n",
       "3956                  0                     0                1   \n",
       "4130                  0                     1                0   \n",
       "4144                  0                     1                0   \n",
       "4188                  0                     1                0   \n",
       "4366                  0                     0                1   \n",
       "4672                  0                     1                0   \n",
       "\n",
       "      lime_type-_نصف اوتوماتيك  \n",
       "2                            0  \n",
       "29                           0  \n",
       "168                          0  \n",
       "288                          0  \n",
       "304                          0  \n",
       "370                          0  \n",
       "765                          0  \n",
       "864                          0  \n",
       "993                          0  \n",
       "1371                         0  \n",
       "1500                         0  \n",
       "1627                         0  \n",
       "1724                         0  \n",
       "1927                         0  \n",
       "1951                         0  \n",
       "1977                         0  \n",
       "2082                         0  \n",
       "2110                         0  \n",
       "2112                         0  \n",
       "2223                         0  \n",
       "2342                         0  \n",
       "2355                         0  \n",
       "2655                         0  \n",
       "2691                         0  \n",
       "2721                         0  \n",
       "2792                         0  \n",
       "2931                         0  \n",
       "2937                         0  \n",
       "3097                         0  \n",
       "3110                         0  \n",
       "3259                         0  \n",
       "3332                         0  \n",
       "3365                         0  \n",
       "3572                         0  \n",
       "3797                         0  \n",
       "3813                         0  \n",
       "3879                         0  \n",
       "3956                         0  \n",
       "4130                         0  \n",
       "4144                         0  \n",
       "4188                         0  \n",
       "4366                         0  \n",
       "4672                         0  \n",
       "\n",
       "[43 rows x 481 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered_data = cleaned_cars_data[cleaned_cars_data['Name-_هونداي افانتي'] == 1]\n",
    "filtered_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "19afd902",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('cars_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "6c103662",
   "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>اسم السيارة</th>\n",
       "      <th>موديل السيارة</th>\n",
       "      <th>سعر السيارة</th>\n",
       "      <th>لون السيارة</th>\n",
       "      <th>نوع الوقود</th>\n",
       "      <th>أصل السيارة</th>\n",
       "      <th>رخصة السيارة</th>\n",
       "      <th>نوع الجير</th>\n",
       "      <th>الزجاج</th>\n",
       "      <th>قوة الماتور</th>\n",
       "      <th>...</th>\n",
       "      <th>وسيلة الدفع</th>\n",
       "      <th>معروضة</th>\n",
       "      <th>أصحاب سابقون</th>\n",
       "      <th>إضافات</th>\n",
       "      <th>حالة الإعلان</th>\n",
       "      <th>تاريخ نشر الإعلان</th>\n",
       "      <th>تاريخ إنتهاء الإعلان</th>\n",
       "      <th>Number_of_Additions</th>\n",
       "      <th>فتحة السقف</th>\n",
       "      <th>الدفع</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>كيا اوبتيما</td>\n",
       "      <td>موديل سنة 2014</td>\n",
       "      <td>100000 شيكل</td>\n",
       "      <td>أبيض عاجي</td>\n",
       "      <td>بنزين</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>نقدا فقط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>يد اولى</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>2017-09-15</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>كيا سورينتو</td>\n",
       "      <td>موديل سنة 2007</td>\n",
       "      <td>60000 شيكل</td>\n",
       "      <td>سكني</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>نصف اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>...</td>\n",
       "      <td>إمكانية التقسيط</td>\n",
       "      <td>للبيع أو التبديل</td>\n",
       "      <td>2</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2017-08-16</td>\n",
       "      <td>2017-09-30</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>هونداي افانتي</td>\n",
       "      <td>موديل سنة 2006</td>\n",
       "      <td>43500 شيكل</td>\n",
       "      <td>سكني</td>\n",
       "      <td>بنزين</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>...</td>\n",
       "      <td>نقدا فقط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>NaN</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2017-08-19</td>\n",
       "      <td>2017-09-18</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6983</th>\n",
       "      <td>مرسيدس C220</td>\n",
       "      <td>موديل سنة 2009</td>\n",
       "      <td>90000 شيكل</td>\n",
       "      <td>فيراني</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>نقدا فقط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>يد ثانية</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2022-05-07</td>\n",
       "      <td>2022-07-06</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>دفع خلفي</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6984</th>\n",
       "      <td>نيسان كشكاي</td>\n",
       "      <td>موديل سنة 2014</td>\n",
       "      <td>95000 شيكل</td>\n",
       "      <td>فيراني</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>...</td>\n",
       "      <td>إمكانية التقسيط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>يد اولا</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقففرش ...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2022-05-07</td>\n",
       "      <td>2022-06-06</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>دفع أمامي</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6985</th>\n",
       "      <td>سكودا اوكتافيا</td>\n",
       "      <td>موديل سنة 2020</td>\n",
       "      <td>160000 شيكل</td>\n",
       "      <td>أبيض</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>إمكانية التقسيط</td>\n",
       "      <td>للبيع أو التبديل</td>\n",
       "      <td>0</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2022-05-08</td>\n",
       "      <td>2022-07-07</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>دفع أمامي</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6986</th>\n",
       "      <td>سكودا سوبيرب</td>\n",
       "      <td>موديل سنة 2018</td>\n",
       "      <td>119000 شيكل</td>\n",
       "      <td>أسود</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>نقدا فقط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>0</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2022-05-08</td>\n",
       "      <td>2022-06-12</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>دفع أمامي</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6987</th>\n",
       "      <td>كيا سورينتو</td>\n",
       "      <td>موديل سنة 2018</td>\n",
       "      <td>185000 شيكل</td>\n",
       "      <td>أبيض عاجي</td>\n",
       "      <td>ديزل</td>\n",
       "      <td>خصوصي</td>\n",
       "      <td>فلسطينية</td>\n",
       "      <td>نصف اوتوماتيك</td>\n",
       "      <td>الكتروني</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>إمكانية التقسيط</td>\n",
       "      <td>للبيع فقط</td>\n",
       "      <td>اولى</td>\n",
       "      <td>مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...</td>\n",
       "      <td>إعلان منتهي</td>\n",
       "      <td>2022-05-08</td>\n",
       "      <td>2022-07-07</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>دفع أمامي</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6988 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         اسم السيارة   موديل السيارة  سعر السيارة لون السيارة نوع الوقود  \\\n",
       "0        كيا اوبتيما  موديل سنة 2014  100000 شيكل   أبيض عاجي      بنزين   \n",
       "1                NaN             NaN          NaN         NaN        NaN   \n",
       "2                NaN             NaN          NaN         NaN        NaN   \n",
       "3        كيا سورينتو  موديل سنة 2007   60000 شيكل        سكني       ديزل   \n",
       "4      هونداي افانتي  موديل سنة 2006   43500 شيكل        سكني      بنزين   \n",
       "...              ...             ...          ...         ...        ...   \n",
       "6983     مرسيدس C220  موديل سنة 2009   90000 شيكل      فيراني       ديزل   \n",
       "6984     نيسان كشكاي  موديل سنة 2014   95000 شيكل      فيراني       ديزل   \n",
       "6985  سكودا اوكتافيا  موديل سنة 2020  160000 شيكل        أبيض       ديزل   \n",
       "6986    سكودا سوبيرب  موديل سنة 2018  119000 شيكل        أسود       ديزل   \n",
       "6987     كيا سورينتو  موديل سنة 2018  185000 شيكل   أبيض عاجي       ديزل   \n",
       "\n",
       "     أصل السيارة رخصة السيارة      نوع الجير    الزجاج  قوة الماتور  ...  \\\n",
       "0          خصوصي     فلسطينية      اوتوماتيك  الكتروني       2000.0  ...   \n",
       "1            NaN          NaN            NaN       NaN          NaN  ...   \n",
       "2            NaN          NaN            NaN       NaN          NaN  ...   \n",
       "3          خصوصي     فلسطينية  نصف اوتوماتيك  الكتروني       2500.0  ...   \n",
       "4          خصوصي     فلسطينية      اوتوماتيك  الكتروني       1600.0  ...   \n",
       "...          ...          ...            ...       ...          ...  ...   \n",
       "6983       خصوصي     فلسطينية      اوتوماتيك  الكتروني       2200.0  ...   \n",
       "6984       خصوصي     فلسطينية      اوتوماتيك  الكتروني       1600.0  ...   \n",
       "6985       خصوصي     فلسطينية      اوتوماتيك  الكتروني       2000.0  ...   \n",
       "6986       خصوصي     فلسطينية      اوتوماتيك  الكتروني       2000.0  ...   \n",
       "6987       خصوصي     فلسطينية  نصف اوتوماتيك  الكتروني       2200.0  ...   \n",
       "\n",
       "          وسيلة الدفع            معروضة أصحاب سابقون  \\\n",
       "0            نقدا فقط         للبيع فقط      يد اولى   \n",
       "1                 NaN               NaN          NaN   \n",
       "2                 NaN               NaN          NaN   \n",
       "3     إمكانية التقسيط  للبيع أو التبديل            2   \n",
       "4            نقدا فقط         للبيع فقط          NaN   \n",
       "...               ...               ...          ...   \n",
       "6983         نقدا فقط         للبيع فقط     يد ثانية   \n",
       "6984  إمكانية التقسيط         للبيع فقط      يد اولا   \n",
       "6985  إمكانية التقسيط  للبيع أو التبديل            0   \n",
       "6986         نقدا فقط         للبيع فقط            0   \n",
       "6987  إمكانية التقسيط         للبيع فقط         اولى   \n",
       "\n",
       "                                                 إضافات حالة الإعلان  \\\n",
       "0     مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...  إعلان منتهي   \n",
       "1                                                   NaN          NaN   \n",
       "2                                                   NaN          NaN   \n",
       "3     مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...  إعلان منتهي   \n",
       "4     مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...  إعلان منتهي   \n",
       "...                                                 ...          ...   \n",
       "6983  مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...  إعلان منتهي   \n",
       "6984  مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقففرش ...  إعلان منتهي   \n",
       "6985  مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...  إعلان منتهي   \n",
       "6986  مُكيّفإغلاق مركزيجهاز إنذارمسجل CDجنطات مغنيسي...  إعلان منتهي   \n",
       "6987  مُكيّفإغلاق مركزيجهاز إنذارمسجل CDفتحة سقفجنطا...  إعلان منتهي   \n",
       "\n",
       "     تاريخ نشر الإعلان تاريخ إنتهاء الإعلان Number_of_Additions فتحة السقف  \\\n",
       "0           2017-08-16           2017-09-15                 7.0        1.0   \n",
       "1                  NaN                  NaN                 NaN        NaN   \n",
       "2                  NaN                  NaN                 NaN        NaN   \n",
       "3           2017-08-16           2017-09-30                 7.0        1.0   \n",
       "4           2017-08-19           2017-09-18                 7.0        0.0   \n",
       "...                ...                  ...                 ...        ...   \n",
       "6983        2022-05-07           2022-07-06                 7.0        1.0   \n",
       "6984        2022-05-07           2022-06-06                 6.0        1.0   \n",
       "6985        2022-05-08           2022-07-07                 7.0        0.0   \n",
       "6986        2022-05-08           2022-06-12                 6.0        0.0   \n",
       "6987        2022-05-08           2022-07-07                 6.0        1.0   \n",
       "\n",
       "          الدفع  \n",
       "0           NaN  \n",
       "1           NaN  \n",
       "2           NaN  \n",
       "3           NaN  \n",
       "4           NaN  \n",
       "...         ...  \n",
       "6983   دفع خلفي  \n",
       "6984  دفع أمامي  \n",
       "6985  دفع أمامي  \n",
       "6986  دفع أمامي  \n",
       "6987  دفع أمامي  \n",
       "\n",
       "[6988 rows x 22 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "22dda2fd",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.18"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}