---
title: "SQL on Pandas - DuckDB"
description: "!https://duckdb.org/docs/guides/python/sql_pandas"
date: 2023-07-28
published: true
tags:
  - data
  - duckdb
  - pandas
  - python
  - thought
template: link
---


<div class="embed-card embed-card-external">
  <a href="https://duckdb.org/docs/guides/python/sql_on_pandas" class="embed-card-link" target="_blank" rel="noopener noreferrer">
    <div class="embed-card-content">
      <div class="embed-card-title">Redirecting…</div>
      <div class="embed-card-meta">duckdb.org</div>
    </div>
  </a>
</div>


duckdb can just query any pandas dataframe that is in memory.

> I tried running it against a list of objects and got this error.  Great error message that gives me supported types right in the message.

``` python
Make sure that "posts" is either a pandas.DataFrame, duckdb.DuckDBPyRelation, pyarrow Table, Dataset, RecordBatchReader, Scanner, or NumPy ndarrays with supported format
```