python不等长列表转化成DataFrame

• 不同长度列表横向合并成DataFrame

import pandas as pd

a = [1,2,3]
b = [4,5]
c = ['a','b','c','d']
df = pd.concat([pd.DataFrame(a),pd.DataFrame(b)],axis=1)
# 若axis=0，则纵向合并
print(df)

	0	0	0
0	1.0	4.0	a
1	2.0	5.0	b
2	3.0	NaN	c
3	NaN NaN d

• 字典中多个不同长度列表横行合并成DataFrame

import pandas as pd
from numpy import nan
data = {}
data['a'] = [1,2,3]
data['b'] = [4,5]
data['c'] = ['a','b','c','d']
data['d'] = [nan]
data['e'] = ['cat','dog']

df = pd.DataFrame()
for k in data.keys():	
	df = pd.concat([df,pd.DataFrame(data[k])],axis=1)
print(df)

	0	0	0	0	0
0	1.0	4.0	a	NaN	cat
1	2.0	5.0	b	NaN	dog
2	3.0	NaN	c	NaN	NaN
3	NaN	NaN	d	NaN	NaN	

• 字典中不定个数、不同长度列表横行合并成DataFrame，并保留索引名

import pandas as pd
from numpy import nan
data = {}
data['a'] = [1,2,3]
data['b'] = [4,5]
data['c'] = ['a','b','c','d']
data['d'] = [nan]
data['e'] = ['cat','dog']

df = pd.DataFrame()
for k in data.keys():	
   df = pd.concat([df,pd.DataFrame({k:data[k]})],axis=1)
print(df)

	a	b	c	d	e
0	1.0	4.0	a	NaN	cat
1	2.0	5.0	b	NaN	dog
2	3.0	NaN	c	NaN	NaN
3	NaN	NaN	d	NaN	NaN