2022/06/12-2022/06/14 Python处理数据
2022/6/15 5:20:17
本文主要是介绍2022/06/12-2022/06/14 Python处理数据,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
2022.06.12
import csv,sys,os import matplotlib.pyplot as plt def read(filename): # filename='Tcam V5 5.csv' csv_reader = csv.reader(open(filename,encoding='utf-8')) ls1 = [205+66*i for i in range(31)] ls2 = [214+66*i for i in range(31)] n = 0 flag = False tmp,res = [],[] for row in csv_reader: n += 1 if n > 2205: break if n in ls1: # print(row[2]) flag = True if n-1 in ls2: flag = False # print(sum(tmp)/len(tmp)) res.append(sum(tmp)/len(tmp)) tmp = [] if flag: tmp.append(float(row[3])) with open(filename+'.dat','w') as f: for i in res: f.write(str(i) + '\n') return res # filename='Tcam V5 5.csv' # print(read(filename)) for i in os.listdir(): tmp = i.split() # print(tmp) if tmp[-1].split('.')[-1] == 'csv' and tmp[0] == 'Tcam': read(i)
2022.06.14
import matplotlib.pyplot as plt import numpy as np import xlrd,sys,os import xlwt as ExcelWrite import xlsxwriter filename = 'Eng_Sweep_IdVg_220609_095907.xlsx' data = xlrd.open_workbook(filename) # print(data.sheet_names()) table = data.sheet_by_name('Sheet1') # V = table.row_values(2) V = table.col_values(2) I = table.col_values(3) tmp = 7 ls = [] for i in range(1,513): ls.append(tmp) if i%8 == 0: tmp += 108 else: tmp += 114 # print(ls) resV1,resV2,resV3 = [],[],[] resV4,resV5,resV6 = [],[],[] resV7,resV0 = [],[] resI1,resI2,resI3 = [],[],[] resI4,resI5,resI6 = [],[],[] resI7,resI0 = [],[] for i,j in enumerate(ls): if i%8 == 0: resV0.append(V[j-1:j+50]) resI0.append(I[j-1:j+50]) elif i%8 == 1: resV1.append(V[j-1:j+50]) resI1.append(I[j-1:j+50]) elif i%8 == 2: resV2.append(V[j-1:j+50]) resI2.append(I[j-1:j+50]) elif i%8 == 3: resV3.append(V[j-1:j+50]) resI3.append(I[j-1:j+50]) elif i%8 == 4: resV4.append(V[j-1:j+50]) resI4.append(I[j-1:j+50]) elif i%8 == 5: resV5.append(V[j-1:j+50]) resI5.append(I[j-1:j+50]) elif i%8 == 6: resV6.append(V[j-1:j+50]) resI6.append(I[j-1:j+50]) elif i%8 == 7: resV7.append(V[j-1:j+50]) resI7.append(I[j-1:j+50]) workbook = xlsxwriter.Workbook('res.xlsx') num = len(resV0)*len(resV0[0]) worksheet0 = workbook.add_worksheet('res0') row,col = 0,0 for i in range(len(resV0)): for j in range(len(resV0[0])): worksheet0.write(row,col,resV0[i][j]) worksheet0.write(row,col+1,resI0[i][j]) row += 1 worksheet1 = workbook.add_worksheet('res1') row,col = 0,0 for i in range(len(resV0)): for j in range(len(resV0[0])): worksheet1.write(row,col,resV1[i][j]) worksheet1.write(row,col+1,resI1[i][j]) row += 1 worksheet2 = workbook.add_worksheet('res2') row,col = 0,0 for i in range(len(resV0)): for j in range(len(resV0[0])): worksheet2.write(row,col,resV2[i][j]) worksheet2.write(row,col+1,resI2[i][j]) row += 1 worksheet3 = workbook.add_worksheet('res3') row,col = 0,0 for i in range(len(resV0)): for j in range(len(resV0[0])): worksheet3.write(row,col,resV3[i][j]) worksheet3.write(row,col+1,resI3[i][j]) row += 1 worksheet4 = workbook.add_worksheet('res4') row,col = 0,0 for i in range(len(resV0)): for j in range(len(resV0[0])): worksheet4.write(row,col,resV4[i][j]) worksheet4.write(row,col+1,resI4[i][j]) row += 1 worksheet5 = workbook.add_worksheet('res5') row,col = 0,0 for i in range(len(resV0)): for j in range(len(resV0[0])): worksheet5.write(row,col,resV5[i][j]) worksheet5.write(row,col+1,resI5[i][j]) row += 1 worksheet6 = workbook.add_worksheet('res6') row,col = 0,0 for i in range(len(resV0)): for j in range(len(resV0[0])): worksheet6.write(row,col,resV6[i][j]) worksheet6.write(row,col+1,resI6[i][j]) row += 1 worksheet7 = workbook.add_worksheet('res7') row,col = 0,0 for i in range(len(resV0)): for j in range(len(resV0[0])): worksheet7.write(row,col,resV7[i][j]) worksheet7.write(row,col+1,resI7[i][j]) row += 1 workbook.close()
这篇关于2022/06/12-2022/06/14 Python处理数据的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-12-24Python编程入门指南
- 2024-12-24Python编程基础入门
- 2024-12-24Python编程基础:变量与数据类型
- 2024-12-23使用python部署一个usdt合约,部署自己的usdt稳定币
- 2024-12-20Python编程入门指南
- 2024-12-20Python编程基础与进阶
- 2024-12-19Python基础编程教程
- 2024-12-19python 文件的后缀名是什么 怎么运行一个python文件?-icode9专业技术文章分享
- 2024-12-19使用python 把docx转为pdf文件有哪些方法?-icode9专业技术文章分享
- 2024-12-19python怎么更换换pip的源镜像?-icode9专业技术文章分享