joao.herculano/Ruptura_Projetada
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Ruptura_Projetada/estudo tombamento EUD BA.ipynb
João Herculano 7221f41ebb mudaças pré formatação do pc
2025-10-24 15:54:54 -03:00

764 lines
23 KiB
Plaintext
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

{
"cells": [
{
"cell_type": "code",
"execution_count": 32,
"id": "a6f320df",
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 33,
"id": "03c2c8a2",
"metadata": {},
"outputs": [],
"source": [
"df = pd.read_csv(r\"C:\\Users\\joao.herculano\\Downloads\\VENDAS_BAHIA_27_08.csv\",sep=';')"
]
},
{
"cell_type": "code",
"execution_count": 34,
"id": "df4d53ad",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>nf</th>\n",
" <th>data_venda</th>\n",
" <th>canal</th>\n",
" <th>PDV</th>\n",
" <th>cod</th>\n",
" <th>desc</th>\n",
" <th>qtd</th>\n",
" <th>valor_unit</th>\n",
" <th>valor_total</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>52276</td>\n",
" <td>KIT SACOLA P INST EUD 2022 C/10 VD</td>\n",
" <td>1</td>\n",
" <td>6,37</td>\n",
" <td>6,37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>49016</td>\n",
" <td>ACCORDES DES BDY SPR 100ml V6</td>\n",
" <td>1</td>\n",
" <td>40,72</td>\n",
" <td>40,72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>50481</td>\n",
" <td>GLAM BAT MICRO PLUMP VERMELHO UNICO 1,8g</td>\n",
" <td>1</td>\n",
" <td>24,43</td>\n",
" <td>24,43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>52334</td>\n",
" <td>SOUL K/M BAT MATE VERM MODERNO V2 3,7g</td>\n",
" <td>1</td>\n",
" <td>25,19</td>\n",
" <td>25,19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>50483</td>\n",
" <td>GLAM BAT MICRO PLUMP ROSADO NOBRE 1,8g</td>\n",
" <td>1</td>\n",
" <td>24,43</td>\n",
" <td>24,43</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" nf data_venda canal PDV cod \\\n",
"0 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 52276 \n",
"1 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 49016 \n",
"2 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 50481 \n",
"3 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 52334 \n",
"4 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 50483 \n",
"\n",
" desc qtd valor_unit valor_total \n",
"0 KIT SACOLA P INST EUD 2022 C/10 VD 1 6,37 6,37 \n",
"1 ACCORDES DES BDY SPR 100ml V6 1 40,72 40,72 \n",
"2 GLAM BAT MICRO PLUMP VERMELHO UNICO 1,8g 1 24,43 24,43 \n",
"3 SOUL K/M BAT MATE VERM MODERNO V2 3,7g 1 25,19 25,19 \n",
"4 GLAM BAT MICRO PLUMP ROSADO NOBRE 1,8g 1 24,43 24,43 "
]
},
"execution_count": 34,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 35,
"id": "25155a2d",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>nf</th>\n",
" <th>data_venda</th>\n",
" <th>canal</th>\n",
" <th>PDV</th>\n",
" <th>SKU</th>\n",
" <th>desc</th>\n",
" <th>qtd</th>\n",
" <th>valor_unit</th>\n",
" <th>valor_total</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>52276</td>\n",
" <td>KIT SACOLA P INST EUD 2022 C/10 VD</td>\n",
" <td>1</td>\n",
" <td>6,37</td>\n",
" <td>6,37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>49016</td>\n",
" <td>ACCORDES DES BDY SPR 100ml V6</td>\n",
" <td>1</td>\n",
" <td>40,72</td>\n",
" <td>40,72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>50481</td>\n",
" <td>GLAM BAT MICRO PLUMP VERMELHO UNICO 1,8g</td>\n",
" <td>1</td>\n",
" <td>24,43</td>\n",
" <td>24,43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>52334</td>\n",
" <td>SOUL K/M BAT MATE VERM MODERNO V2 3,7g</td>\n",
" <td>1</td>\n",
" <td>25,19</td>\n",
" <td>25,19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>50483</td>\n",
" <td>GLAM BAT MICRO PLUMP ROSADO NOBRE 1,8g</td>\n",
" <td>1</td>\n",
" <td>24,43</td>\n",
" <td>24,43</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" nf data_venda canal PDV SKU \\\n",
"0 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 52276 \n",
"1 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 49016 \n",
"2 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 50481 \n",
"3 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 52334 \n",
"4 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 50483 \n",
"\n",
" desc qtd valor_unit valor_total \n",
"0 KIT SACOLA P INST EUD 2022 C/10 VD 1 6,37 6,37 \n",
"1 ACCORDES DES BDY SPR 100ml V6 1 40,72 40,72 \n",
"2 GLAM BAT MICRO PLUMP VERMELHO UNICO 1,8g 1 24,43 24,43 \n",
"3 SOUL K/M BAT MATE VERM MODERNO V2 3,7g 1 25,19 25,19 \n",
"4 GLAM BAT MICRO PLUMP ROSADO NOBRE 1,8g 1 24,43 24,43 "
]
},
"execution_count": 35,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = df.rename(columns={'cod':'SKU'})\n",
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 36,
"id": "59aad387",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"0 20970\n",
"1 20970\n",
"2 20970\n",
"3 20970\n",
"4 20970\n",
"Name: pdv_tratado, dtype: object"
]
},
"execution_count": 36,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['pdv_tratado'] = df['PDV'].str.split('-').str[0]\n",
"df['pdv_tratado'].head()"
]
},
{
"cell_type": "code",
"execution_count": 37,
"id": "3f7da7c8",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>SKU</th>\n",
" <th>origem</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>72898</td>\n",
" <td>BOT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>49586</td>\n",
" <td>BOT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>5221</td>\n",
" <td>BOT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>28644</td>\n",
" <td>BOT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>85154</td>\n",
" <td>BOT</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" SKU origem\n",
"0 72898 BOT\n",
"1 49586 BOT\n",
"2 5221 BOT\n",
"3 28644 BOT\n",
"4 85154 BOT"
]
},
"execution_count": 37,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_marca = pd.read_csv(r\"C:\\Users\\joao.herculano\\OneDrive - GRUPO GINSENG\\Documentos\\CONSULTAS BANCO DE DADOS\\skus e marcas 20250828.csv\",sep=';')\n",
"\n",
"df_marca.head()"
]
},
{
"cell_type": "code",
"execution_count": 38,
"id": "bd585612",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>nf</th>\n",
" <th>data_venda</th>\n",
" <th>canal</th>\n",
" <th>PDV</th>\n",
" <th>SKU</th>\n",
" <th>desc</th>\n",
" <th>qtd</th>\n",
" <th>valor_unit</th>\n",
" <th>valor_total</th>\n",
" <th>pdv_tratado</th>\n",
" <th>origem</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>52276</td>\n",
" <td>KIT SACOLA P INST EUD 2022 C/10 VD</td>\n",
" <td>1</td>\n",
" <td>6,37</td>\n",
" <td>6,37</td>\n",
" <td>20970</td>\n",
" <td>EUD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>49016</td>\n",
" <td>ACCORDES DES BDY SPR 100ml V6</td>\n",
" <td>1</td>\n",
" <td>40,72</td>\n",
" <td>40,72</td>\n",
" <td>20970</td>\n",
" <td>BOT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>50481</td>\n",
" <td>GLAM BAT MICRO PLUMP VERMELHO UNICO 1,8g</td>\n",
" <td>1</td>\n",
" <td>24,43</td>\n",
" <td>24,43</td>\n",
" <td>20970</td>\n",
" <td>EUD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>52334</td>\n",
" <td>SOUL K/M BAT MATE VERM MODERNO V2 3,7g</td>\n",
" <td>1</td>\n",
" <td>25,19</td>\n",
" <td>25,19</td>\n",
" <td>20970</td>\n",
" <td>EUD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>32892</td>\n",
" <td>27/08/2025</td>\n",
" <td>Venda Direta</td>\n",
" <td>20970-COMERCIO-ER SAO SEBASTIAO</td>\n",
" <td>50483</td>\n",
" <td>GLAM BAT MICRO PLUMP ROSADO NOBRE 1,8g</td>\n",
" <td>1</td>\n",
" <td>24,43</td>\n",
" <td>24,43</td>\n",
" <td>20970</td>\n",
" <td>EUD</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" nf data_venda canal PDV SKU \\\n",
"0 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 52276 \n",
"1 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 49016 \n",
"2 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 50481 \n",
"3 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 52334 \n",
"4 32892 27/08/2025 Venda Direta 20970-COMERCIO-ER SAO SEBASTIAO 50483 \n",
"\n",
" desc qtd valor_unit valor_total \\\n",
"0 KIT SACOLA P INST EUD 2022 C/10 VD 1 6,37 6,37 \n",
"1 ACCORDES DES BDY SPR 100ml V6 1 40,72 40,72 \n",
"2 GLAM BAT MICRO PLUMP VERMELHO UNICO 1,8g 1 24,43 24,43 \n",
"3 SOUL K/M BAT MATE VERM MODERNO V2 3,7g 1 25,19 25,19 \n",
"4 GLAM BAT MICRO PLUMP ROSADO NOBRE 1,8g 1 24,43 24,43 \n",
"\n",
" pdv_tratado origem \n",
"0 20970 EUD \n",
"1 20970 BOT \n",
"2 20970 EUD \n",
"3 20970 EUD \n",
"4 20970 EUD "
]
},
"execution_count": 38,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = pd.merge(df,df_marca,on='SKU',how='left')\n",
"\n",
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 40,
"id": "c6dd1a57",
"metadata": {},
"outputs": [],
"source": [
"\n",
"df['valor_unit'] = df['valor_unit'].str.replace(',','.')\n",
"\n",
"df['valor_unit'] = df['valor_unit'].astype(float)\n"
]
},
{
"cell_type": "code",
"execution_count": 41,
"id": "c6fa06d5",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"nf int64\n",
"data_venda object\n",
"canal object\n",
"PDV object\n",
"SKU int64\n",
"desc object\n",
"qtd int64\n",
"valor_unit float64\n",
"valor_total float64\n",
"pdv_tratado object\n",
"origem object\n",
"dtype: object"
]
},
"execution_count": 41,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['valor_total'] = df['valor_unit']*df['qtd']\n",
"\n",
"df.dtypes"
]
},
{
"cell_type": "code",
"execution_count": 43,
"id": "9b76b521",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>nf</th>\n",
" <th>pdv_tratado</th>\n",
" <th>origem</th>\n",
" <th>valor_total</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1367</td>\n",
" <td>24293</td>\n",
" <td>BOT</td>\n",
" <td>225.16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1368</td>\n",
" <td>24293</td>\n",
" <td>BOT</td>\n",
" <td>2310.04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>1369</td>\n",
" <td>24293</td>\n",
" <td>BOT</td>\n",
" <td>1033.93</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>1369</td>\n",
" <td>24293</td>\n",
" <td>EUD</td>\n",
" <td>67.82</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1370</td>\n",
" <td>24293</td>\n",
" <td>BOT</td>\n",
" <td>441.82</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>4236</th>\n",
" <td>324225</td>\n",
" <td>23711</td>\n",
" <td>BOT</td>\n",
" <td>216.80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4237</th>\n",
" <td>324226</td>\n",
" <td>23711</td>\n",
" <td>BOT</td>\n",
" <td>267.40</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4238</th>\n",
" <td>324227</td>\n",
" <td>23711</td>\n",
" <td>BOT</td>\n",
" <td>7724.42</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4239</th>\n",
" <td>324227</td>\n",
" <td>23711</td>\n",
" <td>EUD</td>\n",
" <td>7332.19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4240</th>\n",
" <td>324227</td>\n",
" <td>23711</td>\n",
" <td>QDB</td>\n",
" <td>31.36</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>4241 rows × 4 columns</p>\n",
"</div>"
],
"text/plain": [
" nf pdv_tratado origem valor_total\n",
"0 1367 24293 BOT 225.16\n",
"1 1368 24293 BOT 2310.04\n",
"2 1369 24293 BOT 1033.93\n",
"3 1369 24293 EUD 67.82\n",
"4 1370 24293 BOT 441.82\n",
"... ... ... ... ...\n",
"4236 324225 23711 BOT 216.80\n",
"4237 324226 23711 BOT 267.40\n",
"4238 324227 23711 BOT 7724.42\n",
"4239 324227 23711 EUD 7332.19\n",
"4240 324227 23711 QDB 31.36\n",
"\n",
"[4241 rows x 4 columns]"
]
},
"execution_count": 43,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_agg_marca = df.groupby(['nf','pdv_tratado','origem'])['valor_total'].sum().reset_index().sort_values('nf')\n",
"df_agg_marca"
]
},
{
"cell_type": "code",
"execution_count": 45,
"id": "88f5968f",
"metadata": {},
"outputs": [],
"source": [
"caminho = r'C:\\Users\\joao.herculano\\Documents\\df_agg_vendaBA.xlsx'\n",
"\n",
"with pd.ExcelWriter(caminho, engine='xlsxwriter') as writer:\n",
" df.to_excel(writer, sheet_name='df', index=False)\n",
" df_agg_marca.to_excel(writer, sheet_name='df_agg_marca', index=False)"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.13.2"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Reference in New Issue View Git Blame Copy Permalink