Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Introduction to pandas!
You have completed Introduction to pandas!
Preview
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