如何组合这两个代码示例?拆分excel工作簿和从csv中删除语音标记。

import pandas as pd
from openpyxl import load_workbook

def split_excel(file_path, sheet_name, chunk_size):
    # 读取Excel文件
    wb = load_workbook(filename=file_path)
    ws = wb[sheet_name]
    
    # 分块读取数据
    data = []
    for row in ws.iter_rows(values_only=True):
        data.append(row)
        if len(data) >= chunk_size:
            write_to_excel(data, file_path, sheet_name)
            data = []
    
    # 写入剩余的数据
    if data:
        write_to_excel(data, file_path, sheet_name)

def write_to_excel(data, file_path, sheet_name):
    new_file_path = f"{file_path.rsplit('.', 1)[0]}_part.xlsx"
    with pd.ExcelWriter(new_file_path, engine='openpyxl') as writer:
        df = pd.DataFrame(data[1:], columns=data[0])
        df.to_excel(writer, sheet_name=sheet_name, index=False)

# 使用示例
split_excel('large_file.xlsx', 'Sheet1', 1000)

import pandas as pd
import re

def remove_speech_tags(csv_file_path):
    # 读取CSV文件
    df = pd.read_csv(csv_file_path)
    
    # 定义一个函数来移除语音标记
    def clean_text(text):
        if pd.isnull(text):
            return text
        return re.sub(r'<[^>]+>', '', text)
    
    # 应用该函数到所有文本列
    for column in df.select_dtypes(include=['object']):
        df[column] = df[column].apply(clean_text)
    
    # 保存修改后的数据回CSV文件
    df.to_csv(csv_file_path, index=False)

# 使用示例
remove_speech_tags('data_with_speech_tags.csv')

import os

# 拆分Excel工作簿并获取生成的CSV文件列表
split_excel('large_file.xlsx', 'Sheet1', 1000)
csv_files = [f for f in os.listdir('.') if f.endswith('.csv')]

# 对每个CSV文件移除语音标记
for csv_file in csv_files:
    remove_speech_tags(csv_file)