title: Python Pandas - Removing trailing numbers and the remaining words in string
body: <p>How do I remove numbers and everything behind the number using pandas? Basically anything with a number as a separate word and remove anything behind the separate word.</p>
  
  <p>For example:</p>
  
  <pre><code>ABC,2 QUEEN = ABC
  
  ABC 3 QUEEN = ABC
  
  ABC PTE LTD YES123 = ABC PTE LTD YES123
  
  ABC PTE LTD YES 123 = ABC PTE LTD
  </code></pre>