title: Aggregating Rows Pandas
body: <p>I am quite new to <code>pandas</code>. I need to aggregate <code>'Names'</code> if they have the same name and then make an average for <code>'Rating'</code> and <code>'NumsHelpful'</code> (without counting <code>NaN</code>). <code>'Review'</code> should get concatenated whilst <code>'Weight(Pounds)'</code>should remain untouched: </p>
  
  <pre><code>col names: ['Brand', 'Name', 'NumsHelpful', 'Rating', 'Weight(Pounds)', 'Review']
  
  Name             'Brand'                             'Name'
  1534             Zing Zang                Zing Zang Bloody Mary Mix, 32 fl oz   
  1535             Zing Zang                Zing Zang Bloody Mary Mix, 32 fl oz   
  1536             Zing Zang                Zing Zang Bloody Mary Mix, 32 fl oz   
  1537             Zing Zang                Zing Zang Bloody Mary Mix, 32 fl oz   
  1538             Zing Zang                Zing Zang Bloody Mary Mix, 32 fl oz   
  1539             Zing Zang                Zing Zang Bloody Mary Mix, 32 fl oz   
  1540             Zing Zang                Zing Zang Bloody Mary Mix, 32 fl oz   
  
          'NumsHelpful'     'Rating'       'Weight'
  1534          NaN            2              4.5   
  1535          NaN            2              4.5   
  1536          NaN            NaN            4.5   
  1537          NaN            NaN            4.5   
  1538          2              NaN            4.5   
  1539          3              5              4.5   
  1540          5              NaN            4.5   
  
                          'Review'
  1534                                     Yummy - Delish  
  1535  The best Bloody Mary mix! - The best Bloody Ma...  
  1536  Best Taste by far - I've tried several if not ...  
  1537  Best bloody mary mix ever - This is also good ...  
  1538  Outstanding - Has a small kick to it but very ...  
  1539   OMG! So Good! - Spicy, terrific Bloody Mary mix!  
  1540                      Good stuff - This is the best  
  </code></pre>
  
  <p>So the output should be something like this:</p>
  
  <pre><code> 'Brand'                'Name'                   'NumsHelpful'    'Rating' 
  Zing Zang    Zing Zang Bloody Mary Mix, 32 fl oz     3.33             3
  
   'Weight'               'Review'
     4.5      Review1 / Review2 / ... / ReviewN
  </code></pre>
  
  <p>How shall I procede? Thanks.</p>