Learn practical skills, build real-world projects, and advance your career
5 years ago
from xplan.pipe import *

datetime 格式定义

代码说明
%Y4位数的年
%y2位数的年
%m2位数的月[01,12]
%d2位数的日[01,31]
%H时(24小时制)[00,23]
%l时(12小时制)[01,12]
%M2位数的分[00,59]
%S秒[00,61]有闰秒的存在
%w用整数表示的星期几[0(星期天),6]
%F%Y-%m-%d简写形式例如,2017-06-27
%D%m/%d/%y简写形式

创建 ts

  • pd.timedelta_range
  • pd.date_range
pd.date_range(start='1/1/2018', periods=2, freq='s') # S
pd.date_range(start='1/1/2018', periods=2, freq='min') # Min
pd.date_range(start='2018-01-01', periods=2, freq='1h') # H
pd.date_range(start='2018-01-01', periods=2, freq='2d') # D
pd.date_range(start='2018-01-01', periods=2, freq='3w') # D
pd.date_range(start='2018-01-01', periods=2, freq='4m') # M
pd.date_range(start='2018-01-01', periods=2, freq='5y') # Y
pd.date_range(start=datetime.datetime.today(), periods=2, freq='d')
DatetimeIndex(['2018-01-01 00:00:00', '2018-01-01 00:00:01'], dtype='datetime64[ns]', freq='S')
DatetimeIndex(['2018-01-01 00:00:00', '2018-01-01 00:01:00'], dtype='datetime64[ns]', freq='T')
DatetimeIndex(['2018-01-01 00:00:00', '2018-01-01 01:00:00'], dtype='datetime64[ns]', freq='H')
DatetimeIndex(['2018-01-01', '2018-01-03'], dtype='datetime64[ns]', freq='2D')
DatetimeIndex(['2018-01-07', '2018-01-28'], dtype='datetime64[ns]', freq='3W-SUN')
DatetimeIndex(['2018-01-31', '2018-05-31'], dtype='datetime64[ns]', freq='4M')
DatetimeIndex(['2018-12-31', '2023-12-31'], dtype='datetime64[ns]', freq='5A-DEC')
DatetimeIndex(['2019-03-12 12:14:55.370025', '2019-03-13 12:14:55.370025'], dtype='datetime64[ns]', freq='D')

pd.Timestamp

  • pd.Timestamp('2019-03-12')
  • pd.Timestamp('2019/03/12')
  • pd.Timestamp('03/12/2019')
  • pd.Timestamp(pd.datetime.today())
  • pd.to_datetime(pd.datetime.today())

pd.Timedelta

  • pd.to_timedelta('1d') # pd.Timedelta

其他

pd.datetime # datetime.datetime pd.TimeGrouper pd.TimedeltaIndex pd.DateOffset pd.DatetimeIndex