import pandas as pd
import matplotlib.pyplot as plt



name_list = [
    'throughput_connectivity',
    'throughput_el_remaining',
    'throughput_scale',
    'throughput_successPro',
    'throughput_workload',    
    'waiting_connectivity',
    'waiting_el_remaining',
    'waiting_scale',
    'waiting_successPro',
    'waiting_workload',
    'waste_connectivity',
    'waste_el_remaining',
    'waste_scale',
    'waste_successPro',
    'waste_workload'
]

for txt_name in name_list:
    print(txt_name)
    file_path = f'./data/experiment_data/{txt_name}.txt'
    data = pd.read_csv(file_path)

    # 将数据存储到Excel文件中
    data.to_excel(f'./data/data_to_excel/{txt_name}.xlsx', index=False)