Finding mean from two different variables

Question

I have dataset like

df = pd.DataFrame({"type" :["A","B","C","A","B","B"], "value": [40,25,33,22,45,62]})

I want to find each individual type mean, ie., type = A has mean of 31 I did by subsetting

df_a = df.loc[df['type']=="A"]
df_a['value'].mean()

I want to do it in single line, Thanks in advance

`df.gropuby('type')['value'].mean()` – ansev Oct 30 '20 at 12:42 — ansev, Oct 30 '20 at 12:42

score 1 · Accepted Answer · edited Oct 30 '20 at 20:21

1

A possible solution might be:

df.gropuby('type')['value'].mean()

edited Oct 30 '20 at 20:21

Wai Ha Lee

answered Oct 30 '20 at 12:42

Andre S.

1 Answers1