title: Group by one columns and find sum and max value for another in pandas
body: <p>I have a dataframe like this:</p>
  
  <pre><code>Name  id  col1  col2  col3  cl4 
  PL    252  0     747   3     53  
  PL2   252  1     24    2     35 
  PL3   252  4     75    24    13 
  AD    889  53    24    0     95 
  AD2   889  23    2     0     13  
  AD3   889  0     24    3     6  
  BG    024  12    89    53    66 
  BG1   024  43    16    13    0   
  BG2   024  5     32    101   4   
  </code></pre>
  
  <p>And now I need to group by ID, and for columns col1 and col4 find the sum for each id and put that into a new column near to parent column (example: col3(sum)) But for col2 and col3 find max value. 
  Desired output: </p>
  
  <pre><code>Name  id  col1 col1(sum) col2 col2(max) col3 col(max) col4 col4(sum)
  PL    252  0       5      747    747     3     24    6    18
  PL2   252  1       5      24     747     2     24    12   18
  PL3   252  4       5      75     747     24    24    0    18
  AD    889  53      76     24     24      95    95    23   33
  AD2   889  23      76     2      24      13    95    5    33
  AD3   889  0       76     24     24      6     95    5    33
  BG    024  12      60     89     89      66    66    0    67   
  BG1   024  43      60     16     89      0     66    63   67    
  BG2   024  5       60     32     89      4     66    4    67    
  </code></pre>
  
  <p>What is the easiest and fastest way to calculate this? </p>