I have two csv files
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"))
try this:
final_csv = merge(csv_1, csv_2, by = c("Show.Name", "Episode.Name"))