JIYIK CN >

Python Pandas DataFrame.median() function calculates the median of the elements of the DataFrame object along the specified axis.

The median is not the average, but the middle value of a list of numbers.

pandas.DataFrame.median()grammar

DataFrame.median(axis=None, skipna=None, level=None, numeric_only=None, **kwargs)

parameter

Return Value

If not specified level, returns the median along the requested axis Series, otherwise returns the median DataFrame.

Example Code: DataFrame.median()Method to find the median along the column axis

import pandas as pd

df = pd.DataFrame({'X': [1, 2, 7, 5, 10],
                   'Y': [4, 3, 8, 2, 9]})
print("DataFrame:")
print(df)

medians=df.median()
print("medians of Each Column:")
print(medians)

Output:

DataFrame:
    X  Y
0   1  4
1   2  3
2   7  8
3   5  2
4  10  9
medians of Each Column:
X    5.0
Y    4.0
dtype: float64

Computes the median of two columns, Xand Y, and returns a object containing the median of each column Series.

In Pandas, to find the median of a column in a DataFrame, we just call median()the median function on that column.

import pandas as pd

df = pd.DataFrame({'X': [1, 2, 7, 5, 10],
                   'Y': [4, 3, 8, 2, 9]})
print("DataFrame:")
print(df)

medians=df["X"].median()
print("medians of Each Column:")
print(medians)

Output:

DataFrame:
    X  Y
0   1  4
1   2  3
2   7  8
3   5  2
4  10  9
medians of Each Column:
5.0

It just gives the median of the columns DataFramein .X

Example Code: DataFrame.median()Method to find the median along the row axis

import pandas as pd

df = pd.DataFrame({'X': [1, 2, 7, 5, 10],
                   'Y': [4, 3, 8, 2, 9],
                   'Z': [2, 7, 6, 10, 5]})
print("DataFrame:")
print(df)

medians=df.median(axis=1)
print("medians of Each Row:")
print(medians)

Output:

DataFrame:
    X  Y   Z
0   1  4   2
1   2  3   7
2   7  8   6
3   5  2  10
4  10  9   5
medians of Each Row:
0    2.0
1    3.0
2    7.0
3    5.0
4    9.0
dtype: float64

It calculates the median of all rows and returns a Seriesobject containing the median for each row.

In Pandas, to find DataFramethe median of a row in , we just call median()the function to calculate the median of that row.

import pandas as pd

df = pd.DataFrame({'X': [1, 2, 7, 5, 10],
                   'Y': [4, 3, 8, 2, 9],
                   'Z': [2, 7, 6, 10, 5]})

print("DataFrame:")
print(df)

median=df.iloc[[0]].median(axis=1)
print("median of 1st Row:")
print(median)

Output:

DataFrame:
    X  Y   Z
0   1  4   2
1   2  3   7
2   7  8   6
3   5  2  10
4  10  9   5
median of 1st Row:
0    2.0
dtype: float64

It only gives DataFramethe median of the first row of values ​​in .

We use ilocthe method to select a row based on its index.

Example Code: DataFrame.median()Method Ignoring NaNValues ​​to Find the Median

We use skipnathe default value of the parameter, that is , find the median of along the specified axis skipna=Trueby ignoring the value of .NaNDataFrame

import pandas as pd

df = pd.DataFrame({'X': [1, 2, 7, None, 10, 8],
                   'Y': [None, 3, 8, 2, 9, 6],
                   'Z': [2, 7, 6, 10, None, 5]})

print("DataFrame:")
print(df)

median=df.median(skipna=True)
print("medians of Each Row:")
print(median)

Output:

DataFrame:
      X    Y     Z
0   1.0  NaN   2.0
1   2.0  3.0   7.0
2   7.0  8.0   6.0
3   NaN  2.0  10.0
4  10.0  9.0   NaN
5   8.0  6.0   5.0
medians of Each Row:
X    7.0
Y    6.0
Z    6.0
dtype: float64

If we set skipna=True, it ignores the in DataFrame NaN. It allows us NaNto calculate DataFramethe median along the column axis by ignoring the values.

import pandas as pd

df = pd.DataFrame({'X': [1, 2, 7, None, 10],
                   'Y': [5, 3, 8, 2, 9],
                   'Z': [2, 7, 6, 10, 4]})

print("DataFrame:")
print(df)

median=df.median(skipna=False)
print("medians of Each Row:")
print(median)

Output:

DataFrame:
      X  Y   Z
0   1.0  5   2
1   2.0  3   7
2   7.0  8   6
3   NaN  2  10
4  10.0  9   4
medians of Each Row:
X    NaN
Y    5.0
Z    6.0
dtype: float64

Here, we get NaNthe value as Xthe median of the column because Xthere are values ​​in the column NaN.