askedith 0.18.12

Natural Language Query Engine for Pandas

Natural Language Query Engine for Pandas

AskEdith is a data analytics question-answering system that can help you speed up your data analytics workflows. AskEdith converts your natural language questions into SQL queries that are used to return a computed DataFrame.

How It Works

1. ETL / Ingress - AskEdith ingresses data and parses schema and metadata.
2. Semantic Search to relate relevant sections of data to the question.
3. NLP Language Model to convert natural language to SQL.
4. Execute on input DataFrame and return results.

Installation

pip install askedith

Usage

import pandas as pd
import askedith

# Load Avocados Data (https://figshare.com/articles/dataset/avocado_csv/17696882)
df = pd.read_csv("https://figshare.com/ndownloader/files/35259799")

# Use AskEdith
df = df.askedith.ask("What's the average price for organic avocados?")

print(df)

Examples