def parse_contents()

in Dashboard/pages/upload_tst.py [0:0]


def parse_contents(contents, filename, date):
    content_type, content_string = contents.split(',')

    decoded = base64.b64decode(content_string)
    try:
        if 'csv' in filename:
        # Assume that the user uploaded a CSV file
            df = pd.read_csv(
            io.StringIO(decoded.decode('utf-8')))
        elif 'xls' in filename:
        # Assume that the user uploaded an excel file
            df = pd.read_excel(io.BytesIO(decoded))
    except Exception as e:
        print(e)
        return html.Div([
        'There was an error processing this file.'
    ])

    return html.Div([
    html.H5(filename),
    html.H6(datetime.datetime.fromtimestamp(date)),
    html.P("Inset X axis data"),
    dcc.Dropdown(id='xaxis-data',
                    options=[{'label':x, 'value':x} for x in df.columns]),
    html.P("Inset Y axis data"),
    dcc.Dropdown(id='yaxis-data',
                    options=[{'label':x, 'value':x} for x in df.columns]),
    html.Button(id="submit-button", children="Create Graph"),
    html.Hr(),
    dash_table.DataTable(
        data=df.to_dict('records'),
        columns=[{'name': i, 'id': i} for i in df.columns],
        page_size=15
    ),
    dcc.Store(id='stored-data', data=df.to_dict('records')),
    html.Hr(),  # horizontal line
    # For debugging, display the raw contents provided by the web browser
    html.Div('Raw Content'),
    html.Pre(contents[0:200] + '...', style={
        'whiteSpace': 'pre-wrap',
        'wordBreak': 'break-all'
    })