← All projects
Documents & knowledge

PandasAI

Ask questions about your spreadsheets and databases in plain English and get answers or charts back.

What it does

PandasAI is a Python library that lets you ask questions about data in everyday language, such as "What is the average revenue by region?", and get back an answer.

It works with CSV files, databases and other data sources, and can draw charts when you ask. Behind the scenes it uses an AI language model of your choice to work out the answer.

Who it's for

Data analysts and developers, and teams who want to give non-technical colleagues a simpler way to query data.

Can I use it without coding?

Developers only. It's a Python library, so you need to write a little code and have an AI model key. New to this? Start here.

Can I run it?

Cost
Free, but needs an AI accountThe software is free, but it uses an online AI service (like OpenAI or Anthropic), which usually charges for use.
Privacy
Sends what you give it to an online service
API key
Needed. An API key is a password-like code from an online AI service. What's that?

Try it

Using Claude Code, Cursor or another AI coding assistant? Paste the prompt and it will walk you through the setup.New to this?

Before you install

  • Only download from the official GitHub page. Copies with similar names exist for many popular projects.
  • No standard license listed. Check the GitHub page before using it for business.
  • Keep your API key private. Never paste it into websites or share it, and set a spending limit with the AI service.
  • What you type or upload is sent to an online service. Avoid sharing private or sensitive information.
  • More on staying safe