online_store_analysis_part_3.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "c027d72e-edcb-4e7f-aacd-55e9619c90c4",
   "metadata": {},
   "source": [
    "# Products Analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "eb6ac541-a100-4924-affb-81d440f4d38f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "314f87e0-b65f-4cfd-ae49-507990a4bcfb",
   "metadata": {},
   "source": [
    "## Combining dataframe with all the information of all products"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "27ee08ec-9a3e-443f-a864-6730c2296bd9",
   "metadata": {},
   "source": [
    "### Data set 7: Olist Products"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "930d1baf-7237-4bcd-ad24-c839bbcbcb58",
   "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>product_id</th>\n",
       "      <th>product_category_name</th>\n",
       "      <th>product_name_lenght</th>\n",
       "      <th>product_description_lenght</th>\n",
       "      <th>product_photos_qty</th>\n",
       "      <th>product_weight_g</th>\n",
       "      <th>product_length_cm</th>\n",
       "      <th>product_height_cm</th>\n",
       "      <th>product_width_cm</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1e9e8ef04dbcff4541ed26657ea517e5</td>\n",
       "      <td>perfumaria</td>\n",
       "      <td>40.0</td>\n",
       "      <td>287.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3aa071139cb16b67ca9e5dea641aaa2f</td>\n",
       "      <td>artes</td>\n",
       "      <td>44.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>96bd76ec8810374ed1b65e291975717f</td>\n",
       "      <td>esporte_lazer</td>\n",
       "      <td>46.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>154.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>cef67bcfe19066a932b7673e239eb23d</td>\n",
       "      <td>bebes</td>\n",
       "      <td>27.0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9dc1a7de274444849c219cff195d0b71</td>\n",
       "      <td>utilidades_domesticas</td>\n",
       "      <td>37.0</td>\n",
       "      <td>402.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>625.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         product_id  product_category_name  \\\n",
       "0  1e9e8ef04dbcff4541ed26657ea517e5             perfumaria   \n",
       "1  3aa071139cb16b67ca9e5dea641aaa2f                  artes   \n",
       "2  96bd76ec8810374ed1b65e291975717f          esporte_lazer   \n",
       "3  cef67bcfe19066a932b7673e239eb23d                  bebes   \n",
       "4  9dc1a7de274444849c219cff195d0b71  utilidades_domesticas   \n",
       "\n",
       "   product_name_lenght  product_description_lenght  product_photos_qty  \\\n",
       "0                 40.0                       287.0                 1.0   \n",
       "1                 44.0                       276.0                 1.0   \n",
       "2                 46.0                       250.0                 1.0   \n",
       "3                 27.0                       261.0                 1.0   \n",
       "4                 37.0                       402.0                 4.0   \n",
       "\n",
       "   product_weight_g  product_length_cm  product_height_cm  product_width_cm  \n",
       "0             225.0               16.0               10.0              14.0  \n",
       "1            1000.0               30.0               18.0              20.0  \n",
       "2             154.0               18.0                9.0              15.0  \n",
       "3             371.0               26.0                4.0              26.0  \n",
       "4             625.0               20.0               17.0              13.0  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data7_products= pd.read_csv('data_sets/brazilian_e_commerce_public/7_olist_products_dataset.csv')\n",
    "data7_products.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "51cae925-144c-47aa-b2af-560e38a5cc27",
   "metadata": {},
   "source": [
    "### Data set 9: Product category with name translation in English"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "6d56921d-ff3d-4226-a092-f48fe56d2aff",
   "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>product_category_name</th>\n",
       "      <th>product_category_name_english</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>beleza_saude</td>\n",
       "      <td>health_beauty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>computers_accessories</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>automotivo</td>\n",
       "      <td>auto</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>bed_bath_table</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>moveis_decoracao</td>\n",
       "      <td>furniture_decor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    product_category_name product_category_name_english\n",
       "0            beleza_saude                 health_beauty\n",
       "1  informatica_acessorios         computers_accessories\n",
       "2              automotivo                          auto\n",
       "3         cama_mesa_banho                bed_bath_table\n",
       "4        moveis_decoracao               furniture_decor"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data9_translation= pd.read_csv('data_sets/brazilian_e_commerce_public/9_product_category_name_translation.csv')\n",
    "data9_translation.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "d35a700e-da0c-407e-9420-67ce5a22b54e",
   "metadata": {},
   "outputs": [],
   "source": [
    "products_list= data7_products.merge(data9_translation, how='left',on= 'product_category_name')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "5fe961b2-6ed6-4485-98cf-0b7d624f4ec6",
   "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>product_id</th>\n",
       "      <th>product_category_name</th>\n",
       "      <th>product_name_lenght</th>\n",
       "      <th>product_description_lenght</th>\n",
       "      <th>product_photos_qty</th>\n",
       "      <th>product_weight_g</th>\n",
       "      <th>product_length_cm</th>\n",
       "      <th>product_height_cm</th>\n",
       "      <th>product_width_cm</th>\n",
       "      <th>product_category_name_english</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1e9e8ef04dbcff4541ed26657ea517e5</td>\n",
       "      <td>perfumaria</td>\n",
       "      <td>40.0</td>\n",
       "      <td>287.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>perfumery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3aa071139cb16b67ca9e5dea641aaa2f</td>\n",
       "      <td>artes</td>\n",
       "      <td>44.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>art</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>96bd76ec8810374ed1b65e291975717f</td>\n",
       "      <td>esporte_lazer</td>\n",
       "      <td>46.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>154.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>sports_leisure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>cef67bcfe19066a932b7673e239eb23d</td>\n",
       "      <td>bebes</td>\n",
       "      <td>27.0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>371.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>baby</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9dc1a7de274444849c219cff195d0b71</td>\n",
       "      <td>utilidades_domesticas</td>\n",
       "      <td>37.0</td>\n",
       "      <td>402.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>625.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>housewares</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         product_id  product_category_name  \\\n",
       "0  1e9e8ef04dbcff4541ed26657ea517e5             perfumaria   \n",
       "1  3aa071139cb16b67ca9e5dea641aaa2f                  artes   \n",
       "2  96bd76ec8810374ed1b65e291975717f          esporte_lazer   \n",
       "3  cef67bcfe19066a932b7673e239eb23d                  bebes   \n",
       "4  9dc1a7de274444849c219cff195d0b71  utilidades_domesticas   \n",
       "\n",
       "   product_name_lenght  product_description_lenght  product_photos_qty  \\\n",
       "0                 40.0                       287.0                 1.0   \n",
       "1                 44.0                       276.0                 1.0   \n",
       "2                 46.0                       250.0                 1.0   \n",
       "3                 27.0                       261.0                 1.0   \n",
       "4                 37.0                       402.0                 4.0   \n",
       "\n",
       "   product_weight_g  product_length_cm  product_height_cm  product_width_cm  \\\n",
       "0             225.0               16.0               10.0              14.0   \n",
       "1            1000.0               30.0               18.0              20.0   \n",
       "2             154.0               18.0                9.0              15.0   \n",
       "3             371.0               26.0                4.0              26.0   \n",
       "4             625.0               20.0               17.0              13.0   \n",
       "\n",
       "  product_category_name_english  \n",
       "0                     perfumery  \n",
       "1                           art  \n",
       "2                sports_leisure  \n",
       "3                          baby  \n",
       "4                    housewares  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "products_list.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "17fdedf9-1bd3-4b0b-9258-ecb7d8c00916",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 32951 entries, 0 to 32950\n",
      "Data columns (total 10 columns):\n",
      " #   Column                         Non-Null Count  Dtype  \n",
      "---  ------                         --------------  -----  \n",
      " 0   product_id                     32951 non-null  object \n",
      " 1   product_category_name          32341 non-null  object \n",
      " 2   product_name_lenght            32341 non-null  float64\n",
      " 3   product_description_lenght     32341 non-null  float64\n",
      " 4   product_photos_qty             32341 non-null  float64\n",
      " 5   product_weight_g               32949 non-null  float64\n",
      " 6   product_length_cm              32949 non-null  float64\n",
      " 7   product_height_cm              32949 non-null  float64\n",
      " 8   product_width_cm               32949 non-null  float64\n",
      " 9   product_category_name_english  32328 non-null  object \n",
      "dtypes: float64(7), object(3)\n",
      "memory usage: 2.8+ MB\n"
     ]
    }
   ],
   "source": [
    "products_list.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "d55fd633-7f03-4fe4-bbe3-4df7b71df7c2",
   "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>customer_id</th>\n",
       "      <th>customer_unique_id</th>\n",
       "      <th>zip_code_prefix_customer</th>\n",
       "      <th>customer_city</th>\n",
       "      <th>sc_state_customer</th>\n",
       "      <th>geolocation_lat_customer</th>\n",
       "      <th>geolocation_lng_customer</th>\n",
       "      <th>state_customer</th>\n",
       "      <th>region_customer</th>\n",
       "      <th>order_id</th>\n",
       "      <th>...</th>\n",
       "      <th>shipping_limit_date_hour</th>\n",
       "      <th>zip_code_prefix_seller</th>\n",
       "      <th>seller_city</th>\n",
       "      <th>sc_state_seller</th>\n",
       "      <th>geolocation_lat_seller</th>\n",
       "      <th>geolocation_lng_seller</th>\n",
       "      <th>state_seller</th>\n",
       "      <th>region_seller</th>\n",
       "      <th>dist_in_km</th>\n",
       "      <th>distance_group</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>06b8999e2fba1a1fbc88172c00ba8bc7</td>\n",
       "      <td>861eff4711a542e4b93843c6dd7febb0</td>\n",
       "      <td>14409</td>\n",
       "      <td>franca</td>\n",
       "      <td>SP</td>\n",
       "      <td>-20.498489</td>\n",
       "      <td>-47.396929</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>00e7ee1b050b8499577073aeb2a297a1</td>\n",
       "      <td>...</td>\n",
       "      <td>15:22:12</td>\n",
       "      <td>8577</td>\n",
       "      <td>itaquaquecetuba</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.486111</td>\n",
       "      <td>-46.366721</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>254.302</td>\n",
       "      <td>group_2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18955e83d337fd6b2def6b18a428ac77</td>\n",
       "      <td>290c77bc529b7ac935b93aa66c333dc3</td>\n",
       "      <td>9790</td>\n",
       "      <td>sao bernardo do campo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.727992</td>\n",
       "      <td>-46.542848</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>29150127e6685892b6eab3eec79f59c7</td>\n",
       "      <td>...</td>\n",
       "      <td>20:58:32</td>\n",
       "      <td>88303</td>\n",
       "      <td>itajai</td>\n",
       "      <td>SC</td>\n",
       "      <td>-26.912574</td>\n",
       "      <td>-48.673980</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>south</td>\n",
       "      <td>336.323</td>\n",
       "      <td>group_3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4e7b3e00288586ebd08712fdd0374a03</td>\n",
       "      <td>060e732b5b29e8181a18229c7b0b2b5e</td>\n",
       "      <td>1151</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.531642</td>\n",
       "      <td>-46.656289</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>b2059ed67ce144a36e2aa97d2c9e9ad2</td>\n",
       "      <td>...</td>\n",
       "      <td>16:19:10</td>\n",
       "      <td>8577</td>\n",
       "      <td>itaquaquecetuba</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.486111</td>\n",
       "      <td>-46.366721</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>32.386</td>\n",
       "      <td>group_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b2b6027bc5c5109e529d4dc6358b12c3</td>\n",
       "      <td>259dac757896d24d7702b9acbbff3f3c</td>\n",
       "      <td>8775</td>\n",
       "      <td>mogi das cruzes</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.499702</td>\n",
       "      <td>-46.185233</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>951670f92359f4fe4a63112aa7306eba</td>\n",
       "      <td>...</td>\n",
       "      <td>16:31:16</td>\n",
       "      <td>8577</td>\n",
       "      <td>itaquaquecetuba</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.486111</td>\n",
       "      <td>-46.366721</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>20.208</td>\n",
       "      <td>group_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4f2d8ab171c80ec8364f7c12e35b23ad</td>\n",
       "      <td>345ecd01c38d18a9036ed96c73b8d066</td>\n",
       "      <td>13056</td>\n",
       "      <td>campinas</td>\n",
       "      <td>SP</td>\n",
       "      <td>-22.975100</td>\n",
       "      <td>-47.142925</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>6b7d50bd145f6fc7f33cebabd7e49d0f</td>\n",
       "      <td>...</td>\n",
       "      <td>10:10:09</td>\n",
       "      <td>14940</td>\n",
       "      <td>ibitinga</td>\n",
       "      <td>SP</td>\n",
       "      <td>-21.757321</td>\n",
       "      <td>-48.829744</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>208.307</td>\n",
       "      <td>group_2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        customer_id                customer_unique_id  \\\n",
       "0  06b8999e2fba1a1fbc88172c00ba8bc7  861eff4711a542e4b93843c6dd7febb0   \n",
       "1  18955e83d337fd6b2def6b18a428ac77  290c77bc529b7ac935b93aa66c333dc3   \n",
       "2  4e7b3e00288586ebd08712fdd0374a03  060e732b5b29e8181a18229c7b0b2b5e   \n",
       "3  b2b6027bc5c5109e529d4dc6358b12c3  259dac757896d24d7702b9acbbff3f3c   \n",
       "4  4f2d8ab171c80ec8364f7c12e35b23ad  345ecd01c38d18a9036ed96c73b8d066   \n",
       "\n",
       "   zip_code_prefix_customer          customer_city sc_state_customer  \\\n",
       "0                     14409                 franca                SP   \n",
       "1                      9790  sao bernardo do campo                SP   \n",
       "2                      1151              sao paulo                SP   \n",
       "3                      8775        mogi das cruzes                SP   \n",
       "4                     13056               campinas                SP   \n",
       "\n",
       "   geolocation_lat_customer  geolocation_lng_customer state_customer  \\\n",
       "0                -20.498489                -47.396929      São Paulo   \n",
       "1                -23.727992                -46.542848      São Paulo   \n",
       "2                -23.531642                -46.656289      São Paulo   \n",
       "3                -23.499702                -46.185233      São Paulo   \n",
       "4                -22.975100                -47.142925      São Paulo   \n",
       "\n",
       "  region_customer                          order_id  ...  \\\n",
       "0       southeast  00e7ee1b050b8499577073aeb2a297a1  ...   \n",
       "1       southeast  29150127e6685892b6eab3eec79f59c7  ...   \n",
       "2       southeast  b2059ed67ce144a36e2aa97d2c9e9ad2  ...   \n",
       "3       southeast  951670f92359f4fe4a63112aa7306eba  ...   \n",
       "4       southeast  6b7d50bd145f6fc7f33cebabd7e49d0f  ...   \n",
       "\n",
       "  shipping_limit_date_hour zip_code_prefix_seller      seller_city  \\\n",
       "0                 15:22:12                   8577  itaquaquecetuba   \n",
       "1                 20:58:32                  88303           itajai   \n",
       "2                 16:19:10                   8577  itaquaquecetuba   \n",
       "3                 16:31:16                   8577  itaquaquecetuba   \n",
       "4                 10:10:09                  14940         ibitinga   \n",
       "\n",
       "  sc_state_seller geolocation_lat_seller geolocation_lng_seller  \\\n",
       "0              SP             -23.486111             -46.366721   \n",
       "1              SC             -26.912574             -48.673980   \n",
       "2              SP             -23.486111             -46.366721   \n",
       "3              SP             -23.486111             -46.366721   \n",
       "4              SP             -21.757321             -48.829744   \n",
       "\n",
       "     state_seller  region_seller  dist_in_km  distance_group  \n",
       "0       São Paulo      southeast     254.302         group_2  \n",
       "1  Santa Catarina          south     336.323         group_3  \n",
       "2       São Paulo      southeast      32.386         group_1  \n",
       "3       São Paulo      southeast      20.208         group_1  \n",
       "4       São Paulo      southeast     208.307         group_2  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_f1_olist = pd.read_csv('data_sets/final_datasets/data_f1_olist.csv')\n",
    "data_f1_olist.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "ca5e33c7-bfcd-4c10-af41-aa522c96e1df",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 110180 entries, 0 to 110179\n",
      "Data columns (total 38 columns):\n",
      " #   Column                                              Non-Null Count   Dtype  \n",
      "---  ------                                              --------------   -----  \n",
      " 0   customer_id                                         110180 non-null  object \n",
      " 1   customer_unique_id                                  110180 non-null  object \n",
      " 2   zip_code_prefix_customer                            110180 non-null  int64  \n",
      " 3   customer_city                                       110180 non-null  object \n",
      " 4   sc_state_customer                                   110180 non-null  object \n",
      " 5   geolocation_lat_customer                            109892 non-null  float64\n",
      " 6   geolocation_lng_customer                            109892 non-null  float64\n",
      " 7   state_customer                                      110180 non-null  object \n",
      " 8   region_customer                                     110180 non-null  object \n",
      " 9   order_id                                            110180 non-null  object \n",
      " 10  order_status                                        110180 non-null  object \n",
      " 11  order_purchase_timestamp                            110180 non-null  object \n",
      " 12  order_approved_at                                   110180 non-null  object \n",
      " 13  order_delivered_carrier_date                        110180 non-null  object \n",
      " 14  order_delivered_customer_date                       110180 non-null  object \n",
      " 15  order_estimated_delivery_date                       110180 non-null  object \n",
      " 16  delta_purchase_approved                             110180 non-null  float64\n",
      " 17  delta_purchase_delivered_carrier                    110180 non-null  float64\n",
      " 18  delta_purchase_delivered_customer                   110180 non-null  float64\n",
      " 19  delta_delivered_customer_carrier                    110180 non-null  float64\n",
      " 20  delta_delivered_customer_order_estimated_delivery_  110180 non-null  float64\n",
      " 21  order_item_id                                       110180 non-null  int64  \n",
      " 22  product_id                                          110180 non-null  object \n",
      " 23  seller_id                                           110180 non-null  object \n",
      " 24  shipping_limit_date                                 110180 non-null  object \n",
      " 25  price                                               110180 non-null  float64\n",
      " 26  freight_value                                       110180 non-null  float64\n",
      " 27  shipping_limit_date_only                            110180 non-null  object \n",
      " 28  shipping_limit_date_hour                            110180 non-null  object \n",
      " 29  zip_code_prefix_seller                              110180 non-null  int64  \n",
      " 30  seller_city                                         110180 non-null  object \n",
      " 31  sc_state_seller                                     110180 non-null  object \n",
      " 32  geolocation_lat_seller                              109931 non-null  float64\n",
      " 33  geolocation_lng_seller                              109931 non-null  float64\n",
      " 34  state_seller                                        110180 non-null  object \n",
      " 35  region_seller                                       110180 non-null  object \n",
      " 36  dist_in_km                                          109644 non-null  float64\n",
      " 37  distance_group                                      109644 non-null  object \n",
      "dtypes: float64(12), int64(3), object(23)\n",
      "memory usage: 31.9+ MB\n"
     ]
    }
   ],
   "source": [
    "data_f1_olist.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "97ddc125-ca9c-4998-a6d7-65ac316ed793",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_f1_olist_with_products= data_f1_olist.merge(products_list, how='left',on= 'product_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "578142e7-40dd-4fc5-8433-cd3cd48f3aef",
   "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>customer_id</th>\n",
       "      <th>customer_unique_id</th>\n",
       "      <th>zip_code_prefix_customer</th>\n",
       "      <th>customer_city</th>\n",
       "      <th>sc_state_customer</th>\n",
       "      <th>geolocation_lat_customer</th>\n",
       "      <th>geolocation_lng_customer</th>\n",
       "      <th>state_customer</th>\n",
       "      <th>region_customer</th>\n",
       "      <th>order_id</th>\n",
       "      <th>...</th>\n",
       "      <th>distance_group</th>\n",
       "      <th>product_category_name</th>\n",
       "      <th>product_name_lenght</th>\n",
       "      <th>product_description_lenght</th>\n",
       "      <th>product_photos_qty</th>\n",
       "      <th>product_weight_g</th>\n",
       "      <th>product_length_cm</th>\n",
       "      <th>product_height_cm</th>\n",
       "      <th>product_width_cm</th>\n",
       "      <th>product_category_name_english</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>06b8999e2fba1a1fbc88172c00ba8bc7</td>\n",
       "      <td>861eff4711a542e4b93843c6dd7febb0</td>\n",
       "      <td>14409</td>\n",
       "      <td>franca</td>\n",
       "      <td>SP</td>\n",
       "      <td>-20.498489</td>\n",
       "      <td>-47.396929</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>00e7ee1b050b8499577073aeb2a297a1</td>\n",
       "      <td>...</td>\n",
       "      <td>group_2</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1141.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8683.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>office_furniture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18955e83d337fd6b2def6b18a428ac77</td>\n",
       "      <td>290c77bc529b7ac935b93aa66c333dc3</td>\n",
       "      <td>9790</td>\n",
       "      <td>sao bernardo do campo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.727992</td>\n",
       "      <td>-46.542848</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>29150127e6685892b6eab3eec79f59c7</td>\n",
       "      <td>...</td>\n",
       "      <td>group_3</td>\n",
       "      <td>utilidades_domesticas</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1002.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10150.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>housewares</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4e7b3e00288586ebd08712fdd0374a03</td>\n",
       "      <td>060e732b5b29e8181a18229c7b0b2b5e</td>\n",
       "      <td>1151</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.531642</td>\n",
       "      <td>-46.656289</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>b2059ed67ce144a36e2aa97d2c9e9ad2</td>\n",
       "      <td>...</td>\n",
       "      <td>group_1</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>55.0</td>\n",
       "      <td>955.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8267.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>office_furniture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b2b6027bc5c5109e529d4dc6358b12c3</td>\n",
       "      <td>259dac757896d24d7702b9acbbff3f3c</td>\n",
       "      <td>8775</td>\n",
       "      <td>mogi das cruzes</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.499702</td>\n",
       "      <td>-46.185233</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>951670f92359f4fe4a63112aa7306eba</td>\n",
       "      <td>...</td>\n",
       "      <td>group_1</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>48.0</td>\n",
       "      <td>1066.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12160.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>office_furniture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4f2d8ab171c80ec8364f7c12e35b23ad</td>\n",
       "      <td>345ecd01c38d18a9036ed96c73b8d066</td>\n",
       "      <td>13056</td>\n",
       "      <td>campinas</td>\n",
       "      <td>SP</td>\n",
       "      <td>-22.975100</td>\n",
       "      <td>-47.142925</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>6b7d50bd145f6fc7f33cebabd7e49d0f</td>\n",
       "      <td>...</td>\n",
       "      <td>group_2</td>\n",
       "      <td>casa_conforto</td>\n",
       "      <td>61.0</td>\n",
       "      <td>407.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5200.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>home_confort</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 47 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        customer_id                customer_unique_id  \\\n",
       "0  06b8999e2fba1a1fbc88172c00ba8bc7  861eff4711a542e4b93843c6dd7febb0   \n",
       "1  18955e83d337fd6b2def6b18a428ac77  290c77bc529b7ac935b93aa66c333dc3   \n",
       "2  4e7b3e00288586ebd08712fdd0374a03  060e732b5b29e8181a18229c7b0b2b5e   \n",
       "3  b2b6027bc5c5109e529d4dc6358b12c3  259dac757896d24d7702b9acbbff3f3c   \n",
       "4  4f2d8ab171c80ec8364f7c12e35b23ad  345ecd01c38d18a9036ed96c73b8d066   \n",
       "\n",
       "   zip_code_prefix_customer          customer_city sc_state_customer  \\\n",
       "0                     14409                 franca                SP   \n",
       "1                      9790  sao bernardo do campo                SP   \n",
       "2                      1151              sao paulo                SP   \n",
       "3                      8775        mogi das cruzes                SP   \n",
       "4                     13056               campinas                SP   \n",
       "\n",
       "   geolocation_lat_customer  geolocation_lng_customer state_customer  \\\n",
       "0                -20.498489                -47.396929      São Paulo   \n",
       "1                -23.727992                -46.542848      São Paulo   \n",
       "2                -23.531642                -46.656289      São Paulo   \n",
       "3                -23.499702                -46.185233      São Paulo   \n",
       "4                -22.975100                -47.142925      São Paulo   \n",
       "\n",
       "  region_customer                          order_id  ... distance_group  \\\n",
       "0       southeast  00e7ee1b050b8499577073aeb2a297a1  ...        group_2   \n",
       "1       southeast  29150127e6685892b6eab3eec79f59c7  ...        group_3   \n",
       "2       southeast  b2059ed67ce144a36e2aa97d2c9e9ad2  ...        group_1   \n",
       "3       southeast  951670f92359f4fe4a63112aa7306eba  ...        group_1   \n",
       "4       southeast  6b7d50bd145f6fc7f33cebabd7e49d0f  ...        group_2   \n",
       "\n",
       "   product_category_name product_name_lenght product_description_lenght  \\\n",
       "0      moveis_escritorio                41.0                     1141.0   \n",
       "1  utilidades_domesticas                43.0                     1002.0   \n",
       "2      moveis_escritorio                55.0                      955.0   \n",
       "3      moveis_escritorio                48.0                     1066.0   \n",
       "4          casa_conforto                61.0                      407.0   \n",
       "\n",
       "  product_photos_qty product_weight_g  product_length_cm  product_height_cm  \\\n",
       "0                1.0           8683.0               54.0               64.0   \n",
       "1                3.0          10150.0               89.0               15.0   \n",
       "2                1.0           8267.0               52.0               52.0   \n",
       "3                1.0          12160.0               56.0               51.0   \n",
       "4                1.0           5200.0               45.0               15.0   \n",
       "\n",
       "   product_width_cm  product_category_name_english  \n",
       "0              31.0               office_furniture  \n",
       "1              40.0                     housewares  \n",
       "2              17.0               office_furniture  \n",
       "3              28.0               office_furniture  \n",
       "4              35.0                   home_confort  \n",
       "\n",
       "[5 rows x 47 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_f1_olist_with_products.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "40441fbe-0b57-4c41-bc99-829fa1c4d503",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 110180 entries, 0 to 110179\n",
      "Data columns (total 47 columns):\n",
      " #   Column                                              Non-Null Count   Dtype  \n",
      "---  ------                                              --------------   -----  \n",
      " 0   customer_id                                         110180 non-null  object \n",
      " 1   customer_unique_id                                  110180 non-null  object \n",
      " 2   zip_code_prefix_customer                            110180 non-null  int64  \n",
      " 3   customer_city                                       110180 non-null  object \n",
      " 4   sc_state_customer                                   110180 non-null  object \n",
      " 5   geolocation_lat_customer                            109892 non-null  float64\n",
      " 6   geolocation_lng_customer                            109892 non-null  float64\n",
      " 7   state_customer                                      110180 non-null  object \n",
      " 8   region_customer                                     110180 non-null  object \n",
      " 9   order_id                                            110180 non-null  object \n",
      " 10  order_status                                        110180 non-null  object \n",
      " 11  order_purchase_timestamp                            110180 non-null  object \n",
      " 12  order_approved_at                                   110180 non-null  object \n",
      " 13  order_delivered_carrier_date                        110180 non-null  object \n",
      " 14  order_delivered_customer_date                       110180 non-null  object \n",
      " 15  order_estimated_delivery_date                       110180 non-null  object \n",
      " 16  delta_purchase_approved                             110180 non-null  float64\n",
      " 17  delta_purchase_delivered_carrier                    110180 non-null  float64\n",
      " 18  delta_purchase_delivered_customer                   110180 non-null  float64\n",
      " 19  delta_delivered_customer_carrier                    110180 non-null  float64\n",
      " 20  delta_delivered_customer_order_estimated_delivery_  110180 non-null  float64\n",
      " 21  order_item_id                                       110180 non-null  int64  \n",
      " 22  product_id                                          110180 non-null  object \n",
      " 23  seller_id                                           110180 non-null  object \n",
      " 24  shipping_limit_date                                 110180 non-null  object \n",
      " 25  price                                               110180 non-null  float64\n",
      " 26  freight_value                                       110180 non-null  float64\n",
      " 27  shipping_limit_date_only                            110180 non-null  object \n",
      " 28  shipping_limit_date_hour                            110180 non-null  object \n",
      " 29  zip_code_prefix_seller                              110180 non-null  int64  \n",
      " 30  seller_city                                         110180 non-null  object \n",
      " 31  sc_state_seller                                     110180 non-null  object \n",
      " 32  geolocation_lat_seller                              109931 non-null  float64\n",
      " 33  geolocation_lng_seller                              109931 non-null  float64\n",
      " 34  state_seller                                        110180 non-null  object \n",
      " 35  region_seller                                       110180 non-null  object \n",
      " 36  dist_in_km                                          109644 non-null  float64\n",
      " 37  distance_group                                      109644 non-null  object \n",
      " 38  product_category_name                               108644 non-null  object \n",
      " 39  product_name_lenght                                 108644 non-null  float64\n",
      " 40  product_description_lenght                          108644 non-null  float64\n",
      " 41  product_photos_qty                                  108644 non-null  float64\n",
      " 42  product_weight_g                                    110162 non-null  float64\n",
      " 43  product_length_cm                                   110162 non-null  float64\n",
      " 44  product_height_cm                                   110162 non-null  float64\n",
      " 45  product_width_cm                                    110162 non-null  float64\n",
      " 46  product_category_name_english                       108622 non-null  object \n",
      "dtypes: float64(19), int64(3), object(25)\n",
      "memory usage: 40.3+ MB\n"
     ]
    }
   ],
   "source": [
    "data_f1_olist_with_products.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "f4214420-7464-43fb-a3e2-0cefcc745283",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "96461"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_f1_olist_with_products['order_id'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "1fde25d8-856d-44b2-90aa-c88ad7fdadac",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "71"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_f1_olist_with_products['product_category_name_english'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "5e26e545-6761-428b-a4aa-2c0580ed9c9e",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_f1_olist_with_products['sub_group_rank']= data_f1_olist_with_products.groupby('distance_group')['delta_purchase_delivered_customer'].rank(ascending=False, method = 'first').astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "09072fdf-88f2-457a-88e4-bd0d31d0f8c0",
   "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>customer_id</th>\n",
       "      <th>customer_unique_id</th>\n",
       "      <th>zip_code_prefix_customer</th>\n",
       "      <th>customer_city</th>\n",
       "      <th>sc_state_customer</th>\n",
       "      <th>geolocation_lat_customer</th>\n",
       "      <th>geolocation_lng_customer</th>\n",
       "      <th>state_customer</th>\n",
       "      <th>region_customer</th>\n",
       "      <th>order_id</th>\n",
       "      <th>...</th>\n",
       "      <th>product_category_name</th>\n",
       "      <th>product_name_lenght</th>\n",
       "      <th>product_description_lenght</th>\n",
       "      <th>product_photos_qty</th>\n",
       "      <th>product_weight_g</th>\n",
       "      <th>product_length_cm</th>\n",
       "      <th>product_height_cm</th>\n",
       "      <th>product_width_cm</th>\n",
       "      <th>product_category_name_english</th>\n",
       "      <th>sub_group_rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>06b8999e2fba1a1fbc88172c00ba8bc7</td>\n",
       "      <td>861eff4711a542e4b93843c6dd7febb0</td>\n",
       "      <td>14409</td>\n",
       "      <td>franca</td>\n",
       "      <td>SP</td>\n",
       "      <td>-20.498489</td>\n",
       "      <td>-47.396929</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>00e7ee1b050b8499577073aeb2a297a1</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1141.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8683.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>office_furniture</td>\n",
       "      <td>8936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18955e83d337fd6b2def6b18a428ac77</td>\n",
       "      <td>290c77bc529b7ac935b93aa66c333dc3</td>\n",
       "      <td>9790</td>\n",
       "      <td>sao bernardo do campo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.727992</td>\n",
       "      <td>-46.542848</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>29150127e6685892b6eab3eec79f59c7</td>\n",
       "      <td>...</td>\n",
       "      <td>utilidades_domesticas</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1002.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10150.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>housewares</td>\n",
       "      <td>5476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4e7b3e00288586ebd08712fdd0374a03</td>\n",
       "      <td>060e732b5b29e8181a18229c7b0b2b5e</td>\n",
       "      <td>1151</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.531642</td>\n",
       "      <td>-46.656289</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>b2059ed67ce144a36e2aa97d2c9e9ad2</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>55.0</td>\n",
       "      <td>955.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8267.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>office_furniture</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>b2b6027bc5c5109e529d4dc6358b12c3</td>\n",
       "      <td>259dac757896d24d7702b9acbbff3f3c</td>\n",
       "      <td>8775</td>\n",
       "      <td>mogi das cruzes</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.499702</td>\n",
       "      <td>-46.185233</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>951670f92359f4fe4a63112aa7306eba</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>48.0</td>\n",
       "      <td>1066.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12160.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>office_furniture</td>\n",
       "      <td>1349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4f2d8ab171c80ec8364f7c12e35b23ad</td>\n",
       "      <td>345ecd01c38d18a9036ed96c73b8d066</td>\n",
       "      <td>13056</td>\n",
       "      <td>campinas</td>\n",
       "      <td>SP</td>\n",
       "      <td>-22.975100</td>\n",
       "      <td>-47.142925</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>6b7d50bd145f6fc7f33cebabd7e49d0f</td>\n",
       "      <td>...</td>\n",
       "      <td>casa_conforto</td>\n",
       "      <td>61.0</td>\n",
       "      <td>407.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5200.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>home_confort</td>\n",
       "      <td>5544</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        customer_id                customer_unique_id  \\\n",
       "0  06b8999e2fba1a1fbc88172c00ba8bc7  861eff4711a542e4b93843c6dd7febb0   \n",
       "1  18955e83d337fd6b2def6b18a428ac77  290c77bc529b7ac935b93aa66c333dc3   \n",
       "2  4e7b3e00288586ebd08712fdd0374a03  060e732b5b29e8181a18229c7b0b2b5e   \n",
       "3  b2b6027bc5c5109e529d4dc6358b12c3  259dac757896d24d7702b9acbbff3f3c   \n",
       "4  4f2d8ab171c80ec8364f7c12e35b23ad  345ecd01c38d18a9036ed96c73b8d066   \n",
       "\n",
       "   zip_code_prefix_customer          customer_city sc_state_customer  \\\n",
       "0                     14409                 franca                SP   \n",
       "1                      9790  sao bernardo do campo                SP   \n",
       "2                      1151              sao paulo                SP   \n",
       "3                      8775        mogi das cruzes                SP   \n",
       "4                     13056               campinas                SP   \n",
       "\n",
       "   geolocation_lat_customer  geolocation_lng_customer state_customer  \\\n",
       "0                -20.498489                -47.396929      São Paulo   \n",
       "1                -23.727992                -46.542848      São Paulo   \n",
       "2                -23.531642                -46.656289      São Paulo   \n",
       "3                -23.499702                -46.185233      São Paulo   \n",
       "4                -22.975100                -47.142925      São Paulo   \n",
       "\n",
       "  region_customer                          order_id  ...  \\\n",
       "0       southeast  00e7ee1b050b8499577073aeb2a297a1  ...   \n",
       "1       southeast  29150127e6685892b6eab3eec79f59c7  ...   \n",
       "2       southeast  b2059ed67ce144a36e2aa97d2c9e9ad2  ...   \n",
       "3       southeast  951670f92359f4fe4a63112aa7306eba  ...   \n",
       "4       southeast  6b7d50bd145f6fc7f33cebabd7e49d0f  ...   \n",
       "\n",
       "   product_category_name product_name_lenght product_description_lenght  \\\n",
       "0      moveis_escritorio                41.0                     1141.0   \n",
       "1  utilidades_domesticas                43.0                     1002.0   \n",
       "2      moveis_escritorio                55.0                      955.0   \n",
       "3      moveis_escritorio                48.0                     1066.0   \n",
       "4          casa_conforto                61.0                      407.0   \n",
       "\n",
       "  product_photos_qty product_weight_g product_length_cm  product_height_cm  \\\n",
       "0                1.0           8683.0              54.0               64.0   \n",
       "1                3.0          10150.0              89.0               15.0   \n",
       "2                1.0           8267.0              52.0               52.0   \n",
       "3                1.0          12160.0              56.0               51.0   \n",
       "4                1.0           5200.0              45.0               15.0   \n",
       "\n",
       "   product_width_cm  product_category_name_english  sub_group_rank  \n",
       "0              31.0               office_furniture            8936  \n",
       "1              40.0                     housewares            5476  \n",
       "2              17.0               office_furniture             241  \n",
       "3              28.0               office_furniture            1349  \n",
       "4              35.0                   home_confort            5544  \n",
       "\n",
       "[5 rows x 48 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_f1_olist_with_products.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "113e76c2-fee5-4cce-bc00-9605594dcaa2",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_f1_olist_with_products.to_csv('data_sets/final_datasets/data_f2_olist.csv', index= False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "e6067859-46d6-4c19-b3cf-17a13428903b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "49.0     215\n",
       "99.0     190\n",
       "73.0     187\n",
       "50.0     183\n",
       "47.0     182\n",
       "        ... \n",
       "648.0      1\n",
       "811.0      1\n",
       "22.0       1\n",
       "835.0      1\n",
       "773.0      1\n",
       "Name: delta_purchase_delivered_customer, Length: 759, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_f1_olist_with_products['delta_purchase_delivered_customer'][data_f1_olist_with_products['distance_group']=='group_1'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "11c488e1-1d65-428f-bd05-c5b435556718",
   "metadata": {
    "tags": []
   },
   "source": [
    "## Creating Dataframe for the top 200 products with the highest product journey per distance group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "6b55bf79-c788-4168-910b-12549824505d",
   "metadata": {},
   "outputs": [],
   "source": [
    "top_200= data_f1_olist_with_products['sub_group_rank'] < 201"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "2a795a25-6d51-4ba5-adc7-59077a85dc45",
   "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>customer_id</th>\n",
       "      <th>customer_unique_id</th>\n",
       "      <th>zip_code_prefix_customer</th>\n",
       "      <th>customer_city</th>\n",
       "      <th>sc_state_customer</th>\n",
       "      <th>geolocation_lat_customer</th>\n",
       "      <th>geolocation_lng_customer</th>\n",
       "      <th>state_customer</th>\n",
       "      <th>region_customer</th>\n",
       "      <th>order_id</th>\n",
       "      <th>...</th>\n",
       "      <th>product_category_name</th>\n",
       "      <th>product_name_lenght</th>\n",
       "      <th>product_description_lenght</th>\n",
       "      <th>product_photos_qty</th>\n",
       "      <th>product_weight_g</th>\n",
       "      <th>product_length_cm</th>\n",
       "      <th>product_height_cm</th>\n",
       "      <th>product_width_cm</th>\n",
       "      <th>product_category_name_english</th>\n",
       "      <th>sub_group_rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>6bed27564bd99d78d09c1fac13da56fd</td>\n",
       "      <td>463093247faa080167d77f2e6d1b297d</td>\n",
       "      <td>13321</td>\n",
       "      <td>salto</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.191965</td>\n",
       "      <td>-47.290258</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>0e5d9583490deb1e011b1c8e7da13398</td>\n",
       "      <td>...</td>\n",
       "      <td>bebes</td>\n",
       "      <td>53.0</td>\n",
       "      <td>361.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5125.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>baby</td>\n",
       "      <td>178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>3f5939e06e89efd9e9ca8ef3ab9d68c7</td>\n",
       "      <td>6b7e1090d106aaee31d5ed12d2bbc2af</td>\n",
       "      <td>1310</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.561653</td>\n",
       "      <td>-46.656021</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>d3aa5667ad65af7fa58a5481d0aff07a</td>\n",
       "      <td>...</td>\n",
       "      <td>esporte_lazer</td>\n",
       "      <td>58.0</td>\n",
       "      <td>568.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>sports_leisure</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>bcf86029aeed4ed8bac0e16eb14c22f5</td>\n",
       "      <td>7cd7974c9f79f75b77f323878ef87f43</td>\n",
       "      <td>11547</td>\n",
       "      <td>cubatao</td>\n",
       "      <td>SP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>71932b1adae11f63e4a454bb85d4235a</td>\n",
       "      <td>...</td>\n",
       "      <td>brinquedos</td>\n",
       "      <td>57.0</td>\n",
       "      <td>927.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>toys</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>fed6164eb076a32849ac5d4d3cf14480</td>\n",
       "      <td>f0697e6813b23d285c3b3c8c50002fc0</td>\n",
       "      <td>8150</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.518635</td>\n",
       "      <td>-46.413807</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>ca759ab8f22c84329b8dbcb5192ef923</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>48.0</td>\n",
       "      <td>729.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3400.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>857</th>\n",
       "      <td>5f174de9b3c05f164681fb0f3e47f453</td>\n",
       "      <td>e8bab621313ad2a3c0ce8e3a023ff9bb</td>\n",
       "      <td>13059</td>\n",
       "      <td>campinas</td>\n",
       "      <td>SP</td>\n",
       "      <td>-22.942673</td>\n",
       "      <td>-47.153204</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>d905856c062516e1bd43377034e5c615</td>\n",
       "      <td>...</td>\n",
       "      <td>beleza_saude</td>\n",
       "      <td>58.0</td>\n",
       "      <td>2904.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>health_beauty</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110165</th>\n",
       "      <td>84874c595637bb7aea0323c01a7e9c92</td>\n",
       "      <td>cced18dc0d1f0d8b16f75f5b5ec3e2fe</td>\n",
       "      <td>69304</td>\n",
       "      <td>boa vista</td>\n",
       "      <td>RR</td>\n",
       "      <td>2.824631</td>\n",
       "      <td>-60.687982</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>north_region</td>\n",
       "      <td>cdde87555bcd91df4fa4f191cbc77774</td>\n",
       "      <td>...</td>\n",
       "      <td>beleza_saude</td>\n",
       "      <td>31.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>health_beauty</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110173</th>\n",
       "      <td>05ad4097a892d5d8163107dd0bc3ca2d</td>\n",
       "      <td>a7dde49a1e77e409fae17b945a82e2b6</td>\n",
       "      <td>69316</td>\n",
       "      <td>boa vista</td>\n",
       "      <td>RR</td>\n",
       "      <td>2.779962</td>\n",
       "      <td>-60.734700</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>north_region</td>\n",
       "      <td>a72fc5669df669ab2c501cd323698fac</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>60.0</td>\n",
       "      <td>289.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1150.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110176</th>\n",
       "      <td>351c4091b6f035cbc49b25c86db368fc</td>\n",
       "      <td>fc6edb96180128815a10afb2297bf552</td>\n",
       "      <td>69313</td>\n",
       "      <td>boa vista</td>\n",
       "      <td>RR</td>\n",
       "      <td>2.829995</td>\n",
       "      <td>-60.722750</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>north_region</td>\n",
       "      <td>0a80da8a2e86f5f401c7514602bc1105</td>\n",
       "      <td>...</td>\n",
       "      <td>telefonia</td>\n",
       "      <td>46.0</td>\n",
       "      <td>394.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>telephony</td>\n",
       "      <td>138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110177</th>\n",
       "      <td>f82d62c40f8aa96a0539ff63897cbdd5</td>\n",
       "      <td>2be29c188d2c5552046469c6c7e03061</td>\n",
       "      <td>69311</td>\n",
       "      <td>boa vista</td>\n",
       "      <td>RR</td>\n",
       "      <td>2.846929</td>\n",
       "      <td>-60.712952</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>north_region</td>\n",
       "      <td>8b5cf5ac7d33694c12564d2f8ca47535</td>\n",
       "      <td>...</td>\n",
       "      <td>eletronicos</td>\n",
       "      <td>39.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>electronics</td>\n",
       "      <td>148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110178</th>\n",
       "      <td>abc04b2e7196b64e40603beb7d4d392e</td>\n",
       "      <td>15b2459300f0b85b233d798c23552cee</td>\n",
       "      <td>69301</td>\n",
       "      <td>boa vista</td>\n",
       "      <td>RR</td>\n",
       "      <td>2.822775</td>\n",
       "      <td>-60.670698</td>\n",
       "      <td>Roraima</td>\n",
       "      <td>north_region</td>\n",
       "      <td>8d5e10fa7f259ed886ca55788bbf797d</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>35.0</td>\n",
       "      <td>2245.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7625.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>office_furniture</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2000 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             customer_id                customer_unique_id  \\\n",
       "42      6bed27564bd99d78d09c1fac13da56fd  463093247faa080167d77f2e6d1b297d   \n",
       "171     3f5939e06e89efd9e9ca8ef3ab9d68c7  6b7e1090d106aaee31d5ed12d2bbc2af   \n",
       "177     bcf86029aeed4ed8bac0e16eb14c22f5  7cd7974c9f79f75b77f323878ef87f43   \n",
       "202     fed6164eb076a32849ac5d4d3cf14480  f0697e6813b23d285c3b3c8c50002fc0   \n",
       "857     5f174de9b3c05f164681fb0f3e47f453  e8bab621313ad2a3c0ce8e3a023ff9bb   \n",
       "...                                  ...                               ...   \n",
       "110165  84874c595637bb7aea0323c01a7e9c92  cced18dc0d1f0d8b16f75f5b5ec3e2fe   \n",
       "110173  05ad4097a892d5d8163107dd0bc3ca2d  a7dde49a1e77e409fae17b945a82e2b6   \n",
       "110176  351c4091b6f035cbc49b25c86db368fc  fc6edb96180128815a10afb2297bf552   \n",
       "110177  f82d62c40f8aa96a0539ff63897cbdd5  2be29c188d2c5552046469c6c7e03061   \n",
       "110178  abc04b2e7196b64e40603beb7d4d392e  15b2459300f0b85b233d798c23552cee   \n",
       "\n",
       "        zip_code_prefix_customer customer_city sc_state_customer  \\\n",
       "42                         13321         salto                SP   \n",
       "171                         1310     sao paulo                SP   \n",
       "177                        11547       cubatao                SP   \n",
       "202                         8150     sao paulo                SP   \n",
       "857                        13059      campinas                SP   \n",
       "...                          ...           ...               ...   \n",
       "110165                     69304     boa vista                RR   \n",
       "110173                     69316     boa vista                RR   \n",
       "110176                     69313     boa vista                RR   \n",
       "110177                     69311     boa vista                RR   \n",
       "110178                     69301     boa vista                RR   \n",
       "\n",
       "        geolocation_lat_customer  geolocation_lng_customer state_customer  \\\n",
       "42                    -23.191965                -47.290258      São Paulo   \n",
       "171                   -23.561653                -46.656021      São Paulo   \n",
       "177                          NaN                       NaN      São Paulo   \n",
       "202                   -23.518635                -46.413807      São Paulo   \n",
       "857                   -22.942673                -47.153204      São Paulo   \n",
       "...                          ...                       ...            ...   \n",
       "110165                  2.824631                -60.687982        Roraima   \n",
       "110173                  2.779962                -60.734700        Roraima   \n",
       "110176                  2.829995                -60.722750        Roraima   \n",
       "110177                  2.846929                -60.712952        Roraima   \n",
       "110178                  2.822775                -60.670698        Roraima   \n",
       "\n",
       "       region_customer                          order_id  ...  \\\n",
       "42           southeast  0e5d9583490deb1e011b1c8e7da13398  ...   \n",
       "171          southeast  d3aa5667ad65af7fa58a5481d0aff07a  ...   \n",
       "177          southeast  71932b1adae11f63e4a454bb85d4235a  ...   \n",
       "202          southeast  ca759ab8f22c84329b8dbcb5192ef923  ...   \n",
       "857          southeast  d905856c062516e1bd43377034e5c615  ...   \n",
       "...                ...                               ...  ...   \n",
       "110165    north_region  cdde87555bcd91df4fa4f191cbc77774  ...   \n",
       "110173    north_region  a72fc5669df669ab2c501cd323698fac  ...   \n",
       "110176    north_region  0a80da8a2e86f5f401c7514602bc1105  ...   \n",
       "110177    north_region  8b5cf5ac7d33694c12564d2f8ca47535  ...   \n",
       "110178    north_region  8d5e10fa7f259ed886ca55788bbf797d  ...   \n",
       "\n",
       "       product_category_name product_name_lenght product_description_lenght  \\\n",
       "42                     bebes                53.0                      361.0   \n",
       "171            esporte_lazer                58.0                      568.0   \n",
       "177               brinquedos                57.0                      927.0   \n",
       "202          cama_mesa_banho                48.0                      729.0   \n",
       "857             beleza_saude                58.0                     2904.0   \n",
       "...                      ...                 ...                        ...   \n",
       "110165          beleza_saude                31.0                      474.0   \n",
       "110173       cama_mesa_banho                60.0                      289.0   \n",
       "110176             telefonia                46.0                      394.0   \n",
       "110177           eletronicos                39.0                      400.0   \n",
       "110178     moveis_escritorio                35.0                     2245.0   \n",
       "\n",
       "       product_photos_qty product_weight_g product_length_cm  \\\n",
       "42                    2.0           5125.0              34.0   \n",
       "171                   4.0           1500.0              35.0   \n",
       "177                   3.0            800.0              20.0   \n",
       "202                   1.0           3400.0              20.0   \n",
       "857                   2.0            155.0              17.0   \n",
       "...                   ...              ...               ...   \n",
       "110165                1.0           1000.0              40.0   \n",
       "110173                2.0           1150.0              30.0   \n",
       "110176                3.0            200.0              19.0   \n",
       "110177                1.0            200.0              25.0   \n",
       "110178                1.0           7625.0              52.0   \n",
       "\n",
       "        product_height_cm  product_width_cm  product_category_name_english  \\\n",
       "42                   32.0              31.0                           baby   \n",
       "171                  20.0              15.0                 sports_leisure   \n",
       "177                  35.0              20.0                           toys   \n",
       "202                  30.0              30.0                 bed_bath_table   \n",
       "857                  11.0              15.0                  health_beauty   \n",
       "...                   ...               ...                            ...   \n",
       "110165               16.0              30.0                  health_beauty   \n",
       "110173               10.0              30.0                 bed_bath_table   \n",
       "110176                3.0              11.0                      telephony   \n",
       "110177                7.0              16.0                    electronics   \n",
       "110178               41.0              69.0               office_furniture   \n",
       "\n",
       "        sub_group_rank  \n",
       "42                 178  \n",
       "171                  5  \n",
       "177                 51  \n",
       "202                  9  \n",
       "857                 90  \n",
       "...                ...  \n",
       "110165               7  \n",
       "110173               5  \n",
       "110176             138  \n",
       "110177             148  \n",
       "110178              76  \n",
       "\n",
       "[2000 rows x 48 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_top_200 = data_f1_olist_with_products[top_200]\n",
    "df_top_200"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "65c3b7a5-cf24-48ca-b779-c671b849a984",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "bed_bath_table                             190\n",
       "health_beauty                              187\n",
       "computers_accessories                      159\n",
       "sports_leisure                             132\n",
       "furniture_decor                            130\n",
       "watches_gifts                              100\n",
       "office_furniture                            92\n",
       "auto                                        90\n",
       "garden_tools                                79\n",
       "toys                                        77\n",
       "housewares                                  73\n",
       "electronics                                 73\n",
       "telephony                                   70\n",
       "baby                                        69\n",
       "perfumery                                   65\n",
       "cool_stuff                                  56\n",
       "stationery                                  52\n",
       "consoles_games                              36\n",
       "furniture_living_room                       28\n",
       "fashion_bags_accessories                    26\n",
       "pet_shop                                    24\n",
       "construction_tools_construction             19\n",
       "musical_instruments                         13\n",
       "christmas_supplies                          12\n",
       "luggage_accessories                         11\n",
       "small_appliances                             9\n",
       "home_construction                            9\n",
       "food                                         9\n",
       "home_appliances_2                            7\n",
       "home_appliances                              7\n",
       "computers                                    7\n",
       "audio                                        6\n",
       "market_place                                 6\n",
       "drinks                                       6\n",
       "fashion_shoes                                5\n",
       "home_confort                                 5\n",
       "kitchen_dining_laundry_garden_furniture      5\n",
       "books_general_interest                       5\n",
       "fixed_telephony                              4\n",
       "air_conditioning                             3\n",
       "agro_industry_and_commerce                   3\n",
       "industry_commerce_and_business               3\n",
       "furniture_bedroom                            2\n",
       "food_drink                                   2\n",
       "fashion_male_clothing                        2\n",
       "furniture_mattress_and_upholstery            2\n",
       "signaling_and_security                       2\n",
       "music                                        1\n",
       "construction_tools_safety                    1\n",
       "costruction_tools_tools                      1\n",
       "tablets_printing_image                       1\n",
       "books_technical                              1\n",
       "art                                          1\n",
       "Name: product_category_name_english, dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_top_200['product_category_name_english'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "09c9b64c-c333-4564-8796-a5c79ebb67ed",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "group_3    200\n",
       "group_2    200\n",
       "group_6    200\n",
       "group_1    200\n",
       "group_5    200\n",
       "group_8    200\n",
       "group_4    200\n",
       "group_9    200\n",
       "group_7    200\n",
       "Name: distance_group, dtype: int64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_top_200['distance_group'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "5d6d7cce-bfd0-4ae5-9f08-e06365b1fc60",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Checking if the ranking is correct\n",
    "\n",
    "condition_1= df_top_200['distance_group'] == 'group_6'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "81196510-de6b-4ddd-8c1e-fe466e782866",
   "metadata": {
    "tags": []
   },
   "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>customer_id</th>\n",
       "      <th>customer_unique_id</th>\n",
       "      <th>zip_code_prefix_customer</th>\n",
       "      <th>customer_city</th>\n",
       "      <th>sc_state_customer</th>\n",
       "      <th>geolocation_lat_customer</th>\n",
       "      <th>geolocation_lng_customer</th>\n",
       "      <th>state_customer</th>\n",
       "      <th>region_customer</th>\n",
       "      <th>order_id</th>\n",
       "      <th>...</th>\n",
       "      <th>product_category_name</th>\n",
       "      <th>product_name_lenght</th>\n",
       "      <th>product_description_lenght</th>\n",
       "      <th>product_photos_qty</th>\n",
       "      <th>product_weight_g</th>\n",
       "      <th>product_length_cm</th>\n",
       "      <th>product_height_cm</th>\n",
       "      <th>product_width_cm</th>\n",
       "      <th>product_category_name_english</th>\n",
       "      <th>sub_group_rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>85651</th>\n",
       "      <td>59b42de1617fdda0b327375d35efd708</td>\n",
       "      <td>cf004a37244a84e6569ae75d1efa7149</td>\n",
       "      <td>97010</td>\n",
       "      <td>santa maria</td>\n",
       "      <td>RS</td>\n",
       "      <td>-29.684349</td>\n",
       "      <td>-53.813803</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>south</td>\n",
       "      <td>6e82dcfb5eada6283dba34f164e636f5</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>58.0</td>\n",
       "      <td>636.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85652</th>\n",
       "      <td>59b42de1617fdda0b327375d35efd708</td>\n",
       "      <td>cf004a37244a84e6569ae75d1efa7149</td>\n",
       "      <td>97010</td>\n",
       "      <td>santa maria</td>\n",
       "      <td>RS</td>\n",
       "      <td>-29.684349</td>\n",
       "      <td>-53.813803</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>south</td>\n",
       "      <td>6e82dcfb5eada6283dba34f164e636f5</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>59.0</td>\n",
       "      <td>636.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94093</th>\n",
       "      <td>919dc37f94a27a8b5cac7fd53291afd4</td>\n",
       "      <td>3edbdef5636cc6b1a8c4f661a8910ba2</td>\n",
       "      <td>29724</td>\n",
       "      <td>novo brasil</td>\n",
       "      <td>ES</td>\n",
       "      <td>-19.249397</td>\n",
       "      <td>-40.518293</td>\n",
       "      <td>Espírito Santo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>cce224811ba8fea016c049693c3e0402</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>55.0</td>\n",
       "      <td>1208.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1175.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92832</th>\n",
       "      <td>033fab69968b0d69099d64423831a236</td>\n",
       "      <td>fc0bcca3d8d90a812b707bb8e45069d6</td>\n",
       "      <td>29278</td>\n",
       "      <td>arace</td>\n",
       "      <td>ES</td>\n",
       "      <td>-20.010857</td>\n",
       "      <td>-40.798465</td>\n",
       "      <td>Espírito Santo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>7e708aed151d6a8601ce8f2eaa712bf4</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>32.0</td>\n",
       "      <td>501.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>550.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96615</th>\n",
       "      <td>a6b19a21cdce23baec63e5e6a0ff8288</td>\n",
       "      <td>adfe7ac29b6d503ef86218a91d63a6c4</td>\n",
       "      <td>44930</td>\n",
       "      <td>presidente dutra</td>\n",
       "      <td>BA</td>\n",
       "      <td>-11.296340</td>\n",
       "      <td>-41.988764</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>b7624f6b70f7b79ea2b092b6f1be678c</td>\n",
       "      <td>...</td>\n",
       "      <td>papelaria</td>\n",
       "      <td>43.0</td>\n",
       "      <td>665.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>stationery</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97414</th>\n",
       "      <td>30b441b38d5a5d35013a37dcf4b37f58</td>\n",
       "      <td>380a12f953f4b171f8b2077b37f03bea</td>\n",
       "      <td>41270</td>\n",
       "      <td>salvador</td>\n",
       "      <td>BA</td>\n",
       "      <td>-12.923439</td>\n",
       "      <td>-38.463346</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>3b919fbc512d96f81330d2aae3ed0cf6</td>\n",
       "      <td>...</td>\n",
       "      <td>automotivo</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2063.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>auto</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90241</th>\n",
       "      <td>367000b9bd508db790e048df2f6d6af9</td>\n",
       "      <td>4261e564d3e674b5234f01d199701475</td>\n",
       "      <td>68555</td>\n",
       "      <td>xinguara</td>\n",
       "      <td>PA</td>\n",
       "      <td>-7.084786</td>\n",
       "      <td>-49.921636</td>\n",
       "      <td>Pará</td>\n",
       "      <td>north_region</td>\n",
       "      <td>3602a80b09d914236f74c733631f3b8b</td>\n",
       "      <td>...</td>\n",
       "      <td>esporte_lazer</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1058.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>sports_leisure</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76666</th>\n",
       "      <td>307cb7e9453a86b2550537938d86e177</td>\n",
       "      <td>efb28cc50044dbd84964924743445f54</td>\n",
       "      <td>28605</td>\n",
       "      <td>nova friburgo</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.269904</td>\n",
       "      <td>-42.519719</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>7e8641c6ba8f77235152dd1c3356f814</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>47.0</td>\n",
       "      <td>956.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>fed6164eb076a32849ac5d4d3cf14480</td>\n",
       "      <td>f0697e6813b23d285c3b3c8c50002fc0</td>\n",
       "      <td>8150</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.518635</td>\n",
       "      <td>-46.413807</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>ca759ab8f22c84329b8dbcb5192ef923</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>48.0</td>\n",
       "      <td>729.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3400.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89081</th>\n",
       "      <td>acc7d23ec27f4666d82e72a78fe6cae8</td>\n",
       "      <td>1c29d6a67b493c85043b7252908b095a</td>\n",
       "      <td>97670</td>\n",
       "      <td>sao borja</td>\n",
       "      <td>RS</td>\n",
       "      <td>-28.654368</td>\n",
       "      <td>-56.005437</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>south</td>\n",
       "      <td>e16532416e7fa0b226f67cb0a05696c2</td>\n",
       "      <td>...</td>\n",
       "      <td>cool_stuff</td>\n",
       "      <td>33.0</td>\n",
       "      <td>1401.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>30000.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>cool_stuff</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78415</th>\n",
       "      <td>81e7a069c22d320446440504743833dc</td>\n",
       "      <td>80d0e258a93fb949afa542a87dc8f1a1</td>\n",
       "      <td>22790</td>\n",
       "      <td>rio de janeiro</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-23.012987</td>\n",
       "      <td>-43.465520</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>8f9005e33af4e9098cb514dd5f44b0bb</td>\n",
       "      <td>...</td>\n",
       "      <td>cool_stuff</td>\n",
       "      <td>29.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5650.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>cool_stuff</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103183</th>\n",
       "      <td>594ceaa56731ed8539ea1b5437d9e311</td>\n",
       "      <td>040e4df45a02c9d398c233227f207f67</td>\n",
       "      <td>71503</td>\n",
       "      <td>brasilia</td>\n",
       "      <td>DF</td>\n",
       "      <td>-15.714994</td>\n",
       "      <td>-47.885778</td>\n",
       "      <td>Brasília</td>\n",
       "      <td>central_west</td>\n",
       "      <td>abbbf52551bc34cd52a7851c06dfca90</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_decoracao</td>\n",
       "      <td>32.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>furniture_decor</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103184</th>\n",
       "      <td>594ceaa56731ed8539ea1b5437d9e311</td>\n",
       "      <td>040e4df45a02c9d398c233227f207f67</td>\n",
       "      <td>71503</td>\n",
       "      <td>brasilia</td>\n",
       "      <td>DF</td>\n",
       "      <td>-15.714994</td>\n",
       "      <td>-47.885778</td>\n",
       "      <td>Brasília</td>\n",
       "      <td>central_west</td>\n",
       "      <td>abbbf52551bc34cd52a7851c06dfca90</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_decoracao</td>\n",
       "      <td>32.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>furniture_decor</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95750</th>\n",
       "      <td>c86d48649ada1cc512d6376da4feb479</td>\n",
       "      <td>b3393eca96cd098382248663504da521</td>\n",
       "      <td>47990</td>\n",
       "      <td>formosa do rio preto</td>\n",
       "      <td>BA</td>\n",
       "      <td>-11.017033</td>\n",
       "      <td>-45.258250</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>6a2726fdb7d200560870b229000f73db</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1177.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11880.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>office_furniture</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95751</th>\n",
       "      <td>c86d48649ada1cc512d6376da4feb479</td>\n",
       "      <td>b3393eca96cd098382248663504da521</td>\n",
       "      <td>47990</td>\n",
       "      <td>formosa do rio preto</td>\n",
       "      <td>BA</td>\n",
       "      <td>-11.017033</td>\n",
       "      <td>-45.258250</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>6a2726fdb7d200560870b229000f73db</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1177.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11880.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>office_furniture</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95752</th>\n",
       "      <td>c86d48649ada1cc512d6376da4feb479</td>\n",
       "      <td>b3393eca96cd098382248663504da521</td>\n",
       "      <td>47990</td>\n",
       "      <td>formosa do rio preto</td>\n",
       "      <td>BA</td>\n",
       "      <td>-11.017033</td>\n",
       "      <td>-45.258250</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>6a2726fdb7d200560870b229000f73db</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1177.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11880.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>office_furniture</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95753</th>\n",
       "      <td>c86d48649ada1cc512d6376da4feb479</td>\n",
       "      <td>b3393eca96cd098382248663504da521</td>\n",
       "      <td>47990</td>\n",
       "      <td>formosa do rio preto</td>\n",
       "      <td>BA</td>\n",
       "      <td>-11.017033</td>\n",
       "      <td>-45.258250</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>6a2726fdb7d200560870b229000f73db</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>19.0</td>\n",
       "      <td>883.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10075.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>office_furniture</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95754</th>\n",
       "      <td>c86d48649ada1cc512d6376da4feb479</td>\n",
       "      <td>b3393eca96cd098382248663504da521</td>\n",
       "      <td>47990</td>\n",
       "      <td>formosa do rio preto</td>\n",
       "      <td>BA</td>\n",
       "      <td>-11.017033</td>\n",
       "      <td>-45.258250</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>6a2726fdb7d200560870b229000f73db</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1177.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11880.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>office_furniture</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97097</th>\n",
       "      <td>a8ce6a904d2d16b128b6260b147734aa</td>\n",
       "      <td>5605dfe001a21496976e0a8b1047df4a</td>\n",
       "      <td>48930</td>\n",
       "      <td>curaca</td>\n",
       "      <td>BA</td>\n",
       "      <td>-8.973256</td>\n",
       "      <td>-39.885145</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>e4d88b96fb1801eb436496008e848e1a</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>59.0</td>\n",
       "      <td>1132.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3462.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57907</th>\n",
       "      <td>ab175dacdebe79d6ff8a26651a824d2e</td>\n",
       "      <td>62681000bc12644d2ad1b4e967ab69d6</td>\n",
       "      <td>31070</td>\n",
       "      <td>belo horizonte</td>\n",
       "      <td>MG</td>\n",
       "      <td>-19.888610</td>\n",
       "      <td>-43.898059</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>southeast</td>\n",
       "      <td>d23957cc89dc81d6073de66716d2cf82</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>47.0</td>\n",
       "      <td>956.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57908</th>\n",
       "      <td>ab175dacdebe79d6ff8a26651a824d2e</td>\n",
       "      <td>62681000bc12644d2ad1b4e967ab69d6</td>\n",
       "      <td>31070</td>\n",
       "      <td>belo horizonte</td>\n",
       "      <td>MG</td>\n",
       "      <td>-19.888610</td>\n",
       "      <td>-43.898059</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>southeast</td>\n",
       "      <td>d23957cc89dc81d6073de66716d2cf82</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>47.0</td>\n",
       "      <td>956.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80102</th>\n",
       "      <td>a5fbdec2c17bfe055e28024387bc8f99</td>\n",
       "      <td>824fcf573a9993ef9ae8ebd184f86cfe</td>\n",
       "      <td>28750</td>\n",
       "      <td>trajano de moraes</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.065708</td>\n",
       "      <td>-42.069759</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>b6bf0977a04c2f3b84bf63aa0d308b5e</td>\n",
       "      <td>...</td>\n",
       "      <td>eletronicos</td>\n",
       "      <td>52.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>electronics</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55107</th>\n",
       "      <td>bfc24858928300e9b18e0d96637b8404</td>\n",
       "      <td>f5130e7cd0dc6a46c8a48336818a61f7</td>\n",
       "      <td>34800</td>\n",
       "      <td>caete</td>\n",
       "      <td>MG</td>\n",
       "      <td>-19.884900</td>\n",
       "      <td>-43.664953</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>southeast</td>\n",
       "      <td>6325af88a0611fc357055cb87dcec11e</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>33.0</td>\n",
       "      <td>256.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77842</th>\n",
       "      <td>82ccacbefc4bf6143a989f42785134b4</td>\n",
       "      <td>d6fb818d72390f4d7bedef226f3e954c</td>\n",
       "      <td>25570</td>\n",
       "      <td>sao joao de meriti</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.767755</td>\n",
       "      <td>-43.351649</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>6bf14ce96e0c6026fe21f80a498bb446</td>\n",
       "      <td>...</td>\n",
       "      <td>automotivo</td>\n",
       "      <td>44.0</td>\n",
       "      <td>982.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17600.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>auto</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107082</th>\n",
       "      <td>dc66ab9389433904b412c0f0b4e14363</td>\n",
       "      <td>95df81c7a10fd30caa61bcd7d0ea4e4d</td>\n",
       "      <td>78300</td>\n",
       "      <td>tangara da serra</td>\n",
       "      <td>MT</td>\n",
       "      <td>-14.615108</td>\n",
       "      <td>-57.514783</td>\n",
       "      <td>Mato Grosso</td>\n",
       "      <td>central_west</td>\n",
       "      <td>7a53fed7f9006ef9325efa365e6a1992</td>\n",
       "      <td>...</td>\n",
       "      <td>pet_shop</td>\n",
       "      <td>51.0</td>\n",
       "      <td>1294.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9850.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>pet_shop</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58873</th>\n",
       "      <td>f69122629f3b9eefba47cc225aca93ec</td>\n",
       "      <td>9506b3589dc76cb902c0126e212505c3</td>\n",
       "      <td>38610</td>\n",
       "      <td>unai</td>\n",
       "      <td>MG</td>\n",
       "      <td>-16.363814</td>\n",
       "      <td>-46.895308</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>southeast</td>\n",
       "      <td>08904f6557108c451821501ca9e6aa4a</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>44.0</td>\n",
       "      <td>729.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82976</th>\n",
       "      <td>c0c6670992f4b739fed5149cdd7de373</td>\n",
       "      <td>109a7151c235f2772b649fb4be10032a</td>\n",
       "      <td>22250</td>\n",
       "      <td>rio de janeiro</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.942212</td>\n",
       "      <td>-43.177587</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>f79166d484b12d995cc47ff0fd43db75</td>\n",
       "      <td>...</td>\n",
       "      <td>consoles_games</td>\n",
       "      <td>56.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>consoles_games</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97219</th>\n",
       "      <td>7c71fa0871e272a25eeccac52af90595</td>\n",
       "      <td>b5477baf478d1ba4aeb6f0fe116e836d</td>\n",
       "      <td>45662</td>\n",
       "      <td>ilheus</td>\n",
       "      <td>BA</td>\n",
       "      <td>-14.805138</td>\n",
       "      <td>-39.039484</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>4af2fb154881f350d8696f7f7a7f80d3</td>\n",
       "      <td>...</td>\n",
       "      <td>telefonia</td>\n",
       "      <td>31.0</td>\n",
       "      <td>329.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>telephony</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100180</th>\n",
       "      <td>63b5f3444071954ac6c800ac04644793</td>\n",
       "      <td>917b9b2186fb1b16937a8d1822618b13</td>\n",
       "      <td>79400</td>\n",
       "      <td>coxim</td>\n",
       "      <td>MS</td>\n",
       "      <td>-18.507265</td>\n",
       "      <td>-54.748753</td>\n",
       "      <td>Mato Grosso do Sul</td>\n",
       "      <td>central_west</td>\n",
       "      <td>fc3830b4f000e216dc581df9a0e873e2</td>\n",
       "      <td>...</td>\n",
       "      <td>perfumaria</td>\n",
       "      <td>48.0</td>\n",
       "      <td>969.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>perfumery</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97365</th>\n",
       "      <td>92074364e1af80a6ca822ae3141a7d77</td>\n",
       "      <td>0dbb020311cab46ae601709149df24b5</td>\n",
       "      <td>48400</td>\n",
       "      <td>ribeira do pombal</td>\n",
       "      <td>BA</td>\n",
       "      <td>-10.855588</td>\n",
       "      <td>-38.536477</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>4bdbe1f2d1b360c34d90175e10ec090b</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_decoracao</td>\n",
       "      <td>51.0</td>\n",
       "      <td>498.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>furniture_decor</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60335</th>\n",
       "      <td>4f0da4955b04c7b24168eecf63581092</td>\n",
       "      <td>774c075fecf66d485d49c837d03c71e9</td>\n",
       "      <td>39480</td>\n",
       "      <td>januaria</td>\n",
       "      <td>MG</td>\n",
       "      <td>-15.483421</td>\n",
       "      <td>-44.379894</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>southeast</td>\n",
       "      <td>d5f143e9c159a5f1c33f7477c89db770</td>\n",
       "      <td>...</td>\n",
       "      <td>construcao_ferramentas_construcao</td>\n",
       "      <td>60.0</td>\n",
       "      <td>327.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>29500.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>construction_tools_construction</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60336</th>\n",
       "      <td>4f0da4955b04c7b24168eecf63581092</td>\n",
       "      <td>774c075fecf66d485d49c837d03c71e9</td>\n",
       "      <td>39480</td>\n",
       "      <td>januaria</td>\n",
       "      <td>MG</td>\n",
       "      <td>-15.483421</td>\n",
       "      <td>-44.379894</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>southeast</td>\n",
       "      <td>d5f143e9c159a5f1c33f7477c89db770</td>\n",
       "      <td>...</td>\n",
       "      <td>construcao_ferramentas_construcao</td>\n",
       "      <td>60.0</td>\n",
       "      <td>327.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22350.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>construction_tools_construction</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95975</th>\n",
       "      <td>e53e1eedc9ebf9fa7a3318c60ece1d25</td>\n",
       "      <td>ff8892f7c26aa0446da53d01b18df463</td>\n",
       "      <td>45972</td>\n",
       "      <td>ibiraja</td>\n",
       "      <td>BA</td>\n",
       "      <td>-17.171755</td>\n",
       "      <td>-40.253693</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>1c308eca3f339414a92e518e2a2e5ee9</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>38.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71728</th>\n",
       "      <td>1c18d3e8db890e1c91c5210e57515421</td>\n",
       "      <td>0785cbda0cc5bdbc16c0149b2c7501d8</td>\n",
       "      <td>28895</td>\n",
       "      <td>rio das ostras</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.507679</td>\n",
       "      <td>-41.924925</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>466e5cddccc661ae332697cc83dcafb1</td>\n",
       "      <td>...</td>\n",
       "      <td>beleza_saude</td>\n",
       "      <td>49.0</td>\n",
       "      <td>1729.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2338.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>health_beauty</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96686</th>\n",
       "      <td>986c90c93b95ce4d823f9396c9a25751</td>\n",
       "      <td>9c2922aa6d178bbf7050f821c3a3c62c</td>\n",
       "      <td>45600</td>\n",
       "      <td>itabuna</td>\n",
       "      <td>BA</td>\n",
       "      <td>-14.793365</td>\n",
       "      <td>-39.278459</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>ddb831adbe504c02601f03328420af4d</td>\n",
       "      <td>...</td>\n",
       "      <td>eletronicos</td>\n",
       "      <td>59.0</td>\n",
       "      <td>2526.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>308.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>electronics</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69935</th>\n",
       "      <td>3c38956539b1fbda6560b62ee73d2c42</td>\n",
       "      <td>a68196508ebf4b64293c4b50c2d2dd4a</td>\n",
       "      <td>22231</td>\n",
       "      <td>rio de janeiro</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.936154</td>\n",
       "      <td>-43.181832</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>52c13ebf98c19fe6dc69e69ac09663a1</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>24.0</td>\n",
       "      <td>401.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95484</th>\n",
       "      <td>c714d0379e12f46b0d3671b86773339b</td>\n",
       "      <td>f4b13245902914cb9e81d365ae3e29aa</td>\n",
       "      <td>46500</td>\n",
       "      <td>macaubas</td>\n",
       "      <td>BA</td>\n",
       "      <td>-13.020324</td>\n",
       "      <td>-42.692867</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>e42760f40f2fba3ba7529b6157adf501</td>\n",
       "      <td>...</td>\n",
       "      <td>papelaria</td>\n",
       "      <td>55.0</td>\n",
       "      <td>382.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5700.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>stationery</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25057</th>\n",
       "      <td>6aedd904a13070b8a5c21abd8de0c090</td>\n",
       "      <td>4cfcf39c95ad546b0b18e931bc3e6d6a</td>\n",
       "      <td>8311</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.631164</td>\n",
       "      <td>-46.465823</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>d8f4ac2b5cf577657a2165a7c75857ff</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>47.0</td>\n",
       "      <td>729.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2220.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106356</th>\n",
       "      <td>feee0385d0f1a44cf7052d4d328df398</td>\n",
       "      <td>b4897634cc6c7365149af2214b6d40de</td>\n",
       "      <td>78640</td>\n",
       "      <td>canarana</td>\n",
       "      <td>MT</td>\n",
       "      <td>-13.542299</td>\n",
       "      <td>-52.271518</td>\n",
       "      <td>Mato Grosso</td>\n",
       "      <td>central_west</td>\n",
       "      <td>1161d4dd2b98a1d29aee9a19b48d7cd8</td>\n",
       "      <td>...</td>\n",
       "      <td>cool_stuff</td>\n",
       "      <td>54.0</td>\n",
       "      <td>629.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>cool_stuff</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59754</th>\n",
       "      <td>b000b36b33814dba6443ca09f8662bf6</td>\n",
       "      <td>5e4d57b5217587ccb9234555c17e303f</td>\n",
       "      <td>35450</td>\n",
       "      <td>itabirito</td>\n",
       "      <td>MG</td>\n",
       "      <td>-20.253062</td>\n",
       "      <td>-43.800969</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>southeast</td>\n",
       "      <td>bc6f0d20151b72e478b552a053707ec6</td>\n",
       "      <td>...</td>\n",
       "      <td>automotivo</td>\n",
       "      <td>44.0</td>\n",
       "      <td>982.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17600.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>auto</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72848</th>\n",
       "      <td>69f645ccc229773483d2432687142f71</td>\n",
       "      <td>d4e6e96efe843f32f662a70f7807162c</td>\n",
       "      <td>28080</td>\n",
       "      <td>campos dos goytacazes</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-21.742668</td>\n",
       "      <td>-41.313141</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>cbec497198427d28e8c84e2ccaffb6e3</td>\n",
       "      <td>...</td>\n",
       "      <td>automotivo</td>\n",
       "      <td>58.0</td>\n",
       "      <td>1167.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>auto</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108288</th>\n",
       "      <td>09fcda7c9853505b4e80801a1dccb90c</td>\n",
       "      <td>e7d3203514e1896867c3aaf771bca72f</td>\n",
       "      <td>58280</td>\n",
       "      <td>mamanguape</td>\n",
       "      <td>PB</td>\n",
       "      <td>-6.837169</td>\n",
       "      <td>-35.126887</td>\n",
       "      <td>Paraíba</td>\n",
       "      <td>northeast</td>\n",
       "      <td>2942d9a01a44f073aeff5f1a68e8761e</td>\n",
       "      <td>...</td>\n",
       "      <td>beleza_saude</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1257.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>health_beauty</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88158</th>\n",
       "      <td>d0d47db5ad7c0d4e67ef8587667fe9b4</td>\n",
       "      <td>a8bfc5f0c511a76ceed6b30b1d03efa6</td>\n",
       "      <td>91260</td>\n",
       "      <td>porto alegre</td>\n",
       "      <td>RS</td>\n",
       "      <td>-30.038654</td>\n",
       "      <td>-51.121878</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>south</td>\n",
       "      <td>fb8705064d6146e5fdc372b0fc2bf60a</td>\n",
       "      <td>...</td>\n",
       "      <td>perfumaria</td>\n",
       "      <td>32.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>perfumery</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88159</th>\n",
       "      <td>d0d47db5ad7c0d4e67ef8587667fe9b4</td>\n",
       "      <td>a8bfc5f0c511a76ceed6b30b1d03efa6</td>\n",
       "      <td>91260</td>\n",
       "      <td>porto alegre</td>\n",
       "      <td>RS</td>\n",
       "      <td>-30.038654</td>\n",
       "      <td>-51.121878</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>south</td>\n",
       "      <td>fb8705064d6146e5fdc372b0fc2bf60a</td>\n",
       "      <td>...</td>\n",
       "      <td>perfumaria</td>\n",
       "      <td>30.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>perfumery</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78900</th>\n",
       "      <td>c0451262dd7eda80d7fdc0277e3a6326</td>\n",
       "      <td>1b94082edaec2e4ae13bbf3510969004</td>\n",
       "      <td>24456</td>\n",
       "      <td>sao goncalo</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.809296</td>\n",
       "      <td>-43.016040</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>6139a798f92b14ad667f3a8fb8f78c4c</td>\n",
       "      <td>...</td>\n",
       "      <td>beleza_saude</td>\n",
       "      <td>50.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1338.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>health_beauty</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87714</th>\n",
       "      <td>cd6c27532dbcb15907a72ccc69255c9b</td>\n",
       "      <td>ba16ddffbbaf17628e40c50333931bff</td>\n",
       "      <td>97610</td>\n",
       "      <td>sao francisco de assis</td>\n",
       "      <td>RS</td>\n",
       "      <td>-29.550981</td>\n",
       "      <td>-55.126705</td>\n",
       "      <td>Rio Grande do Sul</td>\n",
       "      <td>south</td>\n",
       "      <td>70828ad0ee27db08d57b1437374b15e3</td>\n",
       "      <td>...</td>\n",
       "      <td>esporte_lazer</td>\n",
       "      <td>55.0</td>\n",
       "      <td>1889.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>sports_leisure</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74690</th>\n",
       "      <td>878b45ad0fa20acbb5198b2e979fb442</td>\n",
       "      <td>47a0a92a1b4d507faa45c6d4910e9d2d</td>\n",
       "      <td>28360</td>\n",
       "      <td>bom jesus do itabapoana</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-21.134261</td>\n",
       "      <td>-41.676563</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>ad4098a257676ea4d394fb3bbbf36ca3</td>\n",
       "      <td>...</td>\n",
       "      <td>eletroportateis</td>\n",
       "      <td>60.0</td>\n",
       "      <td>569.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>small_appliances</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>47 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             customer_id                customer_unique_id  \\\n",
       "85651   59b42de1617fdda0b327375d35efd708  cf004a37244a84e6569ae75d1efa7149   \n",
       "85652   59b42de1617fdda0b327375d35efd708  cf004a37244a84e6569ae75d1efa7149   \n",
       "94093   919dc37f94a27a8b5cac7fd53291afd4  3edbdef5636cc6b1a8c4f661a8910ba2   \n",
       "92832   033fab69968b0d69099d64423831a236  fc0bcca3d8d90a812b707bb8e45069d6   \n",
       "96615   a6b19a21cdce23baec63e5e6a0ff8288  adfe7ac29b6d503ef86218a91d63a6c4   \n",
       "97414   30b441b38d5a5d35013a37dcf4b37f58  380a12f953f4b171f8b2077b37f03bea   \n",
       "90241   367000b9bd508db790e048df2f6d6af9  4261e564d3e674b5234f01d199701475   \n",
       "76666   307cb7e9453a86b2550537938d86e177  efb28cc50044dbd84964924743445f54   \n",
       "202     fed6164eb076a32849ac5d4d3cf14480  f0697e6813b23d285c3b3c8c50002fc0   \n",
       "89081   acc7d23ec27f4666d82e72a78fe6cae8  1c29d6a67b493c85043b7252908b095a   \n",
       "78415   81e7a069c22d320446440504743833dc  80d0e258a93fb949afa542a87dc8f1a1   \n",
       "103183  594ceaa56731ed8539ea1b5437d9e311  040e4df45a02c9d398c233227f207f67   \n",
       "103184  594ceaa56731ed8539ea1b5437d9e311  040e4df45a02c9d398c233227f207f67   \n",
       "95750   c86d48649ada1cc512d6376da4feb479  b3393eca96cd098382248663504da521   \n",
       "95751   c86d48649ada1cc512d6376da4feb479  b3393eca96cd098382248663504da521   \n",
       "95752   c86d48649ada1cc512d6376da4feb479  b3393eca96cd098382248663504da521   \n",
       "95753   c86d48649ada1cc512d6376da4feb479  b3393eca96cd098382248663504da521   \n",
       "95754   c86d48649ada1cc512d6376da4feb479  b3393eca96cd098382248663504da521   \n",
       "97097   a8ce6a904d2d16b128b6260b147734aa  5605dfe001a21496976e0a8b1047df4a   \n",
       "57907   ab175dacdebe79d6ff8a26651a824d2e  62681000bc12644d2ad1b4e967ab69d6   \n",
       "57908   ab175dacdebe79d6ff8a26651a824d2e  62681000bc12644d2ad1b4e967ab69d6   \n",
       "80102   a5fbdec2c17bfe055e28024387bc8f99  824fcf573a9993ef9ae8ebd184f86cfe   \n",
       "55107   bfc24858928300e9b18e0d96637b8404  f5130e7cd0dc6a46c8a48336818a61f7   \n",
       "77842   82ccacbefc4bf6143a989f42785134b4  d6fb818d72390f4d7bedef226f3e954c   \n",
       "107082  dc66ab9389433904b412c0f0b4e14363  95df81c7a10fd30caa61bcd7d0ea4e4d   \n",
       "58873   f69122629f3b9eefba47cc225aca93ec  9506b3589dc76cb902c0126e212505c3   \n",
       "82976   c0c6670992f4b739fed5149cdd7de373  109a7151c235f2772b649fb4be10032a   \n",
       "97219   7c71fa0871e272a25eeccac52af90595  b5477baf478d1ba4aeb6f0fe116e836d   \n",
       "100180  63b5f3444071954ac6c800ac04644793  917b9b2186fb1b16937a8d1822618b13   \n",
       "97365   92074364e1af80a6ca822ae3141a7d77  0dbb020311cab46ae601709149df24b5   \n",
       "60335   4f0da4955b04c7b24168eecf63581092  774c075fecf66d485d49c837d03c71e9   \n",
       "60336   4f0da4955b04c7b24168eecf63581092  774c075fecf66d485d49c837d03c71e9   \n",
       "95975   e53e1eedc9ebf9fa7a3318c60ece1d25  ff8892f7c26aa0446da53d01b18df463   \n",
       "71728   1c18d3e8db890e1c91c5210e57515421  0785cbda0cc5bdbc16c0149b2c7501d8   \n",
       "96686   986c90c93b95ce4d823f9396c9a25751  9c2922aa6d178bbf7050f821c3a3c62c   \n",
       "69935   3c38956539b1fbda6560b62ee73d2c42  a68196508ebf4b64293c4b50c2d2dd4a   \n",
       "95484   c714d0379e12f46b0d3671b86773339b  f4b13245902914cb9e81d365ae3e29aa   \n",
       "25057   6aedd904a13070b8a5c21abd8de0c090  4cfcf39c95ad546b0b18e931bc3e6d6a   \n",
       "106356  feee0385d0f1a44cf7052d4d328df398  b4897634cc6c7365149af2214b6d40de   \n",
       "59754   b000b36b33814dba6443ca09f8662bf6  5e4d57b5217587ccb9234555c17e303f   \n",
       "72848   69f645ccc229773483d2432687142f71  d4e6e96efe843f32f662a70f7807162c   \n",
       "108288  09fcda7c9853505b4e80801a1dccb90c  e7d3203514e1896867c3aaf771bca72f   \n",
       "88158   d0d47db5ad7c0d4e67ef8587667fe9b4  a8bfc5f0c511a76ceed6b30b1d03efa6   \n",
       "88159   d0d47db5ad7c0d4e67ef8587667fe9b4  a8bfc5f0c511a76ceed6b30b1d03efa6   \n",
       "78900   c0451262dd7eda80d7fdc0277e3a6326  1b94082edaec2e4ae13bbf3510969004   \n",
       "87714   cd6c27532dbcb15907a72ccc69255c9b  ba16ddffbbaf17628e40c50333931bff   \n",
       "74690   878b45ad0fa20acbb5198b2e979fb442  47a0a92a1b4d507faa45c6d4910e9d2d   \n",
       "\n",
       "        zip_code_prefix_customer            customer_city sc_state_customer  \\\n",
       "85651                      97010              santa maria                RS   \n",
       "85652                      97010              santa maria                RS   \n",
       "94093                      29724              novo brasil                ES   \n",
       "92832                      29278                    arace                ES   \n",
       "96615                      44930         presidente dutra                BA   \n",
       "97414                      41270                 salvador                BA   \n",
       "90241                      68555                 xinguara                PA   \n",
       "76666                      28605            nova friburgo                RJ   \n",
       "202                         8150                sao paulo                SP   \n",
       "89081                      97670                sao borja                RS   \n",
       "78415                      22790           rio de janeiro                RJ   \n",
       "103183                     71503                 brasilia                DF   \n",
       "103184                     71503                 brasilia                DF   \n",
       "95750                      47990     formosa do rio preto                BA   \n",
       "95751                      47990     formosa do rio preto                BA   \n",
       "95752                      47990     formosa do rio preto                BA   \n",
       "95753                      47990     formosa do rio preto                BA   \n",
       "95754                      47990     formosa do rio preto                BA   \n",
       "97097                      48930                   curaca                BA   \n",
       "57907                      31070           belo horizonte                MG   \n",
       "57908                      31070           belo horizonte                MG   \n",
       "80102                      28750        trajano de moraes                RJ   \n",
       "55107                      34800                    caete                MG   \n",
       "77842                      25570       sao joao de meriti                RJ   \n",
       "107082                     78300         tangara da serra                MT   \n",
       "58873                      38610                     unai                MG   \n",
       "82976                      22250           rio de janeiro                RJ   \n",
       "97219                      45662                   ilheus                BA   \n",
       "100180                     79400                    coxim                MS   \n",
       "97365                      48400        ribeira do pombal                BA   \n",
       "60335                      39480                 januaria                MG   \n",
       "60336                      39480                 januaria                MG   \n",
       "95975                      45972                  ibiraja                BA   \n",
       "71728                      28895           rio das ostras                RJ   \n",
       "96686                      45600                  itabuna                BA   \n",
       "69935                      22231           rio de janeiro                RJ   \n",
       "95484                      46500                 macaubas                BA   \n",
       "25057                       8311                sao paulo                SP   \n",
       "106356                     78640                 canarana                MT   \n",
       "59754                      35450                itabirito                MG   \n",
       "72848                      28080    campos dos goytacazes                RJ   \n",
       "108288                     58280               mamanguape                PB   \n",
       "88158                      91260             porto alegre                RS   \n",
       "88159                      91260             porto alegre                RS   \n",
       "78900                      24456              sao goncalo                RJ   \n",
       "87714                      97610   sao francisco de assis                RS   \n",
       "74690                      28360  bom jesus do itabapoana                RJ   \n",
       "\n",
       "        geolocation_lat_customer  geolocation_lng_customer  \\\n",
       "85651                 -29.684349                -53.813803   \n",
       "85652                 -29.684349                -53.813803   \n",
       "94093                 -19.249397                -40.518293   \n",
       "92832                 -20.010857                -40.798465   \n",
       "96615                 -11.296340                -41.988764   \n",
       "97414                 -12.923439                -38.463346   \n",
       "90241                  -7.084786                -49.921636   \n",
       "76666                 -22.269904                -42.519719   \n",
       "202                   -23.518635                -46.413807   \n",
       "89081                 -28.654368                -56.005437   \n",
       "78415                 -23.012987                -43.465520   \n",
       "103183                -15.714994                -47.885778   \n",
       "103184                -15.714994                -47.885778   \n",
       "95750                 -11.017033                -45.258250   \n",
       "95751                 -11.017033                -45.258250   \n",
       "95752                 -11.017033                -45.258250   \n",
       "95753                 -11.017033                -45.258250   \n",
       "95754                 -11.017033                -45.258250   \n",
       "97097                  -8.973256                -39.885145   \n",
       "57907                 -19.888610                -43.898059   \n",
       "57908                 -19.888610                -43.898059   \n",
       "80102                 -22.065708                -42.069759   \n",
       "55107                 -19.884900                -43.664953   \n",
       "77842                 -22.767755                -43.351649   \n",
       "107082                -14.615108                -57.514783   \n",
       "58873                 -16.363814                -46.895308   \n",
       "82976                 -22.942212                -43.177587   \n",
       "97219                 -14.805138                -39.039484   \n",
       "100180                -18.507265                -54.748753   \n",
       "97365                 -10.855588                -38.536477   \n",
       "60335                 -15.483421                -44.379894   \n",
       "60336                 -15.483421                -44.379894   \n",
       "95975                 -17.171755                -40.253693   \n",
       "71728                 -22.507679                -41.924925   \n",
       "96686                 -14.793365                -39.278459   \n",
       "69935                 -22.936154                -43.181832   \n",
       "95484                 -13.020324                -42.692867   \n",
       "25057                 -23.631164                -46.465823   \n",
       "106356                -13.542299                -52.271518   \n",
       "59754                 -20.253062                -43.800969   \n",
       "72848                 -21.742668                -41.313141   \n",
       "108288                 -6.837169                -35.126887   \n",
       "88158                 -30.038654                -51.121878   \n",
       "88159                 -30.038654                -51.121878   \n",
       "78900                 -22.809296                -43.016040   \n",
       "87714                 -29.550981                -55.126705   \n",
       "74690                 -21.134261                -41.676563   \n",
       "\n",
       "            state_customer region_customer                          order_id  \\\n",
       "85651    Rio Grande do Sul           south  6e82dcfb5eada6283dba34f164e636f5   \n",
       "85652    Rio Grande do Sul           south  6e82dcfb5eada6283dba34f164e636f5   \n",
       "94093       Espírito Santo       southeast  cce224811ba8fea016c049693c3e0402   \n",
       "92832       Espírito Santo       southeast  7e708aed151d6a8601ce8f2eaa712bf4   \n",
       "96615                Bahia       northeast  b7624f6b70f7b79ea2b092b6f1be678c   \n",
       "97414                Bahia       northeast  3b919fbc512d96f81330d2aae3ed0cf6   \n",
       "90241                 Pará    north_region  3602a80b09d914236f74c733631f3b8b   \n",
       "76666       Rio de Janeiro       southeast  7e8641c6ba8f77235152dd1c3356f814   \n",
       "202              São Paulo       southeast  ca759ab8f22c84329b8dbcb5192ef923   \n",
       "89081    Rio Grande do Sul           south  e16532416e7fa0b226f67cb0a05696c2   \n",
       "78415       Rio de Janeiro       southeast  8f9005e33af4e9098cb514dd5f44b0bb   \n",
       "103183            Brasília    central_west  abbbf52551bc34cd52a7851c06dfca90   \n",
       "103184            Brasília    central_west  abbbf52551bc34cd52a7851c06dfca90   \n",
       "95750                Bahia       northeast  6a2726fdb7d200560870b229000f73db   \n",
       "95751                Bahia       northeast  6a2726fdb7d200560870b229000f73db   \n",
       "95752                Bahia       northeast  6a2726fdb7d200560870b229000f73db   \n",
       "95753                Bahia       northeast  6a2726fdb7d200560870b229000f73db   \n",
       "95754                Bahia       northeast  6a2726fdb7d200560870b229000f73db   \n",
       "97097                Bahia       northeast  e4d88b96fb1801eb436496008e848e1a   \n",
       "57907         Minas Gerais       southeast  d23957cc89dc81d6073de66716d2cf82   \n",
       "57908         Minas Gerais       southeast  d23957cc89dc81d6073de66716d2cf82   \n",
       "80102       Rio de Janeiro       southeast  b6bf0977a04c2f3b84bf63aa0d308b5e   \n",
       "55107         Minas Gerais       southeast  6325af88a0611fc357055cb87dcec11e   \n",
       "77842       Rio de Janeiro       southeast  6bf14ce96e0c6026fe21f80a498bb446   \n",
       "107082         Mato Grosso    central_west  7a53fed7f9006ef9325efa365e6a1992   \n",
       "58873         Minas Gerais       southeast  08904f6557108c451821501ca9e6aa4a   \n",
       "82976       Rio de Janeiro       southeast  f79166d484b12d995cc47ff0fd43db75   \n",
       "97219                Bahia       northeast  4af2fb154881f350d8696f7f7a7f80d3   \n",
       "100180  Mato Grosso do Sul    central_west  fc3830b4f000e216dc581df9a0e873e2   \n",
       "97365                Bahia       northeast  4bdbe1f2d1b360c34d90175e10ec090b   \n",
       "60335         Minas Gerais       southeast  d5f143e9c159a5f1c33f7477c89db770   \n",
       "60336         Minas Gerais       southeast  d5f143e9c159a5f1c33f7477c89db770   \n",
       "95975                Bahia       northeast  1c308eca3f339414a92e518e2a2e5ee9   \n",
       "71728       Rio de Janeiro       southeast  466e5cddccc661ae332697cc83dcafb1   \n",
       "96686                Bahia       northeast  ddb831adbe504c02601f03328420af4d   \n",
       "69935       Rio de Janeiro       southeast  52c13ebf98c19fe6dc69e69ac09663a1   \n",
       "95484                Bahia       northeast  e42760f40f2fba3ba7529b6157adf501   \n",
       "25057            São Paulo       southeast  d8f4ac2b5cf577657a2165a7c75857ff   \n",
       "106356         Mato Grosso    central_west  1161d4dd2b98a1d29aee9a19b48d7cd8   \n",
       "59754         Minas Gerais       southeast  bc6f0d20151b72e478b552a053707ec6   \n",
       "72848       Rio de Janeiro       southeast  cbec497198427d28e8c84e2ccaffb6e3   \n",
       "108288             Paraíba       northeast  2942d9a01a44f073aeff5f1a68e8761e   \n",
       "88158    Rio Grande do Sul           south  fb8705064d6146e5fdc372b0fc2bf60a   \n",
       "88159    Rio Grande do Sul           south  fb8705064d6146e5fdc372b0fc2bf60a   \n",
       "78900       Rio de Janeiro       southeast  6139a798f92b14ad667f3a8fb8f78c4c   \n",
       "87714    Rio Grande do Sul           south  70828ad0ee27db08d57b1437374b15e3   \n",
       "74690       Rio de Janeiro       southeast  ad4098a257676ea4d394fb3bbbf36ca3   \n",
       "\n",
       "        ...              product_category_name product_name_lenght  \\\n",
       "85651   ...             informatica_acessorios                58.0   \n",
       "85652   ...             informatica_acessorios                59.0   \n",
       "94093   ...                    cama_mesa_banho                55.0   \n",
       "92832   ...                    cama_mesa_banho                32.0   \n",
       "96615   ...                          papelaria                43.0   \n",
       "97414   ...                         automotivo                57.0   \n",
       "90241   ...                      esporte_lazer                35.0   \n",
       "76666   ...             informatica_acessorios                47.0   \n",
       "202     ...                    cama_mesa_banho                48.0   \n",
       "89081   ...                         cool_stuff                33.0   \n",
       "78415   ...                         cool_stuff                29.0   \n",
       "103183  ...                   moveis_decoracao                32.0   \n",
       "103184  ...                   moveis_decoracao                32.0   \n",
       "95750   ...                  moveis_escritorio                26.0   \n",
       "95751   ...                  moveis_escritorio                26.0   \n",
       "95752   ...                  moveis_escritorio                26.0   \n",
       "95753   ...                  moveis_escritorio                19.0   \n",
       "95754   ...                  moveis_escritorio                26.0   \n",
       "97097   ...             informatica_acessorios                59.0   \n",
       "57907   ...             informatica_acessorios                47.0   \n",
       "57908   ...             informatica_acessorios                47.0   \n",
       "80102   ...                        eletronicos                52.0   \n",
       "55107   ...             informatica_acessorios                33.0   \n",
       "77842   ...                         automotivo                44.0   \n",
       "107082  ...                           pet_shop                51.0   \n",
       "58873   ...                    cama_mesa_banho                44.0   \n",
       "82976   ...                     consoles_games                56.0   \n",
       "97219   ...                          telefonia                31.0   \n",
       "100180  ...                         perfumaria                48.0   \n",
       "97365   ...                   moveis_decoracao                51.0   \n",
       "60335   ...  construcao_ferramentas_construcao                60.0   \n",
       "60336   ...  construcao_ferramentas_construcao                60.0   \n",
       "95975   ...                    cama_mesa_banho                38.0   \n",
       "71728   ...                       beleza_saude                49.0   \n",
       "96686   ...                        eletronicos                59.0   \n",
       "69935   ...             informatica_acessorios                24.0   \n",
       "95484   ...                          papelaria                55.0   \n",
       "25057   ...                    cama_mesa_banho                47.0   \n",
       "106356  ...                         cool_stuff                54.0   \n",
       "59754   ...                         automotivo                44.0   \n",
       "72848   ...                         automotivo                58.0   \n",
       "108288  ...                       beleza_saude                50.0   \n",
       "88158   ...                         perfumaria                32.0   \n",
       "88159   ...                         perfumaria                30.0   \n",
       "78900   ...                       beleza_saude                50.0   \n",
       "87714   ...                      esporte_lazer                55.0   \n",
       "74690   ...                    eletroportateis                60.0   \n",
       "\n",
       "       product_description_lenght product_photos_qty product_weight_g  \\\n",
       "85651                       636.0                1.0            800.0   \n",
       "85652                       636.0                1.0            800.0   \n",
       "94093                      1208.0                1.0           1175.0   \n",
       "92832                       501.0                1.0            550.0   \n",
       "96615                       665.0                1.0            600.0   \n",
       "97414                      2063.0                1.0           1500.0   \n",
       "90241                      1058.0                1.0            350.0   \n",
       "76666                       956.0                1.0            140.0   \n",
       "202                         729.0                1.0           3400.0   \n",
       "89081                      1401.0                2.0          30000.0   \n",
       "78415                       266.0                3.0           5650.0   \n",
       "103183                      240.0                1.0            700.0   \n",
       "103184                      240.0                1.0            700.0   \n",
       "95750                      1177.0                1.0          11880.0   \n",
       "95751                      1177.0                1.0          11880.0   \n",
       "95752                      1177.0                1.0          11880.0   \n",
       "95753                       883.0                1.0          10075.0   \n",
       "95754                      1177.0                1.0          11880.0   \n",
       "97097                      1132.0                5.0           3462.0   \n",
       "57907                       956.0                1.0            140.0   \n",
       "57908                       956.0                1.0            140.0   \n",
       "80102                       240.0                1.0           1050.0   \n",
       "55107                       256.0                1.0            180.0   \n",
       "77842                       982.0                3.0          17600.0   \n",
       "107082                     1294.0                5.0           9850.0   \n",
       "58873                       729.0                1.0           1200.0   \n",
       "82976                       237.0                3.0            100.0   \n",
       "97219                       329.0                4.0            188.0   \n",
       "100180                      969.0                3.0            400.0   \n",
       "97365                       498.0                1.0           2500.0   \n",
       "60335                       327.0                1.0          29500.0   \n",
       "60336                       327.0                1.0          22350.0   \n",
       "95975                       168.0                2.0            350.0   \n",
       "71728                      1729.0                1.0           2338.0   \n",
       "96686                      2526.0                3.0            308.0   \n",
       "69935                       401.0                1.0            213.0   \n",
       "95484                       382.0                5.0           5700.0   \n",
       "25057                       729.0                1.0           2220.0   \n",
       "106356                      629.0                1.0           1050.0   \n",
       "59754                       982.0                3.0          17600.0   \n",
       "72848                      1167.0                1.0           1900.0   \n",
       "108288                     1257.0                1.0            700.0   \n",
       "88158                       140.0                1.0            200.0   \n",
       "88159                       138.0                1.0            150.0   \n",
       "78900                       143.0                1.0           1338.0   \n",
       "87714                      1889.0                5.0            650.0   \n",
       "74690                       569.0                2.0           1200.0   \n",
       "\n",
       "       product_length_cm  product_height_cm  product_width_cm  \\\n",
       "85651               32.0               11.0              13.0   \n",
       "85652               35.0               12.0              15.0   \n",
       "94093               45.0                7.0              35.0   \n",
       "92832               35.0                2.0              50.0   \n",
       "96615               22.0               48.0              38.0   \n",
       "97414               30.0               25.0              30.0   \n",
       "90241               17.0               17.0              17.0   \n",
       "76666               22.0               14.0              14.0   \n",
       "202                 20.0               30.0              30.0   \n",
       "89081               70.0               37.0              70.0   \n",
       "78415               73.0               73.0              20.0   \n",
       "103183              40.0               15.0              11.0   \n",
       "103184              40.0               15.0              11.0   \n",
       "95750               50.0               60.0              27.0   \n",
       "95751               50.0               60.0              27.0   \n",
       "95752               50.0               60.0              27.0   \n",
       "95753               55.0               64.0              26.0   \n",
       "95754               50.0               60.0              27.0   \n",
       "97097               23.0               20.0              25.0   \n",
       "57907               22.0               14.0              14.0   \n",
       "57908               22.0               14.0              14.0   \n",
       "80102               22.0                9.0              12.0   \n",
       "55107               17.0               10.0              13.0   \n",
       "77842               49.0               49.0              23.0   \n",
       "107082              16.0               72.0              92.0   \n",
       "58873               20.0               30.0              30.0   \n",
       "82976               16.0               12.0              12.0   \n",
       "97219               17.0                6.0              12.0   \n",
       "100180              20.0               11.0              11.0   \n",
       "97365               30.0               30.0              30.0   \n",
       "60335               43.0               13.0              43.0   \n",
       "60336               41.0               13.0              41.0   \n",
       "95975               25.0                9.0              19.0   \n",
       "71728               25.0               23.0              18.0   \n",
       "96686               20.0               16.0              17.0   \n",
       "69935               18.0               12.0              13.0   \n",
       "95484               38.0               30.0              28.0   \n",
       "25057               20.0               30.0              30.0   \n",
       "106356              36.0               24.0              22.0   \n",
       "59754               49.0               49.0              23.0   \n",
       "72848               90.0               14.0              18.0   \n",
       "108288              25.0               12.0              19.0   \n",
       "88158               22.0               10.0              19.0   \n",
       "88159               22.0                7.0              16.0   \n",
       "78900               22.0               12.0              14.0   \n",
       "87714               38.0               10.0              28.0   \n",
       "74690               25.0               20.0              20.0   \n",
       "\n",
       "          product_category_name_english  sub_group_rank  \n",
       "85651             computers_accessories               1  \n",
       "85652             computers_accessories               2  \n",
       "94093                    bed_bath_table               3  \n",
       "92832                    bed_bath_table               4  \n",
       "96615                        stationery               5  \n",
       "97414                              auto               6  \n",
       "90241                    sports_leisure               7  \n",
       "76666             computers_accessories               8  \n",
       "202                      bed_bath_table               9  \n",
       "89081                        cool_stuff              10  \n",
       "78415                        cool_stuff              11  \n",
       "103183                  furniture_decor              12  \n",
       "103184                  furniture_decor              13  \n",
       "95750                  office_furniture              14  \n",
       "95751                  office_furniture              15  \n",
       "95752                  office_furniture              16  \n",
       "95753                  office_furniture              17  \n",
       "95754                  office_furniture              18  \n",
       "97097             computers_accessories              19  \n",
       "57907             computers_accessories              20  \n",
       "57908             computers_accessories              21  \n",
       "80102                       electronics              22  \n",
       "55107             computers_accessories              23  \n",
       "77842                              auto              24  \n",
       "107082                         pet_shop              25  \n",
       "58873                    bed_bath_table              26  \n",
       "82976                    consoles_games              27  \n",
       "97219                         telephony              28  \n",
       "100180                        perfumery              29  \n",
       "97365                   furniture_decor              30  \n",
       "60335   construction_tools_construction              31  \n",
       "60336   construction_tools_construction              32  \n",
       "95975                    bed_bath_table              33  \n",
       "71728                     health_beauty              34  \n",
       "96686                       electronics              35  \n",
       "69935             computers_accessories              36  \n",
       "95484                        stationery              37  \n",
       "25057                    bed_bath_table              38  \n",
       "106356                       cool_stuff              39  \n",
       "59754                              auto              40  \n",
       "72848                              auto              41  \n",
       "108288                    health_beauty              42  \n",
       "88158                         perfumery              43  \n",
       "88159                         perfumery              44  \n",
       "78900                     health_beauty              45  \n",
       "87714                    sports_leisure              46  \n",
       "74690                  small_appliances              47  \n",
       "\n",
       "[47 rows x 48 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_top_200[condition_1].sort_values(by='sub_group_rank').head(47)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "4c1cde21-4443-4c03-9297-eeb7bf1dce4b",
   "metadata": {
    "tags": []
   },
   "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>customer_id</th>\n",
       "      <th>customer_unique_id</th>\n",
       "      <th>zip_code_prefix_customer</th>\n",
       "      <th>customer_city</th>\n",
       "      <th>sc_state_customer</th>\n",
       "      <th>geolocation_lat_customer</th>\n",
       "      <th>geolocation_lng_customer</th>\n",
       "      <th>state_customer</th>\n",
       "      <th>region_customer</th>\n",
       "      <th>order_id</th>\n",
       "      <th>...</th>\n",
       "      <th>product_category_name</th>\n",
       "      <th>product_name_lenght</th>\n",
       "      <th>product_description_lenght</th>\n",
       "      <th>product_photos_qty</th>\n",
       "      <th>product_weight_g</th>\n",
       "      <th>product_length_cm</th>\n",
       "      <th>product_height_cm</th>\n",
       "      <th>product_width_cm</th>\n",
       "      <th>product_category_name_english</th>\n",
       "      <th>sub_group_rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>62640</th>\n",
       "      <td>f85e9ec0719b16dc4dd0edd438793553</td>\n",
       "      <td>e7834c7e017fb854ac65189a66c33132</td>\n",
       "      <td>38170</td>\n",
       "      <td>perdizes</td>\n",
       "      <td>MG</td>\n",
       "      <td>-19.360655</td>\n",
       "      <td>-47.285626</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>southeast</td>\n",
       "      <td>c27815f7e3dd0b926b58552628481575</td>\n",
       "      <td>...</td>\n",
       "      <td>eletrodomesticos_2</td>\n",
       "      <td>45.0</td>\n",
       "      <td>442.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9250.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>home_appliances_2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76431</th>\n",
       "      <td>fc99aeadad12e8925f558305956a08aa</td>\n",
       "      <td>4fd742055ecff67e27469f9b2ef1a72b</td>\n",
       "      <td>22621</td>\n",
       "      <td>rio de janeiro</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-23.010803</td>\n",
       "      <td>-43.309887</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>c2a550cc5f966506b717532441c221e5</td>\n",
       "      <td>...</td>\n",
       "      <td>bebes</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2440.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>375.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>baby</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42872</th>\n",
       "      <td>84ff1c605abdcecfd44ff1a0a9f0bb77</td>\n",
       "      <td>7fb41a4469f5c4350698682d6aa0f06f</td>\n",
       "      <td>14860</td>\n",
       "      <td>barrinha</td>\n",
       "      <td>SP</td>\n",
       "      <td>-21.190886</td>\n",
       "      <td>-48.156209</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>6e3a1f3ec46461756c3f620e267aa1b8</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_sala</td>\n",
       "      <td>33.0</td>\n",
       "      <td>332.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6750.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>furniture_living_room</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1068</th>\n",
       "      <td>4fdbaab85bcb2657b6b6c9fea1b0ccb6</td>\n",
       "      <td>e5a197b88d04fe99fe96b95f41a686f4</td>\n",
       "      <td>8021</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.500142</td>\n",
       "      <td>-46.434586</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>d8dbb44d7c5b1fd8e7f41b49e27053d7</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>60.0</td>\n",
       "      <td>269.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>3f5939e06e89efd9e9ca8ef3ab9d68c7</td>\n",
       "      <td>6b7e1090d106aaee31d5ed12d2bbc2af</td>\n",
       "      <td>1310</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.561653</td>\n",
       "      <td>-46.656021</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>d3aa5667ad65af7fa58a5481d0aff07a</td>\n",
       "      <td>...</td>\n",
       "      <td>esporte_lazer</td>\n",
       "      <td>58.0</td>\n",
       "      <td>568.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>sports_leisure</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1500</th>\n",
       "      <td>9d27f64e63e4599ce90c0646b2f09efd</td>\n",
       "      <td>f52319a9425f4d047832c682e74931fe</td>\n",
       "      <td>2122</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.511966</td>\n",
       "      <td>-46.583864</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>848b99752538e17e5a48212d76416846</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>39.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77679</th>\n",
       "      <td>a01d15466cc19da855ba754cafae38ae</td>\n",
       "      <td>d57588ebc4ba515d988842c032981845</td>\n",
       "      <td>21715</td>\n",
       "      <td>rio de janeiro</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.879477</td>\n",
       "      <td>-43.440264</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>f3a34019663003872f3892902d2b7b2d</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>53.0</td>\n",
       "      <td>961.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1850.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50049</th>\n",
       "      <td>1fce339685dd69089aa782acc947f328</td>\n",
       "      <td>970cab2431fe3ecdba987b0a2a5c54ba</td>\n",
       "      <td>89804</td>\n",
       "      <td>chapeco</td>\n",
       "      <td>SC</td>\n",
       "      <td>-27.079120</td>\n",
       "      <td>-52.631783</td>\n",
       "      <td>Santa Catarina</td>\n",
       "      <td>south</td>\n",
       "      <td>88e06e052985636ec90e5e7337150b62</td>\n",
       "      <td>...</td>\n",
       "      <td>perfumaria</td>\n",
       "      <td>59.0</td>\n",
       "      <td>874.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>525.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>perfumery</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15345</th>\n",
       "      <td>57df8c99c1858dc00e611b7b7e852af6</td>\n",
       "      <td>8230e3a4f90966341dec1a7b544e6cac</td>\n",
       "      <td>14700</td>\n",
       "      <td>bebedouro</td>\n",
       "      <td>SP</td>\n",
       "      <td>-20.946080</td>\n",
       "      <td>-48.486768</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>ac1de8fa694be661c516f1df6cd72a24</td>\n",
       "      <td>...</td>\n",
       "      <td>eletronicos</td>\n",
       "      <td>47.0</td>\n",
       "      <td>485.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>electronics</td>\n",
       "      <td>199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32753</th>\n",
       "      <td>fccdeafeeb46d7a1e258e97b5801db6f</td>\n",
       "      <td>fd2111f93b5ea7bdc12f42454235076e</td>\n",
       "      <td>14407</td>\n",
       "      <td>franca</td>\n",
       "      <td>SP</td>\n",
       "      <td>-20.496251</td>\n",
       "      <td>-47.418434</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>e42404a21e1f2985aa073939b8375da5</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>400.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            customer_id                customer_unique_id  \\\n",
       "62640  f85e9ec0719b16dc4dd0edd438793553  e7834c7e017fb854ac65189a66c33132   \n",
       "76431  fc99aeadad12e8925f558305956a08aa  4fd742055ecff67e27469f9b2ef1a72b   \n",
       "42872  84ff1c605abdcecfd44ff1a0a9f0bb77  7fb41a4469f5c4350698682d6aa0f06f   \n",
       "1068   4fdbaab85bcb2657b6b6c9fea1b0ccb6  e5a197b88d04fe99fe96b95f41a686f4   \n",
       "171    3f5939e06e89efd9e9ca8ef3ab9d68c7  6b7e1090d106aaee31d5ed12d2bbc2af   \n",
       "...                                 ...                               ...   \n",
       "1500   9d27f64e63e4599ce90c0646b2f09efd  f52319a9425f4d047832c682e74931fe   \n",
       "77679  a01d15466cc19da855ba754cafae38ae  d57588ebc4ba515d988842c032981845   \n",
       "50049  1fce339685dd69089aa782acc947f328  970cab2431fe3ecdba987b0a2a5c54ba   \n",
       "15345  57df8c99c1858dc00e611b7b7e852af6  8230e3a4f90966341dec1a7b544e6cac   \n",
       "32753  fccdeafeeb46d7a1e258e97b5801db6f  fd2111f93b5ea7bdc12f42454235076e   \n",
       "\n",
       "       zip_code_prefix_customer   customer_city sc_state_customer  \\\n",
       "62640                     38170        perdizes                MG   \n",
       "76431                     22621  rio de janeiro                RJ   \n",
       "42872                     14860        barrinha                SP   \n",
       "1068                       8021       sao paulo                SP   \n",
       "171                        1310       sao paulo                SP   \n",
       "...                         ...             ...               ...   \n",
       "1500                       2122       sao paulo                SP   \n",
       "77679                     21715  rio de janeiro                RJ   \n",
       "50049                     89804         chapeco                SC   \n",
       "15345                     14700       bebedouro                SP   \n",
       "32753                     14407          franca                SP   \n",
       "\n",
       "       geolocation_lat_customer  geolocation_lng_customer  state_customer  \\\n",
       "62640                -19.360655                -47.285626    Minas Gerais   \n",
       "76431                -23.010803                -43.309887  Rio de Janeiro   \n",
       "42872                -21.190886                -48.156209       São Paulo   \n",
       "1068                 -23.500142                -46.434586       São Paulo   \n",
       "171                  -23.561653                -46.656021       São Paulo   \n",
       "...                         ...                       ...             ...   \n",
       "1500                 -23.511966                -46.583864       São Paulo   \n",
       "77679                -22.879477                -43.440264  Rio de Janeiro   \n",
       "50049                -27.079120                -52.631783  Santa Catarina   \n",
       "15345                -20.946080                -48.486768       São Paulo   \n",
       "32753                -20.496251                -47.418434       São Paulo   \n",
       "\n",
       "      region_customer                          order_id  ...  \\\n",
       "62640       southeast  c27815f7e3dd0b926b58552628481575  ...   \n",
       "76431       southeast  c2a550cc5f966506b717532441c221e5  ...   \n",
       "42872       southeast  6e3a1f3ec46461756c3f620e267aa1b8  ...   \n",
       "1068        southeast  d8dbb44d7c5b1fd8e7f41b49e27053d7  ...   \n",
       "171         southeast  d3aa5667ad65af7fa58a5481d0aff07a  ...   \n",
       "...               ...                               ...  ...   \n",
       "1500        southeast  848b99752538e17e5a48212d76416846  ...   \n",
       "77679       southeast  f3a34019663003872f3892902d2b7b2d  ...   \n",
       "50049           south  88e06e052985636ec90e5e7337150b62  ...   \n",
       "15345       southeast  ac1de8fa694be661c516f1df6cd72a24  ...   \n",
       "32753       southeast  e42404a21e1f2985aa073939b8375da5  ...   \n",
       "\n",
       "        product_category_name product_name_lenght product_description_lenght  \\\n",
       "62640      eletrodomesticos_2                45.0                      442.0   \n",
       "76431                   bebes                57.0                     2440.0   \n",
       "42872             moveis_sala                33.0                      332.0   \n",
       "1068          cama_mesa_banho                60.0                      269.0   \n",
       "171             esporte_lazer                58.0                      568.0   \n",
       "...                       ...                 ...                        ...   \n",
       "1500          cama_mesa_banho                39.0                      161.0   \n",
       "77679  informatica_acessorios                53.0                      961.0   \n",
       "50049              perfumaria                59.0                      874.0   \n",
       "15345             eletronicos                47.0                      485.0   \n",
       "32753                     NaN                 NaN                        NaN   \n",
       "\n",
       "      product_photos_qty product_weight_g product_length_cm  \\\n",
       "62640                6.0           9250.0              30.0   \n",
       "76431                1.0            375.0              29.0   \n",
       "42872                1.0           6750.0              54.0   \n",
       "1068                 1.0           1700.0              34.0   \n",
       "171                  4.0           1500.0              35.0   \n",
       "...                  ...              ...               ...   \n",
       "1500                 2.0            350.0              25.0   \n",
       "77679                1.0           1850.0              39.0   \n",
       "50049                1.0            525.0              16.0   \n",
       "15345                1.0            200.0              30.0   \n",
       "32753                NaN            400.0              30.0   \n",
       "\n",
       "       product_height_cm  product_width_cm  product_category_name_english  \\\n",
       "62640               60.0              45.0              home_appliances_2   \n",
       "76431               14.0              20.0                           baby   \n",
       "42872               18.0              53.0          furniture_living_room   \n",
       "1068                 7.0              32.0                 bed_bath_table   \n",
       "171                 20.0              15.0                 sports_leisure   \n",
       "...                  ...               ...                            ...   \n",
       "1500                 8.0              19.0                 bed_bath_table   \n",
       "77679               12.0              22.0          computers_accessories   \n",
       "50049               16.0              18.0                      perfumery   \n",
       "15345               10.0              20.0                    electronics   \n",
       "32753               30.0              11.0                            NaN   \n",
       "\n",
       "       sub_group_rank  \n",
       "62640               1  \n",
       "76431               2  \n",
       "42872               3  \n",
       "1068                4  \n",
       "171                 5  \n",
       "...               ...  \n",
       "1500              196  \n",
       "77679             197  \n",
       "50049             198  \n",
       "15345             199  \n",
       "32753             200  \n",
       "\n",
       "[200 rows x 48 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Checking if the ranking is correct\n",
    "\n",
    "df_group_2= df_top_200[df_top_200['distance_group']=='group_2'].sort_values(by='sub_group_rank')\n",
    "df_group_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "6db2ae1a-df1a-4d8b-9093-45615c182ea6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_top_200.to_csv('data_sets/final_datasets/data_ranking_olist.csv', index= False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "582c785e-d306-4571-8792-184094e212b5",
   "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>customer_id</th>\n",
       "      <th>customer_unique_id</th>\n",
       "      <th>zip_code_prefix_customer</th>\n",
       "      <th>customer_city</th>\n",
       "      <th>sc_state_customer</th>\n",
       "      <th>geolocation_lat_customer</th>\n",
       "      <th>geolocation_lng_customer</th>\n",
       "      <th>state_customer</th>\n",
       "      <th>region_customer</th>\n",
       "      <th>order_id</th>\n",
       "      <th>...</th>\n",
       "      <th>product_category_name</th>\n",
       "      <th>product_name_lenght</th>\n",
       "      <th>product_description_lenght</th>\n",
       "      <th>product_photos_qty</th>\n",
       "      <th>product_weight_g</th>\n",
       "      <th>product_length_cm</th>\n",
       "      <th>product_height_cm</th>\n",
       "      <th>product_width_cm</th>\n",
       "      <th>product_category_name_english</th>\n",
       "      <th>sub_group_rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>32078</th>\n",
       "      <td>cb2caaaead400c97350c37a3fc536867</td>\n",
       "      <td>4cb8ad9a4554099db7d70c13d0dae906</td>\n",
       "      <td>13327</td>\n",
       "      <td>salto</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.179531</td>\n",
       "      <td>-47.313384</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>47b40429ed8cce3aee9199792275433f</td>\n",
       "      <td>...</td>\n",
       "      <td>casa_construcao</td>\n",
       "      <td>39.0</td>\n",
       "      <td>1190.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>30000.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>home_construction</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32811</th>\n",
       "      <td>beeda72b31be3b8a38b5c2b77d7705c4</td>\n",
       "      <td>beba456e33133cc65b481399d051b2ba</td>\n",
       "      <td>9851</td>\n",
       "      <td>sao bernardo do campo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.715285</td>\n",
       "      <td>-46.590457</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>d24e8541128cea179a11a65176e0a96f</td>\n",
       "      <td>...</td>\n",
       "      <td>utilidades_domesticas</td>\n",
       "      <td>42.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>housewares</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32812</th>\n",
       "      <td>beeda72b31be3b8a38b5c2b77d7705c4</td>\n",
       "      <td>beba456e33133cc65b481399d051b2ba</td>\n",
       "      <td>9851</td>\n",
       "      <td>sao bernardo do campo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.715285</td>\n",
       "      <td>-46.590457</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>d24e8541128cea179a11a65176e0a96f</td>\n",
       "      <td>...</td>\n",
       "      <td>utilidades_domesticas</td>\n",
       "      <td>40.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1150.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>housewares</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46032</th>\n",
       "      <td>3d7ded9f88ad6b06bc3f16ef0987fc54</td>\n",
       "      <td>c7d1c1a9792b4c5b53f6e88807ec88f6</td>\n",
       "      <td>13202</td>\n",
       "      <td>jundiai</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.204104</td>\n",
       "      <td>-46.872590</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>103188b1afa4614c023b86344f79727b</td>\n",
       "      <td>...</td>\n",
       "      <td>utilidades_domesticas</td>\n",
       "      <td>39.0</td>\n",
       "      <td>403.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>housewares</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53369</th>\n",
       "      <td>de933a935e7c75c60cf44b12e0972268</td>\n",
       "      <td>0c0efcea44dc4ff4f9a2d0afa966e609</td>\n",
       "      <td>31330</td>\n",
       "      <td>belo horizonte</td>\n",
       "      <td>MG</td>\n",
       "      <td>-19.877827</td>\n",
       "      <td>-43.995421</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>southeast</td>\n",
       "      <td>e7fc47a9bd5fd8c1d1b566d1553be0f4</td>\n",
       "      <td>...</td>\n",
       "      <td>ferramentas_jardim</td>\n",
       "      <td>60.0</td>\n",
       "      <td>196.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2400.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>garden_tools</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73466</th>\n",
       "      <td>b738e54deb887952988fe0b9e7bae515</td>\n",
       "      <td>d92d6e13a2e96880dc2d6a27e08bf3a5</td>\n",
       "      <td>20511</td>\n",
       "      <td>rio de janeiro</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.928413</td>\n",
       "      <td>-43.240538</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>5fc65d39393a0107a062195fdc96ad34</td>\n",
       "      <td>...</td>\n",
       "      <td>beleza_saude</td>\n",
       "      <td>55.0</td>\n",
       "      <td>2987.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1450.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>health_beauty</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44324</th>\n",
       "      <td>66d376416dfbdcb87ddc1f2384d343ba</td>\n",
       "      <td>58cb2f5bcf3fb5994bbf852e86978047</td>\n",
       "      <td>11390</td>\n",
       "      <td>sao vicente</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.961943</td>\n",
       "      <td>-46.382116</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>97f48024fcc76f1898e397ad6966e3a0</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_decoracao</td>\n",
       "      <td>25.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>furniture_decor</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38928</th>\n",
       "      <td>3eddc75fe2314996f68ddcd89ddb5caf</td>\n",
       "      <td>d6e35f5a7df8970f8cae8251516ab787</td>\n",
       "      <td>9571</td>\n",
       "      <td>sao caetano do sul</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.634903</td>\n",
       "      <td>-46.564837</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>8b7fd198ad184563c231653673e75a7f</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_decoracao</td>\n",
       "      <td>37.0</td>\n",
       "      <td>192.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>furniture_decor</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18267</th>\n",
       "      <td>7113efb0ff417de3c22fc3dec35f5b3c</td>\n",
       "      <td>f2bd7baf91b52d05cb2a572f19bc9b1b</td>\n",
       "      <td>6663</td>\n",
       "      <td>itapevi</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.557647</td>\n",
       "      <td>-46.939783</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>357f2ad2d9ea3e63b225cfee8ad3b2a1</td>\n",
       "      <td>...</td>\n",
       "      <td>papelaria</td>\n",
       "      <td>39.0</td>\n",
       "      <td>210.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1475.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>stationery</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8350</th>\n",
       "      <td>3c5ec3e2918028d4e3d956be876ba89b</td>\n",
       "      <td>b854c0239ddb345898833db3b80feedb</td>\n",
       "      <td>4044</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.600609</td>\n",
       "      <td>-46.639784</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>79366f316d691e60b576d0a9b45b4ba6</td>\n",
       "      <td>...</td>\n",
       "      <td>cool_stuff</td>\n",
       "      <td>54.0</td>\n",
       "      <td>998.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2850.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>cool_stuff</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13299</th>\n",
       "      <td>28ddcf325dffd061e80200e467d361b2</td>\n",
       "      <td>d36a28a79ec3068a81a237eaff375f89</td>\n",
       "      <td>6462</td>\n",
       "      <td>barueri</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.485397</td>\n",
       "      <td>-46.809794</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>2f71a7d28c0418b03cd08aed6b0a4400</td>\n",
       "      <td>...</td>\n",
       "      <td>beleza_saude</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1455.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>683.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>health_beauty</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35511</th>\n",
       "      <td>f4148260a4a09bd6d25af93188d106d7</td>\n",
       "      <td>2e366b0c6451864364bab2e7917ca1bb</td>\n",
       "      <td>9132</td>\n",
       "      <td>santo andre</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.703763</td>\n",
       "      <td>-46.501752</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>af95d7a4f9643401325ec89b4f7f8afe</td>\n",
       "      <td>...</td>\n",
       "      <td>fashion_bolsas_e_acessorios</td>\n",
       "      <td>59.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>fashion_bags_accessories</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6992</th>\n",
       "      <td>91fc7465107d197ce60e483d9f601dc8</td>\n",
       "      <td>f8bafce27bef77e21b560a20644ab4f2</td>\n",
       "      <td>13184</td>\n",
       "      <td>hortolandia</td>\n",
       "      <td>SP</td>\n",
       "      <td>-22.870283</td>\n",
       "      <td>-47.212414</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>5622ad01924109b081d3f0f7fdd45f71</td>\n",
       "      <td>...</td>\n",
       "      <td>fashion_bolsas_e_acessorios</td>\n",
       "      <td>41.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>fashion_bags_accessories</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69149</th>\n",
       "      <td>e4f06fec45100ba91af9bc48190aacf0</td>\n",
       "      <td>5988cee3152a64b959afb5a6eeb87a4c</td>\n",
       "      <td>27175</td>\n",
       "      <td>pirai</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.625001</td>\n",
       "      <td>-43.896663</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>880a2443009447fa88b518da4806fc93</td>\n",
       "      <td>...</td>\n",
       "      <td>beleza_saude</td>\n",
       "      <td>44.0</td>\n",
       "      <td>1165.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>health_beauty</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71903</th>\n",
       "      <td>b650ca1298e7cc383a35fced87af148a</td>\n",
       "      <td>670315a8178ee2a1050e5ddb23b21606</td>\n",
       "      <td>22790</td>\n",
       "      <td>rio de janeiro</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-23.012987</td>\n",
       "      <td>-43.465520</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>2c9ef60013a5ee6a831360e3d98c9c0d</td>\n",
       "      <td>...</td>\n",
       "      <td>brinquedos</td>\n",
       "      <td>40.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>750.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>toys</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35022</th>\n",
       "      <td>c8b7d6f94ed82f63ec835ef1af699c1f</td>\n",
       "      <td>a1c839a978e05fedd92fec96d4ea685d</td>\n",
       "      <td>11702</td>\n",
       "      <td>praia grande</td>\n",
       "      <td>SP</td>\n",
       "      <td>-24.014395</td>\n",
       "      <td>-46.438358</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>7410535fe6a922518e4f862208c066bf</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1128.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16133.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>office_furniture</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13205</th>\n",
       "      <td>9009e9f0ac28d47bd18433d82aa028d6</td>\n",
       "      <td>fb554546f4b290032e65366c8472a343</td>\n",
       "      <td>12080</td>\n",
       "      <td>taubate</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.022806</td>\n",
       "      <td>-45.550847</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>866314550f6d7a55c82917d9b4463e1f</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>51.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>817.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13206</th>\n",
       "      <td>9009e9f0ac28d47bd18433d82aa028d6</td>\n",
       "      <td>fb554546f4b290032e65366c8472a343</td>\n",
       "      <td>12080</td>\n",
       "      <td>taubate</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.022806</td>\n",
       "      <td>-45.550847</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>866314550f6d7a55c82917d9b4463e1f</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>51.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>817.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45771</th>\n",
       "      <td>29df9d84d5c2c55f18ca5afe1701f031</td>\n",
       "      <td>fbed94e43d1a3b02454cf347c3acde1b</td>\n",
       "      <td>11706</td>\n",
       "      <td>praia grande</td>\n",
       "      <td>SP</td>\n",
       "      <td>-24.047332</td>\n",
       "      <td>-46.525443</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>a81c8b86774acbd8736ec06f26772f41</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_decoracao</td>\n",
       "      <td>48.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1450.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>furniture_decor</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36035</th>\n",
       "      <td>4ff6cf227ad4c418dab2aab38d9022f4</td>\n",
       "      <td>7da12aefce6a8b6112fb9dda7c5c6dd9</td>\n",
       "      <td>8440</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.533543</td>\n",
       "      <td>-46.410418</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>88c73414c84d0729fdfc26ad5442963e</td>\n",
       "      <td>...</td>\n",
       "      <td>esporte_lazer</td>\n",
       "      <td>38.0</td>\n",
       "      <td>203.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>sports_leisure</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29168</th>\n",
       "      <td>b6fbaad4eb3a0794111683dca8122610</td>\n",
       "      <td>839ec7c231c579ed10ddab6610f8f12b</td>\n",
       "      <td>2111</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.517643</td>\n",
       "      <td>-46.592757</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>0096668e5b0b8e9657a6f7209a4e58b4</td>\n",
       "      <td>...</td>\n",
       "      <td>automotivo</td>\n",
       "      <td>60.0</td>\n",
       "      <td>1159.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2450.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>auto</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19062</th>\n",
       "      <td>9820e5ca96a381bc3166b135b064b64f</td>\n",
       "      <td>b4ed71ab794dd2e18336ccdc3d9bcf42</td>\n",
       "      <td>11702</td>\n",
       "      <td>praia grande</td>\n",
       "      <td>SP</td>\n",
       "      <td>-24.014395</td>\n",
       "      <td>-46.438358</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>8a7679380ddbbbe7495aa2d1cafd515b</td>\n",
       "      <td>...</td>\n",
       "      <td>alimentos</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2585.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4450.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>food</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11559</th>\n",
       "      <td>2ac47a6fd8210114acf678959654944d</td>\n",
       "      <td>a53e5a77a7bc419a73b6b8505baa9101</td>\n",
       "      <td>13092</td>\n",
       "      <td>campinas</td>\n",
       "      <td>SP</td>\n",
       "      <td>-22.895001</td>\n",
       "      <td>-47.034836</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>e78602addbd8567873e9ad519d11ad9c</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>52.0</td>\n",
       "      <td>248.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2584.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13271</th>\n",
       "      <td>533f0f527edd31355c911bec8caef8e2</td>\n",
       "      <td>700bca91ce2b57d63ac40d9a28097da8</td>\n",
       "      <td>9971</td>\n",
       "      <td>diadema</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.725848</td>\n",
       "      <td>-46.621347</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>bac5252be9b1269976695ebd118ef43d</td>\n",
       "      <td>...</td>\n",
       "      <td>bebes</td>\n",
       "      <td>37.0</td>\n",
       "      <td>497.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>baby</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24947</th>\n",
       "      <td>7b0fc6ecc532642ffce9a191715e3faf</td>\n",
       "      <td>ac655882b54449ebf0a37d604d15cb74</td>\n",
       "      <td>13049</td>\n",
       "      <td>campinas</td>\n",
       "      <td>SP</td>\n",
       "      <td>-22.948238</td>\n",
       "      <td>-47.080044</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>81f2ee7669eee05b13906d24d43ebc69</td>\n",
       "      <td>...</td>\n",
       "      <td>utilidades_domesticas</td>\n",
       "      <td>53.0</td>\n",
       "      <td>1034.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>16550.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>housewares</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23106</th>\n",
       "      <td>3d0ddc15f0b45855c923fe2881dd47ee</td>\n",
       "      <td>8b18d86b5cfdb835098b504137eadce7</td>\n",
       "      <td>18143</td>\n",
       "      <td>sao roque</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.560207</td>\n",
       "      <td>-47.087742</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>38d544a25d70fdf56f6630a9bcf7f82d</td>\n",
       "      <td>...</td>\n",
       "      <td>consoles_games</td>\n",
       "      <td>42.0</td>\n",
       "      <td>1266.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>consoles_games</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73724</th>\n",
       "      <td>1a72bada5214567decd50b77bfaa22b6</td>\n",
       "      <td>bf991384e52450ac9fb8fceb295dbe26</td>\n",
       "      <td>20271</td>\n",
       "      <td>rio de janeiro</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.915669</td>\n",
       "      <td>-43.225213</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>66cd3a1c2edd13d9da86b50aca9e3d32</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6623</th>\n",
       "      <td>94dc5118a4bda894002d294ee615a4e3</td>\n",
       "      <td>628ae8584a1c192e60498fb6983bfd9d</td>\n",
       "      <td>9290</td>\n",
       "      <td>santo andre</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.652361</td>\n",
       "      <td>-46.507897</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>65a7c3111cd734466eb706d544e6fae4</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>47.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6624</th>\n",
       "      <td>94dc5118a4bda894002d294ee615a4e3</td>\n",
       "      <td>628ae8584a1c192e60498fb6983bfd9d</td>\n",
       "      <td>9290</td>\n",
       "      <td>santo andre</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.652361</td>\n",
       "      <td>-46.507897</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>65a7c3111cd734466eb706d544e6fae4</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>52.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6625</th>\n",
       "      <td>94dc5118a4bda894002d294ee615a4e3</td>\n",
       "      <td>628ae8584a1c192e60498fb6983bfd9d</td>\n",
       "      <td>9290</td>\n",
       "      <td>santo andre</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.652361</td>\n",
       "      <td>-46.507897</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>65a7c3111cd734466eb706d544e6fae4</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>53.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76929</th>\n",
       "      <td>f5ced6e0d7c20ef958cf5f9269f4287d</td>\n",
       "      <td>8bbcb3029b226dcac4373062433b52f3</td>\n",
       "      <td>21842</td>\n",
       "      <td>rio de janeiro</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.868421</td>\n",
       "      <td>-43.479856</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>fa8d60735eb7db0f4659893592e3fec0</td>\n",
       "      <td>...</td>\n",
       "      <td>esporte_lazer</td>\n",
       "      <td>42.0</td>\n",
       "      <td>877.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2100.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>sports_leisure</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37699</th>\n",
       "      <td>08f94d51129e9289745af658b2c5e578</td>\n",
       "      <td>cf2e05ce00780dd66ddf509bb04cc95e</td>\n",
       "      <td>2241</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.490669</td>\n",
       "      <td>-46.607439</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>19c32126a85a7e87c6bcf2aa99e6ae9e</td>\n",
       "      <td>...</td>\n",
       "      <td>cama_mesa_banho</td>\n",
       "      <td>47.0</td>\n",
       "      <td>298.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>bed_bath_table</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78407</th>\n",
       "      <td>ff567b222d32e3d5198771f4125b7b40</td>\n",
       "      <td>fafc4a24221fb5a48653e1bae9138e22</td>\n",
       "      <td>26900</td>\n",
       "      <td>miguel pereira</td>\n",
       "      <td>RJ</td>\n",
       "      <td>-22.455517</td>\n",
       "      <td>-43.470083</td>\n",
       "      <td>Rio de Janeiro</td>\n",
       "      <td>southeast</td>\n",
       "      <td>7c59d327d267a2ce386f84038c0035c5</td>\n",
       "      <td>...</td>\n",
       "      <td>ferramentas_jardim</td>\n",
       "      <td>39.0</td>\n",
       "      <td>1570.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1625.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>garden_tools</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9819</th>\n",
       "      <td>4c641eb5ac1a5a0becc4610f1084125d</td>\n",
       "      <td>44482ad67ba7af317fd50e27e5f0f009</td>\n",
       "      <td>4016</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.588210</td>\n",
       "      <td>-46.643628</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>812086848825c140a1472472a845a774</td>\n",
       "      <td>...</td>\n",
       "      <td>relogios_presentes</td>\n",
       "      <td>51.0</td>\n",
       "      <td>404.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>820.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>watches_gifts</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13904</th>\n",
       "      <td>107cce44c67b79a9979e971dd6227aa2</td>\n",
       "      <td>1498be8bcb23f385c37e571a8d7af424</td>\n",
       "      <td>14110</td>\n",
       "      <td>bonfim paulista</td>\n",
       "      <td>SP</td>\n",
       "      <td>-21.254548</td>\n",
       "      <td>-47.815291</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>30d6ee4a4d29531562ae9ca6c0635d61</td>\n",
       "      <td>...</td>\n",
       "      <td>esporte_lazer</td>\n",
       "      <td>56.0</td>\n",
       "      <td>2274.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>sports_leisure</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12507</th>\n",
       "      <td>8266047feab97e3f2a81b323a0fc42b0</td>\n",
       "      <td>edaced9806005e41a24fed33e2a1469c</td>\n",
       "      <td>5336</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.544925</td>\n",
       "      <td>-46.753330</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>5a90bdab22ab69f4095415dd55451b66</td>\n",
       "      <td>...</td>\n",
       "      <td>informatica_acessorios</td>\n",
       "      <td>52.0</td>\n",
       "      <td>398.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>computers_accessories</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31423</th>\n",
       "      <td>8134db246a16a831c897deedc0f6e3eb</td>\n",
       "      <td>66eaa2ba32cb330d28add7d852e265e6</td>\n",
       "      <td>13220</td>\n",
       "      <td>varzea paulista</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.210968</td>\n",
       "      <td>-46.844819</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>564db6e83379512127bc60da803b4a36</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18716</th>\n",
       "      <td>45f5c9d984dbfa2105e3544cc85133bf</td>\n",
       "      <td>86a2b7754f964102510d42ab30898f63</td>\n",
       "      <td>13056</td>\n",
       "      <td>campinas</td>\n",
       "      <td>SP</td>\n",
       "      <td>-22.975100</td>\n",
       "      <td>-47.142925</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>fbd82b1fe98967de0db29b6cf134d00a</td>\n",
       "      <td>...</td>\n",
       "      <td>bebes</td>\n",
       "      <td>32.0</td>\n",
       "      <td>572.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>baby</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31082</th>\n",
       "      <td>7100e029840cace5a1d56ccc75b83ccb</td>\n",
       "      <td>f59e3e14cfa2eb6f8865aaef2fe83acf</td>\n",
       "      <td>13175</td>\n",
       "      <td>sumare</td>\n",
       "      <td>SP</td>\n",
       "      <td>-22.817992</td>\n",
       "      <td>-47.241101</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>5e70bcf826ffb41fbf68e94ba929635e</td>\n",
       "      <td>...</td>\n",
       "      <td>perfumaria</td>\n",
       "      <td>49.0</td>\n",
       "      <td>696.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>254.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>perfumery</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23958</th>\n",
       "      <td>21a6abdf0197fbe57451bd0a1d3c59a2</td>\n",
       "      <td>5fc74f8947fe099b44a20bde30661d83</td>\n",
       "      <td>3683</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.521920</td>\n",
       "      <td>-46.482302</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>6b3ee7697a02619a0ace2b3f0aa46bde</td>\n",
       "      <td>...</td>\n",
       "      <td>beleza_saude</td>\n",
       "      <td>60.0</td>\n",
       "      <td>316.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>health_beauty</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16817</th>\n",
       "      <td>573dc06cd01ce38087680e66d886a1c0</td>\n",
       "      <td>6e6623d8c8c95ef0dd34d534391632ee</td>\n",
       "      <td>9361</td>\n",
       "      <td>maua</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.696376</td>\n",
       "      <td>-46.455793</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>10c5eb3ea9a23055a311c44022b574eb</td>\n",
       "      <td>...</td>\n",
       "      <td>telefonia</td>\n",
       "      <td>31.0</td>\n",
       "      <td>890.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>telephony</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58001</th>\n",
       "      <td>3bac688ff89c697ddfc8fccb1206efee</td>\n",
       "      <td>a2b3ce5552d104942d42485e8cf59397</td>\n",
       "      <td>37550</td>\n",
       "      <td>pouso alegre</td>\n",
       "      <td>MG</td>\n",
       "      <td>-22.235083</td>\n",
       "      <td>-45.933922</td>\n",
       "      <td>Minas Gerais</td>\n",
       "      <td>southeast</td>\n",
       "      <td>874b5f0892d39a5537e47c53d0ad4457</td>\n",
       "      <td>...</td>\n",
       "      <td>bebidas</td>\n",
       "      <td>57.0</td>\n",
       "      <td>313.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>drinks</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24382</th>\n",
       "      <td>bcf130ec4f60035b99625fd5c5fc88ed</td>\n",
       "      <td>eebbe9b9abd6cdfe83e65a48adb338a4</td>\n",
       "      <td>11380</td>\n",
       "      <td>sao vicente</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.959895</td>\n",
       "      <td>-46.372795</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>020d1063c6e7cb975472aedbfe0e25ea</td>\n",
       "      <td>...</td>\n",
       "      <td>moveis_escritorio</td>\n",
       "      <td>55.0</td>\n",
       "      <td>955.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8267.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>office_furniture</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10218</th>\n",
       "      <td>da0ba2a9935bca5b4610b0e3bca9d3b4</td>\n",
       "      <td>88bc832f104b6dd684a17dbb1b76e778</td>\n",
       "      <td>2993</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.453962</td>\n",
       "      <td>-46.731884</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>ed8c7b1b3eb256c70ce0c74231e1da88</td>\n",
       "      <td>...</td>\n",
       "      <td>utilidades_domesticas</td>\n",
       "      <td>47.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7600.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>housewares</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29857</th>\n",
       "      <td>92e68079c7279941d8a95546c20f340d</td>\n",
       "      <td>076dc8d838b4a277c14d6e67445b04bb</td>\n",
       "      <td>5565</td>\n",
       "      <td>sao paulo</td>\n",
       "      <td>SP</td>\n",
       "      <td>-23.595660</td>\n",
       "      <td>-46.789084</td>\n",
       "      <td>São Paulo</td>\n",
       "      <td>southeast</td>\n",
       "      <td>961a477711141b3811b897eb49216db1</td>\n",
       "      <td>...</td>\n",
       "      <td>papelaria</td>\n",
       "      <td>59.0</td>\n",
       "      <td>251.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>stationery</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97521</th>\n",
       "      <td>8c13e5ab23851a6fdf5000a1db2378db</td>\n",
       "      <td>25f2a384fa2be0af7d759ec22bd5e88e</td>\n",
       "      <td>48110</td>\n",
       "      <td>catu</td>\n",
       "      <td>BA</td>\n",
       "      <td>-12.363841</td>\n",
       "      <td>-38.381869</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>5fd0b812a7ad786c02970c4223ef1dff</td>\n",
       "      <td>...</td>\n",
       "      <td>telefonia</td>\n",
       "      <td>51.0</td>\n",
       "      <td>422.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>telephony</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97522</th>\n",
       "      <td>8c13e5ab23851a6fdf5000a1db2378db</td>\n",
       "      <td>25f2a384fa2be0af7d759ec22bd5e88e</td>\n",
       "      <td>48110</td>\n",
       "      <td>catu</td>\n",
       "      <td>BA</td>\n",
       "      <td>-12.363841</td>\n",
       "      <td>-38.381869</td>\n",
       "      <td>Bahia</td>\n",
       "      <td>northeast</td>\n",
       "      <td>5fd0b812a7ad786c02970c4223ef1dff</td>\n",
       "      <td>...</td>\n",
       "      <td>telefonia</td>\n",
       "      <td>51.0</td>\n",
       "      <td>422.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>telephony</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>47 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            customer_id                customer_unique_id  \\\n",
       "32078  cb2caaaead400c97350c37a3fc536867  4cb8ad9a4554099db7d70c13d0dae906   \n",
       "32811  beeda72b31be3b8a38b5c2b77d7705c4  beba456e33133cc65b481399d051b2ba   \n",
       "32812  beeda72b31be3b8a38b5c2b77d7705c4  beba456e33133cc65b481399d051b2ba   \n",
       "46032  3d7ded9f88ad6b06bc3f16ef0987fc54  c7d1c1a9792b4c5b53f6e88807ec88f6   \n",
       "53369  de933a935e7c75c60cf44b12e0972268  0c0efcea44dc4ff4f9a2d0afa966e609   \n",
       "73466  b738e54deb887952988fe0b9e7bae515  d92d6e13a2e96880dc2d6a27e08bf3a5   \n",
       "44324  66d376416dfbdcb87ddc1f2384d343ba  58cb2f5bcf3fb5994bbf852e86978047   \n",
       "38928  3eddc75fe2314996f68ddcd89ddb5caf  d6e35f5a7df8970f8cae8251516ab787   \n",
       "18267  7113efb0ff417de3c22fc3dec35f5b3c  f2bd7baf91b52d05cb2a572f19bc9b1b   \n",
       "8350   3c5ec3e2918028d4e3d956be876ba89b  b854c0239ddb345898833db3b80feedb   \n",
       "13299  28ddcf325dffd061e80200e467d361b2  d36a28a79ec3068a81a237eaff375f89   \n",
       "35511  f4148260a4a09bd6d25af93188d106d7  2e366b0c6451864364bab2e7917ca1bb   \n",
       "6992   91fc7465107d197ce60e483d9f601dc8  f8bafce27bef77e21b560a20644ab4f2   \n",
       "69149  e4f06fec45100ba91af9bc48190aacf0  5988cee3152a64b959afb5a6eeb87a4c   \n",
       "71903  b650ca1298e7cc383a35fced87af148a  670315a8178ee2a1050e5ddb23b21606   \n",
       "35022  c8b7d6f94ed82f63ec835ef1af699c1f  a1c839a978e05fedd92fec96d4ea685d   \n",
       "13205  9009e9f0ac28d47bd18433d82aa028d6  fb554546f4b290032e65366c8472a343   \n",
       "13206  9009e9f0ac28d47bd18433d82aa028d6  fb554546f4b290032e65366c8472a343   \n",
       "45771  29df9d84d5c2c55f18ca5afe1701f031  fbed94e43d1a3b02454cf347c3acde1b   \n",
       "36035  4ff6cf227ad4c418dab2aab38d9022f4  7da12aefce6a8b6112fb9dda7c5c6dd9   \n",
       "29168  b6fbaad4eb3a0794111683dca8122610  839ec7c231c579ed10ddab6610f8f12b   \n",
       "19062  9820e5ca96a381bc3166b135b064b64f  b4ed71ab794dd2e18336ccdc3d9bcf42   \n",
       "11559  2ac47a6fd8210114acf678959654944d  a53e5a77a7bc419a73b6b8505baa9101   \n",
       "13271  533f0f527edd31355c911bec8caef8e2  700bca91ce2b57d63ac40d9a28097da8   \n",
       "24947  7b0fc6ecc532642ffce9a191715e3faf  ac655882b54449ebf0a37d604d15cb74   \n",
       "23106  3d0ddc15f0b45855c923fe2881dd47ee  8b18d86b5cfdb835098b504137eadce7   \n",
       "73724  1a72bada5214567decd50b77bfaa22b6  bf991384e52450ac9fb8fceb295dbe26   \n",
       "6623   94dc5118a4bda894002d294ee615a4e3  628ae8584a1c192e60498fb6983bfd9d   \n",
       "6624   94dc5118a4bda894002d294ee615a4e3  628ae8584a1c192e60498fb6983bfd9d   \n",
       "6625   94dc5118a4bda894002d294ee615a4e3  628ae8584a1c192e60498fb6983bfd9d   \n",
       "76929  f5ced6e0d7c20ef958cf5f9269f4287d  8bbcb3029b226dcac4373062433b52f3   \n",
       "37699  08f94d51129e9289745af658b2c5e578  cf2e05ce00780dd66ddf509bb04cc95e   \n",
       "78407  ff567b222d32e3d5198771f4125b7b40  fafc4a24221fb5a48653e1bae9138e22   \n",
       "9819   4c641eb5ac1a5a0becc4610f1084125d  44482ad67ba7af317fd50e27e5f0f009   \n",
       "13904  107cce44c67b79a9979e971dd6227aa2  1498be8bcb23f385c37e571a8d7af424   \n",
       "12507  8266047feab97e3f2a81b323a0fc42b0  edaced9806005e41a24fed33e2a1469c   \n",
       "31423  8134db246a16a831c897deedc0f6e3eb  66eaa2ba32cb330d28add7d852e265e6   \n",
       "18716  45f5c9d984dbfa2105e3544cc85133bf  86a2b7754f964102510d42ab30898f63   \n",
       "31082  7100e029840cace5a1d56ccc75b83ccb  f59e3e14cfa2eb6f8865aaef2fe83acf   \n",
       "23958  21a6abdf0197fbe57451bd0a1d3c59a2  5fc74f8947fe099b44a20bde30661d83   \n",
       "16817  573dc06cd01ce38087680e66d886a1c0  6e6623d8c8c95ef0dd34d534391632ee   \n",
       "58001  3bac688ff89c697ddfc8fccb1206efee  a2b3ce5552d104942d42485e8cf59397   \n",
       "24382  bcf130ec4f60035b99625fd5c5fc88ed  eebbe9b9abd6cdfe83e65a48adb338a4   \n",
       "10218  da0ba2a9935bca5b4610b0e3bca9d3b4  88bc832f104b6dd684a17dbb1b76e778   \n",
       "29857  92e68079c7279941d8a95546c20f340d  076dc8d838b4a277c14d6e67445b04bb   \n",
       "97521  8c13e5ab23851a6fdf5000a1db2378db  25f2a384fa2be0af7d759ec22bd5e88e   \n",
       "97522  8c13e5ab23851a6fdf5000a1db2378db  25f2a384fa2be0af7d759ec22bd5e88e   \n",
       "\n",
       "       zip_code_prefix_customer          customer_city sc_state_customer  \\\n",
       "32078                     13327                  salto                SP   \n",
       "32811                      9851  sao bernardo do campo                SP   \n",
       "32812                      9851  sao bernardo do campo                SP   \n",
       "46032                     13202                jundiai                SP   \n",
       "53369                     31330         belo horizonte                MG   \n",
       "73466                     20511         rio de janeiro                RJ   \n",
       "44324                     11390            sao vicente                SP   \n",
       "38928                      9571     sao caetano do sul                SP   \n",
       "18267                      6663                itapevi                SP   \n",
       "8350                       4044              sao paulo                SP   \n",
       "13299                      6462                barueri                SP   \n",
       "35511                      9132            santo andre                SP   \n",
       "6992                      13184            hortolandia                SP   \n",
       "69149                     27175                  pirai                RJ   \n",
       "71903                     22790         rio de janeiro                RJ   \n",
       "35022                     11702           praia grande                SP   \n",
       "13205                     12080                taubate                SP   \n",
       "13206                     12080                taubate                SP   \n",
       "45771                     11706           praia grande                SP   \n",
       "36035                      8440              sao paulo                SP   \n",
       "29168                      2111              sao paulo                SP   \n",
       "19062                     11702           praia grande                SP   \n",
       "11559                     13092               campinas                SP   \n",
       "13271                      9971                diadema                SP   \n",
       "24947                     13049               campinas                SP   \n",
       "23106                     18143              sao roque                SP   \n",
       "73724                     20271         rio de janeiro                RJ   \n",
       "6623                       9290            santo andre                SP   \n",
       "6624                       9290            santo andre                SP   \n",
       "6625                       9290            santo andre                SP   \n",
       "76929                     21842         rio de janeiro                RJ   \n",
       "37699                      2241              sao paulo                SP   \n",
       "78407                     26900         miguel pereira                RJ   \n",
       "9819                       4016              sao paulo                SP   \n",
       "13904                     14110        bonfim paulista                SP   \n",
       "12507                      5336              sao paulo                SP   \n",
       "31423                     13220        varzea paulista                SP   \n",
       "18716                     13056               campinas                SP   \n",
       "31082                     13175                 sumare                SP   \n",
       "23958                      3683              sao paulo                SP   \n",
       "16817                      9361                   maua                SP   \n",
       "58001                     37550           pouso alegre                MG   \n",
       "24382                     11380            sao vicente                SP   \n",
       "10218                      2993              sao paulo                SP   \n",
       "29857                      5565              sao paulo                SP   \n",
       "97521                     48110                   catu                BA   \n",
       "97522                     48110                   catu                BA   \n",
       "\n",
       "       geolocation_lat_customer  geolocation_lng_customer  state_customer  \\\n",
       "32078                -23.179531                -47.313384       São Paulo   \n",
       "32811                -23.715285                -46.590457       São Paulo   \n",
       "32812                -23.715285                -46.590457       São Paulo   \n",
       "46032                -23.204104                -46.872590       São Paulo   \n",
       "53369                -19.877827                -43.995421    Minas Gerais   \n",
       "73466                -22.928413                -43.240538  Rio de Janeiro   \n",
       "44324                -23.961943                -46.382116       São Paulo   \n",
       "38928                -23.634903                -46.564837       São Paulo   \n",
       "18267                -23.557647                -46.939783       São Paulo   \n",
       "8350                 -23.600609                -46.639784       São Paulo   \n",
       "13299                -23.485397                -46.809794       São Paulo   \n",
       "35511                -23.703763                -46.501752       São Paulo   \n",
       "6992                 -22.870283                -47.212414       São Paulo   \n",
       "69149                -22.625001                -43.896663  Rio de Janeiro   \n",
       "71903                -23.012987                -43.465520  Rio de Janeiro   \n",
       "35022                -24.014395                -46.438358       São Paulo   \n",
       "13205                -23.022806                -45.550847       São Paulo   \n",
       "13206                -23.022806                -45.550847       São Paulo   \n",
       "45771                -24.047332                -46.525443       São Paulo   \n",
       "36035                -23.533543                -46.410418       São Paulo   \n",
       "29168                -23.517643                -46.592757       São Paulo   \n",
       "19062                -24.014395                -46.438358       São Paulo   \n",
       "11559                -22.895001                -47.034836       São Paulo   \n",
       "13271                -23.725848                -46.621347       São Paulo   \n",
       "24947                -22.948238                -47.080044       São Paulo   \n",
       "23106                -23.560207                -47.087742       São Paulo   \n",
       "73724                -22.915669                -43.225213  Rio de Janeiro   \n",
       "6623                 -23.652361                -46.507897       São Paulo   \n",
       "6624                 -23.652361                -46.507897       São Paulo   \n",
       "6625                 -23.652361                -46.507897       São Paulo   \n",
       "76929                -22.868421                -43.479856  Rio de Janeiro   \n",
       "37699                -23.490669                -46.607439       São Paulo   \n",
       "78407                -22.455517                -43.470083  Rio de Janeiro   \n",
       "9819                 -23.588210                -46.643628       São Paulo   \n",
       "13904                -21.254548                -47.815291       São Paulo   \n",
       "12507                -23.544925                -46.753330       São Paulo   \n",
       "31423                -23.210968                -46.844819       São Paulo   \n",
       "18716                -22.975100                -47.142925       São Paulo   \n",
       "31082                -22.817992                -47.241101       São Paulo   \n",
       "23958                -23.521920                -46.482302       São Paulo   \n",
       "16817                -23.696376                -46.455793       São Paulo   \n",
       "58001                -22.235083                -45.933922    Minas Gerais   \n",
       "24382                -23.959895                -46.372795       São Paulo   \n",
       "10218                -23.453962                -46.731884       São Paulo   \n",
       "29857                -23.595660                -46.789084       São Paulo   \n",
       "97521                -12.363841                -38.381869           Bahia   \n",
       "97522                -12.363841                -38.381869           Bahia   \n",
       "\n",
       "      region_customer                          order_id  ...  \\\n",
       "32078       southeast  47b40429ed8cce3aee9199792275433f  ...   \n",
       "32811       southeast  d24e8541128cea179a11a65176e0a96f  ...   \n",
       "32812       southeast  d24e8541128cea179a11a65176e0a96f  ...   \n",
       "46032       southeast  103188b1afa4614c023b86344f79727b  ...   \n",
       "53369       southeast  e7fc47a9bd5fd8c1d1b566d1553be0f4  ...   \n",
       "73466       southeast  5fc65d39393a0107a062195fdc96ad34  ...   \n",
       "44324       southeast  97f48024fcc76f1898e397ad6966e3a0  ...   \n",
       "38928       southeast  8b7fd198ad184563c231653673e75a7f  ...   \n",
       "18267       southeast  357f2ad2d9ea3e63b225cfee8ad3b2a1  ...   \n",
       "8350        southeast  79366f316d691e60b576d0a9b45b4ba6  ...   \n",
       "13299       southeast  2f71a7d28c0418b03cd08aed6b0a4400  ...   \n",
       "35511       southeast  af95d7a4f9643401325ec89b4f7f8afe  ...   \n",
       "6992        southeast  5622ad01924109b081d3f0f7fdd45f71  ...   \n",
       "69149       southeast  880a2443009447fa88b518da4806fc93  ...   \n",
       "71903       southeast  2c9ef60013a5ee6a831360e3d98c9c0d  ...   \n",
       "35022       southeast  7410535fe6a922518e4f862208c066bf  ...   \n",
       "13205       southeast  866314550f6d7a55c82917d9b4463e1f  ...   \n",
       "13206       southeast  866314550f6d7a55c82917d9b4463e1f  ...   \n",
       "45771       southeast  a81c8b86774acbd8736ec06f26772f41  ...   \n",
       "36035       southeast  88c73414c84d0729fdfc26ad5442963e  ...   \n",
       "29168       southeast  0096668e5b0b8e9657a6f7209a4e58b4  ...   \n",
       "19062       southeast  8a7679380ddbbbe7495aa2d1cafd515b  ...   \n",
       "11559       southeast  e78602addbd8567873e9ad519d11ad9c  ...   \n",
       "13271       southeast  bac5252be9b1269976695ebd118ef43d  ...   \n",
       "24947       southeast  81f2ee7669eee05b13906d24d43ebc69  ...   \n",
       "23106       southeast  38d544a25d70fdf56f6630a9bcf7f82d  ...   \n",
       "73724       southeast  66cd3a1c2edd13d9da86b50aca9e3d32  ...   \n",
       "6623        southeast  65a7c3111cd734466eb706d544e6fae4  ...   \n",
       "6624        southeast  65a7c3111cd734466eb706d544e6fae4  ...   \n",
       "6625        southeast  65a7c3111cd734466eb706d544e6fae4  ...   \n",
       "76929       southeast  fa8d60735eb7db0f4659893592e3fec0  ...   \n",
       "37699       southeast  19c32126a85a7e87c6bcf2aa99e6ae9e  ...   \n",
       "78407       southeast  7c59d327d267a2ce386f84038c0035c5  ...   \n",
       "9819        southeast  812086848825c140a1472472a845a774  ...   \n",
       "13904       southeast  30d6ee4a4d29531562ae9ca6c0635d61  ...   \n",
       "12507       southeast  5a90bdab22ab69f4095415dd55451b66  ...   \n",
       "31423       southeast  564db6e83379512127bc60da803b4a36  ...   \n",
       "18716       southeast  fbd82b1fe98967de0db29b6cf134d00a  ...   \n",
       "31082       southeast  5e70bcf826ffb41fbf68e94ba929635e  ...   \n",
       "23958       southeast  6b3ee7697a02619a0ace2b3f0aa46bde  ...   \n",
       "16817       southeast  10c5eb3ea9a23055a311c44022b574eb  ...   \n",
       "58001       southeast  874b5f0892d39a5537e47c53d0ad4457  ...   \n",
       "24382       southeast  020d1063c6e7cb975472aedbfe0e25ea  ...   \n",
       "10218       southeast  ed8c7b1b3eb256c70ce0c74231e1da88  ...   \n",
       "29857       southeast  961a477711141b3811b897eb49216db1  ...   \n",
       "97521       northeast  5fd0b812a7ad786c02970c4223ef1dff  ...   \n",
       "97522       northeast  5fd0b812a7ad786c02970c4223ef1dff  ...   \n",
       "\n",
       "             product_category_name product_name_lenght  \\\n",
       "32078              casa_construcao                39.0   \n",
       "32811        utilidades_domesticas                42.0   \n",
       "32812        utilidades_domesticas                40.0   \n",
       "46032        utilidades_domesticas                39.0   \n",
       "53369           ferramentas_jardim                60.0   \n",
       "73466                 beleza_saude                55.0   \n",
       "44324             moveis_decoracao                25.0   \n",
       "38928             moveis_decoracao                37.0   \n",
       "18267                    papelaria                39.0   \n",
       "8350                    cool_stuff                54.0   \n",
       "13299                 beleza_saude                28.0   \n",
       "35511  fashion_bolsas_e_acessorios                59.0   \n",
       "6992   fashion_bolsas_e_acessorios                41.0   \n",
       "69149                 beleza_saude                44.0   \n",
       "71903                   brinquedos                40.0   \n",
       "35022            moveis_escritorio                43.0   \n",
       "13205       informatica_acessorios                51.0   \n",
       "13206       informatica_acessorios                51.0   \n",
       "45771             moveis_decoracao                48.0   \n",
       "36035                esporte_lazer                38.0   \n",
       "29168                   automotivo                60.0   \n",
       "19062                    alimentos                57.0   \n",
       "11559              cama_mesa_banho                52.0   \n",
       "13271                        bebes                37.0   \n",
       "24947        utilidades_domesticas                53.0   \n",
       "23106               consoles_games                42.0   \n",
       "73724                          NaN                 NaN   \n",
       "6623               cama_mesa_banho                47.0   \n",
       "6624               cama_mesa_banho                52.0   \n",
       "6625               cama_mesa_banho                53.0   \n",
       "76929                esporte_lazer                42.0   \n",
       "37699              cama_mesa_banho                47.0   \n",
       "78407           ferramentas_jardim                39.0   \n",
       "9819            relogios_presentes                51.0   \n",
       "13904                esporte_lazer                56.0   \n",
       "12507       informatica_acessorios                52.0   \n",
       "31423                          NaN                 NaN   \n",
       "18716                        bebes                32.0   \n",
       "31082                   perfumaria                49.0   \n",
       "23958                 beleza_saude                60.0   \n",
       "16817                    telefonia                31.0   \n",
       "58001                      bebidas                57.0   \n",
       "24382            moveis_escritorio                55.0   \n",
       "10218        utilidades_domesticas                47.0   \n",
       "29857                    papelaria                59.0   \n",
       "97521                    telefonia                51.0   \n",
       "97522                    telefonia                51.0   \n",
       "\n",
       "      product_description_lenght product_photos_qty product_weight_g  \\\n",
       "32078                     1190.0                2.0          30000.0   \n",
       "32811                      200.0                1.0           1100.0   \n",
       "32812                      200.0                1.0           1150.0   \n",
       "46032                      403.0                2.0           2500.0   \n",
       "53369                      196.0                1.0           2400.0   \n",
       "73466                     2987.0                2.0           1450.0   \n",
       "44324                      175.0                2.0           3000.0   \n",
       "38928                      192.0                2.0            600.0   \n",
       "18267                      210.0                2.0           1475.0   \n",
       "8350                       998.0                1.0           2850.0   \n",
       "13299                     1455.0                1.0            683.0   \n",
       "35511                       93.0                7.0            250.0   \n",
       "6992                       187.0                1.0            100.0   \n",
       "69149                     1165.0                1.0            250.0   \n",
       "71903                      180.0                3.0            750.0   \n",
       "35022                     1128.0                1.0          16133.0   \n",
       "13205                      326.0                1.0            817.0   \n",
       "13206                      326.0                1.0            817.0   \n",
       "45771                      409.0                4.0           1450.0   \n",
       "36035                      203.0                1.0           1000.0   \n",
       "29168                     1159.0                3.0           2450.0   \n",
       "19062                     2585.0                7.0           4450.0   \n",
       "11559                      248.0                1.0           2584.0   \n",
       "13271                      497.0                4.0            150.0   \n",
       "24947                     1034.0                2.0          16550.0   \n",
       "23106                     1266.0                4.0            600.0   \n",
       "73724                        NaN                NaN           1200.0   \n",
       "6623                       297.0                1.0           1400.0   \n",
       "6624                       297.0                1.0           1300.0   \n",
       "6625                       297.0                1.0           1500.0   \n",
       "76929                      877.0                1.0           2100.0   \n",
       "37699                      298.0                1.0           1000.0   \n",
       "78407                     1570.0                1.0           1625.0   \n",
       "9819                       404.0                3.0            820.0   \n",
       "13904                     2274.0                1.0           2600.0   \n",
       "12507                      398.0                1.0            350.0   \n",
       "31423                        NaN                NaN            200.0   \n",
       "18716                      572.0                2.0            700.0   \n",
       "31082                      696.0                2.0            254.0   \n",
       "23958                      316.0                3.0            250.0   \n",
       "16817                      890.0                1.0            100.0   \n",
       "58001                      313.0                1.0           2500.0   \n",
       "24382                      955.0                1.0           8267.0   \n",
       "10218                      187.0                1.0           7600.0   \n",
       "29857                      251.0                6.0           1500.0   \n",
       "97521                      422.0                5.0            300.0   \n",
       "97522                      422.0                5.0            300.0   \n",
       "\n",
       "      product_length_cm  product_height_cm  product_width_cm  \\\n",
       "32078              50.0               80.0              50.0   \n",
       "32811              40.0               10.0              35.0   \n",
       "32812              40.0               10.0              35.0   \n",
       "46032              48.0               10.0              35.0   \n",
       "53369              16.0                2.0              11.0   \n",
       "73466              18.0               18.0              16.0   \n",
       "44324              70.0               55.0              70.0   \n",
       "38928              16.0               40.0              30.0   \n",
       "18267              40.0               33.0              24.0   \n",
       "8350               42.0               25.0              15.0   \n",
       "13299              29.0               15.0              22.0   \n",
       "35511              16.0                2.0              11.0   \n",
       "6992               16.0               16.0              16.0   \n",
       "69149              16.0               15.0              11.0   \n",
       "71903              26.0               14.0              26.0   \n",
       "35022              63.0               59.0              25.0   \n",
       "13205              30.0               15.0              15.0   \n",
       "13206              30.0               15.0              15.0   \n",
       "45771              24.0               18.0              18.0   \n",
       "36035              16.0                6.0              12.0   \n",
       "29168              30.0               30.0              30.0   \n",
       "19062              28.0               14.0              28.0   \n",
       "11559              68.0               17.0              49.0   \n",
       "13271              16.0                7.0              11.0   \n",
       "24947              22.0               65.0              40.0   \n",
       "23106              20.0               15.0              20.0   \n",
       "73724              30.0               12.0              12.0   \n",
       "6623               37.0               23.0              35.0   \n",
       "6624               37.0               23.0              35.0   \n",
       "6625               37.0               23.0              35.0   \n",
       "76929              26.0               20.0              22.0   \n",
       "37699              37.0               23.0              35.0   \n",
       "78407              28.0               16.0              25.0   \n",
       "9819               18.0               12.0              16.0   \n",
       "13904              22.0               22.0              22.0   \n",
       "12507              20.0                2.0              26.0   \n",
       "31423              16.0                2.0              11.0   \n",
       "18716              59.0               27.0              11.0   \n",
       "31082              19.0               15.0              18.0   \n",
       "23958              18.0               10.0              15.0   \n",
       "16817              17.0                2.0              11.0   \n",
       "58001              28.0               15.0              15.0   \n",
       "24382              52.0               52.0              17.0   \n",
       "10218              55.0               33.0              40.0   \n",
       "29857              60.0               20.0              29.0   \n",
       "97521              23.0                7.0              15.0   \n",
       "97522              23.0                7.0              15.0   \n",
       "\n",
       "       product_category_name_english  sub_group_rank  \n",
       "32078              home_construction               1  \n",
       "32811                     housewares               2  \n",
       "32812                     housewares               3  \n",
       "46032                     housewares               4  \n",
       "53369                   garden_tools               5  \n",
       "73466                  health_beauty               6  \n",
       "44324                furniture_decor               7  \n",
       "38928                furniture_decor               8  \n",
       "18267                     stationery               9  \n",
       "8350                      cool_stuff              10  \n",
       "13299                  health_beauty              11  \n",
       "35511       fashion_bags_accessories              12  \n",
       "6992        fashion_bags_accessories              13  \n",
       "69149                  health_beauty              14  \n",
       "71903                           toys              15  \n",
       "35022               office_furniture              16  \n",
       "13205          computers_accessories              17  \n",
       "13206          computers_accessories              18  \n",
       "45771                furniture_decor              19  \n",
       "36035                 sports_leisure              20  \n",
       "29168                           auto              21  \n",
       "19062                           food              22  \n",
       "11559                 bed_bath_table              23  \n",
       "13271                           baby              24  \n",
       "24947                     housewares              25  \n",
       "23106                 consoles_games              26  \n",
       "73724                            NaN              27  \n",
       "6623                  bed_bath_table              28  \n",
       "6624                  bed_bath_table              29  \n",
       "6625                  bed_bath_table              30  \n",
       "76929                 sports_leisure              31  \n",
       "37699                 bed_bath_table              32  \n",
       "78407                   garden_tools              33  \n",
       "9819                   watches_gifts              34  \n",
       "13904                 sports_leisure              35  \n",
       "12507          computers_accessories              36  \n",
       "31423                            NaN              37  \n",
       "18716                           baby              38  \n",
       "31082                      perfumery              39  \n",
       "23958                  health_beauty              40  \n",
       "16817                      telephony              41  \n",
       "58001                         drinks              42  \n",
       "24382               office_furniture              43  \n",
       "10218                     housewares              44  \n",
       "29857                     stationery              45  \n",
       "97521                      telephony              46  \n",
       "97522                      telephony              47  \n",
       "\n",
       "[47 rows x 48 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_top_200[df_top_200['distance_group']=='group_1'].sort_values(by='sub_group_rank').head(47)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "87a0cb6d-cfa7-444d-9f82-e4d1241cc60e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "office_furniture                   19\n",
       "bed_bath_table                     18\n",
       "sports_leisure                     17\n",
       "furniture_decor                    15\n",
       "housewares                         14\n",
       "health_beauty                      12\n",
       "telephony                          11\n",
       "perfumery                          10\n",
       "watches_gifts                       9\n",
       "auto                                8\n",
       "baby                                8\n",
       "computers_accessories               8\n",
       "toys                                6\n",
       "consoles_games                      6\n",
       "electronics                         5\n",
       "stationery                          5\n",
       "cool_stuff                          4\n",
       "garden_tools                        2\n",
       "pet_shop                            2\n",
       "construction_tools_construction     2\n",
       "market_place                        2\n",
       "fashion_bags_accessories            2\n",
       "drinks                              1\n",
       "luggage_accessories                 1\n",
       "tablets_printing_image              1\n",
       "furniture_living_room               1\n",
       "air_conditioning                    1\n",
       "fixed_telephony                     1\n",
       "home_appliances                     1\n",
       "home_construction                   1\n",
       "fashion_male_clothing               1\n",
       "food                                1\n",
       "furniture_bedroom                   1\n",
       "musical_instruments                 1\n",
       "Name: product_category_name_english, dtype: int64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_top_200['product_category_name_english'][df_top_200['distance_group']=='group_1'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "05ad673d-0f28-4e34-8d7f-27b5de7afa2b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}