# Making uploaded dataframe available globally

**URL:** <https://community.plotly.com/t/making-uploaded-dataframe-available-globally/69475>\
**Category:** Dash Python\
**Tags:** question\
**Created:** [November 1, 2022, 6:29pm UTC](https://community.plotly.com/t/making-uploaded-dataframe-available-globally/69475 "2022-11-01T18:29:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![FumaxIN](https://sea2.discourse-cdn.com/flex024/user_avatar/community.plotly.com/fumaxin/32/20779_2.png) [@FumaxIN](https://community.plotly.com/u/FumaxIN)\
**Post date:** [November 1, 2022, 6:29pm UTC](https://community.plotly.com/t/making-uploaded-dataframe-available-globally/69475/1 "2022-11-01T18:29:05Z")

</div>

I want to shift `column_dropdown` code into the `app.layout` for which I need to make `df` in `parse_data` available globally in order to use `df` in `app.layout`.  
In short it is like declaring `df` at the top before `app.layout`

```
import base64
import datetime
import io
import plotly.graph_objs as go
import cufflinks as cf
import chart_studio as py
from plotly.offline import download_plotlyjs, init_notebook_mode, plot, iplot

import dash
from dash.dependencies import Input, Output, State
from dash import dcc
from dash import html
from dash import dash_table
import json
import pandas as pd
import xlrd
import openpyxl
import plotly.express as px
import plotly.io as pio
external_stylesheets = ["https://codepen.io/chriddyp/pen/bWLwgP.css"]

app = dash.Dash( __name__ , external_stylesheets=external_stylesheets)
server = app.server

colors = {"graphBackground": "#F5F5F5", "background": "#ffffff", "text": "#000000"}

app.layout = html.Div(
    [
        html.Div([dcc.Graph(id='our_graph')]),
        dcc.Upload(
            id="upload-data",
            children=html.Div(["Drag and Drop or ", html.A("Select Files")]),
            style={
                "width": "100%",
                "height": "60px",
                "lineHeight": "60px",
                "borderWidth": "1px",
                "borderStyle": "dashed",
                "borderRadius": "5px",
                "textAlign": "center",
                "margin": "10px",
            },
            # Allow multiple files to be uploaded
            multiple=True,
        ),
        # dcc.Graph(id="Mygraph"),
        # html.Div(id="output-data-upload"),
        html.Div(id="column_dropdown"),

    ]
)
def parse_data(contents, filename):
    global df
    content_type, content_string = contents.split(",")

    decoded = base64.b64decode(content_string)
    try:
        if "csv" in filename:
            # Assume that the user uploaded a CSV or TXT 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 df

@app.callback(
    Output("column_dropdown", "value"),
    [Input("upload-data", "contents"), Input("upload-data", "filename")],
)

def column_dropdown(contents, filename):
    if contents:
        contents = contents[0]
        filename = filename[0]
        df = parse_data(contents, filename)
        Dropdown = html.Div([
            dcc.Dropdown(
                id='Dataset_and_Column',
                options=[{'label': i, 'value': i} for i in df.columns],
                style={'width': '100%', 'height': '60px', 'lineHeight': '60px', 'borderWidth': '1px',
                       'borderStyle': 'dashed', 'borderRadius': '5px', 'textAlign': 'center', 'display': 'inline-block'},
                placeholder='Select Dataset Column'
            ),
            html.Br(),
        ])

        return Dropdown

```