This web application is built using python, streamlit, python enabled html, Nivo Chart and mui.

1. Generate insights to the tabular data, you can upload your CSV file and ask any question about it.
2. Text to SQL
3. Text to Chart/Graph
4. The Graph that has been created is draggable and resizable

Current supported chart types:

-Bar Chart

-Line Plot

-Scatter Plot

-Swarm Plot

-Pie Chart

To start using the repository, first clone the project into your local pc

git clone https://github.com/thongekchakrit/automated-data-analysis.git

Next, open the file location in any Python IDE, I highly recommend PyCharm. Then, navigate to the folder > .streamlit (as shown in the picture below), create a file called secrets.toml

Within secrets.toml file add your OpenAI API key into the file (as shown below). This will allow streamlit to pick up the secrets.

gpt_secret = "<YOUR-API-KEY>"

Once done, install the requirements for the project.

pip install -r requirements.txt

To run the application. Within the terminal of the IDE do:

streamlit run Home.py

Access the site using: http://localhost:8501

Please feel free to contribute to the repository.

Fork the application, make edits and perform a pull request.