擅长:python、mysql、java
<p>我觉得以下是这个问题的一个很好的解决方案:(<a href="https://stackoverflow.com/questions/10951341/pandas-dataframe-aggregate-function-using-multiple-columns">Pandas DataFrame aggregate function using multiple columns</a>)</p>
<pre><code>grouped = df.groupby('Date')
def wavg(group):
d = group['value']
w = group['wt']
return (d * w).sum() / w.sum()
grouped.apply(wavg)
</code></pre>