CODEWITHSUNDEEP
pythonconditional-statementsmissing-datafillna
Hassan Ahmed
Hassan Ahmed

Reputation: 3

Filling Null Values in Pandas

How to fill missing values based on conditions meeting from other columns such as I want to fill only mull values of Product Container Column based on the Product Category column if it is "Office supplies" in Product Category it will be a "Small Box" and there are some other conditions as well?

cnt=0
for row in salesdirty["Product_Category"]:
    if salesdirty.loc[cnt,"Product_container"]==pd.isnull(salesdirty["Product_container"]):
        if salesdirty.loc[cnt,"Product_Category"]=="Office Supplies":
            salesdirty.loc[cnt,"Product_container"]="Small Box"
    cnt+=1

Upvotes: 0

Views: 73

Answers (1)

fsl
fsl

Reputation: 3280

You could use Boolean indexing to filter the conditions, then do whatever you want with it:

mask = (salesdirty["Product_container"].isnull()) & (salesdirty["Product_Category"]=="Office Supplies")

# Assign new values
salesdirty["Product_Category"][mask] = "Small Box"

# Count conditions' occurences
cnt = len(mask[mask])

Upvotes: 1

Related Questions