在python中将列表转换为数据框

import pandas as pd

# 单层列表
data = [
    ['Alice', 24],
    ['Bob', 27],
    ['Charlie', 22]
]

# 转换为数据框
df = pd.DataFrame(data, columns=['Name', 'Age'])

print(df)

      Name  Age
0    Alice   24
1      Bob   27
2  Charlie   22

import pandas as pd

# 长度不一致的列表
data = [
    ['Alice', 24],
    ['Bob', 27, 'Engineer'],
    ['Charlie', 22]
]

# 转换为数据框
df = pd.DataFrame.from_records(data)

print(df)

      0   1         2
0  Alice  24       NaN
1    Bob  27  Engineer
2  Charlie  22       NaN

import pandas as pd

# 多层列表
data = [
    ['Alice', [24, 'Female']],
    ['Bob', [27, 'Male']],
    ['Charlie', [22, 'Male']]
]

# 转换为数据框
df = pd.DataFrame(data, columns=['Name', 'Details'])

# 展开Details列
df[['Age', 'Gender']] = pd.DataFrame(df['Details'].tolist(), index=df.index)

print(df)

      Name  Details  Age  Gender
0    Alice  [24, Female]   24  Female
1      Bob  [27, Male]    27    Male
2  Charlie  [22, Male]    22    Male