擅长:python、mysql、java
<p>{and non-Need dictionary}和非嵌套的^列:</p>
<pre><code>aggregation = {'Count': 'mean', 'Amount': 'sum'}
cols_d = {'Count': 'Total Count', 'Amount': 'Total Amount'}
df = df.groupby(['Company','Region'], as_index=False).agg(aggregation).rename(columns=cols_d)
print (df)
Company Region Total Count Total Amount
0 AAA XXY 766 18630
1 BBB XYY 66 13150
</code></pre>
<p>另一个用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.add_prefix.html" rel="noreferrer">^{<cd2>}</a>代替<code>rename</code>的解决方案:</p>
^{pr2}$