Using AWS Glue DataBrew for data wrangling
In this section, we will explore how AWS Glue DataBrew can be utilized for various data-wrangling tasks, including the following:
- Data discovery
- Data structuring
- Data cleaning
- Data enrichment
- Data validation
- Data publication
Before we begin, the first step is to identify the data source, acquire the dataset, and make it available for data wrangling.
Identifying the dataset
To demonstrate the data-wrangling steps and tasks, we will be using human resources data generated using the Random HR Data Generator Excel macro available on the internet. We will be using a sample size of 5 million records with the following attributes:
Emp ID, Name Prefix, First Name, Middle Initial, Last Name, Gender, E Mail, Father's Name, Mother's Name, Mother's Maiden Name, Date of Birth, Time of Birth, Age in Yrs., Weight in Kgs., Date of Joining, Quarter of Joining, Half of Joining, Year of Joining, Month...