File size: 3,023 Bytes
5c1210a
 
 
 
 
 
1486dbf
5c1210a
 
 
 
aa893a9
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
---
title: Tesla Production & Deliveries Dashboard
emoji: πŸš—
colorFrom: indigo
colorTo: blue
sdk: gradio
sdk_version: 5.47.2
app_file: app.py
pinned: false
---

Tesla Production & Deliveries Dashboard

CS 5130 – Final Project (Gradio + pandas)

πŸ“Œ Project Overview

This project is an interactive Business Intelligence Dashboard built using Gradio and pandas.
It helps non-technical users explore and understand business data.
The dashboard allows users to:

Upload datasets (CSV or Excel)

View basic statistics

Apply interactive filters

Create different types of visualizations

Generate automated insights

Export data and charts

Two sample Tesla datasets (1K rows and 50K rows) are included for testing and demonstration.

⭐ Key Features
1. Data Upload & Validation

Upload CSV or Excel files

Built-in Tesla sample datasets

Automatic detection of:

Numeric columns

Categorical columns

Date columns

Dataset preview

Clear error handling and messages

2. Summary Statistics

Numeric summary (mean, median, std, min, max, quartiles)

Categorical summary (unique values, mode, frequency)

Missing value report

Correlation heatmap for numeric columns

3. Interactive Filtering

Numeric range filters

Categorical multi-select filters

Date range filters

Filtered data preview

Export filtered result to CSV

4. Visualizations

Supports at least 4 required chart types:

Time series plot

Histogram

Box plot

Category bar chart

Scatter plot

Correlation heatmap

Additional features:

User selects columns

Supports aggregation (sum, mean, count, median)

Download charts as PNG

5. Automated Insights

Top and bottom performing models

Region ranking by estimated deliveries

Production vs. delivery comparison

Overall trend summary

πŸ“ Project Structure

project/

│── app.py                  # Main Gradio application

│── data_processor.py       # Data loading, cleaning, filtering

│── visualizations.py       # Chart creation functions

│── insights.py             # Insight generation functions

│── utils.py                # Helper utilities

│── prepare_tesla_data.py   # Synthetic dataset generator

│── requirements.txt        # Dependencies

│── README.md               # Documentation

└── data/

    β”œβ”€β”€ tesla_deliveries_1k.csv

    └── tesla_deliveries_50k.csv

β–Ά How to Run
1. Install dependencies
pip install -r requirements.txt

2. Run the Gradio app
python app.py

3. Open the browser link

Gradio will show a local URL such as:

http://127.0.0.1:7860

🧰 Technologies Used

Python

pandas

NumPy

Matplotlib / Seaborn

Gradio

πŸ€– Use of AI Tools

AI tools (ChatGPT / Claude / GitHub Copilot) were used for:

Code suggestions

Debugging

Improving documentation

Refining design ideas

All AI-generated code was reviewed, tested, and modified by me to ensure it works for this project.

πŸ“Œ Notes

Sample Tesla datasets are synthetic and created for class demonstration.

Dashboard is for educational use only.