How to Create Interactive Charts from Excel Data - Five Minute Python Scripts

Plotly is a great tool we can use to create many types of interactive charts from pandas df's and microsoft excel spreadsheets.

What we'll cover:
- How to download Pandas, plotly
- How to load data into pandas dataframe
- How to format that data for loading into a plotly figure
- How to display that plotly figure
- How to save the figure once created

Thanks so much for all the support! You guys are incredible. We BROKE 4,000! 4,090+ subscribers. You all rock. Thanks for supporting me.

*****************************************************************
Full code from the video:
import plotly
import pandas as pd

print(df)

data = [go.Scatter( x=df['Date'], y=df['Profit'])]

fig = go.Figure(data)

*****************************************************************
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 and thank you for all your support!!

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

[kleanthisskoulikaris]

As usual, you provide awesome educational content in easy to follow small-duration clips. Thank you so much Derrick!

[billelguechi]

Awesome bro great job keep going finally I've found something that make me stay at home away from the Corona Virus Cheers from Algeria North Africa

[legohistory]

In Germany we say that you are a "Ehrenmann"!
Thank you very much!

[jairoj.ninoperez]

Great video. Straight to the point. You've become my go-to source for spreadsheet -python matters. Keep it up! One question tho: You called go.scatter but the graph produced looks like a line chart. What am I missing?

[winniepooh]

It was just the video I was looking for..Great.. love this video

[MohammadRezaMokhtari_Robin]

Hey Derrick, thanks a lot for this wonderful video!

[jklfaav]

This video is so nice and helped me very much! Thank you! Keep doing amazing videos!

[GabrielIchiro]

very interesting and intuitive videos, keep going!

[kicc]

Very nice. I am assuming that if I will also be able to plot a WMA for example, as a technical indicator on the .html chart. Also, I love the idea of posting it to a website instead too. For example, I can save it on my local website folder and upload to site via FTP, or maybe this can be sent directly there. Will check on it. Nice to test with fresh downloaded data too. Thanks.

[henkbroam]

Would you recommend this for super large files with almost a million data points? and not, what to use instead ?

[youtubewatch]

hi bro, thanks for your video .it helps alot. if i wanna show sales, revenue, profit in the same charts. how to do it ?

[vio-noob_]

Any advantages to using Seaborn instead of plotly? Or is it really just preference

Also, another great video. Keep it up!

[mikekaspari]

Great video. Where can I download the excel file for practice?

[rosalyna_]

is it possible to add that chart in the same excel file ??

[nirajmunot]

Hey, Thanks a lot for this video. Can you please tell me how can I take data from a particular Sheet in the excel?

[sainagabharat]

Great. Thanks a lot bro.
Channel Subscribed ;)

[trungduhuynh]

Hi Derrick,
If I used Dash Plotly library to run demo, Could I output offline html file as your, I also did but Couldn’t, so how to share localhost for my teammate view chart? Big thanks

[aaronbell]

can plotly render html strings or .svg files? I need to send this to an airtable data base before a website picks it up

[adl]

Nothing showed up after I ran fig.show().
Did I do something wrong?


from matplotlib import pyplot as plt
import pandas as pd
from plotly import graph_objs as go

excel_file = "Python_Practice_Chart.xlsx"
df = pd.read_excel(excel_file)
data = [go.Scatter(x=df['Date'], y = df["RN"])]
fig = go.Figure(data)
fig.show()

[azizee]

sir, do you have video how to make table from excel data and show it on browser?