title: Find and replace using * equivalent in pandas dataframe
body: <p>I want to replace the string &quot;Private room in house&quot; with &quot;Private&quot; in a column in a dataframe</p>
  <p>I have tried</p>
  <pre><code>df['room'] = df['room'].str.replace(&quot;Private[]&quot;,&quot;Private&quot;) 
  </code></pre>
  <p>putting all the various regular expression characters in the [] but nothing works. All I have succeeded in doing is removing the space after Private.</p>
  <p>I have looked at re.sub but haven't managed to get anything to work for me. I'm pretty new to Python so this is probably a simple problem but I can't find the answer anywhere</p>