DuckDB: Up and Running: Fast Data Analytics and Reporting

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 JSONWei-Meng Lee is a technologist and founder of Developer Learning Solutions, a company that provides hands-on training on the latest technologies.