Search code examples
pythonpandasiteratorapi-design

How to iterate through dataframe based on timer?


I have a dataframe that looks like this:

id   text     number  url
1    test1    123     a.com
2    test2    456     b.com

Once per day I want to iterate through only one row of a dataframe into an api. Example on 7/28, send number 123 text test1. On 7/29 send 456 text test2.

Here is the code that looks through the entire dataframe, but not sure how to only one row per day?

for index, row in df.iterrows():
    data = {
    'phone': row.number,
    'message':row.text,
    'url':row.URL,
    }

    r = requests.post(URL,headers=headers,params=data)

    print(r.text)

Solution

  • import time
    
    for index, row in df.iterrows():
        data = {
        'phone': row.number,
        'message':row.text,
        'url':row.URL,
        }
    
        r = requests.post(URL,headers=headers,params=data)
        print(r.text)
        time.sleep(86400)