Python Forum

Full Version: how to use dataframe in dash?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I am very new to python, need to develop some dash,

I have a padas dataframe.
df:
x y1 y2
1 4 2
2 1 4
3 5 5
My question is how to use df to replace the hard coded 'data' part in following codes?

dcc.Graph(
        id='example-graph',
        figure={
            'data': [
                {'x': [1, 2, 3], 'y': [4, 1, 5], 'type': 'line', 'name': 'SF'},
                {'x': [1, 2, 3], 'y': [2, 4, 5], 'type': 'line', 'name': u'Montréal'},
            ],
            'layout': {
                'title': ' Campaign Contacts '
            }
        }
    )    
Thanks,
Jeff
data = pd.DataFrame({'x': [1,2,3], 'y1': [4,1,5], 'y2': [2, 4, 5]})
xvals = data.x.values.tolist()
names = ['SF', 'Montreal']
data_pars = [{'x': xvals, 'y': data[colname].values.tolist(), 'name': name, 'type': 'line'} for colname, name in zip(data.iloc[:, 1:].columns, names)]

dcc.Graph(
        id='example-graph',
        figure={
            'data': data_pars,
            'layout': {
                'title': ' Campaign Contacts '
            }
        }
    )