Combining DataFrames0:55 with Craig Dennis
Oftentimes we'll need data from multiple DataFrames. Let's merge!
Often, the data that we work with will not be just in one single data frame, 0:00 it will be spread across multiple data frames. 0:03 And our job is often to take these different data frames, and 0:06 combine them together, and somehow produce a new result. 0:09 Sometimes we're lucky and these data frames have clearly related information, 0:12 and other times it's a bit of a challenge to figure out how to relate the rows. 0:16 If the labels match between the data frames, it's possible to join the two 0:20 together quite easily, much like you would see in SQL with primary and foreign keys. 0:24 And, of course, sometimes it's not that cut and dry, 0:29 you have to do some work to relate the data frames together. 0:31 But that's okay. 0:34 We're ready for that work. 0:35 We've been picking up manipulation skills so 0:36 that we can get things together in the right shape for our needs. 0:39 After your data friends are merged together, 0:41 some new problems will most likely enter the introduce themselves. 0:44 You might have to worry about duplicate records or missing data. 0:47 Let's do some merging and 0:50 cleaning up of those problems that you're bound to run into, 0:51
You need to sign up for Treehouse in order to download course files.Sign up