擅长:python、mysql、java
<p>我想你想要这样的输出:</p>
<p><a href="https://i.stack.imgur.com/WofGP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WofGP.png" alt="Barplot"/></a></p>
<p>我不确定这一点,但我认为使用<code>pivot</code>方法会把你搞砸。您不需要使用<code>pivot</code>,因为<code>agg_df</code>基本上是一个透视表。下面是我用来创建图形的代码:</p>
<pre><code>import pandas as pd
# I made this to approximate your CSV file.
table = {
'BirthYear': [2015, 2015, 2015, 2015, 2014, 2014,],
'Sex': ['W', 'M', 'W', 'M', 'M', 'W',],
'Area': ['Dhaka', 'Dhaka', 'Khulna', 'Khulna', 'Dhaka', 'Dhaka',],
'Count': [6, 3, 1, 8, 13, 20]
}
df = pd.DataFrame(table)
df = df.reset_index(drop=True)
# Select people born in 2015.
df = df.loc[df["BirthYear"] == 2015]
# This is basically a pivot table.
agg_df = df.groupby(['Sex']).sum()
# Make the plot.
agg_df['Count'].plot.bar(stacked=True)
</code></pre>