Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
Oftentimes we'll need data from multiple DataFrames. Let's merge!
This video doesn't have any notes.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
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 dataframes
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 upYou need to sign up for Treehouse in order to set up Workspace
Sign up