擅长:python、mysql、java
<p>用matplotlib就可以直接看到。只需先确定数据的形状即可。转换为日期并返回到字符串以获得所需的订单</p>
<pre><code>df = pd.read_csv(io.StringIO("""MONTH TASKTYPE
09/19 A
09/19 B
10/19 B
10/19 B
01/20 A"""), sep="\s+")
(df
.assign(m=pd.to_datetime("28/"+df["MONTH"]))
.groupby(["m","TASKTYPE"])["TASKTYPE"].count().to_frame()
.unstack(0)
.droplevel(0, axis=1)
.T
.assign(MONTH=lambda dfa: dfa.index.strftime("%m/%y"))
.set_index("MONTH")
.plot(kind="bar", stacked=True)
)
</code></pre>
<p><a href="https://i.stack.imgur.com/4gd8e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4gd8e.png" alt="enter image description here"/></a></p>