2023年7月26日发(作者：)

PYTHON——⾃然间断点分级法PYTHON——⾃然间断点分级法import xlrdimport xlwtimport jenkspy#输⼊⽂件Table= _workbook("D:dxkjtest因⼦.xlsx")#打印Table相关信息print(_names())sheet1 = ()[0]print(,, )print(_values(1))f = ok()#遍历Table的每个sheetfor k in range(0,len(())): sheetSave = _sheet(()[k].name,cell_overwrite_ok = True) sheet = ()[k] #遍历sheet的列数据

从第⼆列开始 for j in range(1,): col = _values(j) List = col[1:len(col)] newList=col[1:len(col)] () nn=int(len(col)*0.025) del newList[0:nn] del newList[0-nn:] ListID = col[1:len(col)]#对类别进⾏标识 # print(ListID) #计算间断点 breaks = _breaks(newList,nb_class = 5) #根据计算的间断点，判断每个原始数据属于哪个类别 print(breaks) for i in range(len(List)): if List[i] >5: print(List[i] ) if List[i] < breaks[1]: ListID[i] = 1 elif List[i] < breaks[2] and List[i] >= breaks[1]: ListID[i] = 2 elif List[i] < breaks[3] and List[i] >= breaks[2]: ListID[i] = 3 elif List[i] < breaks[4] and List[i] >= breaks[3]: ListID[i] = 4 elif List[i] >= breaks[4]: ListID[i] = 5 else: ListID[i] = 5 for u in range(0,len(ListID)): # print(u,j) (u,j,ListID[u])#写数据 print(j,'------') print(k,'======')#保存数据成excel表(r'D:')