我有一个带有虚构数值的数据框:
import pandas as pd
df = pd.DataFrame({'Country|Gender': ["US", "UK", "Canada"],
'Male': [100000, 10000, 1000],
'Female': [200000, 20000, 2000]})
现在，我把它放到了一个很好的位置:
from pandas import ExcelWriter
output_file='output.xlsx'
writer = ExcelWriter(output_file, engine='xlsxwriter')
df.to_excel(writer, 'FirstSheet', index=False)
writer.save()
writer.close()
我想要对角线拆分Electron 表格中数据框左上角的单元格，"Country"在底部，而"Gender"在顶部.
我怎么能做到这一点？
IIUC, you can tweak the split with the xlsxwriter engine you already set :
with ExcelWriter(output_file, engine="xlsxwriter") as writer:
df.to_excel(writer, "FirstSheet", index=False)
ws = writer.sheets["FirstSheet"]
wb = writer.book
fmt = wb.add_format({"diag_type": 2, "diag_color": "black"})
fmt.set_text_wrap()
fmt.set_border(1)
fmt.set_bold()
ws.write("A1", "{}Gender\nCountry".format(" "*15), fmt)
ws.set_row(0, 29)
ws.set_column("A:A", 13)
输出(output.xlsx):
