- Contents
- Learn about JMP
- Get Started
- Introduction to Basic Features
- Anatomy of a JMP Session
- Data Tables
- Platforms
- Manage JMP Files and Open Windows
- JMP Starter Window
- Import Your Data
- Create Data Tables
- About Importing Data to JMP
- Import Microsoft Excel Files
- Import Data from SAS
- Build SQL Queries in Query Builder
- Connect to a SQL Database
- Select Tables from a SQL Database
- Build the SQL Query
- Select Columns from the Database Table
- Maintain Compatibility with JMP 12
- Create a Computed Column
- Group the Common Values
- Import a Sample of the Data
- Select Filters to Import a Subset of the Data
- Import Matching Data from an Existing Data Table
- Write a Custom Expression to Import a Subset of the Data
- Sort the Selected Data
- View the Query Status
- Write a Post-Query Script
- Save and Run the Query
- Open the Selected Data in JMP
- Query Builder Red Triangle Options
- Write SQL Statements in Query Builder
- Import Data from a Database
- Import Text Files
- Import Data from the Internet or a Remote Computer
- Import SPSS Files
- Import Triple-S Survey Data
- Import HDF5 Data
- Import JSON Files
- Import Data from MATLAB
- Import Data from R
- Import Data Using the Excel Add-In
- Create New Data Tables
- Enter and Edit Data
- Perform Basic Data Table Tasks
- Enter Data
- Select Rows
- Select Columns
- Select Cells
- Resize Rows and Columns
- Organize Data
- Delete Rows and Columns
- Rearrange Columns
- Group Columns
- Move Values
- Color Cells
- Edit or Delete Cells
- Edit Column Names
- Hide and Exclude Rows
- Exclude Rows
- Hide Rows
- Exclude Columns
- Hide Columns
- View Patterns of Missing Data
- Find and Replace Cell Values
- Use the Row Editor to Edit Cells in a Row
- Context Menus for Rows and Columns
- Compare Data Tables
- Assign Characteristics to Rows and Columns
- Restructure Data
- Edit the Data Table
- The Column Info Window
- Set Column Attributes and Properties
- About the Column Info Window
- Column Properties
- Basic Column Properties
- Properties That Validate Column Values
- Properties That Attach Information to Column Values
- Properties That Control the Display of Columns
- Properties Used in Modeling and DOE
- Properties Associated with Control Charts and Capability
- Properties That Control How Columns Are Used in Platforms
- Virtual Join Properties
- Additional Properties
- Properties Assigned and Controlled by JMP
- Standardize Attributes and Properties Across Columns
- Assign a Preselected Analysis Role
- Reshape Data
- Formula Editor
- Construct Formulas
- Formula Overview
- Create a Formula
- Refer to Values in Columns and Table Variables
- Use Local Variables
- Insert Constants
- Add Operators
- Use Functions in a Formula
- Order Expressions in Formulas
- Use Formula Editor Options
- Edit Formulas
- Customize Formulas
- Examples and Tutorials
- Keyboard Shortcuts
- Glossary of Terms
- Summarize Data
- JMP Reports
- Navigate and Customize Report Windows
- Navigate Reports
- Red Triangle Options in a Report
- The Data Filter
- Reformat Report Tables
- Select Points in Graphs
- Use Markers
- Change the Appearance of Graphs
- Resize Graphs
- Zoom In and Out
- Pin Hover Labels on a Graph
- Change Line Widths
- Change the Background Color in a Graph
- Change the Color of Histogram Bars
- Display Coordinates and Temporary Reference Lines
- Scroll and Scale Axes
- Customize Axes and Axis Labels in the Axis Settings Window
- Customize Axes and Axis Labels Using the Right-Click Menu
- Change the Order of Values
- Change the Pattern and Format of Selected Objects
- Add a Graph to a Data Table
- Customize Graphical Elements
- Add Images to a Graph or Report
- Add Annotations and Shapes to a Report
- Save and Share Data
- Get Your Data Out of JMP
- Save and Share Data Tables
- Save and Share Reports
- Save Your Analysis as a Script
- Print Reports
- Copy and Paste Reports
- JMP Journals
- Create a New Journal
- Prevent Modifications
- Append Reports to a Journal
- Add and Edit Outline Levels
- Control the Display of Outline Levels
- Add a Graph or Graphic
- Customize Journal Items
- Save the Journal in Another Format
- Print a Journal
- Delete Items from a Journal
- Example of Making a Journal for a Presentation
- Save JMP Sessions
- JMP Projects (Windows Only)
- Save a Log Window
- Extend JMP
- Create Dashboards
- Combine Reports by Creating a Dashboard
- Example of Creating a Dashboard with Two Reports
- Details about Using the Dashboard Builder
- Dashboard Builder Red Triangle Options
- Sample Dashboards
- Edit a Dashboard
- View a Running Dashboard
- Example of Combining Windows to Create a Dashboard
- Example of Adding a Selection Filter to a Dashboard
- Example of Creating a JMP Query Dashboard and Add-In
- Personalize JMP
- Customize Menus and Toolbars
- Personalize Toolbars and Menus on Windows
- Change Customization Sets
- Create Toolbars
- Create Main Menus
- Create Menu Items and Toolbar Buttons
- Rearrange Toolbars
- Copy and Paste Menus, Menu Items, Toolbars, and Buttons
- Rearrange Custom Menus, Menu Items, and Buttons
- Delete Custom Items
- Show and Hide Items
- Import Customizations
- Remove Customizations
- Personalize Toolbars on Macintosh
- Personalize Menu Items on Macintosh
- JMP Preferences
- Formula Functions Reference
- Descriptions of Functions in the Formula Editor
- Row Functions
- Numeric Functions
- Transcendental Functions
- Trigonometric Functions
- Character Functions
- Character Pattern Functions
- Comparison Functions
- Conditional Functions
- Probability Functions
- Discrete Probability Functions
- Statistical Functions
- Random Functions
- Date Time Functions
- Row State Functions
- Assignment Functions
- Parametric Model Functions
- Finance Functions
- JMP Technical Details
- Index
Chapter 3
Import Your Data
Create Data Tables
This chapter covers the following topics:
• How to import data into JMP, such as text files, SPSS files, and SAS data
• How to transfer Excel data into a JMP data table
• How to read in real-time data
• How to create a new data table
Figure 3.1 Importing a Text File
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.