Skip to main content
 首页 » 编程设计

python之将 2x2 DataFrame 整理成 4x1 系列 (Pandas)

2025年02月15日12EasonJim

我想在 pandas/matplotlib 中将以下数据显示为单个饼图。解决这个问题的聪明方法是什么?我的方法似乎草率。

import pandas as pd 
from pandas import DataFrame, Series 
matplotlib.style.use("ggplot") 
 
df = DataFrame({"Support": {"Pet Camper": 10, "Non-Pet Camper": 20}, 
                "Oppose": {"Pet Camper": 15, "Non-Pet Camper": 55}, 
               })  
d = {} 
for r in df.index: 
    for c in df.columns: 
        d[r + ", " + c] = df[c][r] 
jd = Series(d) 
 
pie_d = Series(d).plot(kind="pie", autopct="%1.1f%%") 
plt.legend() 
plt.ylabel("") 
plt.title("Dedicated Pet Section?") 
plt.show() 

数据框:

                      Oppose  Support 
    Non-Pet Camper      55       20 
    Pet Camper          15       10 

系列:

    Non-Pet Camper, Oppose     15 
    Non-Pet Camper, Support    55 
    Pet Camper, Oppose         10 
    Pet Camper, Support        20 

请您参考如下方法:

使用stack然后将 MultiIndex 转换为 index:

s = df.stack() 
s.index = s.index.map(','.join) 
print (s) 
Non-Pet Camper,Oppose     55 
Non-Pet Camper,Support    20 
Pet Camper,Oppose         15 
Pet Camper,Support        10 
dtype: int64 

另一种解决方案:

s = df.stack() 
s.index = [''.join(idx) for idx in s.index] 
print (s) 
Non-Pet CamperOppose     55 
Non-Pet CamperSupport    20 
Pet CamperOppose         15 
Pet CamperSupport        10 
dtype: int64