Sales Data Analysis With Python | Solving Real World Data Science Problems | Python Case Study | EDS

Veröffentlicht am: 19 Juli 2020
auf dem Kanal: ED Science

85,764

2.4k

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

Auf dieser Seite können Sie das Online-Video Sales Data Analysis With Python | Solving Real World Data Science Problems | Python Case Study | EDS mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer ED Science 19 Juli 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 85,764 Mal angesehen und es wurde von 2.4 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!