File size: 4,326 Bytes
158b090 8b4e84a 158b090 8b4e84a 158b090 925c4f9 158b090 14fefbe 158b090 14fefbe 158b090 925c4f9 158b090 906872c 331f887 f7d481f 158b090 445f8cd 158b090 b86339c 925c4f9 158b090 |
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 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 |
import gradio as gr
import pandas as pd
SHEET_ID = '1eaqWOSqNAY64E8jce5R8APAe12WFGga7f0xK3Ygt9HY'
SHEET_NAME = 'Sheet1'
csv_url = f'https://docs.google.com/spreadsheets/d/{SHEET_ID}/gviz/tq?tqx=out:csv&sheet={SHEET_NAME}'
class DataList:
def __init__(self):
self.table = pd.read_csv(csv_url)
self._preprocess_table()
self.table_header = '''
<tr>
<td width="15%">Name</td>
<td width="52%">Description</td>
<td width="15%">Module</td>
<td width="20%">Alignment with Key Guidance</td>
</tr>'''
def _preprocess_table(self) -> None:
self.table['name_lowercase'] = self.table['Name'].str.lower()
rows = []
for row in self.table.itertuples():
source = f'<a href="{row.URL}" target="_parent">{row.Name}</a>' if isinstance(
row.URL, str) else '{row.Name}'
row = f'''
<tr>
<td>{source}</td>
<td>{row.Description}</td>
<td>{row.Module}</td>
<td>{row.Alignment}</td>
</tr>'''
rows.append(row)
self.table['html_table_content'] = rows
def render(self, search_query: str,
filter_names: list[str],
filter_names2: list[str], ) -> tuple[int, str]:
self.table = pd.read_csv(csv_url)
self._preprocess_table()
self.table_header = '''
<tr>
<td width="15%">Name</td>
<td width="52%">Description</td>
<td width="15%">Module</td>
<td width="20%">Alignment with Key Guidance</td>
</tr>'''
df = self.table
if search_query:
df = df[df.name_lowercase.str.contains(search_query.lower())]
df = self.filter_table(df, filter_names,filter_names2)
result = self.to_html(df, self.table_header)
return result
@staticmethod
def filter_table(df: pd.DataFrame, filter_names: list[str], filter_names2: list[str]) -> pd.DataFrame:
df = df.loc[df.Module.isin(set(filter_names))]
df= df[df.Alignment.str.contains('|'.join(filter_names2),case=False, regex=True)]
return df
@staticmethod
def to_html(df: pd.DataFrame, table_header: str) -> str:
table_data = ''.join(df.html_table_content)
html = f'''
<table>
{table_header}
{table_data}
</table>'''
return html
data_list = DataList()
css = """
button.svelte-kqij2n{font-weight: bold !important;
background-color: #ebecf0;
color: black;
margin-left: 5px;}
#tlsnlbs{}
#mtcs{}
#mdls{}
#dts{}
.svelte-kqij2n .selected {
background-color: black;
color: white;
}
.app.svelte-182fdeq.svelte-182fdeq {
padding: 0 !important;
}
span.svelte-s1r2yt{font-weight: bold !important;
}
"""
with gr.Blocks(css=css) as demo:
search_box = gr.Textbox( label='Search Name', placeholder='You can search for titles with regular expressions. e.g. (?<!sur)face',max_lines=1, scale = 5)
filter_names = gr.CheckboxGroup(choices=["Compliance and Regulatory Guidance", "Generative AI", "Suppliers and Procurement", "Policy and Governance", "Assessing AI Systems",], value=['Compliance and Regulatory Guidance', 'Generative AI', 'Suppliers and Procurement', 'Policy and Governance', 'Assessing AI Systems',], label='Type')
filter_names2 = gr.CheckboxGroup(choices=['NIST AI RMF MAP','NIST AI RMF MEASURE','NIST AI RMF MANAGE','NIST AI RMF GOVERN','ISO/IEC 42001 4','ISO/IEC 42001 5','ISO/IEC 42001 6','ISO/IEC 42001 7','ISO/IEC 42001 8','ISO/IEC 42001 9','ISO/IEC 42001 10',], value=['NIST AI RMF MAP','NIST AI RMF MEASURE','NIST AI RMF MANAGE','NIST AI RMF GOVERN','ISO/IEC 42001 4','ISO/IEC 42001 5','ISO/IEC 42001 6','ISO/IEC 42001 7','ISO/IEC 42001 8','ISO/IEC 42001 9','ISO/IEC 42001 10',], label='Alignment with Key Guidance')
search_button = gr.Button('Search', size = 'sm', scale =1)
table = gr.HTML(show_label=False)
demo.load(fn=data_list.render, inputs=[search_box, filter_names,filter_names2,], outputs=[table,])
search_button.click(fn=data_list.render, inputs=[search_box, filter_names,filter_names2,], outputs=[table,])
demo.queue()
demo.launch(share=False) |