.loc使用时出现报错keyerror:2957875

.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")

img

用loc[m, "卡号"]必须注意,你那个m是否是索引,如果不是,会报错的。