python - 如何在ubuntu中提供将数据框导出到excel文件的路径？

Question

如何提供导出Dataframe到 excel 文件的完整路径

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

我有一个 DataFrame df，我必须将该 dataframe df 导出到 excel 文件中。

标签： pythonpython-3.xpandasdataframe

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()