import pandas as pd
data_time = pd.read_csv("demo.csv",engine='python',encoding='gbk')
data_time["日期"]=pd.to_datetime(data_time['准确日期'], format='%Y-%m-%d', errors='coerce')
data_time.head()
data_time['年月'] = data_time['日期'].apply(lambda x: x.strftime("%Y-%m"))
data_time.head()
data_time["月"] = data_time['日期'].apply(lambda x: x.month)
data_time['天'] = data_time['日期'].apply(lambda x:x.day)
data_time.head()
data_time['星期']=data_time['日期'].apply(lambda x:x.weekday()+1)
data_time.head()
具体: