Discussing about data preprocessing steps

Assignment Help Database Management System
Reference no: EM131079516

Assignment Project: Data Mining using R

The goal of this project is to applying association rule mining, classification and clustering methods on the Mushroom and groceriesdata sets. For detailed information about the mush room data set, refer to the Machnie Learning Repository (https://archive.ics.uci.edu/ml/datasets.html) provided by the University of California, Irvine. You can download and read more about the data there.

The groceries Dataset

Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That is exactly what the Groceries Data Set contains: a collection of receipts with each line representing 1 receipt and the items purchased. Each line is called a transaction and each column in a row represents an item.

Task 1: Data Pre-processing

Read the data in R. There are many ways to read in csv tables in R. For more details, please refer to data import/export in R
https://cran.r-project.org/doc/manuals/r-release/R-data.pdf

For the clustering experiments, the column for class labels need to be removed. Refer to lecture Module 10 to see how to do so.
Verify if any other pre-processing is beneficial for the analysis. For example, replacing missing values, attribute range normalization, converting numerical or string to nominal values etc.

Task 2: Data Mining

• Association Rule Mining experiments: Using R to explorer "association rules" on the groceries dataset.Try out different algorithms. Visualize the result you found. Report any interesting association rules discovered in the experiments and explain why they are interesting.

• Classification experiments: Using to construct classifiers on the mushroom dataset. Randomly split the data set in the training and test data set (80% v.s. 20%). Select at least one classifier from each of the following two categories of classifiers: Tree-based models, Bayes classifiers, and Rule-based classifiers. Compare the result of the chosen classifers.

• Clustering experiments: Using R explorer clusters on the mushroom dataset.Select and compare two clustering algorithms from R (e.g. k-means v.s. density-based). Use R to visually explore the resulting clusters.

• For all the above experimentations, try different parameter settings to fine tune the outcome. In principle select methods that work well on the given data set.

Task 3: Prepare a report

Your report should contain the following:

• Theoretical Discussion: Limited to two pages discussing about data preprocessing steps, the motivation for selecting a particular method, and how the parameters are chosen.

• Results: Include results and screenshots of the above experimentations.

• Discussion and error analysis: Try to interpret the results of your model. Discuss intuitions or hypothesis that can be obtained by visual inspections of the resulting classes or clusters. Mention about assumptions if any, discuss issues that might have affected the model's performance.

• References: If you are using information from other sources apart from R manual and official website, you should cite them.

Attachment:- Assignment.rar

Reference no: EM131079516

Questions Cloud

What is the current market price of these bonds : Jackson Corporation's bonds have 5 years remaining to maturity. Interest is paid annually, the bonds have a $1,000 par value, and the coupon interest rate is 11%. The bonds have a yield to maturity of 8%. What is the current market price of these bon..
The internal rate of return : The internal rate of return
Debt versus equity financing : You are considering a stock investment in one of two firms (AllDebt, Inc., and AllEquity, Inc.), both of which operate in the same industry and have identical operating income of $7.00 million. Calculate the income available to pay the asset funders ..
Production function in range : In a small European country, it is estimated that a $10,000 increase in capital per hour worked will increase real GDP per hour worked by $300. Based on this information, what is the slope of the per-worker production function in this range?
Discussing about data preprocessing steps : NIT6160 Assignment Project: Data Mining using R. Your report should contain the following: Theoretical Discussion: Limited to two pages discussing about data preprocessing steps, the motivation for selecting a particular method, and how the paramet..
Changing the level of capital : In a small European country, it is estimated that changing the level of capital from $8 million to $10 million will increase real GDP from $2 million to $3 million.
Evaluate three capital projects : Your company just informed you that they have a cost of capital of 14 percent and request that you evaluate three capital projects. The internal rates of return are as follows: Project Internal Rate of Return 1 12% 2 15% 3 13% Your recommendation is ..
Express f(t) as a fourier series expansion : Express f(t) as a Fourier series expansion.
The types of compensation top-level managers receive : Write a maximum 2 page MLA paper that will discuss the types of compensation top-level managers receive and their effects on managerial decisions.

Reviews

Write a Review

Database Management System Questions & Answers

  Modifying a database design in visio

Modifying a Database Design in Visio- This assignment contains two (2) Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment

  Write down a 350-word summary explaining two of the most

write a 350-word summary describing two of the most popular database vendors in the marketplace. answer the following

  Create a relational database schema

Draw the ER diagram for the database described above and create a relational database schema for this model assuming

  1nf figure converted to 2nf figure

1NF figure converted to 2NF figure with a explanation of the steps taken. Once in 2NF, it needs to be converted to 3NF, and explanation of steps taken is needed as well.

  Find the year when maximum number of faculty

Find the year when maximum number of faculty were hired - List the number of courses (not offerings) taught in 2006 by faculty rank and department excluding the ones with zero courses taught.

  Difference between obsolescent and redundant stocks

Difference between obsolescent and redundant stocks

  Create a table for patients with information

Create a table (by your own imagination) which comprises the least 25 patients with next information (columns): Calculate average of Value1 for each Gender.

  Describe data modeling tool such as erwin or rational rose

Consider the UNIVERSITY database described in Exercise Build the ER schema for this database using a data modeling tool such as ERwin or Rational Rose.

  How do databases generate sales and profits

Why are databases important to business. How do databases generate sales and/or profits. What databases do you interact with, and how do they benefit you

  Calculate the total expenditure for each of the categories

The data in the table on the data sheet contains the operational expenditure and the budget for a small department.

  Determine functional dependencies of table

Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table.

  What is referential integrity

Pathivadr's (2009) article addresses a fundamentally critical function in the relational model DB-referential integrity. What is referential integrity

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd