pandas reset_index after groupby.value_counts()
You need parameter name in reset_index, because Series name is same as name of one of levels of MultiIndex:
df_grouped.reset_index(name='count')Another solution is rename Series name:
print (df_grouped.rename('count').reset_index()) A Amt count0 1 30 41 1 20 32 1 40 23 2 40 34 2 10 2More common solution instead value_counts is aggregate size:
df_grouped1 = dftest.groupby(['A','Amt']).size().reset_index(name='count')print (df_grouped1) A Amt count0 1 20 31 1 30 42 1 40 23 2 10 24 2 40 3