Enter and Edit Data

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • Enter and Edit Data

•

Enter and Edit Data

Perform Basic Data Table Tasks

After you import data into JMP or create a new data table, you can format your data to prepare it for analysis.

This chapter contains the following information:

•

Change formatting for numeric values

•

Add, delete, and select rows and columns

•

Use the Row Editor to navigate within rows and edit rows

•

Create scripts that are saved to the data table

Figure 3.1 The Rows and Cols Menus

Contents

Copy and Paste Data

Fill Columns with Sequential Data

Replace Missing Values with Previous Values

Enter Cell Formulas

Locate Next and Previously Selected Rows

Select Columns in a Data Table

Select Columns in the Columns Viewer

Locate Next and Previously Selected Columns

Resize Rows and Columns

Delete Rows and Columns

Rearrange Columns

Edit or Delete Cells

Edit Column Names

Hide and Exclude Rows

Exclude Columns

View Patterns of Missing Data

Find and Replace Cell Values

Use the Row Editor to Edit Cells in a Row

Pop-Up Menus for Rows and Columns

Compare Data Tables

Assign Characteristics to Rows and Columns

How to Find Rows and Columns Options

Label Rows and Columns

Assign Colors or Markers to Rows

Create Color Themes

Delete Custom Color Themes

Select Matching Row State Cells

Delete Row Characteristics

Lock Columns in Place

Restructure Data

Make a Column into Multiple Columns

Make Indicator Columns

Combine Columns

Compress Selected Columns

Make Binning Formula

Convert Labels to Codes and Codes to Labels

Make a New Formula Column

Transform Columns

Edit the Data Table

Change Table Names

Compress Tables

Use Table Variables

Create and Save Scripts

•

Help created on 7/12/2018