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; } } }

Iterating through a dictionary

JoeBorgione · 2019-05-06T21:33:26+00:00

I have a dictionary in the form of: year2018 = { 'jan18' : ( 1 , <SPAN…

JoeBorgione

I have a dictionary in the form of:

year2018 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'jan18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'feb18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'mar18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'apr18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
            <SPAN class="string token">'may18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'jun18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'jul18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'aug18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
            <SPAN class="string token">'sept18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'oct18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'nov18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'dec18'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">12</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2018</SPAN><SPAN class="punctuation token">)</SPAN>
            <SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I have a data table where each record has Month field and a Year field. I would like to iterate through my dictionary so that while key = jan18, I select records from my table where Month = 1 and Year = 2018, and then export those records to a stand-alone table called jan18: then move on to key = feb18, etc etc. I've tried a couple different approaches, but still not quite getting what I want. Any suggestions are appreciated. (Using a dictionary is cool, but I'm open to all suggestions...)

Find more posts tagged with

Accepted answers

DanPatterson_Retired

you ruled out Split By Attributes—Help | ArcGIS Desktop ?

might require adding a temporary field to concatenate your month and year if your data aren't set up for a straight split as is

All comments

bixb0012

Then use Table Select—Help | ArcGIS Desktop instead.

JoeBorgione

I've never used this tool before: it's my new favorite. It's fun to write python and do all sorts of elaborate gyrations, but hey, this is slick!

RandyBurton

You can iterate through a dictionary, but some simple loops are easy. Just ideas..

months = {1:'jan',2:'feb',3:'mar',4:'apr',5:'may',6:'jun',7:'jul',8:'aug',9:'sep',10:'oct',11:'nov',12:'dec'}
for yr in range(2018,2019): # stop when 2019 is reached
    for mo in months:
        print yr, mo, months[mo]
        print "Month = {} AND Year = {}".format(mo,yr)
        print "{}_{}".format(months[mo], yr)

''' prints:
2018 1 jan
Month = 1 AND Year = 2018
jan_2018
... etc.
'''
for yr in range(2018, 2019): # stop when 2019 is reached
    for mo in range(1,13): # stop when 2019 is reached
        print yr, mo

''' prints
2018 1
2018 2
...
2018 11
2018 12
'''<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>

DanPatterson_Retired

you ruled out Split By Attributes—Help | ArcGIS Desktop ?

might require adding a temporary field to concatenate your month and year if your data aren't set up for a straight split as is

JoeBorgione

Thanks- I'm working on a table, not a feature class so I don't think Select_Analysis() will work. However, If I make a table view first, and run my selections on it, this should give me what I'm after....

Yuriko

Hi Joe, I'm not sure what you've attempted but dictionaries are indeed cool. I haven't tested this but give this a whirl:

for key, value in year2018.items(): # Iterate through each key,value pair in the dictionary
    in_features = in_feature_class # Identify the input feature class
    out_feature_class = out_path + "_" + key # Identify the filepath output appending the key to identify it
    where_clause = "Month = '" + str(value[0]) + "' AND Year = '" + str(value[1]) + "'"
    arcpy.Select_analysis(in_features, out_feature_class, where_clause)

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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