import os
import pandas as pd
from datetime import date
import time
today=str(date.today())
curdate=time.strftime('%Y-%m-%d',time.localtime())
curtime=time.strftime('%Y-%m-%d %H:%M:%S',time.localtime())
#格式化时间日期
# print(curdate)
# print(curtime)
downpath='/Users/kangyongqing/Downloads/'
lists=os.listdir(downpath)
print('未经处理的文件列表:\n %s'%lists)
lists.sort(key=lambda x:os.path.getmtime((downpath+x)) )
filenew=os.path.join(downpath,lists[-1])
print('时间排序后的文件列表:\n %s \n'%lists)
print('最新文件路径:\n%s'%filenew)
filename="文件%s"%curdate
# data=pd.read_csv(downpath+'20230526_105522.csv',dtype='object')
# data=pd.read_csv(filenew,dtype='object')
data=pd.read_csv(filenew,dtype={'老师id':'object','教师id':'object','班级id':'object','教师ID':'object','推荐老师id':'object','tutor_id':'object','tutor_user_id':'object','student_user_id':'object','id':'object','课堂id':'object','virtual_class_id':'object',
'学生id':'object','学员id':'object','student_id':'object','parent_id':'object','parent_user_id':'object','家长id':'object','trail_tutor_id':'object'})
# data=pd.read_csv(filenew)
data.to_excel(downpath+filename+'.xlsx',index=False)
print('现在时间是%s,任务已完成,请查收'%curtime)