[Python] Making a Table using Python Language in Juptyer Notebook using Synthea created COVID...

I have a COVID-19 Synthea created dataset. I am trying to create a table for the TOP 10 conditions associated with COVID 19 patients who died and those who survived but am having trouble getting a proper output. Additionally, I want to do the same comparsion for covid_patient_conditions for COVID patients admitted to the hospital and those admitted to the ICU.

def condition_frequencies(patient_ids, conditions, exclude_diseases):
filtered_conditions = conditions[~conditions['DESCRIPTION'].isin(exclude_diseases)]
filtered_conditions = filtered_conditions[filtered_conditions['PATIENT'].isin(patient_ids)]
disease_counts = filtered_conditions.groupby(['CODE', 'DESCRIPTION']).size().reset_index(name='count')
ranked_diseases = disease_counts.sort_values(by='count', ascending=False).reset_index(drop=True)
top_10_diseases = ranked_diseases.head(10)
return top_10_diseases

exclude_diseases = ["COVID-19", "Suspected COVID-19"]

Continue reading...