title: How to group by and aggregate on multiple columns in pandas
body: <p>I have following dataframe in pandas</p>
  
  <pre><code> ID     Balance     ATM_drawings    Value
   1      100         50              345 
   1      150         33              233
   2      100         100             333 
   2      100         100             234
  </code></pre>
  
  <p>I want data in that desired format</p>
  
  <pre><code> ID     Balance_mean    Balance_sum     ATM_Drawings_mean    ATM_drawings_sum 
   1      75              250             41.5                 83 
   2      200             100             200                  100
  </code></pre>
  
  <p>I am using following command to do it in pandas</p>
  
  <pre><code> df1= df[['Balance','ATM_drawings']].groupby('ID', as_index = False).agg(['mean', 'sum']).reset_index()
  </code></pre>
  
  <p>But, it does not give what I intended to get. </p>