def each_val_count_percent(df, col):
all = dbf.num_rows(df)
each_val = df[col].unique()
for i in each_val:
c = dbf.num_rows(df.loc[df[col] == i])
p = dbf.num_rows(df.loc[df[col] == i]) / all
print("{} : count = {} - percentage = {}".format(i, c, p))
def loop_collook(
df,
*columns,
):
i = 0
for i in range(i, dbf.num_rows(df), 50):
col_look(df, i, i + 50, *columns)
input("click Enter to show more\n")
def risk_charts():
data = dbf.true_val_col(database['devices'], 'risk_class')
classes = data['risk_class'].unique()
count = []
for c in classes:
count.append(dbf.num_rows(data.loc[data['risk_class'] == c]))
fig_pie = go.Figure(data=[go.Pie(labels=classes, values=count)])
return html.Div(id='risk_pie',
children=[dcc.Graph(id='risk_pie_chart', figure=fig_pie)])
def categories():
############# Categories Pie Chat
data = dbf.true_val_col(database['devices'], 'classification')
categories = data['classification'].unique()
count = []
for c in categories:
count.append(dbf.num_rows(data.loc[data['classification'] == c]))
fig_pie = go.Figure(data=[go.Pie(labels=categories, values=count)])
############# Risk Category Bar Chart
df = dbf.match_cols(data, 'classification', 'risk_class')
fig_bar = px.bar(df, x=df.index, y=df.columns, title="Long-Form Input")
fig_bar.update_layout(title_text='Percentage of MD among countries')
return html.Div(id='categories_pie',
children=[
dcc.Graph(id='map', figure=fig_pie),
dcc.Graph(id='graph_risk_class', figure=fig_bar)
])
def loop_wholelook(df):
i = 0
for i in range(i, dbf.num_rows(df), 50):
whole_look(df, i, i + 50)
input("click Enter to show more\n")
import database_functions as dbf
database = pre.db_finalization()
layout_icij_summary = html.Div(children=[
html.Div(id='row_datanases',
children=[
"whole Look of three Data Bases",
dcc.Graph(id='Graph1',
figure={
'data': [
{
'x':
['Devices', 'Events', 'Manufacturers'],
'y': [
dbf.num_rows(database['devices']),
dbf.num_rows(database['events']),
dbf.num_rows(database['manus'])
],
'type':
'bar',
'name':
'SF'
},
],
'layout': {
'plot_bgcolor': color.colors['background'],
'paper_bgcolor': color.colors['background'],
'font': {
'color': color.colors['text']
}