如何在excel中从pandas dataframe中创建数据验证列？

import pandas as pd
from openpyxl import load_workbook
from openpyxl.worksheet.datavalidation import DataValidation

data = {'Name': ['John', 'Emma', 'Mike', 'Emily'],
        'Age': [25, 28, 30, 27],
        'Gender': ['Male', 'Female', 'Male', 'Female']}
df = pd.DataFrame(data)

writer = pd.ExcelWriter('data.xlsx', engine='openpyxl')
df.to_excel(writer, index=False, sheet_name='Sheet1')
writer.save()

book = load_workbook('data.xlsx')
writer = pd.ExcelWriter('data.xlsx', engine='openpyxl')
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

dv = DataValidation(type="list", formula1='"Male,Female"', showDropDown=True)

sheet = book['Sheet1']
dv.add(sheet['C2'])
dv.add(sheet['C3'])
dv.add(sheet['C4'])

writer.save()