title: How to remove .0 without messing with number 10
body: <p>so it might looks silly but how would you accomplish this merge.
  So as you guys can see I tried summing two strings, but it is failling for some reason at number <code>Weeks_between = 10</code>  </p>
  
  <p>The type will be different, it is not consistent. This was just sample of data. it is actually close to 1million rows.  </p>
  
  <p>data:</p>
  
  <pre><code>cw = pd.DataFrame({ "Weeks_between": [1.0 ,2.0 ,3.0 ,4.0 ,5.0 ,6.0 ,7.0 ,8.0 ,9.0 ,10.0 ,11.0 ,12.0 ] ,
                       "Type" : ["a" , "b" ,"c" , "b" ,"c", "b" ,"c", "b" ,"c", "b" ,"c", "b" ]  })
  
  </code></pre>
  
  <p>my code:</p>
  
  <pre><code>cw["Weeks_between"] = cw["Weeks_between"].round(0)
  cw["key"] = cw["Weeks_between"].map(str) + cw["Type"]
  cw["key"] = cw.key.str.replace('.0', '').astype(str)
  
  cw[["Weeks_between","key"]]
  &gt;&gt;&gt;
  Weeks_between   key
  1              1a
  2              2b 
  3              3c
  4              4b
  5              5c
  6              6b
  7              7c
  8              8b
  9              9c
  10             b      #   &lt;-- THERE IS THE PROBLEM
  11             11c
  12             12b
  
  </code></pre>