Data Wrangling on AWS: Clean and organize complex data for analysis

Revamp your data landscape and implement highly effective data pipelines in AWS with this hands-on guide

Purchase of the print or Kindle book includes a free PDF eBook

Key Features

• Execute extract, transform, and load (ETL) tasks on data lakes, data warehouses, and databases
• Implement effective Pandas data operation with data wrangler
• Integrate pipelines with AWS data services

Book Description

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.

What you will learn

• Explore how to write simple to complex transformations using AWS data wrangler
• Use abstracted functions to extract and load data from and into AWS datastores
• Configure AWS Glue DataBrew for data wrangling
• Develop data pipelines using AWS data wrangler
• Integrate AWS security features into Data Wrangler using identity and access management (IAM)
• Optimize your data with AWS SageMaker

Who this book is for

This book is for data engineers, data scientists, and business data analysts looking to explore the capabilities, tools, and services of data wrangling on AWS for their ETL tasks. Basic knowledge of Python, Pandas, and a familiarity with AWS tools such as AWS Glue, Amazon Athena is required to get the most out of this book.

Table of Contents

1. Introduction to Data Wrangling on AWS
2. Working with AWS GlueDataBrew
3. Introducing AWS Data Wrangler
4. Introducing Amazon SageMaker Data Wrangler
5. Working with Amazon S3
6. Working with AWS Glue
7. Working with Athena
8. Working with Quicksight
9. Perform Pandas operation with AWS Data Wrangler
10. Optimizing ML data with AWS SageMaker Data Wrangler
11. Security and Monitoring

Navnit Shukla is an accomplished Senior Solution Architect with a specialization in AWS analytics. With an impressive career spanning 12 years, he has honed his expertise in databases and analytics, establishing himself as a trusted professional in the field. Currently based in Orange County, CA, Navnit's primary responsibility lies in assisting customers in building scalable, cost-effective, and secure data platforms on the AWS cloud.

Sankar Sundaram has been working in IT Industry since 2007, specializing in databases, data warehouses, analytics space for many years. As a specialized Data Architect, he helps customers build and modernize data architectures and help them build secure, scalable, and performant data lake, database, and data warehouse solutions. Prior to joining AWS, he has worked with multiple customers in implementing complex data architectures.

Sam Palani has over 18+ years as developer, data engineer, data scientist, a startup cofounder and IT leader. He holds a master's in Business Administration with a dual specialization in Information Technology. His professional career spans across 5 countries across financial services, management consulting and the technology industries. He is currently Sr Leader for Machine Learning and AI at Amazon Web Services, where he is responsible for multiple lines of the business, product strategy and thought leadership. Sam is also a practicing data scientist, a writer with multiple publications, speaker at key industry conferences and an active open source contributor. Outside work, he loves hiking, photography, experimenting with food and reading.