数据进行切分
"""
Created on Mon Apr 17 16:12:18 2017
@author: STP
"""
import pandas as pd
import numpy as np
import datetime
begin = datetime.datetime.now()
data= pd.read_csv('0401-0415.csv', header = 0)
'''
data1 = pd.read_csv('0221-0229.csv', header = 0)
data2 = pd.read_csv('0301-0306.csv', header = 0)
data12=[data1,data2]
data= pd.concat(data12)
'''
data['time'] = pd.to_datetime(data['time'])
rng1 = pd.date_range('2016-04-11',periods = 1)
rng2 = pd.date_range('2016-04-15',periods = 1)
for i in rng1:
for j in rng2:
index1 = data['time'] >= i
print i
index2 = data['time'] <= j
print j
output = data[index1 & index2]
output.to_csv('0411-0415.csv' , mode = 'ab+', index = None)
'''
# 处理合并的两个数据集
data['time'] = pd.to_datetime(data['time'])
rng1= pd.date_range('2016-03-06',periods = 1)
for i in rng1:
index1 = data['time'] <= i
print i
output = data[index1]
output.to_csv('0301-0306.csv' , mode = 'ab+', index = None)
'''
end = datetime.datetime.now()
time_run=end-begin
print time_run