擅长:python、mysql、java
<p>我想你在找groupby。这样的办法应该行得通。你得照顾好伯爵的南斯。你知道吗</p>
<pre><code>import pandas as pd
d1 = pd.DataFrame([['A', 'B', 'C', 'D', 'E', 'F'], ['blah', 'blah', 'blah', 'blah', 'blah', 'blah']]).T
d2 = pd.DataFrame([['A', 'A', 'C', 'D', 'A', 'D'], ['blah', 'blah', 'blah', 'blah', 'blah', 'blah']]).T
unique_counts = d2.groupby(0).count()
pd.merge(d1, unique_counts, left_on=0, right_index=True, how='outer')
</code></pre>