Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Combining Data for Analysis

Well done!

You have completed Combining Data for Analysis!

Sign up for Treehouse Back to Library

Final Dataset Solution

1:57 with Richard Tillies

Welcome! In this video, I will provide my solution to the third challenge.

Challenge 3 solution

bill_spot_final = pd.merge(billboard_all, spotify_all, how='left', on=['Name', 'Artists', 'BB.Week'])

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    In the second challenge, you concatenated the two Billboard datasets into one 0:00
    combined Billboard data frame. 0:03
    And you did the same with the Spotify datasets. 0:06
    So our final step would be to merge the combined billboard data frame and 0:09
    the combined Spotify data frame. 0:13
    We will perform a left join on the columns Name, Artists, and BB.Week. 0:16

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up