title: Python Pivot Table margins=True not summing well
body: <p>I have the below code:</p>
  
  <pre><code>import pandas as pd
  df=pd.read_csv("https://www.dropbox.com/s/90y07129zn351z9/test_data.csv?dl=1", encoding="latin-1")
  pvt_received=df.pivot_table(index=['site'], values = ['received','sent'], aggfunc = {  'received' : 'count' ,'sent': 'count'}, fill_value=0, margins=True) 
  pvt_received['to_send']=pvt_received['received']-pvt_received['sent']
  column_order = ['received', 'sent','to_send']
  pvt_received_ordered = pvt_received.reindex_axis(column_order, axis=1)
  pvt_received_ordered.to_csv("test_pivot.csv")
  table_to_send = pd.read_csv('test_pivot.csv', encoding='latin-1')
  table_to_send.rename(columns={'site':'Site','received':'Date Received','sent':'Date Sent','to_send':'Date To Send'}, inplace=True)
  table_to_send.set_index('Site', inplace=True)
  table_to_send
  </code></pre>
  
  <p>Which generate this table:</p>
  
  <pre><code>      Date Received       Date Sent       Date To Send
  Site            
  2         32.0             27.0           5.0
  3         20.0             17.0           3.0
  4         33.0             31.0           2.0
  5         40.0             31.0           9.0
  All       106.0            106.0          0.0
  </code></pre>
  
  <p>But this parameter margins=True is not giving correct result of total of each columns. For instance, Date Received should be 125 instead of 106, Date Sent should be 106 (it is correct) and Date To Send should be 19 instead of 0.0 (zero). Question: What am I supposed to change to get correct numbers? Also, there is lack on All that should do a sum of each row. Thanks a lot in advance.</p>