I am new to Plotly and Python. I am trying to use plotly.express timeline to plot process during event log. Here is a simple code to show what I wanted to achieve:
import plotly.express as px
import pandas as pd
df = pd.DataFrame([
dict(Task=“Wk1”, Start=‘2.1’, End=‘5.5’, Category=‘Group1’),
dict(Task=“Wk2”, Start=‘5.5’, End=‘10.0’, Category=‘Group1’),
dict(Task=“Wk3”, Start=‘22.3’, End=‘28.9’, Category=‘Group1’),
dict(Task=“Wk4”, Start=‘12.6’, End=‘14.0’, Category=‘Group2’),
dict(Task=“Wk5”, Start=‘14.0’, End=‘18.3’, Category=‘Group2’),
dict(Task=“Wk6”, Start=‘18.3’, End=‘20.8’, Category=‘Group2’)
])
df[‘Start’] = pd.to_datetime(df[‘Start’], unit=‘s’)
df[‘End’] = pd.to_datetime(df[‘End’], unit=‘s’)
fig = px.timeline(df, x_start=‘Start’, x_end=‘End’, y=‘Category’, color=‘Task’, title=“unit=‘s’”)
fig.show()
Because my process durations are in microseconds, so the ‘Start’ and ‘End’ unit should actually be ‘us’. However, if I change the unit in pd.to_datetime() to ‘us’, I only get a total blank drawing.
I thought the accuracy of the datetime is datetime64[ns], which I assume is up to the nanosecond. Please help.
Below is my plot results:
