我认为您可以
to_datetime使用参数解析,
errors='coerce'然后将
strftime其转换为工作日作为语言环境的全名:
print df TRX_DATE some value0 2010-08-15 13:00:00 27.0651 2010-08-16 13:10:00 25.6102 2010-08-17 02:30:00 17.0003 2010-06-18 02:40:00 17.0154 2010-18-19 02:50:00 16.910df['TRX_DATE'] = pd.to_datetime(df['TRX_DATE'],errors='coerce')df['day_type'] = df['TRX_DATE'].dt.strftime('%A')print df TRX_DATE some value day_type0 2010-08-15 13:00:00 27.065 Sunday1 2010-08-16 13:10:00 25.610 Monday2 2010-08-17 02:30:00 17.000 Tuesday3 2010-06-18 02:40:00 17.015 Friday4 NaT 16.910 NaT
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)