remove time conversion in the column. Error: Can only use .dt accessor with datetimelike values

Asked Jul 21 '22 at 04:47

Active Jul 21 '22 at 04:53

Viewed 13 times

I have time column that looks like the one that I attached below. How to remove +0600 conversion I appreciate your help I tried

clean['event_time_selected_timezone'] = clean['event_time_selected_timezone'].dt.tz_localize(None)

But it gives Can only use .dt accessor with datetimelike values Error

edited Jul 21 '22 at 04:53

asked Jul 21 '22 at 04:47

YanRemes

First convert column to datetimes. – jezrael Jul 21 '22 at 04:54
It gives this error Try using .loc[row_indexer,col_indexer] = value instead – YanRemes Jul 21 '22 at 04:57
`clean['event_time_selected_timezone'] = pd.to_datetime(clean['event_time_selected_timezone'])` return error? – jezrael Jul 21 '22 at 04:58
Yes, this error SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead – YanRemes Jul 21 '22 at 05:01
There is some filtering in your code? – jezrael Jul 21 '22 at 05:03
oh thank you. Now I don't have +0600, instead I have 2022-07-11 00:00:14.10400. How do I keep only 2022-07-11 00:00:14 – YanRemes Jul 21 '22 at 05:07
1

try `clean['event_time_selected_timezone'] = clean['event_time_selected_timezone'].dt.tz_localize(None).dt.floor('S')` – jezrael Jul 21 '22 at 05:08

0 Answers0