We provide the solution to this challenge using:
Need a program? Click here.
Brittany is on the tail-end of busy season and is believably burned out. This morning, she woke up to a tap on her shoulder and was both bewildered and bothered to find her boss blinking back at her. “Bertha, what are you doing in my house?” she breathed, groggily. Bertha bluntly brought up that they were actually in the office. “Brittany, you reek of anxiety, chow mein, and burnout. You’ve been working yourself too hard, so I’m sending you on a paid vacation before you go berserk.” Blown away, Brittany agreed and thanked Bertha.
Because Bertha is a good boss, she will pay for the vacation and allow Brittany to select the destination. Based on her preferences below, help Brittany find the best option!
Bertha is rich in resources but isn’t very resourceful. The data she provided Brittany is a mess. In her burned-out state, Brittany isn’t bright enough to google the information herself, but she’s brilliant in Alteryx, especially Regex, and decides to deal with what she’s been given. Brittany can sense the beach beckoning to her and wants to be close to an ocean. She’s also aiming for somewhere warm, and because Bertha is paying, Brittany wants to break Bertha’s Bank. Your goal is to find the most expensive destination with an average temperature warmer than 75 degrees Fahrenheit and a beach that is closer than 5 miles away.
- Input, parse, and clean the data.
- From the Destination column on the first sheet, create two new columns: DestID and DestName
- From the Distance column on the second sheet, create the following new columns: DestID, DestName, ClosestBeach, Dist1, Unit1, Dist2, Unit2
- From the Coordinates column on the third sheet, create the following new columns: DestID, Lat, Long
- From the Temperature column on the fourth sheet, create two new columns: DestName, TempC
- Using the data on the fifth sheet, create a new column called TotalCost that shows the total cost of the trip.
- Join all the data.
- Create a new column called MilesToBeach that shows how close the destination is to the beach, in miles.
- Create a new column called TempF that converts the average temperatures from Celsius to Fahrenheit. Remember that (Celsius *9/5) + 32 is the correct conversion.
- Filter out destinations that are 5 miles or further away from a beach and 75 degrees Fahrenheit or cooler.
- After filtering based on Brittany’s preferences, select the destination that costs the most.
Suggestions and Hints
- If the RegEx is giving you trouble, consider looking through some of the preset expressions. There are several ways to write the syntax but using the “^” symbol may prove useful.
- If you end up with a tie, consider using the coordinates to make sure each destination is actually near an ocean.