



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Data Warehouse Lab ARFF and CSV formats Preprocessing filters on Weather dataset 1.Add 2.Remove 3.Discretize 4.Replace Missing values 5.Normalize
Typology: Study notes
1 / 7
This page cannot be seen from the preview
Don't miss anything!
Aim: Create a dataset using ARFF and CSV formats and load into the Weka Explorer. Description: We need to create an Employee Table with training data set which includes attributes like name, id, salary, experience, gender, phone number. Procedure: Steps for creating and loading .arff file. 1) Open Start 🡪All Programs🡪 Accessories🡪Notepad 2) Type the following training data set with the help of Notepad for Employee Table. @relation employee @attribute name {x,y,z,a,b} @attribute id numeric @attribute salary {low,medium,high} @attribute exp numeric @attribute gender {male,female} @attribute phone numeric @data x,101,low,2,male, y,102,high,3,female, z,103,medium,1,male, a,104,low,5,female, b,105,high,2,male, 3) After that the file is saved with .arff file format. 4) Minimize the arff file and then open Start 🡪 Programs🡪 weka-3-4. 5) Click on weka-3-4 , then Weka dialog box is displayed on the screen. 6) In that dialog box there are four modes, click on Explorer. 7) Explorer shows many options. In that click on ‘open file’ and select the arff file 8) Click on edit button which shows employee table on weka. Steps for creating and loading CSV file.
“Save” button. Click "OK" to save.
Add 🡪 Pre-Processing Technique: Procedure: 1) Start🡪 Programs 🡪 Weka-3-4 🡪Weka-3- 2) Click on explorer. 3) Click on open file. 4) Select Weather.arff file and click on open. 5) Click on Choose button and select the Filters option. 6) In Filters, we have Supervised and Unsupervised data. 7) Click on Unsupervised data. 8) Select the attribute Add. 9) A new window is opened. 10) In that we enter attribute index, type, data format, nominal label values for Climate. 11) Click on OK. 12) Press the Apply button , then a new attribute is added to the Weather Table. 13) Save the file. 14) Click on the Edit button , it shows a new Weather Table on Weka.
Weather Table after adding new attribute CLIMATE: Remove Pre-Processing Technique: Procedure: 1) Start 🡪All Programs 🡪 Weka-3- 2) Click on Explorer. 3) Click on open file. 4) Select Weather.arff file and click on open. 5) Click on Choose button and select the Filters option. 6) In Filters, we have Supervised and Unsupervised data. 7) Click on Unsupervised data. 8) Select the attribute Remove. 9) Select the attributes windy, play to Remove. 10) Click Remove button and then Save. 11) Click on the Edit button , it shows a new Weather Table on Weka.
Weather Table after Normalizing TEMPARATURE, HUMIDITY: Result: This program has been successfully executed.