title: Reading rpt files with pandas
body: <p>I read rpt data to pandas by using:</p>
  
  <pre><code>import pandas as pd
  df = pd.read_fwf("2014-1.rpt", skiprows=[1], nrows=150)
  </code></pre>
  
  <p>I actually follow the anwser <a href="https://stackoverflow.com/questions/42208832/how-to-load-space-separate-file-into-pandas-dataframe">here</a>
  However, for some columns, seperation is not accurate. It is sample of what I get:</p>
  
  <pre><code>Country   Order Date Device   Category
  UK        2014-01-03 Desktop  Shoes
  IT        2014-01-03 Desktop  Shoes
  FR        2014-01-04 Desktop  Dress
  FR        2014-01-04 Tablet   Dress
  US        2014-01-05 Desktop  Bags
  US        2014-01-06 Desktop  Bags
  UK        2014-01-07 Tablet   Dress
  </code></pre>
  
  <p>For instance it reads Order Date and Device columns as a single column. Actually, it is just an example, there are many columns like this.
  How to solve it? Do you have any idea?
  Actually these columns with problems might have fixed widths</p>