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

For Loop not looping correctly, ArcPy

MattAzemar

I have four markets 1-4, but I only want to do markets 2 and 3. I created a markets list only containing those two markets so that I could use the list in a "for" loop. However, when I try and run it, it still runs through all the markets. I think this has to do with my "whereclause" or "sqlclause" or both, but I can't figure out how to fix it. I've tried using a wildcard in the "whereclause" but that doesn't work. I've also tried getting rid of the "whereclause" but that also doesn't work. Could someone help me with this?

fc <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Centers'</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'market_id'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Center_ID'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Center_Name'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Opening_Date'</SPAN><SPAN class="punctuation token">]</SPAN>
fieldname <SPAN class="operator token">=</SPAN> <SPAN class="string token">'market_id'</SPAN>

<SPAN class="comment token">#Define WHERE clause statement</SPAN>
<SPAN class="comment token">#whereclause = """{} = '%000' """.format(arcpy.AddFieldDelimiters(fc, fieldname))</SPAN>

sqlclause <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Order By market_id, Center_ID'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Set Markets to loop through</SPAN>
markets <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token"># Set Years to loop through</SPAN>
years <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">2016</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2017</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token"># Set Months to loop through</SPAN>
months <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token">#returns last day of each month</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">last_day_of_month</SPAN><SPAN class="punctuation token">(</SPAN>any_day<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; next_month <SPAN class="operator token">=</SPAN> any_day<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN>day<SPAN class="operator token">=</SPAN><SPAN class="number token">28</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> datetime<SPAN class="punctuation token">.</SPAN>timedelta<SPAN class="punctuation token">(</SPAN>days<SPAN class="operator token">=</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> next_month <SPAN class="operator token">-</SPAN> datetime<SPAN class="punctuation token">.</SPAN>timedelta<SPAN class="punctuation token">(</SPAN>days<SPAN class="operator token">=</SPAN>next_month<SPAN class="punctuation token">.</SPAN>day<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> market <SPAN class="keyword token">in</SPAN> markets<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; sqlclause <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Order By market_id, Center_ID'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>market<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> year <SPAN class="keyword token">in</SPAN> years<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> month <SPAN class="keyword token">in</SPAN> months<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>month<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_table <SPAN class="operator token">=</SPAN> fc<SPAN class="punctuation token">,</SPAN> field_names <SPAN class="operator token">=</SPAN> fields<SPAN class="punctuation token">,</SPAN> where_clause<SPAN class="operator token">=</SPAN>whereclause<SPAN class="punctuation token">,</SPAN> sql_clause<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ORDER BY market_id, Center_ID'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<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>‍</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

MattAzemar

The quick and easy way to fix the issue I posted earlier was to fix my where clause. It was an invalid SQL statement so by altering it to what is below, I was able to fix the issue.

whereclause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""{} IN (2, 3) """</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fieldname<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

I was also able to further optimize my code and make it more streamline by using some of xander_bakker‌'s suggestions. Thanks for your help Xander.

All comments

MattAzemar

The quick and easy way to fix the issue I posted earlier was to fix my where clause. It was an invalid SQL statement so by altering it to what is below, I was able to fix the issue.

whereclause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""{} IN (2, 3) """</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fieldname<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

I was also able to further optimize my code and make it more streamline by using some of xander_bakker‌'s suggestions. Thanks for your help Xander.

MattAzemar

Hey Xander thanks for the response and advice. Your assumptions were correct and my data is stored in a geodatabase. I'll give your suggestions a try and let you know how it goes!

XanderBakker

Example of a query for a specified month if the data is stored in a File Geodatabase:

<SPAN class="keyword token">from</SPAN> calendar <SPAN class="keyword token">import</SPAN> monthrange<SPAN class="punctuation token">,</SPAN> datetime

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> queryDefDateBetweenForGivenMonth<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2017</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Opening_Date"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">queryDefDateBetweenForGivenMonth</SPAN><SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">,</SPAN> date_field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; start_date <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; end_date <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">,</SPAN> monthrange<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">23</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">59</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">59</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"{0} BETWEEN date '{1}' AND date '{2}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>date_field<SPAN class="punctuation token">,</SPAN> start_date<SPAN class="punctuation token">,</SPAN> end_date<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; main<SPAN class="punctuation token">(</SPAN><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>‍</SPAN><SPAN>‍</SPAN></SPAN>

This will yield:

Opening_Date BETWEEN date '2017-09-01 00:00:00' AND date '2017-09-30 23:59:59'<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

You should include the market_id too to limit the results to what you want.:

<SPAN class="keyword token">from</SPAN> calendar <SPAN class="keyword token">import</SPAN> monthrange<SPAN class="punctuation token">,</SPAN> datetime

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp; fld_date <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Opening_Date"</SPAN>
&nbsp;&nbsp;&nbsp; fld_market_id <SPAN class="operator token">=</SPAN> <SPAN class="string token">"market_id"</SPAN>

&nbsp;&nbsp;&nbsp; markets <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; years <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">2016</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2017</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; months <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> market <SPAN class="keyword token">in</SPAN> markets<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> year <SPAN class="keyword token">in</SPAN> years<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> month <SPAN class="keyword token">in</SPAN> months<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date_query <SPAN class="operator token">=</SPAN> queryDefDateBetweenForGivenMonth<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">,</SPAN> fld_date<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; whereclause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{0} = {1} AND ({2})"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>fld_market_id<SPAN class="punctuation token">,</SPAN> market<SPAN class="punctuation token">,</SPAN> date_query<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> whereclause


<SPAN class="keyword token">def</SPAN> <SPAN class="token function">queryDefDateBetweenForGivenMonth</SPAN><SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">,</SPAN> date_field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; start_date <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; end_date <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">,</SPAN> monthrange<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">23</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">59</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">59</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"{0} BETWEEN date '{1}' AND date '{2}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>date_field<SPAN class="punctuation token">,</SPAN> start_date<SPAN class="punctuation token">,</SPAN> end_date<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; main<SPAN class="punctuation token">(</SPAN><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>‍</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>

Which will yield:

market_id = 2 AND (Opening_Date BETWEEN date '2016-01-01 00:00:00' AND date '2016-01-31 23:59:59')
market_id = 2 AND (Opening_Date BETWEEN date '2016-02-01 00:00:00' AND date '2016-02-29 23:59:59')
market_id = 2 AND (Opening_Date BETWEEN date '2017-01-01 00:00:00' AND date '2017-01-31 23:59:59')
market_id = 2 AND (Opening_Date BETWEEN date '2017-02-01 00:00:00' AND date '2017-02-28 23:59:59')
market_id = 3 AND (Opening_Date BETWEEN date '2016-01-01 00:00:00' AND date '2016-01-31 23:59:59')
market_id = 3 AND (Opening_Date BETWEEN date '2016-02-01 00:00:00' AND date '2016-02-29 23:59:59')
market_id = 3 AND (Opening_Date BETWEEN date '2017-01-01 00:00:00' AND date '2017-01-31 23:59:59')
market_id = 3 AND (Opening_Date BETWEEN date '2017-02-01 00:00:00' AND date '2017-02-28 23:59:59')<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

XanderBakker

Although I'm not sure what you will do inside the SearchCursor, I assume that you want to query those records that correspond to the defined market_id, year and month and therefor you have the function to get the last day of the month (to define the date range to be included in the query).

The query on dates may depend on the data source you are using. What type of workspace is the data stored in?

I also think that using the calendar might be a better way of obtaining the last day (or moment) of a given month in a given year. This could look something like this:

<SPAN class="keyword token">from</SPAN> calendar <SPAN class="keyword token">import</SPAN> monthrange<SPAN class="punctuation token">,</SPAN> datetime

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; years <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">2016</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2017</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; months <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> year <SPAN class="keyword token">in</SPAN> years<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> month <SPAN class="keyword token">in</SPAN> months<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">,</SPAN> last_day_of_month<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">last_day_of_month</SPAN><SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; last_day <SPAN class="operator token">=</SPAN> monthrange<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">,</SPAN> last_day<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">23</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">59</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">59</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; main<SPAN class="punctuation token">(</SPAN><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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Inside your loop, you will have to include the market_id, and date range. Optionally you can use a sql clause to sort the result. No need to sort on market id, since each iteration will only include 1.

Ú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.