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

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


Full Code From This Example:

YouTube Description:

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) plotly.offline.plot(fig, filename="Salesreport.html") ***************************************************************** 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!

Enjoy this content? Consider Subbing to the Youtube channel

Derrick Sherrill

By: Derrick Sherrill

Thanks for visiting my page! I'm working hard to make the best content I can for you. I love watching people learn and teaching others. Happy Coding!

Become a Patreon!