💭 SQL on Pandas - DuckDB
━━━━━━━━━━━━━━━━━━━━━━━━

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

Date: July 28, 2023

Redirecting… duckdb.org

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.

[code]
  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 </thoughts/>. It’s a short note that I make about someone else’s content online #thoughts </tags/thoughts/>