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 multiple tables
The techniques in this chapter will help you make your data more understandable and give you the experience to structure your DuckDB analytic pipelines. Let’s dive in.
