testing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "val = pd.read_csv('final oofs/lgb411_goss_tune_oof_val_pred.csv')\n",
    "test = pd.read_csv('final oofs/lgb411_goss_tune_oof_test_pred.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "SEED=411\n",
    "train_y = pd.read_csv(\"regression_target.csv\").deal_probability.values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.212845442353082"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(((val.iloc[:,0].values-train_y)**2).mean())**.5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "test_df = pd.read_csv(\"data/test.csv\", usecols=['item_id'])\n",
    "pd.DataFrame(np.clip(test.iloc[:,0].values,0,1), \n",
    "             index=test_df.item_id,\n",
    "             columns=['deal_probability']).to_csv('testsubmissionlgbgoss.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "train = pd.read_csv('data/train.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "train = train.loc[~train.image_top_1.isnull(),:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "imtop1 = pd.read_pickle('image_top_1_resnet_train')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "imtop1['image'] = imtop1['image'].map(lambda x: x.replace('.jpg', ''))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "train = train.merge(imtop1, on='image', how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>item_id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>region</th>\n",
       "      <th>city</th>\n",
       "      <th>parent_category_name</th>\n",
       "      <th>category_name</th>\n",
       "      <th>param_1</th>\n",
       "      <th>param_2</th>\n",
       "      <th>param_3</th>\n",
       "      <th>title</th>\n",
       "      <th>description</th>\n",
       "      <th>price</th>\n",
       "      <th>item_seq_number</th>\n",
       "      <th>activation_date</th>\n",
       "      <th>user_type</th>\n",
       "      <th>image</th>\n",
       "      <th>image_top_1</th>\n",
       "      <th>deal_probability</th>\n",
       "      <th>image_top_1_resnet</th>\n",
       "      <th>image_top_1_resnet_confidence</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>b912c3c6a6ad</td>\n",
       "      <td>e00f8ff2eaf9</td>\n",
       "      <td>Свердловская область</td>\n",
       "      <td>Екатеринбург</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Товары для детей и игрушки</td>\n",
       "      <td>Постельные принадлежности</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Кокоби(кокон для сна)</td>\n",
       "      <td>Кокон для сна малыша,пользовались меньше месяц...</td>\n",
       "      <td>400.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-03-28</td>\n",
       "      <td>Private</td>\n",
       "      <td>d10c7e016e03247a3bf2d13348fe959fe6f436c1caf64c...</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>0.12789</td>\n",
       "      <td>resnet_887</td>\n",
       "      <td>0.302808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2dac0150717d</td>\n",
       "      <td>39aeb48f0017</td>\n",
       "      <td>Самарская область</td>\n",
       "      <td>Самара</td>\n",
       "      <td>Для дома и дачи</td>\n",
       "      <td>Мебель и интерьер</td>\n",
       "      <td>Другое</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Стойка для Одежды</td>\n",
       "      <td>Стойка для одежды, под вешалки. С бутика.</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>19</td>\n",
       "      <td>2017-03-26</td>\n",
       "      <td>Private</td>\n",
       "      <td>79c9392cc51a9c81c6eb91eceb8e552171db39d7142700...</td>\n",
       "      <td>692.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_739</td>\n",
       "      <td>0.088708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ba83aefab5dc</td>\n",
       "      <td>91e2f88dd6e3</td>\n",
       "      <td>Ростовская область</td>\n",
       "      <td>Ростов-на-Дону</td>\n",
       "      <td>Бытовая электроника</td>\n",
       "      <td>Аудио и видео</td>\n",
       "      <td>Видео, DVD и Blu-ray плееры</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Philips bluray</td>\n",
       "      <td>В хорошем состоянии, домашний кинотеатр с blu ...</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>9</td>\n",
       "      <td>2017-03-20</td>\n",
       "      <td>Private</td>\n",
       "      <td>b7f250ee3f39e1fedd77c141f273703f4a9be59db4b48a...</td>\n",
       "      <td>3032.0</td>\n",
       "      <td>0.43177</td>\n",
       "      <td>resnet_632</td>\n",
       "      <td>0.670999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>02996f1dd2ea</td>\n",
       "      <td>bf5cccea572d</td>\n",
       "      <td>Татарстан</td>\n",
       "      <td>Набережные Челны</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Товары для детей и игрушки</td>\n",
       "      <td>Автомобильные кресла</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Автокресло</td>\n",
       "      <td>Продам кресло от0-25кг</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>286</td>\n",
       "      <td>2017-03-25</td>\n",
       "      <td>Company</td>\n",
       "      <td>e6ef97e0725637ea84e3d203e82dadb43ed3cc0a1c8413...</td>\n",
       "      <td>796.0</td>\n",
       "      <td>0.80323</td>\n",
       "      <td>resnet_615</td>\n",
       "      <td>0.268173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7c90be56d2ab</td>\n",
       "      <td>ef50846afc0b</td>\n",
       "      <td>Волгоградская область</td>\n",
       "      <td>Волгоград</td>\n",
       "      <td>Транспорт</td>\n",
       "      <td>Автомобили</td>\n",
       "      <td>С пробегом</td>\n",
       "      <td>ВАЗ (LADA)</td>\n",
       "      <td>2110</td>\n",
       "      <td>ВАЗ 2110, 2003</td>\n",
       "      <td>Все вопросы по телефону.</td>\n",
       "      <td>40000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-03-16</td>\n",
       "      <td>Private</td>\n",
       "      <td>54a687a3a0fc1d68aed99bdaaf551c5c70b761b16fd0a2...</td>\n",
       "      <td>2264.0</td>\n",
       "      <td>0.20797</td>\n",
       "      <td>resnet_609</td>\n",
       "      <td>0.660595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>51e0962387f7</td>\n",
       "      <td>bbfad0b1ad0a</td>\n",
       "      <td>Татарстан</td>\n",
       "      <td>Чистополь</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Товары для детей и игрушки</td>\n",
       "      <td>Автомобильные кресла</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Авто люлька</td>\n",
       "      <td>В хорошем состоянии</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>9</td>\n",
       "      <td>2017-03-28</td>\n",
       "      <td>Private</td>\n",
       "      <td>eb6ad1231c59d3dc7e4020e724ffe8e4d302023ddcbb99...</td>\n",
       "      <td>796.0</td>\n",
       "      <td>0.80323</td>\n",
       "      <td>resnet_560</td>\n",
       "      <td>0.830588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>c4f260a2b48a</td>\n",
       "      <td>08f469d2e6f7</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Нижний Новгород</td>\n",
       "      <td>Для дома и дачи</td>\n",
       "      <td>Ремонт и строительство</td>\n",
       "      <td>Сантехника и сауна</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Водонагреватель 100 литров нержавейка плоский</td>\n",
       "      <td>Электро водонагреватель накопительный на 100 л...</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>125</td>\n",
       "      <td>2017-03-23</td>\n",
       "      <td>Private</td>\n",
       "      <td>0330f6ac561f5db1fa8226dd5e7e127b5671d44d075a98...</td>\n",
       "      <td>2823.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_605</td>\n",
       "      <td>0.305495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>6b71309d6a8a</td>\n",
       "      <td>fef86baa002c</td>\n",
       "      <td>Пермский край</td>\n",
       "      <td>Пермь</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Джинсы</td>\n",
       "      <td>26</td>\n",
       "      <td>Бойфренды colins</td>\n",
       "      <td>Бойфренды в хорошем состоянии.</td>\n",
       "      <td>500.0</td>\n",
       "      <td>61</td>\n",
       "      <td>2017-03-25</td>\n",
       "      <td>Private</td>\n",
       "      <td>9bab29a519e81c14f4582024adfebd4f11a4ac71d323a6...</td>\n",
       "      <td>567.0</td>\n",
       "      <td>0.80323</td>\n",
       "      <td>resnet_608</td>\n",
       "      <td>0.999852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>c5b969cb63a2</td>\n",
       "      <td>055825270190</td>\n",
       "      <td>Оренбургская область</td>\n",
       "      <td>Оренбург</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Платья и юбки</td>\n",
       "      <td>&gt; 50 (XXL)</td>\n",
       "      <td>Платье</td>\n",
       "      <td>54 раз мер очень удобное</td>\n",
       "      <td>500.0</td>\n",
       "      <td>85</td>\n",
       "      <td>2017-03-17</td>\n",
       "      <td>Private</td>\n",
       "      <td>75ce06d1f939a31dfb2af8ac55f08fa998fa336d13ee05...</td>\n",
       "      <td>415.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_614</td>\n",
       "      <td>0.191267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>b1570962e68c</td>\n",
       "      <td>f9e8f831d94c</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Нижний Новгород</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Детская одежда и обувь</td>\n",
       "      <td>Для девочек</td>\n",
       "      <td>Обувь</td>\n",
       "      <td>25</td>\n",
       "      <td>Полу ботиночки замш натур.Бамбини</td>\n",
       "      <td>По стельке 15.5см мерить приокский район. Цвет...</td>\n",
       "      <td>400.0</td>\n",
       "      <td>136</td>\n",
       "      <td>2017-03-22</td>\n",
       "      <td>Company</td>\n",
       "      <td>54fb8521135fda77a860bfd2fac6bf46867ab7c06796e3...</td>\n",
       "      <td>46.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_502</td>\n",
       "      <td>0.631085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>d5480bb4a6e4</td>\n",
       "      <td>d46200940f37</td>\n",
       "      <td>Ханты-Мансийский АО</td>\n",
       "      <td>Ханты-Мансийск</td>\n",
       "      <td>Недвижимость</td>\n",
       "      <td>Квартиры</td>\n",
       "      <td>Сдам</td>\n",
       "      <td>На длительный срок</td>\n",
       "      <td>1</td>\n",
       "      <td>1-к квартира, 25 м², 2/2 эт.</td>\n",
       "      <td>Сдается однокомнатная мебелированная квартира ...</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>2017-03-25</td>\n",
       "      <td>Private</td>\n",
       "      <td>645d3fb949cb116a00c596ca1e168d8c5ddd21cdeacc5a...</td>\n",
       "      <td>1396.0</td>\n",
       "      <td>0.58853</td>\n",
       "      <td>resnet_799</td>\n",
       "      <td>0.313318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>86f41f50d8c1</td>\n",
       "      <td>35c2b6b654e0</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>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2017-03-19</td>\n",
       "      <td>Shop</td>\n",
       "      <td>5162fdb7d8427738370d3145647d2726546f65631e5de9...</td>\n",
       "      <td>119.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_608</td>\n",
       "      <td>0.868692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>645237cb3601</td>\n",
       "      <td>fc9a38b79414</td>\n",
       "      <td>Оренбургская область</td>\n",
       "      <td>Оренбург</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Товары для детей и игрушки</td>\n",
       "      <td>Товары для школы</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Атласы и Контурныя карты за 8 класс</td>\n",
       "      <td>Атлас история нового времени,19 век./\\nКонтурн...</td>\n",
       "      <td>70.0</td>\n",
       "      <td>15</td>\n",
       "      <td>2017-03-21</td>\n",
       "      <td>Private</td>\n",
       "      <td>5ba63fecb66633cde074c661e0249e26af5cf370241e13...</td>\n",
       "      <td>1040.0</td>\n",
       "      <td>0.13858</td>\n",
       "      <td>resnet_921</td>\n",
       "      <td>0.961335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>df2116f34563</td>\n",
       "      <td>3ce3c2318b16</td>\n",
       "      <td>Ростовская область</td>\n",
       "      <td>Ростов-на-Дону</td>\n",
       "      <td>Бытовая электроника</td>\n",
       "      <td>Товары для компьютера</td>\n",
       "      <td>Мониторы</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Монитор acer 18.5</td>\n",
       "      <td>Продам манитор 18.5 v193HQV. В хорошем состоянии</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>47</td>\n",
       "      <td>2017-03-22</td>\n",
       "      <td>Private</td>\n",
       "      <td>0c84cef077d10e5bb37af78049fb0a593c9f1c7f37f458...</td>\n",
       "      <td>2849.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_592</td>\n",
       "      <td>0.525821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>a97943ae8158</td>\n",
       "      <td>f643d87dd23c</td>\n",
       "      <td>Башкортостан</td>\n",
       "      <td>Туймазы</td>\n",
       "      <td>Животные</td>\n",
       "      <td>Собаки</td>\n",
       "      <td>Немецкая овчарка</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Продаются щенки немецкой овчарки</td>\n",
       "      <td>родились 1 февраля,три кобеля и сучка.</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>2017-03-23</td>\n",
       "      <td>Private</td>\n",
       "      <td>09ebf4b30bad5857a1f26cd18d907c1e888bbe718bb13d...</td>\n",
       "      <td>2133.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_224</td>\n",
       "      <td>0.289771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>4b6abd0a5921</td>\n",
       "      <td>94de2b374869</td>\n",
       "      <td>Татарстан</td>\n",
       "      <td>Казань</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Платья и юбки</td>\n",
       "      <td>42–44 (S)</td>\n",
       "      <td>Платье женское новое</td>\n",
       "      <td>Одето 1 раз на пару часов. Длина 79. Можно кор...</td>\n",
       "      <td>800.0</td>\n",
       "      <td>86</td>\n",
       "      <td>2017-03-27</td>\n",
       "      <td>Private</td>\n",
       "      <td>df76951e5cc7073553ea3214fd2024b9f80166828a5356...</td>\n",
       "      <td>408.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_655</td>\n",
       "      <td>0.522465</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7896ef8fe482</td>\n",
       "      <td>007c6bd858cb</td>\n",
       "      <td>Краснодарский край</td>\n",
       "      <td>Краснодар</td>\n",
       "      <td>Транспорт</td>\n",
       "      <td>Автомобили</td>\n",
       "      <td>С пробегом</td>\n",
       "      <td>Chevrolet</td>\n",
       "      <td>Lanos</td>\n",
       "      <td>Chevrolet Lanos, 2008</td>\n",
       "      <td>Кондиционер, гидроусилитель руля, электрически...</td>\n",
       "      <td>140000.0</td>\n",
       "      <td>201</td>\n",
       "      <td>2017-03-18</td>\n",
       "      <td>Company</td>\n",
       "      <td>5244375e00cb2baefa50f4b01156cc492f8733b93c6cba...</td>\n",
       "      <td>1118.0</td>\n",
       "      <td>0.32100</td>\n",
       "      <td>resnet_717</td>\n",
       "      <td>0.410075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>7882b1e77748</td>\n",
       "      <td>7a3fda0cdf94</td>\n",
       "      <td>Новосибирская область</td>\n",
       "      <td>Новосибирск</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Товары для детей и игрушки</td>\n",
       "      <td>Игрушки</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Объемная цифра 2</td>\n",
       "      <td>Размеры 75*53*15. Основа-картон, декор-гофриро...</td>\n",
       "      <td>500.0</td>\n",
       "      <td>9</td>\n",
       "      <td>2017-03-20</td>\n",
       "      <td>Private</td>\n",
       "      <td>0cdd241246bd930c0026315484d87817c47ce4d586d99b...</td>\n",
       "      <td>983.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_868</td>\n",
       "      <td>0.313282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>071e1ed13c5c</td>\n",
       "      <td>325cacee50f4</td>\n",
       "      <td>Омская область</td>\n",
       "      <td>Москаленки</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Верхняя одежда</td>\n",
       "      <td>44–46 (M)</td>\n",
       "      <td>Куртка весенняя(осенняя)</td>\n",
       "      <td>Куртка новая, очень удобная, ценник был утерян...</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2017-03-24</td>\n",
       "      <td>Private</td>\n",
       "      <td>1a60aa7ac1bab4fac1171650369e19d2e6872483d89032...</td>\n",
       "      <td>95.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_797</td>\n",
       "      <td>0.200972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ea12aec32ec3</td>\n",
       "      <td>06ee4ff4e99c</td>\n",
       "      <td>Новосибирская область</td>\n",
       "      <td>Бердск</td>\n",
       "      <td>Недвижимость</td>\n",
       "      <td>Квартиры</td>\n",
       "      <td>Продам</td>\n",
       "      <td>2</td>\n",
       "      <td>Вторичка</td>\n",
       "      <td>2-к квартира, 44 м², 5/5 эт.</td>\n",
       "      <td>Дом находиться внутри квартала./\\nПластиковые ...</td>\n",
       "      <td>1748000.0</td>\n",
       "      <td>461</td>\n",
       "      <td>2017-03-17</td>\n",
       "      <td>Company</td>\n",
       "      <td>e9fb67b3d22cbf7cf569337780aea8a5c1ddac8b4b6b74...</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_738</td>\n",
       "      <td>0.151410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>de310e6aae86</td>\n",
       "      <td>0178e6308f38</td>\n",
       "      <td>Челябинская область</td>\n",
       "      <td>Магнитогорск</td>\n",
       "      <td>Транспорт</td>\n",
       "      <td>Автомобили</td>\n",
       "      <td>С пробегом</td>\n",
       "      <td>Ford</td>\n",
       "      <td>Focus</td>\n",
       "      <td>Ford Focus, 2005</td>\n",
       "      <td>Полная комплектация. ГУР. 4 эсп.  Подогрев сид...</td>\n",
       "      <td>249000.0</td>\n",
       "      <td>12</td>\n",
       "      <td>2017-03-20</td>\n",
       "      <td>Private</td>\n",
       "      <td>1c873f41cea87bc32f52d0a99cf5ff6a33305f0542b7f7...</td>\n",
       "      <td>2264.0</td>\n",
       "      <td>0.10334</td>\n",
       "      <td>resnet_468</td>\n",
       "      <td>0.324867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>08b24e170109</td>\n",
       "      <td>6630d724bbf5</td>\n",
       "      <td>Ростовская область</td>\n",
       "      <td>Ростов-на-Дону</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Детская одежда и обувь</td>\n",
       "      <td>Для девочек</td>\n",
       "      <td>Обувь</td>\n",
       "      <td>25</td>\n",
       "      <td>Туфли moschino</td>\n",
       "      <td>Очень красивые стильные туфельки, состояние от...</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>59</td>\n",
       "      <td>2017-03-20</td>\n",
       "      <td>Private</td>\n",
       "      <td>6edfface637bd8f85e5614b57a840cb7ec168aed081ba4...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_643</td>\n",
       "      <td>0.287440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>065a4daba35f</td>\n",
       "      <td>19a5cd02c89b</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Нижний Новгород</td>\n",
       "      <td>Животные</td>\n",
       "      <td>Товары для животных</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Таблетки бравекто</td>\n",
       "      <td>Таблетки \"Бравекто\" от блох и клещей по ценам:...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>310</td>\n",
       "      <td>2017-03-16</td>\n",
       "      <td>Company</td>\n",
       "      <td>22babf609cfcbca6b1d5ca81321fd6f58e873903c8fc0a...</td>\n",
       "      <td>843.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_844</td>\n",
       "      <td>0.516069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>990113ae4f1c</td>\n",
       "      <td>d9b494f97062</td>\n",
       "      <td>Воронежская область</td>\n",
       "      <td>Воронеж</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Товары для детей и игрушки</td>\n",
       "      <td>Игрушки</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Пинки Пай My Little Pony</td>\n",
       "      <td>Пинки Пай ждёт любящую хозяйку./\\nВ комплекте ...</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>309</td>\n",
       "      <td>2017-03-24</td>\n",
       "      <td>Company</td>\n",
       "      <td>a8f76b8abea964400c4075cedaea9f7a0c970b5a5f2f8e...</td>\n",
       "      <td>957.0</td>\n",
       "      <td>0.10796</td>\n",
       "      <td>resnet_850</td>\n",
       "      <td>0.494834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>78164bc09657</td>\n",
       "      <td>721c2f914f63</td>\n",
       "      <td>Самарская область</td>\n",
       "      <td>Тольятти</td>\n",
       "      <td>Для дома и дачи</td>\n",
       "      <td>Мебель и интерьер</td>\n",
       "      <td>Текстиль и ковры</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ламбрикен</td>\n",
       "      <td>Продам ламбрикен в хорошем состоянии,длина 2,20.</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>59</td>\n",
       "      <td>2017-03-26</td>\n",
       "      <td>Private</td>\n",
       "      <td>b3c27bf75ffb0dad53a1f4a04fc8c335040468879b1365...</td>\n",
       "      <td>1420.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_854</td>\n",
       "      <td>0.913493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>fbe29970a8a5</td>\n",
       "      <td>2f0e2746d462</td>\n",
       "      <td>Кемеровская область</td>\n",
       "      <td>Новокузнецк</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Обувь</td>\n",
       "      <td>37</td>\n",
       "      <td>Ботинки</td>\n",
       "      <td>Ботинки б/у в хорошем состоянии. Размер 37</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>8</td>\n",
       "      <td>2017-03-27</td>\n",
       "      <td>Private</td>\n",
       "      <td>1d0cc04d7e20f696fbdc181dd3ab9ea964b57b46a981c9...</td>\n",
       "      <td>436.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_774</td>\n",
       "      <td>0.637281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>71d9399b59a2</td>\n",
       "      <td>965ee1e259eb</td>\n",
       "      <td>Саратовская область</td>\n",
       "      <td>Саратов</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Платья и юбки</td>\n",
       "      <td>46–48 (L)</td>\n",
       "      <td>Продаю новое платье</td>\n",
       "      <td>Новое, очень нарядное платье, Рост 170 см, раз...</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>12</td>\n",
       "      <td>2017-03-25</td>\n",
       "      <td>Private</td>\n",
       "      <td>c4f1d5ccdbda96f2a4718f997318813c84de9e057d3528...</td>\n",
       "      <td>618.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_578</td>\n",
       "      <td>0.259102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>4941f0385575</td>\n",
       "      <td>d283308a713b</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Нижний Новгород</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Детская одежда и обувь</td>\n",
       "      <td>Для мальчиков</td>\n",
       "      <td>Другое</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Песочник Crockid</td>\n",
       "      <td>Состояние хорошее, носили мало.</td>\n",
       "      <td>200.0</td>\n",
       "      <td>20</td>\n",
       "      <td>2017-03-19</td>\n",
       "      <td>Private</td>\n",
       "      <td>659081173b0a320fae12fe7f8f7bbf9e361444cfcf5ff8...</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_911</td>\n",
       "      <td>0.305007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>af9d5b0eadc9</td>\n",
       "      <td>ff3f46835373</td>\n",
       "      <td>Ростовская область</td>\n",
       "      <td>Аксай</td>\n",
       "      <td>Для дома и дачи</td>\n",
       "      <td>Ремонт и строительство</td>\n",
       "      <td>Стройматериалы</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Фасадные панели</td>\n",
       "      <td>Уникальные свойства фасадных панелей FineBer п...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>2017-03-25</td>\n",
       "      <td>Private</td>\n",
       "      <td>fb5c2ee81f10750f4142d2028707a779c7e95576bb180d...</td>\n",
       "      <td>1282.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_634</td>\n",
       "      <td>0.432811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1b080aa4a17d</td>\n",
       "      <td>68ee0dc56c28</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Нижний Новгород</td>\n",
       "      <td>Животные</td>\n",
       "      <td>Другие животные</td>\n",
       "      <td>С/х животные</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Бычки</td>\n",
       "      <td>продаю бычков на откорм веса от 150 до 220</td>\n",
       "      <td>130.0</td>\n",
       "      <td>18</td>\n",
       "      <td>2017-03-28</td>\n",
       "      <td>Private</td>\n",
       "      <td>d507fc90a72ae0a6c5b74e0ab6cd723680450c3af4f466...</td>\n",
       "      <td>2195.0</td>\n",
       "      <td>0.78501</td>\n",
       "      <td>resnet_580</td>\n",
       "      <td>0.587181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390806</th>\n",
       "      <td>c346749a7127</td>\n",
       "      <td>6df435165550</td>\n",
       "      <td>Ростовская область</td>\n",
       "      <td>Ростов-на-Дону</td>\n",
       "      <td>Для дома и дачи</td>\n",
       "      <td>Мебель и интерьер</td>\n",
       "      <td>Шкафы и комоды</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Офисная мебель</td>\n",
       "      <td>В связи с оптимизацией помещений, продаю офисн...</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>5</td>\n",
       "      <td>2017-03-16</td>\n",
       "      <td>Private</td>\n",
       "      <td>42a0eeeed54478f2fb8d7cbf9b8ed2a53ed39eb7c2bb32...</td>\n",
       "      <td>1460.0</td>\n",
       "      <td>0.33720</td>\n",
       "      <td>resnet_553</td>\n",
       "      <td>0.929934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390807</th>\n",
       "      <td>3c073bb117d8</td>\n",
       "      <td>f3db5b0b12a1</td>\n",
       "      <td>Иркутская область</td>\n",
       "      <td>Братск</td>\n",
       "      <td>Транспорт</td>\n",
       "      <td>Мотоциклы и мототехника</td>\n",
       "      <td>Вездеходы</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Продам болотоход юпитер 3</td>\n",
       "      <td>продам болотоход юпитер 3</td>\n",
       "      <td>20000.0</td>\n",
       "      <td>41</td>\n",
       "      <td>2017-03-28</td>\n",
       "      <td>Company</td>\n",
       "      <td>9765edf15ac427120c1359e3d4dd813a475cc4f4b94701...</td>\n",
       "      <td>1142.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_665</td>\n",
       "      <td>0.710614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390808</th>\n",
       "      <td>6fcc0d49b22d</td>\n",
       "      <td>cd553840f1a2</td>\n",
       "      <td>Тульская область</td>\n",
       "      <td>Кимовск</td>\n",
       "      <td>Хобби и отдых</td>\n",
       "      <td>Музыкальные инструменты</td>\n",
       "      <td>Пианино и другие клавишные</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Пианино Аккорд</td>\n",
       "      <td>Находится в Кимовске. Самовывоз</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32</td>\n",
       "      <td>2017-03-21</td>\n",
       "      <td>Private</td>\n",
       "      <td>17558d450f7de115acc61ec7bc08073443e14753940d8a...</td>\n",
       "      <td>2514.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_881</td>\n",
       "      <td>0.974792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390809</th>\n",
       "      <td>f7cb51309717</td>\n",
       "      <td>a96bf12eaaba</td>\n",
       "      <td>Ярославская область</td>\n",
       "      <td>Ярославль</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Верхняя одежда</td>\n",
       "      <td>44–46 (M)</td>\n",
       "      <td>Жакет</td>\n",
       "      <td>Стильный жакет. Можно и для беременной, можно ...</td>\n",
       "      <td>450.0</td>\n",
       "      <td>36</td>\n",
       "      <td>2017-03-20</td>\n",
       "      <td>Private</td>\n",
       "      <td>756323281a7579f2bd1c8fc66182f13c0c5d9817424bbb...</td>\n",
       "      <td>569.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_474</td>\n",
       "      <td>0.756632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390810</th>\n",
       "      <td>cb74d5fa1498</td>\n",
       "      <td>141a6ebb6456</td>\n",
       "      <td>Красноярский край</td>\n",
       "      <td>Красноярск</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Верхняя одежда</td>\n",
       "      <td>44–46 (M)</td>\n",
       "      <td>Пальто демисезонное</td>\n",
       "      <td>пальто,фирмы \"Белла\",  размер 46, цвет \"фуксия...</td>\n",
       "      <td>500.0</td>\n",
       "      <td>8</td>\n",
       "      <td>2017-03-18</td>\n",
       "      <td>Private</td>\n",
       "      <td>224a4b70e48a6ce3acdc8cebe3d8df7e1740472954a766...</td>\n",
       "      <td>523.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_834</td>\n",
       "      <td>0.837981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390811</th>\n",
       "      <td>55760672b23e</td>\n",
       "      <td>085e58413b19</td>\n",
       "      <td>Волгоградская область</td>\n",
       "      <td>Волгоград</td>\n",
       "      <td>Хобби и отдых</td>\n",
       "      <td>Книги и журналы</td>\n",
       "      <td>Книги</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Серия книг \"Бессмертные \" все сразу</td>\n",
       "      <td>Цена за все книги оптом</td>\n",
       "      <td>300.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-03-26</td>\n",
       "      <td>Private</td>\n",
       "      <td>4e711d8c72b89b011d30df969aeca7599646f3912fb5a6...</td>\n",
       "      <td>2286.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_711</td>\n",
       "      <td>0.418764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390812</th>\n",
       "      <td>15dc060224ab</td>\n",
       "      <td>13d487ead5a2</td>\n",
       "      <td>Воронежская область</td>\n",
       "      <td>Новая Усмань</td>\n",
       "      <td>Бытовая электроника</td>\n",
       "      <td>Товары для компьютера</td>\n",
       "      <td>Комплектующие</td>\n",
       "      <td>Оперативная память</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Оперативная память</td>\n",
       "      <td>NaN</td>\n",
       "      <td>400.0</td>\n",
       "      <td>12</td>\n",
       "      <td>2017-03-20</td>\n",
       "      <td>Private</td>\n",
       "      <td>f3ccc832ed847c606080e4d26456d5bdefd601e8703e85...</td>\n",
       "      <td>2853.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_626</td>\n",
       "      <td>0.130859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390813</th>\n",
       "      <td>87cb486a418d</td>\n",
       "      <td>bd8cd55a533a</td>\n",
       "      <td>Ханты-Мансийский АО</td>\n",
       "      <td>Нефтеюганск</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Детская одежда и обувь</td>\n",
       "      <td>Для девочек</td>\n",
       "      <td>Брюки</td>\n",
       "      <td>98-104 см (2-4 года)</td>\n",
       "      <td>Джинсы для девочек</td>\n",
       "      <td>Состояние хорошее. Демисезонные</td>\n",
       "      <td>250.0</td>\n",
       "      <td>6</td>\n",
       "      <td>2017-03-26</td>\n",
       "      <td>Private</td>\n",
       "      <td>b75fc36c2432cc50b11ba789e360e60a8929b2b9daf1c5...</td>\n",
       "      <td>118.0</td>\n",
       "      <td>0.14989</td>\n",
       "      <td>resnet_608</td>\n",
       "      <td>0.743174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390814</th>\n",
       "      <td>5e317564107b</td>\n",
       "      <td>7d2bc0de4caa</td>\n",
       "      <td>Самарская область</td>\n",
       "      <td>Самара</td>\n",
       "      <td>Транспорт</td>\n",
       "      <td>Автомобили</td>\n",
       "      <td>С пробегом</td>\n",
       "      <td>BMW</td>\n",
       "      <td>3 серия</td>\n",
       "      <td>BMW 3 серия, 2009</td>\n",
       "      <td>Продаю bmw 3 серии в прекрасном состоянии, пра...</td>\n",
       "      <td>720000.0</td>\n",
       "      <td>61</td>\n",
       "      <td>2017-03-20</td>\n",
       "      <td>Private</td>\n",
       "      <td>709729b67a3dafba282b5299ab76cf95ec97abd35eec55...</td>\n",
       "      <td>1118.0</td>\n",
       "      <td>0.23044</td>\n",
       "      <td>resnet_656</td>\n",
       "      <td>0.603287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390815</th>\n",
       "      <td>d630ca83fc9e</td>\n",
       "      <td>ad73bbe882db</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Нижний Новгород</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Детская одежда и обувь</td>\n",
       "      <td>Для девочек</td>\n",
       "      <td>Обувь</td>\n",
       "      <td>&lt; 19</td>\n",
       "      <td>Сандалии Таши Орто</td>\n",
       "      <td>Продам сандалии б/у,размер 18 на первые шаги,п...</td>\n",
       "      <td>500.0</td>\n",
       "      <td>23</td>\n",
       "      <td>2017-03-20</td>\n",
       "      <td>Private</td>\n",
       "      <td>9719775bb3aa3f87be91caf3545efbd262a3d02b89ac4e...</td>\n",
       "      <td>93.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_774</td>\n",
       "      <td>0.786317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390816</th>\n",
       "      <td>732b69fced92</td>\n",
       "      <td>94a9c852a234</td>\n",
       "      <td>Самарская область</td>\n",
       "      <td>Самара</td>\n",
       "      <td>Транспорт</td>\n",
       "      <td>Автомобили</td>\n",
       "      <td>С пробегом</td>\n",
       "      <td>Mercedes-Benz</td>\n",
       "      <td>M-класс</td>\n",
       "      <td>Mercedes-Benz M-класс, 2008</td>\n",
       "      <td>В отличном состоянии, вложений не требует, 100...</td>\n",
       "      <td>1300000.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-03-28</td>\n",
       "      <td>Private</td>\n",
       "      <td>4d3f4f83f0c065f26ec64fac298936e3a4b0b505402fb0...</td>\n",
       "      <td>1055.0</td>\n",
       "      <td>0.01232</td>\n",
       "      <td>resnet_609</td>\n",
       "      <td>0.429230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390817</th>\n",
       "      <td>fc8ff7c77732</td>\n",
       "      <td>049099972988</td>\n",
       "      <td>Калининградская область</td>\n",
       "      <td>Калининград</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Товары для детей и игрушки</td>\n",
       "      <td>Детская мебель</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Продается шезлонг фирмы Чико</td>\n",
       "      <td>Продается детский шезлонг +0 до 9 кг. В отличн...</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>39</td>\n",
       "      <td>2017-03-26</td>\n",
       "      <td>Private</td>\n",
       "      <td>c5774df8edc744e41c174a3e7987d93359c71e10937aef...</td>\n",
       "      <td>821.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_675</td>\n",
       "      <td>0.174481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390818</th>\n",
       "      <td>bb532fcc7dec</td>\n",
       "      <td>391e0fa1bb2d</td>\n",
       "      <td>Краснодарский край</td>\n",
       "      <td>Холмская</td>\n",
       "      <td>Для дома и дачи</td>\n",
       "      <td>Ремонт и строительство</td>\n",
       "      <td>Садовая техника</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Садовая тачка</td>\n",
       "      <td>В отличном состоянии /\\nзабирать в холмской центр</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>259</td>\n",
       "      <td>2017-03-16</td>\n",
       "      <td>Private</td>\n",
       "      <td>38eb5445db2433f192d0d7383761177e71aaf56f206351...</td>\n",
       "      <td>1348.0</td>\n",
       "      <td>0.86521</td>\n",
       "      <td>resnet_428</td>\n",
       "      <td>0.367337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390819</th>\n",
       "      <td>ff2a88b765c6</td>\n",
       "      <td>152a1d5e6178</td>\n",
       "      <td>Свердловская область</td>\n",
       "      <td>Екатеринбург</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Детская одежда и обувь</td>\n",
       "      <td>Для мальчиков</td>\n",
       "      <td>Верхняя одежда</td>\n",
       "      <td>86-92 см (1-2 года)</td>\n",
       "      <td>Лёгкая куртка размер 92</td>\n",
       "      <td>Двусторонняя!</td>\n",
       "      <td>300.0</td>\n",
       "      <td>33</td>\n",
       "      <td>2017-03-19</td>\n",
       "      <td>Private</td>\n",
       "      <td>e0fef616352e4834f1a2023d8884582b8ed460b2745c3b...</td>\n",
       "      <td>53.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_400</td>\n",
       "      <td>0.132794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390820</th>\n",
       "      <td>d23a9e2a65e1</td>\n",
       "      <td>02652bf7abdd</td>\n",
       "      <td>Саратовская область</td>\n",
       "      <td>Саратов</td>\n",
       "      <td>Недвижимость</td>\n",
       "      <td>Коммерческая недвижимость</td>\n",
       "      <td>Продам</td>\n",
       "      <td>Офисное помещение</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Нежилое помещение</td>\n",
       "      <td>Продается 4 офисных помещения площадью от 106 ...</td>\n",
       "      <td>1600000.0</td>\n",
       "      <td>24</td>\n",
       "      <td>2017-03-20</td>\n",
       "      <td>Company</td>\n",
       "      <td>072bf1c8af2f3a046bdfbe4e65b7343b4884c48b396194...</td>\n",
       "      <td>2221.0</td>\n",
       "      <td>0.12384</td>\n",
       "      <td>resnet_918</td>\n",
       "      <td>0.995208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390821</th>\n",
       "      <td>79386f3f2573</td>\n",
       "      <td>e8788c35b158</td>\n",
       "      <td>Воронежская область</td>\n",
       "      <td>Воронеж</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Детская одежда и обувь</td>\n",
       "      <td>Для девочек</td>\n",
       "      <td>Платья и юбки</td>\n",
       "      <td>98-104 см (2-4 года)</td>\n",
       "      <td>Нвые платья</td>\n",
       "      <td>Новые платья разные в наличии!!!</td>\n",
       "      <td>480.0</td>\n",
       "      <td>145</td>\n",
       "      <td>2017-03-22</td>\n",
       "      <td>Company</td>\n",
       "      <td>b7188a3b2f7ec022758297933d20843d40bd0f8cbf6ea6...</td>\n",
       "      <td>127.0</td>\n",
       "      <td>0.12459</td>\n",
       "      <td>resnet_610</td>\n",
       "      <td>0.542376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390822</th>\n",
       "      <td>2bc8c895545b</td>\n",
       "      <td>f1fbfb3dc6fa</td>\n",
       "      <td>Краснодарский край</td>\n",
       "      <td>Новороссийск</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Платья и юбки</td>\n",
       "      <td>44–46 (M)</td>\n",
       "      <td>Платье женское</td>\n",
       "      <td>Платье очень комфортное, покупала на праздник,...</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>26</td>\n",
       "      <td>2017-03-22</td>\n",
       "      <td>Private</td>\n",
       "      <td>e1138cb112dd93a0fb12d84bec55177dbff3decd184002...</td>\n",
       "      <td>387.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_578</td>\n",
       "      <td>0.618816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390823</th>\n",
       "      <td>43ad2ec1cd29</td>\n",
       "      <td>b1ff78e0d361</td>\n",
       "      <td>Алтайский край</td>\n",
       "      <td>Новоалтайск</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Трикотаж</td>\n",
       "      <td>42–44 (S)</td>\n",
       "      <td>Кофта</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.0</td>\n",
       "      <td>17</td>\n",
       "      <td>2017-03-26</td>\n",
       "      <td>Private</td>\n",
       "      <td>96a65b018d54fe4a59614ac2574003d879635df19c80bf...</td>\n",
       "      <td>590.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_480</td>\n",
       "      <td>0.265408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390824</th>\n",
       "      <td>872691eb6232</td>\n",
       "      <td>c257da473f0b</td>\n",
       "      <td>Красноярский край</td>\n",
       "      <td>Красноярск</td>\n",
       "      <td>Хобби и отдых</td>\n",
       "      <td>Коллекционирование</td>\n",
       "      <td>Грампластинки</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Винил пластинка СССР А. Кальянов Жена жена</td>\n",
       "      <td>Виниловай грампластинка. /\\nСостояние конверта...</td>\n",
       "      <td>150.0</td>\n",
       "      <td>78</td>\n",
       "      <td>2017-03-21</td>\n",
       "      <td>Company</td>\n",
       "      <td>c7ca77c0fa64ccc68e7a2ec620d969c2212b206afd3cfc...</td>\n",
       "      <td>2402.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_921</td>\n",
       "      <td>0.940897</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390825</th>\n",
       "      <td>00b6a41d5af9</td>\n",
       "      <td>704b0a259816</td>\n",
       "      <td>Ханты-Мансийский АО</td>\n",
       "      <td>Когалым</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Товары для детей и игрушки</td>\n",
       "      <td>Детские коляски</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Продам коляску 2в1</td>\n",
       "      <td>Коляска в идеальном состоянии, практически не ...</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>77</td>\n",
       "      <td>2017-03-16</td>\n",
       "      <td>Private</td>\n",
       "      <td>2b2cc11564c63b2dc66d2bef5b94ede8f54108521411f1...</td>\n",
       "      <td>2336.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_621</td>\n",
       "      <td>0.177701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390826</th>\n",
       "      <td>72be5f7bac89</td>\n",
       "      <td>548d266baeda</td>\n",
       "      <td>Алтайский край</td>\n",
       "      <td>Бийск</td>\n",
       "      <td>Для дома и дачи</td>\n",
       "      <td>Мебель и интерьер</td>\n",
       "      <td>Кровати, диваны и кресла</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Мягкая мебель</td>\n",
       "      <td>продам мягкую мебель-диван и 2 кресла-кровати,...</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>8</td>\n",
       "      <td>2017-03-24</td>\n",
       "      <td>Private</td>\n",
       "      <td>361061e2129fe9c77b1b689e3e2071dc10e7a9c93dcee4...</td>\n",
       "      <td>1442.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_883</td>\n",
       "      <td>0.191640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390827</th>\n",
       "      <td>d4bf418c598e</td>\n",
       "      <td>a45156b6ccfc</td>\n",
       "      <td>Челябинская область</td>\n",
       "      <td>Копейск</td>\n",
       "      <td>Недвижимость</td>\n",
       "      <td>Квартиры</td>\n",
       "      <td>Продам</td>\n",
       "      <td>2</td>\n",
       "      <td>Вторичка</td>\n",
       "      <td>2-к квартира, 59 м², 5/10 эт.</td>\n",
       "      <td>Дом сдан заселен. Свидетельство о собственност...</td>\n",
       "      <td>1850000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>2017-03-15</td>\n",
       "      <td>Private</td>\n",
       "      <td>85229dc0f6bb7d3735a59724d05e996a921a9e50cb6811...</td>\n",
       "      <td>2221.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_916</td>\n",
       "      <td>0.694682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390828</th>\n",
       "      <td>a927b25d4daa</td>\n",
       "      <td>5db5d1e60f38</td>\n",
       "      <td>Тульская область</td>\n",
       "      <td>Тула</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Обувь</td>\n",
       "      <td>38</td>\n",
       "      <td>Резиновые сапоги Lucky Land, размер 36,37,38.Н...</td>\n",
       "      <td>Продам Новые резиновые сапоги Lucky Land, разм...</td>\n",
       "      <td>200.0</td>\n",
       "      <td>89</td>\n",
       "      <td>2017-03-24</td>\n",
       "      <td>Private</td>\n",
       "      <td>3c67c7fca10a8e7a0b104248b8731394fd6871ef164b0d...</td>\n",
       "      <td>494.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_514</td>\n",
       "      <td>0.731745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390829</th>\n",
       "      <td>21a474db168f</td>\n",
       "      <td>28ca07eeb01a</td>\n",
       "      <td>Ставропольский край</td>\n",
       "      <td>Ставрополь</td>\n",
       "      <td>Транспорт</td>\n",
       "      <td>Автомобили</td>\n",
       "      <td>С пробегом</td>\n",
       "      <td>ВАЗ (LADA)</td>\n",
       "      <td>2114 Samara</td>\n",
       "      <td>ВАЗ 2114 Samara, 2009</td>\n",
       "      <td>Продаю по обстоятельствам. Машина в хорошем со...</td>\n",
       "      <td>160000.0</td>\n",
       "      <td>13</td>\n",
       "      <td>2017-03-27</td>\n",
       "      <td>Private</td>\n",
       "      <td>5998ed044fa7b6f99dbe66260caf3fd5bf9e211cbe9363...</td>\n",
       "      <td>2264.0</td>\n",
       "      <td>0.73760</td>\n",
       "      <td>resnet_656</td>\n",
       "      <td>0.394836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390830</th>\n",
       "      <td>8ab4c1e56046</td>\n",
       "      <td>97146e7aea69</td>\n",
       "      <td>Оренбургская область</td>\n",
       "      <td>Оренбург</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Одежда, обувь, аксессуары</td>\n",
       "      <td>Женская одежда</td>\n",
       "      <td>Платья и юбки</td>\n",
       "      <td>48–50 (XL)</td>\n",
       "      <td>Платье фирмы zarina, размер 50</td>\n",
       "      <td>В хорошем состоянии,  ткань плотная (рисунок т...</td>\n",
       "      <td>500.0</td>\n",
       "      <td>10</td>\n",
       "      <td>2017-03-17</td>\n",
       "      <td>Private</td>\n",
       "      <td>18f8dffacd5516ec8b824a2e846d8d12d75a7a964804a7...</td>\n",
       "      <td>387.0</td>\n",
       "      <td>0.12869</td>\n",
       "      <td>resnet_434</td>\n",
       "      <td>0.520462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390831</th>\n",
       "      <td>5e6b7f0f3f65</td>\n",
       "      <td>dd05217165ea</td>\n",
       "      <td>Пермский край</td>\n",
       "      <td>Пермь</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Детская одежда и обувь</td>\n",
       "      <td>Для девочек</td>\n",
       "      <td>Обувь</td>\n",
       "      <td>26</td>\n",
       "      <td>Ботиночки</td>\n",
       "      <td>NaN</td>\n",
       "      <td>300.0</td>\n",
       "      <td>7</td>\n",
       "      <td>2017-03-20</td>\n",
       "      <td>Private</td>\n",
       "      <td>2da79294c6f23f61d4bf6a8f4034f87e2f318b7e32c68b...</td>\n",
       "      <td>88.0</td>\n",
       "      <td>0.25019</td>\n",
       "      <td>resnet_669</td>\n",
       "      <td>0.125498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390832</th>\n",
       "      <td>d1f0910d2126</td>\n",
       "      <td>dc23ef451c8a</td>\n",
       "      <td>Краснодарский край</td>\n",
       "      <td>Краснодар</td>\n",
       "      <td>Услуги</td>\n",
       "      <td>Предложение услуг</td>\n",
       "      <td>Ремонт, строительство</td>\n",
       "      <td>Ремонт квартиры</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Натяжной потолок</td>\n",
       "      <td>Произведем бесплатный замер, изготовим и устан...</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-03-28</td>\n",
       "      <td>Private</td>\n",
       "      <td>33e13a67b441486ebe48e1459382caa620c4d1802aad1c...</td>\n",
       "      <td>1191.0</td>\n",
       "      <td>0.60000</td>\n",
       "      <td>resnet_884</td>\n",
       "      <td>0.236327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390833</th>\n",
       "      <td>bc04866bc803</td>\n",
       "      <td>66a7016a5995</td>\n",
       "      <td>Башкортостан</td>\n",
       "      <td>Белебей</td>\n",
       "      <td>Недвижимость</td>\n",
       "      <td>Квартиры</td>\n",
       "      <td>Продам</td>\n",
       "      <td>4</td>\n",
       "      <td>Вторичка</td>\n",
       "      <td>4-к квартира, 83 м², 4/5 эт.</td>\n",
       "      <td>Продам квартиру с отличным ремонтом , две лодж...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50</td>\n",
       "      <td>2017-03-21</td>\n",
       "      <td>Company</td>\n",
       "      <td>2ae822ca21cff9465e430c68a1df31c5cda658cbc00eb1...</td>\n",
       "      <td>1202.0</td>\n",
       "      <td>0.39569</td>\n",
       "      <td>resnet_598</td>\n",
       "      <td>0.824384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390834</th>\n",
       "      <td>f782f2ad9349</td>\n",
       "      <td>2d3ac1f5a7b3</td>\n",
       "      <td>Пермский край</td>\n",
       "      <td>Березники</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Детская одежда и обувь</td>\n",
       "      <td>Для девочек</td>\n",
       "      <td>Обувь</td>\n",
       "      <td>27</td>\n",
       "      <td>Туфли-балетки</td>\n",
       "      <td>Продам красивые туфли в хорошем состоянии!</td>\n",
       "      <td>350.0</td>\n",
       "      <td>33</td>\n",
       "      <td>2017-03-22</td>\n",
       "      <td>Private</td>\n",
       "      <td>6b4285c22388a5dae37c3d390d3e1b174f7a980d9e3919...</td>\n",
       "      <td>87.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_774</td>\n",
       "      <td>0.482262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390835</th>\n",
       "      <td>9ad3b7bff1db</td>\n",
       "      <td>f3342ccd95c8</td>\n",
       "      <td>Краснодарский край</td>\n",
       "      <td>Анапа</td>\n",
       "      <td>Личные вещи</td>\n",
       "      <td>Товары для детей и игрушки</td>\n",
       "      <td>Игрушки</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Кукольные домики из берез. фанеры (большой выбор)</td>\n",
       "      <td>ПРЕДЛАГАЕМ ВАШЕМУ ВНИМАНИЮ УНИКАЛЬНЫЕ ИГРУШКИ ...</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>18</td>\n",
       "      <td>2017-03-21</td>\n",
       "      <td>Private</td>\n",
       "      <td>87cca5889b96b0368bffbe7cdb3f0cc5fa660f33be9fd0...</td>\n",
       "      <td>979.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>resnet_448</td>\n",
       "      <td>0.585059</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1390836 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              item_id       user_id                   region  \\\n",
       "0        b912c3c6a6ad  e00f8ff2eaf9     Свердловская область   \n",
       "1        2dac0150717d  39aeb48f0017        Самарская область   \n",
       "2        ba83aefab5dc  91e2f88dd6e3       Ростовская область   \n",
       "3        02996f1dd2ea  bf5cccea572d                Татарстан   \n",
       "4        7c90be56d2ab  ef50846afc0b    Волгоградская область   \n",
       "5        51e0962387f7  bbfad0b1ad0a                Татарстан   \n",
       "6        c4f260a2b48a  08f469d2e6f7    Нижегородская область   \n",
       "7        6b71309d6a8a  fef86baa002c            Пермский край   \n",
       "8        c5b969cb63a2  055825270190     Оренбургская область   \n",
       "9        b1570962e68c  f9e8f831d94c    Нижегородская область   \n",
       "10       d5480bb4a6e4  d46200940f37      Ханты-Мансийский АО   \n",
       "11       86f41f50d8c1  35c2b6b654e0        Тюменская область   \n",
       "12       645237cb3601  fc9a38b79414     Оренбургская область   \n",
       "13       df2116f34563  3ce3c2318b16       Ростовская область   \n",
       "14       a97943ae8158  f643d87dd23c             Башкортостан   \n",
       "15       4b6abd0a5921  94de2b374869                Татарстан   \n",
       "16       7896ef8fe482  007c6bd858cb       Краснодарский край   \n",
       "17       7882b1e77748  7a3fda0cdf94    Новосибирская область   \n",
       "18       071e1ed13c5c  325cacee50f4           Омская область   \n",
       "19       ea12aec32ec3  06ee4ff4e99c    Новосибирская область   \n",
       "20       de310e6aae86  0178e6308f38      Челябинская область   \n",
       "21       08b24e170109  6630d724bbf5       Ростовская область   \n",
       "22       065a4daba35f  19a5cd02c89b    Нижегородская область   \n",
       "23       990113ae4f1c  d9b494f97062      Воронежская область   \n",
       "24       78164bc09657  721c2f914f63        Самарская область   \n",
       "25       fbe29970a8a5  2f0e2746d462      Кемеровская область   \n",
       "26       71d9399b59a2  965ee1e259eb      Саратовская область   \n",
       "27       4941f0385575  d283308a713b    Нижегородская область   \n",
       "28       af9d5b0eadc9  ff3f46835373       Ростовская область   \n",
       "29       1b080aa4a17d  68ee0dc56c28    Нижегородская область   \n",
       "...               ...           ...                      ...   \n",
       "1390806  c346749a7127  6df435165550       Ростовская область   \n",
       "1390807  3c073bb117d8  f3db5b0b12a1        Иркутская область   \n",
       "1390808  6fcc0d49b22d  cd553840f1a2         Тульская область   \n",
       "1390809  f7cb51309717  a96bf12eaaba      Ярославская область   \n",
       "1390810  cb74d5fa1498  141a6ebb6456        Красноярский край   \n",
       "1390811  55760672b23e  085e58413b19    Волгоградская область   \n",
       "1390812  15dc060224ab  13d487ead5a2      Воронежская область   \n",
       "1390813  87cb486a418d  bd8cd55a533a      Ханты-Мансийский АО   \n",
       "1390814  5e317564107b  7d2bc0de4caa        Самарская область   \n",
       "1390815  d630ca83fc9e  ad73bbe882db    Нижегородская область   \n",
       "1390816  732b69fced92  94a9c852a234        Самарская область   \n",
       "1390817  fc8ff7c77732  049099972988  Калининградская область   \n",
       "1390818  bb532fcc7dec  391e0fa1bb2d       Краснодарский край   \n",
       "1390819  ff2a88b765c6  152a1d5e6178     Свердловская область   \n",
       "1390820  d23a9e2a65e1  02652bf7abdd      Саратовская область   \n",
       "1390821  79386f3f2573  e8788c35b158      Воронежская область   \n",
       "1390822  2bc8c895545b  f1fbfb3dc6fa       Краснодарский край   \n",
       "1390823  43ad2ec1cd29  b1ff78e0d361           Алтайский край   \n",
       "1390824  872691eb6232  c257da473f0b        Красноярский край   \n",
       "1390825  00b6a41d5af9  704b0a259816      Ханты-Мансийский АО   \n",
       "1390826  72be5f7bac89  548d266baeda           Алтайский край   \n",
       "1390827  d4bf418c598e  a45156b6ccfc      Челябинская область   \n",
       "1390828  a927b25d4daa  5db5d1e60f38         Тульская область   \n",
       "1390829  21a474db168f  28ca07eeb01a      Ставропольский край   \n",
       "1390830  8ab4c1e56046  97146e7aea69     Оренбургская область   \n",
       "1390831  5e6b7f0f3f65  dd05217165ea            Пермский край   \n",
       "1390832  d1f0910d2126  dc23ef451c8a       Краснодарский край   \n",
       "1390833  bc04866bc803  66a7016a5995             Башкортостан   \n",
       "1390834  f782f2ad9349  2d3ac1f5a7b3            Пермский край   \n",
       "1390835  9ad3b7bff1db  f3342ccd95c8       Краснодарский край   \n",
       "\n",
       "                     city parent_category_name               category_name  \\\n",
       "0            Екатеринбург          Личные вещи  Товары для детей и игрушки   \n",
       "1                  Самара      Для дома и дачи           Мебель и интерьер   \n",
       "2          Ростов-на-Дону  Бытовая электроника               Аудио и видео   \n",
       "3        Набережные Челны          Личные вещи  Товары для детей и игрушки   \n",
       "4               Волгоград            Транспорт                  Автомобили   \n",
       "5               Чистополь          Личные вещи  Товары для детей и игрушки   \n",
       "6         Нижний Новгород      Для дома и дачи      Ремонт и строительство   \n",
       "7                   Пермь          Личные вещи   Одежда, обувь, аксессуары   \n",
       "8                Оренбург          Личные вещи   Одежда, обувь, аксессуары   \n",
       "9         Нижний Новгород          Личные вещи      Детская одежда и обувь   \n",
       "10         Ханты-Мансийск         Недвижимость                    Квартиры   \n",
       "11           Заводоуковск          Личные вещи   Одежда, обувь, аксессуары   \n",
       "12               Оренбург          Личные вещи  Товары для детей и игрушки   \n",
       "13         Ростов-на-Дону  Бытовая электроника       Товары для компьютера   \n",
       "14                Туймазы             Животные                      Собаки   \n",
       "15                 Казань          Личные вещи   Одежда, обувь, аксессуары   \n",
       "16              Краснодар            Транспорт                  Автомобили   \n",
       "17            Новосибирск          Личные вещи  Товары для детей и игрушки   \n",
       "18             Москаленки          Личные вещи   Одежда, обувь, аксессуары   \n",
       "19                 Бердск         Недвижимость                    Квартиры   \n",
       "20           Магнитогорск            Транспорт                  Автомобили   \n",
       "21         Ростов-на-Дону          Личные вещи      Детская одежда и обувь   \n",
       "22        Нижний Новгород             Животные         Товары для животных   \n",
       "23                Воронеж          Личные вещи  Товары для детей и игрушки   \n",
       "24               Тольятти      Для дома и дачи           Мебель и интерьер   \n",
       "25            Новокузнецк          Личные вещи   Одежда, обувь, аксессуары   \n",
       "26                Саратов          Личные вещи   Одежда, обувь, аксессуары   \n",
       "27        Нижний Новгород          Личные вещи      Детская одежда и обувь   \n",
       "28                  Аксай      Для дома и дачи      Ремонт и строительство   \n",
       "29        Нижний Новгород             Животные             Другие животные   \n",
       "...                   ...                  ...                         ...   \n",
       "1390806    Ростов-на-Дону      Для дома и дачи           Мебель и интерьер   \n",
       "1390807            Братск            Транспорт     Мотоциклы и мототехника   \n",
       "1390808           Кимовск        Хобби и отдых     Музыкальные инструменты   \n",
       "1390809         Ярославль          Личные вещи   Одежда, обувь, аксессуары   \n",
       "1390810        Красноярск          Личные вещи   Одежда, обувь, аксессуары   \n",
       "1390811         Волгоград        Хобби и отдых             Книги и журналы   \n",
       "1390812      Новая Усмань  Бытовая электроника       Товары для компьютера   \n",
       "1390813       Нефтеюганск          Личные вещи      Детская одежда и обувь   \n",
       "1390814            Самара            Транспорт                  Автомобили   \n",
       "1390815   Нижний Новгород          Личные вещи      Детская одежда и обувь   \n",
       "1390816            Самара            Транспорт                  Автомобили   \n",
       "1390817       Калининград          Личные вещи  Товары для детей и игрушки   \n",
       "1390818          Холмская      Для дома и дачи      Ремонт и строительство   \n",
       "1390819      Екатеринбург          Личные вещи      Детская одежда и обувь   \n",
       "1390820           Саратов         Недвижимость   Коммерческая недвижимость   \n",
       "1390821           Воронеж          Личные вещи      Детская одежда и обувь   \n",
       "1390822      Новороссийск          Личные вещи   Одежда, обувь, аксессуары   \n",
       "1390823       Новоалтайск          Личные вещи   Одежда, обувь, аксессуары   \n",
       "1390824        Красноярск        Хобби и отдых          Коллекционирование   \n",
       "1390825           Когалым          Личные вещи  Товары для детей и игрушки   \n",
       "1390826             Бийск      Для дома и дачи           Мебель и интерьер   \n",
       "1390827           Копейск         Недвижимость                    Квартиры   \n",
       "1390828              Тула          Личные вещи   Одежда, обувь, аксессуары   \n",
       "1390829        Ставрополь            Транспорт                  Автомобили   \n",
       "1390830          Оренбург          Личные вещи   Одежда, обувь, аксессуары   \n",
       "1390831             Пермь          Личные вещи      Детская одежда и обувь   \n",
       "1390832         Краснодар               Услуги           Предложение услуг   \n",
       "1390833           Белебей         Недвижимость                    Квартиры   \n",
       "1390834         Березники          Личные вещи      Детская одежда и обувь   \n",
       "1390835             Анапа          Личные вещи  Товары для детей и игрушки   \n",
       "\n",
       "                             param_1             param_2  \\\n",
       "0          Постельные принадлежности                 NaN   \n",
       "1                             Другое                 NaN   \n",
       "2        Видео, DVD и Blu-ray плееры                 NaN   \n",
       "3               Автомобильные кресла                 NaN   \n",
       "4                         С пробегом          ВАЗ (LADA)   \n",
       "5               Автомобильные кресла                 NaN   \n",
       "6                 Сантехника и сауна                 NaN   \n",
       "7                     Женская одежда              Джинсы   \n",
       "8                     Женская одежда       Платья и юбки   \n",
       "9                        Для девочек               Обувь   \n",
       "10                              Сдам  На длительный срок   \n",
       "11                    Женская одежда              Джинсы   \n",
       "12                  Товары для школы                 NaN   \n",
       "13                          Мониторы                 NaN   \n",
       "14                  Немецкая овчарка                 NaN   \n",
       "15                    Женская одежда       Платья и юбки   \n",
       "16                        С пробегом           Chevrolet   \n",
       "17                           Игрушки                 NaN   \n",
       "18                    Женская одежда      Верхняя одежда   \n",
       "19                            Продам                   2   \n",
       "20                        С пробегом                Ford   \n",
       "21                       Для девочек               Обувь   \n",
       "22                               NaN                 NaN   \n",
       "23                           Игрушки                 NaN   \n",
       "24                  Текстиль и ковры                 NaN   \n",
       "25                    Женская одежда               Обувь   \n",
       "26                    Женская одежда       Платья и юбки   \n",
       "27                     Для мальчиков              Другое   \n",
       "28                    Стройматериалы                 NaN   \n",
       "29                      С/х животные                 NaN   \n",
       "...                              ...                 ...   \n",
       "1390806               Шкафы и комоды                 NaN   \n",
       "1390807                    Вездеходы                 NaN   \n",
       "1390808   Пианино и другие клавишные                 NaN   \n",
       "1390809               Женская одежда      Верхняя одежда   \n",
       "1390810               Женская одежда      Верхняя одежда   \n",
       "1390811                        Книги                 NaN   \n",
       "1390812                Комплектующие  Оперативная память   \n",
       "1390813                  Для девочек               Брюки   \n",
       "1390814                   С пробегом                 BMW   \n",
       "1390815                  Для девочек               Обувь   \n",
       "1390816                   С пробегом       Mercedes-Benz   \n",
       "1390817               Детская мебель                 NaN   \n",
       "1390818              Садовая техника                 NaN   \n",
       "1390819                Для мальчиков      Верхняя одежда   \n",
       "1390820                       Продам   Офисное помещение   \n",
       "1390821                  Для девочек       Платья и юбки   \n",
       "1390822               Женская одежда       Платья и юбки   \n",
       "1390823               Женская одежда            Трикотаж   \n",
       "1390824                Грампластинки                 NaN   \n",
       "1390825              Детские коляски                 NaN   \n",
       "1390826     Кровати, диваны и кресла                 NaN   \n",
       "1390827                       Продам                   2   \n",
       "1390828               Женская одежда               Обувь   \n",
       "1390829                   С пробегом          ВАЗ (LADA)   \n",
       "1390830               Женская одежда       Платья и юбки   \n",
       "1390831                  Для девочек               Обувь   \n",
       "1390832        Ремонт, строительство     Ремонт квартиры   \n",
       "1390833                       Продам                   4   \n",
       "1390834                  Для девочек               Обувь   \n",
       "1390835                      Игрушки                 NaN   \n",
       "\n",
       "                      param_3  \\\n",
       "0                         NaN   \n",
       "1                         NaN   \n",
       "2                         NaN   \n",
       "3                         NaN   \n",
       "4                        2110   \n",
       "5                         NaN   \n",
       "6                         NaN   \n",
       "7                          26   \n",
       "8                  > 50 (XXL)   \n",
       "9                          25   \n",
       "10                          1   \n",
       "11                Без размера   \n",
       "12                        NaN   \n",
       "13                        NaN   \n",
       "14                        NaN   \n",
       "15                  42–44 (S)   \n",
       "16                      Lanos   \n",
       "17                        NaN   \n",
       "18                  44–46 (M)   \n",
       "19                   Вторичка   \n",
       "20                      Focus   \n",
       "21                         25   \n",
       "22                        NaN   \n",
       "23                        NaN   \n",
       "24                        NaN   \n",
       "25                         37   \n",
       "26                  46–48 (L)   \n",
       "27                        NaN   \n",
       "28                        NaN   \n",
       "29                        NaN   \n",
       "...                       ...   \n",
       "1390806                   NaN   \n",
       "1390807                   NaN   \n",
       "1390808                   NaN   \n",
       "1390809             44–46 (M)   \n",
       "1390810             44–46 (M)   \n",
       "1390811                   NaN   \n",
       "1390812                   NaN   \n",
       "1390813  98-104 см (2-4 года)   \n",
       "1390814               3 серия   \n",
       "1390815                  < 19   \n",
       "1390816               M-класс   \n",
       "1390817                   NaN   \n",
       "1390818                   NaN   \n",
       "1390819   86-92 см (1-2 года)   \n",
       "1390820                   NaN   \n",
       "1390821  98-104 см (2-4 года)   \n",
       "1390822             44–46 (M)   \n",
       "1390823             42–44 (S)   \n",
       "1390824                   NaN   \n",
       "1390825                   NaN   \n",
       "1390826                   NaN   \n",
       "1390827              Вторичка   \n",
       "1390828                    38   \n",
       "1390829           2114 Samara   \n",
       "1390830            48–50 (XL)   \n",
       "1390831                    26   \n",
       "1390832                   NaN   \n",
       "1390833              Вторичка   \n",
       "1390834                    27   \n",
       "1390835                   NaN   \n",
       "\n",
       "                                                     title  \\\n",
       "0                                    Кокоби(кокон для сна)   \n",
       "1                                        Стойка для Одежды   \n",
       "2                                           Philips bluray   \n",
       "3                                               Автокресло   \n",
       "4                                           ВАЗ 2110, 2003   \n",
       "5                                              Авто люлька   \n",
       "6            Водонагреватель 100 литров нержавейка плоский   \n",
       "7                                         Бойфренды colins   \n",
       "8                                                   Платье   \n",
       "9                        Полу ботиночки замш натур.Бамбини   \n",
       "10                            1-к квартира, 25 м², 2/2 эт.   \n",
       "11                                                  Джинсы   \n",
       "12                     Атласы и Контурныя карты за 8 класс   \n",
       "13                                       Монитор acer 18.5   \n",
       "14                        Продаются щенки немецкой овчарки   \n",
       "15                                    Платье женское новое   \n",
       "16                                   Chevrolet Lanos, 2008   \n",
       "17                                        Объемная цифра 2   \n",
       "18                                Куртка весенняя(осенняя)   \n",
       "19                            2-к квартира, 44 м², 5/5 эт.   \n",
       "20                                        Ford Focus, 2005   \n",
       "21                                          Туфли moschino   \n",
       "22                                       Таблетки бравекто   \n",
       "23                                Пинки Пай My Little Pony   \n",
       "24                                               Ламбрикен   \n",
       "25                                                 Ботинки   \n",
       "26                                     Продаю новое платье   \n",
       "27                                        Песочник Crockid   \n",
       "28                                         Фасадные панели   \n",
       "29                                                   Бычки   \n",
       "...                                                    ...   \n",
       "1390806                                     Офисная мебель   \n",
       "1390807                          Продам болотоход юпитер 3   \n",
       "1390808                                     Пианино Аккорд   \n",
       "1390809                                              Жакет   \n",
       "1390810                                Пальто демисезонное   \n",
       "1390811                Серия книг \"Бессмертные \" все сразу   \n",
       "1390812                                 Оперативная память   \n",
       "1390813                                 Джинсы для девочек   \n",
       "1390814                                  BMW 3 серия, 2009   \n",
       "1390815                                 Сандалии Таши Орто   \n",
       "1390816                        Mercedes-Benz M-класс, 2008   \n",
       "1390817                       Продается шезлонг фирмы Чико   \n",
       "1390818                                      Садовая тачка   \n",
       "1390819                            Лёгкая куртка размер 92   \n",
       "1390820                                  Нежилое помещение   \n",
       "1390821                                        Нвые платья   \n",
       "1390822                                     Платье женское   \n",
       "1390823                                              Кофта   \n",
       "1390824         Винил пластинка СССР А. Кальянов Жена жена   \n",
       "1390825                                 Продам коляску 2в1   \n",
       "1390826                                      Мягкая мебель   \n",
       "1390827                      2-к квартира, 59 м², 5/10 эт.   \n",
       "1390828  Резиновые сапоги Lucky Land, размер 36,37,38.Н...   \n",
       "1390829                              ВАЗ 2114 Samara, 2009   \n",
       "1390830                     Платье фирмы zarina, размер 50   \n",
       "1390831                                          Ботиночки   \n",
       "1390832                                   Натяжной потолок   \n",
       "1390833                       4-к квартира, 83 м², 4/5 эт.   \n",
       "1390834                                      Туфли-балетки   \n",
       "1390835  Кукольные домики из берез. фанеры (большой выбор)   \n",
       "\n",
       "                                               description      price  \\\n",
       "0        Кокон для сна малыша,пользовались меньше месяц...      400.0   \n",
       "1                Стойка для одежды, под вешалки. С бутика.     3000.0   \n",
       "2        В хорошем состоянии, домашний кинотеатр с blu ...     4000.0   \n",
       "3                                   Продам кресло от0-25кг     2200.0   \n",
       "4                                 Все вопросы по телефону.    40000.0   \n",
       "5                                      В хорошем состоянии     1300.0   \n",
       "6        Электро водонагреватель накопительный на 100 л...    11000.0   \n",
       "7                           Бойфренды в хорошем состоянии.      500.0   \n",
       "8                                 54 раз мер очень удобное      500.0   \n",
       "9        По стельке 15.5см мерить приокский район. Цвет...      400.0   \n",
       "10       Сдается однокомнатная мебелированная квартира ...    18000.0   \n",
       "11                                                     NaN        1.0   \n",
       "12       Атлас история нового времени,19 век./\\nКонтурн...       70.0   \n",
       "13        Продам манитор 18.5 v193HQV. В хорошем состоянии     2500.0   \n",
       "14                  родились 1 февраля,три кобеля и сучка.     5000.0   \n",
       "15       Одето 1 раз на пару часов. Длина 79. Можно кор...      800.0   \n",
       "16       Кондиционер, гидроусилитель руля, электрически...   140000.0   \n",
       "17       Размеры 75*53*15. Основа-картон, декор-гофриро...      500.0   \n",
       "18       Куртка новая, очень удобная, ценник был утерян...     1000.0   \n",
       "19       Дом находиться внутри квартала./\\nПластиковые ...  1748000.0   \n",
       "20       Полная комплектация. ГУР. 4 эсп.  Подогрев сид...   249000.0   \n",
       "21       Очень красивые стильные туфельки, состояние от...     1300.0   \n",
       "22       Таблетки \"Бравекто\" от блох и клещей по ценам:...        NaN   \n",
       "23       Пинки Пай ждёт любящую хозяйку./\\nВ комплекте ...     1500.0   \n",
       "24        Продам ламбрикен в хорошем состоянии,длина 2,20.     1000.0   \n",
       "25              Ботинки б/у в хорошем состоянии. Размер 37     1500.0   \n",
       "26       Новое, очень нарядное платье, Рост 170 см, раз...     1000.0   \n",
       "27                         Состояние хорошее, носили мало.      200.0   \n",
       "28       Уникальные свойства фасадных панелей FineBer п...        NaN   \n",
       "29              продаю бычков на откорм веса от 150 до 220      130.0   \n",
       "...                                                    ...        ...   \n",
       "1390806  В связи с оптимизацией помещений, продаю офисн...     2000.0   \n",
       "1390807                          продам болотоход юпитер 3    20000.0   \n",
       "1390808                    Находится в Кимовске. Самовывоз        NaN   \n",
       "1390809  Стильный жакет. Можно и для беременной, можно ...      450.0   \n",
       "1390810  пальто,фирмы \"Белла\",  размер 46, цвет \"фуксия...      500.0   \n",
       "1390811                            Цена за все книги оптом      300.0   \n",
       "1390812                                                NaN      400.0   \n",
       "1390813                    Состояние хорошее. Демисезонные      250.0   \n",
       "1390814  Продаю bmw 3 серии в прекрасном состоянии, пра...   720000.0   \n",
       "1390815  Продам сандалии б/у,размер 18 на первые шаги,п...      500.0   \n",
       "1390816  В отличном состоянии, вложений не требует, 100...  1300000.0   \n",
       "1390817  Продается детский шезлонг +0 до 9 кг. В отличн...     3000.0   \n",
       "1390818  В отличном состоянии /\\nзабирать в холмской центр     3000.0   \n",
       "1390819                                      Двусторонняя!      300.0   \n",
       "1390820  Продается 4 офисных помещения площадью от 106 ...  1600000.0   \n",
       "1390821                   Новые платья разные в наличии!!!      480.0   \n",
       "1390822  Платье очень комфортное, покупала на праздник,...     3000.0   \n",
       "1390823                                                NaN      150.0   \n",
       "1390824  Виниловай грампластинка. /\\nСостояние конверта...      150.0   \n",
       "1390825  Коляска в идеальном состоянии, практически не ...     8000.0   \n",
       "1390826  продам мягкую мебель-диван и 2 кресла-кровати,...     7000.0   \n",
       "1390827  Дом сдан заселен. Свидетельство о собственност...  1850000.0   \n",
       "1390828  Продам Новые резиновые сапоги Lucky Land, разм...      200.0   \n",
       "1390829  Продаю по обстоятельствам. Машина в хорошем со...   160000.0   \n",
       "1390830  В хорошем состоянии,  ткань плотная (рисунок т...      500.0   \n",
       "1390831                                                NaN      300.0   \n",
       "1390832  Произведем бесплатный замер, изготовим и устан...      200.0   \n",
       "1390833  Продам квартиру с отличным ремонтом , две лодж...        NaN   \n",
       "1390834         Продам красивые туфли в хорошем состоянии!      350.0   \n",
       "1390835  ПРЕДЛАГАЕМ ВАШЕМУ ВНИМАНИЮ УНИКАЛЬНЫЕ ИГРУШКИ ...     1500.0   \n",
       "\n",
       "         item_seq_number activation_date user_type  \\\n",
       "0                      2      2017-03-28   Private   \n",
       "1                     19      2017-03-26   Private   \n",
       "2                      9      2017-03-20   Private   \n",
       "3                    286      2017-03-25   Company   \n",
       "4                      3      2017-03-16   Private   \n",
       "5                      9      2017-03-28   Private   \n",
       "6                    125      2017-03-23   Private   \n",
       "7                     61      2017-03-25   Private   \n",
       "8                     85      2017-03-17   Private   \n",
       "9                    136      2017-03-22   Company   \n",
       "10                     6      2017-03-25   Private   \n",
       "11                     4      2017-03-19      Shop   \n",
       "12                    15      2017-03-21   Private   \n",
       "13                    47      2017-03-22   Private   \n",
       "14                     6      2017-03-23   Private   \n",
       "15                    86      2017-03-27   Private   \n",
       "16                   201      2017-03-18   Company   \n",
       "17                     9      2017-03-20   Private   \n",
       "18                     4      2017-03-24   Private   \n",
       "19                   461      2017-03-17   Company   \n",
       "20                    12      2017-03-20   Private   \n",
       "21                    59      2017-03-20   Private   \n",
       "22                   310      2017-03-16   Company   \n",
       "23                   309      2017-03-24   Company   \n",
       "24                    59      2017-03-26   Private   \n",
       "25                     8      2017-03-27   Private   \n",
       "26                    12      2017-03-25   Private   \n",
       "27                    20      2017-03-19   Private   \n",
       "28                     8      2017-03-25   Private   \n",
       "29                    18      2017-03-28   Private   \n",
       "...                  ...             ...       ...   \n",
       "1390806                5      2017-03-16   Private   \n",
       "1390807               41      2017-03-28   Company   \n",
       "1390808               32      2017-03-21   Private   \n",
       "1390809               36      2017-03-20   Private   \n",
       "1390810                8      2017-03-18   Private   \n",
       "1390811                2      2017-03-26   Private   \n",
       "1390812               12      2017-03-20   Private   \n",
       "1390813                6      2017-03-26   Private   \n",
       "1390814               61      2017-03-20   Private   \n",
       "1390815               23      2017-03-20   Private   \n",
       "1390816                1      2017-03-28   Private   \n",
       "1390817               39      2017-03-26   Private   \n",
       "1390818              259      2017-03-16   Private   \n",
       "1390819               33      2017-03-19   Private   \n",
       "1390820               24      2017-03-20   Company   \n",
       "1390821              145      2017-03-22   Company   \n",
       "1390822               26      2017-03-22   Private   \n",
       "1390823               17      2017-03-26   Private   \n",
       "1390824               78      2017-03-21   Company   \n",
       "1390825               77      2017-03-16   Private   \n",
       "1390826                8      2017-03-24   Private   \n",
       "1390827                6      2017-03-15   Private   \n",
       "1390828               89      2017-03-24   Private   \n",
       "1390829               13      2017-03-27   Private   \n",
       "1390830               10      2017-03-17   Private   \n",
       "1390831                7      2017-03-20   Private   \n",
       "1390832                1      2017-03-28   Private   \n",
       "1390833               50      2017-03-21   Company   \n",
       "1390834               33      2017-03-22   Private   \n",
       "1390835               18      2017-03-21   Private   \n",
       "\n",
       "                                                     image  image_top_1  \\\n",
       "0        d10c7e016e03247a3bf2d13348fe959fe6f436c1caf64c...       1008.0   \n",
       "1        79c9392cc51a9c81c6eb91eceb8e552171db39d7142700...        692.0   \n",
       "2        b7f250ee3f39e1fedd77c141f273703f4a9be59db4b48a...       3032.0   \n",
       "3        e6ef97e0725637ea84e3d203e82dadb43ed3cc0a1c8413...        796.0   \n",
       "4        54a687a3a0fc1d68aed99bdaaf551c5c70b761b16fd0a2...       2264.0   \n",
       "5        eb6ad1231c59d3dc7e4020e724ffe8e4d302023ddcbb99...        796.0   \n",
       "6        0330f6ac561f5db1fa8226dd5e7e127b5671d44d075a98...       2823.0   \n",
       "7        9bab29a519e81c14f4582024adfebd4f11a4ac71d323a6...        567.0   \n",
       "8        75ce06d1f939a31dfb2af8ac55f08fa998fa336d13ee05...        415.0   \n",
       "9        54fb8521135fda77a860bfd2fac6bf46867ab7c06796e3...         46.0   \n",
       "10       645d3fb949cb116a00c596ca1e168d8c5ddd21cdeacc5a...       1396.0   \n",
       "11       5162fdb7d8427738370d3145647d2726546f65631e5de9...        119.0   \n",
       "12       5ba63fecb66633cde074c661e0249e26af5cf370241e13...       1040.0   \n",
       "13       0c84cef077d10e5bb37af78049fb0a593c9f1c7f37f458...       2849.0   \n",
       "14       09ebf4b30bad5857a1f26cd18d907c1e888bbe718bb13d...       2133.0   \n",
       "15       df76951e5cc7073553ea3214fd2024b9f80166828a5356...        408.0   \n",
       "16       5244375e00cb2baefa50f4b01156cc492f8733b93c6cba...       1118.0   \n",
       "17       0cdd241246bd930c0026315484d87817c47ce4d586d99b...        983.0   \n",
       "18       1a60aa7ac1bab4fac1171650369e19d2e6872483d89032...         95.0   \n",
       "19       e9fb67b3d22cbf7cf569337780aea8a5c1ddac8b4b6b74...       2011.0   \n",
       "20       1c873f41cea87bc32f52d0a99cf5ff6a33305f0542b7f7...       2264.0   \n",
       "21       6edfface637bd8f85e5614b57a840cb7ec168aed081ba4...         87.0   \n",
       "22       22babf609cfcbca6b1d5ca81321fd6f58e873903c8fc0a...        843.0   \n",
       "23       a8f76b8abea964400c4075cedaea9f7a0c970b5a5f2f8e...        957.0   \n",
       "24       b3c27bf75ffb0dad53a1f4a04fc8c335040468879b1365...       1420.0   \n",
       "25       1d0cc04d7e20f696fbdc181dd3ab9ea964b57b46a981c9...        436.0   \n",
       "26       c4f1d5ccdbda96f2a4718f997318813c84de9e057d3528...        618.0   \n",
       "27       659081173b0a320fae12fe7f8f7bbf9e361444cfcf5ff8...         63.0   \n",
       "28       fb5c2ee81f10750f4142d2028707a779c7e95576bb180d...       1282.0   \n",
       "29       d507fc90a72ae0a6c5b74e0ab6cd723680450c3af4f466...       2195.0   \n",
       "...                                                    ...          ...   \n",
       "1390806  42a0eeeed54478f2fb8d7cbf9b8ed2a53ed39eb7c2bb32...       1460.0   \n",
       "1390807  9765edf15ac427120c1359e3d4dd813a475cc4f4b94701...       1142.0   \n",
       "1390808  17558d450f7de115acc61ec7bc08073443e14753940d8a...       2514.0   \n",
       "1390809  756323281a7579f2bd1c8fc66182f13c0c5d9817424bbb...        569.0   \n",
       "1390810  224a4b70e48a6ce3acdc8cebe3d8df7e1740472954a766...        523.0   \n",
       "1390811  4e711d8c72b89b011d30df969aeca7599646f3912fb5a6...       2286.0   \n",
       "1390812  f3ccc832ed847c606080e4d26456d5bdefd601e8703e85...       2853.0   \n",
       "1390813  b75fc36c2432cc50b11ba789e360e60a8929b2b9daf1c5...        118.0   \n",
       "1390814  709729b67a3dafba282b5299ab76cf95ec97abd35eec55...       1118.0   \n",
       "1390815  9719775bb3aa3f87be91caf3545efbd262a3d02b89ac4e...         93.0   \n",
       "1390816  4d3f4f83f0c065f26ec64fac298936e3a4b0b505402fb0...       1055.0   \n",
       "1390817  c5774df8edc744e41c174a3e7987d93359c71e10937aef...        821.0   \n",
       "1390818  38eb5445db2433f192d0d7383761177e71aaf56f206351...       1348.0   \n",
       "1390819  e0fef616352e4834f1a2023d8884582b8ed460b2745c3b...         53.0   \n",
       "1390820  072bf1c8af2f3a046bdfbe4e65b7343b4884c48b396194...       2221.0   \n",
       "1390821  b7188a3b2f7ec022758297933d20843d40bd0f8cbf6ea6...        127.0   \n",
       "1390822  e1138cb112dd93a0fb12d84bec55177dbff3decd184002...        387.0   \n",
       "1390823  96a65b018d54fe4a59614ac2574003d879635df19c80bf...        590.0   \n",
       "1390824  c7ca77c0fa64ccc68e7a2ec620d969c2212b206afd3cfc...       2402.0   \n",
       "1390825  2b2cc11564c63b2dc66d2bef5b94ede8f54108521411f1...       2336.0   \n",
       "1390826  361061e2129fe9c77b1b689e3e2071dc10e7a9c93dcee4...       1442.0   \n",
       "1390827  85229dc0f6bb7d3735a59724d05e996a921a9e50cb6811...       2221.0   \n",
       "1390828  3c67c7fca10a8e7a0b104248b8731394fd6871ef164b0d...        494.0   \n",
       "1390829  5998ed044fa7b6f99dbe66260caf3fd5bf9e211cbe9363...       2264.0   \n",
       "1390830  18f8dffacd5516ec8b824a2e846d8d12d75a7a964804a7...        387.0   \n",
       "1390831  2da79294c6f23f61d4bf6a8f4034f87e2f318b7e32c68b...         88.0   \n",
       "1390832  33e13a67b441486ebe48e1459382caa620c4d1802aad1c...       1191.0   \n",
       "1390833  2ae822ca21cff9465e430c68a1df31c5cda658cbc00eb1...       1202.0   \n",
       "1390834  6b4285c22388a5dae37c3d390d3e1b174f7a980d9e3919...         87.0   \n",
       "1390835  87cca5889b96b0368bffbe7cdb3f0cc5fa660f33be9fd0...        979.0   \n",
       "\n",
       "         deal_probability image_top_1_resnet  image_top_1_resnet_confidence  \n",
       "0                 0.12789         resnet_887                       0.302808  \n",
       "1                 0.00000         resnet_739                       0.088708  \n",
       "2                 0.43177         resnet_632                       0.670999  \n",
       "3                 0.80323         resnet_615                       0.268173  \n",
       "4                 0.20797         resnet_609                       0.660595  \n",
       "5                 0.80323         resnet_560                       0.830588  \n",
       "6                 0.00000         resnet_605                       0.305495  \n",
       "7                 0.80323         resnet_608                       0.999852  \n",
       "8                 0.00000         resnet_614                       0.191267  \n",
       "9                 0.00000         resnet_502                       0.631085  \n",
       "10                0.58853         resnet_799                       0.313318  \n",
       "11                0.00000         resnet_608                       0.868692  \n",
       "12                0.13858         resnet_921                       0.961335  \n",
       "13                0.00000         resnet_592                       0.525821  \n",
       "14                0.00000         resnet_224                       0.289771  \n",
       "15                0.00000         resnet_655                       0.522465  \n",
       "16                0.32100         resnet_717                       0.410075  \n",
       "17                0.00000         resnet_868                       0.313282  \n",
       "18                0.00000         resnet_797                       0.200972  \n",
       "19                0.00000         resnet_738                       0.151410  \n",
       "20                0.10334         resnet_468                       0.324867  \n",
       "21                0.00000         resnet_643                       0.287440  \n",
       "22                0.00000         resnet_844                       0.516069  \n",
       "23                0.10796         resnet_850                       0.494834  \n",
       "24                0.00000         resnet_854                       0.913493  \n",
       "25                0.00000         resnet_774                       0.637281  \n",
       "26                0.00000         resnet_578                       0.259102  \n",
       "27                0.00000         resnet_911                       0.305007  \n",
       "28                0.00000         resnet_634                       0.432811  \n",
       "29                0.78501         resnet_580                       0.587181  \n",
       "...                   ...                ...                            ...  \n",
       "1390806           0.33720         resnet_553                       0.929934  \n",
       "1390807           0.00000         resnet_665                       0.710614  \n",
       "1390808           0.00000         resnet_881                       0.974792  \n",
       "1390809           0.00000         resnet_474                       0.756632  \n",
       "1390810           0.00000         resnet_834                       0.837981  \n",
       "1390811           0.00000         resnet_711                       0.418764  \n",
       "1390812           0.00000         resnet_626                       0.130859  \n",
       "1390813           0.14989         resnet_608                       0.743174  \n",
       "1390814           0.23044         resnet_656                       0.603287  \n",
       "1390815           0.00000         resnet_774                       0.786317  \n",
       "1390816           0.01232         resnet_609                       0.429230  \n",
       "1390817           0.00000         resnet_675                       0.174481  \n",
       "1390818           0.86521         resnet_428                       0.367337  \n",
       "1390819           0.00000         resnet_400                       0.132794  \n",
       "1390820           0.12384         resnet_918                       0.995208  \n",
       "1390821           0.12459         resnet_610                       0.542376  \n",
       "1390822           0.00000         resnet_578                       0.618816  \n",
       "1390823           0.00000         resnet_480                       0.265408  \n",
       "1390824           0.00000         resnet_921                       0.940897  \n",
       "1390825           0.00000         resnet_621                       0.177701  \n",
       "1390826           0.00000         resnet_883                       0.191640  \n",
       "1390827           0.00000         resnet_916                       0.694682  \n",
       "1390828           0.00000         resnet_514                       0.731745  \n",
       "1390829           0.73760         resnet_656                       0.394836  \n",
       "1390830           0.12869         resnet_434                       0.520462  \n",
       "1390831           0.25019         resnet_669                       0.125498  \n",
       "1390832           0.60000         resnet_884                       0.236327  \n",
       "1390833           0.39569         resnet_598                       0.824384  \n",
       "1390834           0.00000         resnet_774                       0.482262  \n",
       "1390835           0.00000         resnet_448                       0.585059  \n",
       "\n",
       "[1390836 rows x 20 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>image_top_1_resnet_confidence</th>\n",
       "      <th>deal_probability</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>image_top_1_resnet_confidence</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.016029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>deal_probability</th>\n",
       "      <td>0.016029</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               image_top_1_resnet_confidence  deal_probability\n",
       "image_top_1_resnet_confidence                       1.000000          0.016029\n",
       "deal_probability                                    0.016029          1.000000"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train[['image_top_1_resnet_confidence', 'deal_probability']].corr()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}