Change language

Absolute and relative frequency in pandas

1. Absolute frequency:
This is the number of observations in a particular category. It always has an integer value, or we can say that it has discrete values.

Example :

Following data are given about pass or fail of students in an exam held of Mathematics in a class.
P, P, F, P, F, P, P, F, F, P, P, P

where, P = Passed and F = Failed.

Solution:
From the given data we can say that,
There are 8 students who passed the exam
There are 4 students who failed the exam

Implementation in Python:
Let the result be 12 people declared in two categories Pass (P) and Fail (F), classified as 1 and 0 respectively.

 P, P, F, P, F, P, P, F, F, P, P, P 1 , 1, 0, 1, 0, 1, 1, 0, 0, 1, 1, 1 

import pandas as pd

  

data = [ 1 , 1 , 0 , 1 , 0 , 1 , 1 , 0 , 0 , 1 , 1 , 1 ]

 
# Create a data frame with using the pandas library
# .value_counts () counts the number 
# specific observation cases

 

df = pd.Series (data) .value_counts ()

print (df)

Exit :

 1 8 0 4 dtype: int64 

2. Relative frequency:
This is the proportion of observations of a specific category in this dataset. It has floating values ​​and is also represented as a percentage. Consider the following example of passed and failed students on a math exam. Then,

relative frequency of passed students = 8 / (8 + 4) = 0.666 = 66.6%
relative frequency of failed students = 4 / (8 + 4) = 0.333 = 33.3%

import pandas as pd

 

data = [ 1 , 1 , 0 , 1 , 0 , 1 , 1 , 0 , 0  , 1 , 1 , 1 ]

 
# Create a data frame using the pandas library
# .value_counts () counts the number
# specific observation cases

 

df = pd.Series (data) .value_counts () 

print (df / len (data))

Exit:

 1 0.666667 0 0.333333 dtype: float64 

Shop

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 laptop for development

$499+
Gifts for programmers

Best laptop for Cricut Maker

$299+
Gifts for programmers

Best laptop for hacking

$890
Gifts for programmers

Best laptop for Machine Learning

$699+
Gifts for programmers

Raspberry Pi robot kit

$150

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