import plotly.graph_objs as go
import pandas as pd
#df = pd.read_csv('https://raw.githubusercontent.com/plotly/datasets/master/wind_speed_laurel_nebraska.csv')
df = pd.read_excel('/Users/Jakob/Documents/python_notebooks/data/test_excel_import_1.xlsx')
fig = go.Figure([
go.Scatter(
name='Measurement 1',
x=df['Time'],
y=df['10 Min Sampled Avg'],
mode='markers+lines',
marker=dict(color='red', size=2),
showlegend=True
),
go.Scatter(
name='Upper Bound',
x=df['Time'],
y=df['10 Min Sampled Avg']+df['10 Min Std Dev'],
mode='lines',
marker=dict(color="#444"),
line=dict(width=1),
showlegend=False
),
go.Scatter(
name='Lower Bound',
x=df['Time'],
y=df['10 Min Sampled Avg']-df['10 Min Std Dev'],
marker=dict(color="#444"),
line=dict(width=1),
mode='lines',
fillcolor='rgba(68, 68, 68, 0.3)',
fill='tonexty',
showlegend=False
),
go.Scatter(
name='Measurement 2',
x=df['Time'],
y=df['Velocity'],
mode='markers+lines',
marker=dict(color='blue', size=2),
showlegend=True
),
go.Scatter(
name='Upper Bound',
x=df['Time'],
y=df['Velocity']+df['SEM'],
mode='lines',
marker=dict(color="#444"),
line=dict(width=1),
showlegend=False
),
go.Scatter(
name='Lower Bound',
x=df['Time'],
y=df['Velocity']-df['SEM'],
marker=dict(color="#444"),
line=dict(width=1),
mode='lines',
fillcolor='rgba(68, 68, 68, 0.3)',
fill='tonexty',
showlegend=False
)
])
fig.update_layout(
yaxis_title='Wind speed (m/s)',
title='Continuous, variable value error bars',
hovermode="x"
)
fig.show()