import numpy as np
import pandas as pd
data1 = pd.read_csv('采暖制冷用户-采暖_日.csv', encoding = 'gbk')
data1 = pd.DataFrame(data1)
data1 = np.array(data1)
j=0
n=1
zhouqi=[list() for i in range(68)]
zhouqi[0].append(data1[0][1])
zhouqi[0].append(data1[0][5])
for i in range(data1.shape[0]-1):
if i == data1.shape[0]-2:
zhouqi[j].append(data1[i+1][5])
zhouqi[j].append(n+1)
if data1[i][1] == data1[i+1][1]:
n=n+1
if data1[i][1]!=data1[i+1][1]:
zhouqi[j].append(data1[i][5])
zhouqi[j].append(n)
n=1
zhouqi[j+1].append(data1[i+1][1])
zhouqi[j + 1].append(data1[i + 1][5])
j=j+1
zhouqi= pd.DataFrame(zhouqi)
zhouqi = np.array(zhouqi)
for i in range (zhouqi.shape[0]-1):
if zhouqi[i][1].split('-')[0]!='2017':
zhouqi = np.delete(zhouqi, i, 0)
print(zhouqi)
0到zhuoqi.shape[0]正好遍历一遍zhouqi.shape[0]的length,30行改成for i in range(zhouqi.shape[0]):试试