How to count the number of unique rows in a Pandas DataFrame using Python
Land Your First Data Science Job
A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.
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 :
Land Your First Data Science Job
A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.
Related Articles
Continue your learning journey with these related topics
Master Data Science in Days, Not Months 🚀
Skip the theoretical rabbit holes. Get practical data science skills delivered in bite-sized lessons – Approach used by real data scientist. Not bookworms. 📚