Viewing and Editing the Data

On this page…
Viewing Data Using Notes to Sort Data for Plotting Removing Outliers and Problem Tests Reordering and Editing Data

Viewing Data

As shown in the following figure you can split the views to display several plots at once, as in the Design Editor. You can use the right-click context menus, the toolbar buttons, or the View menu to split views. You can choose 2-D plots, 3-D plots, multiple data plots, cluster plots, data tables, and list views of filters, variables, test filters, test notes and cluster information.

In the 2-D plot view, the list boxes on the left allow a combination of tests and variables to be plotted simultaneously. The example shown plots torque against spark for multiple tests on the left, and speed for three selected tests on the right. You can multiple-select tests and y-axes to compare the data in the tests (hold down Shift or Control). For more details about each view, see Data Editor Views in the Model-Based Calibration Toolbox Model Browser User's Guide.

You can use test notes to investigate problem data and decide whether some points should be removed before modeling. The following steps cover using notes and views to sort and investigate your data.

Back to Top

Using Notes to Sort Data for Plotting

1. Right-click a view and select Current View > Multiple Data Plot.

2. Right-click the new view and select Viewer Options > Add Plot.

   The Plot Variables Setup dialog appears.

3. Select spark and click to add to the X Variable box, then select tq and click to add to the Y Variable box. Click OK to create the plot.

4. Click in the Tests list to select a test to plot (or Shift-click, Ctrl-click, or click and drag to select multiple tests).

5. Right-click the view and select Split View > Test Note Definitions.

   The current view is divided into two.

6. Select Tools > Test Notes > Add.

   The Test Note Editor appears.

7. Enter mean(tq)<10 in the top edit box to define the tests to be noted, and enter Low torque in the Test Note edit box. Leave the note color at the default and click OK.

8. Right-click the Test Notes List view and select Split View > Notes View.

   The current view is split into two. You can sort records by notes in the new Notes view.

9. Click the column header of the new Low torque note in the Notes view. All the tests that satisfy the condition mean(tq)<10 are sorted to the top of the list.

10. Now create some more views.

    • Right-click a view and select Split View > Data Table.

    • Right-click a view and select Split View > 3D Data Plot.

11. In the Notes view, click particular tests with the Low torque note.

    Notice that when you select a test here, the same test is plotted in the multiple data plots, the 3D data plot, and highlighted in the data table. You can use the notes in this way to easily identify problem tests and decide whether you should remove them.

Back to Top

Removing Outliers and Problem Tests

1. Click a point on the Multiple Data Plots view.

   The point is outlined in red on the plot, and highlighted in the data table. You can remove points you have selected as outliers by selecting Tools > Filters > Remove Outliers (or use the keyboard shortcut Ctrl+A). Select Tools > Filters > Restore Outliers (or use the keyboard shortcut Ctrl+Z) to open a dialog where you can choose to restore any or all removed points.

   You can remove individual points as outliers, or you can remove records or entire tests with filters.

2. For example, after examining all the Low torque noted tests, you could decide they should be filtered out.

   1. Select Split View > Test Filter Definitions.

   2. Select Tools > Test Filters > Add.

   3. The Test Filter Editor appears. Enter mean(tq)>10 to keep all tests where the mean torque is greater than 10, and click OK.

   In the new Test Filter List view, you should see the new test filter successfully applied and the number of records removed.

   Similarly, you can use filters to remove individual records rather than entire tests, which you will cover in a later section Applying a Filter.

3. To view removed data in the table view, right-click and select Viewer Options > Allow Editing. Removed records are red. To view removed data in the 2-D and Multiple Data Plots, select Viewer Options > Properties and select the box Show bad data.

Back to Top

Reordering and Editing Data

To change the display, right-click a 2-D plot and select Viewer Options > Properties. You can alter grid and plot settings including lines to join the data points.

Reorder X Data in the Plot Properties dialog can be useful when record order does not produce a sensible line joining the data points. For an illustration of this:

1. Ensure you are displaying a 2-D plot. You can right-click on any plot and select Current Plot > 2-D Plot, or use the context menu split commands to add new views.

2. Right-click on a 2-D plot and select Viewer Options > Properties and choose solid from the Data Linestyle drop-down menu, as shown below. Click OK.

   

3. Choose afr for the y-axis.

4. Choose Load for the x-axis.

5. Select test 590. You must use the test controls contained within the 2-D plot. The Tests pane on the left applies to other views: tables and 3-D and multiple data plots.

   

6. Right-click and select Viewer Options > Properties and choose Reorder X Data. Click OK.

   This command replots the line from left to right instead of in the order of the records, as shown.

   

7. Right-click and select Split Plot > Data Table to split the currently selected view and add a table view. You can select particular test numbers in the Tests pane on the left of the Data Editor. You can right-click to select Viewer Options > Allow Editing, and then you can double-click cells to edit them.

Back to Top

Loading the Data

User-Defined Variables and Filtering

© 1984-2012- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS