title: Python Pandas remove .0 from data in column without losing trailing zeros
body: <p>Having an issue when I remove '.0' that it is also removing the trailing zeros. I have the following dataframe:</p>
  
  <pre><code>Product Number Materia      Key
  100000080      100000080.0  CUIP717610000008
  </code></pre>
  
  <p>I tried:</p>
  
  <pre><code>df['Material'] = df['Product Number'].astype(str)
  df['Key'] = df['Target Location'] + df['Material'].str.rstrip(r'\.0')
  </code></pre>
  
  <p>Ideally, I would like Material reflected as an object without the '.0' before the concatenate, but this is what I have been able to get so far.  The key is dropping the .0 and the last zero.</p>