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 plotly.graph_objects as go
import pandas as pd
excel_file = 'ProductSales.xlsx'
df = pd.read_excel(excel_file)
print(df)
data = [go.Scatter( x=df['Date'], y=df['Profit'])]
fig = go.Figure(data)
fig.show()
plotly.offline.plot(fig, filename="Salesreport.html")
https://github.com/Derrick-Sherrill/D...
*****************************************************************
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!!
Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!
