Python | Pandas Index.value_counts ()

| | | | | | | |

Index.value_counts() Pandas Index.value_counts() returns an object containing the number of unique values. The resulting object will be in descending order, so the first item is the most common item. Excludes NA values ​​by default.

Syntax: Index.value_counts (normalize = False, sort = True, ascending = False, bins = None, dropna = True)

Parameters:
normalize: If True then the object returned will contain the relative frequencies of the unique values.
sort: Sort by values ​​
ascending: Sort in ascending order
bins: Rather than count values, group them into half- open bins, a convenience for pd.cut, only works with numeric data
dropna: Don’t include counts of NaN.

Returns: counts: Series

Example # 1: Use Index.value_counts () to count the number of unique values ​​in a given index.

# import pandas as pd

import pandas as pd


# Create index

idx = pd.Index ([ ’Harry’ , ’Mike’ , ’ Arther’ , ’Nick’ ,

’ Harry’ , ’Arther’ ], name = ’Student’ )


# Print index

print (idx)

Output:

Let’s find the count of all unique values ‚Äã‚Äãin the index.

# find the number of unique values ​​in the index
idx.value_counts ()

Output:

The function returned a counter of all unique values ​​in the given index. Note that the object returned by the function contains occurrences of values ​​in descending order.

Example # 2: Use Index.value_counts () to find the count all unique values ​​in this index.

# import pandas as pd

import pandas as pd


# Create Index

idx = pd .Index ([ 21 , 10 , 30 , 40 , 50 , 10 , 50 ])


# Print index

print (idx)

Output:

Let’s count the occurrence of all unique values ‚Äã‚Äãin the index.

# to count all
# unique values in the index.
idx.value_counts ()

Output:

The function returned a counter of all unique values in the index.

Shop

Gifts for programmers

Best Python online courses for 2022

$FREE
Gifts for programmers

Best laptop for Excel

$
Gifts for programmers

Best laptop for Solidworks

$399+
Gifts for programmers

Best laptop for Roblox

$399+
Gifts for programmers

Best computer for crypto mining

$499+
Gifts for programmers

Best laptop for Sims 4

$
Gifts for programmers

Best laptop for Zoom

$499
Gifts for programmers

Best laptop for Minecraft

$590

Latest questions

PythonStackOverflow

Common xlabel/ylabel for matplotlib subplots

1947 answers

PythonStackOverflow

Check if one list is a subset of another in Python

1173 answers

PythonStackOverflow

How to specify multiple return types using type-hints

1002 answers

PythonStackOverflow

Printing words vertically in Python

909 answers

PythonStackOverflow

Python Extract words from a given string

798 answers

PythonStackOverflow

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

606 answers

PythonStackOverflow

Python os.path.join () method

384 answers

PythonStackOverflow

Flake8: Ignore specific warning for entire file

360 answers

News


Wiki

Python | How to copy data from one Excel sheet to another

Common xlabel/ylabel for matplotlib subplots

Check if one list is a subset of another in Python

How to specify multiple return types using type-hints

Printing words vertically in Python

Python Extract words from a given string

Cyclic redundancy check in Python

Finding mean, median, mode in Python without libraries

Python add suffix / add prefix to strings in a list

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

Python - Move item to the end of the list

Python - Print list vertically