Issues with Common-Excel-Part-2.ipynb

[maverickactuary]

We have a few sort() hard stops in Python 3.5. Thus: In [13]: #df = df.sort('date') # AKH fails df = df.sort_values(by='date') # AKH this works

In [26] # df[(df['sku'].str.contains('B1-531')) & (df['quantity']>40)].sort(columns=['quantity','name'],ascending=[0,1]) # AKH fails df[(df['sku'].str.contains('B1-531')) & (df['quantity']>40)].sort_values(by=['quantity','name'],ascending=[0,1]) # AKH works

Could also replace ix In [29]: # df.drop_duplicates(subset=["account number","name"]).ix[:,[0,1]] # AKH df.drop_duplicates(subset=["account number","name"]).loc[:,["account number","name"]] # AKH