title: Excel - combining two csv files into one with a common column
body: <p>I am working with two datasets in <code>csv</code> form (movielens latest-small dataset). Given below are the fields of both.</p>
  
  <p>rating.csv </p>
  
  <pre><code>  user_id   movie_id  rating
  </code></pre>
  
  <p>movie.csv</p>
  
  <pre><code>  movie_id   movie_name
  </code></pre>
  
  <p>what I want is to combine them into a single .csv with following fields</p>
  
  <pre><code>user_id   movie_id   movie_name   rating
  </code></pre>
  
  <p>So that the common column <code>movie_id</code> maps with corresponding <code>movie_name</code>. </p>
  
  <p>Could that be done using Excel? If not, how can I do it?</p>
  
  <p>I just need it as a dataset for my <em>recommender</em> engine, so any simple solution is welcome as end result is all that matters. But since I've some experience in java so that would be easy for my easy understand and implement. </p>
  
  <p>If there is some way using Excel then that would be the best. I have tried searching online and found some <code>VLOOKUP</code> method but couldn't clearly get it. </p>
  
  <p>Also I tried some online merging tools but they just attached the sheets one after the another not mapping the column. So I have no problem using online tools too.</p>