René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Create more table in one page","articleBody":"Hey guys, i would like to show 2 dataframe table, one is the dataset and the other one is statistical calculation of the dataframe (pandas describe()) of the dataframe. but I couldn't manage to show it. here is my code: \r\n\r\n```\r\n# Define App Layout\r\napp.layout = html.Div([\r\n    # Title\r\n    html.H2('Analytics Dashboard'),\r\n    \r\n    # Dropdown to choose the dataset\r\n    html.Div([\r\n        html.Label('Choose Your Data'),\r\n        dcc.Dropdown(\r\n            options = [{'label':i, 'value':i} for i in onlyfiles], \r\n            value = \" \",\r\n            id=\"field-dropdown\"\r\n            ), \r\n        ], \r\n        style = {'width':'25%', 'display':'inline-block'}\r\n    ),\r\n\r\n    # Visualize Dataframe using Dash's Data Table Experiments\r\n    dt.DataTable(\r\n        # initialize rows\r\n        rows = [{}],\r\n        # selection feature in dash table\r\n        row_selectable = True,\r\n        # filter feature in dash table\r\n        filterable = True,\r\n        # sort feature in dash table\r\n        sortable = True,\r\n        # initialize row selection array\r\n        selected_row_indices = [],\r\n        # data table id (for referencing)\r\n        id = 'datatable'\r\n    ), \r\n\r\n    dt.DataTable(\r\n        rows = [{}],\r\n        row_selectable = False,\r\n        filterable = False,\r\n        sortable = False,\r\n        id = 'statisticalTable'\r\n    ), \r\n\r\n    # Hidden div inside the app that stores the intermediate value\r\n    # Use for sharing data between callback\r\n    html.Div(id='intermediate-value', style={'display':'none'})\r\n])\r\n\r\n# Callback to read state change in dropdown\r\n@app.callback(Output('intermediate-value','children'),[Input('field-dropdown', 'value')])\r\ndef updateTable(field_dropdown): # update function in dropdown change\r\n    # pandas dataframe construct\r\n    df = pd.read_csv(datapath+field_dropdown)\r\n    return df.to_json(date_format='iso', orient='split')\r\n\r\n@app.callback(Output('datatable','rows'),[Input('intermediate-value', 'children')])\r\ndef updateTable(jsonified_clean_data):\r\n    print('update 1st table')\r\n    dff = pd.read_json(jsonified_clean_data, orient='split')\r\n    return dff.to_dict('record')\r\n\r\n@app.callback(Output('statisticalTable','rows'),[Input('intermediate-value', 'children')])\r\ndef updateStatTable(jsonified_clean_data):\r\n    print('update 2nd table')\r\n    dff = pd.read_json(jsonified_clean_data, orient='split')\r\n    stat = dff.describe()\r\n    print(stat)\r\n    return stat.to_dict('record')\r\n\r\n\r\n# server main \r\nif __name__ == '__main__':\r\n    app.run_server(debug=True)\r\n```","author":{"url":"https://github.com/elianalien","@type":"Person","name":"elianalien"},"datePublished":"2018-10-22T11:00:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/95/dash-table-experiments/issues/95"}