Data Mining (3160714) 200170107069
Experiment No - 3
Aim: To perform hand on experiments of data preprocessing with sample data on Orange tool.
Date:
Competency and Practical Skills: Exploration and Understanding of Tool
Relevant CO: CO1 & CO4
Objectives: 1) improve users' understanding of data preprocessing techniques
2) Familiarize them with the tool
.
Equipment/Instruments: Orange tool
Demonstration of Tool:
Data Preprocessing With Orange tool
Preprocesses data with selected methods. Inputs Data: input dataset Outputs Preprocessor:
preprocessing method Preprocessed Data: data preprocessed with selected methods Preprocessing is
crucial for achieving better-quality analysis results. The Preprocess widget offers several
preprocessing methods that can be combined in a single preprocessing pipeline. Some methods are
available as separate widgets, which offer advanced techniques and greater parameter tuning.
Fig. Handling Missing Values
1. List of preprocessors. Double click the preprocessors you wish to use and shuffle their order by
dragging them up or down. You can also add preprocessors by dragging them from the left menu to
the right.
2. Preprocessing pipeline.
Data Mining (3160714) 200170107069
3. When the box is ticked (Send Automatically), the widget will communicate changes
automatically. Alternatively, click Send.
⮚ Preprocessed Technique :
[ Fig: Continuous Descrete variables -> Most Frequent is base Used ]
Data Mining (3160714) 200170107069
⮚ Data Table of Preprocessed Data
⮚ Scatter Plot of Age vs Job
⮚ Data table of Correlation
Data Mining (3160714) 200170107069
⮚ Discretize Data table
⮚ Randomize Data Table
Data Mining (3160714) 200170107069
⮚ Continuos Data Table
Conclusion:
Orange is a powerful open-source data analysis and visualization tool for machine learning and data
mining tasks. It provides a wide variety of functionalities including data visualization, data
preprocessing, feature selection, classification, regression, clustering, and more. Its user-friendly
interface and drag-and-drop workflow make it easy for non-experts to work with and understand
machine learning concepts.
Quiz:
(1) What is the purpose of Orange's Preprocess method?
� The purpose of Orange's Preprocess method is to prepare and transform raw data into a
form that is more suitable for analysis and modeling
(2) What is the use of orange tool?
� The use of Orange tool: Preprocess and clean data
Visualize data
Workflow and automation
Data Mining (3160714) 200170107069
Perform classification, regression, clustering, and other tasks.
Suggested Reference:
1. J. Han, M. Kamber, “Data Mining Concepts and Techniques”, Morgan Kaufman
2. [Link]
References used by the students:
1. [Link]
2. [Link]
dataset
Rubric wise marks obtained:
Problem Tool Usage/
Knowledge Communicati
Recognition Demonstrati Ethics (2)
Rubrics (2) on Skill (2) Total
(2) on (2)
Good Average Good Average Good Average Good Average Good Average
(2) (1) (2) (1) (2) (1) (2) (1) (2) (1)
Marks