数据分析之pandas.date_range

1
2
def date_range(start=None, end=None, periods=None, freq=None, tz=None,
normalize=False, name=None, closed=None, **kwargs):

参数:

  • start 开始时间
  • end 结束时间
  • periods 固定日期范围,整数
  • normalize 若参数为True表示将startend参数值正则化到午夜时间戳
  • name 生成时间索引对象名称
  • freq 日期偏移量,默认为D
别名 偏移量 说明
D/d Day 每日历日
B BusinessDay 每工作日
H/h Hour 每小时
T或min Minute 每分
S Secend 每秒
L或ms Milli 每毫秒(每千分之一秒)
U Micro 每微秒(即百万分之一秒)
M MonthEnd 每月最后一个日历日
BM BusinessDayEnd 每月最后一个工作

例1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
import pandas as pd
dates = pd.date_range(start="2018-10-01", end="2018-10-12")
dates1 = pd.date_range(start="2018-10-01", periods=6)
print(dates)
print(dates1)
DatetimeIndex(['2018-10-01', '2018-10-02', '2018-10-03', '2018-10-04',
'2018-10-05', '2018-10-06', '2018-10-07', '2018-10-08',
'2018-10-09', '2018-10-10', '2018-10-11', '2018-10-12'],
dtype='datetime64[ns]', freq='D')
DatetimeIndex(['2018-10-01', '2018-10-02', '2018-10-03', '2018-10-04',
'2018-10-05', '2018-10-06'],
dtype='datetime64[ns]', freq='D')

例2

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
import pandas as pd
dates = pd.date_range(start="2018-10-01", periods=8, freq="B")
dates1 = pd.date_range(start="2018-10-01", periods=8, freq="H")
dates2 = pd.date_range(start="2018-10-01", periods=8, freq="S")
print(dates)
print(dates1)
print(dates2)
DatetimeIndex(['2018-10-01', '2018-10-02', '2018-10-03', '2018-10-04',
'2018-10-05', '2018-10-08', '2018-10-09', '2018-10-10'],
dtype='datetime64[ns]', freq='B')
DatetimeIndex(['2018-10-01 00:00:00', '2018-10-01 01:00:00',
'2018-10-01 02:00:00', '2018-10-01 03:00:00',
'2018-10-01 04:00:00', '2018-10-01 05:00:00',
'2018-10-01 06:00:00', '2018-10-01 07:00:00'],
dtype='datetime64[ns]', freq='H')
DatetimeIndex(['2018-10-01 00:00:00', '2018-10-01 00:00:01',
'2018-10-01 00:00:02', '2018-10-01 00:00:03',
'2018-10-01 00:00:04', '2018-10-01 00:00:05',
'2018-10-01 00:00:06', '2018-10-01 00:00:07'],
dtype='datetime64[ns]', freq='S')

例3

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
import pandas as pd
dates = pd.date_range(start="2018-10-01 03:00:00", periods=8, freq="H", normalize=True)
dates1 = pd.date_range(start="2018-10-01 03:00:00", periods=8, freq="H", normalize=False)
print(dates)
print(dates1)
DatetimeIndex(['2018-10-01 00:00:00', '2018-10-01 01:00:00',
'2018-10-01 02:00:00', '2018-10-01 03:00:00',
'2018-10-01 04:00:00', '2018-10-01 05:00:00',
'2018-10-01 06:00:00', '2018-10-01 07:00:00'],
dtype='datetime64[ns]', freq='H')
DatetimeIndex(['2018-10-01 03:00:00', '2018-10-01 04:00:00',
'2018-10-01 05:00:00', '2018-10-01 06:00:00',
'2018-10-01 07:00:00', '2018-10-01 08:00:00',
'2018-10-01 09:00:00', '2018-10-01 10:00:00'],
dtype='datetime64[ns]', freq='H')

当前网速较慢或者你使用的浏览器不支持博客特定功能,请尝试刷新或换用Chrome、Firefox等现代浏览器