how to get value_counts output in dataframe format code example
Example 1: how to get value_counts output in dataframe format
df = df.value_counts().rename_axis('unique_values').reset_index(name='counts')
print (df)
unique_values counts
0 2 3
1 1 2
Example 2: value_counts pandas
>>> index = pd.Index([3, 1, 2, 3, 4, np.nan])
>>> index.value_counts()
3.0 2
4.0 1
2.0 1
1.0 1
dtype: int64
Example 3: plot value counts pandas
df.letters.value_counts().sort_values().plot(kind = 'barh')