Graph Multiple Excel Worksheets with Python - Five Minute Python Automation Scripts

** Five Minute Python Tutorial **

Create Graphs across numerous Excel spreadsheets using one Python script that you can make in five minutes. Easy to automate and include into other algorithms.

Please Like and Subscribe if you like the content - it motivates me to create more! If you have any suggestions on what you would like to do with Python, let me know in the comments below.
------

Requirements:
Python
MatPlotLib
Pandas

*****************************************************************
Code from this tutorial and all my others can be found on my GitHub:

Check out my website:

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

Useful Links
-----------------------------------------------------------------------------------------------------------------
Python Download:
(Remember Python 3 is the future!)

I use Atom Text Editor for all my tutorials
Atom Text Editor:

Packages I often use in Python tutorials:
-Pandas
-Numpy
-xlrd
-TensorFlow
-Matplotlib
-Django Framework
-Beautiful Soup
(Install through Terminal $pip3 install ....)

Other Useful Services sometimes featured:
-Amazon Web Services (AWS)
-Microsoft Azure
-Google Cloud
-Juypter Notebooks

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

[karate-ka]

Basic stuff, yet effective for a newbie like me. This was great to get me started. Thank you, Derrick.

[aduck]

Love all your tutorials as they are very on point. Thank you very much.

[fernandalopez]

Amazing content! I’m learning Python and watching your videos has helped me tremendously. One question: If I only use one excel sheet, would it work?

[walerij]

In VBA you can also specify which column you would like to take by column title / column name.

[martin-xqte]

Great video. Is there a way of placing the plots into excel?

[CrispinValdezOfficial]

Excellent stuff, I love it! Keep it up!

[vinuv]

Hey upload few more similar videos ...it's really helpful ...

[khalidjj]

Another excellent video! You make it so simple....
Question, instead of changing to a specific workbook, like you showed in this demo, how to just plot all the workbooks in this folder...thanks and more videos please

[paulpolo]

Nice work, Thanks for sharing and please keep on.

[joey]

thanks! great stuff, can you also add multiple values to the y ax?
I followed your example but all my bars are the same color? yours are different colors, don't know what when wrong there..

[gopigopichand]

Thanks for sharing.. very great video..very valuable..

[ShivaniSharma-midl]

Hey! Thanks for all the help. Can you please make a video on how we can write to an excel sheet and perform operations?

[vivekkoli]

Thank you for the great video, is there any way to show Data Label on each bar?

[Ledesmath]

Dumb Question probably... I have never used matplotlib, but I wanted to confirm whether it was possible to customize the graphs by adding a title, labeling the corresponding axes, and changing the colors of the bars? Please let me know.

[l_combo]

great video - thanks!
wondering how you deal where a workbook has multiple sheets in it and you need to refer to a specific one?
Does it just default to the first sheet?


If you wanted to combined the data from both sheets into one, is it much different?

[khalidjj]

Hello
Excellent video

Questions,
1. how can I automatically chart multiple xls files that are in the same folder. I have a bunch of xls files with unique names and want to chart them on the same chart.
Is there a way chart a specific x, y column from each xks file on the same chart

2. I have many x, y columns in the same xls tab. How can I chart column A, B then column d, e, then, columns in the same chart

[precise_pace]

Great video, can you kindly show how to plot multiple overlapping histograms for the evaluation of one variable under different conditions. For example there's 6 different conditions of making steel and the strength of the steel is the variable that is being tested, therefore drawing 6 histograms in one plot to show how the mean strength varies for each condition.

[TheAlexavien]

Hi hi wanted to ask, what if I need to have two elements for example profit and cost as a bar graph side by side

[DiamondTurtleGamer]

Module MatPlotLib doesn't confirm its definition when imported.?

[ShareMarketTamilChannel]

Hello Derrick,
Can you please make a video for every 3 minutes once line chart would be updated
for example,
CE OI STRIKE PRICE PE OI
11000
11100
so on

I need to get the separate line chart on every strike price with CE OI and PE OI Line chart with 3 minutes or 5 minutes time frame
the above CE/PE OI will be changing frequently. I need to track with line chart