我有一个EXCEL文件，它有两列，‘时间’和‘样本’.我想做一个‘样本’对‘时间’的折线图.
我试过:
excel_file = 'test.xlsx'
sheet_name = 'Sheet1'
writer = pd.ExcelWriter(excel_file, engine='xlsxwriter')
workbook = writer.book
worksheet = writer.sheets[sheet_name]
chart = workbook.add_chart({'type': 'line'})
chart.add_series({'values': ["Sheet 1", 1, 1, 2000, 1]})
chart.add_series({'values': ["Sheet 1", 1, 2, 2000, 2]})
worksheet.insert_chart('P2', chart)
workbook.close`
代码运行了，但我无法打开EXCEL文件.有谁可以帮我？谢谢!
代码有几个问题:
df.to_excel()的Excel文件close()应该在writer号公路上，而不是workbook号公路上.这不是一个严重的错误，但最好避免它.解决了这些问题后，您应该会得到预期的输出:
import pandas as pd
df = pd.DataFrame(
{
"Data1": [10, 20, 30, 10, 19, 35, 40],
"Data2": [20, 10, 30, 20, 15, 30, 45],
}
)
excel_file = "test.xlsx"
sheet_name = "Sheet1"
writer = pd.ExcelWriter(excel_file, engine="xlsxwriter")
df.to_excel(writer, sheet_name=sheet_name)
workbook = writer.book
worksheet = writer.sheets[sheet_name]
chart = workbook.add_chart({"type": "line"})
(max_row, max_col) = df.shape
chart.add_series({"values": [sheet_name, 1, 1, max_row, 1]})
chart.add_series({"values": [sheet_name, 1, 2, max_row, 2]})
worksheet.insert_chart(1, 4, chart)
writer.close()
输出:
