import pandas as pd
import calendar
def change_date(date):#将日期转化为时间戳
date_list = date.replace(',', '').split(' ')
num_date = str(list(calendar.month_name).index(date_list[0])) + '-' + date_list[1] + '-' + date_list[2]
timeArray = time.strptime(num_date, "%m-%d-%Y")
timeStamp = int(time.mktime(timeArray))
return timeStamp
def sort_save(filename):#传入的参数是文件的名称,程序负责排好序并保存
mydf = pd.read_csv(filename, encoding='utf-8', error_bad_lines=False)
mydf.insert(0, 'timeStamp', value=None)
for i in range(len(mydf)):
mydf.at[i, 'timeStamp'] = save_content.change_date(mydf.at[i,'date'])
mydf.sort_values(by=['timeStamp'], ascending=False, inplace=True)
mydf = mydf.iloc[:, 1:]#‘,’ 前的部分标明选取的行,‘,’后的部分标明选取的列
mydf.to_csv(filename, encoding='utf-8', index=False)
print("排序完成")