Name: Exploring categorical data and unstructured text - Cases and spaces
Uploaded: 2020-01-09T00:00:00Z
Description: Text, or character, data can get messy, but you'll learn how to deal with inconsistencies in case, spacing, and delimiters. Learn how to use a temporary table to recode messy categorical data to standardized values you can count and aggregate. Extract new variables from unstructured text as you explore help requests submitted to the city of Evanston, IL.