If statement on a specific cell in an Excel data

Question

I am trying to run a specific line of script based on a cell value in an excel data frame. I basically want to conduct the calculation if a specific cell is not empty. For this, I used the code below:

check=df.iat[1,13]  #I am reading the value of the cell

if check is not (None, "[nan]"):
    print("cell is not empty")

when I print the value of check (the cell value), I get 'nan'. However, the if statement is not working as nothing is printed.

I am not sure why is this happening and I will appreciate any hints. Thanks!

https://stackoverflow.com/questions/47440077/checking-if-particular-value-in-cell-is-nan-in-pandas-dataframe-not-working-us — Jérôme, Oct 18 '21 at 14:00
cheers Vinzent, this actually works! I was not aware of the .insa, very helpful! — Kimchi, Oct 18 '21 at 14:03
could you please answer this question and I will accept the solution — Kimchi, Oct 19 '21 at 22:15

Kimchi · Accepted Answer · 2021-10-22T10:08:20.860

0

Answer provided by Vinzent

check=df.iat[1,13]  #I am reading the value of the cell
if not pd.isna(check):
    print("cell is not empty")

edited Oct 22 '21 at 10:08

answered Oct 18 '21 at 14:05

Kimchi

97
6

2

Is this not Vinzent answer? You could ask him/her to write the answer and you would accept it. – Prayson W. Daniel Oct 19 '21 at 07:58

If statement on a specific cell in an Excel data

1 Answers1