Condition if column from table is empty is not working?

up vote
1
down vote

favorite

I want to make a loop where if a column is empty in a row to do something else. The problem is that it can't determine the empty row. I tried as null, na , '',' ' and with double quotes and nothing.

for i in t_list:
 with arcpy.da.SearchCursor(i, ["name","num"]) as cur:
 for row in cur:
 if row[1] is not "''":
 print(row)

Gives:

nog1, num = '1'
nog2, ''

And it returns even the the empty rows

edited 1 hour ago

PolyGeoâ™¦

52.2k1779236

asked 1 hour ago

user51332

New contributor

add a commentÂ |Â

up vote
1
down vote

favorite

I want to make a loop where if a column is empty in a row to do something else. The problem is that it can't determine the empty row. I tried as null, na , '',' ' and with double quotes and nothing.

for i in t_list:
 with arcpy.da.SearchCursor(i, ["name","num"]) as cur:
 for row in cur:
 if row[1] is not "''":
 print(row)

Gives:

nog1, num = '1'
nog2, ''

And it returns even the the empty rows

edited 1 hour ago

PolyGeoâ™¦

52.2k1779236

asked 1 hour ago

user51332

New contributor

add a commentÂ |Â

up vote
1
down vote

favorite

I want to make a loop where if a column is empty in a row to do something else. The problem is that it can't determine the empty row. I tried as null, na , '',' ' and with double quotes and nothing.

for i in t_list:
 with arcpy.da.SearchCursor(i, ["name","num"]) as cur:
 for row in cur:
 if row[1] is not "''":
 print(row)

Gives:

nog1, num = '1'
nog2, ''

And it returns even the the empty rows

edited 1 hour ago

PolyGeoâ™¦

52.2k1779236

asked 1 hour ago

user51332

New contributor

I want to make a loop where if a column is empty in a row to do something else. The problem is that it can't determine the empty row. I tried as null, na , '',' ' and with double quotes and nothing.

for i in t_list:
 with arcpy.da.SearchCursor(i, ["name","num"]) as cur:
 for row in cur:
 if row[1] is not "''":
 print(row)

Gives:

nog1, num = '1'
nog2, ''

And it returns even the the empty rows

arcpy cursor null

edited 1 hour ago

PolyGeoâ™¦

52.2k1779236

asked 1 hour ago

user51332

New contributor

edited 1 hour ago

PolyGeoâ™¦

52.2k1779236

asked 1 hour ago

user51332

New contributor

edited 1 hour ago

PolyGeoâ™¦

52.2k1779236

edited 1 hour ago

PolyGeoâ™¦

52.2k1779236

edited 1 hour ago

PolyGeoâ™¦

52.2k1779236

asked 1 hour ago

user51332

New contributor

asked 1 hour ago

user51332

asked 1 hour ago

user51332

New contributor

user51332 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a commentÂ |Â

1 Answer
1

active

oldest

votes

up vote
3
down vote

accepted

To check for not na/none use:

if row[1] is not None

To check for both None and empty string use:

if row[1] not in ('', None)

edited 1 hour ago

answered 1 hour ago

BERA

12.6k51737

add a commentÂ |Â

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

user51332 is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f300302%2fcondition-if-column-from-table-is-empty-is-not-working%23new-answer', 'question_page');

);

Post as a guest

Name

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
3
down vote

accepted

To check for not na/none use:

if row[1] is not None

To check for both None and empty string use:

if row[1] not in ('', None)

edited 1 hour ago

answered 1 hour ago

BERA

12.6k51737

add a commentÂ |Â

up vote
3
down vote

accepted

To check for not na/none use:

if row[1] is not None

To check for both None and empty string use:

if row[1] not in ('', None)

edited 1 hour ago

answered 1 hour ago

BERA

12.6k51737

add a commentÂ |Â

up vote
3
down vote

accepted

To check for not na/none use:

if row[1] is not None

To check for both None and empty string use:

if row[1] not in ('', None)

edited 1 hour ago

answered 1 hour ago

BERA

12.6k51737

To check for not na/none use:

if row[1] is not None

To check for both None and empty string use:

if row[1] not in ('', None)

edited 1 hour ago

answered 1 hour ago

BERA

12.6k51737

edited 1 hour ago

answered 1 hour ago

BERA

12.6k51737

answered 1 hour ago

BERA

12.6k51737

answered 1 hour ago

BERA

12.6k51737

add a commentÂ |Â

user51332 is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

user51332 is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Post as a guest

Name

Search This Blog

Iyfjky