Python help please

Question

If i have 2 columns, 'a' and 'b'. 'a' has random values and 'b' has some missing values. If i want to impute missing values of 'b' with 0 if that row has 'a' value 0, then how can I achieve that in python

Answer 1

What is the variable type? DataFrame? Array? or are those just two lists?

In any way, you should iterate through with index and assign b[index] = 0 if a[index] == 0

Or at least this is how I understood your question.

Answer 2

Kuba Siekierzyński Thank you so much. So kind of you. I really appreciate.

Answer 3

fillna will affect everything.

Try the following, instead:
df.loc[df['a']==0, 'b'] = 0
https://code.sololearn.com/cUu3pQq9LdME/?ref=app

Answer 4

A and B are columns of a dataframe

Answer 5

Thank you Kiibo for replying

Answer 6

Thank you Kuba

Answer 7

𝐊𝐢𝐢𝐛𝐨 𝐆𝐡𝐚𝐲𝐚𝐥 I tried like this
if df['a'] ==0:
df['b'].fillna(0,inplace=True)

Answer 8

Kuba Siekierzyński a and b are columns of a same dataframe df