File size: 4,243 Bytes
13e10ec
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
import streamlit as st
import pandas as pd
import numpy as np
import io
import matplotlib.pyplot as plt
from sklearn.preprocessing import LabelEncoder
import seaborn as sns
import base64
import json
from langchain.docstore.document import Document
from langchain.vectorstores import Chroma
from langchain.embeddings import HuggingFaceEmbeddings
from langchain.llms import HuggingFaceHub
from langchain.chains import RetrievalQA
from Information import show_general_data_statistics, describe_data, info_data
from Preprocessing1 import preview_data, data_cleaning, modify_column_names
from Preprocessing2 import handle_categorical_values, missing_values, handle_duplicates, handle_outliers
from RAG import create_doucment, ask_me, load_models_embedding, load_models_llm, create_database


def upload_data():
    st.title("Upload Dataset")
    file = st.file_uploader("Upload your dataset", type=[
                            "csv", "xlsx"], key="file_uploader_1")

    if file:
        try:
            if file.name.endswith(".csv"):
                data = pd.read_csv(file)
            elif file.name.endswith(".xlsx"):
                data = pd.read_excel(file)

            st.session_state["data"] = data
            st.success("Dataset uploaded successfully!")
        except Exception as e:
            st.error(f"Error loading file: {e}")
    return file


def download_data():
    """Downloads the DataFrame as a CSV file."""
    if "data" in st.session_state and not st.session_state["data"].empty:
        csv = st.session_state["data"].to_csv(index=False).encode('utf-8')

        st.download_button(
            label="Download Cleaned Dataset",
            data=csv,
            file_name="cleaned_data.csv",
            mime="text/csv"
        )

    else:
        st.warning(
            "No data available to download. Please modify or upload a dataset first.")


def rag_chatbot():
    st.title("RAG Chatbot")

    # Check if data is uploaded
    if "data" in st.session_state and isinstance(st.session_state["data"], pd.DataFrame):
        df = st.session_state["data"]

        # Convert data to documents
        st.write("Processing the dataset...")
        documents = create_doucment(df)
        st.write(f"Created {len(documents)} documents.")

        # Load models
        st.write("Loading models...")
        embedding = load_models_embedding()
        llm = load_models_llm()

        # Create retriever
        retriever = create_database(embedding, documents).as_retriever()

        # Ask a question
        question = st.text_input("Ask a question about your dataset:")
        if question:
            response = ask_me(question, retriever, llm)
            st.write(f"Answer: {response}")
    else:
        st.warning("Please upload a dataset to proceed.")


def main():
    st.sidebar.title("Navigation")
    options = st.sidebar.radio(
        "Go to",
        [
            "Upload",
            "Preview",
            "Data Cleaning",
            "Modify Column Names",
            "General Data Statistics",
            "Describe",
            "Info",
            "Handle Categorical",
            "Missing Values",
            "Handle Duplicates",
            "Handle Outliers",
            "Download",
            "RAG Chatbot"
        ],
        key="unique_navigation_key",
    )

    if options == "Upload":
        upload_data()
    elif options == "Preview":
        preview_data()
    elif options == "Data Cleaning":
        data_cleaning()
    elif options == "Modify Column Names":
        modify_column_names()
    elif options == "General Data Statistics":
        show_general_data_statistics()
    elif options == "Describe":
        describe_data()
    elif options == "Info":
        info_data()
    elif options == "Handle Categorical":
        handle_categorical_values()
    elif options == "Missing Values":
        missing_values()
    elif options == "Handle Duplicates":
        handle_duplicates()
    elif options == "Handle Outliers":
        handle_outliers()
    elif options == "Download":
        download_data()
    elif options == "RAG Chatbot":
        rag_chatbot()

    else:
        st.warning("Please upload a dataset first.")


if __name__ == "__main__":
    main()