How to find the percentage of missing value in a column?

python

#1

I have an excel data set which has a column Customer_Value . I want to find the percentage of missing values for that particular column. How to achieve that?


#2

Hi @niranjan_283

You can first count the number of missing values and then divide it by the total number of values in the column.

To find the number of missing values, you can use :
data['Customer_value'].isnull().sum()

Divide the value you get from the above code line by the total number of values in the column ( which is basically the number of rows)


#3

Thanks @AishwaryaSingh