import pandas as pd
import numpy as np
df = pd.read_excel("../data/sample-salesv3.xlsx")
df['date'] = pd.to_datetime(df['date'])
df.head()
df = df.sort_values(by=['date'])
df.head()
import pandas as pd
import numpy as np
df = pd.read_excel("../data/sample-salesv3.xlsx")
df[df['sku'].str.contains('B1')].head()
df[(df['sku'].str.contains('B1-531')) & (df['quantity']>40)].sort_values(by=['quantity','name'],ascending=[0,1])