Python check if int is in certain object of list

Question

i currently have a result set with the following data:

((0L, datetime.date(2018, 1, 29)), (0L, datetime.date(2018, 1, 30)), (0L, 
datetime.date(2018, 1, 31)), (0L, datetime.date(2018, 2, 1)))

I am trying to check if the current date has the status 0 or 1.

Currently i do this:

   if checkdate():
        if result_set[0] == 1:

The checkdate function checks if the currentdate is inside the list somewhere. But there i'm stuck trying to figure out if that date has the status 1 or 0. The status is the first item on the list (0l and 1L) mysql somehow adds a L after the 0 and 1.

Currently my checkdate function looks like this:

return any(d[1] == cd for d in result_set)

Would love some help!

Edit: Now, checkdate looks like this:

return next(((s,d) for (s,d) in dates if d == date), None)

entry = checkdate([x[1] for x in result_set], cd)
            if entry is not None:

Yes my bad, the first result in the lists (0L and 1L) is supposed to be the status. in my database this is either 0 or 1. MySQL adds a L for some reason. — Wesley van Straalen
– Wesley van Straalen, Commented Feb 1, 2018 at 10:37
Change function checkdate to return the index of the current date in the list, or -1 if it is not in the list. Then you can simply do something like index = checkdate(); if index >= 0 and result_set[index][0] == 1: .... — goodvibration
– goodvibration, Commented Feb 1, 2018 at 10:38
@goodvibration That sounds good. How would i do this? My current checkdate function is the following: return any(d[1] == cd for d in result_set) — Wesley van Straalen
– Wesley van Straalen, Commented Feb 1, 2018 at 10:39
You probably should redesign the data, and use a dictionary that maps date objects to ints. — willeM_ Van Onsem
– willeM_ Van Onsem, Commented Feb 1, 2018 at 10:39

tobias_k · Accepted Answer · 2018-02-01 11:18:11Z

1

You should change your checkdate function to return the actual (status, date) pair instead of just whether such a pair exists. For this, you can translate your any expression almost 1:1 into a next statement, using None as the default in case no such pair exists.

For example, like this (I also changed the function to take parameters instead of using global variables, but that's not essential for this to work).

import datetime
result_set = ((0, datetime.date(2018, 1, 29)), (1, datetime.date(2018, 1, 30)),   
              (0, datetime.date(2018, 1, 31)), (0, datetime.date(2018, 2, 1)))
cd = datetime.date(2018, 1, 30)

def checkdate(dates, date):
    return next(((s, d) for (s, d) in dates if d == date), None)

entry = checkdate(result_set, cd)
if entry is not None and entry[0] == 1:
    print("found")

Or like this, if you prefer using the global result_set and cd variables:

def checkdate():
    return next(((s, d) for (s, d) in result_set if d == cd), None)

entry = checkdate()
if entry is not None and entry[0] == 1:
    print("found")

edited Feb 1, 2018 at 11:18

answered Feb 1, 2018 at 10:55

tobias_k

83.1k12 gold badges130 silver badges186 bronze badges

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

2 Comments

Wesley van Straalen Over a year ago

Trying this i get the following error: datetime.date is not iterable

tobias_k Over a year ago

@WesleyvanStraalen I just saw your edit. You should pass the list of (status, date) pairs to checkdate, not just the dates as you seem to do.

goodvibration · Accepted Answer · 2018-02-01 10:41:03Z

0

Change function checkdate to return the index of the current date in the list, or -1 if it is not there.

Then you can simply do something like:

index = checkdate()
if index >= 0 and result_set[index][0] == 1:
    ...

answered Feb 1, 2018 at 10:41

goodvibration

6,2465 gold badges35 silver badges69 bronze badges

4 Comments

hjpotter92 Over a year ago

Why not return the tuple itself or None?

Wesley van Straalen Over a year ago

Seems nice, how would i make the function return the index?

goodvibration Over a year ago

@hjpotter92: That's also an option (and probably not the only one).

goodvibration Over a year ago

@WesleyvanStraalen: How about iterating the list?

Collectives™ on Stack Overflow

Python check if int is in certain object of list

2 Answers 2

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related