value_counts pandas dataframe 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 count in python

col-name.value_count()

Example 3: 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 4: plot value counts pandas

df.letters.value_counts().sort_values().plot(kind = 'barh')

Example 5: count_values in python

idx.value_counts()

Example 6: relativefrequencies of the unique values pandas

df.value_counts(normalize=True)