Subject : Data Mining Lab Manual
BCA Sem.-4 Model: 1
Experiment No.: 1
Aim : Create an Employee Table with the help of Data Mining Tool WEKA.
Description: We need to create an Employee Table with a training data set which includes attributes like name, id, salary, experince, gender, phone number.
Procedure:
Steps:
Open Start ➡️ Programs ➡️ Accessories ➡️ Notepad.
Type the following training data set with the help of notepad for employee table.
a. relation employee
a. attribute name {x,y,z,a,b}
a. attribute id numeric
a. attribute salary (low, medium, high)
a. attribute exp numeric
a. attribute gender (male, female)
a. attribute phone numeric
a. Data:
x, 101, low, 2, male, 250311
y, 102, high, 3, female, 251665
z, 103, medium, 1, male, 240238
a, 104, low, 5, female, 20020
b, 104, high, 2, male, 240240
that the file is saved with add file format.
2. Minimize the add file and than open start ➡️ program ➡️ WEKA -3-4
Click on WEKA -3-4 then WEKA dialogue box is displayed on the screen.
In that dialogue box there are four modes click on explorer.
Explorer shows many options In that click on open file and select the file..
Click on edit button which shows employee table on WEKA.
Experiment No.: 2
Aim: Create a Weather Table with the help of Data Mining Tool WEKA.
Description: We need to create a Weather table with training data set which includes attributes like, outlook, temperature, humidity, windy, play.
Procedure:
Steps:
Open ➡️ Start ➡️ Program ➡️ Accessories ➡️ Notepad.
Type the following training data set with the help of Notepad for weather table.
a. relation weather
a. attribute outlook {sunny, rainy, overcast}
a. attribute temperature numeric
a. attribute windly, {true, false}
a. attribute play { yes, no}
a. Data:
sunny, 85.0, 85.0, false, no
overcast, 80.0, 90.0, true, no
sunny, 83.0, 86.0, false, yes
rainy, 70.0, 80.0, false, yes
overcast, 64.0, 65.0, false, yes
sunny, 72.0, 95.0, true, no
sunny, 69.0, 70.0, false, yes
rainy, 75.0, 80.0, false, yes
After that the file as saved with all file format.
Minimize the file and than open start ➡️ program ➡️ WEKA -3-4.
Click WEKA-3-4, then WEKA dialog box is displayed on the screen.
In that dialog box there are four modes click on explorer.
Explore shows many options In that click on open file and select the ARFF file.
Click on edit button which shows weather table on WEKA.
Experiment No.:3
Aim: Apply Pre-processing techniques to the training data set of Weather Table.
Description: Real world databases are highly influenced to noise, missing, and inconsistency due to their queue size so the data can be pre-processed to improve the quality of data and missing results and it also improves the efficiency.
There are 3 pre-processing techniques they are:
Add
Remove
Normalization
Creation of Weather Table :
Procedure:
Open ➡️ start ➡️ Program ➡️ Accessories ➡️ Notepad.
Type the following training data set with the help of Notepad for weather table.
a. relation weather
a. attribute outlook {sunny, rainy, overcast}
a. attribute temperature numeric
a. attribute humidity numeric
a. attribute windly {true, false}
a. attribute play {yes, no}
a. Data:
sunny, 85.0, 85.0, false, no
overcast, 80.0, 90.0, true, no
sunny, 83.0, 86.0, false, yes
rainy, 70.0, 86.0, false, yes
rainy, 68.0, 80.0, false, yes
overcast, 64.0, 65.0, true, no
sunny, 69.0, 70.0, false, yes
rainy, 75.0, 80.0, false, yes
After that the file is saved with ARFF file format.
Minimize the ARFF file and than open ➡️ Start ➡️ Program ➡️ WEKA-3-4.
Click on WEKA-3-4 then WEKA dialog box is displayed on the screen.
In that dialog box there are four modes click on explorer.
Explorer shows many options In that click on open file and select the ARFF file.
Click on edit button which shows weather table on WEKA. Add pre-processing technique.
Procedure:
Start ➡️ Programs ➡️ WEKA-3-4
Click on explores.
Click on open file.
Select weather ARFF file and click on open
Click on choose button and select the filter option.
In filter, we have supervised and unsupervised data.
Click on unsupervised data.
Select the attribute add.
A new window is opened.
In that we enter attribute index type data format nominal level value for climate
Click on OK.
Press the apply latter than a new attribute as added to the weather table.
Save the file.
Remove Pre-processing technique:
Procedure :
Start ➡️ Program ➡️ WEKA-3-4 ➡️ WEKA-3-4.
Click on explorer.
Click on open file.
Select weather ARFF file and click on open.
Click on choose button and select the printer option.
In printer, we have have supervised data.
Click on unsupervised data.
Select the attribute remove.
Select the attribute windly play and remove.
Click remove button and then save.
Click on the edit button it shows a new weather table on WEKA.
Normalize Pre-processing Technique:
Procedure :
Start ➡️ Program ➡️ WEKA-3-4 ➡️ WEKA-3-4.
Click on explore.
Click on open file.
Select weather ARFF file and click on open.
Click choose button and select the printer option.
In printer we have supervised and unsupervised data.
Click on unsupervised data.
Select the attribute normalized.
Select the attribute temperature humidity to normalize.
Click on the edit button, it shows a new weather table with normalized value on WEKA.
Weather table after normalizing TEMPERATURE HUMIDITY.
Experiment No.:4
Aim: Apply pre-processing techniques to the training data set of Employee Table
Description: Real world databases are highly influenced to noise, missing and inconsistency due to their queue size so the data can be pre-processed to improve the quality of data and missing results and it also improves the efficiency.
There are 3 pre-processing techniques they are :
Add
Remove
Normalization
Creation of Employee Table :
Procedure :
Open ➡️ Start ➡️ Programs ➡️ Accessories ➡️ Notepad .
Type the following training data set truth the help of notepad for employee table.
a. relation employee
a. attribute name {x,y,z,a,b}
a. attribute id numeric
a. attribute salary {low, medium, high}
a. attribute exp. numeric
a. attribute gender {male, female}
a. attribute phone numeric
a. Data:
x, 101, low, 2, male, 250311
y, 102, high, 3, female, 251665
z, 102, high, 5, female, 200200
a, 104, low, 1, male, 240328
b, 105, high, 2, male, 140240
3. After that the file is saved with ARFF file format.
4. Minimize the ARFF file and then open ➡️ Start ➡️ program ➡️ 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 module click on explore.
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.
WORK IN PROCESS
...
Comments