Database Reference
In-Depth Information
DEPLOYMENT
Gill now has a data set with a prediction for each boy that has been tested using the athletic battery
at his academy. What to do with these predictions will be a matter of some thought and
discussion. Gill can extract these data from RapidMiner and relate them back to each boy
individually. For relatively small data sets, such as this one, we could move the results into a
spreadsheet by simply copying and pasting them. Just as a quick exercise in moving results to
other formats, try this:
1)
Open a blank OpenOffice Calc spreadsheet.
2)
In RapidMiner, click on the 1 under Row No. in Data View of results perspective (the cell
will turn gray).
3)
Press Ctrl+A (the keyboard command for 'select all' in Windows; you can use equivalent
keyboard command for Mac or Linux as well). All cells in Data View will turn gray.
4)
Press Ctrl+C (or the equivalent keyboard command for 'copy' if not using Windows).
5)
In your blank OpenOffice Calc spreadsheet, right click in cell A1 and choose Paste
Special… from the context menu.
6)
In the pop up dialog box, select Unformatted Text, then click OK.
7)
A Text Import pop up dialog box will appear with a preview of the RapidMiner data.
Accept the defaults by clicking OK. The data will be pasted into the spreadsheet. The
attribute names will have to be transcribed and added to the top row of the spreadsheet,
but the data are now available outside of RapidMiner. Gill can match each prediction back
to each boy in the scoring data set. The data are still in order, but remember that a few
were removed because on inconsistent data, so care should be exercised when matching
the predictions back to the boys represented by each observation. Bringing a unique
identifying number into the training and scoring data sets might aid the matching once
