Read data (.dat file) with Pandas
<p>How do I read the following (two columns) data (from a .dat file) with Pandas</p>

<pre><code>TIME                      XGSM
2004 006 01 00 01 37 600  1
2004 006 01 00 02 32 800  5
2004 006 01 00 03 28 000  8
2004 006 01 00 04 23 200  11
2004 006 01 00 05 18 400  17
</code></pre>

<p>Column separator is (at least) 2 spaces.</p>

<p>I tried </p>

<pre><code>df = pd.read_table("test.dat", sep="\s+", usecols=['TIME', 'XGSM'])
print df
</code></pre>

<p>But it prints </p>

<pre><code>   TIME  XGSM
   2004     6
   2004     6
   2004     6
   2004     6
   2004     6
</code></pre>