Streamlit LLM Integration
This application uses a MySQL database based on the E-commerce Customer Behavior Dataset from Kaggle.
It utilizes PandasAI as a language model to run analytics on the database.
Streamlit is used to create a web application that allows users to interact with the data and generate visualizations.
Sample Questions You Can Ask:
- List the top 5 rows of the DataFrame.
- Generate a bar chart showing the number of customers in each age group.
- What is the average age of customers?
- What is the total spend of customers in each city?
- Generate a pie chart showing the total spend by membership type.
- What is the average total spend by customers of different membership types?
- Show a line chart of the total spend over different age groups.
- Generate a histogram of the number of items purchased by customers.
- What is the correlation between customer age and total spend?
- Show a scatter plot of customer age versus total spend.
- What is the distribution of customer satisfaction levels?
- What is the total spend of customers who received discounts versus those who did not?
- Generate a bar chart showing the average rating of customers who received discounts versus those who did not.
- What is the average number of days since the last purchase by city?