Re: [Tutor] Finding and Inserting missing dates in a date range.

2009-10-14 Thread Glen Zangirolami
I went ahead and used a date range generator: http://dpaste.com/107140/ to iterate over the range.I then compared the original list with the generated one and inserted the missing dates. I was comparing the generated dates to dates in a list list of tuples: [(date, count), (date, count) .

Re: [Tutor] Finding and Inserting missing dates in a date range.

2009-10-11 Thread Lie Ryan
Glen Zangirolami wrote: Thats for all the responses. I'm going to use Kents method. I'll let you know what I work out. Rudiger - I did think about that. Luckily I am generating the list with a start datetime and end datetime so if those don't exist in either end if the list I can insert

[Tutor] Finding and Inserting missing dates in a date range.

2009-10-09 Thread Glen Zangirolami
If i have a list of dates:date_list = ['2008-12-29','2008-12-31','2008-01-01','2008-01-02','2008-01-03','2008-01-05'] How do I find the missing dates in the range of dates and insert them into the list so I get? date_list =

Re: [Tutor] Finding and Inserting missing dates in a date range.

2009-10-09 Thread Wayne
On Fri, Oct 9, 2009 at 2:16 PM, Glen Zangirolami digitalma...@gmail.comwrote: If i have a list of dates:date_list = ['2008-12-29','2008-12-31','2008-01-01','2008-01-02','2008-01-03','2008-01-05'] How do I find the missing dates in the range of dates and insert them into the list so I get?

Re: [Tutor] Finding and Inserting missing dates in a date range.

2009-10-09 Thread Tim Golden
Glen Zangirolami wrote: If i have a list of dates:date_list = ['2008-12-29','2008-12-31','2008-01-01','2008-01-02','2008-01-03','2008-01-05'] How do I find the missing dates in the range of dates and insert them into the list so I get? date_list =

Re: [Tutor] Finding and Inserting missing dates in a date range.

2009-10-09 Thread Kent Johnson
On Fri, Oct 9, 2009 at 3:16 PM, Glen Zangirolami digitalma...@gmail.com wrote: If i have a list of dates: date_list = ['2008-12-29','2008-12-31','2008-01-01','2008-01-02','2008-01-03','2008-01-05'] How do I find the missing dates in the range of dates and insert them into the list so I get?

Re: [Tutor] Finding and Inserting missing dates in a date range.

2009-10-09 Thread Rüdiger Wolf
Ah! but are we sure that the max and min dates are actually in the list? If there are 'missing dates' it might just be possible that it is the max or min date that is missing. On Fri, 09 Oct 2009 16:43 -0400, Kent Johnson ken...@tds.net wrote: On Fri, Oct 9, 2009 at 3:16 PM, Glen Zangirolami

Re: [Tutor] Finding and Inserting missing dates in a date range.

2009-10-09 Thread Glen Zangirolami
Thats for all the responses. I'm going to use Kents method. I'll let you know what I work out. Rudiger - I did think about that. Luckily I am generating the list with a start datetime and end datetime so if those don't exist in either end if the list I can insert them after I check the dates