Skip to content

meevans1/PortsmouthHospitalTrust

Repository files navigation

PortsmouthHospitalTrust

logo

The main example of NLP is in diagnosis/bedview_diagnosis.ipynb

Investigation into medicine patient safety events: patient_safety/

Investigation into diagnoses: diagnosis/

Investigation into helpdesk tickets: helpdesk_tickets/

Update results with new events

To update with new results you need access to the Datix SQL server at PHT with ApplicationIntent=ReadOnly; Ask the IT dev team for the server name.

  1. Download 32-bit Python 3.7 Anaconda from https://www.anaconda.com/distribution/ (you'll need permission to get this on a RICH client).

download_anaconda

  1. Download the SNOMED dictionary from https://download.nlm.nih.gov/umls/kss/IHTSDO20190731/SnomedCT_InternationalRF2_PRODUCTION_20190731T120000Z.zip (you'll need permission to get this on a RICH client). You'll need to create an account on UMLS.

create_account

  1. On this webpage, click on the green "Clone or download" text button, then the blue "Download ZIP" text button (you'll need permission on a RICH client).

download_git_zip

  1. Once Anaconda is installed, click on the Windows character, search for "jupyter" and click on "Jupyter notebook (Anaconda3)".

search_jup

  1. Once the GitHub ZIP has been downloaded, unzip it and move the folder to C://Users/your_username

move_folder

  1. Once the SNOMED ZIP has downloaded, unzip it and move the file sct2_Description_Snapshot-en_INT_20190731.txt to C://Users/your_username/PortsmouthHospitalTrust

  2. Open the webpage where Jupyter should've opened (e.g. Chrome).

open_jupyter

  1. Click on the .ipynb file you want to update, e.g. PortsmouthHospitalTrust/ --> patient_safety/ --> patient_medicine_events_over_time/ --> hour_of_patient_medicine_safety_events_at_QA.ipynb

navigate_to_ipynb

  1. Ask the IT dev team for the server name and database for the file you want to run. The server name starts with L_AAG. For the diagnosis folder you should ask for the old bedview server and database name. For the patient safety folder you should ask for the Datix server and database name.

navigate_to_ipynb

  1. Click Cell --> Run All to update results with the latest medicine patients safety events at QA.

RunAll

  1. If making a report, change the start date.

change_start_date

  1. The easiest option is to take screenshots of your new results to show off to your friends!