Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Latest commit

 

History

History
History
42 lines (31 loc) · 892 Bytes

File metadata and controls

42 lines (31 loc) · 892 Bytes
Copy raw file
Download raw file
Edit and raw actions
@author jackzhenguo
@desc 格式化Pandas的时间列
@tag
@version 
@date 2020/03/29

第191个小例子: 格式化Pandas的时间列

import pandas as pd 
from datetime import datetime, time 

def series_dt_fmt(s:pd.Series,fmt:str)-> pd.Series: 
        """
        根据fmt格式,格式化s列
        s列是datetime 或者 datetime的str类型,如'2020-12-30 11:44:00' 
        """
        st = pd.to_datetime(s)
        return st.apply(lambda t: datetime.strftime(t,fmt))

别看只有两行代码,却能实现更加丰富的功能,相比pandas,支持直接返回时分等格式:

s = pd.Series(['2020-12-30 11:44:00','2020-12-30 11:20:10'])

# 只保留时分
fmt = '%H:%M'
series_dt_fmt(s,fmt)

# 输出结果
0    11:44
1    11:20
dtype: object
[上一个例子](190.md) [下一个例子](192.md)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.