Add Excel Functionality

[HisokaMagician101]

🚀 The feature

Be able to read in an excel dataframe

Motivation, pitch

I'm not a great programmer, want the ability to read in data from excel

Alternatives

N/A

Additional context

N/A

[aryandgandhi]

I can take this one @gventuri

[gventuri]

Assigned to you @aryandgandhi 🚀

[jonbiemond]

@aryandgandhi Are you working on this? I'd like to submit a PR.

[aryandgandhi]

Yeah I was waiting for google sheets to be approved. Feel free to submit one though

[mspronesti]

Hi @HisokaMagician101, I believe this does not require any extra feature. One can simply use pandas

import pandas as pd
from pandasai import PandasAI
from pandasai.llm import OpenAI

excel_file = '/path/to/you/excel/file'
df = pd.read_excel(excel_file)

llm = OpenAI()
pandas_ai = PandasAI(llm, verbose=True)
response = pandas_ai(df, "your-prompt-here")
print(response)