aula_9_10 (1).ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "vwXcFiSXDbFa"
      },
      "outputs": [],
      "source": [
        "!pip install pandas\n",
        "!pip install numpy"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd"
      ],
      "metadata": {
        "id": "el-p5zroGPmr"
      },
      "execution_count": 1,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "produtosDF = pd.read_csv('/content/drive/MyDrive/SENAC Python/produtos_csv.csv', sep=';')\n",
        "produtosDF"
      ],
      "metadata": {
        "id": "6QACKHCWGUaS"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "produtosDF['titulo']"
      ],
      "metadata": {
        "id": "Y1fYXxvvMXB8"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "produtosDF.info()"
      ],
      "metadata": {
        "id": "IS6vUR3oPd3C"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Listar uma serie de colunas\n",
        "colunas = ['id_produto','titulo','estoque']\n",
        "produtosDF[colunas]"
      ],
      "metadata": {
        "id": "smuAPoutQj2o"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Listando uma serie de colunas mais elegantes\n",
        "lista = ['id_produto','titulo','estoque']\n",
        "prodDF = produtosDF"
      ],
      "metadata": {
        "id": "SOdDiaYKRM-I"
      },
      "execution_count": 11,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Listando as 5 primeiras linhas \n",
        "prodDF[:5]"
      ],
      "metadata": {
        "id": "Aquu0X97RfcQ"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "produtosDF['titulo'][1]"
      ],
      "metadata": {
        "id": "WVdsJccxRtI_"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_produtos = pd.read_csv('/content/drive/MyDrive/SENAC Python/produtos_csv.csv', sep=';', encoding='utf-8')\n",
        "df_clientes = pd.read_csv('/content/drive/MyDrive/SENAC Python/cliente.csv', sep=';', encoding='utf-8')\n",
        "df_vendas = pd.read_csv('/content/drive/MyDrive/SENAC Python/vendasTratada.csv', sep=',', encoding='utf-8')\n"
      ],
      "metadata": {
        "id": "CxuaD4URR4m4"
      },
      "execution_count": 13,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "display(df_produtos.info())\n",
        "display(df_clientes.info())\n",
        "display(df_vendas.info())"
      ],
      "metadata": {
        "id": "C_P0_ff9VThC"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Removendo colunas ou linas do DF por meio da função drop\n",
        "\n",
        "df_produtos = df_produtos.drop(['cfop','codigo_ncm','icms_situacao_tributaria',\n",
        "                                'icms_origem','pis_situacao_tributaria','cofins_situacao_tributaria',\n",
        "                                'ipi_situacao_tributaria','ipi_codigo_enquadramento_legal'],\n",
        "                               axis=1)\n",
        "display(df_produtos.info())"
      ],
      "metadata": {
        "id": "XFhR5egWZZW3"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Selecionando colunas, devemos criar uma lista com as colunas desejadas\n",
        "colunas = ['id','nome','email','sexo']\n",
        "df_cliente = df_clientes[colunas]\n",
        "df_cliente"
      ],
      "metadata": {
        "id": "sWqRyUb5ckfs"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "display(df_cliente.info())\n",
        "display(df_vendas.info())"
      ],
      "metadata": {
        "id": "MZG8xhfXmLrG"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Renomeando a coluna id para id_cliente do dataframe df_cliente\n",
        "df_cliente = df_cliente.rename(columns={'id':'id_cliente'})\n",
        "df_cliente"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "8_zG9H8Zpddt",
        "outputId": "9cdd13a7-8b56-4dc5-e3fb-b9ba2ce5ff89"
      },
      "execution_count": 32,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      id_cliente                             nome  \\\n",
              "0          12358        Dalvani Maria dos Santos    \n",
              "1          12357           RICHARD CODER O MELHOR   \n",
              "2          12356                 Mariana Ferreira   \n",
              "3          12355           Alessandra Mayumi Odan   \n",
              "4          12354         CLEITON  PATRICK DANELLI   \n",
              "...          ...                              ...   \n",
              "7102          14  carla tatiana de oliveira peres   \n",
              "7103          11                      Geisy Vidal   \n",
              "7104           9                          Douglas   \n",
              "7105           8                   DOUGLAS IZAIAS   \n",
              "7106           6   Douglas IZaias Santos da Silva   \n",
              "\n",
              "                                   email       sexo  \n",
              "0                        dalvani@dalvani          M  \n",
              "1     richardcoder7@tuamaeaquelaursa.com  Masculino  \n",
              "2             marianaalamino80@gmail.com   Feminino  \n",
              "3               mayumi.odan@terra.com.br   Feminino  \n",
              "4      cleiton.patrick.danelli@gmail.com  Masculino  \n",
              "...                                  ...        ...  \n",
              "7102               atilatcar@hotmail.com   feminino  \n",
              "7103            geisy_vidall@hotmail.com   feminino  \n",
              "7104           douglasizaias@hotmail.com         \\N  \n",
              "7105            douglas.izaias@gmail.com  masculino  \n",
              "7106         gabriel.william@hotmail.com  masculino  \n",
              "\n",
              "[7107 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-06cd6be5-22fd-46b6-9208-318201052fae\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_cliente</th>\n",
              "      <th>nome</th>\n",
              "      <th>email</th>\n",
              "      <th>sexo</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>12358</td>\n",
              "      <td>Dalvani Maria dos Santos</td>\n",
              "      <td>dalvani@dalvani</td>\n",
              "      <td>M</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>12357</td>\n",
              "      <td>RICHARD CODER O MELHOR</td>\n",
              "      <td>richardcoder7@tuamaeaquelaursa.com</td>\n",
              "      <td>Masculino</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>12356</td>\n",
              "      <td>Mariana Ferreira</td>\n",
              "      <td>marianaalamino80@gmail.com</td>\n",
              "      <td>Feminino</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>12355</td>\n",
              "      <td>Alessandra Mayumi Odan</td>\n",
              "      <td>mayumi.odan@terra.com.br</td>\n",
              "      <td>Feminino</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>12354</td>\n",
              "      <td>CLEITON  PATRICK DANELLI</td>\n",
              "      <td>cleiton.patrick.danelli@gmail.com</td>\n",
              "      <td>Masculino</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7102</th>\n",
              "      <td>14</td>\n",
              "      <td>carla tatiana de oliveira peres</td>\n",
              "      <td>atilatcar@hotmail.com</td>\n",
              "      <td>feminino</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7103</th>\n",
              "      <td>11</td>\n",
              "      <td>Geisy Vidal</td>\n",
              "      <td>geisy_vidall@hotmail.com</td>\n",
              "      <td>feminino</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7104</th>\n",
              "      <td>9</td>\n",
              "      <td>Douglas</td>\n",
              "      <td>douglasizaias@hotmail.com</td>\n",
              "      <td>\\N</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7105</th>\n",
              "      <td>8</td>\n",
              "      <td>DOUGLAS IZAIAS</td>\n",
              "      <td>douglas.izaias@gmail.com</td>\n",
              "      <td>masculino</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7106</th>\n",
              "      <td>6</td>\n",
              "      <td>Douglas IZaias Santos da Silva</td>\n",
              "      <td>gabriel.william@hotmail.com</td>\n",
              "      <td>masculino</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>7107 rows × 4 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-06cd6be5-22fd-46b6-9208-318201052fae')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-06cd6be5-22fd-46b6-9208-318201052fae button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-06cd6be5-22fd-46b6-9208-318201052fae');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Melhorando a visualização da df vendas\n",
        "colunas_vendas = ['id_cliente','quantidade','data','num_pedido','tipoFrete','valor_total']\n",
        "df_vendas = df_vendas[colunas_vendas]\n",
        "display(df_vendas.info())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 260
        },
        "id": "VPE5zoRcq3Aq",
        "outputId": "93621bbf-5cdd-4aa7-cc8f-5ebcfaae77fc"
      },
      "execution_count": 44,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 22168 entries, 0 to 22167\n",
            "Data columns (total 6 columns):\n",
            " #   Column       Non-Null Count  Dtype  \n",
            "---  ------       --------------  -----  \n",
            " 0   id_cliente   22168 non-null  int64  \n",
            " 1   quantidade   22168 non-null  object \n",
            " 2   data         22168 non-null  object \n",
            " 3   num_pedido   22168 non-null  int64  \n",
            " 4   tipoFrete    22168 non-null  object \n",
            " 5   valor_total  22168 non-null  float64\n",
            "dtypes: float64(1), int64(2), object(3)\n",
            "memory usage: 1.0+ MB\n"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "None"
            ]
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Realizando o merge com df organizados\n",
        "dataAnalize = df_cliente.merge(df_vendas, on='id_cliente')\n",
        "dataAnalize"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "-OplHSszsNoK",
        "outputId": "3effa17a-d890-444c-f2b5-6ab4de9ba834"
      },
      "execution_count": 71,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       id_cliente                             nome  \\\n",
              "0           12356                 Mariana Ferreira   \n",
              "1           12355           Alessandra Mayumi Odan   \n",
              "2           12354         CLEITON  PATRICK DANELLI   \n",
              "3           12354         CLEITON  PATRICK DANELLI   \n",
              "4           12354         CLEITON  PATRICK DANELLI   \n",
              "...           ...                              ...   \n",
              "21709          14  carla tatiana de oliveira peres   \n",
              "21710          14  carla tatiana de oliveira peres   \n",
              "21711           6   Douglas IZaias Santos da Silva   \n",
              "21712           6   Douglas IZaias Santos da Silva   \n",
              "21713           6   Douglas IZaias Santos da Silva   \n",
              "\n",
              "                                   email       sexo quantidade        data  \\\n",
              "0             marianaalamino80@gmail.com   Feminino          1  09/09/2022   \n",
              "1               mayumi.odan@terra.com.br   Feminino          2  08/09/2022   \n",
              "2      cleiton.patrick.danelli@gmail.com  Masculino          1  08/09/2022   \n",
              "3      cleiton.patrick.danelli@gmail.com  Masculino          1  08/09/2022   \n",
              "4      cleiton.patrick.danelli@gmail.com  Masculino          1  08/09/2022   \n",
              "...                                  ...        ...        ...         ...   \n",
              "21709              atilatcar@hotmail.com   feminino          1  27/01/2011   \n",
              "21710              atilatcar@hotmail.com   feminino          1  27/01/2011   \n",
              "21711        gabriel.william@hotmail.com  masculino          1  01/02/2011   \n",
              "21712        gabriel.william@hotmail.com  masculino          1  25/03/2011   \n",
              "21713        gabriel.william@hotmail.com  masculino          1  23/02/2016   \n",
              "\n",
              "       num_pedido tipoFrete  valor_total  \n",
              "0       157221646        SD     R$ 30.00  \n",
              "1       195149875        SD     R$ 75.60  \n",
              "2       209673461        EN    R$ 195.00  \n",
              "3       209673461        EN      R$ 2.50  \n",
              "4       209673461        EN      R$ 2.50  \n",
              "...           ...       ...          ...  \n",
              "21709   183450321        EN     R$ 14.00  \n",
              "21710   183450321        EN     R$ 16.00  \n",
              "21711   107395287        EN     R$ 15.00  \n",
              "21712   112466176        SD      R$ 5.54  \n",
              "21713   983149508        SD    R$ 320.06  \n",
              "\n",
              "[21714 rows x 9 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bbe82d6d-b010-4d51-a4f9-902fcae184d9\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_cliente</th>\n",
              "      <th>nome</th>\n",
              "      <th>email</th>\n",
              "      <th>sexo</th>\n",
              "      <th>quantidade</th>\n",
              "      <th>data</th>\n",
              "      <th>num_pedido</th>\n",
              "      <th>tipoFrete</th>\n",
              "      <th>valor_total</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>12356</td>\n",
              "      <td>Mariana Ferreira</td>\n",
              "      <td>marianaalamino80@gmail.com</td>\n",
              "      <td>Feminino</td>\n",
              "      <td>1</td>\n",
              "      <td>09/09/2022</td>\n",
              "      <td>157221646</td>\n",
              "      <td>SD</td>\n",
              "      <td>R$ 30.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>12355</td>\n",
              "      <td>Alessandra Mayumi Odan</td>\n",
              "      <td>mayumi.odan@terra.com.br</td>\n",
              "      <td>Feminino</td>\n",
              "      <td>2</td>\n",
              "      <td>08/09/2022</td>\n",
              "      <td>195149875</td>\n",
              "      <td>SD</td>\n",
              "      <td>R$ 75.60</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>12354</td>\n",
              "      <td>CLEITON  PATRICK DANELLI</td>\n",
              "      <td>cleiton.patrick.danelli@gmail.com</td>\n",
              "      <td>Masculino</td>\n",
              "      <td>1</td>\n",
              "      <td>08/09/2022</td>\n",
              "      <td>209673461</td>\n",
              "      <td>EN</td>\n",
              "      <td>R$ 195.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>12354</td>\n",
              "      <td>CLEITON  PATRICK DANELLI</td>\n",
              "      <td>cleiton.patrick.danelli@gmail.com</td>\n",
              "      <td>Masculino</td>\n",
              "      <td>1</td>\n",
              "      <td>08/09/2022</td>\n",
              "      <td>209673461</td>\n",
              "      <td>EN</td>\n",
              "      <td>R$ 2.50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>12354</td>\n",
              "      <td>CLEITON  PATRICK DANELLI</td>\n",
              "      <td>cleiton.patrick.danelli@gmail.com</td>\n",
              "      <td>Masculino</td>\n",
              "      <td>1</td>\n",
              "      <td>08/09/2022</td>\n",
              "      <td>209673461</td>\n",
              "      <td>EN</td>\n",
              "      <td>R$ 2.50</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21709</th>\n",
              "      <td>14</td>\n",
              "      <td>carla tatiana de oliveira peres</td>\n",
              "      <td>atilatcar@hotmail.com</td>\n",
              "      <td>feminino</td>\n",
              "      <td>1</td>\n",
              "      <td>27/01/2011</td>\n",
              "      <td>183450321</td>\n",
              "      <td>EN</td>\n",
              "      <td>R$ 14.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21710</th>\n",
              "      <td>14</td>\n",
              "      <td>carla tatiana de oliveira peres</td>\n",
              "      <td>atilatcar@hotmail.com</td>\n",
              "      <td>feminino</td>\n",
              "      <td>1</td>\n",
              "      <td>27/01/2011</td>\n",
              "      <td>183450321</td>\n",
              "      <td>EN</td>\n",
              "      <td>R$ 16.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21711</th>\n",
              "      <td>6</td>\n",
              "      <td>Douglas IZaias Santos da Silva</td>\n",
              "      <td>gabriel.william@hotmail.com</td>\n",
              "      <td>masculino</td>\n",
              "      <td>1</td>\n",
              "      <td>01/02/2011</td>\n",
              "      <td>107395287</td>\n",
              "      <td>EN</td>\n",
              "      <td>R$ 15.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21712</th>\n",
              "      <td>6</td>\n",
              "      <td>Douglas IZaias Santos da Silva</td>\n",
              "      <td>gabriel.william@hotmail.com</td>\n",
              "      <td>masculino</td>\n",
              "      <td>1</td>\n",
              "      <td>25/03/2011</td>\n",
              "      <td>112466176</td>\n",
              "      <td>SD</td>\n",
              "      <td>R$ 5.54</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21713</th>\n",
              "      <td>6</td>\n",
              "      <td>Douglas IZaias Santos da Silva</td>\n",
              "      <td>gabriel.william@hotmail.com</td>\n",
              "      <td>masculino</td>\n",
              "      <td>1</td>\n",
              "      <td>23/02/2016</td>\n",
              "      <td>983149508</td>\n",
              "      <td>SD</td>\n",
              "      <td>R$ 320.06</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>21714 rows × 9 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bbe82d6d-b010-4d51-a4f9-902fcae184d9')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-bbe82d6d-b010-4d51-a4f9-902fcae184d9 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-bbe82d6d-b010-4d51-a4f9-902fcae184d9');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 71
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "AULA 10"
      ],
      "metadata": {
        "id": "LlWqud6icys4"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Clientes que mais comprou\n",
        "clientesEspecial = dataAnalize['nome'].value_counts()\n",
        "display(clientesEspecial.info())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 312
        },
        "id": "P2jkpUuBc0L4",
        "outputId": "19bae490-85cb-4120-ba98-ba63496fe777"
      },
      "execution_count": 72,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 21714 entries, 0 to 21713\n",
            "Data columns (total 9 columns):\n",
            " #   Column       Non-Null Count  Dtype  \n",
            "---  ------       --------------  -----  \n",
            " 0   id_cliente   21714 non-null  int64  \n",
            " 1   nome         21714 non-null  object \n",
            " 2   email        21714 non-null  object \n",
            " 3   sexo         21714 non-null  object \n",
            " 4   quantidade   21714 non-null  object \n",
            " 5   data         21714 non-null  object \n",
            " 6   num_pedido   21714 non-null  int64  \n",
            " 7   tipoFrete    21714 non-null  object \n",
            " 8   valor_total  21714 non-null  float64\n",
            "dtypes: float64(1), int64(2), object(6)\n",
            "memory usage: 1.7+ MB\n"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "None"
            ]
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Gerando graficos dos 5 primcipais clientes\n",
        "clientesEspecial[:5].plot(figsize=(20,10))"
      ],
      "metadata": {
        "id": "DCKFf4Sjdcmy"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#transformando objeto em float\n",
        "dataAnalize['quantidade'] = pd.to_numeric(dataAnalize['quantidade'],errors='coerce') #, downcast='signed' para ser int, mas não deu certo\n",
        "display(dataAnalize.info())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 312
        },
        "id": "tKmQlZpbqHvg",
        "outputId": "c074831e-dd19-4bd1-99d4-2a57df0ce074"
      },
      "execution_count": 74,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 21714 entries, 0 to 21713\n",
            "Data columns (total 9 columns):\n",
            " #   Column       Non-Null Count  Dtype  \n",
            "---  ------       --------------  -----  \n",
            " 0   id_cliente   21714 non-null  int64  \n",
            " 1   nome         21714 non-null  object \n",
            " 2   email        21714 non-null  object \n",
            " 3   sexo         21714 non-null  object \n",
            " 4   quantidade   21219 non-null  float64\n",
            " 5   data         21714 non-null  object \n",
            " 6   num_pedido   21714 non-null  int64  \n",
            " 7   tipoFrete    21714 non-null  object \n",
            " 8   valor_total  21714 non-null  float64\n",
            "dtypes: float64(2), int64(2), object(5)\n",
            "memory usage: 1.7+ MB\n"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "None"
            ]
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Agrupar valores\n",
        "pd.options.display.float_format = 'R$ {:,.2f}'.format\n",
        "vendasPorCliente = dataAnalize.groupby('nome').sum()\n",
        "display(vendasPorCliente.info())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 225
        },
        "id": "UiM8wXbteUy2",
        "outputId": "f07f042f-5f9a-4952-8370-076e9bee5b7f"
      },
      "execution_count": 76,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Index: 4980 entries,  Lucas William Almeida Silva to érika Cristiane Bertuchi\n",
            "Data columns (total 4 columns):\n",
            " #   Column       Non-Null Count  Dtype  \n",
            "---  ------       --------------  -----  \n",
            " 0   id_cliente   4980 non-null   int64  \n",
            " 1   quantidade   4980 non-null   float64\n",
            " 2   num_pedido   4980 non-null   int64  \n",
            " 3   valor_total  4980 non-null   float64\n",
            "dtypes: float64(2), int64(2)\n",
            "memory usage: 194.5+ KB\n"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "None"
            ]
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Retornado apenas o nome do cliente e o valor de compra\n",
        "vendasPorCliente = vendasPorCliente[['valor_total']]\n",
        "display(vendasPorCliente)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        },
        "id": "XRU7gFqGepsu",
        "outputId": "b70621b1-d5c7-4493-b90d-fd06822ad4b4"
      },
      "execution_count": 78,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "                                       valor_total\n",
              "nome                                              \n",
              " Lucas William Almeida Silva              R$ 40.50\n",
              " Marcello Reis                         R$ 4,980.06\n",
              " Sandra Paula Caserta Lee              R$ 2,100.00\n",
              "ADEILSON FLORENCIO DA SILVA              R$ 828.70\n",
              "ADERVAL PACHECO DE MATOS               R$ 1,126.30\n",
              "...                                            ...\n",
              "Áurea Fabrícia Amâncio Quirino         R$ 1,420.40\n",
              "ÉDERSON BARBOSA DE LIMA                  R$ 205.50\n",
              "Éverton José Hernandes                   R$ 144.00\n",
              "Êrika FErnandes Rosas Carlos da Silva    R$ 147.06\n",
              "érika Cristiane Bertuchi                 R$ 129.00\n",
              "\n",
              "[4980 rows x 1 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-287c5caa-de40-4bf6-846c-4d3e5f3c7836\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>valor_total</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>nome</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Lucas William Almeida Silva</th>\n",
              "      <td>R$ 40.50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Marcello Reis</th>\n",
              "      <td>R$ 4,980.06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Sandra Paula Caserta Lee</th>\n",
              "      <td>R$ 2,100.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ADEILSON FLORENCIO DA SILVA</th>\n",
              "      <td>R$ 828.70</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ADERVAL PACHECO DE MATOS</th>\n",
              "      <td>R$ 1,126.30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Áurea Fabrícia Amâncio Quirino</th>\n",
              "      <td>R$ 1,420.40</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ÉDERSON BARBOSA DE LIMA</th>\n",
              "      <td>R$ 205.50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Éverton José Hernandes</th>\n",
              "      <td>R$ 144.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Êrika FErnandes Rosas Carlos da Silva</th>\n",
              "      <td>R$ 147.06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>érika Cristiane Bertuchi</th>\n",
              "      <td>R$ 129.00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>4980 rows × 1 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-287c5caa-de40-4bf6-846c-4d3e5f3c7836')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-287c5caa-de40-4bf6-846c-4d3e5f3c7836 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-287c5caa-de40-4bf6-846c-4d3e5f3c7836');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Podemos ordernar os valor do maior para o menor\n",
        "# dica no parementro ascending pode-se tambem enviar 0=false ou 1=true\n",
        "\n",
        "vendasPorCliente = vendasPorCliente.sort_values('valor_total', ascending=0)\n",
        "display(vendasPorCliente)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        },
        "id": "RlKHpltfreTj",
        "outputId": "4e1e23aa-a25b-48fa-9021-6b3eec68f9ff"
      },
      "execution_count": 81,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "                                valor_total\n",
              "nome                                       \n",
              "Isabel Gomes Pereira          R$ 433,736.24\n",
              "MAURO                         R$ 198,288.00\n",
              "Comercial Tsurukyo Ltda       R$ 121,530.11\n",
              "Gabriel William de Andrade     R$ 89,416.06\n",
              "Douglas Izaias                 R$ 72,014.08\n",
              "...                                     ...\n",
              "teste teste                         R$ 1.00\n",
              "Wagner dos Santos de oliveira       R$ 0.00\n",
              "Gleice Pereira de Oliveira          R$ 0.00\n",
              "Rosinei Martins Adolfo         R$ -4,072.50\n",
              "Marli Rodrigues Okamura       R$ -14,520.00\n",
              "\n",
              "[4980 rows x 1 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-828deb1c-3bd5-48dc-a4e5-af1ad40bb8d5\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>valor_total</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>nome</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Isabel Gomes Pereira</th>\n",
              "      <td>R$ 433,736.24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MAURO</th>\n",
              "      <td>R$ 198,288.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Comercial Tsurukyo Ltda</th>\n",
              "      <td>R$ 121,530.11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gabriel William de Andrade</th>\n",
              "      <td>R$ 89,416.06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Douglas Izaias</th>\n",
              "      <td>R$ 72,014.08</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>teste teste</th>\n",
              "      <td>R$ 1.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wagner dos Santos de oliveira</th>\n",
              "      <td>R$ 0.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gleice Pereira de Oliveira</th>\n",
              "      <td>R$ 0.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Rosinei Martins Adolfo</th>\n",
              "      <td>R$ -4,072.50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Marli Rodrigues Okamura</th>\n",
              "      <td>R$ -14,520.00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>4980 rows × 1 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-828deb1c-3bd5-48dc-a4e5-af1ad40bb8d5')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-828deb1c-3bd5-48dc-a4e5-af1ad40bb8d5 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-828deb1c-3bd5-48dc-a4e5-af1ad40bb8d5');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Exportar os DF para excel, json, html e xml\n",
        "# salva na raiz da maquina vitual\n",
        "vendasPorCliente.to_excel('totalDeVendasPorClient.xlsx')\n",
        "vendasPorCliente.to_json('totalDeVendasPorClient.json')\n",
        "vendasPorCliente.to_html('totalDeVendasPorClient.html')\n",
        "vendasPorCliente.to_xml('totalDeVendasPorClient.xml')"
      ],
      "metadata": {
        "id": "-teb7bv8yEHl"
      },
      "execution_count": 83,
      "outputs": []
    }
  ]
}