 |
 |
 | VIDA
User Manual | ||||
 |
 |
 |
 |
||||
Spreadsheets may also be filtered into new spreadsheet views. For instance, this could be useful for identifying all compounds with an IC50 above or below a given value.
 |
Filtering spreadsheets is very similar to creating new columns. To filter a spreadsheet, click on the Data menu and select ``Filter Spreadsheet" option. A wizard dialog will appear to aid in the process. This dialog can be seen in Figure 7.4.
Similar to the column expressions in 7.4, filter functions are arbitrary functions. The main difference is that, when applied to a row, if filter functions return False or 0, then the row is not included in the new filtered spreadsheet.
The filter dialog operates on the currently viewed spreadsheet. This means if that if the original spreadsheet is filtered on ``IC50", then the ``IC50" filtered spreadsheet is made visible, and then a filter on ``EC50" is applied, this will result in the equivalent of having filtered the original spreadsheet on both ``IC50" and ``EC50".
 |
Figure 7.5 shows the result of filtering the included example Cox2 dataset for IC50's greater than 50.
|
|
| VIDA
User Manual | ||||
|
|
|
|
||||