JosephZYU
11/8/2019 - 3:33 PM

sort

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])