import pandas as pdfrom openpyxl import Workbook, load_workbookfrom openpyxl.styles import Alignment def extract_to_result(col_names, var_names): sdf = [] for col in col_names: sdf.append(eval(row[col]))# sdf = [shapes, dtypes, formats] for i in range(len(sdf)): if type(sdf[i]) == str: sdf[i] = sdf[i].split(' ') # print(sdf) for i in range(len(sdf[0])): for j in range(len(sdf)): value = sdf[j][i % len(sdf[j])] if type(value) == tuple: value = ','.join(map(str, value)) + ',' row[var_names[i % len(var_names)] + suffix[j % len(suffix)]] = valuefor index, row in two_df.iterrows(): extract_to_result(col_in, var_in) extract_to_result(col_out, var_out) extract_to_result(col_dyn, var_dyn) two_df.drop(labels=train_header, axis=1, inplace=True)two_df.to_excel('result_simple.xlsx', index=False)