title: Reading key-value pairs into Pandas
body: <p>Pandas makes it really easy to read a CSV file:</p>
  
  <pre><code>pd.read_table('data.txt', sep=',')
  </code></pre>
  
  <p>Does Pandas having something similar for a file with key-value pairs? I came-up with this:</p>
  
  <pre><code>pd.DataFrame([dict([p.split('=') for p in l.split(',')]) for l in open('data.txt')])
  </code></pre>
  
  <p>If not built-in, then perhaps something more idiomatic?</p>
  
  <p>The file of interest looks like this:</p>
  
  <pre><code>symbol=ESM3,exchange=GLOBEX,timestamp=1365428525690751,price=1548.00,quantity=551
  symbol=ESM3,exchange=GLOBEX,timestamp=1365428525697183,price=1548.00,quantity=551
  symbol=ESM3,exchange=GLOBEX,timestamp=1365428525714498,price=1548.00,quantity=551
  symbol=ESM3,exchange=GLOBEX,timestamp=1365428525734967,price=1548.00,quantity=551
  symbol=ESM3,exchange=GLOBEX,timestamp=1365428525735567,price=1548.00,quantity=555
  symbol=ESM3,exchange=GLOBEX,timestamp=1365428525735585,price=1548.00,quantity=556
  symbol=ESM3,exchange=GLOBEX,timestamp=1365428525736116,price=1548.00,quantity=556
  symbol=ESM3,exchange=GLOBEX,timestamp=1365428525740757,price=1548.00,quantity=556
  symbol=ESM3,exchange=GLOBEX,timestamp=1365428525748502,price=1548.00,quantity=556
  symbol=ESM3,exchange=GLOBEX,timestamp=1365428525748952,price=1548.00,quantity=557
  </code></pre>
  
  <p>It has the exact same keys on every line, and in the same order. There are no null values. The table to be generated is:</p>
  
  <pre><code>  exchange    price quantity symbol         timestamp
  0   GLOBEX  1548.00    551\n   ESM3  1365428525690751
  1   GLOBEX  1548.00    551\n   ESM3  1365428525697183
  2   GLOBEX  1548.00    551\n   ESM3  1365428525714498
  3   GLOBEX  1548.00    551\n   ESM3  1365428525734967
  4   GLOBEX  1548.00    555\n   ESM3  1365428525735567
  5   GLOBEX  1548.00    556\n   ESM3  1365428525735585
  6   GLOBEX  1548.00    556\n   ESM3  1365428525736116
  7   GLOBEX  1548.00    556\n   ESM3  1365428525740757
  8   GLOBEX  1548.00    556\n   ESM3  1365428525748502
  9   GLOBEX  1548.00    557\n   ESM3  1365428525748952
  </code></pre>
  
  <p>(I can remove the <code>\n</code> from <code>quantity</code> with an <code>rstrip()</code> after I've brought it in.)</p>