Search
K
Comment on page

DEX Grid

DEX Grid is an interactive data wrangling tool that allows you to quickly explore, search, filter, format, transform, and visualize data. This article will describe how to use Grid.

Open data in Grid

DEX works with cell outputs, which are dataframes. To get data into a dataframe for use with Grid:
UI
Code
SQL
Using the UI:
  1. 1.
    Open the project files panel using the
    icon from the left sidebar.
  2. 2.
    Hover over a CSV file and select
    to open the menu.
  3. 3.
    Select
    Query with Python.
  4. 4.
    Execute the cell that is created (see Use code cells).
  5. 5.
    Click on the Explore button in the lower right of the cell to move to the Grid view
Using Python code:
  1. 1.
    Create a Python cell (see Creating a code cell)
  2. 2.
    Enter the following code replacing <filename> with the name of your CSV file:
    pd.read_csv("<filename>.csv")
  3. 3.
    Execute the cell
  4. 4.
    Click on the Explore button in the lower right of the cell to move to the Grid view
The output of a SQL query is a dataframe. To run a SQL query, see Data Connections or Query project files
Open file in Grid

Learn more