Analysis of Yelp Reviews for Rhinegeist and Madtree

This data comes from yelp. Two local breweries in Cincinnati, Ohio. The two breweries are Madtree and Rhinegeist, two well known brewers that ship nationally. The data in this will be looking at their yelp reviews and seeing how positive or negative they are.

##Average Yelp Review This is the average yelp rating and the median yelp rating of both breweries.

## # A tibble: 2 × 3
##   brewery    `avg rating` `median rating`
##   <chr>             <dbl>           <dbl>
## 1 madtree            4.31               5
## 2 rhinegeist         4.27               5

Looks like Madtree is just barely ahead! but both have amazing reviews, if you are in Cincinnati, you should check both out.

#count of top 10 most used words per brewery

## `summarise()` has grouped output by 'word'. You can override using the
## `.groups` argument.
## # A tibble: 20 × 3
## # Groups:   word [14]
##    word       brewery        n
##    <chr>      <chr>      <int>
##  1 beer       rhinegeist   552
##  2 beer       madtree      466
##  3 pizza      madtree      280
##  4 brewery    rhinegeist   279
##  5 rhinegeist rhinegeist   249
##  6 madtree    madtree      214
##  7 space      rhinegeist   206
##  8 beers      madtree      169
##  9 beers      rhinegeist   165
## 10 bar        rhinegeist   163
## 11 space      madtree      157
## 12 love       madtree      154
## 13 bar        madtree      150
## 14 food       madtree      148
## 15 rooftop    rhinegeist   142
## 16 friendly   madtree      141
## 17 love       rhinegeist   137
## 18 brewery    madtree      135
## 19 time       madtree      132
## 20 cincinnati rhinegeist   130

Not shockingly, both bars most reviewed word is ‘Beer’. Who would have guessed?

#which brewery mentions dogs more? Nothing is better than drinking beer and petting dogs!

## # A tibble: 2 × 2
##   brewery        n
##   <chr>      <int>
## 1 madtree       99
## 2 rhinegeist     1
## `summarise()` has grouped output by 'word'. You can override using the
## `.groups` argument.
## Joining, by = "word"

MadTree is the clear winner. With 99 separate uses, feel free to bring your pup to madtree while enjoying their brews.

#Sentiment

This is showing the sentiment analysis of the most used word per each brewery, (n>75). If you are in charge of either of these breweries, you must be extremely happy, every word has a positive sentiment.