From the course: Data Cleaning and Manipulating with Python in Excel

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Merging and joining

Merging and joining

From the course: Data Cleaning and Manipulating with Python in Excel

Start my 1-month free trial Buy for my team

Merging and joining

“

- [Instructor] There are plenty of situations where I've had to join several sheets of data in Excel, and I remember it being a complete disaster. This is where Python in Excel comes in handy with its merging and joining features. In this video, we will learn how to merge and join tables using Python in Excel. We will also learn the different types of joins we can do within Python. Lastly, we will discuss and compare the different joins and what the results look like from our codes. Okay, I'm excited for this one, so let's get right into it. So let's open up the Exercise File for this video. we'll use the Chapter 4 04_01 tab. Okay, so we have two tables here. Over here to left, we have the employee ID, their name, and the title that they have. Now over here in our second table, we have an employee ID, tenure, which is how long they've been at the company, and their age. And I quickly want to look at this DataFrame because it's a little bit different than what we've worked with in the…

Contents