This article provides a quick guide on how to use the project. It explains everything in a simple and easy-to-understand manner, making it accessible even for non-technical users or those who are new to Python.
To get started, make sure you have Python installed on your system. Additionally, you need to install the following external libraries: Open AI Library, Pandas Library, and Dot Environment Library. You can do this by opening the terminal and running the provided code.
Once you have installed the necessary libraries, you can proceed to download the project files either by downloading the zip file or cloning the repository using Visual Studio Code.
A
fter downloading and extracting the files, open the project folder in Visual Studio Code. Inside the folder, you will find the main file and an example file. The main file contains the core functionality of the project, while the example file demonstrates how to use the project with your own data.
Before running the project, you need to make a few changes. Rename the example file to 'env.py' and input your Open AI API key in the designated section. You can obtain the API key from the Open AI website.
Once you have made the necessary changes, save the file. The main file interacts with a sample database provided in the project. If you want to use your own database, you can replace the sample database with your own and update the table and column names accordingly.
To run the project, open the terminal in Visual Studio Code and navigate to the project directory. Then, run the command 'python3 GPT_SQL.py'. The program will prompt you to enter a query. Enter your query, and the extracted data will be saved in a CSV file.
If you want to visualize the extracted data, you can run the command 'python3 GPT.py'. This will generate a basic bar chart using the Plotly library.
That's a quick breakdown of the project. If you have any questions or need further assistance, feel free to ask. Thank you!
