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

Creating Final Dataset

2:31 with Richard Tillies

Welcome back! In this video, we will create our final dataset by merging and concatenating our original datasets into one large DataFrame.

Create final dataset of Ariana Grande song data

ariana_final = pd.merge(ariana_bill_all, ariana_spot_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

    concatenating our original datasets into one large data frame. 0:00
    Let's look at our Ariana Grande data to see how to do it. 0:02
    We have one dataset with all Ariana's billboard data, 0:06
    ariana_bill_all.shape. 0:12
    We have one dataset with all of Ariana's Spotify data, 0:18
    ariana_spot_all.shape. 0:24
    So, let's merge these two combined datasets into our final dataset, 0:29

    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