What is best source of wine in optimum price-rating ratio

Assignment Help Database Management System

Reference no: EM132261857

Question: Australian Wine Importers (AWI) asked you to develop a data mining method of classifying imported wines based on:

• Price category (as 5 equal size bins)

AWI provided you with a sample of 130,000 wine tasting results, which include:

• Taster name and twitter handle;

• Wine "title" (name + vintage);

• Country, Province and Region;

• Variety and Winery;

• Description and Designation (text data);

• Price (US$) and Points (taster's rating).

As there are great many tasting results, AWI would like to get the preliminary insight into the wine's origin and its marketability.

The following questions are of interests to AWI:

A) What is the best source of wine in the optimum price-rating ratio? and,

B) What is the expected price range category of newly imported wines?

C) Can all wine tasters in the data set be trusted with their tasting results?

AWI wants you to cleanup and explore wine tasting data, develop and evaluate a classifier to determine the price range for new wines, and to minimize classification errors.

In technical terms: Your project objectives form a learning portfolio. The first objective (LP1) is to acquire and explore the available data, visualise and report any significant characteristics of non-text data, as well as, prepare the data for further processing.

Reference no: EM132261857

Questions Cloud

Analyze process states for your preferred operating system : In this assignment, you will analyze the process states for your preferred operating system. This analysis will prepare you for the process management.

Why is sexual harassment important : Why is sexual harassment important in the workplace and what are consequences of it?

Brief description of the business problem : Brief Description of the Business Problem/ Opportunity you Plan to Address and a General Description of your Strategy.

Consider different types of qualitative data collection : Summarize the use of qualitative data to support business decision making. Consider different types of qualitative data collection.

What is best source of wine in optimum price-rating ratio : Australian Wine Importers (AWI) asked you to develop a data mining method of classifying imported wines based on: Price category (as 5 equal size bins).

Penetrating price and skimming price strategies : Can you think of a type of business or an industry that can naturally benefit from one or the other price strategies?

Explain the greater benefit in the long-term this decision : Explain the greater benefit in the long-term this decision provides and conclude your memo.

Tension between departments due to organization : There has been increased tension between departments due to organization wide changes brought about by a recent merger.

Describe how externality of make new homeless shelter : Externalities can have a significant positive or negative affect on a property's value. Describe how externality of make new homeless shelter

User Account

All Pages