Mean(), Median(), Mode(): Finding Measures Of Central Tendency In A Pandas Dataframe

Overview:

  • In a distribution, measures of central tendency identify where the data is centered. Mean, Median and the Mode are commonly used measures of central tendency.
  • The mean() and median() methods return the mean and median of values for a given axis in a pandas DataFrame instance.
  • Median is the middle value of the dataset which divides it into upper half and a lower half.
  • Mode is the most frequently occuring value in a dataset or distribution. A dataset can have more than one mode
  • Similar to the measures of central tendency quantile is also a measure of location. In a dataset, it identifies a location at or below which a given portion of data lies.

Example:

import pandas as pd

 

dataMatrix = {"D1":[135, 137, 136, 138, 138],

              "D2":[43,   42, 42, 42, 42],

              "D3":[72, 73, 72, 72, 73],

              "D4":[100, 102, 100, 103, 104]

             };

       

dataFrame = pd.DataFrame(data=dataMatrix);

 

print("DataFrame:");

print(dataFrame);

 

print("Mean:Computed column-wise:");

meanData = dataFrame.mean();

print(meanData);

 

print("Mean:Computed row-wise:");

meanData = dataFrame.mean(axis=1);

print(meanData);

 

print("Median:Computed column-wise:");

medianData = dataFrame.median();

print(medianData);

 

print("Median:Computed row-wise:");

medianData = dataFrame.median(axis=1);

print(medianData);

 

print("Mode:Computed column-wise:");

modeData = dataFrame.mode();

print(modeData);

 

print("Mode:Computed row-wise:");

modeData = dataFrame.mode(axis=1);

print(modeData);

 

Output:

DataFrame:

    D1  D2  D3   D4

0  135  43  72  100

1  137  42  73  102

2  136  42  72  100

3  138  42  72  103

4  138  42  73  104

Mean:Computed column-wise:

D1    136.8

D2     42.2

D3     72.4

D4    101.8

dtype: float64

Mean:Computed row-wise:

0    87.50

1    88.50

2    87.50

3    88.75

4    89.25

dtype: float64

Median:Computed column-wise:

D1    137.0

D2     42.0

D3     72.0

D4    102.0

dtype: float64

Median:Computed row-wise:

0    86.0

1    87.5

2    86.0

3    87.5

4    88.5

dtype: float64

Mode:Computed column-wise:

    D1  D2  D3   D4

0  138  42  72  100

Mode:Computed row-wise:

    0   1    2    3

0  43  72  100  135

1  42  73  102  137

2  42  72  100  136

3  42  72  103  138

4  42  73  104  138


Copyright 2023 © pythontic.com