Outubro 2015

PURPOSE:

Identify how much the cultural aspects can influence the preferences/comments of the Yelpers in two similar sized cities
and from two different continents: Pittsburgh - USA and Edinburgh - Scotland.

TOPICS

    > Introduction  

    > Data Analysis   

    > Results/Final Comments
.
.
    >Data source:https://www.yelp.com/dataset_challenge

Introduction

This work, analized statistically the words on 1000 reviews done by YELPERs in Pittsburgh and 1000 reviews done by YELPERs in Edinburgh, the opinions were split by their rating, 1/2 stars and 4/5 stars, based on the results was possible to identify the most frequent words in the reviews and also extract valuable information from the needs and behaviors of the YELPERs in these two cities.

The packages utilized were:

  • TEXT MINING: which involves the process of structuring the input text (usually parsing, along with the addition or removal of some derived linguistic features), deriving patterns within the structured data, and finally evaluation and interpretation of the output.

  • RANDOM FOREST: Improves the accuracy of the outcomes by generating a large number of trees, classifying and combining the results across all of the trees.

  • CTree: A non-parametric class of regression trees embedding tree-structured regression models into a well defined theory of conditional inference procedures. It is applicable to all kinds of regression problems.

Data Analysis ( summarized )

CTree ( Conditional Inference)

Ratings 1/2 stars

Ratings 4/5 stars

Results/Final Comments

.

SUMMARY: Based on these data, although the accuracy is not very high and can be a starting point for more deep and accurate future analysis, it is possible affirm that exist a higher intolerance of the yelpers in Edinburgh related to the service of the attendance, expressed by the word "staff" which was more explored in their lower rating comments, on the other side for the higher rating, the yelpers in Pittsburgh tend to be more loyal with the place than the yelpers in Edinburgh, expressed by the word "favorite" which can be related to the local, food or service.

.
.
.

FINAL COMMENTS: the entrepreneurs/investors aiming to start up and/or improve their food business, if located in Edinburgh should improve/pay more attention in the quality of the service, and also propose action to attract and retain the customers for their business while in Pittsburgh all the attention should be concentrated in actions to understand the root cause of the current loyalty and implement actions to not lose them