数据进行切分

数据进行切分

# -*- coding: utf-8 -*-"""Created on Mon Apr 17 16:12:18 2017@author: STP"""import pandas as pdimport numpy as npimport datetimebegin = datetime.datetime.now()data= pd.read_csv('0401-0415.csv', header = 0)#data2 = pd.read_csv('JData_Action_201602.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