将两个数组之间的行匹配限制为特定列的值

# 假设数组A和数组B已经定义并初始化
arrayA = [
    [1, 'John', 'Male'],
    [2, 'Jane', 'Female'],
    [3, 'Mike', 'Male']
]

arrayB = [
    [4, 'Emily', 'Female'],
    [5, 'John', 'Male'],
    [6, 'Jane', 'Female']
]

# 定义特定列的索引
columnIndex = 1  # 假设列索引为1，即第二列

# 存储匹配的行
matchedRows = []

# 遍历数组A的每一行
for rowA in arrayA:
    valueA = rowA[columnIndex]  # 获取特定列的值

    # 遍历数组B的每一行
    for rowB in arrayB:
        valueB = rowB[columnIndex]  # 获取特定列的值

        # 比较特定列的值是否相等
        if valueA == valueB:
            matchedRows.append(rowB)  # 将匹配的行存储到新数组中

# 打印匹配的行
for row in matchedRows:
    print(row)