I'm a begineer in Python. I have data from sales each 30 min as you can see in the figure below (note: .xlsx file)
I import it in pandas library so I have it in a dataframe.
import pandas as pd
df = pd.read_excel('sales_first_month.xlsx',header = None)
header = df.iloc[0]
df = df[1:] #there is an extra column that i dont want
df.columns = header #set the first row as a header
However, is necessary to have sales data each 15 min. How could I get the result?