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

CodePudding user response：

Refer Here

It shows the detailed solution

CodePudding user response：

try this:

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