# 变成年月日时分秒
XJ = pd.to_datetime(data_dd["新建时间"],format="%Y/%m/%d %H:%M:%S")defgetMonth(time):# 获取月份
a =(time.dt.month.astype(float)).tolist()return a
defgetDay(time):# 获取日
a =(time.dt.day.astype(float)).tolist()return a
defgetHoure(time):# 获取小时
a =(time.dt.hour.astype(float)).tolist()return a
defgetMinute(time):# 获取分钟数
a =(time.dt.minute.astype(float)).tolist()return a
defgetYear(time):
a =(time.dt.year.astype(float)).tolist()return a
train["month"]= getMonth(Ptakeoff)
train["day"]= getDay(Ptakeoff)
train['year']= getYear(Ptakeoff)# 变成年月日
data1['时间']= pd.to_datetime(data1['时间'], errors='coerce')
data1['时间']= data1['时间'].dt.normalize()
data1['year']= data1['时间'].dt.year
a = data1['时间'].dt.month
data1["month"]=a
data1['day']= data1['时间'].dt.dayofyear
data1['weekday']= data1['时间'].dt.weekday # 0-6
字符串时间类型与时间戳之间互转
#设a为字符串import time
a ="2011-09-28 10:00:00"#中间过程,一般都需要将字符串转化为时间数组
time.strptime(a,'%Y-%m-%d %H:%M:%S')>>time.struct_time(tm_year=2011, tm_mon=9, tm_mday=27, tm_hour=10, tm_min=50, tm_sec=0, tm_wday=1, tm_yday=270, tm_isdst=-1)#将"2011-09-28 10:00:00"转化为时间戳
time.mktime(time.strptime(a,'%Y-%m-%d %H:%M:%S'))>>1317091800.0#将时间戳转化为localtime
x = time.localtime(1317091800.0)
time.strftime('%Y-%m-%d %H:%M:%S',x)#获取当前日期
time.strftime("%Y-%m-%d")>>>'2015-03-13'#获取当前时间
time.strftime("%Y-%m-%d %H:%M:%S")>>>'2015-03-13 20:26:22'