Please try later #7
Description
Code:
import os
import pandas as pd
from pandas_llm import PandasLLM
Data
Please note that these names, ages, and donations are randomly generated
and do not correspond to real individuals or their donations.
data = [('John Doe', 25, 50),
('Jane Smith', 38, 70),
('Alex Johnson', 45, 80),
('Jessica Brown', 60, 40),
('Michael Davis', 22, 90),
('Emily Wilson', 30, 60),
('Daniel Taylor', 35, 75),
('Sophia Moore', 40, 85),
('David Thomas', 50, 65),
('Olivia Jackson', 29, 55)]
df = pd.DataFrame(data, columns=['name', 'age', 'donation'])
conv_df = PandasLLM(data=df, llm_api_key =API_KEY)
result = conv_df.prompt("What is the average donation of people older than 40 who donated more than $50?")
code = conv_df.code_block
print(f"Executing the following expression of type {type(result)}:\n{code}\n\nResult is:\n {result}\n")
Executing the following expression of type <class 'numpy.float64'>:
result = df.loc[(df['age'] > 40) & (df['donation'] > 50), 'donation'].mean()
Result is:
72.5
Error:
UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access
conv_df = PandasLLM(data=df, llm_api_key =API_KEY)
Executing the following expression of type <class 'str'>:
Result is:
Please try later
Even though I am trying with same code which is given in the pandas-llm documentation, I always encounter with 'Please try later' response.
@alessioricco @alessiodashydash @kairavdashydash @muhammad-abdullah-dashy-dash