Agents Lookup

Use cases / Data & analytics

Ask questions of local CSV and parquet files in Python

Use an open-source library to ask plain-language questions of dataframes on your machine, with the generated code shown.

DifficultyBeginner
Setup timeUnder 1 hour
CategoryData & analytics

The use case

Analysts working in Python notebooks often want a quick answer without writing the pandas themselves. PandasAI lets them ask questions of dataframes, CSV or parquet files, and SQL sources; it generates and runs Python or SQL and returns results or charts. It can run with different model providers. The analyst still reads the generated code, checks results on a known case, and runs it in an environment where the generated code cannot reach sensitive systems. It suits quick checks during exploration; anything that feeds a report should be rewritten as plain, reviewed code.

Example workflow

  1. Install the library and set a model
  2. Load data into a dataframe
  3. Ask a question
  4. Read the generated code and result
  5. Copy confirmed code into the notebook

Tools

Risks and guardrails

Sources

Written by Agents Lookup. Credits and official pages for the tools this use case names: