Loading csv-data into data source by a JavaScript Callback

[mylesmoose]

I can’t help answer your question but I have an application where a user uploads an excel file, which gets put into a dataframe and various plots are generated. I did it using the FileInput widget. It was discussed in this question.

How to process files after using FileInput function

I’m trying to modify an existing program I have such that it allows the user to select a file, which some python code then processes and some nice plots result. However, I’m really stuck on getting the input from the FileInput reader into a dataframe. My inputs are in relatively standardized xls and xlsx files, but I can’t figure out how I can put them in a dataframe as pd.read_excel expects a link to the file. Here is the simple code I’m using to try and test my function, I’m sure I’m missing …

;Main code
df_data = pd.DataFrame()
df_header = pd.DataFrame()
p = Paragraph(text="""Select File:""")
file_input = FileInput(accept=".xls,.xlsx")
file_input.on_change('value', upload_fit_data)
doc=curdoc()
doc.add_root(row(p,file_input))

;processing function
def upload_fit_data(attr, old, new):
global df_header
global df_data
global row_split
decoded = b64decode(new)
cpt_file = io.BytesIO(decoded)
#cpt_file = '18-04011_GP08-BSC.xls'

xls = pd.read_excel(cpt_file)

row_split = (xls[xls.isin(['Layer'])].dropna(how='all').index + 2)[0]
df_header = xls.iloc[0:row_split, :]
df_data = xls.iloc[row_split:, :]
pd.set_option('mode.chained_assignment', None)