如何在ubuntu中给出将数据帧导出到excel文件的路径？

Question

如何给出将Dataframe导出到excel文件的完整路径

xport_excel = df.to_excel('home\desktop\python\export_dataframe.xlsx', index = None, header=True)

我有一个dataframedf，我必须将这个dataframedf导出到excel文件中。你知道吗

Answer 1

df=result1[['StoreID', 'BatchID', 'Quantity', 'ProductID']]   


writer = pd.ExcelWriter('pandas_simple.xlsx', engine='xlsxwriter')
# Convert the dataframe to an XlsxWriter Excel object.
df.to_excel(writer, sheet_name='Sheet1')
# Close the Pandas Excel writer and output the Excel file.
writer.save()