In an excel spreadsheet with four sheets (this is an A/B test, Sheet 1 is a_group_flights, Sheet 2 is b_group_flights, Sheet 3 is a_group_hotels, Sheet 4 is b_group_hotels), I'm interested in plotting two of the columns "budget_price" and "total_spend" over a time period shown by "budget_datetime" and have those two lines (budget_price and total_spend) overlap to show the difference between what your budget is and how much you're actually spending over time on trips.
This is what the spreadsheet looks like: https://ibb.co/JHCf12z
I am using Dash Plotly and want to read the excel spreadsheet with Pandas, and then plot the data on a graph.
xlsx = pd.ExcelFile('data.xlsx')
#python #pandas