Move from Excel to Python with Pandas Transcripts
Chapter: Aggregating, grouping, and merging
Lecture: Merging data in Excel
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
Up until now, we've been dealing with one Excel sheet, but in the real world, you'll normally have multiple excel sheets or see SV files
0:10
that you need to merge together to do your analysis. So I'm gonna go through an example of how we could add some additional data to
0:19
our sample sales file boosts Excel file We've been working with. We have 1000 rows of data and let's say we have another file.
0:28
It has 50 rows of data that we would like to add. So here's that other file. So what you would probably do in Excel.
0:37
This highlights your data. Copy it, go to your other file, paste it. And now we have our 1050 rose in that data set.
0:49
And now let's do an example of what if we wanted to modify this data set to have, kind of the customer level associated with each company so that
1:00
we can do some further analysis on that. So if we have a file that looks like this, so we've got another. Each company has a level,
1:09
so we have 352 companies that each have a gold, silver or platinum level Probably what you do is another copy.
1:21
And then let's paste this into a new sheet, and then you would need to do if he look up and to figure out the
1:29
the appropriate level. So we'll call this company. Well, this and then we'll do if you look up.
1:51
So that tells us that really Cube is a gold level company, and then we can copy that down. And now our data will tell us which level each company is.
2:01
Get nice data frame. With all of those rose and the company level, we can do our further analysis. This process is relatively straightforward in excel,
2:11
but not very repeatable. So I'm gonna show how we would do the same thing