[ERROR]: AttributeError: 'QueryResult' object has no attribute 'as_pandas'

[cansayin]

Contact Details [Optional]

No response

System Information

"superduperdb==0.1.0",

"os_uname": [ "Linux", "6.2.0-1017-aws", "#17~22.04.1-Ubuntu SMP Fri Nov 17 21:07:13 UTC 2023", "x86_64" ], "package_versions": {}, "platform": { "platform": "Linux-6.2.0-1017-aws-x86_64-with-glibc2.35", "python_version": "3.10.12" }, "startup_time": "2024-01-29 16:56:40.638752", "superduper_db_root": "/usr/local/lib/python3.10/dist-packages", "sys": { "argv": [ "/usr/local/lib/python3.10/dist-packages/superduperdb/main.py", "info" ], "path": [ "/root", "/usr/lib/python310.zip", "/usr/lib/python3.10", "/usr/lib/python3.10/lib-dynload", "/usr/local/lib/python3.10/dist-packages", "/usr/lib/python3/dist-packages" ] } }

What happened?

Hi,

We realized that there is no pandas module in superduperdb package. It returns following error. Is there any updated python script that we can check and do demo ?

Thanks # Use the OpenAIChatCompletion model to predict the next query based on the provided context output, context = db.predict( model_name='gpt-3.5-turbo', input=search_term, context_select=db.execute(RawSQL(f'DESCRIBE {table_name}')).as_pandas().to_csv() )

ERROR:

Traceback (most recent call last): File "/root/test.py", line 111, in result = chat_with_your_database(table_name, query) File "/root/test.py", line 59, in chat_with_your_database context_select=db.execute(RawSQL(f'DESCRIBE {table_name}')).as_pandas().to_csv() AttributeError: 'QueryResult' object has no attribute 'as_pandas'

Steps to reproduce

No response

Relevant log output

No response

[blythed]

@cansayin what format is your data in exactly?

[cansayin]

dataset that i upload to db is https://ghe.clickhouse.tech