/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

3 votes95 views1 answer
Replace multiple values in pandas column
Python
40 votes98 views3 answers
Python push to dataframe pandas
Python
59 votes102 views3 answers
Join() python
Python
11 votes102 views2 answers
Add reaction discord.py
Python
12 votes62 views3 answers
Write list to text file python
Python
0 vote110 views1 answer
Flask decoding base 64 image
Python
2 votes104 views1 answer
Read a csv file in pandas
Python
7 votes106 views2 answers
How to get index of pandas dataframe python
Python
3 votes104 views3 answers
Get every nth element in list python
Python
0 vote98 views1 answer
Var person
Python