title: Pandas Sum of Duplicate Attributes
body: <p>I'm using Pandas to manipulate a csv file with several rows and columns that looks like the following</p>
  <pre><code>Fullname     Amount     Date           Zip    State .....
  John Joe        1        1/10/1900     55555    Confusion
  Betty White     5         .             .       Alaska 
  Bruce Wayne     10        .             .       Frustration
  John Joe        20        .             .       .
  Betty White     25        .             .       .
  </code></pre>
  <p>I'd like to create a new column entitled <code>Total</code> with a total sum of amount for each person. (Identified by <code>Fullname</code> and <code>Zip</code>). I'm having difficulty in finding the correct solution.</p>
  <p>Let's just call my csv import csvfile. Here is what I have.</p>
  <pre><code>import Pandas
  df = pandas.read_csv('csvfile.csv', header = 0) 
  df.sort(['fullname'])
  </code></pre>
  <p>I think I have to use the iterrows to do what I want as an object. The problem with dropping duplicates is that I will lose the amount or the amount may be different.</p>