pandas tricks

 df['count'].clip(lower=1, upper=10)

pandas tricks 3

 df.sort_values(["a","b","C", ascending=[True, False, True)

df.nlargest(10, 'a').nsmallest(5,"b)

pandas tricks 2

 df.select_dtypes(include=['int'])

df.select_dtypes(include=['number'])

df.selected_dytpes(include=['np.number'])

df.get_dtype_counts()

pandas tricks (1)

search column using filter: 

df.filter(like="good")

df.filter(regex="\d")

pandas, groupby result to file

 grpd = df.groupby('name').size()

print(grpd)

grpd.reset_index().to_csv('result.csv')