1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| import os
final_df = pd.DataFrame()
txt_folder = 'data/参考数据集/'
for subdir in range(1,11): subpath = os.path.join(txt_folder,str(subdir)) for filename in os.listdir(subpath): if filename.endswith('.txt'): txt_file_path = os.path.join(subpath,filename) data_np = np.loadtxt(txt_file_path) data_np = data_np.T data_df = pd.DataFrame(data_np) data_df.to_excel(txt_file_path.replace('.txt', '.xlsx'), index=False) print("数据已导入到Excel文件")
|