-
Notifications
You must be signed in to change notification settings - Fork 2
/
dashboard.py
61 lines (48 loc) · 1.61 KB
/
dashboard.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
import sqlite3
import pandas as pd
import plotly.express as px
from string import Template
import os
# see
# https://realpython.com/python-dash/
# https://stackoverflow.com/a/47715493
DATABASE = (
"prod-points.sqlite" if os.path.exists("prod-points.sqlite") else "points.sqlite"
)
df = pd.read_sql(
"select * from points where not banned order by datetime is not null desc, datetime desc",
sqlite3.connect(DATABASE),
)
df["datetime"] = df["datetime"].astype("datetime64[ns]")
hist_data = df["datetime"]
fig = px.histogram(df["datetime"], title="Entries per month")
fig.update_xaxes(
range=[
"2006-01-01",
pd.Timestamp.today().strftime("%Y-%m-%d"),
],
rangeselector=dict(
buttons=list(
[
dict(count=1, label="1m", step="month", stepmode="backward"),
dict(count=6, label="6m", step="month", stepmode="backward"),
dict(count=1, label="1y", step="year", stepmode="backward"),
dict(count=2, label="2y", step="year", stepmode="backward"),
dict(count=5, label="5y", step="year", stepmode="backward"),
dict(count=10, label="10y", step="year", stepmode="backward"),
dict(step="all"),
]
)
),
)
fig.update_layout(showlegend=False)
fig.update_layout(xaxis_title=None)
fig.update_layout(yaxis_title="# of entries")
timeline_plot = fig.to_html("dash.html", full_html=False)
template = open("dashboard_template.html").read()
output = Template(template).substitute(
{
"timeline": timeline_plot,
}
)
open("dashboard.html", "w").write(output)