Data integration using R

Question

I am trying to integrate data by merging two data-set in R, I am wondering if i can use the function merge() but i want to specify the column witch have the same information in one result column here is an example:

i want to merge dataset 1 and dataset 2 in one dataset (dataset 3) and specifying that "FN" is same as "FirstName" so i want it to be one column so the result should be :

Just rename FN to FirstName, `merge(by = c("FirstName", "LastName"))` and you should be good — Punintended, Feb 01 '19 at 22:21

score 2 · Answer 1 · answered Feb 02 '19 at 22:57

2

if you want to merge by the FN / FirstName as the common variable the you can do in one dplyr chain to rename and use merge:

dataset3 <- dataset2 %>% 
  rename(FirstName = FN) %>% 
  merge(dataset1, by = "FirstName")

answered Feb 02 '19 at 22:57

nycrefugee

1,629
1
10
23

score 1 · Accepted Answer · answered Feb 01 '19 at 22:22

1

You can set the same column name and then use it to merge the data.

names(dataset2)[1] = "FirstName"
dataset3 = merge(dataset1, dataset2, by="FirstName")

answered Feb 01 '19 at 22:22

Alexandre georges

667
3
12

score 1 · Answer 3 · answered Feb 02 '19 at 01:20

1

With the dplyr package you can do that with:

dplyr::inner_join(
x = dataset1, y = dataset2,
by = c("FirstName" = "FN")
)

answered Feb 02 '19 at 01:20

Zachary Colburn

46
3

Data integration using R

3 Answers3