1 www.quandl.com NumPy / SciPy / Pandas Cheat Sheet Select column. Select row by label. Return DataFrame index. Delete given row or column. Pass axis=1 for columns. Reindex df1 with index of df2. Reset index, putting old index in column named index. Change DataFrame index, new indecies set to NaN. Show first n rows. Show last n rows. Sort index. Sort columns. Pivot DataFrame, using new conditions. Transpose DataFrame. Change lowest level of column labels into innermost row index. Change innermost row index into lowest level of column labels. NumPy / SciPy arr = array([]) arr.shape convolve(a,b) arr.reshape() sum(arr) mean(arr) std(arr) dot(arr1,arr2) vectorize() Create a Series. Create a Dataframe. Create a Panel. Pandas Create Structures s = Series (data, index) df = DataFrame (data, index, columns) p = Panel (data, items, major_axis, minor_axis) df.stack() df.unstack() df.pivot(index,column,values) df.T DataFrame commands df[col] df.iloc[labe
