help with accessing .txt file and performing actions

[deanhystad]

To find out if the task is overdue

To do this in pandas.

import pandas as pd
from datetime import datetime

tasks = pd.read_csv(
    "tasks.txt",
    sep=";",
    names=["user", "action", "desc", "created", "due", "complete"],
    parse_dates=["due", "created"])
tasks.complete = tasks.complete=="Yes"

print("All tasks", tasks, sep="\n")
print("\nAwaiting completion")
print(tasks[~tasks.complete])
today = datetime.strptime("2024-06-15", "%Y-%m-%d")
print("\nOverdue\nToday =", today.strftime("%Y-%m-%d"))
print(tasks[(~tasks.complete) & (tasks.due < today)])

Output:
All tasks
    user       action desc    created        due  complete
0     am  needs doing  now 2004-04-12 2024-03-05     False
1    sam    please do  gym 2024-05-20 2024-07-05     False
2  admin           do   sd 2004-12-12 2024-05-05     False
3    dam          dam  dam 2024-12-12 2024-03-05      True

Awaiting completion
    user       action desc    created        due  complete
0     am  needs doing  now 2004-04-12 2024-03-05     False
1    sam    please do  gym 2024-05-20 2024-07-05     False
2  admin           do   sd 2004-12-12 2024-05-05     False

Overdue
Today = 2024-06-15
    user       action desc    created        due  complete
0     am  needs doing  now 2004-04-12 2024-03-05     False
2  admin           do   sd 2004-12-12 2024-05-05     False