Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Missing values
Duplicate rows
Joining datasets
12. Importing multiple files


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.


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.