from langchain.agents import create_pandas_dataframe_agent
import pandas as pd
from langchain.llms import OpenAI


def query_agent(data, query):

    #Parse the CSV file and create a Pandas DataFrame from its contents.
    df = pd.read_csv(data)

    llm = OpenAI()

    # Create a Pandas DataFrame Agent.
    agent = create_pandas_dataframe_agent(llm,df,verbose=True)

    #Python REPL: A python shell used to evaluating and excuting Python commands
    #It takes python code as an input and outputs the results. The input python code can be generated from another tool in the langchain
    return agent.run(query)