Logo

SakuraAI

An Earl McGowen Company

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?