pandas 添加多个sheet页
import pandas as pd
from openpyxl import load_workbook
# 读取Excel文件
file_path = 'cs.xlsx' # 替换为你的Excel文件路径
df = pd.read_excel(file_path)
# 指定字段和筛选项
field_to_filter = '33' # 替换为你要筛选的字段名称
filter_values = ['1', '2', '3'] # 替换为你的筛选项列表
writer = pd.ExcelWriter("1.xlsx")
for i in filter_values:
sheet_name = i.split('[')[0]
sheet_num = i.split('[')[1].split(']')[0]
df_filtered = df[df[field_to_filter].str.contains(F'.*?{sheet_name}|{sheet_num}')]
df_filtered.to_excel(writer, sheet_name=sheet_name, index=False,)
writer._save()