DuckDB: Up and Running: Fast Data Analytics and Reporting

by Wei-Meng Lee

Overview

DuckDB is an open source in-process database created for OLAP workloads. It provides key advantages that separate this database from more mainstream OLAP solutions, including embeddability, compatibility with SQL, optimization for fast and efficient analytics, and integration with Python. This practical book shows you how DuckDB leverages Python libraries and tools for data analytics, machine learning, and AI.

Author Wei-Meng Lee shows developers, data engineers, data analysts, and data scientists how to get started. You'll learn the primary features and functions of DuckDB, explore use cases and best practices, and examine practical examples of how DuckDB can be used for a variety of data analytics tasks. You'll also dive into specific topics including how to import data into DuckDB, work with tables, perform exploratory data analysis, visualize DuckDB data, perform spatial analysis, and use DuckDB with JSON files, Polars, and JupySQL.

You'll also explore:

• The purpose of DuckDB and its main functions
• How to conduct data analytics tasks using DuckDB
• Methods for integrating DuckDB with pandas, Polars, and JupySQL
• How to use DuckDB to query your data
• Ways to perform spatial analytics using DuckDB's spatial extension
• How to work with a diverse range of data including Parquet, CSV, and JSON

Wei-Meng Lee is a technologist and founder of Developer Learning Solutions, a company that provides hands-on training on the latest technologies.

Product Details

ISBN-13:	9781098159696
Publisher:	O'Reilly Media, Incorporated
Publication date:	01/21/2025
Pages:	305
Product dimensions:	7.00(w) x 9.19(h) x 0.00(d)

About the Author

Wei-Meng Lee is a technologist and founder of Developer Learning Solutions, a company that provides hands-on training on the latest technologies. He is an established developer and trainer, specializing in data science, blockchain, and mobile technologies. Wei-Meng speaks regularly at international conferences and has authored and co-authored numerous books on topics ranging from blockchain to machine learning. He currently writes a regular column for Medium and Code Magazine, with a focus on making complex technologies easy for beginners to understand.