Pandas:根据dataframe中的另一列设置特定单元格的样式

import pandas as pd
import numpy as np
import openpyxl
from openpyxl.styles import PatternFill

data = {'Name': ['Alice', 'Bob', 'Charlie', 'David'],
        'Age': [25, 30, 35, 40],
        'Gender': ['Female', 'Male', 'Male', 'Male']}
df = pd.DataFrame(data)

def set_cell_style(cell, color):
    fill = PatternFill(start_color=color, end_color=color, fill_type="solid")
    cell.fill = fill

# 根据Gender列的值为Male，设置Age列对应单元格的背景色为黄色
for index, row in df.iterrows():
    if row['Gender'] == 'Male':
        cell = 'C' + str(index + 2)  # C列为Age列
        set_cell_style(ws[cell], 'FFFF00')  # 设置背景色为黄色