import pandas as pd
import os
# 导入Excel表格
df = pd.read_excel('SSQ.xlsx')
# 分析数据
result = []
for i in range(len(df)):
row = df.iloc[i]
new_data = []
for j in range(1, 8):
if j <= 6:
# 分析第一列到第六列的数据
value = row[j]
if value < 1 or value > 33:
value = None
else:
# 分析第七列的数据
value = row[j]
if value < 1 or value > 16:
value = None
new_data.append(value)
result.append(new_data)
# 输出结果
result_df = pd.DataFrame(result, columns=['Column1', 'Column2', 'Column3', 'Column4', 'Column5', 'Colum