AttributeError: Can only use .dt accessor with datetimelike values
Try
df['Date'] = pd.to_datetime(df['Date'], errors='coerce')
Use
import pandas as pd file = '/pathtocsv.csv' df = pd.read_csv(file, sep = ',', parse_dates= [col],encoding='utf-8-sig', usecols= ['Date', 'ids'],) df['Month'] = df['Date'].dt.month
df_Time_Table["Date"] = pd.to_datetime(df_Time_Table["Date"]) # Cal Year df_Time_Table['Year'] = df_Time_Table['Date'].dt.strftime('%Y')
You need to login first then you can post Your Answer Log in Sign up
Copyright © 2021 Dtuto.Com