flexfitfury9/Ai-Data-Analysis-Tool
0
Data Analysis Engine
A comprehensive data analysis dashboard built with Streamlit that transforms raw CSV data into actionable insights and visualizations.
Features
- Data Loading: Upload and preview CSV files with automatic dataset overview
- Data Cleaning: Handle missing values, remove duplicates, and preprocess data
- Statistical Analysis: Generate descriptive statistics, correlation analysis, and trend detection
- Interactive Visualizations: Create various chart types including histograms, scatter plots, line charts, bar charts, box plots, and heatmaps
- User-Friendly Interface: Intuitive navigation with a clean, modern design
How It Works
- Load messy data: Upload your raw CSV file using the file uploader
- Clean missing values: Use the data cleaning tools to handle missing values and preprocess your data
- Detect trends and patterns: Analyze correlations, statistical summaries, and trends in your data
- Visualize results: Create interactive charts and graphs to understand your data
Requirements
- Python 3.7+
- Streamlit
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Plotly
- Scikit-learn
Installation
- Clone or download this repository
- Install the required dependencies:
pip install -r requirements.txt- Run the Streamlit application:
streamlit run streamlit_data_analyzer.pyUsage
- Navigate to the "Data Upload" section to upload your CSV file
- Go to "Data Cleaning" to preprocess and clean your data
- Use "Analysis & Insights" to discover patterns and statistical relationships
- Visit "Visualization" to create charts and graphs for your data
Sample Data
The repository includes a sample_data.csv file with employee information that you can use to test the application.
Technologies Used
- Streamlit: For the web-based dashboard interface
- Pandas: For data manipulation and analysis
- Plotly: For interactive visualizations
- Scikit-learn: For advanced statistical analysis
- Matplotlib/Seaborn: For additional visualization options
