title: Python pandas splitting text and numbers in dataframe
body: <p>I have a dataframe df1 with column name Acc Number as the first column and the data looks like: </p>
  
  <pre><code>Acc Number
  ASC100.1
  MJT122
  ASC120.4
  XTY111
  </code></pre>
  
  <p>I need to make a new dataframe df2 that will have two columns first having the text part and the second having the numbers so the desired output is: </p>
  
  <pre><code>Text    Number 
  ASC     100.1
  MJT     122
  ASC     100.4
  XTY     111
  </code></pre>
  
  <p>How would I go about doing this?</p>
  
  <p>Thanks! </p>