Grid View visualizer
From Piki
The Grid View visualizer shows the data in a spreadsheet. It allows for advanced selection operations that can be convereted into filters as well as some data editing functions.
| Grid View | |
 | |
| Name | Grid View |
| Can modify data | Yes |
| Produces filters | Yes |
| Can show multivariate data | Yes |
| Supports selection | Yes |
| Supports clipboard operations | Yes |
| Can export data | Yes |
| Can export images | No |
Contents |
Operation
The Grid View has a standard spreadsheet layout with features as columns and samples as rows. The first column, labeled "Row" shows the sample number and is not part of the data being displayed.
In the toolbar the "Set" drop down list lets you choose which set to use (Training or Validation).
Data selection
Manual
You can use your mouse to click on a row to select it. To select multiple rows you can:
- Press the left mouse button and drag over the rows you wish to select.
- Select a row, hold in the SHIFT button and click on another row. All rows in between will also be selected.
- While holding the CTRL key pressed click on individual rows you wish to select.
- Press CTRL+A to select all rows or click on the empty box next to the "Row" column header.
By query
Samples can be selected by specifying a search query in the text box next to "Select". The query language is a very simplified form of SQL. The syntax follows the one of the select filter and is documented in the select filter documentation.
- The "!" button executes the query and makes the selection in the Grid View.
- The "Keep" button keeps only the rows that fit the select expression.
- The "Remove" button removes all the rows that fit the select expression.
- The undo button undoes the last keep or remove operation without removing other, index based filter operations.
- The help button in the toolbar shows a window with the select filter syntax.
Filter operations
The Grid View has an internal filter stack that is separate from the main filter stack. Once you are happy with the operations performed in the Grid View, you can transfer the internal filter stack to the main one.
- The "Apply" button in the toolbar applies modifications or selections as filters.
- The "Reset" button removes any modifications or selections (that has not yet been turned into global filters)
Index based filters
Main article: Filter#Index based filters
The Grid View supports index based filters which operate against a fixed sample index. This includes delete, edit and add row operations. Using index based filters for anything except initial visualization and data mining is not recommended as they are unlikely to work when you change the data.
To delete one or more selected rows, press the Delete key. To edit a value, double click on the cell and write a new value. To add a row write values directly in the cells of the last row (which is empty).
If you wish to directly create an index based filter without the intermediate local filter stack, use the functions found under the "Options->Filters".
Clipboard and save
You can copy a selection to the clipboard by clicking on the copy button in the toolbar or by pressing CTRL+C. The button in the toolbar will always include column headers in the copied data while CTRL+C will just include the selected data.
To save the data seen in the Grid View, press the save button.