下面是一个使用Python的快速解决方案：
在打开数据集（作为CSV文件）并将其转换为字典列表之后，我使用集合和条件来解释第一级和第二级关系，并为每行提供一个新属性“relationship_id”。

import csv

with open("data_in.csv", "r", encoding="utf-8") as file:
    dataset = list(csv.DictReader(file))

    addresses = set()
    names = set()

    relationship_id = 0
    for row in dataset:
        address = row["address"]
        name = row["name"]
    
        if name not in names and address not in addresses:
            relationship_id += 1
    
        if address not in addresses:
            addresses.add(address)
        
        if address not in names:
            names.add(name)
    
        row["relationship_id"] = relationship_id

字符串
然后，您可以按自己喜欢的方式使用此列表。如果要将更新的行再次转换为CSV文件，可以执行以下操作：

with open("data_out.csv", "w", encoding="utf-8", newline="") as file:
    fieldnames = ["address", "name", "relationship_id"]
    writer = csv.DictWriter(file, fieldnames=fieldnames)
    
    for row in dataset:
        writer.writerow(row)

型