Subject: data mining for business analytics: concepts, techniques, and applications in R.

Need scripts in R and simple analysis

Source data file: winemag-data-130k-v2.csv

see the link

https://gist.github.com/clairehq/79acab35be50eaf1c383948ed3fd1129

Assignment

Problem

Larry Delgado owner of House Wine & Bistro has been experiencing a decrease in revenue, even that according to the PO records the restaurant is keeping a steady amount of order purchases. He discovered that his customers are not ordering as much wine as before, a significant decrease in consumption of wine is causing a decrease in revenues. The main concept of the restaurant is to pair wines with food. If this trend holds, his restaurant will be just like any other and he will lose his key differentiator against his competitors. Mr. Delgado would like to revamp the wine menu. He would like to see diverse wines, with good taste, yet keeping the price in mind since the end goal is to create revenue. Mr. Delgado will be eliminating the 10 worst wines sold in his restaurant and substituting them with the suggestions we would make based on data collected from WineEnthusiast.

Solution

The purpose of our research is to analyze wines that different consumer segments enjoy.

Through our research,

1. We are going to provide the top 10 wines for Larry Delgado, owner of House Wine & Bistro.
2. They will be including these wines in their menu in the next fiscal year.
3. We will base the top 10 wines based on different variables for different consumer segments. For example, a consumer segment in the wine industry is Premium Brand Surburban's. These individuals are frequent wine drinkers but are also among the lowest spenders per bottle (Arthur, 2018).
4. For this, we would base the top 10 options based on the highest average points and lowest average price.
5. If House Wine & Bistro chooses to target this specific segment they could do so through this research.
6. There are 5 other wine consumer segments for which we will provide the top 10. These are Engaged Explorers, Premium Brand Suburban's, Contented Treaters, Social Newbies, Senior Bargain Hunters, and Kitchen Casuals (Arthur, 2018).

Models that we will be using:

Decision trees,

KNN,

Dimension reduction,

Nave Bayes Classifier,

Classification and Regression trees,

Confusion Matrix,

Accuracy measures,

Data Visualization.

The reason for these models is dependent on what we are looking for.

The decision tree model will be used to assist Mr. Delgado in choosing which path he would like to take.

The KNN model will be used to classify records of the types of wines there are in the dataset.

The Nave Bayes Classifier model will be used to determine what wines will better perform for specific consumer segments.

The Classification and Regression trees will be used to determine what wines will perform the best depending on their variables to consumer segments.

The Confusion Matrix to determine the accuracy of our classification models.

We will also be taking accurate measures and providing data visualizing to maintain true to our statements and provide an overview of our statements.

The information in our data sets includes:

Column	Description
country	The country that the wine is from
description	Aroma, structure, flavors, etc
designation	The vineyard within the winery where the grapes that made the wine are from
points	The number of points WineEnthusiast rated the wine on a scale of 1-100 (though they say they only post reviews for
price	The cost for a bottle of the wine
province	The province or state that the wine is from
region_1	The wine-growing area in a province or state (ie Napa)
region_2	Sometimes there are more specific regions specified within a wine-growing area (ie Rutherford inside the Napa Valley), but this
taster_name	Name of tester
taster_twitter_handle	Twitter handle of tested
title	The title of the wine review, which often contains the vintage if you're interested in extracting that feature
variety	The type of grapes used to make the wine (ie Pinot Noir)
winery	The winery that made the wine