DuckDB: Up and Running: Fast Data Analytics and Reporting
Data Science
Book Details
Book Title
DuckDB: Up and Running: Fast Data Analytics and Reporting
Author
Wei-Meng Lee
Publisher
O’Reilly Media
Publication Date
2025
ISBN
9781098159696
Number of Pages
308
Language
English
Format
File Size
5.10MB
Subject
Data analysis and reporting with DuckDB
Table of Contents
- Preface
- Chapter 1. Getting Started with DuckDB
- Introduction to DuckDB
- A Quick Look at DuckDB
- Why DuckDB Is More Efficient
- Summary
- Chapter 2. Importing Data into DuckDB
- Creating DuckDB Databases
- Loading Data from Different Data Sources and Formats
- Summary
- Chapter 3. A Primer on SQL
- Using the DuckDB CLI
- DuckDB SQL Primer
- Working with Tables
- Summary
- Chapter 4. Using DuckDB with Polars
- Introduction to Polars
- Querying Polars DataFrames Using DuckDB
- Summary
- Chapter 5. Performing EDA with DuckDB
- Our Dataset: The 2015 Flight Delays Dataset
- Geospatial Analysis
- Performing Descriptive Analytics
- Summary
- Chapter 6. Using DuckDB with JSON Files
- Primer on JSON
- Loading JSON Files into DuckDB
- Exporting Tables to JSON
- Summary
- Chapter 7. Using DuckDB with JupySQL
- What Is JupySQL?
- Visualization
- Integrating with MySQL
- Summary
- Chapter 8. Accessing Remote Data Using DuckDB
- DuckDB’s httpfs Extension
- Querying CSV and Parquet Files Remotely
- Querying Hugging Face Datasets
- Summary
- Chapter 9. Using DuckDB in the Cloud with MotherDuck
- Introduction to MotherDuck
- Getting Started with MotherDuck
- Using the Databases in MotherDuck
- Using MotherDuck Through the DuckDB CLI
- Summary
- Index
- About the Author
- Colophon