How to get frequency counts of a column in Pandas DataFrame

In this post, we will see how to get frequency counts of a column in Pandas DataFrame.

Sometimes, you might have to find counts of each unique value for the categorical column. You can use value_count() to get frequency counts easily. value_count() returns series object with frequency counts data for a column.

Here is sample Employee data that will be used in below example:

NameAgeDepartment
Adam27HR
Reena22Sales
Mahesh33Tech
Supriya26HR
Aman34Tech

Output:

As you can see, we got Frequency counts for each unique value in column Department.
That’s all about how to get frequency counts of a column in Pandas DataFrame.

Related Posts

  • Copy DataFrame in Python
    10 July

    Copy DataFrame in Pandas

    This articles provide different ways to copy DataFrame in Pandas.

  • Pandas convert column to int
    18 June

    Pandas convert column to int

    Table of ContentsUse the to_numeric() function to convert column to intUse the astype() function to convert column to intUse the infer_objects() function to convert column to intUse the convert_dtypes() function to convert column to int Pandas is a library set up on top of the Python programming language and is mostly used for the purpose […]

  • 20 September

    Reorder the columns of pandas dataframe in Python

    Table of ContentsUsing reindex methodUsing column selection through column nameUsing column selection through column index In this post, we will see 3 different methods to Reordering the columns of Pandas Dataframe : Using reindex method You can use DataFrame’s reindex() method to reorder columns of pandas DataFrame. You need to pass columns=[$list_of_columns] to reindex() method […]

  • 08 September

    Pandas create Dataframe from Dictionary

    Table of ContentsUsing a Dataframe() method of pandas.Using DataFrame.from_dict() method. In this tutorial, We will see different ways of Creating a pandas Dataframe from Dictionary . Using a Dataframe() method of pandas. Example 1 : When we only pass a dictionary in DataFrame() method then it shows columns according to ascending order of their names […]

  • 08 September

    Pandas Convert list to DataFrame

    In this tutorial, We will see different ways of Creating a pandas Dataframe from List. You can use Dataframe() method of pandas library to convert list to DataFrame. so first we have to import pandas library into the python file using import statement. So let’s see the various examples on creating a Dataframe with the […]

  • 26 May

    Pandas DataFrame to CSV

    Table of ContentsSyntax of DataFrame.to_csv()DataFrame sample dataConvert pandas DataFrame to csv Save CSV file without index column Save CSV file with Custom columns header Save CSV file with selected columns Save CSV file with custom delimiter Save CSV file without header Append data to CSV file Save CSV file with index_label In this post, we […]

Leave a Reply

Your email address will not be published. Required fields are marked *

Subscribe to our newletter

Get quality tutorials to your inbox. Subscribe now.