擅长:python、mysql、java
<p>你说的聚类图是什么意思。我认为,最好的方法是通过散点图来可视化这种传播。如果需要,您可以转置和重命名</p>
<pre><code>df.T.reset_index().plot(kind='scatter', x='index', y=0)
</code></pre>
<p><a href="https://i.stack.imgur.com/FjJvj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FjJvj.png" alt="enter image description here"/></a></p>
<p>甚至阴谋</p>
<pre><code>df.T.reset_index().plot(kind='bar', x='index', y=0)
</code></pre>
<p><a href="https://i.stack.imgur.com/GkJdp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GkJdp.png" alt="enter image description here"/></a></p>
<p>根据您的评论和澄清,groupby和dict</p>
<pre><code>df.T.reset_index().groupby(0).agg(list).to_dict()
{'index': {2: ['cat1', 'cat2', 'cat7'],
6: ['cat3', 'cat6'],
7: ['cat5', 'cat9'],
9: ['cat4', 'cat8'],
11: ['cat10']}}
</code></pre>