1527. Patients With a Condition

Pandas

import pandas as pd


def find_patients(patients: pd.DataFrame) -> pd.DataFrame:
    return patients[patients['conditions'].str.match(r'(\bDIAB1|.+ DIAB1)')]

SQL

SELECT
    patient_id,
    patient_name,
    conditions
FROM Patients
WHERE conditions REGEXP '\\bDIAB1'