Data Analysis Assistant

This Data Analysis Agent effortlessly automates all the tasks such as data cleaning, preprocessing, and even complex operations like identifying target objects, partitioning test sets, and selecting the best-fit models based on your data. With Streamline Analyst, results visualization and evaluation become seamless.

Here's how it simplifies your workflow: just select your data file, pick an analysis mode, and hit start. Streamline Analyst aims to expedite the data analysis process, making it accessible to all, regardless of their expertise in data analysis. It's built to empower users to process data and achieve high-quality visualizations with unparalleled efficiency🚀, and to execute high-performance modeling with the best strategies🔮.

Try Our Live Demo Here: (Data Analysis Assistant)

When utilizing GPT-4 turbo, the cost for each comprehensive end-to-end API request is roughly $0.02.

Your data's privacy and security are paramount; rest assured, uploaded data and API Keys are strictly for one-time use and are neither saved nor shared.

Looking ahead, we plan to enhance Streamline Analyst with advanced features like Natural Language Processing (NLP), neural networks, and object detection (utilizing YOLO), broadening its capabilities to meet more diverse data analysis needs.

Video Demo

Live app deployed on streamlit cloud

Demo link available at: Data Analysis Assistant

Current Version Features

• Target Variable Identification: LLMs adeptly pinpoint the target variable
• Null Value Management: Choose from a variety of strategies such as mean, median, mode filling, interpolation, or introducing new categories for handling missing data, all recommended by LLMs
• Data Encoding Tactics: Automated suggestions and completions for the best encoding methods, including one-hot, integer mapping, and label encoding
• Dimensionality Reduction with PCA
• Duplicate Entity Resolution
• Data Transformation and Normalization: Utilize Box-Cox transformation and normalization techniques to improve data distribution and scalability
• Balancing Target Variable Entities: LLM-recommended methods like random over-sampling, SMOTE, and ADASYN help balance data sets, crucial for unbiased model training
• Data Set Proportion Adjustment: LLM determines the proportion of the data set (can also be adjusted manually)
• Model Selection and Training: Based on your data, LLMs recommend and initiate training with the most suitable models
• Cluster Number Recommendation: Leveraging the Elbow Rule and Silhouette Coefficient for optimal cluster numbers, with the flexibility of real-time adjustments

All processed data and models are made available for download, offering a comprehensive, user-friendly data analysis toolkit.

Modeling and Results Visualization:

Automated Workflow Interface:

Supported Modeling tasks:

Classification Models	Clustering Models	Regression Models
Logistic regression	K-means clustering	Linear regression
Random forest	DBSCAN	Ridge regression
Support vector machine	Gaussian mixture model	Lasso regression
Gradient boosting machine	Hierarchical clustering	Elastic net regression
Gaussian Naive Bayes	Spectral clustering	Random forest regression
AdaBoost	etc.	Gradient boosting regression
XGBoost		etc.

Real-time calculation of model indicators and result visualization:

Classification Metrics & Plots	Clustering Metrics & Plots	Regression Metrics & Plots
Model score	Silhouette score	R-squared score
Confusion matrix	Calinski-Harabasz score	Mean square error (MSE)
AUC	Davies-Bouldin score	Root mean square error (RMSE)
F1 score	Cluster scatter plot	Absolute error (MAE)
ROC plot	etc.	Residual plot
etc.		Predicted value vs actual value plot
		Quantile-Quantile plot

Visual Analysis Toolkit:

Streamline Analyst 🪄 offers an array of intuitive visual tools for enhanced data insight, without the need for an API Key:

• Single Attribute Visualization: Insightful views into individual data aspects
• Multi-Attribute Visualization: Comprehensive analysis of variable interrelations
• Three-Dimensional Plotting: Advanced 3D representations for complex data relationships
• Word Clouds: Key themes and concepts highlighted through word frequency
• World Heat Maps: Geographic trends and distributions made visually accessible

Local Installation

Prerequisites

To run app.py, you'll need:

• Python 3.11.5
• OpenAI API Key
  • OpenAI: Note that the free quota does not support GPT-4

Installation

1. Install the required packages

pip install -r requirements.txt

2. Run app.py on your local machine

streamlit run app.py