def find_index(A,a0,a2):
tA=A
while 1:
I1=int(len(tA)/2)-1
I2=I1+1
t0=int(tA.iloc[I1,0][8:10])
t2=int(tA.iloc[I2,0][8:10])
if t2!=t0:
r=(tA.iloc[I1,0],tA.index[I1])
return r
break
if t2==t0 and t2==a0:
tA=tA.iloc[I2:,:]
if t2==t0 and t2==a2:
tA=tA.iloc[:I1+1,:]
def return_values():
import pandas as pd
reader=pd.read_csv('159站点8月份刷卡数据.csv',sep=',',chunksize=10000,usecols=[1],engine='python')
#每个月最后一天,没有与之比较,故每月最后一天无法获得,通过取数据及最后一条记录即可
r_d=[]
for A in reader:
a0=int(A.iloc[0,0][8:10])
a2=int(A.iloc[len(A)-1,0][8:10])
if a0!=a2:
r=find_index(A,a0,a2)
r_d.append(r)
return r_d