Plotting DataFrame with timedelta64 (y-axis)
Open
Nobody has claimed this yet.
feature
P3
- Dominant language
- Python
- Stars
- 18.8k
- Forks
- 2.8k
- Avg merge
- 16h 26m
- Merged PRs (30d)
- 21
Description
Similar to #799 but on y-axis and https://github.com/pandas-dev/pandas/issues/16953
import pandas as pd
from pandas.compat import StringIO
import plotly
import plotly.graph_objs as go
dat = """c1,c2,c3
1000,2000,1500
9000,8000,1600"""
df = pd.read_csv(StringIO(dat))
df = df.apply(lambda x: pd.to_timedelta(x, unit='ms'))
print(df)
print(df.dtypes)
print(df.index)
trace1 = go.Bar(
x=df.index,
y=df.c1,
name='c1'
)
trace2 = go.Bar(
x=df.index,
y=df.c2,
name='c2'
)
trace3 = go.Bar(
x=df.index,
y=df.c3,
name='c3'
)
data = [trace1, trace2, trace3]
layout = go.Layout(
barmode='group'
)
plotly.offline.plot({
"data": data,
"layout": layout
})
displays

y-axis values are not correctly displayed
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by running the provided Python reproducer and comparing the timedelta64 y-axis values with the rendered chart. Trace how pandas timedelta values are passed into Plotly's bar trace and define completion as correctly displayed y-axis values for this example.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- pandas, plotly, python
- Domain
- data-visualization
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 40/100