Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Automate Finance with Python & SQL
·
Module 2
High-Performance Data Processing with DuckDB
1
Connecting to DuckDB in Python
Install DuckDB and connect to an in-memory or persistent database in Python.
2
Faster CSV Processing with DuckDB SQL
Query one or more CSV files directly using DuckDB's SQL reader functions, replacing slow pandas loops.
Combine Files with UNION ALL and Glob Patterns
Consolidate multiple files into a single table using `UNION ALL` and glob patterns.
4
DuckDB to Pandas: Seamless Data Transfer
Convert between DuckDB query results and pandas DataFrames.
5
Saving Transformed Data to DuckDB
Persist transformed data to a local DuckDB database file for subsequent analysis.
Previous module
Structuring Reusable Python Code
Next module
Efficient Data Storage with Parquet