How to drop rows of Pandas DataFrame whose value in certain coulmns is NaN

Question

I have a DataFrame:I want to remove this NaN value row without dropping it?

Answer 1

Hi@DataKing99,

You can create one function according to your requirement. Here I am sharing one example based on your dataset.

def fun(price):
    val = price
    if pd.isnull(val):
        return ""
    else:
        return val
data['Price'] = data['Price'].apply(fun)

You will get the below output.

Distance	Price
0	2	20
1	4	40
2	7
3	9	90
4	10

You can return any value to replace your NAN according to your requirement.