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'] }