I can't get this to work. I want it to return "No Data" if the field PROP_CLASS is empty (see line 32). As things stand it returns "Other." It works otherwise. Any ideas? def CATEGORY ( prop_class ) : if '200' prop_class '283' : return "Residential" elif '310' prop_class '312' : return "Residential" elif prop_class == '322' : return "Residential" elif '410' prop_class '413' : return "Residential" elif prop_class == '416' : return "Residential" elif prop_class == '693' : return "Residential" elif prop_class == '300' : return "Public/Vacant" elif '313' prop_class '321' : return "Public/Vacant" elif '323' prop_class '380' : return "Public/Vacant" elif prop_class == '531' : return "Public/Vacant" elif prop_class == '552' : return "Public/Vacant" elif prop_class == '560' : return "Public/Vacant" elif '590' prop_class '593' : return "Public/Vacant" elif prop_class == '695' : return "Public/Vacant" elif '900' prop_class '994' : return "Public/Vacant" elif prop_class is None : return "No Data" else : return "Other"

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Help debug this Python field calculator script

MichaelLenore1

I can't get this to work. I want it to return "No Data" if the field PROP_CLASS is empty (see line 32). As things stand it returns "Other." It works otherwise. Any ideas?

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">CATEGORY</SPAN><SPAN class="punctuation token">(</SPAN>prop_class<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="string token">'200'</SPAN> <SPAN class="operator token"><=</SPAN> prop_class <SPAN class="operator token"><=</SPAN> <SPAN class="string token">'283'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Residential"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> <SPAN class="string token">'310'</SPAN> <SPAN class="operator token"><=</SPAN> prop_class <SPAN class="operator token"><=</SPAN><SPAN class="string token">'312'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Residential"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> prop_class <SPAN class="operator token">==</SPAN> <SPAN class="string token">'322'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Residential"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> <SPAN class="string token">'410'</SPAN> <SPAN class="operator token"><=</SPAN> prop_class <SPAN class="operator token"><=</SPAN> <SPAN class="string token">'413'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Residential"</SPAN> 
&nbsp; <SPAN class="keyword token">elif</SPAN> prop_class <SPAN class="operator token">==</SPAN> <SPAN class="string token">'416'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Residential"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> prop_class <SPAN class="operator token">==</SPAN> <SPAN class="string token">'693'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Residential"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> prop_class <SPAN class="operator token">==</SPAN> <SPAN class="string token">'300'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Public/Vacant"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN>&nbsp; <SPAN class="string token">'313'</SPAN> <SPAN class="operator token"><=</SPAN> prop_class <SPAN class="operator token"><=</SPAN> <SPAN class="string token">'321'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Public/Vacant"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN>&nbsp; <SPAN class="string token">'323'</SPAN> <SPAN class="operator token"><=</SPAN> prop_class <SPAN class="operator token"><=</SPAN> <SPAN class="string token">'380'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Public/Vacant"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> prop_class <SPAN class="operator token">==</SPAN> <SPAN class="string token">'531'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Public/Vacant"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> prop_class <SPAN class="operator token">==</SPAN> <SPAN class="string token">'552'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Public/Vacant"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> prop_class <SPAN class="operator token">==</SPAN> <SPAN class="string token">'560'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Public/Vacant"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> <SPAN class="string token">'590'</SPAN> <SPAN class="operator token"><=</SPAN> prop_class <SPAN class="operator token"><=</SPAN> <SPAN class="string token">'593'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Public/Vacant"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> prop_class <SPAN class="operator token">==</SPAN> <SPAN class="string token">'695'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Public/Vacant"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN>&nbsp; <SPAN class="string token">'900'</SPAN> <SPAN class="operator token"><=</SPAN> prop_class <SPAN class="operator token"><=</SPAN> <SPAN class="string token">'994'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Public/Vacant"</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> prop_class <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"No Data"</SPAN>
&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Other"</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Encuentra más publicaciones etiquetadas con

Accepted answers

bixb0012

An empty string is '', not None. None is what is returned when a field is NULL.

All comments

MichaelLenore1

Aha. Thought I'd tried ==' ' but I guess I hadn't - that did the trick. thanks!

bixb0012

An empty string is '', not None. None is what is returned when a field is NULL.

MichaelLenore1

Empty string. Now returns "Other."

bixb0012

When you say "empty," do you mean NULL or an empty string? If "No data" isn't being returned now, what is?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.