/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 vote272 views1 answer
Perform a right outer join of self and other.
Python
0 vote263 views1 answer
Create a django and react readonly web app
Python
0 vote274 views1 answer
Python tuple multiply sequence
Python
0 vote263 views1 answer
Python select columns with no na
Python
4 votes279 views3 answers
Python get os
Python
13 votes240 views2 answers
Try catch if else python
Python
81 votes280 views6 answers
Loop in python
Python
32 votes262 views1 answer
How to add a column to a pandas df
Python
0 vote272 views1 answer
How to implement dfa in python
Python
9 votes335 views5 answers
Get dummies pandas
Python