这是我的代码,我的问题似乎是将数据帧写入Excel创建我无法覆盖的格式:
import polars as pl
import xlsxwriter as writer
df = pl.DataFrame({
"A": [1, 2, 3, 2, 5],
"B": ["x", "y", "x", "z", "y"]
})
with writer.Workbook('text_book.xlsx') as wb:
worksheet = wb.add_worksheet()
data_format1 = wb.add_format({'bg_color': '#FFC7CE'})
df.write_excel(wb, worksheet = 'Sheet1', autofilter= False,
autofit = True, position = 'A3', include_header = False)
for row in range(0,10,2):
worksheet.set_row(row+2, cell_format=data_format1)
输出:
理想情况下,输出应为:
我正在寻找一种迭代行索引列表并为这些行设置 colored颜色 的方法.