duckdb-parquet-lab-workflow

What problem does it solve?

This workflow eliminates the manual steps of loading Parquet files, querying with DuckDB, inspecting schemas, performing joins, and converting results into pandas for analysis.

Core Features & Use Cases

• Load Parquet data with DuckDB and query it using SQL.
• Inspect schema with a DESCRIBE command and review metadata.
• Build robust joins (LEFT/RIGHT) to preserve row counts while combining datasets.
• Convert query results to pandas DataFrames for modeling and reporting.
• Use the standard SQL patterns documented in templates/duckdb_snippets.md for consistency.

Quick Start

Load Parquet data with DuckDB, describe the table schema, join relevant tables with explicit join types, and convert the final result to a pandas DataFrame.