Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import dash
- import numpy as np
- import pandas as pd
- import plotly.offline as py
- import plotly.graph_objs as go
- import psycopg2 as pg2
- import datetime
- conn = pg2.connect(database='X',user='X',password=secret)
- cur = conn.cursor()
- cur.execute("SELECT * FROM times;")
- a = cur.fetchall()
- str(a)
- df = pd.DataFrame([[ij for ij in i] for i in a])
- df.to_json()
- df.rename(columns={0: "Serial Number", 1: "Status", 2: "Date", 3: "Time", 4: "Number"}, inplace=True);
- x = df["Date"]
- data = [go.Scatter(
- x=x,
- y=df["Status"])]
- layout = go.Layout(title="Server Data Visualization",
- xaxis = dict(
- range = [df.head(1),
- df.tail(1)]),
- yaxis=dict(title = "Status"))
- fig = go.Figure(data = data, layout = layout)
- py.plot(fig)
- Traceback (most recent call last):
- File "\srv31data1users$UserDesktopbasic.py", line 37, in <module>
- py.plot(fig)
- File "C:UsersUserAppDataLocalProgramsPythonPython36libsite-packagesplotlyofflineoffline.py", line 469, in plot
- '100%', '100%', global_requirejs=False)
- File "C:UsersUserAppDataLocalProgramsPythonPython36libsite-packagesplotlyofflineoffline.py", line 184, in _plot_html
- cls=utils.PlotlyJSONEncoder)
- File "C:UsersUserAppDataLocalProgramsPythonPython36libjson__init__.py", line 238, in dumps
- **kw).encode(obj)
- File "C:UsersUserAppDataLocalProgramsPythonPython36libsite-packagesplotlyutils.py", line 161, in encode
- encoded_o = super(PlotlyJSONEncoder, self).encode(o)
- File "C:UsersUserAppDataLocalProgramsPythonPython36libjsonencoder.py", line 199, in encode
- chunks = self.iterencode(o, _one_shot=True)
- File "C:UsersUserAppDataLocalProgramsPythonPython36libjsonencoder.py", line 257, in iterencode
- return _iterencode(o, 0)
- File "C:UsersUserAppDataLocalProgramsPythonPython36libsite-packagesplotlyutils.py", line 229, in default
- return _json.JSONEncoder.default(self, obj)
- File "C:UsersUserAppDataLocalProgramsPythonPython36libjsonencoder.py", line 180, in default
- o.__class__.__name__)
- TypeError: Object of type 'DataFrame' is not JSON serializable
Add Comment
Please, Sign In to add comment