For loop with Python - using ints instead of datetime

Question

I have a datascience task that requires getting historical weather data. I have looked at wunderground.com but their API example is structured like so:

http://api.wunderground.com/api/d23ac65706dbf6dd/history_YYYYMMDD/q/CA/San_Francisco.json

Therefore, when attempting to build a dataset I need to get from the first day of the year to the last day of the year, but can't do that with:

The only thing that I can come up with is:

for m in range(1, 13):
    for d in range(1, 32):
         r = requests.get("http://api.wunderground.com/api/0def10027afaebb7/history_2014'+str(m)+'/'+str(d)+'/q/Mexico/Mexico_City.json")
        data = r.json()

But that obviously won't work. How would you go about this in Python?

See also: stackoverflow.com/q/1060279/3001761

jonrsharpe
– jonrsharpe

2015-05-15 07:42:54 +00:00
Commented May 15, 2015 at 7:42 — jonrsharpe
– jonrsharpe, Commented May 15, 2015 at 7:42

jonrsharpe · Accepted Answer · 2015-05-15 07:40:30Z

6

Here is a minimal example that demonstrates how to iterate over actual dates:

>>> import datetime
>>> start = datetime.date(2014, 1, 1)
>>> end = datetime.date(2014, 1, 5)
>>> while start <= end:
    print start.strftime('%Y%m%d')
    start += datetime.timedelta(days=1)


20140101
20140102
20140103
20140104
20140105

See the datetime documentation for more information.

answered May 15, 2015 at 7:40

jonrsharpe

123k31 gold badges278 silver badges488 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

wanderlust Over a year ago

print start.strftime('%Y%m%d') and start += datetime.timedelta(days=1) are inner loop.

gwerner Over a year ago

Awesome @jonrsharpe, just what I was looking for!

Juan Diego Godoy Robles · Accepted Answer · 2015-05-15 09:05:19Z

1

An alternative using calendar module:

>>> import calendar
>>> cal = calendar.Calendar()
>>> year = 2014
>>> for month in range(1,13):
...    for day in cal.itermonthdates(year, month):
...        if day.year == year:
...           print day.strftime('%Y%m%d')
... 
20140101
20140102
20140103
20140104
...
...
20141229
20141230
20141231

answered May 15, 2015 at 9:05

Juan Diego Godoy Robles

15k2 gold badges43 silver badges57 bronze badges

Comments

Pooja · Accepted Answer · 2015-05-15 09:37:39Z

0

Instead you can use datetime to convert int to datetime format and check whether the year matches your requirement. for e.g

import datetime
s = 20140101
s_datetime = datetime.datetime.strptime(str(s), '%Y%m%d')
if s_datetime.year == 2014:
    //Do something

answered May 15, 2015 at 9:37

Pooja

1,29014 silver badges17 bronze badges

Collectives™ on Stack Overflow

For loop with Python - using ints instead of datetime

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related