CGI in python, problem with pandas, plotly.express and export html

[HK2432]

Hello !

I need some help with my script in Python. I've two questions :


First question :


I'm creating a CGI which allow to display graph from some data.

The datas looks like :

2020-01-13-00-00,384.00,350.00
2020-01-13-06-00,384.00,350.00
2020-01-13-12-00,384.00,350.00
2020-01-13-18-00,384.00,350.00
2020-01-14-00-00,384.00,350.00
2020-01-14-06-00,384.00,350.00
2020-01-14-12-00,384.00,350.00

I use the ipywidgets, pandas and plotly.express librarys in order to create a web page which will display a graph with two buttons : the first to display the graph and the second to display the graph with the trendline.

My script is :

import ipywidgets as widgets
import pandas as pd
import plotly.express as px
import os
 
####### Button 1 ########
 
button = widgets.Button(description="graph")
display(button)
 
def graph():
    df = pd.read_csv('/xxx/xxx/xxx/Test.txt')
    df.head()
    fig = px.line(df, x = 'Date', y ='Total Used', title='DF command graph')
    fig.update_traces(mode='markers')
    fig.show();
 
output = widgets.Output()
 
@output.capture()
def on_button_clicked(b):
    graph();
 
button.on_click(on_button_clicked)
display(output)


####### Button 2 #########
 
button2 = widgets.Button(description='trend')
display(button2)
 
def trend():
    df = pd.read_csv('/xxx/xxx/xxx/Test.txt')
    df.head()
    fig = px.scatter(float(df), x="Date", y="Total Used", trendline="ols")
    fig.show()
 
output2 = widgets.Output()
 
@output2.capture()
def on_button2_clicked(b):
    trend()
 
button2.on_click(on_button2_clicked)
display(output2)
 
graph()

The first step ( displaying the grap ) works prefectly :



The graph button is here in order to redisplay the original graph withtout the trendline. But when I press the Trend button, I've this error :

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
~/.local/lib/python3.6/site-packages/ipywidgets/widgets/widget_output.py in inner(*args, **kwargs)
    101                     self.clear_output(*clear_args, **clear_kwargs)
    102                 with self:
--> 103                     return func(*args, **kwargs)
    104             return inner
    105         return capture_decorator

<ipython-input-17-8774359d7459> in on_button2_clicked(b)
     41 @output2.capture()
     42 def on_button2_clicked(b):
---> 43     trend()
     44 
     45 button2.on_click(on_button2_clicked)

<ipython-input-17-8774359d7459> in trend()
     34     df = pd.read_csv('/xxx/xxx/Desktop/Test.txt')
     35     df.head()
---> 36     fig = px.scatter(float(df), x="Date", y="Total Used", trendline="ols")
     37     fig.show()
     38 

TypeError: float() argument must be a string or a number, not 'DataFrame'

I think this error appears because pandas doesn't understand the part of data :

2020-01-13-00-00

But I don't understand how to fix it... Could you show me how to change that ?


Second question :

I made an other python script and I've succeeded to export my interactif graph like that :

import pandas as pd
import plotly.express as px


df = pd.read_csv('xxx/Test.txt')
df.head()

fig = px.line(df, x = 'Date', y ='Total Used', title='DF command graph')
fig.add_scatter(x=df['Date'], y=df['Free'])

fig.update_traces(mode='markers+lines')
fig.write_html("/xxx/xxx/xxx/file.html")
fig.show()

There is a way to export my script with my two buttons like that ? I don't want to use jupyter notebook but I don't know if it's possible...

Thanks !