如果第一列中的值大于7,我想突出显示表的整个行(不包括索引)。我现在可以使用以下代码突出显示第一个单元格:
import pandas as pd
df = pd.DataFrame({'A':[6,4,8,2],'B':[.3,.2,.4,.1],'C': [12,13,14,15]})
with pd.ExcelWriter('temp.xlsx',engine='xlsxwriter') as writer:
workbook = writer.book
df.to_excel(writer)
worksheet = workbook.worksheets()[0]
format_yellow = workbook.add_format({'bg_color': '#FFFF00'})
worksheet.conditional_format('B2:B5',{'type': 'cell','criteria': '>','value': 7,'format': format_yellow})
这就是我得到的: get
这就是我想要的: want