Python Forum
how to use dataframe in dash?
Thread Rating:
  • 1 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to use dataframe in dash?
#1
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
Reply
#2
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 '
            }
        }
    )    
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  create loop of subplot plotly dash without hardcode tonycat 0 3,874 Sep-23-2020, 08:40 AM
Last Post: tonycat
  How to update component props every time when a Dash callback returns? sguzunov 0 2,475 Jul-27-2020, 07:11 AM
Last Post: sguzunov
  Invalid archive error when attempting to install dash bootstrap components meaydemi 0 4,733 Jul-11-2019, 05:49 PM
Last Post: meaydemi
  dash problems zhujp98 0 2,220 Jun-14-2018, 03:30 PM
Last Post: zhujp98
  can not change double to single dash oco 7 4,563 Jun-03-2018, 09:51 AM
Last Post: wavic

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020