将元组列表的列表转换为DataFrame(第一个参数:column,第二个参数:value)



所以我需要一个DataFrame的list_of_list_of_tuples:

我的数据是这样的:

元组=[[(0.45),(0.56)],[(0.23)、(0.54)、(0.63)],[(0.86)、(0.36)]]

我需要的是这个:

<表类> 指数 1 2 3 4 5 6 tbody><<tr>1南南南南0.450.5620.230.54南南南0.633南南0.86南南0.36

将每个元组转换为字典,传递给DataFrame构造函数,最后添加DataFrame.reindex以更改顺序,并添加缺失的列:

df = pd.DataFrame([dict(x) for x in tuples])
df = df.reindex(range(df.columns.min(), df.columns.max() + 1), axis=1)
print (df)
1     2     3   4     5     6
0   NaN   NaN   NaN NaN  0.45  0.56
1  0.23  0.54   NaN NaN   NaN  0.63
2   NaN   NaN  0.86 NaN   NaN  0.36
tuples = [[(5,0.45),(6,0.56)],[(1,0.23),(2,0.54),(6,0.63)],[(3,0.86),(6,0.36)]]
for x in tuples:
print(x)
index=[]
values=[]
for tuple in x:
print(tuple[0],tuple[1])
index.append(tuple[0])
values.append(tuple[1])
print(index,values)