如何使用pandas和plotly将具有不同时间轴的2个或多个测量(csv)绘制到一个图形中

将文件读取为熊猫数据帧。如果使用plotly graph对象,则在同一绘图上绘制两个图形会更容易 go.Bar or go.Scatter 。通过给定范围和 dticks 参数

下面的示例显示了一个简单的散点图,其中包含在同一图表上绘制的两个图形。

import numpy as np
import pandas as pd
import plotly.offline as py
import plotly.graph_objs as go
from plotly import tools

df1 = pd.DataFrame({"X":np.linspace(0,30,10), "Y":np.random.rand(10)})
df2 = pd.DataFrame({"A":np.linspace(0,40,10), "B":np.random.rand(10)})

# plotting the graphs...


def scatter_chart(x, y, color, name):

   trace = go.Scatter(
         x=x.values,
         y=y.values,
         name=name,

         marker=dict(
                color=color,
                line=dict(
                color=color,
                width=1)
              ),
          )
  return trace
# for loop could be used
trace1 = scatter_chart(df2["A"], df2["B"], 'rgb(128, 0, 128)', "df2")
trace2 = scatter_chart(df1["X"], df1["Y"], 'rgba(50, 171, 96, 0.6)', "df1")
fig = tools.make_subplots(rows=1,cols=1, vertical_spacing=0.5)
fig.add_trace(trace1)
fig.add_trace(trace2)

fig.update_layout(
   title="df2 and df1 plot",
   height=600, 
   width=600, 
  # annotations=annotations, 
  xaxis=dict(tickangle=-45),
  legend=dict(x=0.029, y=1.038, font_size=10),
  margin=dict(l=100, r=20, t=70, b=70),
  paper_bgcolor='rgb(248, 248, 255)',
  plot_bgcolor='rgb(248, 248, 255)',)

# xaxis could be customized further
fig['layout']['xaxis'].update(title='', range=[0, 500], dtick=50, autorange=False)
py.iplot(fig, filename='pageviews_plots_4')

请运行代码并查看。。希望你能明白。