Data Parsing
Data parsing is vital when preparing data for analysis. Converting data from one format (or no format) and being able to identify and extract data pieces from a field is a crucial procedure for making semi-unusable data useful.
In this chapter, we’ll present recipes to parse/extract data that may look unusable or too complicated to interpret at first. These are the recipes we will cover:
- Preparing a free text field for analysis/patterns findings
- Identifying and classifying free text
- Extracting the last part of a delimited field
- Using ReGex or not
