Quick Data Visualization of Excel Data Demo | Python Pandas Tutorial

Опубликовано: 26 Июль 2020
на канале: Derrick Sherrill

24,677

Hey Everyone! Here's a brief demo of some data visualization techniques with python pandas. Let me know what you want me to do next!

Here's the worksheet I used, it's hosted by microsoft:
https://go.microsoft.com/fwlink/?Link...

#python #pandas #datavisualization
Support the Channel on Patreon --
  / derricksherrill
Join The Socials --
Reddit -   / codewithderrick
FB -   / codewithderrick
Insta -   / codewithderrick
Twitter -   / codewithderrick
LinkedIn -   / derricksherrill
GitHub - https://github.com/Derrick-Sherrill
*****************************************************************
Full code from the video:
import pandas as pd
import matplotlib.pyplot as plt

excel_file_path = "Financial Sample.xlsx"
df = pd.read_excel(excel_file_path)
#print(df)

Time series
df_vtt_canada = df.loc[(df['Country'] == 'Canada') & (df['Product'] == 'VTT') & (df['Segment'] == 'Government')]
df_vtt_canada = df_vtt_canada.sort_values(by=['Date'])
#df_vtt_canada.plot(x='Date', y='Profit')
#plt.show()

df_products = df.groupby(['Product']).sum()
df_products['Units Sold'].plot.pie()
plt.show()

Packages (& Versions) used in this video:
Python 3.8
Pandas 1.0.5

*****************************************************************
Code from this tutorial and all my others can be found on my GitHub:
https://github.com/Derrick-Sherrill/D...

Check out my website:
https://www.derricksherrill.com/

If you liked the video - please hit the like button. It means more than you know. Thanks for watching and thank you for all your support!!

--- Channel FAQ --

What text editor do you use?
Atom - https://atom.io/

What Equipment do you use to film videos?
https://www.amazon.com/shop/derricksh...

What editing software do you use?
Adobe CC - https://www.adobe.com/creativecloud.html
Premiere Pro for video editing
Photoshop for images
After Effects for animations

Do I have any courses available?
Yes & always working on more!
https://www.udemy.com/user/derrick-sh...

Where do I get my music?
I get all my music from the copyright free Youtube audio library
https://www.youtube.com/audiolibrary/...

Let me know if there's anything else you want answered!

-------------------------

Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!