title: Python: Parse table with missing tab at end
body: <p>Is there a way to use pandas read table or read fwf to parse a text file that has empty fields and the tabbed delimiter stops if there aren't any more fields in the line. Example: I added spaces to be readable but they aren't there between tabs. There should be 5 columns A:E</p>
  
  <pre><code>A \t B \t C \t D \t E            \r\n
  word 1 \t 1 \t 2  \t text  \t s  \r\n
         \t 0 \t 20                \r\n
  word 2 \t 1 \t 5                 \r\n
         \t   \t    \t text2       \r\n
  word 6 \t 2 \t 6  \t text3 \t s  \r\n
  </code></pre>
  
  <p>I want NaN values or anything that says it's empty where there are empty fields. I've looked around for something like this and haven't found anything. I've also tried everything I can think of using pandas. I've thought about adding \t values to each line missing 4 but I was hoping there is an easier way since there are more issues with this data set besides just this. These data tables are separated by text in between because it is a pdf converted to text.</p>
  
  <p>Expected Result:</p>
  
  <pre><code>   A      B    C     D      E
  word 1    1    2    text    s
    NaN     0    20   NaN    NaN
  word 2    1    5    NaN    NaN
    NaN    NaN  NaN  text2   NaN
  word 6    2    6   text3    s
  </code></pre>
  
  <p>using </p>
  
  <pre><code>data = pd.read_fwf(filename, skiprows=range(0,10),skipfooter=8,sep='\t',na_values='NaN')
  </code></pre>