Loading [MathJax]/extensions/tex2jax.js

IT Learning

Python
0

【Python】Transforming datetime to date and time with pandas dateframe

by SEBONE · 2020年7月1日

Table of Contents

Original Data

This code is to make sample dataframe.

import pandas as pd
import datetime as dt
 
df = pd.DataFrame([dt.datetime(2020,6,1,0,0,0),dt.datetime(2020,6,2,10,0,0),dt.datetime(2020,6,3,15,0,0)],columns=['datetimes'])

&#12288;&#12288;&#12288;&#12288;datetimes
0   2020-06-01 00:00:00
1   2020-06-02 10:00:00
2   2020-06-03 15:00:00

Transforming dataframe to date and time.

It can realize to use lambda & apply functions like following.

df['dates'] = df['datetimes'].apply(lambda x : dt.date(x.year,x.month,x.day))
df['times'] = df['datetimes'].apply(lambda x : dt.time(x.hour,x.minute,x.second))

&#12288;&#12288;&#12288;&#12288; datetimes  &#12288;&#12288;&#12288;&#12288; dates&#12288;&#12288;  times
0   2020-06-01 00:00:00 2020-06-01  00:00:00
1   2020-06-02 10:00:00 2020-06-02  10:00:00
2   2020-06-03 15:00:00 2020-06-03  15:00:00

If you want to get with string, these code is better.

df['dates'] = df['datetimes'].apply(lambda x : x.strftime('%Y/%m/%d'))
df['times'] = df['datetimes'].apply(lambda x : x.strftime('%H:%M:%S'))

    datetimes           dates           times
0   2020-06-01 00:00:00 2020/06/01  00:00:00
1   2020-06-02 10:00:00 2020/06/02  10:00:00
2   2020-06-03 15:00:00 2020/06/03  15:00:00

You may also like...

Leave a Reply Cancel reply