处理最终效果
用于快速提取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')