数据进行切分

数据进行切分

# -*- coding: utf-8 -*-
"""
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)
#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