Spaces:
Sleeping
Sleeping
File size: 2,713 Bytes
60ac372 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
import pandas as pd
import streamlit.components.v1 as components
import streamlit as st
from ydata_profiling import ProfileReport
from streamlit_pandas_profiling import st_profile_report
from langchain.llms.openai import OpenAI
from langchain_experimental.agents import create_csv_agent
from langchain.agents.agent_types import AgentType
import time
import os
from mitosheet.streamlit.v1 import spreadsheet
from pygwalker.api.streamlit import init_streamlit_comm, get_streamlit_html
st.set_page_config(
page_title="AI TOOL",
layout="wide"
)
def main():
st.sidebar.title("App Options")
option = st.sidebar.selectbox("Choose an option", ["View Instructions", "View Data","Data Profiling","Tableau AI", "CSV Chatbot"])
if option == "View Instructions":
show_instructions()
elif option == "Data Profiling":
uploaded_file = st.file_uploader("Upload CSV file", type=["csv"])
if uploaded_file is None:
st.warning("Please upload a CSV file.")
st.stop() # Stop execution if no file uploaded
else:
data_profiling(uploaded_file)
elif option == "CSV Chatbot":
openai_api_key = st.text_input("Enter your OpenAI API Key", type="password")
if not openai_api_key:
st.warning("You should have an OpenAI API key to continue. Get one at [OpenAI API Keys](https://platform.openai.com/api-keys)")
st.stop()
os.environ['OPENAI_API_KEY'] = openai_api_key
personal_assistant()
elif option == "View Data":
virtual_excel_sheet()
elif option == "Tableau AI":
tableau_ai()
def show_instructions():
st.title("Welcome to the AI TOOL!")
st.write("This tool offers several functionalities to help you analyze and work with your data.")
st.write("Please select an option from the sidebar to proceed:")
st.write("- **View Data:** Upload a CSV file and view its contents.")
st.write("- **Data Profiling:** Upload a CSV file to generate a data profiling report.")
st.write("- **CSV Chatbot:** Interact with a chatbot to get insights from your CSV data.")
st.write("- **Tableau AI:** Upload a CSV file to visualize it using Tableau AI.")
st.write("- **View Instructions:** View these instructions again.")
def data_profiling(uploaded_file):
st.title("Data Profiling App")
# Load the data
df = pd.read_csv(uploaded_file)
# Display the dataframe
st.dataframe(df)
# Generate and display the data profile report
pr = ProfileReport(df, title="Report")
st_profile_report(pr)
# Define other functions (personal_assistant, virtual_excel_sheet, tableau_ai) as before...
if __name__ == "__main__":
main()
|