shot of post - πŸ’­ SQL on Pandas - DuckDB

Here's my thought on πŸ’­ SQL on Pandas - DuckDB


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.

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. It's a short note that I make about someone else's content online. Learn more about the process [[ thoughts ]]

{.text-opacity-80} This post was a thought by Waylon Walker see all my thoughts at https://waylonwalker.com/thoughts