Product_analysis/Product_Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "26e32a04-8c3c-4eb0-a281-72d05ae8cb20",
   "metadata": {},
   "outputs": [],
   "source": [
    "%load_ext sql\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f7123826-8812-4562-b1a1-2a65de53d633",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Connected: postgres@olist'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "host = \"localhost\"\n",
    "database = \"olist\"\n",
    "user = \"postgres\"\n",
    "password = \"sql123\"\n",
    "connection_string = f\"postgresql://{user}:{password}@{host}/{database}\"\n",
    "%sql $connection_string"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "260ee276-559c-4118-89d4-9d604740a2fd",
   "metadata": {},
   "source": [
    "### **Average length of name and description**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "546beae3-292a-47df-ba77-5e43e91f7c41",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * postgresql://postgres:***@localhost/olist\n",
      "73 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <thead>\n",
       "        <tr>\n",
       "            <th>product_category</th>\n",
       "            <th>name_length</th>\n",
       "            <th>desc_length</th>\n",
       "        </tr>\n",
       "    </thead>\n",
       "    <tbody>\n",
       "        <tr>\n",
       "            <td>fashion_roupa_masculina</td>\n",
       "            <td>40</td>\n",
       "            <td>627</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_roupa_feminina</td>\n",
       "            <td>40</td>\n",
       "            <td>639</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>livros_interesse_geral</td>\n",
       "            <td>40</td>\n",
       "            <td>989</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>livros_tecnicos</td>\n",
       "            <td>42</td>\n",
       "            <td>1352</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_colchao_e_estofado</td>\n",
       "            <td>43</td>\n",
       "            <td>1111</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artigos_de_natal</td>\n",
       "            <td>44</td>\n",
       "            <td>412</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artes_e_artesanato</td>\n",
       "            <td>44</td>\n",
       "            <td>620</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_sala</td>\n",
       "            <td>44</td>\n",
       "            <td>625</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>market_place</td>\n",
       "            <td>44</td>\n",
       "            <td>829</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>consoles_games</td>\n",
       "            <td>44</td>\n",
       "            <td>850</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>bebidas</td>\n",
       "            <td>44</td>\n",
       "            <td>1048</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_roupa_infanto_juvenil</td>\n",
       "            <td>45</td>\n",
       "            <td>351</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_bolsas_e_acessorios</td>\n",
       "            <td>45</td>\n",
       "            <td>513</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>brinquedos</td>\n",
       "            <td>45</td>\n",
       "            <td>686</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>perfumaria</td>\n",
       "            <td>45</td>\n",
       "            <td>694</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>alimentos_bebidas</td>\n",
       "            <td>45</td>\n",
       "            <td>983</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fraldas_higiene</td>\n",
       "            <td>46</td>\n",
       "            <td>488</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_esporte</td>\n",
       "            <td>46</td>\n",
       "            <td>556</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_quarto</td>\n",
       "            <td>46</td>\n",
       "            <td>740</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>bebes</td>\n",
       "            <td>46</td>\n",
       "            <td>824</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>dvds_blu_ray</td>\n",
       "            <td>46</td>\n",
       "            <td>1071</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>alimentos</td>\n",
       "            <td>46</td>\n",
       "            <td>1137</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_escritorio</td>\n",
       "            <td>46</td>\n",
       "            <td>1353</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cds_dvds_musicais</td>\n",
       "            <td>47</td>\n",
       "            <td>117</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>livros_importados</td>\n",
       "            <td>47</td>\n",
       "            <td>581</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>malas_acessorios</td>\n",
       "            <td>47</td>\n",
       "            <td>633</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artes</td>\n",
       "            <td>47</td>\n",
       "            <td>678</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletronicos</td>\n",
       "            <td>47</td>\n",
       "            <td>709</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_cozinha_area_de_servico_jantar_e_jardim</td>\n",
       "            <td>47</td>\n",
       "            <td>726</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>audio</td>\n",
       "            <td>47</td>\n",
       "            <td>782</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>esporte_lazer</td>\n",
       "            <td>47</td>\n",
       "            <td>954</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>musica</td>\n",
       "            <td>47</td>\n",
       "            <td>1060</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>beleza_saude</td>\n",
       "            <td>47</td>\n",
       "            <td>1137</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>utilidades_domesticas</td>\n",
       "            <td>48</td>\n",
       "            <td>674</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>informatica_acessorios</td>\n",
       "            <td>48</td>\n",
       "            <td>774</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletrodomesticos_2</td>\n",
       "            <td>48</td>\n",
       "            <td>798</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>sinalizacao_e_seguranca</td>\n",
       "            <td>48</td>\n",
       "            <td>817</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cool_stuff</td>\n",
       "            <td>48</td>\n",
       "            <td>876</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>telefonia_fixa</td>\n",
       "            <td>48</td>\n",
       "            <td>1017</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_jardim</td>\n",
       "            <td>48</td>\n",
       "            <td>1135</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artigos_de_festas</td>\n",
       "            <td>49</td>\n",
       "            <td>446</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_ferramentas</td>\n",
       "            <td>49</td>\n",
       "            <td>708</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>agro_industria_e_comercio</td>\n",
       "            <td>49</td>\n",
       "            <td>808</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>ferramentas_jardim</td>\n",
       "            <td>49</td>\n",
       "            <td>815</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>pet_shop</td>\n",
       "            <td>49</td>\n",
       "            <td>866</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletroportateis</td>\n",
       "            <td>49</td>\n",
       "            <td>934</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>papelaria</td>\n",
       "            <td>50</td>\n",
       "            <td>439</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_calcados</td>\n",
       "            <td>50</td>\n",
       "            <td>458</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>relogios_presentes</td>\n",
       "            <td>50</td>\n",
       "            <td>612</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>telefonia</td>\n",
       "            <td>50</td>\n",
       "            <td>755</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>instrumentos_musicais</td>\n",
       "            <td>50</td>\n",
       "            <td>795</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_decoracao</td>\n",
       "            <td>50</td>\n",
       "            <td>799</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_construcao</td>\n",
       "            <td>51</td>\n",
       "            <td>789</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>casa_construcao</td>\n",
       "            <td>51</td>\n",
       "            <td>855</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cine_foto</td>\n",
       "            <td>51</td>\n",
       "            <td>939</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>casa_conforto_2</td>\n",
       "            <td>52</td>\n",
       "            <td>394</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>la_cuisine</td>\n",
       "            <td>52</td>\n",
       "            <td>422</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cama_mesa_banho</td>\n",
       "            <td>52</td>\n",
       "            <td>464</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>flores</td>\n",
       "            <td>52</td>\n",
       "            <td>468</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>seguros_e_servicos</td>\n",
       "            <td>52</td>\n",
       "            <td>484</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_iluminacao</td>\n",
       "            <td>52</td>\n",
       "            <td>788</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>automotivo</td>\n",
       "            <td>52</td>\n",
       "            <td>814</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>climatizacao</td>\n",
       "            <td>52</td>\n",
       "            <td>903</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_underwear_e_moda_praia</td>\n",
       "            <td>52</td>\n",
       "            <td>1004</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_seguranca</td>\n",
       "            <td>52</td>\n",
       "            <td>1106</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>casa_conforto</td>\n",
       "            <td>53</td>\n",
       "            <td>320</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>portateis_casa_forno_e_cafe</td>\n",
       "            <td>53</td>\n",
       "            <td>1046</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>industria_comercio_e_negocios</td>\n",
       "            <td>53</td>\n",
       "            <td>1103</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletrodomesticos</td>\n",
       "            <td>54</td>\n",
       "            <td>405</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>portateis_cozinha_e_preparadores_de_alimentos</td>\n",
       "            <td>54</td>\n",
       "            <td>623</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>tablets_impressao_imagem</td>\n",
       "            <td>54</td>\n",
       "            <td>676</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>pcs</td>\n",
       "            <td>56</td>\n",
       "            <td>2129</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>pc_gamer</td>\n",
       "            <td>60</td>\n",
       "            <td>998</td>\n",
       "        </tr>\n",
       "    </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "[('fashion_roupa_masculina', 40, 627),\n",
       " ('fashion_roupa_feminina', 40, 639),\n",
       " ('livros_interesse_geral', 40, 989),\n",
       " ('livros_tecnicos', 42, 1352),\n",
       " ('moveis_colchao_e_estofado', 43, 1111),\n",
       " ('artigos_de_natal', 44, 412),\n",
       " ('artes_e_artesanato', 44, 620),\n",
       " ('moveis_sala', 44, 625),\n",
       " ('market_place', 44, 829),\n",
       " ('consoles_games', 44, 850),\n",
       " ('bebidas', 44, 1048),\n",
       " ('fashion_roupa_infanto_juvenil', 45, 351),\n",
       " ('fashion_bolsas_e_acessorios', 45, 513),\n",
       " ('brinquedos', 45, 686),\n",
       " ('perfumaria', 45, 694),\n",
       " ('alimentos_bebidas', 45, 983),\n",
       " ('fraldas_higiene', 46, 488),\n",
       " ('fashion_esporte', 46, 556),\n",
       " ('moveis_quarto', 46, 740),\n",
       " ('bebes', 46, 824),\n",
       " ('dvds_blu_ray', 46, 1071),\n",
       " ('alimentos', 46, 1137),\n",
       " ('moveis_escritorio', 46, 1353),\n",
       " ('cds_dvds_musicais', 47, 117),\n",
       " ('livros_importados', 47, 581),\n",
       " ('malas_acessorios', 47, 633),\n",
       " ('artes', 47, 678),\n",
       " ('eletronicos', 47, 709),\n",
       " ('moveis_cozinha_area_de_servico_jantar_e_jardim', 47, 726),\n",
       " ('audio', 47, 782),\n",
       " ('esporte_lazer', 47, 954),\n",
       " ('musica', 47, 1060),\n",
       " ('beleza_saude', 47, 1137),\n",
       " ('utilidades_domesticas', 48, 674),\n",
       " ('informatica_acessorios', 48, 774),\n",
       " ('eletrodomesticos_2', 48, 798),\n",
       " ('sinalizacao_e_seguranca', 48, 817),\n",
       " ('cool_stuff', 48, 876),\n",
       " ('telefonia_fixa', 48, 1017),\n",
       " ('construcao_ferramentas_jardim', 48, 1135),\n",
       " ('artigos_de_festas', 49, 446),\n",
       " ('construcao_ferramentas_ferramentas', 49, 708),\n",
       " ('agro_industria_e_comercio', 49, 808),\n",
       " ('ferramentas_jardim', 49, 815),\n",
       " ('pet_shop', 49, 866),\n",
       " ('eletroportateis', 49, 934),\n",
       " ('papelaria', 50, 439),\n",
       " ('fashion_calcados', 50, 458),\n",
       " ('relogios_presentes', 50, 612),\n",
       " ('telefonia', 50, 755),\n",
       " ('instrumentos_musicais', 50, 795),\n",
       " ('moveis_decoracao', 50, 799),\n",
       " ('construcao_ferramentas_construcao', 51, 789),\n",
       " ('casa_construcao', 51, 855),\n",
       " ('cine_foto', 51, 939),\n",
       " ('casa_conforto_2', 52, 394),\n",
       " ('la_cuisine', 52, 422),\n",
       " ('cama_mesa_banho', 52, 464),\n",
       " ('flores', 52, 468),\n",
       " ('seguros_e_servicos', 52, 484),\n",
       " ('construcao_ferramentas_iluminacao', 52, 788),\n",
       " ('automotivo', 52, 814),\n",
       " ('climatizacao', 52, 903),\n",
       " ('fashion_underwear_e_moda_praia', 52, 1004),\n",
       " ('construcao_ferramentas_seguranca', 52, 1106),\n",
       " ('casa_conforto', 53, 320),\n",
       " ('portateis_casa_forno_e_cafe', 53, 1046),\n",
       " ('industria_comercio_e_negocios', 53, 1103),\n",
       " ('eletrodomesticos', 54, 405),\n",
       " ('portateis_cozinha_e_preparadores_de_alimentos', 54, 623),\n",
       " ('tablets_impressao_imagem', 54, 676),\n",
       " ('pcs', 56, 2129),\n",
       " ('pc_gamer', 60, 998)]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT product_category,\n",
    "       AVG(product_name_length)::int AS name_length,\n",
    "       AVG(product_desc_length)::int AS desc_length\n",
    "FROM products\n",
    "WHERE product_category IS NOT NULL\n",
    "GROUP BY product_category\n",
    "ORDER BY name_length, desc_length;"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "65b761e1-24eb-42e3-9577-c00d26c2abed",
   "metadata": {},
   "source": [
    "### **Average weight, length, height, width for a product category**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "30b89db7-2311-4235-926b-249ef6a07cb9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * postgresql://postgres:***@localhost/olist\n",
      "73 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <thead>\n",
       "        <tr>\n",
       "            <th>product_category</th>\n",
       "            <th>avg_weight</th>\n",
       "            <th>avg_length</th>\n",
       "            <th>avg_height</th>\n",
       "            <th>avg_width</th>\n",
       "        </tr>\n",
       "    </thead>\n",
       "    <tbody>\n",
       "        <tr>\n",
       "            <td>climatizacao</td>\n",
       "            <td>4.4599595</td>\n",
       "            <td>36.467743</td>\n",
       "            <td>23.887096</td>\n",
       "            <td>26.088709</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>livros_importados</td>\n",
       "            <td>0.5967742</td>\n",
       "            <td>29.741936</td>\n",
       "            <td>3.451613</td>\n",
       "            <td>21.225807</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artigos_de_natal</td>\n",
       "            <td>1.8498154</td>\n",
       "            <td>28.23077</td>\n",
       "            <td>16.215385</td>\n",
       "            <td>22.830769</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>livros_tecnicos</td>\n",
       "            <td>1.1078455</td>\n",
       "            <td>27.325203</td>\n",
       "            <td>5.869919</td>\n",
       "            <td>18.463415</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>ferramentas_jardim</td>\n",
       "            <td>3.103777</td>\n",
       "            <td>30.936255</td>\n",
       "            <td>19.204515</td>\n",
       "            <td>23.504648</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cine_foto</td>\n",
       "            <td>0.7957857</td>\n",
       "            <td>27.642857</td>\n",
       "            <td>11.571428</td>\n",
       "            <td>18.178572</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>dvds_blu_ray</td>\n",
       "            <td>0.3815625</td>\n",
       "            <td>21.270834</td>\n",
       "            <td>4.4166665</td>\n",
       "            <td>14.875</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_roupa_feminina</td>\n",
       "            <td>0.57222223</td>\n",
       "            <td>23.296297</td>\n",
       "            <td>11.481482</td>\n",
       "            <td>18.333334</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>beleza_saude</td>\n",
       "            <td>1.4347938</td>\n",
       "            <td>23.800737</td>\n",
       "            <td>15.712357</td>\n",
       "            <td>17.997545</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>livros_interesse_geral</td>\n",
       "            <td>0.7466111</td>\n",
       "            <td>23.481482</td>\n",
       "            <td>9.773149</td>\n",
       "            <td>19.328703</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>tablets_impressao_imagem</td>\n",
       "            <td>0.38144445</td>\n",
       "            <td>28.11111</td>\n",
       "            <td>9.444445</td>\n",
       "            <td>21.555555</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>papelaria</td>\n",
       "            <td>1.763113</td>\n",
       "            <td>29.062426</td>\n",
       "            <td>19.586573</td>\n",
       "            <td>23.34629</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>bebes</td>\n",
       "            <td>3.6552014</td>\n",
       "            <td>37.14706</td>\n",
       "            <td>21.617647</td>\n",
       "            <td>28.717865</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>musica</td>\n",
       "            <td>1.2135185</td>\n",
       "            <td>27.148148</td>\n",
       "            <td>9.925926</td>\n",
       "            <td>18.222221</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>consoles_games</td>\n",
       "            <td>0.6366593</td>\n",
       "            <td>21.791798</td>\n",
       "            <td>12.640379</td>\n",
       "            <td>18.473186</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletrodomesticos</td>\n",
       "            <td>1.9796541</td>\n",
       "            <td>29.805405</td>\n",
       "            <td>14.8918915</td>\n",
       "            <td>21.859459</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cama_mesa_banho</td>\n",
       "            <td>2.4564052</td>\n",
       "            <td>36.77418</td>\n",
       "            <td>14.091119</td>\n",
       "            <td>30.589964</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>la_cuisine</td>\n",
       "            <td>4.35</td>\n",
       "            <td>67.3</td>\n",
       "            <td>13.8</td>\n",
       "            <td>34.8</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>seguros_e_servicos</td>\n",
       "            <td>0.8125</td>\n",
       "            <td>26.5</td>\n",
       "            <td>28.5</td>\n",
       "            <td>13.0</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artes_e_artesanato</td>\n",
       "            <td>1.1645789</td>\n",
       "            <td>28.368422</td>\n",
       "            <td>9.789474</td>\n",
       "            <td>21.052631</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_iluminacao</td>\n",
       "            <td>2.2809615</td>\n",
       "            <td>27.846153</td>\n",
       "            <td>20.423077</td>\n",
       "            <td>25.73077</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletroportateis</td>\n",
       "            <td>4.0123982</td>\n",
       "            <td>29.47186</td>\n",
       "            <td>27.038961</td>\n",
       "            <td>27.30736</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>malas_acessorios</td>\n",
       "            <td>3.7232838</td>\n",
       "            <td>35.74212</td>\n",
       "            <td>29.584528</td>\n",
       "            <td>30.707737</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>flores</td>\n",
       "            <td>1.4035715</td>\n",
       "            <td>21.714285</td>\n",
       "            <td>15.571428</td>\n",
       "            <td>16.714285</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artigos_de_festas</td>\n",
       "            <td>2.7057693</td>\n",
       "            <td>32.307693</td>\n",
       "            <td>16.5</td>\n",
       "            <td>22.73077</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>sinalizacao_e_seguranca</td>\n",
       "            <td>2.9698172</td>\n",
       "            <td>30.505377</td>\n",
       "            <td>23.892473</td>\n",
       "            <td>20.817204</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>alimentos</td>\n",
       "            <td>0.92341465</td>\n",
       "            <td>21.292683</td>\n",
       "            <td>14.682927</td>\n",
       "            <td>17.719513</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>casa_construcao</td>\n",
       "            <td>3.3957155</td>\n",
       "            <td>29.328888</td>\n",
       "            <td>24.377777</td>\n",
       "            <td>23.457777</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>telefonia</td>\n",
       "            <td>0.23650618</td>\n",
       "            <td>18.432981</td>\n",
       "            <td>6.8536153</td>\n",
       "            <td>13.248677</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>esporte_lazer</td>\n",
       "            <td>2.0246708</td>\n",
       "            <td>31.280085</td>\n",
       "            <td>18.10987</td>\n",
       "            <td>20.824207</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_quarto</td>\n",
       "            <td>9.997222</td>\n",
       "            <td>59.933334</td>\n",
       "            <td>30.8</td>\n",
       "            <td>34.4</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_sala</td>\n",
       "            <td>8.934846</td>\n",
       "            <td>50.73077</td>\n",
       "            <td>22.365385</td>\n",
       "            <td>44.429485</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_colchao_e_estofado</td>\n",
       "            <td>13.19</td>\n",
       "            <td>46.3</td>\n",
       "            <td>34.4</td>\n",
       "            <td>41.3</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_construcao</td>\n",
       "            <td>3.5500524</td>\n",
       "            <td>29.795</td>\n",
       "            <td>15.895</td>\n",
       "            <td>24.2425</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_underwear_e_moda_praia</td>\n",
       "            <td>0.36226416</td>\n",
       "            <td>25.509434</td>\n",
       "            <td>8.849056</td>\n",
       "            <td>18.90566</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_decoracao</td>\n",
       "            <td>3.008267</td>\n",
       "            <td>43.894993</td>\n",
       "            <td>17.438087</td>\n",
       "            <td>28.663155</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>portateis_cozinha_e_preparadores_de_alimentos</td>\n",
       "            <td>2.5175</td>\n",
       "            <td>28.5</td>\n",
       "            <td>25.3</td>\n",
       "            <td>24.6</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_esporte</td>\n",
       "            <td>0.34473684</td>\n",
       "            <td>22.105263</td>\n",
       "            <td>12.842105</td>\n",
       "            <td>16.263159</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>alimentos_bebidas</td>\n",
       "            <td>1.3079327</td>\n",
       "            <td>23.403847</td>\n",
       "            <td>15.951923</td>\n",
       "            <td>18.39423</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_cozinha_area_de_servico_jantar_e_jardim</td>\n",
       "            <td>11.598564</td>\n",
       "            <td>47.340427</td>\n",
       "            <td>40.47872</td>\n",
       "            <td>38.68085</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>pc_gamer</td>\n",
       "            <td>1.4296666</td>\n",
       "            <td>17.666666</td>\n",
       "            <td>20.0</td>\n",
       "            <td>20.0</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>bebidas</td>\n",
       "            <td>1.7361728</td>\n",
       "            <td>23.91358</td>\n",
       "            <td>22.37037</td>\n",
       "            <td>19.395061</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>market_place</td>\n",
       "            <td>1.5441058</td>\n",
       "            <td>26.759615</td>\n",
       "            <td>17.625</td>\n",
       "            <td>22.490385</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_roupa_masculina</td>\n",
       "            <td>0.55973685</td>\n",
       "            <td>27.326315</td>\n",
       "            <td>14.021052</td>\n",
       "            <td>22.11579</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_calcados</td>\n",
       "            <td>1.0445087</td>\n",
       "            <td>26.028902</td>\n",
       "            <td>13.381503</td>\n",
       "            <td>24.947977</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>casa_conforto_2</td>\n",
       "            <td>1.4676</td>\n",
       "            <td>53.2</td>\n",
       "            <td>15.2</td>\n",
       "            <td>26.2</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletronicos</td>\n",
       "            <td>1.2750851</td>\n",
       "            <td>25.237911</td>\n",
       "            <td>11.736944</td>\n",
       "            <td>18.468084</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>audio</td>\n",
       "            <td>0.6416379</td>\n",
       "            <td>20.827587</td>\n",
       "            <td>11.5</td>\n",
       "            <td>17.344828</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_jardim</td>\n",
       "            <td>2.401034</td>\n",
       "            <td>28.693182</td>\n",
       "            <td>16.65909</td>\n",
       "            <td>20.511364</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artes</td>\n",
       "            <td>1.6917636</td>\n",
       "            <td>35.927273</td>\n",
       "            <td>11.8</td>\n",
       "            <td>23.363636</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>automotivo</td>\n",
       "            <td>2.6546504</td>\n",
       "            <td>34.05</td>\n",
       "            <td>16.24158</td>\n",
       "            <td>23.382105</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cool_stuff</td>\n",
       "            <td>2.566579</td>\n",
       "            <td>33.752853</td>\n",
       "            <td>22.988594</td>\n",
       "            <td>24.491762</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>industria_comercio_e_negocios</td>\n",
       "            <td>5.929191</td>\n",
       "            <td>39.058823</td>\n",
       "            <td>32.514706</td>\n",
       "            <td>29.220589</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>pcs</td>\n",
       "            <td>7.995333</td>\n",
       "            <td>32.133335</td>\n",
       "            <td>34.333332</td>\n",
       "            <td>40.1</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>agro_industria_e_comercio</td>\n",
       "            <td>5.2634053</td>\n",
       "            <td>36.527027</td>\n",
       "            <td>28.945946</td>\n",
       "            <td>25.81081</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>casa_conforto</td>\n",
       "            <td>3.8004506</td>\n",
       "            <td>39.198196</td>\n",
       "            <td>20.045046</td>\n",
       "            <td>33.414413</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>pet_shop</td>\n",
       "            <td>3.0888567</td>\n",
       "            <td>32.98053</td>\n",
       "            <td>20.126564</td>\n",
       "            <td>26.749653</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_escritorio</td>\n",
       "            <td>12.740868</td>\n",
       "            <td>55.62783</td>\n",
       "            <td>41.86408</td>\n",
       "            <td>37.919094</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_roupa_infanto_juvenil</td>\n",
       "            <td>0.324</td>\n",
       "            <td>27.4</td>\n",
       "            <td>13.4</td>\n",
       "            <td>20.6</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>informatica_acessorios</td>\n",
       "            <td>0.89837766</td>\n",
       "            <td>25.039658</td>\n",
       "            <td>12.461257</td>\n",
       "            <td>18.14338</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>portateis_casa_forno_e_cafe</td>\n",
       "            <td>3.071516</td>\n",
       "            <td>31.32258</td>\n",
       "            <td>22.838709</td>\n",
       "            <td>23.870968</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>telefonia_fixa</td>\n",
       "            <td>0.6608276</td>\n",
       "            <td>20.646551</td>\n",
       "            <td>10.74138</td>\n",
       "            <td>16.5</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>utilidades_domesticas</td>\n",
       "            <td>3.0207937</td>\n",
       "            <td>31.859957</td>\n",
       "            <td>22.337902</td>\n",
       "            <td>24.821413</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>instrumentos_musicais</td>\n",
       "            <td>3.361038</td>\n",
       "            <td>36.276817</td>\n",
       "            <td>16.854671</td>\n",
       "            <td>29.84429</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>relogios_presentes</td>\n",
       "            <td>0.5092874</td>\n",
       "            <td>19.222723</td>\n",
       "            <td>10.292702</td>\n",
       "            <td>15.268623</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_ferramentas</td>\n",
       "            <td>1.0478206</td>\n",
       "            <td>23.461538</td>\n",
       "            <td>15.666667</td>\n",
       "            <td>17.23077</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>brinquedos</td>\n",
       "            <td>1.8693565</td>\n",
       "            <td>31.754784</td>\n",
       "            <td>20.72289</td>\n",
       "            <td>24.926294</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>perfumaria</td>\n",
       "            <td>0.52925694</td>\n",
       "            <td>20.32258</td>\n",
       "            <td>13.059908</td>\n",
       "            <td>16.668203</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletrodomesticos_2</td>\n",
       "            <td>9.913333</td>\n",
       "            <td>45.733334</td>\n",
       "            <td>30.666666</td>\n",
       "            <td>38.166668</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cds_dvds_musicais</td>\n",
       "            <td>0.55</td>\n",
       "            <td>35.0</td>\n",
       "            <td>15.0</td>\n",
       "            <td>25.0</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_bolsas_e_acessorios</td>\n",
       "            <td>0.42676443</td>\n",
       "            <td>19.18139</td>\n",
       "            <td>8.998822</td>\n",
       "            <td>15.572438</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_seguranca</td>\n",
       "            <td>0.95076925</td>\n",
       "            <td>23.065933</td>\n",
       "            <td>15.0</td>\n",
       "            <td>18.989012</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fraldas_higiene</td>\n",
       "            <td>1.0375</td>\n",
       "            <td>25.0</td>\n",
       "            <td>17.583334</td>\n",
       "            <td>19.25</td>\n",
       "        </tr>\n",
       "    </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "[('climatizacao', 4.4599595, 36.467743, 23.887096, 26.088709),\n",
       " ('livros_importados', 0.5967742, 29.741936, 3.451613, 21.225807),\n",
       " ('artigos_de_natal', 1.8498154, 28.23077, 16.215385, 22.830769),\n",
       " ('livros_tecnicos', 1.1078455, 27.325203, 5.869919, 18.463415),\n",
       " ('ferramentas_jardim', 3.103777, 30.936255, 19.204515, 23.504648),\n",
       " ('cine_foto', 0.7957857, 27.642857, 11.571428, 18.178572),\n",
       " ('dvds_blu_ray', 0.3815625, 21.270834, 4.4166665, 14.875),\n",
       " ('fashion_roupa_feminina', 0.57222223, 23.296297, 11.481482, 18.333334),\n",
       " ('beleza_saude', 1.4347938, 23.800737, 15.712357, 17.997545),\n",
       " ('livros_interesse_geral', 0.7466111, 23.481482, 9.773149, 19.328703),\n",
       " ('tablets_impressao_imagem', 0.38144445, 28.11111, 9.444445, 21.555555),\n",
       " ('papelaria', 1.763113, 29.062426, 19.586573, 23.34629),\n",
       " ('bebes', 3.6552014, 37.14706, 21.617647, 28.717865),\n",
       " ('musica', 1.2135185, 27.148148, 9.925926, 18.222221),\n",
       " ('consoles_games', 0.6366593, 21.791798, 12.640379, 18.473186),\n",
       " ('eletrodomesticos', 1.9796541, 29.805405, 14.8918915, 21.859459),\n",
       " ('cama_mesa_banho', 2.4564052, 36.77418, 14.091119, 30.589964),\n",
       " ('la_cuisine', 4.35, 67.3, 13.8, 34.8),\n",
       " ('seguros_e_servicos', 0.8125, 26.5, 28.5, 13.0),\n",
       " ('artes_e_artesanato', 1.1645789, 28.368422, 9.789474, 21.052631),\n",
       " ('construcao_ferramentas_iluminacao', 2.2809615, 27.846153, 20.423077, 25.73077),\n",
       " ('eletroportateis', 4.0123982, 29.47186, 27.038961, 27.30736),\n",
       " ('malas_acessorios', 3.7232838, 35.74212, 29.584528, 30.707737),\n",
       " ('flores', 1.4035715, 21.714285, 15.571428, 16.714285),\n",
       " ('artigos_de_festas', 2.7057693, 32.307693, 16.5, 22.73077),\n",
       " ('sinalizacao_e_seguranca', 2.9698172, 30.505377, 23.892473, 20.817204),\n",
       " ('alimentos', 0.92341465, 21.292683, 14.682927, 17.719513),\n",
       " ('casa_construcao', 3.3957155, 29.328888, 24.377777, 23.457777),\n",
       " ('telefonia', 0.23650618, 18.432981, 6.8536153, 13.248677),\n",
       " ('esporte_lazer', 2.0246708, 31.280085, 18.10987, 20.824207),\n",
       " ('moveis_quarto', 9.997222, 59.933334, 30.8, 34.4),\n",
       " ('moveis_sala', 8.934846, 50.73077, 22.365385, 44.429485),\n",
       " ('moveis_colchao_e_estofado', 13.19, 46.3, 34.4, 41.3),\n",
       " ('construcao_ferramentas_construcao', 3.5500524, 29.795, 15.895, 24.2425),\n",
       " ('fashion_underwear_e_moda_praia', 0.36226416, 25.509434, 8.849056, 18.90566),\n",
       " ('moveis_decoracao', 3.008267, 43.894993, 17.438087, 28.663155),\n",
       " ('portateis_cozinha_e_preparadores_de_alimentos', 2.5175, 28.5, 25.3, 24.6),\n",
       " ('fashion_esporte', 0.34473684, 22.105263, 12.842105, 16.263159),\n",
       " ('alimentos_bebidas', 1.3079327, 23.403847, 15.951923, 18.39423),\n",
       " ('moveis_cozinha_area_de_servico_jantar_e_jardim', 11.598564, 47.340427, 40.47872, 38.68085),\n",
       " ('pc_gamer', 1.4296666, 17.666666, 20.0, 20.0),\n",
       " ('bebidas', 1.7361728, 23.91358, 22.37037, 19.395061),\n",
       " ('market_place', 1.5441058, 26.759615, 17.625, 22.490385),\n",
       " ('fashion_roupa_masculina', 0.55973685, 27.326315, 14.021052, 22.11579),\n",
       " ('fashion_calcados', 1.0445087, 26.028902, 13.381503, 24.947977),\n",
       " ('casa_conforto_2', 1.4676, 53.2, 15.2, 26.2),\n",
       " ('eletronicos', 1.2750851, 25.237911, 11.736944, 18.468084),\n",
       " ('audio', 0.6416379, 20.827587, 11.5, 17.344828),\n",
       " ('construcao_ferramentas_jardim', 2.401034, 28.693182, 16.65909, 20.511364),\n",
       " ('artes', 1.6917636, 35.927273, 11.8, 23.363636),\n",
       " ('automotivo', 2.6546504, 34.05, 16.24158, 23.382105),\n",
       " ('cool_stuff', 2.566579, 33.752853, 22.988594, 24.491762),\n",
       " ('industria_comercio_e_negocios', 5.929191, 39.058823, 32.514706, 29.220589),\n",
       " ('pcs', 7.995333, 32.133335, 34.333332, 40.1),\n",
       " ('agro_industria_e_comercio', 5.2634053, 36.527027, 28.945946, 25.81081),\n",
       " ('casa_conforto', 3.8004506, 39.198196, 20.045046, 33.414413),\n",
       " ('pet_shop', 3.0888567, 32.98053, 20.126564, 26.749653),\n",
       " ('moveis_escritorio', 12.740868, 55.62783, 41.86408, 37.919094),\n",
       " ('fashion_roupa_infanto_juvenil', 0.324, 27.4, 13.4, 20.6),\n",
       " ('informatica_acessorios', 0.89837766, 25.039658, 12.461257, 18.14338),\n",
       " ('portateis_casa_forno_e_cafe', 3.071516, 31.32258, 22.838709, 23.870968),\n",
       " ('telefonia_fixa', 0.6608276, 20.646551, 10.74138, 16.5),\n",
       " ('utilidades_domesticas', 3.0207937, 31.859957, 22.337902, 24.821413),\n",
       " ('instrumentos_musicais', 3.361038, 36.276817, 16.854671, 29.84429),\n",
       " ('relogios_presentes', 0.5092874, 19.222723, 10.292702, 15.268623),\n",
       " ('construcao_ferramentas_ferramentas', 1.0478206, 23.461538, 15.666667, 17.23077),\n",
       " ('brinquedos', 1.8693565, 31.754784, 20.72289, 24.926294),\n",
       " ('perfumaria', 0.52925694, 20.32258, 13.059908, 16.668203),\n",
       " ('eletrodomesticos_2', 9.913333, 45.733334, 30.666666, 38.166668),\n",
       " ('cds_dvds_musicais', 0.55, 35.0, 15.0, 25.0),\n",
       " ('fashion_bolsas_e_acessorios', 0.42676443, 19.18139, 8.998822, 15.572438),\n",
       " ('construcao_ferramentas_seguranca', 0.95076925, 23.065933, 15.0, 18.989012),\n",
       " ('fraldas_higiene', 1.0375, 25.0, 17.583334, 19.25)]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT product_category,\n",
    "       (AVG(product_weight_grams)/1000)::real AS avg_weight,\n",
    "        AVG(product_length_cm)::real AS avg_length,\n",
    "        AVG(product_height_cm)::real AS avg_height,\n",
    "        AVG(product_width_cm)::real AS avg_width\n",
    "FROM products \n",
    "WHERE product_category IS NOT NULL\n",
    "GROUP BY product_category"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5b535d21-689e-456a-9643-3375e0a2fe8c",
   "metadata": {
    "tags": []
   },
   "source": [
    "### **Average Volume of Box for each Product Category**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "9aaff322-7b26-43f3-864a-11c907ed43d6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * postgresql://postgres:***@localhost/olist\n",
      "73 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <thead>\n",
       "        <tr>\n",
       "            <th>product_category</th>\n",
       "            <th>avg_volume</th>\n",
       "            <th>rank</th>\n",
       "        </tr>\n",
       "    </thead>\n",
       "    <tbody>\n",
       "        <tr>\n",
       "            <td>moveis_colchao_e_estofado</td>\n",
       "            <td>77244.3</td>\n",
       "            <td>1</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_escritorio</td>\n",
       "            <td>75468.47</td>\n",
       "            <td>2</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_cozinha_area_de_servico_jantar_e_jardim</td>\n",
       "            <td>69406.09</td>\n",
       "            <td>3</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletrodomesticos_2</td>\n",
       "            <td>55476.312</td>\n",
       "            <td>4</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_sala</td>\n",
       "            <td>54486.13</td>\n",
       "            <td>5</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_quarto</td>\n",
       "            <td>51038.844</td>\n",
       "            <td>6</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>pcs</td>\n",
       "            <td>44635.168</td>\n",
       "            <td>7</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>agro_industria_e_comercio</td>\n",
       "            <td>37604.23</td>\n",
       "            <td>8</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>industria_comercio_e_negocios</td>\n",
       "            <td>37372.31</td>\n",
       "            <td>9</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>malas_acessorios</td>\n",
       "            <td>32950.336</td>\n",
       "            <td>10</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>bebes</td>\n",
       "            <td>30835.576</td>\n",
       "            <td>11</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>la_cuisine</td>\n",
       "            <td>30483.4</td>\n",
       "            <td>12</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>casa_conforto</td>\n",
       "            <td>28148.73</td>\n",
       "            <td>13</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>climatizacao</td>\n",
       "            <td>27910.533</td>\n",
       "            <td>14</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletroportateis</td>\n",
       "            <td>26913.238</td>\n",
       "            <td>15</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>instrumentos_musicais</td>\n",
       "            <td>25089.021</td>\n",
       "            <td>16</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>portateis_casa_forno_e_cafe</td>\n",
       "            <td>23911.613</td>\n",
       "            <td>17</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cool_stuff</td>\n",
       "            <td>23246.484</td>\n",
       "            <td>18</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>pet_shop</td>\n",
       "            <td>22965.066</td>\n",
       "            <td>19</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>sinalizacao_e_seguranca</td>\n",
       "            <td>22583.795</td>\n",
       "            <td>20</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>moveis_decoracao</td>\n",
       "            <td>22481.225</td>\n",
       "            <td>21</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>utilidades_domesticas</td>\n",
       "            <td>21904.168</td>\n",
       "            <td>22</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>casa_conforto_2</td>\n",
       "            <td>20938.0</td>\n",
       "            <td>23</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>casa_construcao</td>\n",
       "            <td>20800.236</td>\n",
       "            <td>24</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>brinquedos</td>\n",
       "            <td>19625.812</td>\n",
       "            <td>25</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_iluminacao</td>\n",
       "            <td>18897.256</td>\n",
       "            <td>26</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>portateis_cozinha_e_preparadores_de_alimentos</td>\n",
       "            <td>18872.7</td>\n",
       "            <td>27</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>ferramentas_jardim</td>\n",
       "            <td>18615.406</td>\n",
       "            <td>28</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cama_mesa_banho</td>\n",
       "            <td>18594.576</td>\n",
       "            <td>29</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artigos_de_festas</td>\n",
       "            <td>16942.73</td>\n",
       "            <td>30</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>automotivo</td>\n",
       "            <td>16603.586</td>\n",
       "            <td>31</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>papelaria</td>\n",
       "            <td>16240.033</td>\n",
       "            <td>32</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_construcao</td>\n",
       "            <td>15455.385</td>\n",
       "            <td>33</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>esporte_lazer</td>\n",
       "            <td>14725.349</td>\n",
       "            <td>34</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artigos_de_natal</td>\n",
       "            <td>13947.046</td>\n",
       "            <td>35</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletrodomesticos</td>\n",
       "            <td>13451.751</td>\n",
       "            <td>36</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_jardim</td>\n",
       "            <td>13399.671</td>\n",
       "            <td>37</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cds_dvds_musicais</td>\n",
       "            <td>13125.0</td>\n",
       "            <td>38</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>market_place</td>\n",
       "            <td>12973.48</td>\n",
       "            <td>39</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>bebidas</td>\n",
       "            <td>11217.803</td>\n",
       "            <td>40</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artes</td>\n",
       "            <td>10668.491</td>\n",
       "            <td>41</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>beleza_saude</td>\n",
       "            <td>10468.159</td>\n",
       "            <td>42</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>seguros_e_servicos</td>\n",
       "            <td>10233.5</td>\n",
       "            <td>43</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_roupa_masculina</td>\n",
       "            <td>8798.421</td>\n",
       "            <td>44</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_calcados</td>\n",
       "            <td>8478.208</td>\n",
       "            <td>45</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fraldas_higiene</td>\n",
       "            <td>8468.417</td>\n",
       "            <td>46</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>eletronicos</td>\n",
       "            <td>7962.507</td>\n",
       "            <td>47</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>alimentos_bebidas</td>\n",
       "            <td>7947.1636</td>\n",
       "            <td>48</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_roupa_infanto_juvenil</td>\n",
       "            <td>7590.2</td>\n",
       "            <td>49</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_seguranca</td>\n",
       "            <td>7472.055</td>\n",
       "            <td>50</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>construcao_ferramentas_ferramentas</td>\n",
       "            <td>7357.6665</td>\n",
       "            <td>51</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>tablets_impressao_imagem</td>\n",
       "            <td>7182.222</td>\n",
       "            <td>52</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_roupa_feminina</td>\n",
       "            <td>7165.2593</td>\n",
       "            <td>53</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>pc_gamer</td>\n",
       "            <td>7074.6665</td>\n",
       "            <td>54</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>cine_foto</td>\n",
       "            <td>6952.393</td>\n",
       "            <td>55</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>consoles_games</td>\n",
       "            <td>6898.9053</td>\n",
       "            <td>56</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>artes_e_artesanato</td>\n",
       "            <td>6895.9473</td>\n",
       "            <td>57</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_esporte</td>\n",
       "            <td>6789.8945</td>\n",
       "            <td>58</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>musica</td>\n",
       "            <td>6727.4814</td>\n",
       "            <td>59</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>alimentos</td>\n",
       "            <td>6634.122</td>\n",
       "            <td>60</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>informatica_acessorios</td>\n",
       "            <td>6483.912</td>\n",
       "            <td>61</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>flores</td>\n",
       "            <td>6334.857</td>\n",
       "            <td>62</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>perfumaria</td>\n",
       "            <td>5136.2188</td>\n",
       "            <td>63</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>telefonia_fixa</td>\n",
       "            <td>5018.681</td>\n",
       "            <td>64</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>audio</td>\n",
       "            <td>4970.1724</td>\n",
       "            <td>65</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_underwear_e_moda_praia</td>\n",
       "            <td>4584.132</td>\n",
       "            <td>66</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>fashion_bolsas_e_acessorios</td>\n",
       "            <td>4480.635</td>\n",
       "            <td>67</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>livros_interesse_geral</td>\n",
       "            <td>3900.0464</td>\n",
       "            <td>68</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>relogios_presentes</td>\n",
       "            <td>3470.398</td>\n",
       "            <td>69</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>livros_tecnicos</td>\n",
       "            <td>2758.992</td>\n",
       "            <td>70</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>livros_importados</td>\n",
       "            <td>1935.3871</td>\n",
       "            <td>71</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>telefonia</td>\n",
       "            <td>1865.8413</td>\n",
       "            <td>72</td>\n",
       "        </tr>\n",
       "        <tr>\n",
       "            <td>dvds_blu_ray</td>\n",
       "            <td>1746.8541</td>\n",
       "            <td>73</td>\n",
       "        </tr>\n",
       "    </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "[('moveis_colchao_e_estofado', 77244.3, 1),\n",
       " ('moveis_escritorio', 75468.47, 2),\n",
       " ('moveis_cozinha_area_de_servico_jantar_e_jardim', 69406.09, 3),\n",
       " ('eletrodomesticos_2', 55476.312, 4),\n",
       " ('moveis_sala', 54486.13, 5),\n",
       " ('moveis_quarto', 51038.844, 6),\n",
       " ('pcs', 44635.168, 7),\n",
       " ('agro_industria_e_comercio', 37604.23, 8),\n",
       " ('industria_comercio_e_negocios', 37372.31, 9),\n",
       " ('malas_acessorios', 32950.336, 10),\n",
       " ('bebes', 30835.576, 11),\n",
       " ('la_cuisine', 30483.4, 12),\n",
       " ('casa_conforto', 28148.73, 13),\n",
       " ('climatizacao', 27910.533, 14),\n",
       " ('eletroportateis', 26913.238, 15),\n",
       " ('instrumentos_musicais', 25089.021, 16),\n",
       " ('portateis_casa_forno_e_cafe', 23911.613, 17),\n",
       " ('cool_stuff', 23246.484, 18),\n",
       " ('pet_shop', 22965.066, 19),\n",
       " ('sinalizacao_e_seguranca', 22583.795, 20),\n",
       " ('moveis_decoracao', 22481.225, 21),\n",
       " ('utilidades_domesticas', 21904.168, 22),\n",
       " ('casa_conforto_2', 20938.0, 23),\n",
       " ('casa_construcao', 20800.236, 24),\n",
       " ('brinquedos', 19625.812, 25),\n",
       " ('construcao_ferramentas_iluminacao', 18897.256, 26),\n",
       " ('portateis_cozinha_e_preparadores_de_alimentos', 18872.7, 27),\n",
       " ('ferramentas_jardim', 18615.406, 28),\n",
       " ('cama_mesa_banho', 18594.576, 29),\n",
       " ('artigos_de_festas', 16942.73, 30),\n",
       " ('automotivo', 16603.586, 31),\n",
       " ('papelaria', 16240.033, 32),\n",
       " ('construcao_ferramentas_construcao', 15455.385, 33),\n",
       " ('esporte_lazer', 14725.349, 34),\n",
       " ('artigos_de_natal', 13947.046, 35),\n",
       " ('eletrodomesticos', 13451.751, 36),\n",
       " ('construcao_ferramentas_jardim', 13399.671, 37),\n",
       " ('cds_dvds_musicais', 13125.0, 38),\n",
       " ('market_place', 12973.48, 39),\n",
       " ('bebidas', 11217.803, 40),\n",
       " ('artes', 10668.491, 41),\n",
       " ('beleza_saude', 10468.159, 42),\n",
       " ('seguros_e_servicos', 10233.5, 43),\n",
       " ('fashion_roupa_masculina', 8798.421, 44),\n",
       " ('fashion_calcados', 8478.208, 45),\n",
       " ('fraldas_higiene', 8468.417, 46),\n",
       " ('eletronicos', 7962.507, 47),\n",
       " ('alimentos_bebidas', 7947.1636, 48),\n",
       " ('fashion_roupa_infanto_juvenil', 7590.2, 49),\n",
       " ('construcao_ferramentas_seguranca', 7472.055, 50),\n",
       " ('construcao_ferramentas_ferramentas', 7357.6665, 51),\n",
       " ('tablets_impressao_imagem', 7182.222, 52),\n",
       " ('fashion_roupa_feminina', 7165.2593, 53),\n",
       " ('pc_gamer', 7074.6665, 54),\n",
       " ('cine_foto', 6952.393, 55),\n",
       " ('consoles_games', 6898.9053, 56),\n",
       " ('artes_e_artesanato', 6895.9473, 57),\n",
       " ('fashion_esporte', 6789.8945, 58),\n",
       " ('musica', 6727.4814, 59),\n",
       " ('alimentos', 6634.122, 60),\n",
       " ('informatica_acessorios', 6483.912, 61),\n",
       " ('flores', 6334.857, 62),\n",
       " ('perfumaria', 5136.2188, 63),\n",
       " ('telefonia_fixa', 5018.681, 64),\n",
       " ('audio', 4970.1724, 65),\n",
       " ('fashion_underwear_e_moda_praia', 4584.132, 66),\n",
       " ('fashion_bolsas_e_acessorios', 4480.635, 67),\n",
       " ('livros_interesse_geral', 3900.0464, 68),\n",
       " ('relogios_presentes', 3470.398, 69),\n",
       " ('livros_tecnicos', 2758.992, 70),\n",
       " ('livros_importados', 1935.3871, 71),\n",
       " ('telefonia', 1865.8413, 72),\n",
       " ('dvds_blu_ray', 1746.8541, 73)]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "WITH avg_box_volume AS(SELECT product_category,\n",
    "                              AVG(volume)::real AS avg_volume\n",
    "                       FROM(SELECT product_category,\n",
    "                                   (product_length_cm::real * product_height_cm::real * product_width_cm::real)::real AS volume\n",
    "                            FROM products\n",
    "                            WHERE product_category IS NOT NULL) AS box_volume\n",
    "                       GROUP BY product_category)\n",
    "SELECT product_category,\n",
    "       avg_volume,\n",
    "       RANK() OVER(ORDER BY avg_volume DESC)\n",
    "FROM avg_box_volume"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3e7afe27-d4dd-4485-8706-ee2febfd24d4",
   "metadata": {
    "tags": []
   },
   "source": [
    "### **Correlation between freight value and product weight, length, height, volume and price**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "f8dcf1f7-7817-4287-aee2-98a025ea2904",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * postgresql://postgres:***@localhost/olist\n",
      "1 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <thead>\n",
       "        <tr>\n",
       "            <th>corr_length</th>\n",
       "            <th>corr_height</th>\n",
       "            <th>corr_width</th>\n",
       "            <th>corr_volume</th>\n",
       "            <th>corr_weight</th>\n",
       "            <th>corr_price</th>\n",
       "        </tr>\n",
       "    </thead>\n",
       "    <tbody>\n",
       "        <tr>\n",
       "            <td>0.30908597</td>\n",
       "            <td>0.39183104</td>\n",
       "            <td>0.32377744</td>\n",
       "            <td>0.5872701</td>\n",
       "            <td>0.6104202</td>\n",
       "            <td>0.4142043</td>\n",
       "        </tr>\n",
       "    </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "[(0.30908597, 0.39183104, 0.32377744, 0.5872701, 0.6104202, 0.4142043)]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "WITH product_freight \n",
    "       AS(SELECT oi.freight_value,\n",
    "       pr.product_weight_grams,\n",
    "       pr.product_length_cm,\n",
    "       pr.product_height_cm,\n",
    "       pr.product_width_cm,\n",
    "       pr.product_length_cm::real * pr.product_height_cm::real * pr.product_width_cm::real AS volume,\n",
    "       oi.price\n",
    "FROM products pr\n",
    "JOIN order_items oi USING(product_id))\n",
    "SELECT CORR(freight_value, product_length_cm)::real AS corr_length,\n",
    "       CORR(freight_value, product_height_cm)::real AS corr_height,\n",
    "       CORR(freight_value, product_width_cm)::real AS corr_width,\n",
    "       CORR(freight_value, volume)::real AS corr_volume,\n",
    "       CORR(freight_value,product_weight_grams)::real AS corr_weight,\n",
    "       CORR(freight_value, price)::real AS corr_price\n",
    "FROM product_freight"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0ff41778-b42c-4446-91bf-a90c74bddc0e",
   "metadata": {},
   "source": [
    "**Correlation between unit sold and photo quantity** "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "6961eef9-8df8-4106-a6d7-482439e66d79",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * postgresql://postgres:***@localhost/olist\n",
      "1 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <thead>\n",
       "        <tr>\n",
       "            <th>corr</th>\n",
       "        </tr>\n",
       "    </thead>\n",
       "    <tbody>\n",
       "        <tr>\n",
       "            <td>-0.006174032</td>\n",
       "        </tr>\n",
       "    </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "[(-0.006174032,)]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "WITH unit_photos AS(SELECT product_id,\n",
    "                           unit_sold,\n",
    "                           product_photos_qty\n",
    "                    FROM (SELECT *\n",
    "                          FROM (SELECT product_id,\n",
    "                                       SUM(order_item_id) as unit_sold    \n",
    "                                FROM orders\n",
    "                                JOIN order_items USING(order_id)\n",
    "                                WHERE order_status='delivered'\n",
    "                                GROUP BY product_id) AS unit_sold\n",
    "                                ORDER BY unit_sold DESC) AS product_units\n",
    "                          JOIN products USING(product_id))\n",
    "SELECT CORR(unit_sold, product_photos_qty)::real\n",
    "FROM unit_photos\n",
    "LIMIT 10"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a0858a22-c6e1-4e18-a9a5-c8004c0509c8",
   "metadata": {},
   "source": [
    "### **Linear Relationship between freight value and product weight**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c0febcee-ec11-4513-80f7-6c55f8ca7979",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * postgresql://postgres:***@localhost/olist\n",
      "1 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <thead>\n",
       "        <tr>\n",
       "            <th>slope</th>\n",
       "            <th>intercept</th>\n",
       "        </tr>\n",
       "    </thead>\n",
       "    <tbody>\n",
       "        <tr>\n",
       "            <td>2.575215</td>\n",
       "            <td>15.649705</td>\n",
       "        </tr>\n",
       "    </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "[(2.575215, 15.649705)]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "WITH price_freight AS (SELECT product_category, \n",
    "                       freight_value,\n",
    "                       (product_weight_grams/1000)::real AS weight\n",
    "                       FROM order_items\n",
    "                       JOIN products using(product_id))\n",
    "SELECT regr_slope(freight_value,weight)::real AS slope,\n",
    "       regr_intercept(freight_value,weight)::real AS intercept\n",
    "FROM price_freight\n",
    "LIMIT 10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "71defe48-e214-45b9-acca-ca8f1418ad31",
   "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.10.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}