The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms...
Data Wrangling Power Bundle
Query it in SQL, then sculpt it in pandas. Our data workflow becomes clean, fast, and analysis-ready.
Minimum price
$49.99
$54.96
You pay
Author earns
The following 2 books are included in this bundle...
These books have a total suggested price of $49.98. Get them now for only $49.99!
About
About the Bundle
This bundle turns us into a fast, accurate data operator. We start by pulling exactly what we need with SQL, then we reshape, clean, and analyze it with pandas so our reporting and insights become repeatable instead of fragile.
Books
About the Books
SQL 101 Crash Course
Comprehensive Guide to SQL Fundamentals and Practical Applications
SQL 101 Crash Course is a comprehensive beginner's guide that takes you through the world of SQL, right from understanding databases to mastering complex queries. This book is designed to provide you with a solid foundation in SQL, along with practical examples and real-world scenarios to reinforce your learning.
In this book, you'll explore the key concepts of databases and their structure while getting started with SQLite Studio, a versatile SQL tool. You'll dive deep into the fundamentals of SQL queries, turning raw data into meaningful information, and working with tables, multiple tables, and their relationships.
You'll also learn how to harness the power of SQL functions and subqueries to optimize your queries and retrieve data more efficiently. As you progress, you'll delve into the world of views, joins, and advanced SQL topics such as transactions, stored procedures, and performance tuning. The book concludes with two sample databases, where you'll put your newfound knowledge to the test and gain hands-on experience.
This book promises a smooth learning journey for aspiring SQL developers, enabling them to build robust and efficient databases. The book's step-by-step approach ensures that even complete beginners can grasp complex concepts with ease. By the end of this book, you'll emerge as a smart SQL developer, equipped with the skills and knowledge to tackle real-world database challenges.
Key Learnings
- Master SQL fundamentals and best practices.
- Learn to create, modify, and optimize tables.
- Understand and implement table relationships.
- Execute complex queries with ease and confidence.
- Leverage SQL functions for powerful data manipulation.
- Utilize subqueries and derived tables effectively.
- Create and manage views for enhanced data access.
- Apply advanced SQL techniques for optimized performance.
- Hands-on experience with real-world sample databases.
- Begin your journey as a skilled SQL developer.
Table of Content
- Introduction to Databases and SQL
- Setting Up Your SQL Environment
- SQL Queries Basics
- Turning Data into Information
- Working with Tables
- Multiple Tables and Joins
- SQL Functions
- Subqueries and Derived Tables
- Views and Materialized Views
- Advanced SQL Topics
- Sample Programs & Executing SQL
Audience
This book requires no prior knowledge to get started, making it an ideal read for those looking to pursue careers in database administration, business analytics, or business intelligence. Its accessibility ensures that an unwavering passion for learning SQL is all you need to effortlessly progress through the book's content.
Learning Pandas 2.0
A Comprehensive Guide to Data Manipulation and Analysis for Data Scientists and Machine Learning Professionals
"Learning Pandas 2.0" is an essential guide for anyone looking to harness the power of Python's premier data manipulation library. With this comprehensive resource, you will not only master core Pandas 2.0 concepts but also learn how to employ its advanced features to perform efficient data manipulation and analysis.
Throughout the book, you will acquire a deep understanding of Pandas 2.0's data structures, indexing, and selection techniques. Gain expertise in loading, storing, and cleaning data from various file formats and sources, ensuring data integrity and consistency. As you progress, you will delve into advanced data transformation, merging, and aggregation methods to extract meaningful insights and generate insightful reports.
"Learning Pandas 2.0" also covers specialized data processing needs like time series data, DateTime operations, and geospatial analysis. Furthermore, this book demonstrates how to integrate Pandas 2.0 with machine learning libraries like Scikit-learn, TensorFlow, and PyTorch for predictive analytics. This will empower you to build powerful data-driven models to solve complex problems and enhance your decision-making capabilities.
Key Learnings
- Master core Pandas 2.0 concepts, including data structures, indexing, and selection for efficient data manipulation.
- Load, store, and clean data from various file formats and sources, ensuring data integrity and consistency.
- Perform advanced data transformation, merging, and aggregation techniques for insightful analysis and reporting.
- Harness time series data, DateTime operations, and geospatial analysis for specialized data processing needs.
- Visualize data effectively using Seaborn, Plotly, and advanced geospatial visualization tools.
- Integrate Pandas 2.0 with machine learning libraries like Scikit-learn, TensorFlow, and PyTorch for predictive analytics.
Table of Content
- Introduction to Pandas 2.0
- Data Read, Storage, and File Formats
- Indexing and Selecting Data
- Data Manipulation and Transformation
- Time Series and DateTime Operations
- Performance Optimization and Scaling
- Machine Learning with Pandas 2.0
- Text Data and Natural Language Processing
- Geospatial Data Analysis
Earn $8 on a $10 Purchase, and $16 on a $20 Purchase
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
In fact, authors have earned over $15 million writing, publishing and selling on Leanpub.
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Write and Publish on Leanpub
You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!
Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.
Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.