import matplotlib.pyplot as plt

# Define task names and their corresponding start and end dates
tasks = {
    'Task 1': (1, 5),
    'Task 2': (6, 15),
    'Task 3': (16, 25),
    'Task 4': (26, 35),
    'Task 5': (36, 45),
    'Task 6': (46, 55),
    'Task 7': (56, 65)
}

# Create figure and axis objects
fig, ax = plt.subplots(figsize=(10,5))

# Set x-axis limits
start_date = min([tasks[task][0] for task in tasks])
end_date = max([tasks[task][1] for task in tasks])
ax.set_xlim([start_date - 1, end_date + 1])

# Set y-axis limits
ax.set_ylim([0.5,len(tasks)+0.5])

# Set y-axis labels
ax.set_yticks(range(1,len(tasks)+1))
ax.set_yticklabels(list(tasks.keys()))

# Plot horizontal bars for each task
for i,(task,(start,end)) in enumerate(tasks.items()):
    duration = end - start
    ax.broken_barh([(start,duration)], (i+0.1,.8))

# Set x-axis label and title
ax.set_xlabel('Date')
ax.set_title('Project Schedule')

plt.show()

import csv
todocsv = """id,status,priority,project,description,context,start date,due date,annotation
3,,,+LibreOffice,Task 1,,2022-06-21,2022-06-26,
4,,,+LibreOffice,Task 2,,2022-06-24,2022-06-28,
5,,,+LibreOffice,Task 3,,2022-06-26,2022-06-30,
6,,,+LibreOffice,Task 4,,2022-06-29,2022-07-08,
7,,,+LibreOffice,Task 5,,2022-06-18,2022-07-13,
"""

import io
stream =  io.StringIO(todocsv)
tasks = csv.reader(stream)

# csv reader to list
taskslist = []
for task in tasks:
    taskslist.append(task)

taskslist

import json
import pyperclip as clip
f_tasks = ['id','status','priority','project','name','context','start','end','notes']
tododata = [dict(zip(f_tasks,task)) for task in taskslist]
tododata.pop(0)
s = json.dumps(tododata,indent=4)
# Copy to the clipboard the JSON formatted todo list 
clip.copy(s)
print (s)