sinaptik-ai/pandas-ai ? reverse-engineered prompt
Reverse engineered prompt
I want you to build a Python library called PandasAI that lets anyone chat with their data using plain English. Load a CSV or connect to a database and then just ask questions like "what is the average revenue by region" or "show me total sales for the top 3 countries" and it should return the answer.
It should also create charts when you ask it to plot something, like a histogram of GDP by country with different colors. Support multiple datasets at once so you can ask questions that join them together, for example "who gets paid the most" across an employees table and a salaries table.
Make the API feel natural, something like df.chat("your question"). Use an LLM behind the scenes but keep setup simple with an API key. Add an optional Docker sandbox mode so code runs safely in isolation. Include a few examples and make the whole thing installable with pip. Look up current LLM and pandas best practices if you need to.
Are you gonna build this?
make sure you review the code using coderabbit