Broken barh timeline using mattplotlib when row items matches (python)

Question

Let met start by saying that this is my first post so if something is out of the ordinary - my apologies.

I've tried to find solutions to solve my problem, but unfortunately to no avail. I'm trying to create a timeline based on my dataframe ('df_phase') which has the following headers:

Name | time_entries.days | time_entries.end_time | time_entries.hours | time_entries.minutes | time_entries.seconds | time_entries.start_time

In theory, the only columns that matter are the name column, the end time column and the start time column.

Right now I've made a script that can plot the timeline correctly - however, it shows each Activity (column 'name') on a new y-axis row. Ideally, I would like to have row items with the same activity name on the same y-axis using a broken barh and every new row item with a new activity name on a new y-axis row.

My current script is as follows:

df_phase['Start_Time'] = pd.to_datetime(df_phase['time_entries.start_time'], format='%Y-%m-%d %H:%M:%S')
df_phase['End_Time'] = pd.to_datetime(df_phase['time_entries.end_time'], format='%Y-%m-%d %H:%M:%S')

#Convert DF columns into lists
sdate = df_phase['Start_Time'].tolist()
edate = df_phase['End_Time'].tolist()
tasks = df_phase['name'].tolist()

#Convert time to Matplotlib number format
edate, sdate = [dates.date2num(item) for item in (edate, sdate)]

time_diff = edate - sdate
ypos = range(len(tasks))
fig, ax = plt.subplots()      
ax.barh(ypos, time_diff, left=sdate, height=0.8, align='center', color='blue',edgecolor='black')
plt.yticks(ypos, tasks)
ax.axis('tight')


#We need to tell matplotlib that these are dates...
ax.xaxis_date()
ax.set_xlabel('Time line')
plt.xlim(df_phase['Start_Time'].min(), df_phase['End_Time'].max())
ax.xaxis.set_major_formatter(dates.DateFormatter('%H:%M:%S'))

plt.show()

Would it be possible to create such broken barh for each Activity with multiple time entries? If possible with new colours for each y-axis barh.

I would really appreciate your help - thanks :)

question from:https://stackoverflow.com/questions/65841644/broken-barh-timeline-using-mattplotlib-when-row-items-matches-python

Answer 1

Waitting for answers