title: Is there a function within Pandas (Python) that is similar to 'text-to-columns' in Excel?
body: <p>I have a dataset which I have extracted from ABAQUS. It is an '.rpt' file. I've previously been using Excel to sort the data but it can be quite tedious - the button which uses text to columns is incredibly helpful though.</p>
  
  <p>My issue: I am trying to use pandas to clean my data. I have managed to find a way to import the data in to Python using:</p>
  
  <pre><code>df = pd.read_csv('.rpt', delim_whitespace=True)
  </code></pre>
  
  <p>Doing this delimits the data but the result leaves 3000 rows x 1 column. How do I split the data across multiple columns like excel... is there a way?? Thanks guys, I'm fairly new to this so would appreciate the help massively.</p>