how to use value_counts in pandas code example

Example 1: count values 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 2: value count in python

col-name.value_count()

Example 3: 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 4: relativefrequencies of the unique values pandas

df.value_counts(normalize=True)

Example 5: value_counts pandas condition

print(df)
OUTPUT
   A  B  C
0  1  2  3
1  4  5  6
2  7  8  9

subset_df = df[df["A"] < 3]
column_count = subset_df.count()

print(column_count)
OUTPUT
A    1
B    1
C    1
dtype: int64