Pandas Mean for Certain Column

Question

I have a pandas dataframe like that:

How can I able to calculate mean (min/max, median) for specific column if Cluster==1 or CLuster==2?

Thanks!

Answer 1

You can create new df with only the relevant rows, using:

newdf = df[df['cluster'].isin([1,2)]

newdf.mean(axis=1)

In order to calc mean of a specfic column you can:

newdf["page"].mean(axis=1)