.loc使用时出现报错keyerror:2957875
time = pd.date_range(start="20181015000000", periods=7, freq="24H")
name = 1015
for time_sec in range(len(time)-1):
low = (time[time_sec])
high = (time[time_sec+1])
print(f"正在提取----------------{low}至{high}的票卡数据")
matrix = data[(data["进站时间"] >= low) & (data["进站时间"] < high)]
print(matrix)
path = str(name) + ".csv"
name = name + 1
with open(path, "w") as file:
file.write("卡号,进站编号,出站编号,进站时间,出站时间,进站名称,出站名称"+"\n")
for m in range(len(matrix)):
num1 = matrix.loc[m, "卡号"]
num2 = matrix.loc[m, "进站编号"]
num3 = matrix.loc[m, "出站编号"]
num4 = matrix.loc[m, "进站时间"]
num5 = matrix.loc[m, "出站时间"]
num6 = matrix.loc[m, "进站名称"]
num7 = matrix.loc[m, "出站名称"]
file.write("{},{},{},{},{},{},{}".format(num1, num2, num3, num4, num5, num6, num7)+"\n")
用loc[m, "卡号"]必须注意,你那个m是否是索引,如果不是,会报错的。