HDLAB_experiment data processing BY python

处理最终效果

用于快速提取csv文件，同时导入到各个Excel文件夹里

Mathcad 数据处理结果见 数据处理

1、linear

2、output

3、saturation

CODE

'''----------------------------------------------------------
Filename				:	data_deal
Author					:	deilt_cjr
Description				:	Linea、ouput、saturation data used to produce
Called by				:	
Revision History		:	10/21/2022
                            Revison 1.0
Email					:	cjdeilt@qq.com
Company:Deilt Technology.INC
Copyright(c) 1999, Deilt Technology Inc, All right reserved
--------------------------------------------------------------
'''
import  os
import  openpyxl
import  csv
import  pandas as pd
import  numpy as np
from requests import head

#工作文件夹
path = r"D:\资料\实验\data\处理模板\python_data\new"
os.chdir(path)  # 修改工作路径

#linear，output，saturation 原csv文件 需要修改
linear_csv_path = r"D:\资料\实验\data\处理模板\python_data\new\Ntype linear [(1) _Ni longtime 1-1 annealing after process_; 9_6_2022 9_16_34 AM].csv"
output_csv_path = r"D:\资料\实验\data\处理模板\python_data\new\Ntype output [(1) _Ni longtime 1-1 annealing after process_; 9_6_2022 9_09_38 AM].csv"
saturation_csv_path = r"D:\资料\实验\data\处理模板\python_data\new\Ntype saturation [(1) _Ni longtime 1-1 annealing after process_; 9_6_2022 9_11_21 AM].csv"

#----------------------------------------------------------------------------------
#打开linear csv文件获取数据
list_x1 = []
linear_data = pd.read_csv(linear_csv_path,skiprows=259,nrows=801,header=None)
linear_data_value = linear_data.values
list_x1.append(linear_data_value)
print(linear_data)
print(list_x1)

#将linear数据写入excel，保存为linear.xlsx,sheet为linear
linear_data.to_excel('linear.xlsx',index=False,sheet_name='linear',header=None)

#修改excel里面的数据
workbook = openpyxl.load_workbook('linear.xlsx')  # 返回一个workbook数据类型的值
sheet = workbook['linear'] 
#sheet.delete_rows(idx=10)           # 删除第10行
sheet.delete_cols(idx=1)  # 删除第2列
sheet.delete_cols(idx=2)  # 删除第3列
sheet.delete_cols(idx=3)  # 删除第4列
#sheet.delete_cols(idx=6)  # 删除第1列

#保存退出
workbook.save('linear.xlsx')  


#-------------------------------------------------------------------------
#打开output csv文件获取数据
list_x2 = []
output_data = pd.read_csv(output_csv_path,skiprows=259,nrows=806,header=None)
output_data_value = output_data.values
print(output_data)

#切片获取5个Id
Id1 = output_data.iloc[0:162,1]
Id11 = output_data.iloc[0:162,3]

Id2 = output_data.iloc[162:323,1]
Id22 = output_data.iloc[162:323,3]
Id22.index=list(range(1,162))



Id3 = output_data.iloc[323:484,1]
Id33 = output_data.iloc[323:484,3]
Id33.index=list(range(1,162))

Id4 = output_data.iloc[484:645,1]
Id44 = output_data.iloc[484:645,3]
Id44.index=list(range(1,162))

Id5 = output_data.iloc[645:810,1]
Id55 = output_data.iloc[645:810,3]
Id55.index=list(range(1,162))

#合并为一个
VgId= pd.concat([Id1,Id11,Id22,Id33,Id44,Id55],axis=1)
print(VgId)


VgId.to_excel('output.xlsx',index=False,sheet_name='output',header=None,startcol=0)

print(Id1)
print(Id11)
print(Id22)


#修改excel里面的数据
workbook1 = openpyxl.load_workbook('output.xlsx')  # 返回一个workbook数据类型的值
sheet1 = workbook1['output'] 
#sheet1.delete_cols(idx=1)  
#sheet1.delete_cols(idx=2)  
#sheet1.delete_cols(idx=3)  
#wk_sheet.cell(row=2,column=2,value='大区') #在第二行，第二列下入“大区”数值
sheet1.cell(row=1,column=3,value='Id') #在第二行，第二列下入“大区”数值
sheet1.cell(row=1,column=4,value='Id')
sheet1.cell(row=1,column=5,value='Id')
sheet1.cell(row=1,column=6,value='Id')


workbook1.save('output.xlsx')  


#-----------------------------------------------------------------------
#打开output csv文件获取数据
list_x3 = []
saturation_data = pd.read_csv(saturation_csv_path,skiprows=258,nrows=162,header=None)
saturation_data_value = saturation_data.values
#print(saturation_data)

#将linear数据写入excel
saturation_data.to_excel('saturation.xlsx',index=False,sheet_name='saturation',header=None)

#修改excel里面的数据
workbook2 = openpyxl.load_workbook('saturation.xlsx')  # 返回一个workbook数据类型的值
sheet2 = workbook2['saturation'] 
sheet2.delete_cols(idx=1)  
sheet2.delete_cols(idx=2,amount=3)  

workbook2.save('saturation.xlsx')