true

Learn Python Training from the Best Tutors

• Affordable fees
• 1-1 or Group class
• Flexible Timings
• Verified Tutors

Search in

# Code: Gantt Chart: Horizontal bar using matplotlib for tasks with Start Time and End Time

R
Rishi B.
08/04/2020 0 0

import pandas as pd
from datetime import datetime
import matplotlib.dates as dates
import matplotlib.pyplot as plt

def gantt_chart(df_phase):

# Now convert them to matplotlib's internal format...

df_phase['Start Time'] = pd.to_datetime(df_phase['Start Time'], format='%Y-%m-%d %H:%M:%S.%f')

df_phase['End Time'] = pd.to_datetime(df_phase['End Time'], format='%Y-%m-%d %H:%M:%S.%f')

#Convert DF columns into lists, plt will take all values in scalar or list

sdate = df_phase['Start Time'].tolist()

edate = df_phase['End Time'].tolist()

plugin = df_phase['Plugin'].tolist()

status = df_phase['Status'].tolist()

color = []

#Store colors for success and failure to differentiate

for i in range(0, len(status)):

if status[i] == 'Success':

color.append('green')

else:

color.append('red')

#Convert time to Matplotlib number format

edate, sdate = [dates.date2num(item) for item in (edate, sdate)]

ypos = range(len(plugin))

fig, ax = plt.subplots()

time_diff = edate - sdate

# Plot the data, color is scalar or a list

# All are in form of list

ax.barh(ypos, time_diff, left=sdate, linewidth = 0.5, height=0.8, align='center', color=color)

plt.yticks(ypos, plugin)

plt.xticks(rotation=-20)

ax.axis('tight')

# We need to tell matplotlib that these are dates...

ax.xaxis_date()

plt.ylabel('Plugins', fontsize='medium', stretch = 'normal')

# bbox_inches='tight' will prevent cutting of y-label

fig.savefig(image_file, bbox_inches='tight')

plt.show()

data = [['A', '2019-06-27 18:33:58.033', '2019-06-27 19:54:04.658', 'Success'], ['B', '2019-06-27 19:54:04.957', '2019-06-27 19:58:14.570', 'Success'], ['C', '2019-06-27 19:54:04.963', '2019-06-27 19:54:19.928', 'Failed']]

df_phase = pd.DataFrame(data, columns = [Plugin, 'Start Time', 'End Time', 'Status'])

#Calling the function

gantt_chart(df_phase)

Note: This is authored my me only, you can find it on my blog.

0 Dislike

## Other Lessons for You

Assignment operators
Operation Syntax Comment Assignment = Control flow right to left Add AND += Incremental Subtract AND -= Decremental Multiply AND *= Multiplicative increment Division...

Top Programming Languages 2017: Every Beginner Should Learn
Every year a plethora of job opportunities are being created for skilled programmers. So if you are thinking of honing your coding skills it is really a bright idea. But with so many programming languages...

A Python Program to calculate Variance and Standard Deviation
Finding the variance and the standard deviation. Variance and Standard Deviation are related measures of dispersion that tell us more about a list of numbers,like are they...

PEP (Python Enhancement Proposals)
Python Enhancement Proposals(PEP) are suggestions for improvements to the language, made by experienced Python developers. PEP 8 is a style guide on the subject of writing readable code. It contains a...

Shallow And Deep Copying
The difference between shallow and deep copying is only relevant for compound objects (objects that contain other objects, like lists or class instances): A shallow copy constructs a new compound object...

### Looking for Python Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

X

### Looking for Python Training Classes?

The best tutors for Python Training Classes are on UrbanPro

• Select the best Tutor
• Book & Attend a Free Demo
• Pay and start Learning

### Learn Python Training with the Best Tutors

The best Tutors for Python Training Classes are on UrbanPro