DREF-NLP does not find related appeal PDF-s about dref-nlp HOT 7 CLOSED

import requests
import pandas as pd

def download_api_results(call='appeal'):
    href = "https://goadmin.ifrc.org/api/v2/"+call+"/?format=json&limit=300000"
    aa = requests.get(href).json()
    return pd.DataFrame(aa['results'])

DREF_Final_Report_names = [
    'DREF Operation Final Report',
    'DREF Final Report',
    'DREF Operation Final Report 1'
]

# Filter only relevant DREF reports. Ignore case. 
def filter_DREF_Final_Reports(df, names=DREF_Final_Report_names):
    names_lower = [name.lower() for name in names]
    return df[df.name.apply(lambda x: x.lower() in names_lower)].copy().reset_index(drop=True)


appeal_df = download_api_results(call='appeal')
raw_apdo = download_api_results(call='appeal_document')
apdo = filter_DREF_Final_Reports(raw_apdo)

merged = appeal_df.merge(apdo, left_on=appeal_df['id'].astype(int), right_on=apdo.appeal.str['id'])

def find(lead):
    url_list = merged[merged.code==lead].document_url
    if not url_list.empty:
        return url_list.values[0]

print(merged.code)
print(find('MDRGH018'))