Importing data from an Excel file

Description

The process demonstrates how to import data from Excel files using the Read Excel operator. The Concrete Compressive Strength data set is used in the experiment. Parameters of the Read Excel operator are set via its Import Configuration Wizard.

Input

Concrete Compressive Strength [UCI MLR] [Concrete]

Output

An ExampleSet that contains data imported from the Excel file.

Figure 3.3. Metadata of the resulting ExampleSet.

Metadata of the resulting ExampleSet.

Figure 3.4. A small excerpt of the resulting ExampleSet.

A small excerpt of the resulting ExampleSet.

Interpretation of the results

Video

Workflow

import_exp2.rmp

Keywords

importing data
Excel

Operators

Guess Types
Open File
Read Excel
Rename by Generic Names