根据特殊符号进行切除并保存到新excel中脚本

import xlrd
import xlwt


def num_cut():
    # ---------------------读
    # 打开excel文件，创建一个workbook对象,book对象也就是fruits.xlsx文件,表含有sheet名
    r_book = xlrd.open_workbook("./cs.xlsx")
    # xls默认有3个工作簿,Sheet1,Sheet2,Sheet3
    r_sheet = r_book.sheet_by_index(0)  # 取第一个工作簿
    print(r_sheet)

    # ---------------------写
    # 创建一个workbook 设置编码
    workbook = xlwt.Workbook(encoding='utf-8')
    # 创建一个worksheet
    worksheet = workbook.add_sheet('cpu_load')

    # 行数
    row = -1
    # 循环工作簿的所有行
    for my_row in r_sheet.get_rows():
        row += 1
        # 选择第一列
        product_column = my_row[0]
        # print(product_column)
        value = product_column.value
        print(value)
        if value != "cpuload":
            cpu_load_list = product_column.value.split("|")
            # print(cpu_load_list)
            for col, cpu_load in enumerate(cpu_load_list):
                # 参数对应 行, 列, 值
                worksheet.write(row, col, label=cpu_load)
    # 保存
    workbook.save('./cpu_load.xlsx')


if __name__ == '__main__':
    num_cut()

------------------------用pandas进行处理-------------------------------------

#! /usr/bin/python
# -*- coding: utf-8 -*-

# 导入pandas模块
import pandas


def num_cut():
    # 读取excel文件,定位sheet页
    df = pandas.read_excel("./cs.xlsx", sheet_name="以|为界限分成8列")
    # 获取列名为cpuload下的数据
    column_name = df['cpuload']
    # 显示省略部分数据
    pandas.set_option('display.max_rows', None)
    print(str(column_name))
    # 利用‘|’进行分割
    cpu_load_list = column_name.str.split('|', expand=True)
    print(cpu_load_list)

    write_excel(cpu_load_list)


def write_excel(column_name):
    # 数据保存
    column_name.to_excel('new-cut_pandas.xlsx')


if __name__ == '__main__':
    num_cut()