def read_from_dir(cls, path, outexcel=False, outpath=None): files = os.listdir(path) if outexcel: moutexcel = Excel(outpath) moutexcel.new().append([[item, item] for item in files], "sheet1") moutexcel.close() else: return files
if re.match('^(-)?\d+((\.|.)\d+)?$',new_item) is not None: new_item = re.sub('.','.',new_item) new_row.append(float(new_item)) else: all = False new_row.append(item) return new_row,all if __name__ == '__main__': filename = r'E:\data\procedure\Process\reduction\data\admincode\2003.xls' acodefile = AdminCodeFile(filename) filename = r'E:\data\procedure\Process\reduction\data\2003_prefecture\3_3_按三次业人员就业状况_地级市_2003.xls' mexcel = WinExcel(filename) mdata = mexcel.read() reduction = CitydataReduction(mdata,acodefile) reduction.reduction() ndata = reduction.second_data print(reduction.second_data) outfile = r'd:\data\demo.xlsx' moutexcel = Excel(outfile) moutexcel.new().append(ndata, 'mysheet') moutexcel.close()
else: y += coefs[0]*x1 if coefs[2] in rules3: y += coefs[2]*np.log(x3) else: y += coefs[2]*x3 pdata[''.join(['y',str(i+1)])] = y result.append(one_student_coefs) pdata.to_excel(excel_writer = ''.join([out_path,student,file_name]),index=False) print(result) out_path = 'E:\\temp\\lab\\result.xlsx' mexcel = Excel(out_path) mexcel.new().append(result) mexcel.close() ''' # 1. 正态分布的随机数 mu, sigma = 0, 1 s = np.random.normal(mu, sigma, 1000) print(abs(mu - np.mean(s)) < 0.1, np.mean(s)) # 2. 生成数学表达式 x1 = np.random.randint(0,100,1000) print(np.mean(x1)) y = 2 + 3*x1 + s print(np.mean(y))
# 输出相关信息 print("-" * 30) if len(reduction.header) < 1: print("标题: ", "没有") else: print("标题: ", reduction.header[0]) print("Number of Rows: ", len(reduction.second_data)) for item in reduction.no_matched: print("Not Matched: ", item) for item in reduction.not_all_numeric: print("Not All Numeric: ", item) for item in reduction.no_matched_and_not_all_numeric: print("Not Matched and Not All Numeric: ", item) # for item in reduction.deleted_data: # print('Deleted Row: ',item) for item in reduction.remark: print("Remark: ", item) for item in reduction.others: print("Others: ", item) print("*" * 30) moutexcel = Excel(target_file) moutexcel.new().append(ndata, "sheet") moutexcel.close() """ moutexcel2 = Excel(delete_file) moutexcel2.new().append(reduction.deleted_data, 'sheet') moutexcel2.close()"""