value_counts() for frequency in Pandas - Step-by-Step Execution

Concept Flow - value_counts() for frequency

Start with a pandas Series

↓

Call value_counts() method

↓

Count unique values

↓

Sort counts descending

↓

Return frequency Series

↓

End

The value_counts() method counts how many times each unique value appears in a pandas Series and returns a sorted frequency count.

Execution Sample

Pandas

import pandas as pd
s = pd.Series(['apple', 'banana', 'apple', 'orange', 'banana', 'apple'])
counts = s.value_counts()
print(counts)

This code counts how many times each fruit appears in the Series.

Execution Table

Step	Action	Intermediate Result	Explanation
1	Create Series s	s = ['apple', 'banana', 'apple', 'orange', 'banana', 'apple']	Series holds 6 fruit names
2	Call s.value_counts()	Count unique values	Counts how many times each fruit appears
3	Count 'apple'	3	'apple' appears 3 times
4	Count 'banana'	2	'banana' appears 2 times
5	Count 'orange'	1	'orange' appears 1 time
6	Sort counts descending	apple:3, banana:2, orange:1	Sorted by frequency from highest to lowest
7	Return result	Series with index ['apple', 'banana', 'orange'] and values [3, 2, 1]	Final frequency count output

💡 All unique values counted and sorted, method returns frequency Series

Variable Tracker

Variable	Start	After value_counts()	Final
s	Empty	['apple', 'banana', 'apple', 'orange', 'banana', 'apple']	Same
counts	Undefined	apple:3, banana:2, orange:1	Same

Key Moments - 3 Insights

Why does value_counts() return a Series and not a dictionary?

value_counts() returns a pandas Series because it keeps the order sorted by frequency and supports pandas operations. See execution_table step 7 where the result is a Series with index and values.

What if the Series has numbers or mixed types?

value_counts() works the same way for numbers or mixed types by counting unique values. The type does not affect counting, only the unique values present.

Does value_counts() include missing values (NaN)?

By default, value_counts() excludes NaN values from the count. You can include them by using the parameter dropna=False.

Visual Quiz - 3 Questions

Look at the execution_table at step 3, how many times does 'apple' appear?

A 3

B 2

C 1

D 4

💡 Hint

Check the 'Intermediate Result' column at step 3 in the execution_table.

At which step does the method sort the counts in descending order?

A Step 2

B Step 4

C Step 6

D Step 7

💡 Hint

Look for the step mentioning sorting counts descending in the execution_table.

If the Series had a missing value NaN, would value_counts() count it by default?

A Yes, always counts NaN

B No, excludes NaN by default

C Only counts NaN if dropna=True

D Counts NaN only if Series is numeric

💡 Hint

Refer to the key_moments section about NaN handling.

Concept Snapshot

value_counts() counts unique values in a pandas Series.
Returns a Series sorted by frequency descending.
Excludes NaN by default (use dropna=False to include).
Useful to see how often each value appears.
Syntax: series.value_counts()

Full Transcript

The value_counts() method in pandas counts how many times each unique value appears in a Series. It returns a new Series sorted by the counts in descending order. For example, if a Series has fruits like 'apple', 'banana', and 'orange', value_counts() will tell you how many times each fruit appears. It excludes missing values (NaN) by default. This method is useful to quickly understand the frequency of data points in your dataset.