python - 访问嵌套值

Question

我想将数据从一个表移动到另一个表，并在中间进行一些处理。数据在其来源处是一个大型 Json 对象，因此我希望在选择数据时去除单个值。我将数据逐行传递到下面的函数中。

def transformBadges(row):
    for inner_row in row:
        for element in inner_row :
            id = element['id']
            archived = element['archived']
            type = element['type']
            name = element['name']
            badge_id = str(uuid.uuid4())

            insertBadge(id, archived, type, name, badge_id)

row 基本上包含我的目标列。但是我已经更新了我的选择以选择更多的列。因此，我不得不将上面的代码更改为以下代码:

def transformBadges(row):
    badges = row['badges']
    for inner_row in badges:
        for element in inner_row:
            id = element['id']
            archived = element['archived']
            type = element['type']
            name = element['name']
            badge_id = str(uuid.uuid4())

            insertBadge(id, archived, type, name, badge_id)

在我看来，这完全一样 - 只是现在数据存储在不同的变量中。但是，我收到此错误:

Traceback (most recent call last):
  File "etl/main.py", line 537, in <module>
    main()
  File "etl/main.py", line 99, in main
    transformBadges(row)
  File "etl/main.py", line 106, in transformBadges
    id = element['id']
TypeError: string indices must be integers

为什么第一个有效而第二个无效？

Answer 1

def transformBadges(row):
    badges = row['badges']
    for element in badges:
        id = element['id']
        archived = element['archived']
        type = element['type']
        name = element['name']
        badge_id = str(uuid.uuid4())

        insertBadge(id, archived, type, name, badge_id)

因为 badges 现在已经是一个 inner_row