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 Combining Data for Analysis!
You have completed Combining Data for Analysis!
Preview
Welcome! In this video, I will provide my solution to the first challenge.
Challenge 1 solution
bill_spot = pd.merge(billboard, spotify, how='left', on='[Name, Artists, BB.Week]')
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
Now, I created a separate notebook so
0:00
that I could keep track of
just the challenge work.
0:01
I added some markdown so
you can follow along.
0:04
But you can do it in all the same
notebook, there's no difference.
0:06
Remember, our data frames
are named Billboard and Spotify,
0:10
Billboard on the left,
Spotify on the right.
0:14
We want to merge these datasets into a new
data frame called bill_spot,
0:17
via a left join, on our selected columns.
0:21
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