2021: Week 23 - NPS for Airlines

Introduction

This week Prep Air are looking into their Net Promoter Score (NPS) and how this compares with a variety of other new airlines. NPS usually takes the form of asking customers "How likely ae you to recommend this company on a scale of 0-10?" You then subtract the detractors of your company from the promoters and end up with a score between -100 and +100. The higher the NPS, the better!

Requirements

The requirements for this week's challenge can be found here - 2021: Week 23 | Preppin Data

Solution

The solution will be available below, but please post your solutions and questions!