|
import streamlit as st |
|
import pandas as pd |
|
|
|
def show_single_table(result_df): |
|
|
|
if len(result_df) == 0: |
|
st.write("No resuolts found!") |
|
else: |
|
result_df = result_df.reset_index(drop=True) |
|
|
|
|
|
result_df["crs_3_code_list"] = result_df['crs_3_code'].str.split(";").apply(lambda x: x[:-1] if x else []) |
|
result_df["crs_5_code_list"] = result_df['crs_5_code'].str.split(";").apply(lambda x: x[:-1] if x else []) |
|
result_df["sdg_list"] = result_df['sgd_pred_code'].apply(lambda x: [x] if pd.notna(x) else []) |
|
result_df["flag"] = result_df['country'].apply(lambda x: f"https://flagicons.lipis.dev/flags/4x3/{x[:2].lower()}.svg" if pd.notna(x) else "https://flagicons.lipis.dev/flags/4x3/xx.svg") |
|
|
|
st.dataframe( |
|
result_df[["similarity", "iati_id", "title_main", "orga_abbreviation", "client", "description_main", "country", "flag", "sdg_list", "crs_3_code_list", "crs_5_code_list"]], |
|
use_container_width = True, |
|
height = 35 + 35 * len(result_df), |
|
column_config={ |
|
"similarity": st.column_config.TextColumn( |
|
"Similarity", |
|
help="similarity to selected project", |
|
disabled=True, |
|
width="small" |
|
), |
|
"iati_id": st.column_config.TextColumn( |
|
"IATI ID", |
|
help="IATI Project ID", |
|
disabled=True, |
|
width="small" |
|
), |
|
"orga_abbreviation": st.column_config.TextColumn( |
|
"Organization", |
|
help="If description not in English, description in other language provided", |
|
disabled=True, |
|
width="small" |
|
), |
|
"client": st.column_config.TextColumn( |
|
"Client", |
|
help="Client organization of customer", |
|
disabled=True, |
|
width="small" |
|
), |
|
"title_main": st.column_config.TextColumn( |
|
"Title", |
|
help="If title not in English, title in other language provided", |
|
disabled=True, |
|
width="large" |
|
), |
|
"description_main": st.column_config.TextColumn( |
|
"Description", |
|
help="If description not in English, description in other language provided", |
|
disabled=True, |
|
width="large" |
|
), |
|
"country": st.column_config.TextColumn( |
|
"Country", |
|
help="Country of project", |
|
disabled=True, |
|
width="small" |
|
), |
|
"flag": st.column_config.ImageColumn( |
|
"Flag", |
|
help="country flag", |
|
width="small" |
|
), |
|
"sdg_list": st.column_config.ListColumn( |
|
"SDG Prediction", |
|
help="Prediction of SDG's", |
|
width="small" |
|
), |
|
"crs_3_code_list": st.column_config.ListColumn( |
|
"CRS 3", |
|
help="CRS 3 code given by organization", |
|
width="small" |
|
), |
|
"crs_5_code_list": st.column_config.ListColumn( |
|
"CRS 5", |
|
help="CRS 5 code given by organization", |
|
width="small" |
|
), |
|
}, |
|
hide_index=True, |
|
) |
|
|
