Quick Data Visualization of Excel Data Demo | Python Pandas Tutorial

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:
go.microsoft.c...
#python #pandas #datavisualization
Support the Channel on Patreon --
/ derricksherrill
Join The Socials --
Reddit - / codewithderrick
FB - / codewithderrick
Insta - / codewithderrick
Twitter - / codewithderrick
LinkedIn - / derricksherrill
GitHub - github.com/Der...
*****************************************************************
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:
github.com/Der...
Check out my website:
www.derrickshe...
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 - atom.io/
What Equipment do you use to film videos?
www.amazon.com...
What editing software do you use?
Adobe CC - www.adobe.com/...
Premiere Pro for video editing
Photoshop for images
After Effects for animations
Do I have any courses available?
Yes & always working on more!
www.udemy.com/...
Where do I get my music?
I get all my music from the copyright free KZbin audio library
www.youtube.co...
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!

[@gregf9160]

Excellent short look at pandas and python. I'd love more like this!

[@jordanirvin]

These are the best python tutorials on the web. Short, but packed with great information and alternatives. Logical and without resorting to jargon or acronyms like everyone else.

[@minevr5839]

Thank you Derrick and good to see back on again.

[@TravisGarnett]

@H R: I concur, and would love to see more on data visualizations in Python!! 😎 Thank-you again, Derrick.

[@valltechnologies]

Hi Derrick, great content! Couple suggestions for classes: 1. How to build a parser for log files. Extract certain string content or data and create reports (SNMP data, packet captures, network log files). 2. Instead of using excel, show how to use a database with Python for data science (SQLite, MySQL, Postgres, Spark, etc...) 3. Python with Google Sheets?

[@AcceptableBread]

Hey Derrick- you offer some of the best tutorials I’ve found. You are a talented teacher. Thanks for sharing! If you ever make a Udemy course, I would definitely buy it.

[@benwarburton2326]

I don't understand why I hadn't found your stuff earlier. It's perfect! I work remotely now and use python daily, your channel is a blessing man. PLEASE KEEP IT UP!

[@daksh_joshi11]

Great video! I'm just starting on Python and you're one of the first channels I've come across. Keep going!

[@KleanthisSkoulikaris]

It's so good to have you back Derrick. Please keep giving us these little wisdom nuggets and before long, you'll be creating a little army of Pythonistas, all grateful for your contributions!

[@nicombor]

Great explanations on each command, thank you! I'd love to see a more in depth video showing how to further manipulate the chart labels, font size, additional y axis, changing colors, etc.

[@tranceaddict54]

Thank you for all these great walkthroughs. I work a lot with SQL data and your videos help me manipulate the data before I send it to Excel.

[@kevinmcaleer28]

Great video Derrick - keep doing what you're doing!

[@dawn.henderson]

Thank you, Derrick! Quick and concise, but educational. I'm an Excel VBA monkey and have been slowly embracing Python. This is really helpful for me to see the potential, and with MUCH less coding involved ;-)

[@gunasekar4098]

Recently I started to watch your videos. There is no vidoe last one years.. now you came back we are happy to see your videos

[@akakhbod]

excellent derrick.. very clean and clear.. please post more

[@robmonkriedlinger]

Awesome!! Great to have you back. Learnt so much from you in the past! Thank you!!

[@vanimalalsa8606]

The best tutorials so far ! I would love to learn more ! How about a dashboard, if possible interactives, how to link web reports, excel reports, to create visuals that can auto-update and vice versa, publish out somewhere. For the types of visuals, descriptives and prescriptive, since that is so big now.

[@comprehensivemathsscience1217]

Wonderful.. i love working with pandas

[@imdadood5705]

I found this channel yesterday. A valuable find indeed. Thanks Derrick

[@alicemystery5520]

Nice, i liked how easy you make pandas df work with excel data. It kinda make all the time i spent learning excel look silly.

[@pinakpaninath4321]

Thank you derrick you have solved my huddle today

[@gussta1]

Nice to see you back....any chance you could put something together where you're pulling data out to different sheets within the same file?...maybe by country, or something along those lines

[@900s331t]

I like your tutorial very much, simple yet usefull, as usual...thx !!!

[@juanfebena8695]

This video is a great example for great Data Visualization. The thing is that, I would use more Tableu or MPBI to create graphs or dashboards rather using python. I would love to see how you make a predictive model or how to do component analysis in Python! (Thank for the videos, im just starting to learn python and by watching your videos i´ve been learning a lot1

[@ianbraganza3065]

I recently discovered your awesome channel. Glad you're back. Thanks for an awesome video, super helpful

[@izoka1828]

Good to see you again ! Maybe create a dashboard using different data vizualizations and múltiple excel files as data sources.

[@akmiable]

Ура Деррик вернулся!!!

[@sridharrao6366]

Great videos!! Welcome back Derrick! Happy to see you again. Missed your tutorials from long time. Could you please also post videos on kivy/kivymd and python on mobile apps.

[@wazy1852]

Nice to see you back! Why do you think a professional should use python to visualize data instead of excel ? isn't it more convenient and faster ?

[@Abhijeetetrx]

Welcome back bro. Where were you last 5 months man!!

[@Jblanco1989]

It's been a while since your last video. Good to see you again!!

[@stanm991]

I LOVE YOUR VIDEOS SO MUCH thank you for the simple explanations and breaking everything down!!

[@tommy1149]

Hey, in really glad you're back! Love your videos!

[@9000pepo]

Thank you and I miss your videos. Thank you for coming back and posting :)

[@mahnazkatuzi567]

Awesome!!! Please make some videos about statistics in python.

[@asankacool1]

Please do a video on, How to setup python program files to be saved in the same directory ? Because otherwise it waste a lot of time consecutively when writing the long file path.

[@masterludovicus802]

Hi there. I've been trying to follow along with you but when I got to the plt.show() part and run it, I don't get the graph, just an empty coordinate system window. I get a res_values = method(rvalues) message. Not sure what I am missing.

[@prajaysharma]

Hi Derrick , Nice to see you after long time , hope you are safe and doing well.

[@findthetruth3021]

Very informative. Welcome back bro. Could you please make videos on R program, because I can understand you easily.

[@neomatrix3612]

Hi Derrick, please may you do a tutorial on NetworkX and how to make diagrams with it? Thanks

[@aleksandrshvechkov4453]

Hi Derrick, could you explain how to get excel smart table in the sheet?

[@toshiro6589]

I love your excel videos. Clear, in media res. Do you have any video where you use some statistical tests ( chi square, t test..) in your programming?

[@jaker9040]

Hey great video, quick question if you even see this comment - when I type out the df.loc my phycharm does not recognize that as a command it just writes it out as text. I've imported pandas and matplot successfully but it just doesn't register the '.loc'

[@chatrughanprasad7778]

very good explanation bro

[@VilaCharlot]

Hello Derrick, I was wondering if I could make something interactive with another user. For exemple: Write a code asking which stock the user wants to see the data, and then, when he types it, it shows the earning per share, the price of the stock and other things. I have the data but don't know how to make that interactive.

[@juanochoa2725]

Please more videos about pandas and Excel

[@AdilKhan-jp7hn]

Hi, excellent videos. Can you plz show us examples of using LibreOffice spreadsheets?

[@gunasekar4098]

Is that possible to download excel file from excel sheet hyperlink to save in common folder by pandas

[@nickarrigo5540]

great content! Glad I found this channel!

[@peterholmlund9454]

Hi Derrick, love your short and informative tutorials! Considering I would be able to extract and create plots from my rather complicated instrument logfile, how would one set about making python generate an automatic report with the plots, say pdf format? Ultimate goal is to create an interactive tool to extract info based on choices but this would be a good start. At this point I am able to read the files in pandas dataframe and performing some splitting of data.

[@rockNbrain]

Amazing!

[@ishmeetbindra5428]

This is great, can you please make a full visualisation course, using Dash or Seaborn?

[@Sassysrishti6169]

Thanks Derrick! it was good. i have n number of files in one directory. i can use for loop to open each file and would like to delete starting 6 lines from each file. It is first part of data cleaning. 2nd step would be combining these files into one excel sheet. just for your info, actually initially, above text file contains some text in first six lines and then followed by curve data points in x,y columns. That is why data cleaning is required before combining into one excel. for both steps, it looks like that i can use for loop. could you please let me know your thoughts on this.

[@sakolly4401]

Please suggest Mimimum spec of Notebook for Python beginner(nonMac)

[@punjaramborhade1701]

Thanks Derrick Your video great, i found very late, really good... Thanks for sharing knowledge. One query, i m fetching live nse data of stock from morning 9.15 to 3.30 in excel. 1. Can't open excel while recording. 2. If I want to visualisation while recording data means = 9.15, 9.20,9.25 same data i want in visualize form till 3.30 while recording in excel. How to do it... Im digging but search brought me to u.. Plz help...

[@vio-noob_6737]

Nice one!

[@christianheins1530]

Video on how to insert selected columns from one file to the other

[@TarcisiodeMeiraLinsFilho]

It would be great if you made a tutorial on how to grab data from Johns Hopkins’. COVID dashboard and plot like you did here

[@michap.fertig3656]

Do some codewars challenges and explain your thinking! Would be great. Thanks!

[@TasteDaRDX]

Thanks for video, very useful content. How would you calculate different values or columns, like margin?

[@jitendramakwana2719]

@derrik : great work, could you show this: togin to SFTP win server , pull the file from day wise folder and place them in local drive.

[@amauta5]

Bro, are you shooting these in one take? Thank you for explanation.

[@adrianminimal9478]

great post

[@raheem0046]

Hi Please import .XER File (primavera file) Split into tables Create relationships And plot resources histogram

[@jumpropemonk7703]

Why aren't you using Jupiter Notebook?

[@aditgupta684]

Thanks man!

[@shawnbumgarner5638]

How would I automate this process in the sense of attaching the pie chart to an Outlook email with a standard list of recipients and possibly also providing the aggregate (summarized) table of data to the email in text (the data that drives the pie chart I mean)? Love these videos, I work through them line by line on my own each time you put one together - thanks so much Derrick!

[@CodeWithDerrick]

I'm happy to hear you enjoy the videos! Whenever you want to start using specific services like outlook you would likely have to use their API. It is possible to export tables and graphs as PDFs and such with pandas too and send emails using python and smtp if the service doesn't matter too much. There's also a lot of cool graphing libraries you can use to host graphs/tables online and send links with python like plot.ly - Your use case sounds like a great topic for me to make a video on. I'll see what I can put together. Thanks for your kind words & watching!

[@pinakpaninath4321]

Hey Derrick, can you please make a video on the requested topic which I had written in the comment box..Please

[@snakesnarroz]

Looking to manage my finances with python, pandas etc and budgeting. Rather than create from scratch does anyone know of a repo out there I could start with?

[@pursueweazmarecoverall486]

Thank you. Can I share the script I am writing with you?

[@PaulSmith-zs5je]

Is it just me or is there a really low annoying frequency in this vid until 3:09. Perhaps look at filtering out and updating clip.

[@py_tok5589]

very nice good boy, thank you

[@joshuajang1338]

Hi can you create a tutorial on how to display multiple matches from vlookup in one cell?

[@gajanandn]

Hi Derrick nice explanation 👍 , is this possible in python to read news from major news papers and alerts us

[@Roelonl]

thanks!

[@Rulzan]

i get ModuleNotFoundError: No module named 'matplotlib.pylot' i use pycharm, what have ai forgotten ?!i've installed matplotlib

[@abdelmajidalahyane3492]

u may have to install matplotlib before u can use it by typing : pip install matplotlib on ur terminal if u are on mac or linux or cmd if u are on windows.

[@geodatacenter]

We learn with this thanks

[@jaskarankaur4971]

u are awesome

[@HITthegymwithjkhman]

👍🏽

[@geodatacenter]

Great master and congratulations by give chance of download source code

[@CarlosMoreno-vw4ir]

Hello, so good to see you again!! greetings from Monterrey, Mexico.. can you show us how to display our data from dataframes on graphic interface (frames) with wxpython!! btw your videos are the best!!! thanks a lot!

[@lokrajbhatt258]

Pandas tutorial

[@pinakpaninath4321]

Hey derrick can I habe your mail id please.. Also can you show us how to do vlookup and summing and subtratcting for each row and also how to use min and max function in excel by using pandas

[@robmonkriedlinger]

Awesome!! Great to have you back. Learnt so much from you in the past! Thank you!!