Suppose you work at Yelp. You have been tasked with a new initiative to create a new award for the highest performing food establishments represented on the Yelp platform. The team at Yelp has determined that any food establishment that has both the highest stars rating AND th largest total number of reviews (review_count) in their city deserves the Best Local Food Establishment Award. You have been tasked with writing Python code that can determine which food establishments in a data set deserve this new prestigious award. For this exercise, create a DataFrame containing all the food establishments in the food_establishments data that deserve Best Local Food Establishment Award for every city/state combination (to avoid issues with cities that have the same name). The final table that you are to create, called best_food_establishments, should provide the name, city, state, review_count, and stars ratings of all of the food establishments that deserve the award. Important Notes: There are some slight variations in some city names like: Las Vegas, Las Vegas, las vegas. You do not need to worry about cleaning this up before performing your analysis, this is really a proof-of-concept for your team. Also, some cities will have no food establishments that deserve to receive this award as it is possible that the food establishment with the largest number of reviews does not have the highest rating in the city.
Suppose you work at Yelp. You have been tasked with a new initiative to create a new award for the highest performing food establishments represented on the Yelp platform. The team at Yelp has determined that any food establishment that has both the highest stars rating AND th largest total number of reviews (review_count) in their city deserves the Best Local Food Establishment Award. You have been tasked with writing Python code that can determine which food establishments in a data set deserve this new prestigious award. For this exercise, create a DataFrame containing all the food establishments in the food_establishments data that deserve Best Local Food Establishment Award for every city/state combination (to avoid issues with cities that have the same name). The final table that you are to create, called best_food_establishments, should provide the name, city, state, review_count, and stars ratings of all of the food establishments that deserve the award. Important Notes: There are some slight variations in some city names like: Las Vegas, Las Vegas, las vegas. You do not need to worry about cleaning this up before performing your analysis, this is really a proof-of-concept for your team. Also, some cities will have no food establishments that deserve to receive this award as it is possible that the food establishment with the largest number of reviews does not have the highest rating in the city.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
python
not sure how to do the city/state combination element
Transcribed Image Text:Suppose you work at Yelp. You have been tasked with a new initiative to create a new award for the highest performing food establishments
represented on the Yelp platform. The team at Yelp has determined that any food establishment that has both the highest stars rating AND th
largest total number of reviews (review_count) in their city deserves the Best Local Food Establishment Award. You have been tasked with
writing Python code that can determine which food establishments in a data set deserve this new prestigious award.
For this exercise, create a DataFrame containing all the food establishments in the food_establishments data that deserve Best Local Food
Establishment Award for every city/state combination (to avoid issues with cities that have the same name). The final table that you are to
create, called best_food_establishments, should provide the name, city, state, review_count, and stars ratings of all of the food
establishments that deserve the award.
Important Notes: There are some slight variations in some city names like: Las Vegas, Las Vegas, las vegas. You do not need to worry about
cleaning this up before performing your analysis, this is really a proof-of-concept for your team. Also, some cities will have no food
establishments that deserve to receive this award as it is possible that the food establishment with the largest number of reviews does not
have the highest rating in the city.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education