import pandas as pd
input_filepath='input.xlsx'
output_file='output.xlsx'# 读取数据
query_df=pd.read_excel(input_filepath)
# 表头
result_df = pd.DataFrame(columns=['question', 'answer'])for index, row in query_df.iterrows():question=row['question']answer=row['answers']result_df.loc[len(result_df)] = [question, answer]result_df.to_excel(output_file, index=False)