擅长:python、mysql、java
<p>这应该可以做到:</p>
<pre><code>output = {}
for i in ['starbucks','directions','navigate']:
output[i] = df[df['Utterance'].str.lower().str.contains(i)]['Frequency'].sum()
</code></pre>
<p>收益率:</p>
<pre><code>{'starbucks': 3666, 'directions': 2411, 'navigate': 678}
</code></pre>