title: Left join in R by character type
body: <p>am trying to scrape movie sets from 2 different websites</p>
  
  <p>And I want to combine these 2 informations, and tied them up using the movie title name. Here is the first dataset looks like</p>
  
  <pre><code>structure(list(event_name = c("maze runner: the death cure", "star wars: the last jedi", 
  "spider-man: homecoming"), event_start_time = structure(c(100, 
  200, 300), class = "Date"), movie_sold_all = c(100L, 200L, 
  300L)), .Names = c("event_name", "event_start_time", "movie_sold_all"
  ), row.names = c(NA, 3L), class = "data.frame")
  </code></pre>
  
  <p>And this is the 2nd dataset that i've scraped</p>
  
  <p><a href="https://i.stack.imgur.com/rXQAN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rXQAN.png" alt="enter image description here"></a>
  I have to upload image only since there are >10 columns</p>
  
  <p>What i expect to have is to join the <code>movie_title</code> so they it'll incorporate these 2 informations. Basically similar like <code>left join</code> in SQL</p>
  
  <p>I've tried <code>merge( df_bq_movies,movies,by.y="movie_title",all.x = TRUE)</code></p>
  
  <p>but the error occurs </p>
  
  <p><code>Error in merge.data.frame(df_bq_movies, movies, by.y = "movie_title",  :'by.x' and 'by.y' specify different numbers of columns</code></p>
  
  <p>For more information, this is the dimension of the dataset</p>
  
  <p><code>data 1 : 605 rows , 3 column
  data 2 : 509 rows , 21 column</code></p>