Biostatistics Using JMP

Chapter 2: Data Wrangling: Data Collection

2.1 Introduction

2.2 Collecting Data from Files

2.2.1 JMP Native Files

2.2.2 SAS Format Files

2.2.3 Excel Spreadsheets

2.2.4 Text and CSV Format

2.3 Extracting Data from Internet Locations

2.3.1 Opening as Data

2.3.2 Opening as a Webpage

2.4 Data Modeling Types

2.4.1 Incorporating Expression and Contextual Data

2.5 References

2.1 Introduction

Many examples in textbooks and manuals such as this book are very orderly and clean. However, real-world data is rarely orderly and clean (authors actually spend a lot of time searching for and fabricating good example data) and up to 80% of your time can be lost in “wrangling” to make messy data usable (Lohr, 2016). Medical and biological data is also becoming ...