Biostatistics Using JMP

Chapter 3: Data Wrangling: Data Cleaning

3.1 Introduction

3.2 Tables

3.2.1 Stacking Columns

3.2.2 Basic Table Organization

3.2.3 Column Properties

3.3 The Sorted Array

3.4 Restructuring Data

3.4.1 Combining Columns

3.4.2 Separating Out a Column (Text to Columns)

3.4.3 Creating Indicator Columns

3.4.4 Grouping Inside Columns

3.5 References

3.1 Introduction

After data has been collected and imported into JMP, as described in Chapter 2, you would obviously like to analyze this data. However, raw data can have various issues that require cleaning. For example, a variable (a column in a JMP data table) might contain both haemaglobin and Haemaglobin. Although a person can tell that these are both the same, computers pay attention to case and would ...