Python 中pandas将稀疏矩阵型数据转换为稠密矩阵型数据

import pandas as pd
data=pd.DataFrame({"cell":["cell1","cell2","cell3"],"gene":["gene1","gene2","gene3"],"express":[1,2,3]})
tmp=[]
tmp.append(data["cell"])
tmp.append(data["gene"])
data.index=tmp
del data["cell"]
del data["gene"]
print(data.head())
new_Data=data.unstack()
print(new_Data.head())

unstack.png

处理unstack()后的列索引与行索引名字

new_Data.index.name=None
new_Data.columns.names=[None,None]
new_Data.columns=["gene1","gene2","gene3"]

index.name.png