How to count the number of unique rows in a Pandas DataFrame using Python

1 min

You can count the number of occurrences of a DataFrame column the .value_counts() method.

Here is the code

# Import the Pandas library
import pandas as pd

# We create our example dataframe
df = pd.DataFrame({"countries" :  ["Germany", "USA", "Germany", "France"]})

# We print the number of unique occurences 
print(df["countries"].value_counts())

Here you are! You now know how to count the number of unique rows in a Pandas DataFrame using Python.

More on DataFrames

If you want to know more about DataFrame and Pandas. Check out the other articles I wrote on the topic, just here :

Pandas - The Python You Need
We gathered the only Python essentials that you will probably ever need.