pac-stats

PAC analytics toolkit for primary care (PCN) reporting.

Install

pip install pac-stats

Usage

from pac_stats import full_process

practice_one = pd.read_html(r"X:\File Path\PAC & MDT Master Search.html") # r"<File Path for practice report from EMIS>"
practice_one = practice_one[0] # get the dataframe from list created by read html
practice_one = practice_one[~practice_one.isnull().all(axis=1)] # remove null rows caused by confidential hidden patients
practice_one['Practice'] = 'Practice Name' # Practice Name or Abbreviation

practice_two = pd.read_html(r"X:\File Path\PAC & MDT Master Search.html") # r"<File Path for practice report from EMIS>"
practice_two = practice_one[0] # get the dataframe from list created by read html
practice_two = practice_one[~practice_one.isnull().all(axis=1)] # remove null rows caused by confidential hidden patients
practice_two['Practice'] = 'Practice Name' # Practice Name or Abbreviation

#repeat for each practice needed and add to reports list below
reports = [practice_one, practice_two]

icb, extended = full_process(
    reports=reports,
    pac_staff=pac_staff,
    export_path=r"C:\exports\output.xlsx"
)