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

Question

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"))

It would be helpful if you could provide a sample data using `dput(x)`. — Nad Pat, Mar 19 '22 at 10:12

score 1 · Accepted Answer · answered Mar 19 '22 at 10:13

1

try this:

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

answered Mar 19 '22 at 10:13

aaaaa

149
2
18
44

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

1 Answers1