如何在列[1]中连续第二次出现“0”时返回列[0]的值

问题/上下文 : 我正在尝试编写一个代码,该代码将读取指定文件夹中的每个CSV文件,在列索引[1]中查找连续第二次出现的零,并在找到时显示列索引[0]中的相应值。以下是我到目前为止所做的,但它不起作用。它只是简单地说,不存在具有两个连续零的列。然而,当我打开各个文件时,我可以清楚地看到有两个连续零的列。

当前代码 :

import os
import pandas as pd

folder_path = "/content/drive/session 1 & 2"

def find_column1_value_for_second_zero(file_path):
    try:
        df = pd.read_csv(file_path)
        consecutive_zeros = 0
        column1_value = None

        for _, row in df.iterrows():
            if row.iloc[1] == 0:
                consecutive_zeros += 1
                if consecutive_zeros == 2:
                    column1_value = row.iloc[0]
                    break
            else:
                consecutive_zeros = 0

        return column1_value
    except Exception as e:
        print(f"Error reading file '{file_path}': {str(e)}")
        return None

for filename in os.listdir(folder_path):
    if filename.endswith(".csv"):  # Assuming your files are CSV format
        file_path = os.path.join(folder_path, filename)
        
        column1_value = find_column1_value_for_second_zero(file_path)
        
        if column1_value is not None:
            print(f"In file '{filename}', the value in column 1 for the second zero in column 2 is: {column1_value}")
        else:
            print(f"In file '{filename}', no second zero in column 2 was found.")

预期结果 :获取列[0]中与列[1]中第二个连续零位于同一行的值。 实际结果 :每行返回“在第2列中找不到第二个零。”