pandas tricks

 a list of aggregation function for groupby:

min, max, mean, median, sum, count, std, var, size, describe, nuniaue, idxmax, idxmin.

df.groupby([‘airline’, ‘weekday’])[‘cancelled’,’diverted’].agg([‘sum’,’mean’]).head()

df.groupby([‘airline’, ‘weekday’])[‘cancelled’,’diverted’].agg({“dist”:[‘sum’,’mean’]).head()

pandas tricks

 df.style. highlight_max(axis=‘colums’)

CatBoost vs. LightGBM vs. XGBoost

 CatBoost vs. LightGBM vs. XGBoost | by Kay Jan Wong | Towards Data Science

 

What is a Generalised Additive Model?

What are Generalised Additive Models? | Towards Data Science

5.3 GLM, GAM and more | Interpretable Machine Learning (christophm.github.io)

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