[FIXED] How to join two csv files in R and match the data from both tables?

Issue

I have two csv files

csv 1 has this data

and csv 2 has this as its data

I want to add the episode review column from csv 2 to csv 1 with the correct episode name. How could I get this done? Any help is appreciated

EDIT: This is the code that got it work

library(tidyverse)
library(rvest)
library(dplyr)

df1 = read.csv('NewEpisodes.csv', head = T)
df2 = read.csv('episodesReview.csv', head = T, )


dfLeft = df1 %>% left_join(df2, by=c("Episode.Name", "Show.Name"))

Solution

try this:

final_csv = merge(csv_1, csv_2, by = c("Show.Name", "Episode.Name"))

Answered By - aaaaa

Answer Checked By - Pedro (PHPFixing Volunteer)