Introduction
Missing values
Duplicate rows
Outliers
Joining datasets
12. Importing multiple files
Summary

Instruction

Great! Finally, we may need to work with data scattered among multiple datasets. To learn how to join two datasets, we will first load them into two separate variables.

The two datasets will be about employees of a company. The first dataset will contain employees' first and last names. The second dataset will contain employees' departments and salaries. Both files will also show each employee's individual ID.

Exercise

Create a DataFrame named employee_names and read the file employee_names.csv into it. Then, create a DataFrame named employee_salaries and read the file employee_salaries.csv into it.