Hi,
Could you explain me, how to change field value with dictionaries?
for example :
dict = {"A" : "A-150",
"B" : "B-200",
"C" : "C-250"}
And i want change A with A-150, B with B-200
Thanks !
you still need the def example and you call it
if i is None:
<SPAN> row<N> = "NULL"</N></SPAN>
<SPAN>else:</SPAN>
<SPAN> row<N> = get_val</N></SPAN><SPAN>(</SPAN>i<SPAN>) # get)val is the def and it needs your dictionary</SPAN>
It has to be a piece of that script. You see like this part(code) if any row hasn`t a value, in CSV will write Null.
<SPAN class="keyword token">for</SPAN> n<SPAN class="punctuation token">,</SPAN>i <SPAN class="keyword token">in</SPAN> enumerate<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="keyword token">if</SPAN> i<SPAN class="operator token">==</SPAN>None<SPAN class="punctuation token">:</SPAN> row<SPAN class="punctuation token">[</SPAN>n<SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN><SPAN class="string token">"NULL"</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>
So I think I need only a couple lines of code to reach a goal.
Now I have this:
well it is clear now that you want to do this in a script, I thought you were wanting to do this in the field calculator. That is the part that wasn't clear.
You need to use the function (ie def ) with your dictionary to make the change within your tabletocsv function but I am not sure what it is doing there. Does this work without the conversion or is it an attempt to piece a script together?
Any ideas ?
Sorry, yeah I mean rows ... So like I said, I have 2000 rows and ~ 25 columns. One column is Values. So what expression would be the best ? Values column should have A-150, B-200, C-250 values. Not A,B,C. And I dont know solution for that...
2000 fields? Do you mean 2000 rows? Your statement "2000 Fields in Values Column" is confusing since field and column describes the same aspect of a table.
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">get_val</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">""" get a dictionary value"""</SPAN> dict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"A"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"A-150"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"B"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"B-200"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"C"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"C-250"</SPAN><SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">return</SPAN> dict<SPAN class="punctuation token">[</SPAN>val<SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># python parser</SPAN> <SPAN class="comment token"># field calculator code</SPAN> <SPAN class="comment token"># field calculator expression for a text field</SPAN> get_val<SPAN class="punctuation token">(</SPAN>!YourFieldNameHere!<SPAN class="punctuation token">)</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>
I know this, but what statement should be, if I have 2000 Fields in Values Column ? Every field in this column has A, B or C value. How to change values with dict in all 2000 fields ?
Or set it to anything.
dict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"A"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Anything you want it to be"</SPAN> <SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN></SPAN>
Are you trying to retrieve the value?
dict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"A"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"A-150"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"B"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"B-200"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"C"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"C-250"</SPAN><SPAN class="punctuation token">}</SPAN> dict<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># get its value</SPAN> <SPAN class="string token">'A-150'</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
