Move from Excel to Python with Pandas Transcripts
Chapter: Aggregating, grouping, and merging
Lecture: Merging data in Excel
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, um, 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