pandasql
sqldf for pandas (by yhat)
pandas-ai
Chat with your database (SQL, CSV, pandas, polars, mongodb, noSQL, etc). PandasAI makes data analysis conversational using LLMs (GPT 3.5 / 4, Anthropic, VertexAI) and RAG. (by Sinaptik-AI)
pandasql | pandas-ai | |
---|---|---|
3 | 14 | |
1,286 | 11,140 | |
0.0% | 4.6% | |
0.0 | 9.8 | |
about 1 year ago | 9 days ago | |
Python | Python | |
MIT License | GNU General Public License v3.0 or later |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pandasql
Posts with mentions or reviews of pandasql.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-05-17.
- Pandas AI – The Future of Data Analysis
-
Pandas and SQL side by side
There are many more but I've tried to list down the popular ones. To show side by side examples, however, I am not using any database. I have using a SQL engine called pandassql. So to run these examples, you will have to read some data into pandas dataframe and then use pandasql to run SQL queries.
-
How to Run SQL Queries on Pandas Data Frames?
Pandasql is an open-source package that lets you run SQL code on pandas data frames. You can check out its repository on GitHub.
pandas-ai
Posts with mentions or reviews of pandas-ai.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-07-08.
- PandasAI is great but is there a more general library?
- AI enhanced Pandas Python Library
-
[P] Project Asking for Feedbacks, Critiques, and Everything in Between!
I started working on a project recently to familiar myself with LLM's. The project is called matplotlib_ai, and it's inspired by pandas_ai. matplotlib_ai is a package that is able to take in a natural language prompt by the user and generate graphs based on it. As of right now, it uses OpenAI's GPT-3.5 service only (so yes, it requires an API key from OpenAI), but I plan on incorporating other free LLM's too. The GitHub repo is here: https://github.com/notY0rick/matplotlib_ai.
- Trying to run prompt through pandasai and receiving index error
- Pandas AI?
-
How do I get Local LLM to analyze an whole excel or CSV?
you could use this https://github.com/gventuri/pandas-ai
-
Pandas AI – The Future of Data Analysis
The medium article is ok, if blocked at times. This is just a summary, not by the package author.
You can jump to the code at https://github.com/gventuri/pandas-ai to see more of what it's trying to do.
-
AI Weekly rundown (May 7- May 13, 2023): OpenAI's Shap·E, Multimodal GPT, Anthropic's constitutional AI and a lot more.
Pandas gets an AI-powered upgrade. (Link)
- Pandas AI: make data conversational
- PandasAI: Query DataFrames Using LLMs
What are some alternatives?
When comparing pandasql and pandas-ai you can also consider the following projects:
MySQL - MySQL Server, the world's most popular open source database, and MySQL Cluster, a real-time, open source transactional database.
RasaGPT - 💬 RasaGPT is the first headless LLM chatbot platform built on top of Rasa and Langchain. Built w/ Rasa, FastAPI, Langchain, LlamaIndex, SQLModel, pgvector, ngrok, telegram