Using Python to Schedule a job everyday

Question

I want to run a job every day at 9:55 AM to load a data frame into an Excel sheet. I was able to figure out the below code that apparently does that. However, when I run the code, it's sort of perennially stuck in execution mode without any results. I basically do not want to open Pycharm every day to run this code. What do I need to add to run the job every day without me having to do anything at all?

def job():
    df=pd.DataFrame(np.random.randn(25).reshape(5, 5), index=[1, 2, 3, 4, 5], columns=['a', 'b', 'c', 'd', 'e'])
    writer=pd.ExcelWriter('test.xlsx')
    df.to_excel(writer,'Sheet1')
    writer.save()


schedule.every().day.at("09:55").do(job)

while True:
schedule.run_pending()
time.sleep(1)

I'd use a cron job on Linux or something similar on a Windows machine, given that you have a machine that runs 24/7. — Uwe Ziegenhagen, Feb 08 '19 at 14:54
As mentioned before you can use different schedulers for Windows. https://stackoverflow.com/a/132975/6244607 — forest-man, Feb 08 '19 at 14:57
@LaxMandis Windows has Task Scheduler. This is something the OS can do for you, not something you program yourself. — RemcoGerlich, Feb 08 '19 at 14:57

score 1 · Answer 1 · answered Feb 08 '19 at 15:39

For scheduling tasks, you better use software which was designed to do that. In nix environment it could be Cron, for example. For Win -- probably TaskScheduler. Anyway, you probably would like to take this approach: https://stackoverflow.com/a/2725908/2822774

score 0 · Answer 2 · answered Feb 10 '19 at 09:08

0

i had a simmilar problem - u can see my py_scheduler library for it https://github.com/kl09/py_scheduler This is better to controll schduler job in your app, to make a special microservice for it, neither to use a cron

answered Feb 10 '19 at 09:08

kl09

31
2

Using Python to Schedule a job everyday

2 Answers2