python time函数用法_python – 如何使用dataframe between_time()函数

示例 – 我使用评论中的信息：

import pandas as pd

import StringIO

import datetime

data = '''time --- value

1984-12-12 14:08:00 --- 1

1984-12-12 14:25:00 --- 2

1984-12-12 14:47:00 --- 4

1984-12-12 16:37:00 --- 3

1984-12-12 16:37:00 --- 9

1984-12-12 16:37:00 --- 5

1984-12-12 17:52:00 --- 3

1984-12-12 17:52:00 --- 7

1984-12-12 19:29:00 --- 2'''

#------------------------------------------------

df = pd.read_csv(StringIO.StringIO(data), sep=' --- ')

df['time'] = pd.DatetimeIndex(df['time'])

print "\nDataFrame:\n", df

print '\nIndex:', type(df.index)

#------------------------------------------------

df.set_index(keys='time', inplace=True)

print "\nDataFrame:\n", df

print '\nIndex:', type(df.index)

#------------------------------------------------

start = datetime.time(14,50,0)

end = datetime.time(18,0,0)

print "\nResult:\n", df['value'].between_time(start, end)

结果：

DataFrame:

time value

0 1984-12-12 14:08:00 1

1 1984-12-12 14:25:00 2

2 1984-12-12 14:47:00 4

3 1984-12-12 16:37:00 3

4 1984-12-12 16:37:00 9

5 1984-12-12 16:37:00 5

6 1984-12-12 17:52:00 3

7 1984-12-12 17:52:00 7

8 1984-12-12 19:29:00 2

Index:

DataFrame:

value

time

1984-12-12 14:08:00 1

1984-12-12 14:25:00 2

1984-12-12 14:47:00 4

1984-12-12 16:37:00 3

1984-12-12 16:37:00 9

1984-12-12 16:37:00 5

1984-12-12 17:52:00 3

1984-12-12 17:52:00 7

1984-12-12 19:29:00 2

Index:

Result:

time

1984-12-12 16:37:00 3

1984-12-12 16:37:00 9

1984-12-12 16:37:00 5

1984-12-12 17:52:00 3

1984-12-12 17:52:00 7

Name: value, dtype: int64