Data Table
The Data Table tab displays dataset contents in tabular format, allowing you to explore data using filters and sorting.
See also Getting Started.
Filter Feature
Enter filter expressions to display only rows that match your conditions. Filters also apply to the Statistics tab, which computes statistics on the filtered data only.
Basic Usage
- Enter an expression in the filter input field at the top of the Data Table tab
- Press Enter or click outside the input field
- Only rows matching the condition are displayed, and the number of matching rows appears below the filter input
How to Write Filter Expressions
Filter expressions use SQL-like syntax supporting comparison operators, LIKE, IN, BETWEEN, and more. Enclose strings in single quotes and column names in double quotes.
Comparison Operators
| Operator | Meaning | Example |
|---|---|---|
= | Equal to | species = 'Adelie' |
!= | Not equal to | species != 'Adelie' |
> | Greater than | age > 30 |
>= | Greater or equal | age >= 30 |
< | Less than | age < 30 |
<= | Less or equal | age <= 30 |
Pattern Matching Operators
| Operator | Meaning | Example |
|---|---|---|
LIKE | Matches pattern (case-sensitive) | name LIKE '%田%' |
ILIKE | Matches pattern (case-insensitive) | name ILIKE '%Smith%' |
NOT LIKE | Does not match pattern | name NOT LIKE '%test%' |
Pattern syntax:
%represents any string (0 or more characters)_represents any single character
Examples:
name LIKE '%田%'- Contains "田"name LIKE '山%'- Starts with "山"name LIKE '%郎'- Ends with "郎"email LIKE '%@example.com'- Ends with @example.com
Logical Operators
| Operator | Meaning | Example |
|---|---|---|
and | And | age > 30 and sex = 'male' |
or | Or | species = 'Adelie' or species = 'Gentoo' |
() | Grouping | (age > 30 or salary > 50000) and active = true |
Set and Range Operators
| Operator | Meaning | Example |
|---|---|---|
IN (...) | In list of values | species IN ('Adelie', 'Chinstrap') |
NOT IN (...) | Not in list of values | status NOT IN ('deleted', 'archived') |
BETWEEN ... AND ... | Within range (inclusive) | age BETWEEN 20 AND 30 |
NOT BETWEEN ... AND ... | Outside range | age NOT BETWEEN 20 AND 30 |
Negation Operator
| Operator | Meaning | Example |
|---|---|---|
NOT (...) | Negates condition | NOT (status = 'deleted') |
NULL Check and Boolean Values
| Syntax | Meaning | Example |
|---|---|---|
IS NULL | Is missing value | bill_length_mm IS NULL |
IS NOT NULL | Is not missing | bill_length_mm IS NOT NULL |
true / false | Boolean values | active = true |
Column Names with Spaces or Special Characters
Enclose column names in double quotes:
"Body Mass (g)" > 4000
Filter Examples
# Numeric condition
body_mass_g > 4000
# String condition (enclose in single quotes)
species = 'Chinstrap'
# Combining multiple conditions
species = 'Adelie' and body_mass_g > 3500
# Excluding missing values
bill_length_mm IS NOT NULL
# Pattern matching (partial match)
island LIKE '%Dream%'
# Matching multiple values
species IN ('Adelie', 'Gentoo')
# Range specification
body_mass_g BETWEEN 3500 AND 4500
For example, filtering with species IN ('Adelie', 'Gentoo') displays only the matching rows.
Sort Feature
Click the sort button on a column header to sort data by that column.
Single Column Sort
- 1 click: Ascending order
- 2 clicks: Descending order
- 3 clicks: Remove sort
Multi-Column Sort
Hold Ctrl/Cmd while clicking to sort by multiple columns.
- Ctrl/Cmd+click to add a sort condition (ascending)
- Ctrl/Cmd+click the same column again to switch to descending
- Ctrl/Cmd+click once more to remove the sort
During multi-column sort, priority numbers are displayed on sort buttons (e.g., 1, 2).
Row Selection
Selecting rows in the Data Table synchronizes the selection state with other tabs (Statistics, Graph Builder, etc.).
Selection Methods
- Single row: Click a row
- Range selection: Hold Shift while clicking
- Add to selection: Hold Ctrl/Cmd while clicking
- Clear row selection: Click the Clear rows button in the Selected Rows tab
Selected rows synchronize with other tabs such as Statistics and Graph Builder. See Row Selection for details on cross-tab synchronization and saving selections as datasets.
Dataset Operations
Viewing Metadata
Click the ⓘ button next to the dataset name to view basic information about the dataset (dataset name, row and column counts, data type and measurement scale for each column).
Column Context Menu
Right-click a column header to open the context menu.
- Convert Column Types...: Open the type conversion tab. See Column Type Conversion for details.
- Edit Scale of Measurement: Change the measurement scale.
- Rename Column: Rename the column.
Table Menu
Click the menu button (⋮) at the top right of the table to access dataset operations.
- Edit Data: Edit cell values, add rows, or delete rows (Primary datasets only)
- Add to Report: Add the table to a report
- Export: Export data. See Data Export for details
- View SQL Query: View the original SQL query (derived datasets only)
- Materialize: Save query results to the project file (MDS) (derived datasets only). Normally, derived dataset cache is discarded on save, but Materialize preserves it. Useful for computationally expensive small tables.
- Reload Dataset...: Reload data from the original CSV file. Opens a dialog where you select the file to reload. The column structure (number of columns and data types) must match
Data Export
Select Export from the table menu to export the dataset in CSV, TSV, or JSON format. Active filters and sort order are reflected in the export. The row number column is not included.
File Name - Specify the output file name. The extension is added automatically based on the selected format.
File Format - Select the output format.
| Format | Description |
|---|---|
| CSV | Comma-separated values. A widely supported format for spreadsheets and other tools |
| TSV | Tab-separated values. Useful when your data contains commas |
| JSON | Array of objects. Programs can read this format directly |
Encoding - Select the character encoding. Available for CSV and TSV. JSON always uses UTF-8.
| Encoding | Use case |
|---|---|
| UTF-8 | Standard encoding supported by most tools |
| Shift-JIS | Opens without garbled characters in Excel on Japanese systems |
| EUC-JP | An encoding used by some Unix-based tools |
Add BOM - Adds a byte order mark when UTF-8 is selected. Prevents garbled characters when opening UTF-8 CSV files in Excel.
Include column headers - Outputs column names in the first row. Available for CSV and TSV.
Export selected rows only - Shown when rows are selected. When checked, only the selected rows are exported.
Missing Values
Missing values are output as empty fields in CSV and TSV formats. In JSON, they are output as null literals.
Row Number Column
The leftmost column displays row numbers. These row numbers indicate the original data order and do not change when filters or sorting are applied.
Next steps
- Basic Statistics - View statistics for selected columns
- Data Processing with SQL Editor - Process data with SQL
See also
- Data Preparation and Import - About data types and measurement scales