pandas 添加多个 sheet 页

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()
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17