title: python Is it possible to format string in the cell via pandas
body: <p>I have a csv file and the example of the data row are as follows:</p>
  
  <pre><code>Col A    Col B    Col C
  ‘Cat’     ‘9’     ‘’
  ‘Dog’     ‘’     ‘male’
  Expected result -&gt; 
  Cat 9
  Dog  male 
  </code></pre>
  
  <p>I have used replace(“ ‘ “, “ “, regex=True) but the ‘ ‘ are not disappeared.</p>