Data Wrangling Using Pandas SQL and Java - A Comprehensive Guide to Data Cleaning and Transformation

Mercury Learning and Information, Oswald Campesato

Summary

This book is designed for aspiring data scientists and those involved in data cleaning. It covers features of NumPy and Pandas, along with creating databases and tables in MySQL. It also addresses various data wrangling tasks using Python scripts and awk-based shell scripts. Companion files with code are available from the publisher.Understanding data cleaning and manipulation is vital for data scientists. This book provides a comprehensive introduction to essential tools and techniques. From Python basics to advanced data wrangling, it equips readers with the skills needed to manage and clean data effectively.The journey begins with an introduction to Python and progresses through working with data, Pandas, and SQL. It also covers Java, JSON, XML, and specific data cleaning tasks. The book culminates with detailed data wrangling techniques, ensuring readers gain practical, hands-on experience in data management.

Available since: 08/01/2024.

Print length: 275 pages.

Science & Technology

Other books that might interest you

When Crisis Hits Suburbia

Ted Riley

Would your family survive in lockdown if society were to collapse? Learn how to prepare your home now.We are used to a world in which our homes are supplied with fresh water, gas, and electricity. We’re used to having our waste removed and our sanitary needs met.These are all things we’ve come to expect, but what would happen if they were taken away?Flooding, hurricanes, and pandemics are affecting areas we once thought were safe from disaster--we shouldn’t take anything for granted.In When Crisis Hits Suburbia: A Modern-Day Prepping Guide to Effectively Bug In and Protect Your Family Home in a Societal Collapse, you’ll learn exactly what you need to know to prepare your home for an emergency. You’ll find:The 6 key priorities of survival and how to make sure you have them covered.A clear guide for knowing when it’s time to stay in, and when it’s time to evacuate.Top prepper survival secrets so that you always stay one step ahead of the rest.A toolbox of information that allows you to choose what works best for your family.Practical tips for preparing your children for worst-case scenarios without frightening them.How to make sure your water supply is 100% safe at all times.Comprehensive checklists for everything you need to stock in your home.Essential administrative tasks you should have sorted in advance before a disaster strikes.And much more.The ideal home is not only the home that keeps you and your family safe in good times, but it’s the home that keeps you safe no matter what.Prepare your home for the worst-case scenario and protect your family no matter what.

Show book

Oath and Law

Hippocrates

The Oath and Law by Hippocrates is a document that outlines the ethical code of conduct for medical professionals. The oath is a pledge to uphold the highest standards of care for patients, and the law is a set of guidelines for how physicians should behave. The oath and law are designed to protect patients and ensure that they receive the best possible care. Read in English, unabridged.

Show book

Hearing Happiness - Deafness...

Jaipreet Virdi

Weaving together lyrical history and personal memoir, Virdi powerfully examines society’s—and her own—perception of life as a deaf person in America.

At the age of four, Jaipreet Virdi’s world went silent. A severe case of meningitis left her alive but deaf, suddenly treated differently by everyone. Her deafness downplayed by society and doctors, she struggled to “pass” as hearing for most of her life. Countless cures, treatments, and technologies led to dead ends. Never quite deaf enough for the Deaf community or quite hearing enough for the “normal” majority, Virdi was stuck in aural limbo for years. It wasn’t until her thirties, exasperated by problems with new digital hearing aids, that she began to actively assert her deafness and reexamine society’s—and her own—perception of life as a deaf person in America.
Through lyrical history and personal memoir, Hearing Happiness raises pivotal questions about deafness in American society and the endless quest for a cure. Taking us from the 1860s up to the present, Virdi combs archives and museums in order to understand the long history of curious cures: ear trumpets, violet ray apparatuses, vibrating massagers, electrotherapy machines, airplane diving, bloodletting, skull hammering, and many more. Hundreds of procedures and products have promised grand miracles but always failed to deliver a universal cure—a harmful legacy that is still present in contemporary biomedicine.

Weaving Virdi’s own experiences together with her exploration into the fascinating history of deafness cures, Hearing Happiness is a powerful story that America needs to hear.

Show book

Lost in the Stream - How...

Jeff Rauseo

This engaging book by Jeff Rauseo blends film history with a modern guide to streaming, helping you navigate the complex history of movie making and ultimately how to know what to watch in the vast ocean of content. From the golden age of Hollywood to the best new movies to stream, Rauseo breaks down the ever-evolving movie watching experience to help us understand the good, the bad, and the ugly of streaming. 
 
Ever feel overwhelmed by endless streaming choices? Jeff Rauseo's Lost in the Stream is your ultimate roadmap, combining movie history insights with an in-depth breakdown of how streaming influences the movies that are made and the ones that we are shown. Whether you're searching for the best new movies to stream, hidden Amazon Prime movies, or fun movies to watch on Netflix, this book has you covered. 
 
Blending nostalgia with today's streaming hits, Lost in the Stream dives deep into the iconic history of film that shaped the art while helping you discover new favorites. It's the perfect companion for movie buffs and casual viewers alike. Inside, you'll find a breakdown of the evolution of film watching, from drive-ins to Blockbuster nights and beyond; engaging insights into the impact finances and algorithms have on the movies that are made; and a guide to discovering the best films for you.

Show book

Virtual Collaboration Tools -...

Craig Dames

Remote work has transitioned from a rare privilege to a widespread norm, reshaping the way individuals and organizations approach productivity, collaboration, and work-life balance. While working remotely once seemed limited to freelancers and digital nomads, advancements in technology and a shift in workplace culture have made it a viable option for professionals across all industries. This transformation has been especially accelerated by global events such as the COVID-19 pandemic, which forced companies to adopt remote strategies almost overnight. As a result, many organizations have discovered the long-term benefits and flexibility that remote work offers.
The evolution of the modern workplace has been marked by a steady move away from traditional office settings. High-speed internet, cloud computing, and a wide array of collaboration tools have made it easier than ever to connect from anywhere in the world. Employees no longer need to be physically present to contribute meaningfully to their teams. This has given rise to distributed workforces, where talent is sourced globally, and diverse perspectives are brought together in virtual environments. The shift has not only broadened hiring pools but also enabled businesses to reduce overhead costs and improve employee satisfaction.
Technology has played a pivotal role in enabling this transition. Tools for communication, project management, video conferencing, and file sharing have made collaboration seamless, even when teams are spread across multiple time zones. Platforms like Zoom, Slack, Microsoft Teams, and Google Workspace have become central to the remote work ecosystem. These technologies are not just alternatives to in-person interaction—they are becoming essential components of the modern work experience.

Show book

The Future Earth - A Radical...

Anonymous

The first hopeful book about climate change, The Future Earth shows readers how to reverse the short- and long-term effects of climate change over the next three decades. 
The basics of climate science are easy. We know it is entirely human-caused. Which means its solutions will be similarly human-led. In The Future Earth, leading climate change advocate and weather-related journalist Eric Holthaus (“the Rebel Nerd of Meteorology”—Rolling Stone) offers a radical vision of our future, specifically how to reverse the short- and long-term effects of climate change over the next three decades. Anchored by world-class reporting, interviews with futurists, climatologists, biologists, economists, and climate change activists, it shows what the world could look like if we implemented radical solutions on the scale of the crises we face.  
What could happen if we reduced carbon emissions by 50 percent in the next decade?What could living in a city look like in 2030?How could the world operate in 2040, if the proposed Green New Deal created a 100 percent net carbon-free economy in the United States? 
This is the book for anyone who feels overwhelmed by the current state of our environment. Hopeful and prophetic, The Future Earth invites us to imagine how we can reverse the effects of climate change in our own lifetime and encourages us to enter a deeper relationship with the earth as conscientious stewards and to re-affirm our commitment to one another in our shared humanity.

Show book