-
Notifications
You must be signed in to change notification settings - Fork 0
/
setup.py
38 lines (32 loc) · 868 Bytes
/
setup.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
from datetime import datetime
import pandas as pd
# Inserir a data atual no final do arquivo
DATE = datetime.now().strftime("%Y-%m-%d")
from paginas_sigbm import (
page1,
page1_1,
page1_2,
page2,
page3,
page4,
page5,
page6,
page7,
)
# Definir o caminho do arquivo Excel
EXCEL_FILE_PATH = f"data/download_sigbm_{DATE}.xlsx"
# Criar dicionário que mapeia o nome da página para o DataFrame correspondente
page_dataframes = {
"1": page1.df_page1,
"1.1": page1_1.df_page1_1,
"1.2": page1_2.df_page1_2,
"2": page2.df_page2,
"3": page3.df_page3,
"4": page4.df_page4,
"5": page5.df_page5,
"6": page6.df_page6,
"7": page7.df_page7,
}
with pd.ExcelWriter(EXCEL_FILE_PATH) as writer:
for sheet_name, df in page_dataframes.items():
df.to_excel(writer, sheet_name=sheet_name, index=False)