现有以下数据样本:
id | relId | type | status | createTime | unsubTime |
---|---|---|---|---|---|
o08fMwZ_cy83ZcHp19wcCEmEed4M | o08fMwRWQKkM1oFjfmQaBlL9-zzg | sc | sub | 2019-10-15 14:25:22 | NaT |
o08fMwZ_fRkR2FfAszBsEK1iWr0c | o08fMwYD-KlsIANB9HlZVAT-WCBU | sc | sub | 2019-12-06 12:42:26 | 2019-12-06 12:43:58 |
o08fMwZ_MsInN8_crRmb0c4ydxhM | o08fMwQTERNE35DtNryoSUnMn_QM | sc | sub | 2019-10-15 23:13:55 | NaT |
o08fMwZ_tFK3EEjmD8zTwhd8BwCM | o08fMwTjeuJVRCAXslwnkIjOtH1M | sc | sub | 2019-10-29 09:07:14 | NaT |
o08fMwZ_woeoBFXQ88QAzy0f5Czs | o08fMwaVPaYNq8uSGTEX5WEoKJi0 | s | sub | 2019-10-28 15:17:29 | NaT |
相应的数据类型为:
需求:现今要将2019-10-15 14:25:22格式的数据格式化为2019-10-15
方法一:strftime( '%Y-%m-%d' )
data1['createTime']=data1['createTime'].apply(lambda x:x.strftime( '%Y-%m-%d' ))
弊端:类似于unsubTime字段含有NAT值的,则 此方法会报以下错误:
ValueError: NaTType does not support strftime
方法二:dt.date
此方法适用于unsubTime字段含有NAT值的情况:
data1['unsubTime']=data1['unsubTime'].dt.date