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