Merging data enables us to understand how different data sources relate to each other. The merge
operation in R is similar to the join
operation in a database, which combines fields from two datasets using values that are common to each.
Refer to the Converting data types recipe and convert each attribute of imported data into the proper data type. Also, rename the columns of the employees
and salaries
datasets by following the steps from the Renaming the data variable recipe.
Perform the following steps to merge salaries
and employees
:
As
employees
andsalaries
are common inemp_no
, we can merge these two datasets usingemp_no
as the join key:> employees_salary <- merge(employees, salaries, by="emp_no") > head(employees_salary,3) emp_no birth_date first_name last_name salary from_date to_date 1 10001 1953-09-02 Georgi Facello 60117 1986-06-26 1987-06-26 2 10001 1953-09-02 Georgi Facello 62102 1987-06-26 1988-06-25 3 10001...