title: Heat Map Seaborn fmt='d' error
body: <p>In extension to my previous <a href="https://stackoverflow.com/questions/31086883/heat-maps-seaborn-annot-error/31086912#31086912">question</a></p>
  
  <p>I can plot the Heat map with Seaborn very well and with suggestion can get annotation. But I see a new problem now. </p>
  
  <p>Input File </p>
  
  <pre><code>Nos,Place,Way,Name,00:00:00,12:00:00
  123,London,Air,Apollo,342,972
  123,London,Rail,Beta,2352,342
  123,Paris,Bus,Beta,545,353
  345,Paris,Bus,Rava,652,974
  345,Rome,Bus,Rava,2325,56
  345,London,Air,Rava,2532,9853
  567,Paris,Air,Apollo,545,544
  567,Rome,Rail,Apollo,5454,5
  876,Japan,Rail,Apollo,644,54
  876,Japan,Bus,Beta,45,57
  876,Japan,Bus,Beta,40,57
  876,Japan,Bus,Beta,40,57
  </code></pre>
  
  <p>Program:</p>
  
  <pre><code>import pandas as pd
  import numpy as np
  import seaborn as sns
  import matplotlib.pyplot as plt
  sns.set()
  
  df = pd.read_csv('heat_map_data.csv')
  
  df3 = df.copy()
  for c in ['Place','Name']:
      df3[c] = df3[c].astype('category')
  
  sns.heatmap(df3.pivot_table(index='Place', columns='Name', values='00:00:00' ),annot=True, fmt='.1f' )
  
  plt.show() 
  </code></pre>
  
  <ol>
  <li>If I take <code>fmt='d'</code> then I get error of float value and changed to <code>fmt='f'</code> And I get the count of the desired column. </li>
  </ol>
  
  <p>But When the same axis value repeats it does not add the count from desired column. Any solution for that pls ?</p>
  
  <p>As it is seen in the input file </p>
  
  <pre><code>876,Japan,Bus,Beta,45,57
  876,Japan,Bus,Beta,40,57
  876,Japan,Bus,Beta,40,57
  </code></pre>
  
  <p>It has 3 rows in repeat and the value of them should be shown as sum 
  the cell which represents <code>Japan</code> and <code>Beta</code> should annot value as <code>125</code> instead it shows <code>41.7</code>. How do I achieve that? Also is it possible to give two values as annotation ?</p>
  
  <p><img src="https://i.stack.imgur.com/Xt1Zh.png" alt="enter image description here"></p>
  
  <ol start="2">
  <li>Second  doubt is now that in <code>pivot</code> I am giving <code>value='00:00:00'</code> but I need it to dynamically read the last column from the file. </li>
  </ol>