I plan to look at the count of ratings for each rating (ratings are on scale 1-5). Understanding this data can be helpful in determining if Yelp is used more to complain/ point out shortcomings or rave about outstanding experiences.
After examining the count of reviews for each rating (1-5) we can
determine that no restaurant or brewery categorized by beer was rated
lower than 3, and most review were on places rated a 4. We can infer
that individuals enjoy raving about the best beer places rather than
complaining. On the other hand, wing joints have ratings ranging from
2-5. Most of the reviews come from ratings with a 4.5. While most
reviews certainly come from the 4.5 rating, it is interesting to see
that individuals are much more willing to rank wings joints lower. I
would assume this is true because people are typically more picky when
it comes to choosing food.
I plan to look at the count distribution of cities based on the
prices described for each in Yelp.
After examining results, we can identify that Cincinnati dominates in
both beer locations as well as wing locations. We can also see that wing
locations do not have any locations with price noted as $$$. It clear
that no other city comes close to competing with Cincinnati. This is
likely due to the vastness of bars and restaurants located in Downtown
Cincinnati. These locations draw in great crowds before large events,
unlike some smaller owned shops in the tristate.
I plan to examine this question by separating each rating and then separating each rating by its associated price point.
These two graphs allow us to determine that a rating of 4.5 is most common as well as $ $ price point. It would have been interesting to see price points of $ $ $ reviewed as a 5 or lower than 3.5. I think seeing a higher price point with a very high or low rating would be more helpful than an average rate. Seeing if the food/drink and price are compatible would be more telling than seeing just another average rating of food or drink. If I saw a high priced restaurant or brewery rated similar to one with a $ price point, I would be less willing to spend money on the more expensive venue.