python进行等宽离散并将结果写入excel表格

【实例截图】

【核心代码】

import xlrd
import xlwt
import pandas as pd
import copy



def Lianxu_Lisan1():

    lis = []
    lis = readincol()
    print("请输入要处理的没有划分标准的列的总数")
    all = input("all:")
    for i in range(int(all)):
        print("请输入要处理的列的列号")
        n = input("n:")
        data=[]
        data = copy.copy(lis[int(n)-1][1:])
        print(data)

        # da = [3,60,83,100,52,36]

        k = 4
        # da_cut = pd.cut(da,k,labels=range(k))
        # print(da_cut)
        # da = da_cut
        # print(da)

        data_cut1 = []
        data_cut1 = pd.cut(data,k,labels=range(k))

        print(data_cut1)
        lis[int(n) - 1][1:] = data_cut1
        print(lis[int(n) - 1])
        print(lis)


    # 等宽法
    # d1 = pd.cut(data, k, labels=range(k))  # 等宽离散化，各个类次命名为0,1,2,3
    # print(d1)


def readincol():
    lis_col = []
    print("按列读取表格数据")
    print("请输入文件名：")
    filename=input("filename:")
    workbook = xlrd.open_workbook(filename)
    print("该文件中sheet表的名称列表如下：")
    print(workbook.sheet_names())
    print("请输入sheet名：")
    sheetname=input("sheetname:")
    sheet = workbook.sheet_by_name(sheetname)
    for j in range(sheet.ncols):
        lis_col.append(sheet.col_values(j))
    print("原始表格数据按列存储为列表形式如下：")
    print(lis_col)
    return lis_col

def saveExcel(list):
    Lis_end = []
    Lis_end = list
    print("经过多次处理此时的sheet表的列数为：")
    col = input("col:")
    print("经过多次处理此时的sheet表的行数为：")
    row = input("row:")
    print("将数据写入新的Excel表格")
    wb = xlwt.Workbook(encoding='utf-8')
    print("请输入文件保存的sheet表名称")
    newname = input("newname:")
    worksheet = wb.add_sheet(newname)

    for i in range(int(col)):
        for j in range(int(row)):
            worksheet .write(j, i, Lis_end[i][j])
            j  = 1
        i  = 1
    print("请输入保存的文件名(请注意不能和之前的文件名重复）")
    newfile = input("newfile:")
    wb.save(newfile)
    print("最终数据写入新的表格\n")

if __name__ == '__main__':
    Lianxu_Lisan1()