Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello,
I am trying to export a folder with my result tables using a python recipe.
I am also trying to name each table differently.
Here is my code:
I keep getting this error when I run my code:
Any idea how to debug please?
Thanks in advance
def export_data(table,scope,liste_region):
for region in liste_region :
with export_DATA.get_writer(region + "/REPORT_AXIS_" +scope+ "_RG_"+ region + "_" + brand_filter + "_" + date_deb + "_" + date_fin + "_" + now + ".csv") as export_data:
export_data.write(table[table['Region']== str(region)].to_csv(index=False))
Hi @Oh_Lily,
the trouble comes from
with export_DATA.get_writer(region + "/REPORT_AXIS_" +scope+ "_RG_"+ region + "_" + brand_filter + "_" + date_deb + "_" + date_fin + "_" + now + ".csv") as export_data:
export_data.write(table[table['Region']== str(region)].to_csv(index=False))
You can't write directly a string, maybe putting an `encode()` will help to write, something like:
with export_DATA.get_writer(region + "/REPORT_AXIS_" +scope+ "_RG_"+ region + "_" + brand_filter + "_" + date_deb + "_" + date_fin + "_" + now + ".csv") as export_data:
export_data.write(table[table['Region']== str(region)].to_csv(index=False).encode())
Hope this helps,
Best
Hi @Oh_Lily,
the trouble comes from
with export_DATA.get_writer(region + "/REPORT_AXIS_" +scope+ "_RG_"+ region + "_" + brand_filter + "_" + date_deb + "_" + date_fin + "_" + now + ".csv") as export_data:
export_data.write(table[table['Region']== str(region)].to_csv(index=False))
You can't write directly a string, maybe putting an `encode()` will help to write, something like:
with export_DATA.get_writer(region + "/REPORT_AXIS_" +scope+ "_RG_"+ region + "_" + brand_filter + "_" + date_deb + "_" + date_fin + "_" + now + ".csv") as export_data:
export_data.write(table[table['Region']== str(region)].to_csv(index=False).encode())
Hope this helps,
Best
Hello,
YES it works!!
thanks a lot for your help !!