Book Image

Data Wrangling on AWS

By : Navnit Shukla, Sankar M, Sampat Palani
5 (1)
Book Image

Data Wrangling on AWS

5 (1)
By: Navnit Shukla, Sankar M, Sampat Palani

Overview of this book

Data wrangling is the process of cleaning, transforming, and organizing raw, messy, or unstructured data into a structured format. It involves processes such as data cleaning, data integration, data transformation, and data enrichment to ensure that the data is accurate, consistent, and suitable for analysis. Data Wrangling on AWS equips you with the knowledge to reap the full potential of AWS data wrangling tools. First, you’ll be introduced to data wrangling on AWS and will be familiarized with data wrangling services available in AWS. You’ll understand how to work with AWS Glue DataBrew, AWS data wrangler, and AWS Sagemaker. Next, you’ll discover other AWS services like Amazon S3, Redshift, Athena, and Quicksight. Additionally, you’ll explore advanced topics such as performing Pandas data operation with AWS data wrangler, optimizing ML data with AWS SageMaker, building the data warehouse with Glue DataBrew, along with security and monitoring aspects. By the end of this book, you’ll be well-equipped to perform data wrangling using AWS services.
Table of Contents (19 chapters)
1
Part 1:Unleashing Data Wrangling with AWS
3
Part 2:Data Wrangling with AWS Tools
7
Part 3:AWS Data Management and Analysis
12
Part 4:Advanced Data Manipulation and ML Data Optimization
15
Part 5:Ensuring Data Lake Security and Monitoring

Getting started with AWS Glue DataBrew

One of the most effective ways to learn about any service or tool is through hands-on experience or by learning from examples. We will follow the same approach. In this guide and subsequent tutorials, we will be using the AWS console to learn about AWS Glue DataBrew as a data-wrangling tool. The first requirement for working with AWS Glue DataBrew is data. We previously discussed how data is the new oil, but when it is in raw form, it has little to no value. Before we proceed, it is crucial to understand the pricing model of any service.

Understanding the pricing of AWS Glue DataBrew

It is important to note that the pricing for AWS services varies between regions and is subject to change. In this section, we will be discussing pricing in the us-east-1 region. AWS Glue DataBrew has various components, such as projects, datasets, jobs, and recipes.

Let’s start with datasets. A dataset is created when you bring data from different...