从csv数据中提取ManyToOne字段的装置

import csv

# 1. 导入CSV数据
data = []
with open('data.csv', 'r') as file:
    reader = csv.reader(file)
    for row in reader:
        data.append(row)

# 3. 处理ManyToOne字段
devices = set()
for row in data:
    device_id = row[0]  # 假设装置ID在CSV文件的第一列
    devices.add(device_id)

# 4. 根据装置ID进行分组
device_attributes = {}
for device_id in devices:
    attributes = []
    for row in data:
        if row[0] == device_id:
            attributes.append(row[1:])  # 假设装置属性字段从第二列开始
    device_attributes[device_id] = attributes

# 5. 输出结果
for device_id, attributes in device_attributes.items():
    print(f"装置ID: {device_id}")
    for attribute in attributes:
        print(f"属性字段: {attribute}")