title: Unwanted white spaces resulting into distorted column
body: <p>I am trying to import a list of chemicals from a txt file which is spaced (not tabbed).</p>
  <p><a href="https://i.stack.imgur.com/3LdBM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3LdBM.png" alt="enter image description here" /></a></p>
  <pre><code>NO FORMULA NAME CAS No A B C D TMIN TMAX code ngas@TMIN ngas@25 C ngas@TMAX
  1 CBrClF2 bromochlorodifluoromethane 353-59-3 -0.0799 4.9660E-01 -6.3021E-05 -9.0961E-09 200 1500 2 96.65 142.14 572.33
  2 CBrCl2F bromodichlorofluoromethane 353-58-2 4.0684 4.1343E-01 1.6576E-05 -3.4388E-08 200 1500 2 87.14 127.90 545.46
  3 CBrCl3 bromotrichloromethane 75-62-7 7.3767 3.5056E-01 6.9163E-05 -4.9571E-08 200 1500 2 79.86 116.73 521.53
  4 CBrF3 bromotrifluoromethane 75-63-8 -9.5253 6.5020E-01 -3.4459E-04 1.0987E-07 230 1500 1,2 123.13 156.61 561.26
  5 CBr2F2 dibromodifluoromethane 75-61-6 2.8167 4.9405E-01 -1.2627E-05 -2.8629E-08 200 1500 2 100.89 148.24 618.87
  6 CBr4 carbon tetrabromide 558-13-4 10.6812 3.2869E-01 1.0739E-04 -6.0788E-08 200 1500 2 80.23 116.62 540.18
  7 CClF3 chlorotrifluoromethane 75-72-9 13.8075 4.7487E-01 -1.3368E-04 2.2485E-08 230 1500 1,2 116.23 144.10 501.22
  8 CClN cyanogen chloride 506-77-4 0.8665 3.6619E-01 -2.9975E-05 -1.3191E-08 200 1500 2 72.80 107.03 438.19
  </code></pre>
  <p>When I import with pandas</p>
  <pre><code>df = pd.read_csv('trial1.txt', sep='\s')
  </code></pre>
  <p>I get:</p>
  <p><a href="https://i.stack.imgur.com/kILpz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kILpz.png" alt="enter image description here" /></a></p>
  <p>For first 5 compounds (index 0-4) name is correctly in <code>Name</code> column but for 6th (index 5) and 8th (index 7) compounds - their name is divided because of <em>space</em> and it goes to <code>CAS</code>. Causing <code>CAS</code> column value to go under <code>No</code> column and values and so on subsequently.</p>
  <p>Is there a way to eliminate this issue ? Thank you</p>