/Python/Split datetime to date and time pandas

Split datetime to 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

107 votes183 views6 answers
Python rename columns
Python
0 vote218 views1 answer
How to find the ascii value of character in python
Python
1 vote194 views2 answers
Django class based views
Python
5 votes202 views2 answers
Numpy print full array
Python
0 vote197 views1 answer
Make screen shot of specific part of screen python
Python
0 vote172 views1 answer
Fullscreen cmd with python
Python
0 vote208 views1 answer
Python euler
Python
33 votes181 views4 answers
Python check folder exist
Python
15 votes206 views3 answers
Divide list into equal parts python
Python
13 votes193 views4 answers
How to call a python script from another python script
Python