title: Pandas Column Names Not Lining Up When .dat File Read
body: <p>I'm going through Wes McKinney's Python for Data Analysis 2nd Edition and in Chapter 2 he has several examples based of merging three <code>.dat</code> files about movie reviews.</p>
  
  <p>I can get two of the three data files to work (users and reviews), but the third one (movie titles) I can not get to work and can't figure out what to do.</p>
  
  <p>Here's the code:</p>
  
  <pre><code>mnames = ['movie_id', 'title', 'genres']
  movies = pd.read_table('movies.dat',  sep = '::', header = None, engine = 'python', names = mnames)
  
  print(movies[:5])
  </code></pre>
  
  <p>And here is what the output/problem looks like. Seems the file is not lining up the separator correctly and I've tried recreating the file and comparing to the other two files which are working but they look exactly the same.
  <a href="https://i.stack.imgur.com/ck8It.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ck8It.jpg" alt="enter image description here"></a></p>
  
  <p>Here's a sample data taken from <a href="https://raw.githubusercontent.com/wesm/pydata-book/2nd-edition/datasets/movielens/movies.dat" rel="nofollow noreferrer">here</a>: </p>
  
  <pre><code>1::Toy Story (1995)::Animation|Children's|Comedy
  2::Jumanji (1995)::Adventure|Children's|Fantasy
  3::Grumpier Old Men (1995)::Comedy|Romance
  4::Waiting to Exhale (1995)::Comedy|Drama
  5::Father of the Bride Part II (1995)::Comedy
  6::Heat (1995)::Action|Crime|Thriller
  7::Sabrina (1995)::Comedy|Romance
  8::Tom and Huck (1995)::Adventure|Children's
  9::Sudden Death (1995)::Action
  10::GoldenEye (1995)::Action|Adventure|Thriller
  11::American President, The (1995)::Comedy|Drama|Romance
  12::Dracula: Dead and Loving It (1995)::Comedy|Horror
  13::Balto (1995)::Animation|Children's
  14::Nixon (1995)::Drama
  </code></pre>
  
  <p>I'd like to be able to read this file properly so I can join it to the other two example files and keep learning Pandas :)</p>