💭 SQL on Pandas - DuckDB
========================

!https://duckdb.org/docs/guides/python/sql_pandas

Date: July 28, 2023

Redirecting…
 duckdb.org [1]

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
```

!!! note

 This post is a thought [2]. It's a short note that I make
 about someone else's content online #thoughts [3]

References:
[1]: https://duckdb.org/docs/guides/python/sql_on_pandas
[2]: /thoughts/
[3]: /tags/thoughts/