rhea2809/MD

1import gradio as gr2import pandas as pd3 4 5SHEET_ID = '1l-NbqrTOkbd5pPamav1kkQ9Xk3P40EIKOPL7mfCnRJo'6SHEET_NAME = 'Sheet1'7csv_url = f'https://docs.google.com/spreadsheets/d/{SHEET_ID}/gviz/tq?tqx=out:csv&sheet={SHEET_NAME}'8 9class DataList:10    def __init__(self):11        self.table = pd.read_csv(csv_url)12        self._preprocess_table()13 14        self.table_header = '''15            <tr>16                <td width="30%">Name</td>17                <td width="70%">Description</td>18            </tr>'''19 20    def _preprocess_table(self) -> None:21        self.table['name_lowercase'] = self.table['Name'].str.lower()22 23        rows = []24        for row in self.table.itertuples():25            source = f'<a href="{row.URL}" target="_parent">{row.Name}</a>' if isinstance(26                row.URL, str) else '{row.Name}'27            row = f'''28                <tr>29                    <td>{source}</td>30                    <td>{row.Description}</td>31                </tr>'''32            rows.append(row)33        self.table['html_table_content'] = rows34 35    def render(self, search_query: str            36            ) -> tuple[int, str]:37        self.table = pd.read_csv(csv_url)38        self._preprocess_table()39 40        self.table_header = '''41            <tr>42                <td width="15%">Organization Name</td>43                <td width="85%">Organization Overview</td>44            </tr>'''45        df = self.table46        if search_query:47                df = df[df.name_lowercase.str.contains(search_query.lower())]48        result = self.to_html(df, self.table_header)49        return result50 51    @staticmethod52    def filter_table(df: pd.DataFrame, filter_names: list[str]) -> pd.DataFrame:53        df = df.loc[df.Type.isin(set(filter_names))]54        return df55 56    @staticmethod57    def to_html(df: pd.DataFrame, table_header: str) -> str:58        table_data = ''.join(df.html_table_content)59        html = f'''60        <table>61            {table_header}62            {table_data}63        </table>'''64        return html65 66 67data_list = DataList()68 69css = """70button.svelte-kqij2n{font-weight: bold !important;71background-color: #ebecf0;72color: black;73margin-left: 5px;}74#tlsnlbs{}75#mtcs{}76 77#mdls{}78#dts{}79.svelte-kqij2n .selected {80    background-color: black;81    color: white;82}83.app.svelte-182fdeq.svelte-182fdeq {84padding: 0 !important;85}86span.svelte-s1r2yt{font-weight: bold !important;87}88"""89with gr.Blocks(css=css) as demo:90        search_box = gr.Textbox( label='Search Name', placeholder='You can search for titles with regular expressions. e.g. (?<!sur)face',max_lines=1)91        search_button = gr.Button('Search')92        table = gr.HTML(show_label=False)93        demo.load(fn=data_list.render, inputs=[search_box,],outputs=[table,])94        search_box.submit(fn=data_list.render, inputs=[search_box,], outputs=[table,])95        search_button.click(fn=data_list.render, inputs=[search_box,], outputs=[table,])    96 97demo.queue()98demo.launch(share=False)99