Analytics Website Dashboard using Python and Streamlit Library with MYSQL database (Data Science)

What is descriptive analytics?

Descriptive analytics is a type of data analytics that looks at past data to give an account of what has happened. Results are typically presented in reports, dashboards, bar charts and other visualizations that are easily understood.

Descriptive statistics provide simple summaries about the sample and about the observations that have been made. Such summaries may be either quantitative, i.e. summary statistics, or visual, i.e. simple-to-understand graphs. These summaries may either form the basis of the initial description of the data as part of a more extensive statistical analysis, or they may be sufficient in and of themselves for a particular investigation.

live demo

source code

video contents:

1. how to download and install Python
2. how to install streamlit
3. how to start a new project
4. how to upload Excel file to Mysql
5. how to connect streamlit and Mysql
6. how to print data to Dataframe()
7. how to compute central tendencies
8. how to plot graphs in streamlit
9. how to create sidebar in streamlit
10. how to create multi-selector to sidebar

references:

download python

emoji

bootstrap icon

OTHER PYTHON VIDEO SERIES

Analytics Web application Multiple Linear Regression Web Project using Streamlit and Python
live demo
reference code
Video tutorial

*Python Web Dashboard using DashPlotly Framework and Dash Bootstrap Component*
Demo 1
Demo 2
reference code
Video tutorial

*Business Analytics Dashboard Website using Streamlit Python and MySQL*
live demo
reference code
Video tutorial

*descriptive analytics website with MySQL*
live demo
reference code
Video tutorial

*Python Machine Learning Web App Multiple Linear Regression using Streamlit Python and MySQL*
live demo
reference code
Video tutorial

*analytics dashboard with excel and graphs*
live demo
Video tutorial

*Web Analytics Dashboard using Python and Streamlit to Visualize Sales* Data of Excel file
live demo
reference code
Video Tutorial

*Streamlit Web Visualization Dashboard using Python and PygWalker Exploratory Library*
Live Demo
Source Code
Video Tutorial

*Crosstabulation web*
live demo
reference code
Video tutorial

*Add new Record to Excel file via Web Interface*
live demo
reference code
Video tutorial

*Percentiles, 5 number summary, Categorical data*
live demo
reference code
Video tutorial

*Business Intelligent Analytics Web Dashboard Using PYTHON, HTML, CSS, STREAMLIT, MICROSOFT EXCEL*
video
live demo
reference code

*Business Analytics Web Dashboard Using Python, Html, CSS, Streamlit & Excel as Database | real Word*
live demo
source code
video

*Logistic Regression Analysis And Coefficient Of Correlation Using Python And Jupyter Notebook*
reference code

[jefersoneurides]

Thanks a lot, one of the best videos about streamlit and a beautiful template. Congrats

[wtfcmonwtf]

I do not speak Kiswahili... but I recognise the immense value you're giving. Jah Bless...!!! And, kindly keep up the good work....!!!! 🙏🙏🙏🙏🙏

[felixogero]

Amazing ❤ asante sana my brother I've learnt a lot

[bhoomikakapoor]

This is useful but I didn’t understand the language
Can you make it in english if possible

[dhanasria]

'streamlit' is not recognized as an internal or external command,
operable program or batch file.
how to make this workout

[eagleterry]

Ningependa kusirikiana nawe kwa mambo ya data sciensi

[tholetivamsidharreddy]

I am not getting streamlit option menu help me out

[syedahsannoori]

is this a realtime update? means in future if data changes in database will it be changed on website as well?

[putriafianurfallahi]

i am having an error while deploying the app, the error is "ModuleNotFoundError: No module named 'plotly'" could you help me to resolve it? i already add the requirement text

[mcheniitsolution]

Naweza kutumi streamlit kutengeneza system ya kupredict network traffic kujua kama norma or abnormal. Kama inawezekana naomba nisaidie muongozo

[tholetivamsidharreddy]

Import streamlit option menu not showing

[dhanasria]

exception has occurred: ValueError
DataFrame constructor not properly called!
File "C:\Users\Dhanasri\Desktop\Myproject\Home.py", line 17, in <module>
df = pd.DataFrame(result, columns=columns)

ValueError: DataFrame constructor not properly called!
how to correct this

[prthm]

hy mate,
I am having error while connection while mysql it is giving me error of mysql.connector.connect
can you help me to resolve it

[anujdubey]

hello sir
i am having error [error type ] is
TypeError: cannot convert the series to <class 'float'>

i hope you see these cmt

[SP-jsgf]

This look usefull but I understand the language

[swahiliicttutorials]

PYTHON, DJANGO AND MYSQL STATISTICS WEB APP [LOAN MIS ]

Episode 1
Python Web Analytics App Loan Business Intelligent with Django and MySQL Project introduction

Episode 2
Python Web Analytics App How to start Django Web Project and Link HTML Pages

Episode 3
Python Web Analytics App using Django How to use Bootstrap Data table Google Fonts jQuery in Django

Episode 4
Python Web Analytics App using Django How to link Html pages and perform routes

Episode 5
Python Web Analytics App using Django How to create Models and Migrate to MySQL

Episode 6
Python Web Analytics App using Django How to Install Admin Site material Design Theme and Customize

Episode 7
Python Web Analytics App How to create Simple Analytics Page with Bar graph and Metric Cards

Episode 8
Python Web Analytics App How to create a Backend HTML form with File upload using Crispy


Episode 9
Python Web Analytics Loan Intelligent App with Django and MySQL HTML Form Add Loan to MYSQL

Episode 10
Python Web Analytics App using Django Normal Distribution and Z test Statistics with Box Plot

Episode 11
Python Web Analytics App How to create Meter Gauge to Visualize Business Position and Target

Episode 12
Python Web Analytics App Loan Business Intelligent with Django and MySQL Complete Project

[swahiliicttutorials]

live demo

source code


OTHER PYTHON VIDEO SERIES

Analytics Web application Multiple Linear Regression Web Project using Streamlit and Python
live demo
reference code
Video tutorial

*Python Web Dashboard using DashPlotly Framework and Dash Bootstrap Component*
Demo 1
Demo 2
reference code
Video tutorial

*Business Analytics Dashboard Website using Streamlit Python and MySQL*
live demo
reference code
Video tutorial

*descriptive analytics website with MySQL*
live demo
reference code
Video tutorial

*Python Machine Learning Web App Multiple Linear Regression using Streamlit Python and MySQL*
live demo
reference code
Video tutorial

*analytics dashboard with excel and graphs*
live demo
Video tutorial

*Web Analytics Dashboard using Python and Streamlit to Visualize Sales* Data of Excel file
live demo
reference code
Video Tutorial

*Streamlit Web Visualization Dashboard using Python and PygWalker Exploratory Library*
Live Demo
Source Code
Video Tutorial

*Crosstabulation web*
live demo
reference code
Video tutorial

*Add new Record to Excel file via Web Interface*
live demo
reference code
Video tutorial

*Percentiles, 5 number summary, Categorical data*
live demo
reference code
Video tutorial

*Business Intelligent Analytics Web Dashboard Using PYTHON, HTML, CSS, STREAMLIT, MICROSOFT EXCEL*
video
live demo
reference code

*Business Analytics Web Dashboard Using Python, Html, CSS, Streamlit & Excel as Database | real Word*
live demo
source code
video

*Logistic Regression Analysis And Coefficient Of Correlation Using Python And Jupyter Notebook*
reference code