|
- import os
- os.chdir('csv')
- data_list = []
- title_list = ['Threads', 'Sample', 'Average/ms', 'Median/ms', '90%Line/ms', 'Error%', 'Thougtput/sec', 'kb-sec']
- data_list.append(title_list)
- for fn in os.listdir('.'):
- with open(fn) as f:
- temp_list1 = []
- temp_list1.append(f.readline().split(',')[0])
- temp_list2 = f.readline().strip().split(',')
- temp_list1.extend(temp_list2[1:5])
- temp_list1.extend(temp_list2[9:11])
- temp_list1.append(temp_list2[12])
- data_list.append(temp_list1)
- with open('result.csv', 'w') as f:
- f.writelines([','.join(item) + '\n' for item in zip(*data_list)])
复制代码
说明:我是把所有源文件放到一个名为csv的文件夹中,这个脚本应该和csv文件夹处于同级目录下。 |
|