Exception in APILogger: {"message":"Invalid API Key!","data":null}

[pgvetrivel]

Hi

I am trying out pandasai for the first time. I tried the following code

import os
from dotenv import load_dotenv
import pandas as pd
from pandasai import Agent

sales_by_country = pd.DataFrame({
"country": ["United States", "United Kingdom", "France", "Germany", "Italy", "Spain", "Canada", "Australia", "Japan", "China"],
"revenue": [5000, 3200, 2900, 4100, 2300, 2100, 2500, 2600, 4500, 7000]
})

load_dotenv()
pandaskey = os.getenv('PANDAS_API_KEY')

agent = Agent(sales_by_country)
agent.chat('Which are the top 5 countries by sales?')

it throws up the following error
pandasai.exceptions.PandasAIApiCallError: Unauthorized
Exception in APILogger: {"message":"Invalid API Key!","data":null}

api key is correctly called from the .env file. i am able to print and check. i have created the apikey in https://www.pandabi.ai. to use use BambooLLM

please help me out.

[dosubot[bot]]

Hey @pgvetrivel 👋, I'm here to help you with any bugs, questions, or contributions you have. Let's dive into the issue together!

Ensure that your .env file uses the correct environment variable name PANDASAI_API_KEY instead of PANDAS_API_KEY. The Session class in pandasai looks for PANDASAI_API_KEY to retrieve the API key ^[1].

Update your .env file to:

PANDASAI_API_KEY=your_api_key_here

Then, adjust your code to:

pandaskey = os.getenv('PANDASAI_API_KEY')

This should resolve the "Invalid API Key" error.

To continue talking to Dosu, mention @dosu.

[pgvetrivel]

Thank you so much for the quick reply. It is solved.