Programming

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

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()

--------------------------------------------------------------------------
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('/home/timothee/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'

DataFrame or TextParser
A comma-separated values (csv) file is returned as two-dimensional data structure with labeled axes.