title: Mutilple delimiter pandas txt
body: <p>I am trying to turn a long string in a .txt file into a 2D pandas table</p>
  
  <pre><code>[{"CAN":"5420060701","VAL":"0"},{"CAN":"1920010101","VAL":"1"},{"CAN":"1920020101","VAL":"1"},...]
  </code></pre>
  
  <p>Into   </p>
  
  <pre><code>+----CAN-----+----VAL--+  
  +-5420060701-+----0----+  
  +-1920010101-+----1----+  
  +-1920020101-+----1----+ 
  </code></pre>
  
  <p>....</p>
  
  <p>I thought about <code>pd.read_fwf</code> but my value as different width, (i.e can be 65000 sometimes).<br>
  I though about <code>pd.read_csv(file,  delimiter=',')</code> but it returns a long row that is hard to reshape.<br>
  I have seen from a separate thread I could use <code>genfromtxt</code>from numpy but did not get it to run.</p>