pandas Python -重新排列 Dataframe 数据

3ks5zfa0 于 2022-12-02 发布在 Python

关注(0)|答案(1)|浏览(155)

我想将 Dataframe 从左边的表重新排列到右边的表，如下图所示：

df = pd.DataFrame({
"Unnamed:0": ["Entity","","Var1","Var2","Var3","Var4"],
"Unnamed:1": ["A","X","0.45","0.14","0.16","0.28"],
"Unnamed:2": ["A","Y","0.66","0.55","0.39","0.49"],
"Unnamed:3": ["A","Z","0.3","0.24","0.31","0.13"],
"Unnamed:4": ["B","X","0.22","0.08","0.74","0.41"],
"Unnamed:5": ["B","Y","0.94","0.47","0.17","0.16"],
"Unnamed:6": ["B","Z","0.76","0.4","0.93","0.15"],
"Unnamed:7": ["C","X","0.4","0.76","0.71","0.01"],
"Unnamed:8": ["C","Y","0.86","1","0.26","0.32"],
"Unnamed:9": ["C","Z","0.35","0.1","0.36","0.4"],
})

我尝试使用pd.melt，但无法获得所需的内容。

pandas

来源：https://stackoverflow.com/questions/74619534/python-rearranging-dataframe-data

1条答案

按热度按时间

ct3nt3jp1#

由于您的 Dataframe 不是干净的（前2行是多索引列名），您可以先创建内部 Dataframe ，然后再将其熔化：

new_df = pd.DataFrame(df.iloc[2:,1:]).set_index(df.iloc[2:,0])
new_df.columns = pd.MultiIndex.from_frame(df.iloc[:2,1:].T)
new_df.melt(ignore_index=False).reset_index()

赞(0）回复(0）举报 2022-12-02

我来回答

pandas Python -重新排列 Dataframe 数据

1条答案

相关问题

热门标签

最新问答