Python Zip列表到Dataframe

import pandas as pd

# 定义两个列表
names = ['Alice', 'Bob', 'Charlie']
scores = [85, 90, 88]

# 使用zip函数将两个列表组合成一个元组的迭代器
zipped_data = zip(names, scores)

# 将zip对象转换为DataFrame
df = pd.DataFrame(zipped_data, columns=['Name', 'Score'])

print(df)

      Name  Score
0    Alice     85
1      Bob     90
2  Charlie     88

from itertools import zip_longest

names = ['Alice', 'Bob', 'Charlie']
scores = [85, 90]

zipped_data = zip_longest(names, scores, fillvalue=None)
df = pd.DataFrame(zipped_data, columns=['Name', 'Score'])

print(df)

      Name  Score
0    Alice     85
1      Bob     90
2  Charlie    None

names = ['Alice', 'Bob', 'Charlie']
scores = [85, '90', 88]  # 注意这里的'90'是一个字符串

# 将scores列表中的所有元素转换为整数
scores = [int(score) for score in scores]

zipped_data = zip(names, scores)
df = pd.DataFrame(zipped_data, columns=['Name', 'Score'])

print(df)

      Name  Score
0    Alice     85
1      Bob     90
2  Charlie     88