Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Introduction to Python for Data Science

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.