python 保存 excel file IPA data

import pandas
import matplotlib.pyplot as plt

data = pandas.read_excel(‘IPA2_hulkDE.xlsx’)
print(data.columns)
ParameterList =[‘TOPOFIMAGE_DEVIATION’, ‘TOPOFIMAGE_SKEW’,
‘LEFTOFIMAGE_DEVIATION’, ‘LEFTOFIMAGE_SKEW’, ‘HORIZONTAL_PARALLELISM’,
‘VERTICAL_PARALLELISM’, ‘IMAGE_STRETCH_PROCESS’, ‘IMAGE_STRETCH_SCAN’]
summary_before = data.pivot_table(index=[‘Device’, ‘Environment’, ‘Mode’,‘PAGE_SIDE’],
values=[“A”, ‘B’, ‘C’, ‘D’, ‘E’, ‘F’, ‘G’, ‘H’, ‘TOPOFIMAGE_DEVIATION’, ‘TOPOFIMAGE_SKEW’,
‘LEFTOFIMAGE_DEVIATION’, ‘LEFTOFIMAGE_SKEW’, ‘HORIZONTAL_PARALLELISM’,
‘VERTICAL_PARALLELISM’, ‘IMAGE_STRETCH_PROCESS’, ‘IMAGE_STRETCH_SCAN’])
TOPOFIMAGE_DEVIATION = []
TOPOFIMAGE_SKEW = []
LEFTOFIMAGE_DEVIATION = []
LEFTOFIMAGE_SKEW = []
HORIZONTAL_PARALLELISM = []
VERTICAL_PARALLELISM = []
IMAGE_STRETCH_PROCESS = []
IMAGE_STRETCH_SCAN = []
TLXm = []
TLYm = []
TRYm =[]
BLXm = []
TRXm = []
BLYm = []
BRXm = []
BRYm = []
for index,r in data.iterrows():
TLX = r.C
TLY = r.B
TRY = r.A
BLX = r.D
if r[‘Media Size’]== ‘A4’:
TRX = 210 - r[‘H’]
BLY = 297 - r[‘B’]
BRX = 210 - r[‘G’]
BRY = 297 - r[‘F’]
else:
TRX = 216 - r[‘H’]
BLY = 279 - r[‘B’]
BRX = 216 - r[‘G’]
BRY = 279 - r[‘F’]
TLXm.append(TLX)
TLYm.append(TLY)
TRYm.append(TRY)
BLXm.append(BLX)
TRXm.append(TRX)
BLYm.append(BLY)
BRXm.append(BRX)
BRYm.append(BRY)
TOPOFIMAGE_DEVIATION.append((r[‘A’]+r[‘B’])/2-12.7)
TOPOFIMAGE_SKEW.append((r[‘A’] - r.B) / (TRX - TLX) * 100)
LEFTOFIMAGE_DEVIATION.append((r.C + r.D) / 2 - 12.7)
LEFTOFIMAGE_SKEW.append((r.C - r.D) / (BLY - TLY) * 100)
HORIZONTAL_PARALLELISM.append(((BRY - TRY) - (BLY - TLY)) / (TRX - TLX) * 100)
VERTICAL_PARALLELISM.append(((BRX - BLX) - (TRX - TLX)) / (BLY - TLY) * 100)
if r[‘Media Size’]== ‘A4’:
STRETCH_PROCESS = (((BRY - TRY) + (BLY - TLY)) / 2 - (297 - 25.4)) / (297 - 25.4) * 100
STRETCH_SCAN = (((TRX - TLX) + (BRX - BLX)) / 2 - (210 - 25.4)) / (210 - 25.4) * 100
else:
STRETCH_PROCESS = (((BRY - TRY) + (BLY - TLY)) / 2 - (279 - 25.4)) / (279 - 25.4) * 100
STRETCH_SCAN = (((TRX - TLX) + (BRX - BLX)) / 2 - (216 - 25.4)) / (216 - 25.4) * 100
IMAGE_STRETCH_PROCESS.append(STRETCH_PROCESS)
IMAGE_STRETCH_SCAN.append(STRETCH_SCAN)
data.TOPOFIMAGE_DEVIATION=TOPOFIMAGE_DEVIATION
data.TOPOFIMAGE_SKEW=TOPOFIMAGE_SKEW
data.LEFTOFIMAGE_DEVIATION=LEFTOFIMAGE_DEVIATION
data.LEFTOFIMAGE_SKEW=LEFTOFIMAGE_SKEW
data.HORIZONTAL_PARALLELISM=HORIZONTAL_PARALLELISM
data.VERTICAL_PARALLELISM=VERTICAL_PARALLELISM
data.IMAGE_STRETCH_PROCESS=IMAGE_STRETCH_PROCESS
data.IMAGE_STRETCH_SCAN=IMAGE_STRETCH_SCAN
data.TLX = TLXm
data.TLY = TLYm
data.TRY =TRYm
data.BLX = BLXm
data.TRX = TRXm
data.BLY = BLYm
data.BRX = BRXm
data.BRY = BRYm
print(data)
summary_after = data.pivot_table(index=[‘Device’, ‘Environment’, ‘Mode’,‘PAGE_SIDE’],
values=[“A”, ‘B’, ‘C’, ‘D’, ‘E’, ‘F’, ‘G’, ‘H’, ‘TOPOFIMAGE_DEVIATION’, ‘TOPOFIMAGE_SKEW’,
‘LEFTOFIMAGE_DEVIATION’, ‘LEFTOFIMAGE_SKEW’, ‘HORIZONTAL_PARALLELISM’,
‘VERTICAL_PARALLELISM’, ‘IMAGE_STRETCH_PROCESS’, ‘IMAGE_STRETCH_SCAN’]
).sort_index(axis=0, ascending=False)
writer = pandas.ExcelWriter(‘IPA_output.xlsx’)
data.to_excel(writer,‘IPA_RawData’,float_format = ‘%.3f’)
summary_after.to_excel(writer,‘Summary_after’,float_format = ‘%.3f’)
summary_before.to_excel(writer,‘Summary_before’,float_format = ‘%.3f’)

fig,axes=plt.subplots(2,4)

ax1=axes[0,0]

ax2=axes[0,1]

ax3=axes[1,0]

ax1.hist(data.C-data.D)

ax1.set_title(‘TOPOFIMAGE_DEVIATION’)

ax2.hist(data.LEFTOFIMAGE_DEVIATION)

ax2.set_title(‘LEFTOFIMAGE_DEVIATION’)

plt.show()