Pandas dataframe with input variables

[akabass]

@dosu-bot
i got this >> ValueError: input_variables is not supported at the moment. when modifing the create the pandas dataframe function to this >>

                    llm_code, 
                    df, 
                    agent_type=AgentType.OPENAI_FUNCTIONS,
                    verbose=True,
                    memory=memory,  # type: ignore
                    agent_executor_kwargs={"memory": memory},
                    input_variables=['input', 'chat_history_buffer', 'chat_history_summary', 'chat_history_KG']
                    )```
   while this pieace of code of identifing the memories is >>> 
```chat_history_buffer = ConversationBufferWindowMemory(
                    k=5,
                    memory_key="chat_history_buffer",
                    input_key="input"
                    )
                chat_history_summary = ConversationSummaryMemory(
                    llm=llm_context, 
                    memory_key="chat_history_summary",
                    input_key="input"
                    )
                chat_history_KG = ConversationKGMemory(
                    llm=llm_context, 
                    memory_key="chat_history_KG",
                    input_key="input",
                    )
                memory = CombinedMemory(memories=[chat_history_buffer, chat_history_summary, chat_history_KG])```

                    

[dosubot[bot]]

🤖

Hello,

The error you're encountering is due to the fact that the input_variables parameter is currently not supported when the agent_type is AgentType.OPENAI_FUNCTIONS. This is explicitly checked in the _get_functions_prompt_and_tools function, and a ValueError is raised if input_variables is not None.

Here is the relevant code snippet from the _get_functions_prompt_and_tools function:

def _get_functions_prompt_and_tools(
    df: Any,
    prefix: Optional[str] = None,
    suffix: Optional[str] = None,
    input_variables: Optional[List[str]] = None,
    include_df_in_prompt: Optional[bool] = True,
    number_of_head_rows: int = 5,
) -> Tuple[BasePromptTemplate, List[PythonAstREPLTool]]:
    ...
    if input_variables is not None:
        raise ValueError("`input_variables` is not supported at the moment.")
    ...

As you can see, if input_variables is not None, the function raises a ValueError. This is why you are receiving the error when you try to modify the create_pandas_dataframe_agent function to include input_variables.

The input_variables parameter in the create_pandas_dataframe_agent function is used to specify the variables that will be included in the prompt created by the ZeroShotAgent or OpenAIFunctionsAgent. These variables are used to construct the prompt that will be passed to the language model.

However, in the case of the OpenAIFunctionsAgent, the input_variables parameter is currently not supported and will raise a ValueError if provided.

You can find more details in the source code of the LangChain repository, specifically in the file libs/langchain/langchain/agents/agent_toolkits/pandas/base.py.

I hope this clarifies the issue. If you have any other questions, feel free to ask.

Sources

• libs/langchain/langchain/agents/agent_toolkits/pandas/base.py

---

This response is meant to be useful and save you time. It is not meant to be a precise solution, but rather a starting point for your own research.

Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.

If you want to continue the conversation, start your reply with @dosu-bot.