非原创,参考了几篇文章
import pandas as pd
import csv
data = pd.read_csv(r'C:\Users\刀刀\Desktop\次数\0729.csv')
a = data['delta E']
b = data['times']
if __name__ == '__main__':
scores = b
ages = a
arr = list(zip(ages, scores))
arr.sort(key=lambda x: (x[0], x[1]))
print(arr)
column = ['delta E', 'times'] # 列表头名称#
test = pd.DataFrame(columns=column, data=arr) # 将数据放进表格
test.to_csv(r'C:\Users\刀刀\Desktop\ΔE次数1s\0729.csv') # 数据存入csv,存储位置及文件名称