Show data as an interactive table

Datasets

Choose one of the datasets from the Datasets dropdown. Files are loaded into Radiant through the Data > Manage tab.

Filter

There are several ways to select a subset of the data to view. The Filter box on the left (click the check-box) can be used with > and < symbols. You can also combine subset commands, for example, x > 3 & y == 2 would show only those rows for which the variable x has values larger than 3 AND for which y is equal to 2. Note that in R, and most other programming languages, = is used to assign a value and == to determine if values are equal to each other. In contrast, != is used to determine if two values are unequal. You can also use expressions that have an OR condition. For example, to select rows where Salary is smaller than $100,000 OR larger than $20,000 use Salary > 20000 | Salary < 100000. | is the symbol for OR and & is the symbol for AND

It is also possible to filter using dates. For example, to select rows with dates before June 1st, 2014 enter date < "2014-6-1" into the filter box and press return.

You can also use string matching to select rows. For example, type grepl('ood', cut) to select rows with Good or Very good cut. This search is case sensitive by default. For case insensitive search use grepl("GOOD", cut, ignore.case = TRUE). Type your statement in the Filter box and press return to see the result on screen or an error below the box if the expression is invalid.

It is important to note that these filters are persistent and will be applied to any analysis conducted through in Radiant. To deactivate a filter un-check the Filter check-box. To remove a filter simply delete it.

Operator Description Example
< less than price < 5000
<= less than or equal to carat <= 2
> greater than price > 1000
>= greater than or equal to carat >= 2
== exactly equal to cut == 'Fair'
!= not equal to cut != 'Fair'
| x OR y price > 10000 | cut == 'Premium'
& x AND y carat < 2 & cut == 'Fair'
%in% x is one of y cut %in% c('Fair', 'Good')

Pause view

For very large datasets it can useful to click Pause view before selecting variables, entering filters, etc. When you are ready to generate the table make sure that Pause view is no longer checked. When Pause view is un-checked, any input change will generate a new table.

Select variables to show

By default all columns in the data are shown. Click on any variable to focus on it alone. To select several variables use the SHIFT and ARROW keys on your keyboard. On a mac the CMD key can also be used to select multiple variables. The same effect is achieved on windows using the CTRL key. To select all variable use CTRL-A (or CMD-A on mac).

Sort

Click on a column header in the table to sort the data. Clicking again will toggle between sorting in ascending and descending order. To sort on multiple columns at once press shift and then click on the 2nd, 3rd, etc. column to sort by.

Browse the data

By default only 10 rows of data are shown at a time. You can change this setting through the Show ... entries dropdown. Press the Next and Previous buttons at the bottom-right of the screen to page through the data.

© Vincent Nijs (2016) Creative Commons License