Python提取特定时间段内数据的方法实例
发布时间:2020-09-24 05:46:06
来源:脚本之家
阅读:75
作者:淮南草
python提取特定时间段内的数据
尝试一下:
data['Date'] = pd.to_datetime(data['Date'])
data = data[(data['Date'] >=pd.to_datetime('20120701')) & (data['Date'] <= pd.to_datetime('20120831'))]
实际测试
'''
Created on 2019年1月3日
@author: hcl
'''
import pandas as pd
import matplotlib.pyplot as plt
data_path = 'one_20axyz.csv'
if __name__ == '__main__':
msg = pd.read_csv(data_path)
# ID_set = set(msg['Time'].tolist())
# ID_list = list(ID_set)
# print(len(msg['Time'].tolist()),len(ID_list),len(msg['Time'].tolist())/len(ID_list))#打印