1. Learn
    2. /
  2. Courses
    3. /
  3. Cleaning Data in Python

Exercise

Pairs of restaurants

In the last lesson, you cleaned the restaurants dataset to make it ready for building a restaurants recommendation engine. You have a new DataFrame named restaurants_new with new restaurants to train your model on, that's been scraped from a new data source.

You've already cleaned the cuisine_type and city columns using the techniques learned throughout the course. However you saw duplicates with typos in restaurants names that require record linkage instead of joins with restaurants.

In this exercise, you will perform the first step in record linkage and generate possible pairs of rows between restaurants and restaurants_new. Both DataFrames, pandas and recordlinkage are in your environment.

Instructions 1/2

undefined XP
    1
    2
  • Instantiate an indexing object by using the Index() function from recordlinkage.
  • Block your pairing on cuisine_type by using indexer's' .block() method.
  • Generate pairs by indexing restaurants and restaurants_new in that order.