A data table is a collection of data organized in rows and columns. It is similar to a Microsoft® Excel® spreadsheet, but with some important differences that are discussed in How is JMP Different from Excel?. A data table might also contain other information like notes, variables, and scripts. These supplementary items are discussed in later chapters.
Figure .4 A Data Table
The data grid contains the data arranged in rows and columns. Generally, each row in the data grid is an observation, and the columns (also called variables) give information about the observations. In Figure .4, each row corresponds to a test subject, and there are twelve columns of information. Although all twelve columns cannot be shown in the data grid, the Columns panel lists them all. The information given about each test subject includes the time, cell type, treatment, and more. Each column has a header, or name. That name is not part of the table’s total count of rows.
The table panel can contain table variables or table scripts. In Figure .4, there is one saved script called Model that can automatically re-create an analysis. This table also has a variable named Notes that contains information about the data. Table variables and table scripts are discussed in a later chapter.
The columns panel shows the total number of columns, whether any columns are selected, and a list of all the columns by name. The numbers in parentheses (12/0) show that there are twelve columns, and that no columns are selected. An icon to the left of each column name shows that column’s modeling type. Modeling types are described in Understand Modeling Types in Analyze Your Data. Icons to the right show any attributes assigned to the column. See View or Change Column Information in Work with Your Data for more information about these icons.
The rows panel shows the number of rows in the data table, and how many rows are selected, excluded, hidden, or labeled. In Figure .4, there are 137 rows in the data table.
Interacting with the data grid, which includes adding rows and columns, entering data, and editing data, is discussed in the Work with Your Data topic. If you open multiple data tables, each one appears in a separate window.