/Python/Hwo to separate datetime column into date and time pandas

Hwo to separate datetime column into date and time pandas

import pandas as pd
df = pd.read_csv(file_path)

df['Dates'] = pd.to_datetime(df['date']).dt.date
df['Time'] = pd.to_datetime(df['date']).dt.time

Source: stackoverflow.com

Split datetime to date and time pandas

df = pd.DataFrame({'my_timestamp': pd.date_range('2016-1-1 15:00', periods=5)})

>>> df
         my_timestamp
0 2016-01-01 15:00:00
1 2016-01-02 15:00:00
2 2016-01-03 15:00:00
3 2016-01-04 15:00:00
4 2016-01-05 15:00:00

df['new_date'] = [d.date() for d in df['my_timestamp']]
df['new_time'] = [d.time() for d in df['my_timestamp']]

>>> df
         my_timestamp    new_date  new_time
0 2016-01-01 15:00:00  2016-01-01  15:00:00
1 2016-01-02 15:00:00  2016-01-02  15:00:00
2 2016-01-03 15:00:00  2016-01-03  15:00:00
3 2016-01-04 15:00:00  2016-01-04  15:00:00
4 2016-01-05 15:00:00  2016-01-05  15:00:00

Source: stackoverflow.com

Similar codes

0 vote176 views1 answer
Django.core.exceptions.FieldError: 'date' cannot be specified for Forum model form as it is a non-editable field
Python
0 vote171 views1 answer
Leetcode python
Python
0 vote178 views1 answer
While attempts > 0:
Python
1 vote201 views1 answer
Barplot syntax in python
Python
1 vote216 views1 answer
How to redirect to previous page in django
Python Django
0 vote211 views1 answer
Membuat chat bot dengan python
Python
0 vote182 views1 answer
Python for comparing url path
Python
24 votes180 views2 answers
How to search for element in list python
Python
15 votes177 views4 answers
Float to int in python
Python
0 vote175 views1 answer
Determinant of 3x3 numpy
Python