Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
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,
it will be spread across multiple data frames.
And our job is often to take these different data frames, and
combine them together, and somehow produce a new result.
Sometimes we're lucky and these data frames have clearly related information,
and other times it's a bit of a challenge to figure out how to relate the rows.
If the labels match between the data frames, it's possible to join the two
together quite easily, much like you would see in SQL with primary and foreign keys.
And, of course, sometimes it's not that cut and dry,
you have to do some work to relate the data frames together.
But that's okay.
We're ready for that work.
We've been picking up manipulation skills so
that we can get things together in the right shape for our needs.
After your data friends are merged together,
some new problems will most likely enter the introduce themselves.
You might have to worry about duplicate records or missing data.
Let's do some merging and
cleaning up of those problems that you're bound to run into,
You need to sign up for Treehouse in order to download course files.Sign up