TypeError: 'NoneType' object is not subscriptable when checking for nonetype

Question

I am trying to detect Nonetype in a single cell of a 1 column, 15 row dataframe with the following:

if str(row.iloc[13][:]) is None:
     print("YES")

But this causes the error: TypeError: 'NoneType' object is not subscriptable

Why not if row.iloc[13] is None: ? Also can you explain more, what need? — jezrael
– jezrael, Commented Apr 6, 2020 at 6:59

jezrael · Accepted Answer · 2020-04-06 07:05:23Z

1

If row is Series, then if select value by position:

row.iloc[13]

output is scalar. So cannot slice scalar value by [:]. Also if convert to string by str cannot compare by None, but by string like:

if str(row.iloc[13]) == 'None':

If want compare by None:

if row.iloc[13] is None:

Or if compare by NaN or None:

if pd.isna(row.iloc[13]):

answered Apr 6, 2020 at 7:05

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1