i am using kedro 0.18.14 and kedro datasets 1.4.2....
# questionsa
Alejandro P.
07/18/2024, 8:40 PMi am using kedro 0.18.14 and kedro datasets 1.4.2. I have defined in the catalog the excel file with multiple sheets (basically repeating for each sheet the same definition) but it doesnt work
n
Nok Lam Chan
07/18/2024, 10:42 PMCan you show how you define it in the catalog?
Nok Lam Chan
07/18/2024, 10:43 PMYou can check the example here https://docs.kedro.org/en/0.18.14/kedro_datasets.pandas.ExcelDataset.html
a
Alejandro P.
07/19/2024, 1:08 PMthanks! i checked the example but i dont know how to save different dataframes as different sheets in the same excel file
Alejandro P.
07/19/2024, 1:08 PMhere is how i define it
Alejandro P.
07/19/2024, 1:08 PMdf_result_final:
type: pandas.ExcelDataSet
load_args:
sheet_name: Result_Final
save_args:
sheet_name: Result_Final
layer: cleaning
filepath: data/03_primary/Q_Filtrado_STL_IQR.xlsx
df_describe_Q:
type: pandas.ExcelDataSet
load_args:
sheet_name: Estadisticas_Antes_Result_Q
save_args:
sheet_name: Estadisticas_Antes_Result_Q
index: True
layer: cleaning
filepath: data/03_primary/Estadisticas_Antes_Result_Q.xlsx
Alejandro P.
07/19/2024, 1:09 PMsrry that is not
Alejandro P.
07/19/2024, 1:09 PMthis:
Alejandro P.
07/19/2024, 1:09 PMdf_result_final:
type: pandas.ExcelDataSet
load_args:
sheet_name: Result_Final
save_args:
sheet_name: Result_Final
layer: cleaning
filepath: data/03_primary/Q_Filtrado_STL_IQR.xlsx
df_describe_Q:
type: pandas.ExcelDataSet
load_args:
sheet_name: Estadisticas_Antes_Result_Q
save_args:
sheet_name: Estadisticas_Antes_Result_Q
index: True
layer: cleaning
filepath: data/03_primary/Q_Filtrado_STL_IQR.xlsx
n
Nok Lam Chan
07/19/2024, 1:10 PMa
Alejandro P.
07/19/2024, 1:27 PMthanks i will try
2 Views