您可以将每个列表append
到一个具有列名称的键,然后创建pandas.DataFrame
.
from collections import defaultdict
import pandas as pd
dct = defaultdict(list)
for idx, ls in enumerate([list1, list2, list3]):
dct[columns[idx%len(columns)]].append(ls) # why `%len(columns)`? see second part
print(dct)
df = pd.DataFrame(dct)
print(df)
输出:
{'c1': [['a', 'b', 'c', 'd']], 'c2': [[1, 2, 3, 4, 5, 6]], 'c3': [['h', 'j', 'm', 'q', 'w']]}
c1 c2 c3
0 [a, b, c, d] [1, 2, 3, 4, 5, 6] [h, j, m, q, w]
您可以向每列添加多个列表.
dct = defaultdict(list)
for idx, ls in enumerate([list1, list2, list3, list1, list2, list3]):
dct[columns[idx%len(columns)]].append(ls)
df = pd.DataFrame(dct)
print(df)
输出:
c1 c2 c3
0 [a, b, c, d] [1, 2, 3, 4, 5, 6] [h, j, m, q, w]
1 [a, b, c, d] [1, 2, 3, 4, 5, 6] [h, j, m, q, w]