Python 遍历列表列表，然后创建数据帧

Full List中每个子列表中元素的顺序是一致的，但在某些情况下，像第二个子列表一样，没有‘Age’变量，这将导致IndexError.更健壮的方法是遍历每个子列表，并基于"变量"键动态提取值.

# Initialize empty dictionaries for each variable
data = {'First_Name': [], 'Middle_Name': [], 'Age': [], 'Country': []}

# Iterate over each sublist
for sublist in fulllist:
    # Initialize variables to None
    first_name = middle_name = age = country = None
    # Iterate over each dictionary in the sublist
    for item in sublist:
        if item['Variable'] == 'First_Name':
            first_name = item['Answer']
        elif item['Variable'] == 'Middle_Name':
            middle_name = item['Answer']
        elif item['Variable'] == 'Age':
            age = item['Answer']
        elif item['Variable'] == 'Country':
            country = item['Answer']
    
    # Append values to respective lists
    data['First_Name'].append(first_name)
    data['Middle_Name'].append(middle_name)
    data['Age'].append(age)
    data['Country'].append(country)

# Create DataFrame
df = pd.DataFrame(data)
print(df)

输出-

  First_Name Middle_Name   Age   Country
0       Anne     Wanjohi    50    Uganda
1       John     Wagwara  None     Kenya
2       Jeff     Simboyi    20        UK
3        Ken      Kumbua  None  Tanzania