Exercise

Merging on different sets of fields

As you saw in the previous exercise, both customer_data and app_purchases have a common 'uid' column that you can use to combine them. If you explored them further, you would discover that they also have a common date column that is named 'date' in app_purchases and 'reg_date' in customer_data.

In this exercise you will explore merging on both of these columns and looking at how this impacts your final results.

The two datasets from the previous exercise - customer_data and app_purchases- have been loaded for you, with 'reg_date' in customer_data renamed to 'date'.

Instructions 1/2

undefined XP
  • 1

    Merge customer_data with app_purchases, combining on the 'uid' column.

  • 2

    To look at purchases that happened on the date of registration, merge customer_data to app_purchases on 'uid' and 'date'.