This application will give you a chat interface to gather insights on your own enterprise data & visualize them effectively, Simply ask Questions in plain English. The dataset used is airbnb.
- OpenAI
- Langchain
- Streamlit
- Visualizations - Altair
- Database - SQLite
- Create a Streamlit UI interface
- Construct Raw SQL Query using Langchain SQL Agent
- Fetch data from sqlite DB with SQL query
- Identify Visualization type by with user query and SQL query using visualizer prompt
- Plot the Visualization
- How many Total listings do we have?
- How many Total hosts do we have?
- What is the average number of reviews for listings?
- What is the distribution of top 10 property types among Airbnb listings as a whole/
- Give the total bedrooms wise total listings
- Give number of listings that are available and are unavailable for each day between July 1st to July 10th, 2023
- What is the average price for Airbnb listings in different neighborhoods?
- What are 5 least Avg. cost per accomodate property types
- Top 10 hosts with highestTotal Revenue(revenue is calculated as the sum of the price for the listings which hacve false in the availlibility) from the booking between July 1st and Sept 30th 2023
- Provide neighborhoods Wise - License Type(consider "No License" if the license is null, if the license contains the word "Exempt" then "License exempted", else give "Licensed" as License Type ) Wise Listing counts
git clone https://github.com/adithyaboyapati/CHATDB_OPENAI
Make sure you run the below commands in virtual environment..
pip install -r requirements.txt
streamlit run main.py