I have schools and classes to analyze % of students succeed exams. If I do so the output is series of multi indexes. But I need a dataframe from this as an output.
df.groupby(["school","class"]).passed_or_not.value_counts(normalize=True)*100
Asked
Active
Viewed 24 times
0
Trenton McKinney
- 56,955
- 33
- 144
- 158
lincolnab
- 47
- 6
-
so need `.reset_index()` ? – jezrael Jun 10 '22 at 09:58
-
where on this current code? – lincolnab Jun 10 '22 at 10:00
-
to end of your code. – jezrael Jun 10 '22 at 10:00
1 Answers
1
df.groupby(["school", "class"]).passed_or_not.value_counts(normalize=True)*100.reset_index(name='share')
Trenton McKinney
- 56,955
- 33
- 144
- 158
lincolnab
- 47
- 6