Filtering data using SPICE

With SPICE, we can refine data in a dataset. Each filter applies to only one field, which can be a regular or a derived field. We can apply multiple filters to the same field or different fields. Let's review this functionality in detail.

Adding new filters

Let's see how to use the filtering features on the zip code salary data. We will filter the dataset for records that have median income between $30,000 and $60,000 and for states in the north east (NH, MA, NY, CT, and NJ).

We will achieve this in two key steps: filter on the numeric medianincome and then filter on the text field statecode.

Filter on medianincome

Follow these steps to add a filter on the numeric field medianincome:

1. On the data preparation page, click on the Filters pane.

2. Next click on New filter.

3. Next select medianincome as shown in the following screenshot:

   

   Figure 3.16: Filter on medianincome

4. Click on the text Equals - none, which will then expand the various filter options, as shown in the next screenshot...