0

I have two csv files

csv 1 has this data This is the data of csv 1

and csv 2 has this as its data Data of csv 2

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"))
1
  • It would be helpful if you could provide a sample data using dput(x). Commented Mar 19, 2022 at 10:12

1 Answer 1

1

try this:

final_csv = merge(csv_1, csv_2, by = c("Show.Name", "Episode.Name"))
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.