擅长:python、mysql、java
<p>您可以尝试使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.stack.html" rel="nofollow noreferrer">^{<cd1>}</a>和<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.value_counts.html" rel="nofollow noreferrer">^{<cd2>}</a>,然后使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.loc.html" rel="nofollow noreferrer">^{<cd4>}</a>从结果中过滤出<code>India</code></p>
<pre><code>m = df[['Team_1','Team_2']]
d = m[m.eq('India').any(1)].stack().value_counts().loc[lambda x:x.index!='India'].to_dict()
</code></pre>
<p>或在1行中:</p>
<pre><code>d1= (df.loc[df.eq('India').any(1),['Team_1','Team_2']]
.stack().value_counts().loc[lambda x:x.index!='India'].to_dict())
</code></pre>
<hr/>
<pre><code>print(d)
#output -> {'Sri Lanka': 3, 'Bangladesh': 2}
</code></pre>