3
Data Manipulation with DuckDB
This chapter introduces the basics of data manipulation with DuckDB. You will learn how to clean and reshape data using SQL queries and functions and manipulate data from different sources and formats. You will explore how to use aggregate functions, window functions, and common table expressions to perform complex operations on data. By the end of this chapter, you will have a solid grounding in how you can use DuckDB to clean, reshape, and generally wrangle data appropriately for your own analytical workflows.
In this chapter, we’re going to cover the following main topics:
- Data wrangling
- Data import and manipulation
- Altering tables and views
- Aggregate functions and common table expressions
- Joining data from ...
Get Getting Started with DuckDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
