Python data analysis practical examples (Query database, ReadExcel, Sort, Groupby, plot, Matplotlib)
This video covers some of the basic techniques of data analysis using Python. It will help you improve your data analysis skills using Pandas, Numpy and Matplotlib. We define questions and answer them with data analysis solution in Python. Data used in the video comes from Adventureworks database.
Q1. Highlight compnay performance by major KPIs?
Q2. What is the overall sales trend?
Q3. What are the Top 10 products by sales?
Q4. What is the overall month over month and year over year growth?
Q5. What's the sales breakdown by category?
Github repo link for the code along with data and scripts.
https://github.com/hnawaz007/pythonda...
How to install and get started with Jypter Notebook
• Install Anaconda Python, Jupyter Note...
How to video on Jypter Notebook
• Jupyter Notebook Tutorial: Introducti...
GitHub link for AdventureWorks2012 database file
https://www.youtube.com/redirect?even...
Link for stacked chart percentage calculation.
https://www.geeksforgeeks.org/stacked...
#Adventureworks #dataanalysis #python #coding
Python libraries install script...with PIP
pip install pyodbc
pip install install pandas
pip install numpy
pip install matplotlib
pip install voila
In case you are using Anaconda..
conda install -c anaconda pyodbc
conda install -c anaconda pandas
conda install -c anaconda numpy
conda install -c conda-forge matplotlib
conda install -c conda-forge voila
Thanks for watching friends!
Happy coding! :)
#Python #Coding #DataScience #Pandas #PythonPandas #Python #PythonTutorial #PythonTraining #PythonBeginners #Anaconda #JupyterNotebook
Topics covered in this video:
0:00 - Introduction
0:11 - Import libraries
1:11 - Database connection & read data from db
1:55 - Import data from Excel
2:31 - Loading the data & data sampling
3:02 - Line Chart : 1 - Data preparation
5:28 - Top Ten Product report
7:56 - Bar Chart - Month over Month
11:34 - 100% Stacked Chart
16:48 - Build KPIs
17:43 Use Viola to display visualizations
Auf dieser Seite können Sie das Online-Video Python data analysis practical examples (Query database, ReadExcel, Sort, Groupby, plot, Matplotlib) mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer BI Insights Inc 22 März 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 1,035 Mal angesehen und es wurde von 25 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
