Sales Data Analysis With Python | Solving Real World Data Science Problems | Python Case Study | EDS
In this video we use Python Pandas & Python Matplotlib to analyze and answer business questions about 3 years worth of sales data. The data contains thousands of store purchases broken down by month, product type, cost, purchase address, etc.
Setup!
Github source code & data: https://github.com/EDSOfficial/Sales-...
Installing Jupyter Notebook: https://jupyter.readthedocs.io/en/lat...
Installing Pandas library: https://pandas.pydata.org/pandas-docs...
Detailed video description! (timeline can be found in comments)
We have answered these 5 questions through our data analysis mainly using pandas and matplotlib library.
Q1. What is the overall sales trend?
Q2. Which are the Top 10 products by sales?
Q3. Which are the Most Selling Products?
Q4. Which is the most preferred Ship Mode?
Q5. Which are the Most Profitable Category and Sub-Category?
To answer these questions we walk through many different pandas & matplotlib and seaborn library methods. They include:
Adding columns
Parsing cells as strings to make new columns (.str)
Using the .apply() method
Using groupby to perform aggregate analysis
Plotting bar charts and lines graphs to visualize our results
If you enjoy this video, make sure to leave it a like and subscribe to not miss any future similar tutorials :).
Video Timeline!
0:00 - Intro
0:20 - Downloading the Data
1:30 - Opening Jupyter Notebok
2:05 - Objective
3:30 - Importing Libraries
4:23 - Importing Dataset
5:03 - Data Audit
11:10 - Q1. What is the overall sales trend?
16:35 - Q2. Which are the Top 10 products by sales?
20:22 - Q3. Which are the Most Selling Products?
23:40 - Q4. Which is the most preferred Ship Mode?
25:30 - Q5. Which are the Most Profitable Category and Sub-Category?
Thanks for watching! If you enjoyed, please consider subscribing :).
#EDScience #ExploreDataScience #datasciencecourse #DataScience #WhatIsDataScience #DataScienceForBeginners #DataScientist #DataScienceTutorial #DataScienceWithPython #DataScienceWithR #DataScienceCourse #BusinessAnalytics #MachineLearning#pythoncourse #pythontutorialforbeginners #pythonprojects #pythonmachinelearning #datascienceforbeginners #datasciencewithpython #datascienceclasses #datasciencebeginners #datasciencecourse #datasciencecareers #machinelearning
In questa pagina del sito puoi guardare il video online Sales Data Analysis With Python | Solving Real World Data Science Problems | Python Case Study | EDS della durata di ore minuti seconda in buona qualità , che l'utente ha caricato ED Science 19 luglio 2020, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 85,764 volte e gli è piaciuto 2.4 mille spettatori. Buona visione!
