时间戳

首页 > 解决方案 > 熊猫系列获取指定时间段

python - 熊猫系列获取指定时间段

问题描述

data = [{"content": "11", "title": "aa", "info": "aa 2020-01-13 08:52:54", "time": 1578877014},
        {"content": "22", "title": "bb", "info": "abba 2020-02-14 08:15:54", "time": 1581639354},
        {"content": "8", "title": "affa", "info": "aa 2020-01-15 14:56:54", "time": 1579071414},
        {"content": "1", "title": "dd", "info": "aa 2020-01-16 08:56:54", "time": 1579136214},
        {"content": "5", "title": "ee", "info": "aa 2020-01-16 14:56:54", "time": 1579157814},
        {"content": "33", "title": "cc", "info": "au5a 2020-03-15 08:30:54", "time": 1584231354},
        {"content": "55", "title": "cc", "info": "aa 2020-02-16 17:56:54", "time": 1581847014},
        ]

我想获取8:00-9:00的所有数据，不限日期，只需要满足8:00-9:00的条件

[{"content": "11", "title": "aa", "info": "aa 2020-01-13 08:52:54", "time": 1578877014},
{"content": "22", "title": "bb", "info": "aa 2020-02-14 08:15:54", "time": 1581639354},
{"content": "33", "title": "cc", "info": "aa 2020-03-15 08:30:54", "time": 1584231354},
{"content": "1", "title": "dd", "info": "aa 2020-01-16 08:56:54", "time": 1579136214},
]

标签： pythonpandas

解决方案

系列

import pandas as pd

s=pd.Series(data,index=pd.to_datetime([i['time'] for i in data],utc=True,  unit='s').tz_convert('Asia/Shanghai'))
print(s.between_time('08:00:00','09:00:00').tolist())

result--->
[{'content': '11', 'title': 'aa', 'info': 'aa 2020-01-13 08:52:54', 'time': 1578877014}, 
{'content': '22', 'title': 'bb', 'info': 'aa 2020-02-14 08:15:54', 'time': 1581639354}, 
{'content': '1', 'title': 'dd', 'info': 'aa 2020-01-16 08:56:54', 'time': 1579136214}, 
{'content': '33', 'title': 'cc', 'info': 'aa 2020-03-15 08:30:54', 'time': 1584231354}]

数据帧代码

df=pd.DataFrame(data,index=pd.to_datetime([i['time'] for i in data],utc=True,  unit='s').tz_convert('Asia/Shanghai') )
print(df.between_time('08:00:00', '09:00:00').to_dict('r'))

result--->
[{'content': '11', 'title': 'aa', 'info': 'aa 2020-01-13 08:52:54', 'time': 1578877014}, 
{'content': '22', 'title': 'bb', 'info': 'aa 2020-02-14 08:15:54', 'time': 1581639354},
 {'content': '1', 'title': 'dd', 'info': 'aa 2020-01-16 08:56:54', 'time': 1579136214}, 
{'content': '33', 'title': 'cc', 'info': 'aa 2020-03-15 08:30:54', 'time': 1584231354}]

推荐阅读