pages/CSV_Data_Analyzer.py

import streamlit as st
#from dotenv import load_dotenv
from utils1 import query_agent

#load_dotenv()

st.set_page_config(page_title="Spreadsheet Analyzer")
st.subtitle("Let's do some analysis on your CSV...🤖 ")
st.subheader("Please upload your CSV file here:")

# Capture the CSV file
data = st.file_uploader("Upload CSV file",type="csv")

query = st.text_area("Enter your query 🔍")
button = st.button("Generate Response")

if button:
    # Get Response
    answer =  query_agent(data,query)
    st.write(answer)