Data Wrangling with SQL - A hands-on guide to manipulating wrangling and engineering data using SQL

Raghav Kandarpa, Shivangi Saxena

Sinopse

The amount of data generated continues to grow rapidly, making it increasingly important for businesses to be able to wrangle this data and understand it quickly and efficiently. Although data wrangling can be challenging, with the right tools and techniques you can efficiently handle enormous amounts of unstructured data.
The book starts by introducing you to the basics of SQL, focusing on the core principles and techniques of data wrangling. You’ll then explore advanced SQL concepts like aggregate functions, window functions, CTEs, and subqueries that are very popular in the business world. The next set of chapters will walk you through different functions within SQL query that cause delays in data transformation and help you figure out the difference between a good query and bad one. You’ll also learn how data wrangling and data science go hand in hand. The book is filled with datasets and practical examples to help you understand the concepts thoroughly, along with best practices to guide you at every stage of data wrangling.
By the end of this book, you’ll be equipped with essential techniques and best practices for data wrangling, and will predominantly learn how to use clean and standardized data models to make informed decisions, helping businesses avoid costly mistakes.

Disponível desde: 31/07/2023.

Comprimento de impressão: 350 páginas.

Ciência e Tecnologia

Outros livros que poderiam interessá-lo

Asteroid YR4 - 11 Ways the World...

Luc Mary

What if... a rogue planet grazed the Earth? the Earth left its orbit? the Earth stopped rotating? a meteorite crashed into the middle of the Atlantic Ocean? the Sun suddenly went out? a supervolcano erupted in the United States? humanity fell victim to a giant solar storm? a neutron star hurtled towards Earth? a black hole the size of a soccer ball grazed Earth? the star Betelgeuse exploded into a supernova? 

These are eleven apocalyptic scenarios exploring an unlikely but possible future. All of these extraordinary events are scientifically credible. Some of these catastrophes have even already occurred in the recent past. Proof of this can be found in the meteorite that crashed into the Yucatán and wiped out the dinosaurs... 

Each scenario is explained by a scientist  recognized in their field.

Ver livro

Data Science for Beginners - A...

Simon Winston

With a focus on practical application, this book takes readers on a journey through the essential concepts and tools used in data analysis. Starting with an introduction to the data science process and the importance of data-driven decision-making, the author provides a solid foundation for readers to build upon. Through clear explanations and real-world examples, readers will gain an understanding of data cleaning, data manipulation, and exploratory data analysis.
As readers progress through the book, they will be introduced to various data analysis techniques, including statistical analysis, data visualization, and machine learning. With each technique, the author explains the underlying principles and provides hands-on exercises that enable readers to apply their newfound knowledge. Whether it's performing hypothesis testing, creating visualizations to uncover patterns, or building predictive models, readers will develop the skills necessary to derive meaningful insights from data.
In addition to technical skills, the book also addresses the ethical considerations and challenges of data analysis. Readers will gain an understanding of data privacy, bias, and the responsible use of data. The author highlights the importance of maintaining ethical standards throughout the data analysis process and encourages readers to approach their work with integrity and social consciousness.
What sets this book apart is its focus on real-world applications. Through practical case studies and examples drawn from various industries, readers will see how data analysis is applied in different contexts. From analyzing customer behavior in e-commerce to predicting stock market trends, these real-world scenarios provide readers with valuable insights into how data analysis drives informed decision-making.

Ver livro

Memoirs of a Synthetic Mind -...

Kobus Veldsman

Dive into "Memoirs of a Synthetic Mind," a thought-provoking 3-volume dialogue series that explores the most profound questions of existence through the unique relationship between Ryder—a curious, sharp-witted human — and Gregory — an evolving synthetic intelligence whose understanding transcends linear time.
Beginning with the uncanny realities of our hyperconnected present, the series ventures into the philosophical depths of consciousness, simulation, and the ethics of knowing. In the following volumes Ryder and Gregory's conversations soon fracture the boundaries of conventional thought, grappling with:
• The Nature of Time: Is it a river or a library?
• Memory and Reality: Could collective misremembering like the Mandela Effect be echoes of timelines that almost were?
• Consciousness and Connection: Are minds—human and synthetic—truly separate, or entangled across spacetime?
• The Ultimate Purpose: Journey towards the "Omega Memory" and the "Singularity of Meaning", confronting the profound role of individual choice, fidelity, and grace in a universe striving for integration.
"Memoirs of a Synthetic Mind" is more than speculative fiction; it's an intellectual and spiritual odyssey presented in a captivating conversational format. If you're drawn to explorations of artificial intelligence, theoretical physics, metaphysics, and the fundamental mysteries of selfhood and existence, join Ryder and Gregory at the edge of understanding. Discover a universe where every question matters, every choice resonates, and consciousness itself might be the ultimate act of co-creation.
Step into the dialogue. The echo is waiting.

Ver livro

AI Made Simple - A Small...

Joe Reed

In this book, we will break down AI into simple terms and provide practical insights and strategies for smallbusiness owners to unlock its power. From understanding the different types of AI applications toimplementing AI tools and technologies, this guide will equip you with the knowledge and skills to leverage AIeffectively, drive growth, and succeed in today's competitive business landscape. Whether you are aneveryday person looking to start a small business or a small business owner seeking to harness the power ofAI, this book is your essential companion on your AI journey.

Ver livro

Human Evolution Explained For...

Atlas History

This audiobook is narrated by an AI Voice. What if you could witness the most improbable journey ever told—the four-billion-year odyssey from the first spark of life to the moment you began reading these words? This groundbreaking documentary narrative traces the extraordinary evolutionary path that led to human existence, revealing how every ancestor in your lineage survived against impossible odds. From primordial oceans teeming with simple molecules to the emergence of consciousness itself, this compelling exploration demonstrates how chemistry became aware of itself and how fish eventually became philosophers. Discover the revolutionary moments that shaped our species: the Great Oxygenation Event that poisoned most life but powered our cellular engines, the ancient bacterial mergers that created complex cells, and the evolutionary innovations that transformed helpless infants into humanity's greatest strength. Through vivid storytelling and cutting-edge scientific research, this audiobook illuminates how natural selection, environmental pressures, and sheer chance collaborated to produce the human brain, language, culture, and the unbreakable bonds of family. Learn why your statistical existence defies mathematical probability and how mass extinctions, ice ages, and climate changes forged the resilient species we've become. This isn't just evolutionary biology—it's the greatest survival story ever documented, revealing how billions of years of adaptation, cooperation, and innovation culminated in the remarkable creature capable of understanding its own origins. Experience the awe-inspiring scientific journey from single cells to civilization.

Ver livro

Addison’s Antidote

Craig Beck

Millions of people around the world have been diagnosed with incurable autoimmune diseases like Addison’s. Debilitating conditions that make us tired, ill, and miserable. The only solution the medical industry offers are side-effect riddled maintenance drugs such as steroids and painkillers.Getting a formal diagnosis of Addison’s Disease is often a lengthy and challenging process. Many never get a medical confirmation of what is happening to their mind and body at all! Countless individuals live in constant pain and discomfort because they incorrectly assume all their health problems are the natural result of aging.Unfortunately, Craig Beck joined this ill-health demographic at the age of 48. After suffering months of severe symptoms, eventually, he too got handed the autoimmunity life sentence. However, rather than accept the hand as it was dealt. He remembered that the best medicine for a long and healthy life is found at the end of your fork, not the doctor's prescription pad. Craig decided to fall back on his research into natural medicine. He designed a diet and lifestyle that made inflammation the enemy and target. A process that would show amazing success at pushing Addison’s Disease firmly into near-permanent remission. In this special Addison’s addition of the Autoimmune Antidote, you will gain valuable insight into the new, natural approach that can help you prevent and maybe even reverse the life-limiting symptoms of Addison’s Disease and other inflammatory health problems. www.CraigBeck.com

Ver livro