import pandas as pd
data = [[2, 0, 0, 0, 0],
[6, 100, 378.798387, 379.551740, 378.045034],
[4, 300, 860.925874, 861.562822, 860.288927]]
col = ['Step', 'LR', 'MEAN', 'UCL', 'LCL']
pdCalSort = pd.DataFrame(data = data, columns = col)
data = [[2, 0, 0, 0, 0, 0, 0],
[6, 100, 379.306452, 379.354839, 379.411290, 379.478495, 379.629032],
[4, 300, 860.914336, 860.958042, 860.905594, 860.982517, 861.090909]]
col = ['Step', 'LR', '1', '2', '3', '4', '5']
pdSort = pd.DataFrame(data = data, columns = col)
stepData = pdCalSort.iloc[:, 0]
uclData = pdCalSort.iloc[:, 3]
lclData = pdCalSort.iloc[:, 4]
compData = pdSort.iloc[:, 2:7]
print(pdCalSort)
print(pdSort)
print(stepData)
print(uclData)
print(lclData)
print(compData)
for colNum in compData.columns:
print('colNum : {}'.format(colNum))
index = 0
for comp in compData[colNum]:
# print(comp)
lcl = lclData[index]
ucl = uclData[index]
print(lcl)
print(type(lcl))
if comp < lcl:
print('step: ' + str(stepData[index]) + ', col: ' + colNum + ', COMP: ' + str(comp) + ', LCL: ' + str(lcl) + ', value hunting comp가 lcl보다 작다.')
if comp > ucl:
print('step: ' + str(stepData[index]) + ', col: ' + colNum + ', COMP: ' + str(comp) + ', UCL: ' + str(ucl) + ', value hunting comp가 ucl보다 크다.')
index = index + 1
123
2024. 1. 18. 23:56