Dataford - Ace your Data Interview

You are analyzing the performance of Airbnb listings. The goal is to categorize each listing based on its number of bookings and average customer rating. You will be using the listings table from Airbnb:

Column Name	Description
listing_id	A unique identifier for each Airbnb listing.
listing_name	The name or title of the Airbnb listing.
host_id	The identifier for the host of the listing.
booking_count	The total number of bookings that the listing has received.
average_rating	The average rating ranging from 1 to 5 (highest)

Determine the number of listings that fits into each performance category. The 'performance_category' should be determined based on the following criteria:

'Top Performer' if the listing has more than 50 bookings and an average rating of 4.5 or higher.
'High Performer' if the listing has 20 to 50 bookings and an average rating between 4.0 and 4.5.
'Moderate Performer' for 5 to 19 bookings and an average rating of 3.0 to 4.0.
'Needs Improvement' are those that don't meet any of the criteria above.

Example Output:

performance_category	count
Needs Improvement	12
Top Performer	32
High Performer	10
Moderate Performer	7

Modules

Listing Performance Analysis

Example Output:

Listing Performance Analysis

Example Output: