Quick Data Visualization of Excel Data Demo | Python Pandas Tutorial

Veröffentlicht am: 26 Juli 2020
auf dem Kanal: 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!

Auf dieser Seite können Sie das Online-Video Quick Data Visualization of Excel Data Demo | Python Pandas Tutorial mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Derrick Sherrill 26 Juli 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 24,677 Mal angesehen und es wurde von 1 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

994