A solution to last week's challenge can be found here.
Find My Pet US is a platform that helps animal owners find their lost pets in animal shelters in the United States. Find My Pet US wants to expand its business. A data analyst hired by the company is researching various scenarios.
One of the scenarios investigated by the data Analyst includes the following two conditions:
• Pet owners who are offering a reward equal and over $2,700, and;
• Pet owners living within 500 miles from the shelter where the pet is.
The dataset “Pet_info” contains information about the pets. The dataset “Animal_Rewards” lists the rewards associated with the animal ID. The dataset “Owner_Info” provides information about the owners.
Use the datasets to find out which animal owners to target based on the two conditions of this scenario.
