pandas.dt(날짜 다루기)

data2=data

data2['year']=data2.사용일자/10000
data2['month']=(data2.사용일자%10000)//100
data2['day']=data2.사용일자%100

theday=pd.to_datetime(data2.사용일자,format='%Y%m%d')
#교재 426 (format)

 

 

ser=pd.Series(['2020-4-1','2020-4-2'])
ser=pd.to_datetime(ser)

ser.dt.year

data2['year']=theday.dt.year
data2['month']=theday.dt.month
data2['day']=theday.dt.day
wday={0:'월',1:'화',2:'수',3:'목',4:'금',5:'토',6:'일'}
data2['wday']=theday.dt.dayofweek.map(wday)

data2.tail()

 

set(range(1,32))-set(data2.day)

data2[data2.wday=='월'].head()